From eda0c8f74ce453b6e43f88fc92b1e651ce5b6095 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期四, 13 二月 2025 13:46:33 +0800
Subject: [PATCH] 1.条码表实体类型调整 2.条码库存表实体新增基础字段 3.期初入库新增入库人
---
entity/MesQmAql3.cs | 510 ++++++++++++++++++++++++++++++--------------------------
1 files changed, 275 insertions(+), 235 deletions(-)
diff --git a/entity/MesQmAql3.cs b/entity/MesQmAql3.cs
index 78cf8cc..c89ee73 100644
--- a/entity/MesQmAql3.cs
+++ b/entity/MesQmAql3.cs
@@ -1,239 +1,279 @@
锘縰sing SqlSugar;
-namespace NewPdaSqlServer.entity
+namespace NewPdaSqlServer.entity;
+
+/// <summary>
+/// AQL鎶芥牱鍩哄噯鎶芥牱鏂规
+/// </summary>
+[SugarTable("MES_QM_AQL3")]
+public class MesQmAql3
{
/// <summary>
- /// AQL鎶芥牱鍩哄噯鎶芥牱鏂规
- ///</summary>
- [SugarTable("MES_QM_AQL3")]
- public class MesQmAql3
- {
- /// <summary>
- ///
- /// 榛樿鍊�: (newid())
- ///</summary>
- [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
- public Guid Guid { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- ///</summary>
- [SugarColumn(ColumnName="CREATE_BY" )]
- public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓浜哄鍚�
- ///</summary>
- [SugarColumn(ColumnName="CREATE_NAME" )]
- public string CreateName { get; set; }
- /// <summary>
- /// 鍒涘缓鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName="CREATE_DATE" )]
- public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- ///</summary>
- [SugarColumn(ColumnName="LASTUPDATE_BY" )]
- public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏇存柊浜哄鍚�
- ///</summary>
- [SugarColumn(ColumnName="LASTUPDATE_NAME" )]
- public string LastupdateName { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- ///</summary>
- [SugarColumn(ColumnName="LASTUPDATE_DATE" )]
- public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 鏍锋湰澶у皬
- ///</summary>
- [SugarColumn(ColumnName="FSAMPLE_SIZE_WORD" )]
- public int? FsampleSizeWord { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.10
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_010" )]
- public int? Aql0010 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.15
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_015" )]
- public int? Aql0015 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.25
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_025" )]
- public int? Aql0025 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.40
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_040" )]
- public int? Aql0040 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.65
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_065" )]
- public int? Aql0065 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩1.0
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_100" )]
- public int? Aql0100 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩1.5
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_150" )]
- public int? Aql0150 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩2.5
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_250" )]
- public int? Aql0250 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩4.0
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_400" )]
- public int? Aql0400 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩6.5
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_650" )]
- public int? Aql0650 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩10
- ///</summary>
- [SugarColumn(ColumnName="AQL_1_000" )]
- public int? Aql1000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩15
- ///</summary>
- [SugarColumn(ColumnName="AQL_1_500" )]
- public int? Aql1500 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩25
- ///</summary>
- [SugarColumn(ColumnName="AQL_2_500" )]
- public int? Aql2500 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩40
- ///</summary>
- [SugarColumn(ColumnName="AQL_4_000" )]
- public int? Aql4000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩65
- ///</summary>
- [SugarColumn(ColumnName="AQL_6_500" )]
- public int? Aql6500 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩100
- ///</summary>
- [SugarColumn(ColumnName="AQL_10_000" )]
- public int? Aql10000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩150
- ///</summary>
- [SugarColumn(ColumnName="AQL_15_000" )]
- public int? Aql15000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩250
- ///</summary>
- [SugarColumn(ColumnName="AQL_25_000" )]
- public int? Aql25000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩400
- ///</summary>
- [SugarColumn(ColumnName="AQL_40_000" )]
- public int? Aql40000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩650
- ///</summary>
- [SugarColumn(ColumnName="AQL_65_000" )]
- public int? Aql65000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩1000
- ///</summary>
- [SugarColumn(ColumnName="AQL_100_000" )]
- public int? Aql100000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩1500
- ///</summary>
- [SugarColumn(ColumnName="AQL_150_000" )]
- public int? Aql150000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩2500
- ///</summary>
- [SugarColumn(ColumnName="AQL_250_000" )]
- public int? Aql250000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩4000
- ///</summary>
- [SugarColumn(ColumnName="AQL_400_000" )]
- public int? Aql400000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩6500
- ///</summary>
- [SugarColumn(ColumnName="AQL_650_000" )]
- public int? Aql650000 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩10000
- ///</summary>
- [SugarColumn(ColumnName="AQL_1000_000" )]
- public int? Aql1000000 { get; set; }
- /// <summary>
- /// 澶囨敞
- ///</summary>
- [SugarColumn(ColumnName="MEMO" )]
- public string Memo { get; set; }
- /// <summary>
- /// 鏍锋湰澶у皬瀛楃爜
- ///</summary>
- [SugarColumn(ColumnName="SAMPLE_SIZE_WORD" )]
- public string SampleSizeWord { get; set; }
- /// <summary>
- /// 淇敼/ 鏂板鐘舵��
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName="EDIT_STATUS" )]
- public byte? EditStatus { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.010
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_0010" )]
- public int? Aql00010 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.015
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_0015" )]
- public int? Aql00015 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.025
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_0025" )]
- public int? Aql00025 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.040
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_0040" )]
- public int? Aql00040 { get; set; }
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.065
- ///</summary>
- [SugarColumn(ColumnName="AQL_0_0065" )]
- public int? Aql00065 { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName="COMPANY" )]
- public string Company { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName="FACTORY" )]
- public string Factory { get; set; }
- /// <summary>
- /// AQL鎶芥牱鍩哄噯ID
- ///</summary>
- [SugarColumn(ColumnName="AQL1_ID" )]
- public Guid? Aql1Id { get; set; }
- }
-}
+ /// 榛樿鍊�: (newid())
+ /// </summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
+ public string CreateBy { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓浜哄鍚�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_NAME")]
+ public string CreateName { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+ public DateTime? CreateDate { get; set; }
+
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ public string LastupdateBy { get; set; }
+
+ /// <summary>
+ /// 鏇存柊浜哄鍚�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_NAME")]
+ public string LastupdateName { get; set; }
+
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ public DateTime? LastupdateDate { get; set; }
+
+ /// <summary>
+ /// 鏍锋湰澶у皬
+ /// </summary>
+ [SugarColumn(ColumnName = "FSAMPLE_SIZE_WORD")]
+ public int? FsampleSizeWord { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.10
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_010")]
+ public int? Aql0010 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.15
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_015")]
+ public int? Aql0015 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.25
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_025")]
+ public int? Aql0025 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.40
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_040")]
+ public int? Aql0040 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.65
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_065")]
+ public int? Aql0065 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩1.0
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_100")]
+ public int? Aql0100 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩1.5
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_150")]
+ public int? Aql0150 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩2.5
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_250")]
+ public int? Aql0250 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩4.0
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_400")]
+ public int? Aql0400 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩6.5
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_650")]
+ public int? Aql0650 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩10
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_1_000")]
+ public int? Aql1000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩15
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_1_500")]
+ public int? Aql1500 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩25
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_2_500")]
+ public int? Aql2500 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩40
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_4_000")]
+ public int? Aql4000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩65
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_6_500")]
+ public int? Aql6500 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩100
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_10_000")]
+ public int? Aql10000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩150
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_15_000")]
+ public int? Aql15000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩250
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_25_000")]
+ public int? Aql25000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩400
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_40_000")]
+ public int? Aql40000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩650
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_65_000")]
+ public int? Aql65000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩1000
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_100_000")]
+ public int? Aql100000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩1500
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_150_000")]
+ public int? Aql150000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩2500
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_250_000")]
+ public int? Aql250000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩4000
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_400_000")]
+ public int? Aql400000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩6500
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_650_000")]
+ public int? Aql650000 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩10000
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_1000_000")]
+ public int? Aql1000000 { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "MEMO")]
+ public string Memo { get; set; }
+
+ /// <summary>
+ /// 鏍锋湰澶у皬瀛楃爜
+ /// </summary>
+ [SugarColumn(ColumnName = "SAMPLE_SIZE_WORD")]
+ public string SampleSizeWord { get; set; }
+
+ /// <summary>
+ /// 淇敼/ 鏂板鐘舵��
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "EDIT_STATUS")]
+ public byte? EditStatus { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.010
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_0010")]
+ public int? Aql00010 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.015
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_0015")]
+ public int? Aql00015 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.025
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_0025")]
+ public int? Aql00025 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.040
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_0040")]
+ public int? Aql00040 { get; set; }
+
+ /// <summary>
+ /// 鎺ユ敹璐ㄩ噺姘村钩0.065
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL_0_0065")]
+ public int? Aql00065 { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+ public string Company { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+ public string Factory { get; set; }
+
+ /// <summary>
+ /// AQL鎶芥牱鍩哄噯ID
+ /// </summary>
+ [SugarColumn(ColumnName = "AQL1_ID")]
+ public Guid? Aql1Id { get; set; }
+}
\ No newline at end of file
--
Gitblit v1.9.3