From 6bcfd2449dc18ad9455c365d18027663decf61e8 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 24 七月 2024 14:58:51 +0800
Subject: [PATCH] 完善仓库验退的逻辑

---
 MES.Service/service/Warehouse/PurdkbManager.cs                        |    1 
 MESApplication/bin/Release/net8.0/MESApplication.exe                  |    0 
 MESApplication/bin/Release/net8.0/publish/MESApplication.pdb          |    0 
 MESApplication/bin/Debug/net8.0/MES.Service.pdb                       |    0 
 MESApplication/bin/Release/net8.0/publish/MESApplication.dll          |    0 
 MES.Service/service/Warehouse/PurdhbManager.cs                        |    3 
 MESApplication/bin/Debug/net8.0/MES.Service.dll                       |    0 
 MES.Service/Modes/Purdhb.cs                                           |  352 ++++++------
 MESApplication/bin/Debug/net8.0/MESApplication.pdb                    |    0 
 MESApplication/bin/Release/net8.0/MES.Service.dll                     |    0 
 MESApplication/bin/Release/net8.0/MESApplication.dll                  |    0 
 MESApplication/bin/Release/net8.0/publish/MES.Service.pdb             |    0 
 MES.Service/Modes/MesInvItemArn.cs                                    |  304 +++++-----
 MESApplication/bin/Release/net8.0/MES.Service.pdb                     |    0 
 MESApplication/bin/Release/net8.0/publish/MESApplication.exe          |    0 
 MESApplication/bin/Release/net8.0/MESApplication.pdb                  |    0 
 MES.Service/Modes/Purdka.cs                                           |  160 +++---
 MES.Service/bin/Debug/net8.0/MES.Service.pdb                          |    0 
 MESApplication/bin/Release/net8.0/publish/MES.Service.dll             |    0 
 MESApplication/Controllers/Warehouse/MesInvItemArnDetailController.cs |   21 
 MESApplication/bin/Debug/net8.0/MESApplication.dll                    |    0 
 MES.Service/bin/Debug/net8.0/MES.Service.dll                          |    0 
 MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs           |  106 ++-
 MES.Service/Modes/MesQaItemsDetect01.cs                               |  422 ++++++++--------
 MES.Service/Dto/service/Material.cs                                   |    1 
 MESApplication/bin/Debug/net8.0/MESApplication.exe                    |    0 
 MES.Service/bin/Release/net8.0/MES.Service.dll                        |    0 
 MES.Service/bin/Release/net8.0/MES.Service.pdb                        |    0 
 MES.Service/Modes/Purdkb.cs                                           |  176 +++---
 MES.Service/service/Warehouse/PurdkaManager.cs                        |    2 
 30 files changed, 804 insertions(+), 744 deletions(-)

diff --git a/MES.Service/Dto/service/Material.cs b/MES.Service/Dto/service/Material.cs
index 54cefc1..70e8ed4 100644
--- a/MES.Service/Dto/service/Material.cs
+++ b/MES.Service/Dto/service/Material.cs
@@ -11,4 +11,5 @@
     public string? Funit { get; set; }
     public decimal? FmesEntryId { get; set; }
     public decimal? Mid { get; set; }
