From e47656deeba138bf0b4255898bbc60f6525fe7f3 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周一, 01 9月 2025 11:49:47 +0800
Subject: [PATCH] 增加表数据插入
---
wcs/yunneiWCS/yunneiWCS/ORM/Wms_outInStockRecord_V2_Mes.cs | 1
wcs/yunneiWCS/yunneiWCS/yunneiWCS.csproj | 3 +
wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs | 6 +
wcs/yunneiWCS/yunneiWCS/ORM/dbmodel.cs | 27 +++++++++
sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql | 73 ++++++++++++++++++++++++
wcs/yunneiWCS/yunneiWCS/ORM/Wms_outInStockRecord_Details_V2_Mes.cs | 14 ++++
6 files changed, 122 insertions(+), 2 deletions(-)
diff --git a/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql b/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql
index 2406f62..5532899 100644
--- a/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql
+++ b/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql
@@ -178,3 +178,76 @@
)
GO
+
+
+
+/*==============================================================*/
+/* Table: Wms_outInStockRecord_V2_Mes */
+/* Description: 鍑哄叆搴撹褰�(涓烘帹閫丮ES) */
+/* Author:shaocx */
+/* CreateTime:2025-09-01 */
+/*==============================================================*/
+IF NOT EXISTS( SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('Wms_outInStockRecord_V2_Mes') AND TYPE = 'U')
+create table Wms_outInStockRecord_V2_Mes(
+ ID bigint NOT NULL, -- 涓婚敭
+
+ outInFlag int ,--- 鍑哄叆搴撶被鍨� 1 鍏ュ簱 2 鍑哄簱
+ outInFlagName VARCHAR(100) ,--- 鍑哄叆搴撶被鍨� 1 鍏ュ簱 2 鍑哄簱
+
+ taskId NVARCHAR(128) NULL , -- 浠诲姟ID
+ taskType int NULL , -- 浠诲姟绫诲瀷
+ taskTypeName NVARCHAR(128) NULL , -- 浠诲姟绫诲瀷
+ taskName NVARCHAR(128) NULL , -- 浠诲姟绫诲瀷
+
+ sourcePlace NVARCHAR(128) NULL , -- 璧风偣
+ toPlace NVARCHAR(128) NULL , -- 鐩爣鐐�
+
+ materialCode VARCHAR(100) NULL , -- 鐗╂枡缂栫爜
+ materialName NVARCHAR(100) NULL , -- 鐗╂枡鍚嶇О
+ version NVARCHAR(100) NULL , -- 鏈哄瀷
+ supplier NVARCHAR(100) NULL , -- 渚涘簲鍟�
+ containerCode NVARCHAR(100) NULL , -- 鎵樼洏鍙�
+ qty int NULL , -- 鏁伴噺
+
+ isSendToMes int NULL , -- 鏄惁鎺ㄧ粰MES
+ SendToMesTime datetime null, -- 鎺ㄧ粰MES鏃堕棿
+ MesRet NVARCHAR(128) NULL , -- MES杩斿洖缁撴灉
+
+
+ Remark NVARCHAR(128) NULL , -- 澶囨敞
+ Creator varchar(128) null,-- 鍒涘缓浜�
+ CreateTime datetime null, -- 鍒涘缓鏃堕棿
+ LastModifier varchar(128) null,-- 淇敼浜�
+ LastModifyTime datetime null -- 淇敼鏃堕棿
+
+ constraint PK_Wms_outInStockRecord_V2_Mes primary key (ID)
+)
+GO
+
+
+/*==============================================================*/
+/* Table: Wms_outInStockRecord_V2_Mes */
+/* Description: 鍑哄叆搴撹褰曟槑缁�(涓烘帹閫丮ES) */
+/* Author:shaocx */
+/* CreateTime:2025-09-01 */
+/*==============================================================*/
+IF NOT EXISTS( SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('Wms_outInStockRecord_Details_V2_Mes') AND TYPE = 'U')
+create table Wms_outInStockRecord_Details_V2_Mes(
+ ID bigint NOT NULL, -- 涓婚敭
+
+ mainId bigint ,--- Wms_outInStockRecord_V2_Mes琛ㄧ殑ID
+
+ productCode VARCHAR(100) NULL , -- 浜у搧缂栫爜
+ productName NVARCHAR(100) NULL , -- 浜у搧鍚嶇О
+ serialNumber NVARCHAR(100) NULL , -- 娴佹按鍙�
+
+
+ Remark NVARCHAR(128) NULL , -- 澶囨敞
+ Creator varchar(128) null,-- 鍒涘缓浜�
+ CreateTime datetime null, -- 鍒涘缓鏃堕棿
+ LastModifier varchar(128) null,-- 淇敼浜�
+ LastModifyTime datetime null -- 淇敼鏃堕棿
+
+ constraint PK_Wms_outInStockRecord_Details_V2_Mes primary key (ID)
+)
+GO
diff --git a/wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs b/wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs
index 2fc7319..1cf7c41 100644
--- a/wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs
+++ b/wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs
@@ -85,7 +85,8 @@
mainId = log.ID,
productCode = item.productCode,
productName = item.productName,
- serialNumber = item.serialNumber
+ serialNumber = item.serialNumber,
+ CreateTime = DateTime.Now
};
mod.Wms_outInStockRecord_Details_V2_Mes.Add(wms_OutInStockRecord_Details_V2_Mes);
}
@@ -151,7 +152,8 @@
mainId = log.ID,
productCode = item.productCode,
productName = item.productName,
- serialNumber = item.serialNumber
+ serialNumber = item.serialNumber,
+ CreateTime = DateTime.Now
};
mod.Wms_outInStockRecord_Details_V2_Mes.Add(wms_OutInStockRecord_Details_V2_Mes);
}
diff --git a/wcs/yunneiWCS/yunneiWCS/ORM/Wms_outInStockRecord_Details_V2_Mes.cs b/wcs/yunneiWCS/yunneiWCS/ORM/Wms_outInStockRecord_Details_V2_Mes.cs
index 80dc544..ed03b61 100644
--- a/wcs/yunneiWCS/yunneiWCS/ORM/Wms_outInStockRecord_Details_V2_Mes.cs
+++ b/wcs/yunneiWCS/yunneiWCS/ORM/Wms_outInStockRecord_Details_V2_Mes.cs
@@ -9,6 +9,7 @@
[Table("Wms_outInStockRecord_Details_V2_Mes")]
public partial class Wms_outInStockRecord_Details_V2_Mes
{
+ [DatabaseGenerated(DatabaseGeneratedOption.None)]
public long ID { get; set; }
public long? mainId { get; set; }
@@ -21,5 +22,18 @@
[StringLength(50)]
public string serialNumber { get; set; }
+
+ [StringLength(128)]
+ public string Remark { get; set; }
+
+ [StringLength(128)]
+ public string Creator { get; set; }
+
+ public DateTime? CreateTime { get; set; }
+
+ [StringLength(128)]
+ public string LastModifier { get; set; }
+
+ public DateTime? LastModifyTime { get; set; }
}
}
diff --git a/wcs/yunneiWCS/yunneiWCS/ORM/Wms_outInStockRecord_V2_Mes.cs b/wcs/yunneiWCS/yunneiWCS/ORM/Wms_outInStockRecord_V2_Mes.cs
index e2f80a9..0a875ca 100644
--- a/wcs/yunneiWCS/yunneiWCS/ORM/Wms_outInStockRecord_V2_Mes.cs
+++ b/wcs/yunneiWCS/yunneiWCS/ORM/Wms_outInStockRecord_V2_Mes.cs
@@ -8,6 +8,7 @@
public partial class Wms_outInStockRecord_V2_Mes
{
+ [DatabaseGenerated(DatabaseGeneratedOption.None)]
public long ID { get; set; }
public int? outInFlag { get; set; }
diff --git a/wcs/yunneiWCS/yunneiWCS/ORM/dbmodel.cs b/wcs/yunneiWCS/yunneiWCS/ORM/dbmodel.cs
index c3e41ba..735ac14 100644
--- a/wcs/yunneiWCS/yunneiWCS/ORM/dbmodel.cs
+++ b/wcs/yunneiWCS/yunneiWCS/ORM/dbmodel.cs
@@ -45,6 +45,33 @@
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
+ modelBuilder.Entity<Wms_outInStockRecord_Details_V2_Mes>()
+ .Property(e => e.productCode)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_Details_V2_Mes>()
+ .Property(e => e.Creator)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_Details_V2_Mes>()
+ .Property(e => e.LastModifier)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
+ .Property(e => e.outInFlagName)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
+ .Property(e => e.materialCode)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
+ .Property(e => e.Creator)
+ .IsUnicode(false);
+
+ modelBuilder.Entity<Wms_outInStockRecord_V2_Mes>()
+ .Property(e => e.LastModifier)
+ .IsUnicode(false);
modelBuilder.Entity<BasicDataSet>()
.Property(e => e.BasicDataType)
.IsFixedLength()
diff --git a/wcs/yunneiWCS/yunneiWCS/yunneiWCS.csproj b/wcs/yunneiWCS/yunneiWCS/yunneiWCS.csproj
index 59d0450..5d0de2a 100644
--- a/wcs/yunneiWCS/yunneiWCS/yunneiWCS.csproj
+++ b/wcs/yunneiWCS/yunneiWCS/yunneiWCS.csproj
@@ -322,6 +322,9 @@
<ItemGroup>
<Content Include="IwareICO.ico" />
</ItemGroup>
+ <ItemGroup>
+ <Folder Include="Test_ORM\" />
+ </ItemGroup>
<Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
<!-- To modify your build process, add your task inside one of the targets below and uncomment it.
Other similar extension points exist, see Microsoft.Common.targets.
--
Gitblit v1.9.3