From f862d5003ac180b79cd14478fd17dba1b4b28a82 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期三, 12 三月 2025 08:19:13 +0800
Subject: [PATCH] 1.采购入库优化 2.生产领料优化 3.生产不补料优化

---
 entity/MesQmCheckitemDt.cs |  475 +++++++++++++++++++++++++++++++---------------------------
 1 files changed, 255 insertions(+), 220 deletions(-)

diff --git a/entity/MesQmCheckitemDt.cs b/entity/MesQmCheckitemDt.cs
index 90805c2..e4a84d5 100644
--- a/entity/MesQmCheckitemDt.cs
+++ b/entity/MesQmCheckitemDt.cs
@@ -1,224 +1,259 @@
 锘縰sing SqlSugar;
 
-namespace NewPdaSqlServer.entity
+namespace NewPdaSqlServer.entity;
+
+/// <summary>
+///     妫�楠岄」鐩粠琛�
+/// </summary>
+[SugarTable("MES_QM_CHECKITEM_DT")]
+public class MesQmCheckitemDt
 {
     /// <summary>
-    /// 妫�楠岄」鐩粠琛�
-    ///</summary>
-    [SugarTable("MES_QM_CHECKITEM_DT")]
-    public class MesQmCheckitemDt
-    {
-        /// <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_DATE"    )]
-         public DateTime? CreateDate { get; set; }
-        /// <summary>
-        /// 鏈�鍚庢洿鏂颁汉 
-        ///</summary>
-         [SugarColumn(ColumnName="LASTUPDATE_BY"    )]
-         public string LastupdateBy { get; set; }
-        /// <summary>
-        /// 鏈�鍚庢洿鏂版椂闂� 
-        ///</summary>
-         [SugarColumn(ColumnName="LASTUPDATE_DATE"    )]
-         public DateTime? LastupdateDate { get; set; }
-        /// <summary>
-        /// 澶囨敞 
-        ///</summary>
-         [SugarColumn(ColumnName="MEMO"    )]
-         public string Memo { get; set; }
-        /// <summary>
-        /// 鐗╂枡浜у搧缂栫爜 
-        ///</summary>
-         [SugarColumn(ColumnName="ITEM_NO"    )]
-         public string ItemNo { get; set; }
-        /// <summary>
-        /// 椤哄簭 
-        ///</summary>
-         [SugarColumn(ColumnName="FORDER"    )]
-         public long? Forder { get; set; }
-        /// <summary>
-        /// 涓婂叕宸� 
-        ///</summary>
-         [SugarColumn(ColumnName="FUP_ALLOW"    )]
-         public string FupAllow { get; set; }
-        /// <summary>
-        /// 妫�楠岄」鐩� 
-        ///</summary>
-         [SugarColumn(ColumnName="FCHECK_ITEM"    )]
-         public string FcheckItem { get; set; }
-        /// <summary>
-        /// 鐗规畩鐗规�х被鍒� 
-        ///</summary>
-         [SugarColumn(ColumnName="FSPEC_TYPE"    )]
-         public string FspecType { get; set; }
-        /// <summary>
-        /// 澶囩敤 
-        ///</summary>
-         [SugarColumn(ColumnName="WORKSHOP_CENTER_CODE"    )]
-         public long? WorkshopCenterCode { get; set; }
-        /// <summary>
-        /// 宸ュ簭 
-        ///</summary>
-         [SugarColumn(ColumnName="PROC_NO"    )]
-         public string ProcNo { get; set; }
-        /// <summary>
-        /// 妫�楠屾按鍑嗙紪鐮� 
-        ///</summary>
-         [SugarColumn(ColumnName="SAMPLE_SIZE_NO"    )]
-         public string SampleSizeNo { get; set; }
-        /// <summary>
-        /// 妫�楠屽伐鍏� 
-        ///</summary>
-         [SugarColumn(ColumnName="FCHECK_TOOL"    )]
-         public string FcheckTool { get; set; }
-        /// <summary>
-        /// 涓嬪叕宸� 
-        ///</summary>
-         [SugarColumn(ColumnName="FDOWN_ALLOW"    )]
-         public string FdownAllow { get; set; }
-        /// <summary>
-        /// 妫�楠屾按骞� 
-        ///</summary>
-         [SugarColumn(ColumnName="FCHECK_LEVEL"    )]
-         public string FcheckLevel { get; set; }
-        /// <summary>
-        /// 鏍囧噯鍊� 
-        ///</summary>
-         [SugarColumn(ColumnName="FSTAND"    )]
-         public string Fstand { get; set; }
-        /// <summary>
-        /// 鎺ユ敹姘村钩 
-        ///</summary>
-         [SugarColumn(ColumnName="FAC_LEVEL"    )]
-         public string FacLevel { get; set; }
-        /// <summary>
-        /// 澶囩敤 
-        ///</summary>
-         [SugarColumn(ColumnName="FEATU_PROC"    )]
-         public string FeatuProc { get; set; }
-        /// <summary>
-        /// 澶囩敤 
-        ///</summary>
-         [SugarColumn(ColumnName="FEATU_PROD"    )]
-         public string FeatuProd { get; set; }
-        /// <summary>
-        /// 澶囩敤 
-        ///</summary>
-         [SugarColumn(ColumnName="AQL1_ID"    )]
-         public string Aql1Id { get; set; }
-        /// <summary>
-        /// 澶囩敤 
-        ///</summary>
-         [SugarColumn(ColumnName="FQA_TYPE"    )]
-         public string FqaType { get; set; }
-        /// <summary>
-        /// 鏄惁妗ｄ綅 
-        /// 榛樿鍊�: ((0))
-        ///</summary>
-         [SugarColumn(ColumnName="ISDANWEI"    )]
-         public bool? Isdanwei { get; set; }
-        /// <summary>
-        /// 榛樿鐢ㄤ簬鍦ㄥ簱閲嶆 
-        /// 榛樿鍊�: ((1))
-        ///</summary>
-         [SugarColumn(ColumnName="FTYPE"    )]
-         public long? Ftype { get; set; }
-        /// <summary>
-        /// 淇敼/ 鏂板鐘舵�� 
-        /// 榛樿鍊�: ((0))
-        ///</summary>
-         [SugarColumn(ColumnName="EDIT_STATUS"    )]
-         public bool? EditStatus { get; set; }
-        /// <summary>
-        /// 鎶芥鏁伴噺 
-        ///</summary>
-         [SugarColumn(ColumnName="CHECK_QTY"    )]
-         public long? CheckQty { get; set; }
-        /// <summary>
-        /// 鍏佹敹鏁伴噺 
-        /// 榛樿鍊�: ((0))
-        ///</summary>
-         [SugarColumn(ColumnName="FAC_QTY"    )]
-         public long? FacQty { get; set; }
-        /// <summary>
-        ///  
-        ///</summary>
-         [SugarColumn(ColumnName="COMPANY"    )]
-         public string Company { get; set; }
-        /// <summary>
-        ///  
-        ///</summary>
-         [SugarColumn(ColumnName="FACTORY"    )]
-         public string Factory { get; set; }
-        /// <summary>
-        /// 棰戞 
-        ///</summary>
-         [SugarColumn(ColumnName="FREQUENCY"    )]
-         public string Frequency { get; set; }
-        /// <summary>
-        /// 瑙勬牸瑕佹眰 
-        ///</summary>
-         [SugarColumn(ColumnName="FSPEC_REQU"    )]
-         public string FspecRequ { get; set; }
-        /// <summary>
-        /// 椤圭洰绫诲埆 
-        ///</summary>
-         [SugarColumn(ColumnName="FCHECK_TYPE"    )]
-         public string FcheckType { get; set; }
-        /// <summary>
-        /// 鍗曚綅 
-        ///</summary>
-         [SugarColumn(ColumnName="FUNIT"    )]
-         public string Funit { get; set; }
-        /// <summary>
-        /// 鎶ヨ〃閫夋嫨 
-        /// 榛樿鍊�: ((0))
-        ///</summary>
-         [SugarColumn(ColumnName="REPORF_CHECK"    )]
-         public bool? ReporfCheck { get; set; }
-        /// <summary>
-        /// 鐗瑰畾淇敼 
-        /// 榛樿鍊�: ((0))
-        ///</summary>
-         [SugarColumn(ColumnName="GIVEN_MODIFY"    )]
-         public bool? GivenModify { get; set; }
-        /// <summary>
-        /// UCL_X璁惧畾鍊� 
-        ///</summary>
-         [SugarColumn(ColumnName="FUCL"    )]
-         public decimal? Fucl { get; set; }
-        /// <summary>
-        /// LCL_X璁惧畾鍊� 
-        ///</summary>
-         [SugarColumn(ColumnName="FLCL"    )]
-         public decimal? Flcl { get; set; }
-        /// <summary>
-        /// UCL_R璁惧畾鍊� 
-        ///</summary>
-         [SugarColumn(ColumnName="FRUCL"    )]
-         public decimal? Frucl { get; set; }
-        /// <summary>
-        /// 鐗╂枡ID 
-        ///</summary>
-         [SugarColumn(ColumnName="ITEM_ID"    )]
-         public long? ItemId { get; set; }
-        /// <summary>
-        ///  
-        ///</summary>
-         [SugarColumn(ColumnName="pid"    )]
-         public Guid? Pid { 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_DATE")]
+    public DateTime? CreateDate { get; set; }
+
+    /// <summary>
+    ///     鏈�鍚庢洿鏂颁汉
+    /// </summary>
+    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+    public string LastupdateBy { get; set; }
+
+    /// <summary>
+    ///     鏈�鍚庢洿鏂版椂闂�
+    /// </summary>
+    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+    public DateTime? LastupdateDate { get; set; }
+
+    /// <summary>
+    ///     澶囨敞
+    /// </summary>
+    [SugarColumn(ColumnName = "MEMO")]
+    public string Memo { get; set; }
+
+    /// <summary>
+    ///     鐗╂枡浜у搧缂栫爜
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_NO")]
+    public string ItemNo { get; set; }
+
+    /// <summary>
+    ///     椤哄簭
+    /// </summary>
+    [SugarColumn(ColumnName = "FORDER")]
+    public long? Forder { get; set; }
+
+    /// <summary>
+    ///     涓婂叕宸�
+    /// </summary>
+    [SugarColumn(ColumnName = "FUP_ALLOW")]
+    public string FupAllow { get; set; }
+
+    /// <summary>
+    ///     妫�楠岄」鐩�
+    /// </summary>
+    [SugarColumn(ColumnName = "FCHECK_ITEM")]
+    public string FcheckItem { get; set; }
+
+    /// <summary>
+    ///     鐗规畩鐗规�х被鍒�
+    /// </summary>
+    [SugarColumn(ColumnName = "FSPEC_TYPE")]
+    public string FspecType { get; set; }
+
+    /// <summary>
+    ///     澶囩敤
+    /// </summary>
+    [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
+    public long? WorkshopCenterCode { get; set; }
+
+    /// <summary>
+    ///     宸ュ簭
+    /// </summary>
+    [SugarColumn(ColumnName = "PROC_NO")]
+    public string ProcNo { get; set; }
+
+    /// <summary>
+    ///     妫�楠屾按鍑嗙紪鐮�
+    /// </summary>
+    [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
+    public string SampleSizeNo { get; set; }
+
+    /// <summary>
+    ///     妫�楠屽伐鍏�
+    /// </summary>
+    [SugarColumn(ColumnName = "FCHECK_TOOL")]
+    public string FcheckTool { get; set; }
+
+    /// <summary>
+    ///     涓嬪叕宸�
+    /// </summary>
+    [SugarColumn(ColumnName = "FDOWN_ALLOW")]
+    public string FdownAllow { get; set; }
+
+    /// <summary>
+    ///     妫�楠屾按骞�
+    /// </summary>
+    [SugarColumn(ColumnName = "FCHECK_LEVEL")]
+    public string FcheckLevel { get; set; }
+
+    /// <summary>
+    ///     鏍囧噯鍊�
+    /// </summary>
+    [SugarColumn(ColumnName = "FSTAND")]
+    public string Fstand { get; set; }
+
+    /// <summary>
+    ///     鎺ユ敹姘村钩
+    /// </summary>
+    [SugarColumn(ColumnName = "FAC_LEVEL")]
+    public string FacLevel { get; set; }
+
+    /// <summary>
+    ///     澶囩敤
+    /// </summary>
+    [SugarColumn(ColumnName = "FEATU_PROC")]
+    public string FeatuProc { get; set; }
+
+    /// <summary>
+    ///     澶囩敤
+    /// </summary>
+    [SugarColumn(ColumnName = "FEATU_PROD")]
+    public string FeatuProd { get; set; }
+
+    /// <summary>
+    ///     澶囩敤
+    /// </summary>
+    [SugarColumn(ColumnName = "AQL1_ID")]
+    public string Aql1Id { get; set; }
+
+    /// <summary>
+    ///     澶囩敤
+    /// </summary>
+    [SugarColumn(ColumnName = "FQA_TYPE")]
+    public string FqaType { get; set; }
+
+    /// <summary>
+    ///     鏄惁妗ｄ綅
+    ///     榛樿鍊�: ((0))
+    /// </summary>
+    [SugarColumn(ColumnName = "ISDANWEI")]
+    public bool? Isdanwei { get; set; }
+
+    /// <summary>
+    ///     榛樿鐢ㄤ簬鍦ㄥ簱閲嶆
+    ///     榛樿鍊�: ((1))
+    /// </summary>
+    [SugarColumn(ColumnName = "FTYPE")]
+    public long? Ftype { get; set; }
+
+    /// <summary>
+    ///     淇敼/ 鏂板鐘舵��
+    ///     榛樿鍊�: ((0))
+    /// </summary>
+    [SugarColumn(ColumnName = "EDIT_STATUS")]
+    public bool? EditStatus { get; set; }
+
+    /// <summary>
+    ///     鎶芥鏁伴噺
+    /// </summary>
+    [SugarColumn(ColumnName = "CHECK_QTY")]
+    public long? CheckQty { get; set; }
+
+    /// <summary>
+    ///     鍏佹敹鏁伴噺
+    ///     榛樿鍊�: ((0))
+    /// </summary>
+    [SugarColumn(ColumnName = "FAC_QTY")]
+    public long? FacQty { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "COMPANY")]
+    public string Company { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "FACTORY")]
+    public string Factory { get; set; }
+
+    /// <summary>
+    ///     棰戞
+    /// </summary>
+    [SugarColumn(ColumnName = "FREQUENCY")]
+    public string Frequency { get; set; }
+
+    /// <summary>
+    ///     瑙勬牸瑕佹眰
+    /// </summary>
+    [SugarColumn(ColumnName = "FSPEC_REQU")]
+    public string FspecRequ { get; set; }
+
+    /// <summary>
+    ///     椤圭洰绫诲埆
+    /// </summary>
+    [SugarColumn(ColumnName = "FCHECK_TYPE")]
+    public string FcheckType { get; set; }
+
+    /// <summary>
+    ///     鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "FUNIT")]
+    public string Funit { get; set; }
+
+    /// <summary>
+    ///     鎶ヨ〃閫夋嫨
+    ///     榛樿鍊�: ((0))
+    /// </summary>
+    [SugarColumn(ColumnName = "REPORF_CHECK")]
+    public bool? ReporfCheck { get; set; }
+
+    /// <summary>
+    ///     鐗瑰畾淇敼
+    ///     榛樿鍊�: ((0))
+    /// </summary>
+    [SugarColumn(ColumnName = "GIVEN_MODIFY")]
+    public bool? GivenModify { get; set; }
+
+    /// <summary>
+    ///     UCL_X璁惧畾鍊�
+    /// </summary>
+    [SugarColumn(ColumnName = "FUCL")]
+    public decimal? Fucl { get; set; }
+
+    /// <summary>
+    ///     LCL_X璁惧畾鍊�
+    /// </summary>
+    [SugarColumn(ColumnName = "FLCL")]
+    public decimal? Flcl { get; set; }
+
+    /// <summary>
+    ///     UCL_R璁惧畾鍊�
+    /// </summary>
+    [SugarColumn(ColumnName = "FRUCL")]
+    public decimal? Frucl { get; set; }
+
+    /// <summary>
+    ///     鐗╂枡ID
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_ID")]
+    public long? ItemId { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "pid")]
+    public Guid? Pid { get; set; }
+}
\ No newline at end of file

--
Gitblit v1.9.3