+    public string? UserName { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/MesInvItemArn.cs b/MES.Service/Modes/MesInvItemArn.cs
index bf0d207..518f09f 100644
--- a/MES.Service/Modes/MesInvItemArn.cs
+++ b/MES.Service/Modes/MesInvItemArn.cs
@@ -8,232 +8,232 @@
 [SugarTable("MES_INV_ITEM_ARN")]
 public class MesInvItemArn
 {
-   /// <summary>
-   ///     ID(SEQ_INV_ID)
-   /// </summary>
-   [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ ///     ID(SEQ_INV_ID)
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
-   /// <summary>
-   ///     鍒拌揣鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "BILL_NO")]
+ /// <summary>
+ ///     鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
     public string BillNo { get; set; }
 
-   /// <summary>
-   ///     鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
-   /// </summary>
-   [SugarColumn(ColumnName = "STATUS")]
+ /// <summary>
+ ///     鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
     public short? Status { get; set; }
 
-   /// <summary>
-   ///     鍘熷洜
-   /// </summary>
-   [SugarColumn(ColumnName = "REASON")]
+ /// <summary>
+ ///     鍘熷洜
+ /// </summary>
+ [SugarColumn(ColumnName = "REASON")]
     public string Reason { get; set; }
 
-   /// <summary>
-   ///     鍒涘缓浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "CREATE_BY")]
+ /// <summary>
+ ///     鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
     public string CreateBy { get; set; }
 
-   /// <summary>
-   ///     鍒涘缓鏃堕棿
-   /// </summary>
-   [SugarColumn(ColumnName = "CREATE_DATE")]
+ /// <summary>
+ ///     鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
     public DateTime? CreateDate { get; set; }
 
-   /// <summary>
-   ///     鏈�鍚庢洿鏂颁汉
-   /// </summary>
-   [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ /// <summary>
+ ///     鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
     public string LastupdateBy { get; set; }
 
-   /// <summary>
-   ///     鏈�鍚庢洿鏂版椂闂�
-   /// </summary>
-   [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <summary>
+ ///     鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
     public DateTime? LastupdateDate { get; set; }
 
-   /// <summary>
-   ///     鍗曟嵁绫诲瀷ID
-   /// </summary>
-   [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+ /// <summary>
+ ///     鍗曟嵁绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_TYPE_ID")]
     public decimal? BillTypeId { get; set; }
 
-   /// <summary>
-   ///     浜嬪姟绫诲瀷ID
-   /// </summary>
-   [SugarColumn(ColumnName = "TRANSACTION_ID")]
+ /// <summary>
+ ///     浜嬪姟绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_ID")]
     public decimal? TransactionId { get; set; }
 
-   /// <summary>
-   ///     澶囨敞
-   /// </summary>
-   [SugarColumn(ColumnName = "REMARK")]
+ /// <summary>
+ ///     澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK")]
     public string Remark { get; set; }
 
-   /// <summary>
-   ///     閫佽揣鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "PAPER_BILL_NO")]
+ /// <summary>
+ ///     閫佽揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_BILL_NO")]
     public string PaperBillNo { get; set; }
 
-   /// <summary>
-   ///     閫�鏂欎汉宸ュ彿
-   /// </summary>
-   [SugarColumn(ColumnName = "USER_NO_BACK")]
+ /// <summary>
+ ///     閫�鏂欎汉宸ュ彿
+ /// </summary>
+ [SugarColumn(ColumnName = "USER_NO_BACK")]
     public string UserNoBack { get; set; }
 
-   /// <summary>
-   ///     鎻愪氦浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_USER")]
+ /// <summary>
+ ///     鎻愪氦浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_USER")]
     public string CheckUser { get; set; }
 
-   /// <summary>
-   ///     鎻愪氦鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_DATE")]
+ /// <summary>
+ ///     鎻愪氦鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_DATE")]
     public DateTime? CheckDate { get; set; }
 
-   /// <summary>
-   ///     鍏ュ簱鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "INS_DATE")]
+ /// <summary>
+ ///     鍏ュ簱鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "INS_DATE")]
     public DateTime? InsDate { get; set; }
 
-   /// <summary>
-   ///     妫�楠岀粨鏋�
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_RES")]
+ /// <summary>
+ ///     妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_RES")]
     public string CheckRes { get; set; }
 
-   /// <summary>
-   ///     宸叉崱鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_QTY")]
+ /// <summary>
+ ///     宸叉崱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QTY")]
     public decimal? CheckQty { get; set; }
 
-   /// <summary>
-   ///     浠撳簱缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "DEPOTS_CODE")]
+ /// <summary>
+ ///     浠撳簱缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOTS_CODE")]
     public string DepotsCode { get; set; }
 
-   /// <summary>
-   ///     浜嬪姟绫诲瀷缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "TRANSCTION_NO")]
+ /// <summary>
+ ///     浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSCTION_NO")]
     public string TransctionNo { get; set; }
 
-   /// <summary>
-   ///     渚涘簲鍟嗙紪鐮�
-   /// </summary>
-   [SugarColumn(ColumnName = "SUPP_NO")]
+ /// <summary>
+ ///     渚涘簲鍟嗙紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
     public string SuppNo { get; set; }
 
-   /// <summary>
-   ///     鎻愪氦鐘舵��
-   /// </summary>
-   [SugarColumn(ColumnName = "FSTATUS")]
+ /// <summary>
+ ///     鎻愪氦鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "FSTATUS")]
     public short? Fstatus { get; set; }
 
-   /// <summary>
-   ///     宸ュ巶缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ ///     宸ュ巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
     public string Factory { get; set; }
 
-   /// <summary>
-   ///     鏄惁宸插洖鍐橲AP
-   /// </summary>
-   [SugarColumn(ColumnName = "SAPSTATUS")]
+ /// <summary>
+ ///     鏄惁宸插洖鍐橲AP
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPSTATUS")]
     public short? Sapstatus { get; set; }
 
-   /// <summary>
-   ///     纭鍏ュ簱鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "INS_DATE")]
+ /// <summary>
+ ///     纭鍏ュ簱鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "INS_DATE")]
     public DateTime? Insdate { get; set; }
 
-   /// <summary>
-   ///     鏄惁妫�楠�
-   /// </summary>
-   [SugarColumn(ColumnName = "ISCHECK")]
+ /// <summary>
+ ///     鏄惁妫�楠�
+ /// </summary>
+ [SugarColumn(ColumnName = "ISCHECK")]
     public decimal? Ischeck { get; set; }
 
-   /// <summary>
-   ///     瀹℃牳鍏ュ簱浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "INSBY")]
+ /// <summary>
+ ///     瀹℃牳鍏ュ簱浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "INSBY")]
     public string Insby { get; set; }
 
-   /// <summary>
-   ///     鍏徃浠g爜
-   /// </summary>
-   [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ ///     鍏徃浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
     public string Company { get; set; }
 
-   /// <summary>
-   ///     鎬ユ枡鏍囪瘑
-   /// </summary>
-   [SugarColumn(ColumnName = "URGENT_FLAG")]
+ /// <summary>
+ ///     鎬ユ枡鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "URGENT_FLAG")]
     public short? UrgentFlag { get; set; }
 
-   /// <summary>
-   ///     鍐查攢浜嬪姟绫诲瀷缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
+ /// <summary>
+ ///     鍐查攢浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
     public decimal? MttransctionNo { get; set; }
 
-   /// <summary>
-   ///     IQC妫�楠屽崟鍙�
-   /// </summary>
-   [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
+ /// <summary>
+ ///     IQC妫�楠屽崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
     public string IqcReleaseNo { get; set; }
 
-   /// <summary>
-   ///     鏄惁鏄剧ず
-   /// </summary>
-   [SugarColumn(ColumnName = "IS_VISUAL")]
+ /// <summary>
+ ///     鏄惁鏄剧ず
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_VISUAL")]
     public decimal? IsVisual { get; set; }
 
-   /// <summary>
-   ///     0=閲囪喘锛�1=濮斿
-   /// </summary>
-   [SugarColumn(ColumnName = "F_TYPE")]
+ /// <summary>
+ ///     0=閲囪喘锛�1=濮斿
+ /// </summary>
+ [SugarColumn(ColumnName = "F_TYPE")]
     public decimal? FType { get; set; }
 
-   /// <summary>
-   ///     ERP鍒拌揣鍗旾D
-   /// </summary>
-   [SugarColumn(ColumnName = "EBELN_K3ID")]
+ /// <summary>
+ ///     ERP鍒拌揣鍗旾D
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN_K3ID")]
     public string EbelnK3id { get; set; }
 
-   /// <summary>
-   ///     鏉$爜鏉″嵃杩涘害
-   /// </summary>
-   [SugarColumn(ColumnName = "BARCODE_RATIO")]
+ /// <summary>
+ ///     鏉$爜鏉″嵃杩涘害
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_RATIO")]
     public decimal? BarcodeRatio { get; set; }
 
-   /// <summary>
-   ///     ERP鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "ERPNO")]
+ /// <summary>
+ ///     ERP鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ERPNO")]
     public string Erpno { get; set; }
 
-   /// <summary>
-   ///     鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐�
-   /// </summary>
-   [SugarColumn(ColumnName = "THSTATUS")]
+ /// <summary>
+ ///     鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐�
+ /// </summary>
+ [SugarColumn(ColumnName = "THSTATUS")]
     public short? Thstatus { get; set; }
 
-   /// <summary>
-   ///     ERP閫�璐у崟鍙�
-   /// </summary>
-   [SugarColumn(ColumnName = "ERPTHNO")]
+ /// <summary>
+ ///     ERP閫�璐у崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "ERPTHNO")]
     public string Erpthno { get; set; }
 
 
diff --git a/MES.Service/Modes/MesQaItemsDetect01.cs b/MES.Service/Modes/MesQaItemsDetect01.cs
index 14760fb..2a26d0c 100644
--- a/MES.Service/Modes/MesQaItemsDetect01.cs
+++ b/MES.Service/Modes/MesQaItemsDetect01.cs
@@ -8,324 +8,324 @@
 [SugarTable("MES_QA_ITEMS_DETECT_01")]
 public class MesQaItemsDetect01
 {
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
-   /// <summary>
-   ///     妫�楠屽崟鍙�
-   /// </summary>
-   [SugarColumn(ColumnName = "RELEASE_NO")]
+ /// <summary>
+ ///     妫�楠屽崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "RELEASE_NO")]
     public string ReleaseNo { get; set; }
 
-   /// <summary>
-   ///     妫�楠屾棩鏈�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_DATE")]
+ /// <summary>
+ ///     妫�楠屾棩鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_DATE")]
     public DateTime? FcheckDate { get; set; }
 
-   /// <summary>
-   ///     妫�楠屼汉鍛�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_BY")]
+ /// <summary>
+ ///     妫�楠屼汉鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_BY")]
     public string FcheckBy { get; set; }
 
-   /// <summary>
-   ///     鐗╂枡缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "ITEM_NO")]
+ /// <summary>
+ ///     鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
     public string ItemNo { get; set; }
 
-   /// <summary>
-   ///     鏉ユ枡鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "FBATCH_QTY")]
+ /// <summary>
+ ///     鏉ユ枡鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FBATCH_QTY")]
     public decimal? FbatchQty { get; set; }
 
-   /// <summary>
-   ///     鍒ゅ畾缁撴灉
-   /// </summary>
-   [SugarColumn(ColumnName = "FRECE_QTY")]
+ /// <summary>
+ ///     鍒ゅ畾缁撴灉
+ /// </summary>
+ [SugarColumn(ColumnName = "FRECE_QTY")]
     public string FreceQty { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "SUPP_NO")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
     public string SuppNo { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "FNG_DESC")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_DESC")]
     public string FngDesc { get; set; }
 
-   /// <summary>
-   ///     妫�楠岀粨鏋�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_RESU")]
+ /// <summary>
+ ///     妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_RESU")]
     public string FcheckResu { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "FREVIEW")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FREVIEW")]
     public string Freview { get; set; }
 
-   /// <summary>
-   ///     妫�楠屾按鍑�
-   /// </summary>
-   [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
+ /// <summary>
+ ///     妫�楠屾按鍑�
+ /// </summary>
+ [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
     public string SampleSizeNo { get; set; }
 
-   /// <summary>
-   ///     妫�楠屾按骞�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_LEVEL")]
+ /// <summary>
+ ///     妫�楠屾按骞�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_LEVEL")]
     public string FcheckLevel { get; set; }
 
-   /// <summary>
-   ///     鎷掓敹姘村钩
-   /// </summary>
-   [SugarColumn(ColumnName = "FAC_LEVEL")]
+ /// <summary>
+ ///     鎷掓敹姘村钩
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_LEVEL")]
     public string FacLevel { get; set; }
 
-   /// <summary>
-   ///     鎶芥鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_QTY")]
+ /// <summary>
+ ///     鎶芥鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QTY")]
     public string CheckQty { get; set; }
 
-   /// <summary>
-   ///     鎵规鍙�  --鍒拌揣鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "LOT_NO")]
+ /// <summary>
+ ///     鎵规鍙�  --鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO")]
     public string LotNo { get; set; }
 
-   /// <summary>
-   ///     鏄惁鎺ㄩ��
-   /// </summary>
-   [SugarColumn(ColumnName = "FMOVE")]
+ /// <summary>
+ ///     鏄惁鎺ㄩ��
+ /// </summary>
+ [SugarColumn(ColumnName = "FMOVE")]
     public string Fmove { get; set; }
 
-   /// <summary>
-   ///     鏄惁澶勭悊
-   /// </summary>
-   [SugarColumn(ColumnName = "FHANDLE")]
+ /// <summary>
+ ///     鏄惁澶勭悊
+ /// </summary>
+ [SugarColumn(ColumnName = "FHANDLE")]
     public string Fhandle { get; set; }
 
-   /// <summary>
-   ///     鍒涘缓浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "CREATE_BY")]
+ /// <summary>
+ ///     鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
     public string CreateBy { get; set; }
 
-   /// <summary>
-   ///     鍒涘缓鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "CREATE_DATE")]
+ /// <summary>
+ ///     鍒涘缓鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
     public DateTime? CreateDate { get; set; }
 
-   /// <summary>
-   ///     鏇存柊浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ /// <summary>
+ ///     鏇存柊浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
     public string LastupdateBy { get; set; }
 
-   /// <summary>
-   ///     鏇存柊鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <summary>
+ ///     鏇存柊鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
     public DateTime? LastupdateDate { get; set; }
 
-   /// <summary>
-   ///     鏄惁瀹℃牳
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_FLAG")]
+ /// <summary>
+ ///     鏄惁瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_FLAG")]
     public decimal? Modify1Flag { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_BY")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_BY")]
     public string Modify1By { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_DATE")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_DATE")]
     public DateTime? Modify1Date { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
     public string Factory { get; set; }
 
-   /// <summary>
-   ///     XRF娴嬭瘯鎶ュ憡缂栧彿
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_REPNO")]
+ /// <summary>
+ ///     XRF娴嬭瘯鎶ュ憡缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_REPNO")]
     public string FcheckRepno { get; set; }
 
-   /// <summary>
-   ///     绗笁鏂规姤鍛�
-   /// </summary>
-   [SugarColumn(ColumnName = "FTHIRD_REP")]
+ /// <summary>
+ ///     绗笁鏂规姤鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "FTHIRD_REP")]
     public string FthirdRep { get; set; }
 
-   /// <summary>
-   ///     鏄惁浣滃簾
-   /// </summary>
-   [SugarColumn(ColumnName = "FCANCEL")]
+ /// <summary>
+ ///     鏄惁浣滃簾
+ /// </summary>
+ [SugarColumn(ColumnName = "FCANCEL")]
     public decimal? Fcancel { get; set; }
 
-   /// <summary>
-   ///     鎻愪氦鏍囪瘑
-   /// </summary>
-   [SugarColumn(ColumnName = "FSUBMIT")]
+ /// <summary>
+ ///     鎻愪氦鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "FSUBMIT")]
     public decimal? Fsubmit { get; set; }
 
-   /// <summary>
-   ///     妫�楠屼緷鎹�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_ACCORD")]
+ /// <summary>
+ ///     妫�楠屼緷鎹�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ACCORD")]
     public string FcheckAccord { get; set; }
 
-   /// <summary>
-   ///     绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱)
-   /// </summary>
-   [SugarColumn(ColumnName = "FTYPE")]
+ /// <summary>
+ ///     绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱)
+ /// </summary>
+ [SugarColumn(ColumnName = "FTYPE")]
     public short? Ftype { get; set; }
 
-   /// <summary>
-   ///     鍗曚綅
-   /// </summary>
-   [SugarColumn(ColumnName = "ITEM_UNIT")]
+ /// <summary>
+ ///     鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_UNIT")]
     public string ItemUnit { get; set; }
 
-   /// <summary>
-   ///     鍑鸿揣鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "OUT_DATE")]
+ /// <summary>
+ ///     鍑鸿揣鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "OUT_DATE")]
     public string OutDate { get; set; }
 
-   /// <summary>
-   ///     鏄惁鍏嶆
-   /// </summary>
-   [SugarColumn(ColumnName = "FEXEMPTION")]
+ /// <summary>
+ ///     鏄惁鍏嶆
+ /// </summary>
+ [SugarColumn(ColumnName = "FEXEMPTION")]
     public decimal? Fexemption { get; set; }
 
-   /// <summary>
-   ///     妗d綅鏍囧噯
-   /// </summary>
-   [SugarColumn(ColumnName = "FGEAR_STAND")]
+ /// <summary>
+ ///     妗d綅鏍囧噯
+ /// </summary>
+ [SugarColumn(ColumnName = "FGEAR_STAND")]
     public string FgearStand { get; set; }
 
-   /// <summary>
-   ///     涓嶈壇澶勭悊鏂规硶
-   /// </summary>
-   [SugarColumn(ColumnName = "FNG_HANDLE")]
+ /// <summary>
+ ///     涓嶈壇澶勭悊鏂规硶
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_HANDLE")]
     public string FngHandle { get; set; }
 
-   /// <summary>
-   ///     绠$悊缂栧彿
-   /// </summary>
-   [SugarColumn(ColumnName = "FMANAGE_NO")]
+ /// <summary>
+ ///     绠$悊缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FMANAGE_NO")]
     public string FmanageNo { get; set; }
 
-   /// <summary>
-   ///     杞崲鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "FCOVERT_QTY")]
+ /// <summary>
+ ///     杞崲鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FCOVERT_QTY")]
     public string FcovertQty { get; set; }
 
-   /// <summary>
-   ///     鐗堟湰
-   /// </summary>
-   [SugarColumn(ColumnName = "FVERSION")]
+ /// <summary>
+ ///     鐗堟湰
+ /// </summary>
+ [SugarColumn(ColumnName = "FVERSION")]
     public decimal? Fversion { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
     public string Company { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "FSECOND_RESU")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FSECOND_RESU")]
     public string FsecondResu { get; set; }
 
-   /// <summary>
-   ///     鏈�澶ф娊妫�鏁�
-   /// </summary>
-   [SugarColumn(ColumnName = "MAX_CHECK_QTY")]
+ /// <summary>
+ ///     鏈�澶ф娊妫�鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "MAX_CHECK_QTY")]
     public decimal? MaxCheckQty { get; set; }
 
-   /// <summary>
-   ///     鐗瑰畾淇敼鏄惁瀹℃牳
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_FLAG1")]
+ /// <summary>
+ ///     鐗瑰畾淇敼鏄惁瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_FLAG1")]
     public decimal? Modify1Flag1 { get; set; }
 
-   /// <summary>
-   ///     鐗瑰畾淇敼瀹℃牳浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_BY1")]
+ /// <summary>
+ ///     鐗瑰畾淇敼瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_BY1")]
     public string Modify1By1 { get; set; }
 
-   /// <summary>
-   ///     鐗瑰畾淇敼瀹℃牳鏃堕棿
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_DATE1")]
+ /// <summary>
+ ///     鐗瑰畾淇敼瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_DATE1")]
     public DateTime? Modify1Date1 { get; set; }
 
-   /// <summary>
-   ///     灏忔壒娆″彿
-   /// </summary>
-   [SugarColumn(ColumnName = "LOT_NO1")]
+ /// <summary>
+ ///     灏忔壒娆″彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO1")]
     public string LotNo1 { get; set; }
 
-   /// <summary>
-   ///     閲囪喘鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "LOT_NO2")]
+ /// <summary>
+ ///     閲囪喘鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO2")]
     public string LotNo2 { get; set; }
 
-   /// <summary>
-   ///     浜у搧鍨嬪彿
-   /// </summary>
-   [SugarColumn(ColumnName = "BOARD_STYLE")]
+ /// <summary>
+ ///     浜у搧鍨嬪彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BOARD_STYLE")]
     public string BoardStyle { get; set; }
 
-   /// <summary>
-   ///     浠诲姟鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "WORK_NO")]
+ /// <summary>
+ ///     浠诲姟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_NO")]
     public string WorkNo { get; set; }
 
-   /// <summary>
-   ///     鍒拌揣鏃堕棿
-   /// </summary>
-   [SugarColumn(ColumnName = "DHA018")]
+ /// <summary>
+ ///     鍒拌揣鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHA018")]
     public string Dha018 { get; set; }
 
-   /// <summary>
-   ///     琛屽彿
-   /// </summary>
-   [SugarColumn(ColumnName = "DHB002")]
+ /// <summary>
+ ///     琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB002")]
     public decimal? Dhb002 { get; set; }
 
-   /// <summary>
-   ///     鍒拌揣鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "DHB001")]
+ /// <summary>
+ ///     鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB001")]
     public string Dhb001 { get; set; }
 
-   /// <summary>
-   ///     渚涘簲鍟�
-   /// </summary>
-   [SugarColumn(ColumnName = "LIFNR")]
+ /// <summary>
+ ///     渚涘簲鍟�
+ /// </summary>
+ [SugarColumn(ColumnName = "LIFNR")]
     public string Lifnr { get; set; }
 
-   /// <summary>
-   ///     閫�鏂欐柟寮�
-   /// </summary>
-   [SugarColumn(ColumnName = "FMRMODE")]
+ /// <summary>
+ ///     閫�鏂欐柟寮�
+ /// </summary>
+ [SugarColumn(ColumnName = "FMRMODE")]
     public string Fmrmode { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/Purdhb.cs b/MES.Service/Modes/Purdhb.cs
index b8de0cc..7fff6ee 100644
--- a/MES.Service/Modes/Purdhb.cs
+++ b/MES.Service/Modes/Purdhb.cs
@@ -8,267 +8,267 @@
 [SugarTable("PURDHB")]
 public class Purdhb
 {
- /// <summary>
- ///     鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB001")]
+   /// <summary>
+   ///     鍗曞彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB001")]
     public string Dhb001 { get; set; }
 
- /// <summary>
- ///     搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB002")]
+   /// <summary>
+   ///     搴忓彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB002")]
     public string Dhb002 { get; set; }
 
- /// <summary>
- ///     鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DHB003")]
+   /// <summary>
+   ///     鐗╂枡缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB003")]
     public string Dhb003 { get; set; }
 
- /// <summary>
- ///     鐗╂枡鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "DHB004")]
+   /// <summary>
+   ///     鐗╂枡鍚嶇О
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB004")]
     public string Dhb004 { get; set; }
 
- /// <summary>
- ///     鐗╂枡瑙勬牸
- /// </summary>
- [SugarColumn(ColumnName = "DHB005")]
+   /// <summary>
+   ///     鐗╂枡瑙勬牸
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB005")]
     public string Dhb005 { get; set; }
 
- /// <summary>
- ///     浜よ揣鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB006")]
+   /// <summary>
+   ///     浜よ揣鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB006")]
     public decimal? Dhb006 { get; set; }
 
- /// <summary>
- ///     鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "DHB007")]
+   /// <summary>
+   ///     鍗曚綅
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB007")]
     public string Dhb007 { get; set; }
 
- /// <summary>
- ///     浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "DHB008")]
+   /// <summary>
+   ///     浠撳簱
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB008")]
     public string Dhb008 { get; set; }
 
- /// <summary>
- ///     浠撳簱鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "DHB009")]
+   /// <summary>
+   ///     浠撳簱鍚嶇О
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB009")]
     public string Dhb009 { get; set; }
 
- /// <summary>
- ///     鎵瑰彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB010")]
+   /// <summary>
+   ///     鎵瑰彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB010")]
     public string Dhb010 { get; set; }
 
- /// <summary>
- ///     鏉ユ簮鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB011")]
+   /// <summary>
+   ///     鏉ユ簮鍗曞彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB011")]
     public string Dhb011 { get; set; }
 
- /// <summary>
- ///     鏉ユ簮搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB012")]
+   /// <summary>
+   ///     鏉ユ簮搴忓彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB012")]
     public decimal? Dhb012 { get; set; }
 
- /// <summary>
- ///     娓呯偣鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB013")]
+   /// <summary>
+   ///     娓呯偣鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB013")]
     public decimal? Dhb013 { get; set; }
 
- /// <summary>
- ///     鍒板巶鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "DHB014")]
+   /// <summary>
+   ///     鍒板巶鏃ユ湡
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB014")]
     public string Dhb014 { get; set; }
 
- /// <summary>
- ///     楠屾敹鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB015")]
+   /// <summary>
+   ///     楠屾敹鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB015")]
     public decimal? Dhb015 { get; set; }
 
- /// <summary>
- ///     楠岄��鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB016")]
+   /// <summary>
+   ///     楠岄��鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB016")]
     public decimal? Dhb016 { get; set; }
 
- /// <summary>
- ///     杩涜揣鍗曚环
- /// </summary>
- [SugarColumn(ColumnName = "DHB017")]
+   /// <summary>
+   ///     杩涜揣鍗曚环
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB017")]
     public decimal? Dhb017 { get; set; }
 
- /// <summary>
- ///     杩涜揣閲戦
- /// </summary>
- [SugarColumn(ColumnName = "DHB018")]
+   /// <summary>
+   ///     杩涜揣閲戦
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB018")]
     public decimal? Dhb018 { get; set; }
 
- /// <summary>
- ///     瀹㈡埛鏂欏彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB019")]
+   /// <summary>
+   ///     瀹㈡埛鏂欏彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB019")]
     public string Dhb019 { get; set; }
 
- /// <summary>
- ///     閮ㄩ棬缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB020")]
+   /// <summary>
+   ///     閮ㄩ棬缂栧彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB020")]
     public string Dhb020 { get; set; }
 
- /// <summary>
- ///     璧犲搧鏁�
- /// </summary>
- [SugarColumn(ColumnName = "DHB021")]
+   /// <summary>
+   ///     璧犲搧鏁�
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB021")]
     public decimal? Dhb021 { get; set; }
 
- /// <summary>
- ///     鏇存柊ERP
- /// </summary>
- [SugarColumn(ColumnName = "DHB022")]
+   /// <summary>
+   ///     鏇存柊ERP
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB022")]
     public string Dhb022 { get; set; }
 
- /// <summary>
- ///     妫�楠岀姸鎬�
- /// </summary>
- [SugarColumn(ColumnName = "DHB023")]
+   /// <summary>
+   ///     妫�楠岀姸鎬�
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB023")]
     public string Dhb023 { get; set; }
 
- /// <summary>
- ///     澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "DHB024")]
+   /// <summary>
+   ///     澶囨敞
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB024")]
     public string Dhb024 { get; set; }
 
- /// <summary>
- ///     瀹℃牳
- /// </summary>
- [SugarColumn(ColumnName = "AUDITING")]
+   /// <summary>
+   ///     瀹℃牳
+   /// </summary>
+   [SugarColumn(ColumnName = "AUDITING")]
     public decimal? Auditing { get; set; }
 
- /// <summary>
- ///     ERP閲囪喘鍗曞彿ID
- /// </summary>
- [SugarColumn(ColumnName = "DHB026")]
+   /// <summary>
+   ///     ERP閲囪喘鍗曞彿ID
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB026")]
     public decimal? Dhb026 { get; set; }
 
- /// <summary>
- ///     ERP閲囪喘搴忓彿ID
- /// </summary>
- [SugarColumn(ColumnName = "DHB027")]
+   /// <summary>
+   ///     ERP閲囪喘搴忓彿ID
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB027")]
     public decimal? Dhb027 { get; set; }
 
- /// <summary>
- ///     ERP鐗╂枡ID
- /// </summary>
- [SugarColumn(ColumnName = "DHB028")]
+   /// <summary>
+   ///     ERP鐗╂枡ID
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB028")]
     public decimal? Dhb028 { get; set; }
 
- /// <summary>
- ///     寰呮鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB029")]
+   /// <summary>
+   ///     寰呮鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB029")]
     public decimal? Dhb029 { get; set; }
 
- /// <summary>
- ///     妫�楠屾棩鏈�
- /// </summary>
- [SugarColumn(ColumnName = "DHB030")]
+   /// <summary>
+   ///     妫�楠屾棩鏈�
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB030")]
     public string Dhb030 { get; set; }
 
- /// <summary>
- ///     妫�楠屽憳
- /// </summary>
- [SugarColumn(ColumnName = "DHB031")]
+   /// <summary>
+   ///     妫�楠屽憳
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB031")]
     public string Dhb031 { get; set; }
 
- /// <summary>
- ///     鍏ュ簱鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB032")]
+   /// <summary>
+   ///     鍏ュ簱鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB032")]
     public decimal? Dhb032 { get; set; }
 
- /// <summary>
- ///     鍏ュ簱浜�
- /// </summary>
- [SugarColumn(ColumnName = "DHB033")]
+   /// <summary>
+   ///     鍏ュ簱浜�
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB033")]
     public string Dhb033 { get; set; }
 
- /// <summary>
- ///     鍏ュ簱鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "DHB034")]
+   /// <summary>
+   ///     鍏ュ簱鏃堕棿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB034")]
     public string Dhb034 { get; set; }
 
- /// <summary>
- ///     閫�璐ф暟閲�
- /// </summary>
- [SugarColumn(ColumnName = "DHB035")]
+   /// <summary>
+   ///     閫�璐ф暟閲�
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB035")]
     public decimal? Dhb035 { get; set; }
 
- /// <summary>
- ///     ERPID
- /// </summary>
- [SugarColumn(ColumnName = "DHB037")]
+   /// <summary>
+   ///     ERPID
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB037")]
     public decimal? Dhb037 { get; set; }
 
- /// <summary>
- ///     閫�璐т汉
- /// </summary>
- [SugarColumn(ColumnName = "DHB036")]
+   /// <summary>
+   ///     閫�璐т汉
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB036")]
     public string Dhb036 { get; set; }
 
- /// <summary>
- ///     ERP鍘熷垎褰曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB038")]
+   /// <summary>
+   ///     ERP鍘熷垎褰曞彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB038")]
     public decimal? Dhb038 { get; set; }
 
- /// <summary>
- ///     ERP婧愬崟鍐呯爜
- /// </summary>
- [SugarColumn(ColumnName = "DHB039")]
+   /// <summary>
+   ///     ERP婧愬崟鍐呯爜
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB039")]
     public decimal? Dhb039 { get; set; }
 
- /// <summary>
- ///     ERP婧愬崟绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "DHB040")]
+   /// <summary>
+   ///     ERP婧愬崟绫诲瀷
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB040")]
     public decimal? Dhb040 { get; set; }
 
- /// <summary>
- ///     ERP璁㈠崟鍐呯爜
- /// </summary>
- [SugarColumn(ColumnName = "DHB041")]
+   /// <summary>
+   ///     ERP璁㈠崟鍐呯爜
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB041")]
     public decimal? Dhb041 { get; set; }
 
- /// <summary>
- ///     鑷鍒�
- /// </summary>
- [SugarColumn(ColumnName = "ID")]
+   /// <summary>
+   ///     鑷鍒�
+   /// </summary>
+   [SugarColumn(ColumnName = "ID")]
     public decimal? Id { get; set; }
 
- /// <summary>
- ///     鏄惁妫�楠岋紝1涓哄凡妫�
- /// </summary>
- [SugarColumn(ColumnName = "ISCHECK")]
+   /// <summary>
+   ///     鏄惁妫�楠岋紝1涓哄凡妫�
+   /// </summary>
+   [SugarColumn(ColumnName = "ISCHECK")]
     public decimal? Ischeck { get; set; }
 
- /// <summary>
- ///     浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "DHB042")]
+   /// <summary>
+   ///     浠撳簱
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB042")]
     public string Dhb042 { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/Purdka.cs b/MES.Service/Modes/Purdka.cs
index 4330c13..1c3ea40 100644
--- a/MES.Service/Modes/Purdka.cs
+++ b/MES.Service/Modes/Purdka.cs
@@ -8,123 +8,123 @@
 [SugarTable("PURDKA")]
 public class Purdka
 {
- /// <summary>
- ///     鑷鍒�
- /// </summary>
- [SugarColumn(ColumnName = "ID")]
+   /// <summary>
+   ///     鑷鍒�
+   /// </summary>
+   [SugarColumn(ColumnName = "ID")]
     public decimal? Id { get; set; }
 
- /// <summary>
- ///     鍒涘缓浜哄憳
- /// </summary>
- [SugarColumn(ColumnName = "CREATEUSER")]
+   /// <summary>
+   ///     鍒涘缓浜哄憳
+   /// </summary>
+   [SugarColumn(ColumnName = "CREATEUSER")]
     public string Createuser { get; set; }
 
- /// <summary>
- ///     鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATETIME")]
+   /// <summary>
+   ///     鍒涘缓鏃堕棿
+   /// </summary>
+   [SugarColumn(ColumnName = "CREATETIME")]
     public string Createtime { get; set; }
 
- /// <summary>
- ///     淇敼鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "MODIFYTIME")]
+   /// <summary>
+   ///     淇敼鏃堕棿
+   /// </summary>
+   [SugarColumn(ColumnName = "MODIFYTIME")]
     public string Modifytime { get; set; }
 
- /// <summary>
- ///     淇敼浜哄憳
- /// </summary>
- [SugarColumn(ColumnName = "MODIFYUSER")]
+   /// <summary>
+   ///     淇敼浜哄憳
+   /// </summary>
+   [SugarColumn(ColumnName = "MODIFYUSER")]
     public string Modifyuser { get; set; }
 
- /// <summary>
- ///     瀹℃牳
- /// </summary>
- [SugarColumn(ColumnName = "AUDITING")]
+   /// <summary>
+   ///     瀹℃牳
+   /// </summary>
+   [SugarColumn(ColumnName = "AUDITING")]
     public string Auditing { get; set; }
 
- /// <summary>
- ///     閫�璐у崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "DKA001")]
+   /// <summary>
+   ///     閫�璐у崟鍙�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA001")]
     public string Dka001 { get; set; }
 
- /// <summary>
- ///     閫�璐х被鍨�
- /// </summary>
- [SugarColumn(ColumnName = "DKA002")]
+   /// <summary>
+   ///     閫�璐х被鍨�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA002")]
     public string Dka002 { get; set; }
 
- /// <summary>
- ///     閫�璐ф棩鏈�
- /// </summary>
- [SugarColumn(ColumnName = "DKA003")]
+   /// <summary>
+   ///     閫�璐ф棩鏈�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA003")]
     public string Dka003 { get; set; }
 
- /// <summary>
- ///     閫�璐ф椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "DKA004")]
+   /// <summary>
+   ///     閫�璐ф椂闂�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA004")]
     public string Dka004 { get; set; }
 
- /// <summary>
- ///     渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "DKA005")]
+   /// <summary>
+   ///     渚涘簲鍟�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA005")]
     public string Dka005 { get; set; }
 
- /// <summary>
- ///     渚涘簲鍟嗗悕绉�
- /// </summary>
- [SugarColumn(ColumnName = "DKA006")]
+   /// <summary>
+   ///     渚涘簲鍟嗗悕绉�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA006")]
     public string Dka006 { get; set; }
 
- /// <summary>
- ///     閮ㄩ棬
- /// </summary>
- [SugarColumn(ColumnName = "DKA007")]
+   /// <summary>
+   ///     閮ㄩ棬
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA007")]
     public string Dka007 { get; set; }
 
- /// <summary>
- ///     瀹℃牳鑰�
- /// </summary>
- [SugarColumn(ColumnName = "DKA008")]
+   /// <summary>
+   ///     瀹℃牳鑰�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA008")]
     public string Dka008 { get; set; }
 
- /// <summary>
- ///     瀹℃牳鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "DKA009")]
+   /// <summary>
+   ///     瀹℃牳鏃ユ湡
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA009")]
     public string Dka009 { get; set; }
 
- /// <summary>
- ///     閫�璐х姸鎬侊紝0鎴栫┖涓烘湭閫�璐э紝1涓哄凡閫�瀹�
- /// </summary>
- [SugarColumn(ColumnName = "DKA010")]
+   /// <summary>
+   ///     閫�璐х姸鎬侊紝0鎴栫┖涓烘湭閫�璐э紝1涓哄凡閫�瀹�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA010")]
     public string Dka010 { get; set; }
 
- /// <summary>
- ///     ERPID
- /// </summary>
- [SugarColumn(ColumnName = "ERPID")]
+   /// <summary>
+   ///     ERPID
+   /// </summary>
+   [SugarColumn(ColumnName = "ERPID")]
     public decimal? Erpid { get; set; }
 
- /// <summary>
- ///     淇濈鍛樼紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "DKA011")]
+   /// <summary>
+   ///     淇濈鍛樼紪鐮�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA011")]
     public string Dka011 { get; set; }
 
- /// <summary>
- ///     楠屾敹鍛樼紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "DKA012")]
+   /// <summary>
+   ///     楠屾敹鍛樼紪鐮�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA012")]
     public string Dka012 { get; set; }
 
- /// <summary>
- ///     鏄惁鎺ㄩ�佺孩瀛楀叆搴�1-鎺ㄩ�侊紝0-鏈帹閫�
- /// </summary>
- [SugarColumn(ColumnName = "DKA013")]
+   /// <summary>
+   ///     鏄惁鎺ㄩ�佺孩瀛楀叆搴�1-鎺ㄩ�侊紝0-鏈帹閫�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA013")]
     public decimal? Dka013 { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/Purdkb.cs b/MES.Service/Modes/Purdkb.cs
index 7eda171..6a0cb38 100644
--- a/MES.Service/Modes/Purdkb.cs
+++ b/MES.Service/Modes/Purdkb.cs
@@ -8,135 +8,135 @@
 [SugarTable("PURDKB")]
 public class Purdkb
 {
- /// <summary>
- ///     鑷鍒�
- /// </summary>
- [SugarColumn(ColumnName = "ID")]
+    /// <summary>
+    ///     鑷鍒�
+    /// </summary>
+    [SugarColumn(ColumnName = "ID")]
     public decimal? Id { get; set; }
 
- /// <summary>
- ///     瀹℃牳
- /// </summary>
- [SugarColumn(ColumnName = "AUDITING")]
+    /// <summary>
+    ///     瀹℃牳
+    /// </summary>
+    [SugarColumn(ColumnName = "AUDITING")]
     public string Auditing { get; set; }
 
- /// <summary>
- ///     鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATETIME")]
+    /// <summary>
+    ///     鍒涘缓鏃堕棿
+    /// </summary>
+    [SugarColumn(ColumnName = "CREATETIME")]
     public string Createtime { get; set; }
 
- /// <summary>
- ///     鍒涘缓浜哄憳
- /// </summary>
- [SugarColumn(ColumnName = "CREATEUSER")]
+    /// <summary>
+    ///     鍒涘缓浜哄憳
+    /// </summary>
+    [SugarColumn(ColumnName = "CREATEUSER")]
     public string Createuser { get; set; }
 
- /// <summary>
- ///     鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DKB001")]
+    /// <summary>
+    ///     鍗曞彿
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB001")]
     public string Dkb001 { get; set; }
 
- /// <summary>
- ///     搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "DKB002")]
+    /// <summary>
+    ///     搴忓彿
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB002")]
     public string Dkb002 { get; set; }
 
- /// <summary>
- ///     鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DKB003")]
+    /// <summary>
+    ///     鐗╂枡缂栫爜
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB003")]
     public string Dkb003 { get; set; }
 
- /// <summary>
- ///     鐗╂枡鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "DKB004")]
+    /// <summary>
+    ///     鐗╂枡鍚嶇О
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB004")]
     public string Dkb004 { get; set; }
 
- /// <summary>
- ///     鐗╂枡瑙勬牸
- /// </summary>
- [SugarColumn(ColumnName = "DKB005")]
+    /// <summary>
+    ///     鐗╂枡瑙勬牸
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB005")]
     public string Dkb005 { get; set; }
 
- /// <summary>
- ///     搴旈��鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DKB006")]
+    /// <summary>
+    ///     搴旈��鏁伴噺
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB006")]
     public decimal? Dkb006 { get; set; }
 
- /// <summary>
- ///     瀹為��鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DKB007")]
+    /// <summary>
+    ///     瀹為��鏁伴噺
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB007")]
     public decimal? Dkb007 { get; set; }
 
- /// <summary>
- ///     寰呴��鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DKB008")]
+    /// <summary>
+    ///     寰呴��鏁伴噺
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB008")]
     public decimal? Dkb008 { get; set; }
 
- /// <summary>
- ///     鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "DKB009")]
+    /// <summary>
+    ///     鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB009")]
     public string Dkb009 { get; set; }
 
- /// <summary>
- ///     鍗曚环
- /// </summary>
- [SugarColumn(ColumnName = "DKB010")]
+    /// <summary>
+    ///     鍗曚环
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB010")]
     public decimal? Dkb010 { get; set; }
 
- /// <summary>
- ///     閲戦
- /// </summary>
- [SugarColumn(ColumnName = "DKB011")]
+    /// <summary>
+    ///     閲戦
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB011")]
     public decimal? Dkb011 { get; set; }
 
- /// <summary>
- ///     鏉ユ簮鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DKB012")]
+    /// <summary>
+    ///     鏉ユ簮鍗曞彿
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB012")]
     public string Dkb012 { get; set; }
 
- /// <summary>
- ///     鏉ユ簮搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "DKB013")]
+    /// <summary>
+    ///     鏉ユ簮搴忓彿
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB013")]
     public string Dkb013 { get; set; }
 
- /// <summary>
- ///     涓嶈壇鍒嗙被
- /// </summary>
- [SugarColumn(ColumnName = "DKB014")]
+    /// <summary>
+    ///     涓嶈壇鍒嗙被
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB014")]
     public string Dkb014 { get; set; }
 
- /// <summary>
- ///     涓嶈壇椤圭洰
- /// </summary>
- [SugarColumn(ColumnName = "DKB015")]
+    /// <summary>
+    ///     涓嶈壇椤圭洰
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB015")]
     public string Dkb015 { get; set; }
 
- /// <summary>
- ///     浠撳簱缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DKB016")]
+    /// <summary>
+    ///     浠撳簱缂栫爜
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB016")]
     public string Dkb016 { get; set; }
 
- /// <summary>
- ///     澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "DKB017")]
+    /// <summary>
+    ///     澶囨敞
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB017")]
     public string Dkb017 { get; set; }
 
- /// <summary>
- ///     浠撳簱鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "DKB018")]
+    /// <summary>
+    ///     浠撳簱鍚嶇О
+    /// </summary>
+    [SugarColumn(ColumnName = "DKB018")]
     public string Dkb018 { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/bin/Debug/net8.0/MES.Service.dll b/MES.Service/bin/Debug/net8.0/MES.Service.dll
index 6d2f60f..ae1034e 100644
--- a/MES.Service/bin/Debug/net8.0/MES.Service.dll
+++ b/MES.Service/bin/Debug/net8.0/MES.Service.dll
Binary files differ
diff --git a/MES.Service/bin/Debug/net8.0/MES.Service.pdb b/MES.Service/bin/Debug/net8.0/MES.Service.pdb
index dcd0d5e..65ec66a 100644
--- a/MES.Service/bin/Debug/net8.0/MES.Service.pdb
+++ b/MES.Service/bin/Debug/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MES.Service/bin/Release/net8.0/MES.Service.dll b/MES.Service/bin/Release/net8.0/MES.Service.dll
index ba6228b..77464c8 100644
--- a/MES.Service/bin/Release/net8.0/MES.Service.dll
+++ b/MES.Service/bin/Release/net8.0/MES.Service.dll
Binary files differ
diff --git a/MES.Service/bin/Release/net8.0/MES.Service.pdb b/MES.Service/bin/Release/net8.0/MES.Service.pdb
index 0ed0ab8..63403c8 100644
--- a/MES.Service/bin/Release/net8.0/MES.Service.pdb
+++ b/MES.Service/bin/Release/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
index 38d361f..c827092 100644
--- a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
+++ b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
@@ -7,6 +7,13 @@
 
 public class MesInvItemArnDetailManager : Repository<MesInvItemArnDetail>
 {
+    //var result = db.Ado.GetString($"SELECT f_getseqnextvalue('{sequenceName}') FROM DUAL");
+
+    private readonly PurdhbManager purdhbManager = new();
+    private readonly PurdkaManager purdkaManager = new();
+    private readonly PurdkbManager purdkbManager = new();
+
+    private readonly MesQaItemsDetect01Manager rohInDataManager = new();
     //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
 
     //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesInvItemArnDetailManager.cs
@@ -81,16 +88,9 @@
         return result;
     }
 
-    //var result = db.Ado.GetString($"SELECT f_getseqnextvalue('{sequenceName}') FROM DUAL");
-
-    private readonly PurdhbManager purdhbManager = new();
-    private readonly PurdkaManager purdkaManager = new();
-    private readonly PurdkbManager purdkbManager = new();
-    private readonly MesQaItemsDetect01Manager rohInDataManager = new();
-
     public bool SetMaterial(Material material)
     {
-        return UseTransaction(db =>
+        var b1 = UseTransaction(db =>
         {
             var executeCommand = db.Updateable<MesInvItemArnDetail>()
                 .SetColumns(s => s.CheckRes == "涓嶅悎鏍�")
@@ -103,50 +103,94 @@
             var mesQaItemsDetect01 = db.Queryable<MesQaItemsDetect01>()
                 .Where(a => a.Id == material.FmesEntryId).Single();
 
-            if (mesQaItemsDetect01 == null)
-            {
-                return 0;
-            }
+            if (mesQaItemsDetect01 == null) return 0;
 
             var suppName = db.Queryable<MesSupplier>()
                 .Where(b => b.SuppNo == mesQaItemsDetect01.SuppNo)
                 .Select<string>(b => b.SuppName).First();
 
             var CIdt = db.Ado.GetString(
-                $"SELECT f_getseqnextvalue('mes_inv_item_ins') FROM DUAL");
+                "SELECT f_getseqnextvalue('mes_inv_item_ins') FROM DUAL");
 
             var billNo = db.Ado.GetString(
-                $"SELECT getbillcode1('1000', '1000', 'INV_IN_BACK') FROM DUAL");
+                "SELECT getbillcode1('1000', '1000', 'INV_IN_BACK') FROM DUAL");
 
             // PURDKA
             var purdka = GetPurdka(CIdt, billNo, mesQaItemsDetect01, suppName);
 
-            executeCommand += db.Insertable<Purdka>(purdka).ExecuteCommand();
+            executeCommand += db.Insertable(purdka).ExecuteCommand();
 
-            db.Queryable<Purdhb>()
-                .Where(c => c.Dhb001 == mesQaItemsDetect01.LotNo
-                            && c.Dhb003 == mesQaItemsDetect01.ItemNo)
-                .Select(c => new Purdhb
-                {
-                    Dhb002 = c.Dhb002,
-                    Dhb003 = c.Dhb003,
-                    Dhb006 = c.Dhb006,
-                    Dhb007 = c.Dhb007,
-                    Dhb017 = c.Dhb017,
-                    Dhb018 = c.Dhb018,
-                    Dhb001 = c.Dhb001,
-                    Dhb042 = c.Dhb042
-                }).ToList();
+            executeCommand += InsertPurdkbs(db, mesQaItemsDetect01, billNo);
+
+            executeCommand += db.Updateable<MesQaItemsDetect01>()
+                .SetColumns(c => c.Modify1Flag == 1)
+                .SetColumns(c => c.Modify1By == material.UserName)
+                .SetColumns(c => c.Modify1Date == DateTime.Now)
+                .SetColumns(c => c.FngHandle == "閫�璐�")
+                .Where(c => c.ReleaseNo == mesQaItemsDetect01.ReleaseNo)
+                .ExecuteCommand();
 
             return executeCommand;
-        }) > 3;
+        }) >= 4;
+
+        if (b1 == false) throw new NotImplementedException("鎺ㄩ�佸け璐ワ紝Mes鏂归潰鍑虹幇闂");
+
+        return b1;
+    }
+
+    private int InsertPurdkbs(SqlSugarScope db,
+        MesQaItemsDetect01 mesQaItemsDetect01, string billNo)
+    {
+        var purdhbs = db.Queryable<Purdhb>()
+            .Where(c => c.Dhb001 == mesQaItemsDetect01.LotNo
+                        && c.Dhb003 == mesQaItemsDetect01.ItemNo)
+            .Select(c => new Purdhb
+            {
+                Dhb002 = c.Dhb002,
+                Dhb003 = c.Dhb003,
+                Dhb006 = c.Dhb006,
+                Dhb007 = c.Dhb007,
+                Dhb017 = c.Dhb017,
+                Dhb018 = c.Dhb018,
+                Dhb001 = c.Dhb001,
+                Dhb042 = c.Dhb042
+            }).ToList();
+
+        var list = new List<Purdkb>();
+
+        purdhbs.ForEach(s =>
+        {
+            var id = db.Ado.GetString(
+                "SELECT f_getseqnextvalue('MES_INV_ITEM_IN_C_DETAILS') FROM DUAL");
+
+            var purdkb = new Purdkb();
+            purdkb.Id = Convert.ToDecimal(id);
+            purdkb.Dkb001 = billNo;
+            purdkb.Dkb002 = s.Dhb002;
+            purdkb.Dkb003 = s.Dhb003;
+            purdkb.Dkb006 = s.Dhb006;
+            purdkb.Dkb007 = s.Dhb006;
+            purdkb.Dkb008 = 0;
+            purdkb.Dkb009 = s.Dhb007;
+            purdkb.Dkb010 = s.Dhb017;
+            purdkb.Dkb011 = s.Dhb018;
+            purdkb.Dkb012 = s.Dhb001;
+            purdkb.Dkb013 = s.Dhb002;
+            purdkb.Dkb016 = s.Dhb042;
+
+            list.Add(purdkb);
+        });
+
+        var insertRange = db.Insertable(list).ExecuteCommand();
+
+        return insertRange == purdhbs.Count ? 1 : 0;
     }
 
     private static Purdka GetPurdka(string CIdt, string billNo,
         MesQaItemsDetect01 mesQaItemsDetect01, string suppName)
     {
         var date = DateTime.Now.ToString("yyyy-MM-dd");
-        Purdka purdka = new Purdka();
+        var purdka = new Purdka();
         purdka.Id = Convert.ToDecimal(CIdt);
         purdka.Dka001 = billNo;
         purdka.Dka002 = "閲囪喘閫�璐�";
diff --git a/MES.Service/service/Warehouse/PurdhbManager.cs b/MES.Service/service/Warehouse/PurdhbManager.cs
index 0061129..b2b70f3 100644
--- a/MES.Service/service/Warehouse/PurdhbManager.cs
+++ b/MES.Service/service/Warehouse/PurdhbManager.cs
@@ -1,6 +1,5 @@
 锘縰sing MES.Service.DB;
 using MES.Service.Modes;
-using SqlSugar;
 
 namespace MES.Service.service.Warehouse;
 
@@ -9,6 +8,4 @@
     //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
 
     //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 PurdhbManager.cs
-
- 
 }
\ No newline at end of file
diff --git a/MES.Service/service/Warehouse/PurdkaManager.cs b/MES.Service/service/Warehouse/PurdkaManager.cs
index 4d6c646..e17aa76 100644
--- a/MES.Service/service/Warehouse/PurdkaManager.cs
+++ b/MES.Service/service/Warehouse/PurdkaManager.cs
@@ -1,6 +1,5 @@
 锘縰sing MES.Service.DB;
 using MES.Service.Modes;
-using SqlSugar;
 
 namespace MES.Service.service.Warehouse;
 
@@ -9,5 +8,4 @@
     //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
 
     //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 PurdkaManager.cs
- 
 }
\ No newline at end of file
diff --git a/MES.Service/service/Warehouse/PurdkbManager.cs b/MES.Service/service/Warehouse/PurdkbManager.cs
index 224c6d7..881e38f 100644
--- a/MES.Service/service/Warehouse/PurdkbManager.cs
+++ b/MES.Service/service/Warehouse/PurdkbManager.cs
@@ -1,6 +1,5 @@
 锘縰sing MES.Service.DB;
 using MES.Service.Modes;
-using SqlSugar;
 
 namespace MES.Service.service.Warehouse;
 
diff --git a/MESApplication/Controllers/Warehouse/MesInvItemArnDetailController.cs b/MESApplication/Controllers/Warehouse/MesInvItemArnDetailController.cs
index 3e88398..5972239 100644
--- a/MESApplication/Controllers/Warehouse/MesInvItemArnDetailController.cs
+++ b/MESApplication/Controllers/Warehouse/MesInvItemArnDetailController.cs
@@ -54,6 +54,27 @@
         }
     }
 
+    //SetMaterial
+    [HttpPost("SetMaterial")]
+    public ResponseResult SetMaterial(Material material)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.SetMaterial(material);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
     /// <summary>
     ///     鑾峰彇鎵�鏈�
     /// </summary>
diff --git a/MESApplication/bin/Debug/net8.0/MES.Service.dll b/MESApplication/bin/Debug/net8.0/MES.Service.dll
index 6d2f60f..ae1034e 100644
--- a/MESApplication/bin/Debug/net8.0/MES.Service.dll
+++ b/MESApplication/bin/Debug/net8.0/MES.Service.dll
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MES.Service.pdb b/MESApplication/bin/Debug/net8.0/MES.Service.pdb
index dcd0d5e..65ec66a 100644
--- a/MESApplication/bin/Debug/net8.0/MES.Service.pdb
+++ b/MESApplication/bin/Debug/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MESApplication.dll b/MESApplication/bin/Debug/net8.0/MESApplication.dll
index f425719..4654c5b 100644
--- a/MESApplication/bin/Debug/net8.0/MESApplication.dll
+++ b/MESApplication/bin/Debug/net8.0/MESApplication.dll
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MESApplication.exe b/MESApplication/bin/Debug/net8.0/MESApplication.exe
index 57e8c1e..bca230a 100644
--- a/MESApplication/bin/Debug/net8.0/MESApplication.exe
+++ b/MESApplication/bin/Debug/net8.0/MESApplication.exe
Binary files differ
diff --git a/MESApplication/bin/Debug/net8.0/MESApplication.pdb b/MESApplication/bin/Debug/net8.0/MESApplication.pdb
index 77bf131..c82b3bd 100644
--- a/MESApplication/bin/Debug/net8.0/MESApplication.pdb
+++ b/MESApplication/bin/Debug/net8.0/MESApplication.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MES.Service.dll b/MESApplication/bin/Release/net8.0/MES.Service.dll
index ba6228b..77464c8 100644
--- a/MESApplication/bin/Release/net8.0/MES.Service.dll
+++ b/MESApplication/bin/Release/net8.0/MES.Service.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MES.Service.pdb b/MESApplication/bin/Release/net8.0/MES.Service.pdb
index 0ed0ab8..63403c8 100644
--- a/MESApplication/bin/Release/net8.0/MES.Service.pdb
+++ b/MESApplication/bin/Release/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MESApplication.dll b/MESApplication/bin/Release/net8.0/MESApplication.dll
index 80a4d57..6018bf4 100644
--- a/MESApplication/bin/Release/net8.0/MESApplication.dll
+++ b/MESApplication/bin/Release/net8.0/MESApplication.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MESApplication.exe b/MESApplication/bin/Release/net8.0/MESApplication.exe
index 57e8c1e..bca230a 100644
--- a/MESApplication/bin/Release/net8.0/MESApplication.exe
+++ b/MESApplication/bin/Release/net8.0/MESApplication.exe
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MESApplication.pdb b/MESApplication/bin/Release/net8.0/MESApplication.pdb
index 1c55a33..0351088 100644
--- a/MESApplication/bin/Release/net8.0/MESApplication.pdb
+++ b/MESApplication/bin/Release/net8.0/MESApplication.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MES.Service.dll b/MESApplication/bin/Release/net8.0/publish/MES.Service.dll
index ba6228b..77464c8 100644
--- a/MESApplication/bin/Release/net8.0/publish/MES.Service.dll
+++ b/MESApplication/bin/Release/net8.0/publish/MES.Service.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb b/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb
index 0ed0ab8..63403c8 100644
--- a/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb
+++ b/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MESApplication.dll b/MESApplication/bin/Release/net8.0/publish/MESApplication.dll
index 80a4d57..6018bf4 100644
--- a/MESApplication/bin/Release/net8.0/publish/MESApplication.dll
+++ b/MESApplication/bin/Release/net8.0/publish/MESApplication.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MESApplication.exe b/MESApplication/bin/Release/net8.0/publish/MESApplication.exe
index 57e8c1e..bca230a 100644
--- a/MESApplication/bin/Release/net8.0/publish/MESApplication.exe
+++ b/MESApplication/bin/Release/net8.0/publish/MESApplication.exe
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb b/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb
index 1c55a33..0351088 100644
--- a/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb
+++ b/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb
Binary files differ

--
Gitblit v1.9.3