From cee4e362c81af4c93c87f40e77649e9af5a591c6 Mon Sep 17 00:00:00 2001
From: zyf <1071160500@qq.com>
Date: 星期一, 02 六月 2025 20:05:54 +0800
Subject: [PATCH] 修改工单生产数量更新的逻辑，现在只有检验合格的才更新生产数量，清除检验合格的结果也会更新

---
 MES.Service/Modes/MesInvItemIns.cs |  207 ++++++++++++++++++++++++++-------------------------
 1 files changed, 107 insertions(+), 100 deletions(-)

diff --git a/MES.Service/Modes/MesInvItemIns.cs b/MES.Service/Modes/MesInvItemIns.cs
index b38b2cd..a65fee7 100644
--- a/MES.Service/Modes/MesInvItemIns.cs
+++ b/MES.Service/Modes/MesInvItemIns.cs
@@ -11,303 +11,310 @@
     /// <summary>
     ///     ID(SEQ_INV_ID)
     /// </summary>
-    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
+        IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
     /// <summary>
-    ///     鍏ュ簱鍗曞彿
-    /// </summary>
+    /// 鍏ュ簱鍗曞彿 
+    ///</summary>
     [SugarColumn(ColumnName = "BILL_NO")]
     public string BillNo { get; set; }
 
     /// <summary>
-    ///     鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
-    /// </summary>
+    /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴 
+    ///</summary>
     [SugarColumn(ColumnName = "STATUS")]
     public short? Status { get; set; }
 
     /// <summary>
-    ///     浠撳簱
-    /// </summary>
+    /// 浠撳簱 
+    ///</summary>
     [SugarColumn(ColumnName = "DEPOTS_ID")]
     public decimal? DepotsId { get; set; }
 
     /// <summary>
-    ///     鍘熷洜
-    /// </summary>
+    /// 鍘熷洜 
+    ///</summary>
     [SugarColumn(ColumnName = "REASON")]
     public string Reason { get; set; }
 
     /// <summary>
-    ///     鍒涘缓浜�
-    /// </summary>
+    /// 鍒涘缓浜� 
+    ///</summary>
     [SugarColumn(ColumnName = "CREATE_BY")]
     public string CreateBy { get; set; }
 
     /// <summary>
-    ///     鍒涘缓鏃堕棿
-    /// </summary>
+    /// 鍒涘缓鏃堕棿 
+    ///</summary>
     [SugarColumn(ColumnName = "CREATE_DATE")]
     public DateTime? CreateDate { get; set; }
 
     /// <summary>
-    ///     鏈�鍚庢洿鏂颁汉
-    /// </summary>
+    /// 鏈�鍚庢洿鏂颁汉 
+    ///</summary>
     [SugarColumn(ColumnName = "LASTUPDATE_BY")]
     public string LastupdateBy { get; set; }
 
     /// <summary>
-    ///     鏈�鍚庢洿鏂版椂闂�
-    /// </summary>
+    /// 鏈�鍚庢洿鏂版椂闂� 
+    ///</summary>
     [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
     public DateTime? LastupdateDate { get; set; }
 
     /// <summary>
-    ///     鍗曟嵁绫诲瀷ID
-    /// </summary>
+    /// 鍗曟嵁绫诲瀷ID 
+    ///</summary>
     [SugarColumn(ColumnName = "BILL_TYPE_ID")]
     public decimal? BillTypeId { get; set; }
 
     /// <summary>
-    ///     浜嬪姟绫诲瀷ID
-    /// </summary>
+    /// 浜嬪姟绫诲瀷ID 
+    ///</summary>
     [SugarColumn(ColumnName = "TRANSACTION_ID")]
     public decimal? TransactionId { get; set; }
 
     /// <summary>
-    ///     澶囨敞
-    /// </summary>
+    /// 澶囨敞 
+    ///</summary>
     [SugarColumn(ColumnName = "REMARK")]
     public string Remark { get; set; }
 
     /// <summary>
-    ///     閫佽揣鍗曞彿
-    /// </summary>
+    /// 閫佽揣鍗曞彿 
+    ///</summary>
     [SugarColumn(ColumnName = "PAPER_BILL_NO")]
     public string PaperBillNo { get; set; }
 
     /// <summary>
-    ///     閫�鏂欎汉宸ュ彿
-    /// </summary>
+    /// 閫�鏂欎汉宸ュ彿 
+    ///</summary>
     [SugarColumn(ColumnName = "USER_NO_BACK")]
     public string UserNoBack { get; set; }
 
     /// <summary>
-    ///     瀹℃牳浜�
-    /// </summary>
+    /// 瀹℃牳浜� 
+    ///</summary>
     [SugarColumn(ColumnName = "CHECK_USER")]
     public string CheckUser { get; set; }
 
     /// <summary>
-    ///     瀹℃牳鏃ユ湡
-    /// </summary>
+    /// 瀹℃牳鏃ユ湡 
+    ///</summary>
     [SugarColumn(ColumnName = "CHECK_DATE")]
     public DateTime? CheckDate { get; set; }
 
     /// <summary>
-    ///     鐢熶骇璁㈠崟鍙�
-    /// </summary>
+    /// 鐢熶骇璁㈠崟鍙� 
+    ///</summary>
     [SugarColumn(ColumnName = "TASK_NO")]
     public string TaskNo { get; set; }
 
     /// <summary>
-    ///     鍏ュ簱鏃ユ湡
-    /// </summary>
+    /// 鍏ュ簱鏃ユ湡 
+    ///</summary>
     [SugarColumn(ColumnName = "INS_DATE")]
     public DateTime? InsDate { get; set; }
 
     /// <summary>
-    ///     妫�楠岀粨鏋�
-    /// </summary>
+    /// 妫�楠岀粨鏋� 
+    ///</summary>
     [SugarColumn(ColumnName = "CHECK_RES")]
     public string CheckRes { get; set; }
 
     /// <summary>
-    ///     宸叉崱鏁伴噺
-    /// </summary>
+    /// 宸叉崱鏁伴噺 
+    ///</summary>
     [SugarColumn(ColumnName = "CHECK_QTY")]
     public decimal? CheckQty { get; set; }
 
     /// <summary>
-    ///     棰嗘枡宸ユ
-    /// </summary>
+    /// 棰嗘枡宸ユ 
+    ///</summary>
     [SugarColumn(ColumnName = "MMLIST")]
     public string Mmlist { get; set; }
 
     /// <summary>
-    ///     SAP閲囪喘璁㈠崟鍙�
-    /// </summary>
+    /// SAP閲囪喘璁㈠崟鍙� 
+    ///</summary>
     [SugarColumn(ColumnName = "EBELN")]
     public string Ebeln { get; set; }
 
     /// <summary>
-    ///     浠撳簱缂栫爜
-    /// </summary>
+    /// 浠撳簱缂栫爜 
+    ///</summary>
     [SugarColumn(ColumnName = "DEPOTS_CODE")]
     public string DepotsCode { get; set; }
 
     /// <summary>
-    ///     浜嬪姟绫诲瀷缂栫爜
-    /// </summary>
+    /// 浜嬪姟绫诲瀷缂栫爜 
+    ///</summary>
     [SugarColumn(ColumnName = "TRANSCTION_NO")]
     public string TransctionNo { get; set; }
 
     /// <summary>
-    ///     渚涘簲鍟嗙紪鐮�
-    /// </summary>
+    /// 渚涘簲鍟嗙紪鐮� 
+    ///</summary>
     [SugarColumn(ColumnName = "SUPP_NO")]
     public string SuppNo { get; set; }
 
     /// <summary>
-    ///     鍏ュ簱鐘舵��
-    /// </summary>
+    /// 鍏ュ簱鐘舵�� 
+    ///</summary>
     [SugarColumn(ColumnName = "FSTATUS")]
     public short? Fstatus { get; set; }
 
     /// <summary>
-    ///     宸ュ巶缂栫爜
-    /// </summary>
+    /// 宸ュ巶缂栫爜 
+    ///</summary>
     [SugarColumn(ColumnName = "FACTORY")]
     public string Factory { get; set; }
 
     /// <summary>
-    ///     鏄惁宸插洖鍐橲AP
-    /// </summary>
+    /// 鏄惁宸插洖鍐橲AP 
+    ///</summary>
     [SugarColumn(ColumnName = "SAPSTATUS")]
     public short? Sapstatus { get; set; }
 
     /// <summary>
-    ///     SAP杩斿洖鍗曟嵁
-    /// </summary>
+    /// SAP杩斿洖鍗曟嵁 
+    ///</summary>
     [SugarColumn(ColumnName = "SAPNO")]
     public string Sapno { get; set; }
 
     /// <summary>
-    ///     SAP杩斿洖骞翠唤
-    /// </summary>
+    /// SAP杩斿洖骞翠唤 
+    ///</summary>
     [SugarColumn(ColumnName = "SAPYEAR")]
     public short? Sapyear { get; set; }
 
     /// <summary>
-    ///     SAP杩斿洖淇℃伅
-    /// </summary>
+    /// SAP杩斿洖淇℃伅 
+    ///</summary>
     [SugarColumn(ColumnName = "SAPTEXT")]
     public string Saptext { get; set; }
 
     /// <summary>
-    ///     纭鍏ュ簱鏃ユ湡
-    /// </summary>
+    /// 纭鍏ュ簱鏃ユ湡 
+    ///</summary>
     [SugarColumn(ColumnName = "INSDATE")]
-    public DateTime? InsdateA { get; set; }
+    public DateTime? Insdate { get; set; }
 
     /// <summary>
-    ///     鏄惁妫�楠�
-    /// </summary>
+    /// 鏄惁妫�楠� 
+    ///</summary>
     [SugarColumn(ColumnName = "ISCHECK")]
     public decimal? Ischeck { get; set; }
 
     /// <summary>
-    ///     瀹℃牳鍏ュ簱浜�
-    /// </summary>
+    /// 瀹℃牳鍏ュ簱浜� 
+    ///</summary>
     [SugarColumn(ColumnName = "INSBY")]
     public string Insby { get; set; }
 
     /// <summary>
-    ///     鏄惁鏄剧ず
-    /// </summary>
+    /// 鏄惁鏄剧ず 
+    ///</summary>
     [SugarColumn(ColumnName = "IS_VISUAL")]
     public decimal? IsVisual { get; set; }
 
     /// <summary>
-    ///     鍏徃浠ｇ爜
-    /// </summary>
+    /// 鍏徃浠ｇ爜 
+    ///</summary>
     [SugarColumn(ColumnName = "COMPANY")]
     public string Company { get; set; }
 
     /// <summary>
-    ///     鎬ユ枡鏍囪瘑
-    /// </summary>
+    /// 鎬ユ枡鏍囪瘑 
+    ///</summary>
     [SugarColumn(ColumnName = "URGENT_FLAG")]
     public short? UrgentFlag { get; set; }
 
     /// <summary>
-    ///     閲囪喘鍗曡鍙�
-    /// </summary>
+    /// 閲囪喘鍗曡鍙� 
+    ///</summary>
     [SugarColumn(ColumnName = "LINE_NO")]
     public string LineNo { get; set; }
 
     /// <summary>
-    ///     鍐查攢浜嬪姟绫诲瀷缂栫爜
-    /// </summary>
+    /// 鍐查攢浜嬪姟绫诲瀷缂栫爜 
+    ///</summary>
     [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
     public decimal? MttransctionNo { get; set; }
 
     /// <summary>
-    ///     宸ュ崟琛屽彿
-    /// </summary>
+    /// 宸ュ崟琛屽彿 
+    ///</summary>
     [SugarColumn(ColumnName = "TASK_LINO")]
     public string TaskLino { get; set; }
 
     /// <summary>
-    ///     鎶曟枡閫氱煡鍗曞崟鍙�
-    /// </summary>
+    /// 鎶曟枡閫氱煡鍗曞崟鍙� 
+    ///</summary>
     [SugarColumn(ColumnName = "FBILLNO")]
     public string Fbillno { get; set; }
 
     /// <summary>
-    ///     鎶曟枡鍗曡鍙�
-    /// </summary>
+    /// 鎶曟枡鍗曡鍙� 
+    ///</summary>
     [SugarColumn(ColumnName = "FBILL_LINO")]
     public string FbillLino { get; set; }
 
     /// <summary>
-    ///     瀹㈡埛缂栧彿
-    /// </summary>
+    /// 瀹㈡埛缂栧彿 
+    ///</summary>
     [SugarColumn(ColumnName = "CUST_NO")]
     public string CustNo { get; set; }
 
     /// <summary>
-    ///     瀹㈡埛鍚嶇О
-    /// </summary>
+    /// 瀹㈡埛鍚嶇О 
+    ///</summary>
     [SugarColumn(ColumnName = "CUST_NAME")]
     public string CustName { get; set; }
 
     /// <summary>
-    ///     IQC妫�楠屽崟鍙�
-    /// </summary>
+    /// IQC妫�楠屽崟鍙� 
+    ///</summary>
     [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
     public string IqcReleaseNo { get; set; }
 
     /// <summary>
-    ///     鍒拌揣鍗曞彿
-    /// </summary>
+    /// 鍒拌揣鍗曞彿 
+    ///</summary>
     [SugarColumn(ColumnName = "CBILL_NO")]
     public string CbillNo { get; set; }
 
     /// <summary>
-    ///     0 鐢宠鍗曪紝1鍏ュ簱鍗曟爣璇�
-    /// </summary>
+    /// 0 鐢宠鍗曪紝1鍏ュ簱鍗曟爣璇� 
+    ///</summary>
     [SugarColumn(ColumnName = "PICK_INS")]
     public decimal? PickIns { get; set; }
 
     /// <summary>
-    ///     鍏ュ簱瀹℃牳浜�
-    /// </summary>
+    /// 鍏ュ簱瀹℃牳浜� 
+    ///</summary>
     [SugarColumn(ColumnName = "FCHECK_USER")]
     public string FcheckUser { get; set; }
 
     /// <summary>
-    ///     鍏ュ簱瀹℃牳鏃ユ湡
-    /// </summary>
+    /// 鍏ュ簱瀹℃牳鏃ユ湡 
+    ///</summary>
     [SugarColumn(ColumnName = "FCHECK_DATE")]
     public DateTime? FcheckDate { get; set; }
 
     /// <summary>
-    ///     浠诲姟姹囨姤鍗�
-    /// </summary>
+    /// 浠诲姟姹囨姤鍗�/宸ュ崟鍙凤紙鎴愬搧鍏ュ簱锛� 
+    ///</summary>
     [SugarColumn(ColumnName = "RBILL_NO")]
     public string RbillNo { get; set; }
 
+    /// <summary>
+    /// 鎶ュ伐浜� 
+    ///</summary>
+    [SugarColumn(ColumnName = "BGR")]
+    public string Bgr { get; set; }
+
     //鍦ㄦ暟鎹簱鏌ヨ鏃跺拷鐣ヨ繖涓瓧娈�
     [SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
 

--
Gitblit v1.9.3