From 1b972f58f15108fb3c8f2c635527c1d12bf5ba2b Mon Sep 17 00:00:00 2001
From: lg <999544862qq.com>
Date: 星期四, 15 八月 2024 14:30:58 +0800
Subject: [PATCH] Merge branch 'master' of http://43.142.96.171:8080/r/~tjx/StandardPda

---
 MES.Service/Modes/MesInvItemMovesCDetails.cs                      |  341 +++---
 MES.Service/Modes/MesInvItemMoves.cs                              |  224 ++--
 MES.Service/Modes/MesQaItemsDetect01.cs                           |  422 +++---
 MES.Service/service/Warehouse/MesInvItemMovesManager.cs           |  190 +++
 MES.Service/Modes/MesInvBusiness2.cs                              |  288 ++--
 MES.Service/Modes/MesInvItemBarcodes.cs                           |  600 +++++-----
 MES.Service/Modes/MesInvItemInCItems.cs                           |  184 +-
 MES.Service/Modes/MesInvItemStocks.cs                             |   36 
 MES.Service/Modes/MesQaItemsDetectDetail5.cs                      |  216 +-
 MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs |   23 
 MES.Service/Modes/Purdhb.cs                                       |  352 +++---
 MES.Service/Modes/MesInvItemArn.cs                                |  304 ++--
 MES.Service/util/CollectionUtil.cs                                |    2 
 MES.Service/Dto/service/WarehouseQuery.cs                         |    4 
 MES.Service/Modes/Purdka.cs                                       |  160 +-
 15 files changed, 1,779 insertions(+), 1,567 deletions(-)

diff --git a/MES.Service/Dto/service/WarehouseQuery.cs b/MES.Service/Dto/service/WarehouseQuery.cs
index b3f0734..05428f2 100644
--- a/MES.Service/Dto/service/WarehouseQuery.cs
+++ b/MES.Service/Dto/service/WarehouseQuery.cs
@@ -19,8 +19,8 @@
     public string? Type { get; set; }
     public string? DepotCode { get; set; }
     public string? SuppNo { get; set; }
-    
+
     public string Factory { get; set; }
-    
+
     public string Company { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/MesInvBusiness2.cs b/MES.Service/Modes/MesInvBusiness2.cs
index 89ddce5..9ca8594 100644
--- a/MES.Service/Modes/MesInvBusiness2.cs
+++ b/MES.Service/Modes/MesInvBusiness2.cs
@@ -8,220 +8,220 @@
 [SugarTable("MES_INV_BUSINESS2")]
 public class MesInvBusiness2
 {
- /// <summary>
- ///     ID(seq_inv_id)
- /// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID",
+   /// <summary>
+   ///     ID(seq_inv_id)
+   /// </summary>
+   [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID",
         IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
- /// <summary>
- ///     鐘舵�亅0-鏈氦鏄�1-宸蹭氦鏄�
- /// </summary>
- [SugarColumn(ColumnName = "STATUS")]
+   /// <summary>
+   ///     鐘舵�亅0-鏈氦鏄�1-宸蹭氦鏄�
+   /// </summary>
+   [SugarColumn(ColumnName = "STATUS")]
     public decimal? Status { get; set; }
 
- /// <summary>
- ///     鍗曟嵁绫诲瀷ID
- /// </summary>
- [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+   /// <summary>
+   ///     鍗曟嵁绫诲瀷ID
+   /// </summary>
+   [SugarColumn(ColumnName = "BILL_TYPE_ID")]
     public decimal? BillTypeId { get; set; }
 
- /// <summary>
- ///     浜嬪姟绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "TRANSACTION_CODE")]
+   /// <summary>
+   ///     浜嬪姟绫诲瀷缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "TRANSACTION_CODE")]
     public string TransactionCode { get; set; }
 
- /// <summary>
- ///     浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱
- /// </summary>
- [SugarColumn(ColumnName = "BUSINESS_TYPE")]
+   /// <summary>
+   ///     浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱
+   /// </summary>
+   [SugarColumn(ColumnName = "BUSINESS_TYPE")]
     public decimal? BusinessType { get; set; }
 
- /// <summary>
- ///     鍗曟嵁ID
- /// </summary>
- [SugarColumn(ColumnName = "BILL_ID")]
+   /// <summary>
+   ///     鍗曟嵁ID
+   /// </summary>
+   [SugarColumn(ColumnName = "BILL_ID")]
     public decimal? BillId { get; set; }
 
- /// <summary>
- ///     鍗曟嵁缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "BILL_NO")]
+   /// <summary>
+   ///     鍗曟嵁缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "BILL_NO")]
     public string BillNo { get; set; }
 
- /// <summary>
- ///     鐢熶骇璁㈠崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
+   /// <summary>
+   ///     鐢熶骇璁㈠崟鍙�
+   /// </summary>
+   [SugarColumn(ColumnName = "TASK_NO")]
     public string TaskNo { get; set; }
 
- /// <summary>
- ///     瀹㈡埛缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "CUSTOMER_NO")]
+   /// <summary>
+   ///     瀹㈡埛缂栧彿
+   /// </summary>
+   [SugarColumn(ColumnName = "CUSTOMER_NO")]
     public string CustomerNo { get; set; }
 
- /// <summary>
- ///     鍗曟嵁琛孖D
- /// </summary>
- [SugarColumn(ColumnName = "BILL_LINE_ID")]
+   /// <summary>
+   ///     鍗曟嵁琛孖D
+   /// </summary>
+   [SugarColumn(ColumnName = "BILL_LINE_ID")]
     public decimal? BillLineId { get; set; }
 
- /// <summary>
- ///     鐗╂枡鏉$爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
+   /// <summary>
+   ///     鐗╂枡鏉$爜
+   /// </summary>
+   [SugarColumn(ColumnName = "ITEM_BARCODE")]
     public string ItemBarcode { get; set; }
 
- /// <summary>
- ///     鏈徃鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
+   /// <summary>
+   ///     鏈徃鐗╂枡缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "ITEM_NO")]
     public string ItemNo { get; set; }
 
- /// <summary>
- ///     瀹㈡埛鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
+   /// <summary>
+   ///     瀹㈡埛鐗╂枡缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "C_ITEM_CODE")]
     public string CItemCode { get; set; }
 
- /// <summary>
- ///     鍘傚鎵规
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO")]
+   /// <summary>
+   ///     鍘傚鎵规
+   /// </summary>
+   [SugarColumn(ColumnName = "LOT_NO")]
     public string LotNo { get; set; }
 
- /// <summary>
- ///     鏄惁鐜繚(0:鍚�,1:鏄�)
- /// </summary>
- [SugarColumn(ColumnName = "EP_FLAG")]
+   /// <summary>
+   ///     鏄惁鐜繚(0:鍚�,1:鏄�)
+   /// </summary>
+   [SugarColumn(ColumnName = "EP_FLAG")]
     public short? EpFlag { get; set; }
 
- /// <summary>
- ///     鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
+   /// <summary>
+   ///     鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "QUANTITY")]
     public decimal? Quantity { get; set; }
 
- /// <summary>
- ///     婧愬瓙搴揅ODE
- /// </summary>
- [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")]
+   /// <summary>
+   ///     婧愬瓙搴揅ODE
+   /// </summary>
+   [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")]
     public string FromInvDepotsCode { get; set; }
 
- /// <summary>
- ///     婧愯揣浣岰ODE
- /// </summary>
- [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")]
+   /// <summary>
+   ///     婧愯揣浣岰ODE
+   /// </summary>
+   [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")]
     public string FromInvDepotSectionsCode { get; set; }
 
- /// <summary>
- ///     鐩殑瀛愬簱CODE
- /// </summary>
- [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")]
+   /// <summary>
+   ///     鐩殑瀛愬簱CODE
+   /// </summary>
+   [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")]
     public string ToInvDepotsCode { get; set; }
 
- /// <summary>
- ///     鐩殑璐т綅CODE
- /// </summary>
- [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")]
+   /// <summary>
+   ///     鐩殑璐т綅CODE
+   /// </summary>
+   [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")]
     public string ToInvDepotSectionsCode { get; set; }
 
- /// <summary>
- ///     浜ゆ槗寮傚父淇℃伅
- /// </summary>
- [SugarColumn(ColumnName = "DESCRIPTION")]
+   /// <summary>
+   ///     浜ゆ槗寮傚父淇℃伅
+   /// </summary>
+   [SugarColumn(ColumnName = "DESCRIPTION")]
     public string Description { 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 = "ULLAGE_STAT_FLAG")]
+   /// <summary>
+   ///     瓒呮崯缁熻鏍囪瘑
+   /// </summary>
+   [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")]
     public short? UllageStatFlag { get; set; }
 
- /// <summary>
- ///     鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+   /// <summary>
+   ///     鍒嗗巶缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "FACTORY")]
     public string Factory { get; set; }
 
- /// <summary>
- ///     鍏徃浠g爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+   /// <summary>
+   ///     鍏徃浠g爜
+   /// </summary>
+   [SugarColumn(ColumnName = "COMPANY")]
     public string Company { get; set; }
 
- /// <summary>
- ///     绠卞彿鏉$爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE2")]
+   /// <summary>
+   ///     绠卞彿鏉$爜
+   /// </summary>
+   [SugarColumn(ColumnName = "ITEM_BARCODE2")]
     public string ItemBarcode2 { get; set; }
 
- /// <summary>
- ///     鍗℃澘鏉$爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE3")]
+   /// <summary>
+   ///     鍗℃澘鏉$爜
+   /// </summary>
+   [SugarColumn(ColumnName = "ITEM_BARCODE3")]
     public string ItemBarcode3 { get; set; }
 
- /// <summary>
- ///     浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
+   /// <summary>
+   ///     浠诲姟鍗曞彿
+   /// </summary>
+   [SugarColumn(ColumnName = "WORK_NO")]
     public string WorkNo { get; set; }
 
- /// <summary>
- ///     浠诲姟鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
+   /// <summary>
+   ///     浠诲姟鍗曡鍙�
+   /// </summary>
+   [SugarColumn(ColumnName = "WORK_LINE")]
     public decimal? WorkLine { get; set; }
 
- /// <summary>
- ///     渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
+   /// <summary>
+   ///     渚涘簲鍟�
+   /// </summary>
+   [SugarColumn(ColumnName = "SUPP_NO")]
     public string SuppNo { get; set; }
 
- /// <summary>
- ///     鐢熶骇绾�
- /// </summary>
- [SugarColumn(ColumnName = "LINE_NO")]
+   /// <summary>
+   ///     鐢熶骇绾�
+   /// </summary>
+   [SugarColumn(ColumnName = "LINE_NO")]
     public string LineNo { get; set; }
 
- /// <summary>
- ///     閲囪喘璁㈠崟id
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_K3ID")]
+   /// <summary>
+   ///     閲囪喘璁㈠崟id
+   /// </summary>
+   [SugarColumn(ColumnName = "EBELN_K3ID")]
     public decimal? EbelnK3id { get; set; }
 
- /// <summary>
- ///     閲囪喘璁㈠崟琛宨d
- /// </summary>
- [SugarColumn(ColumnName = "LINE_K3ID")]
+   /// <summary>
+   ///     閲囪喘璁㈠崟琛宨d
+   /// </summary>
+   [SugarColumn(ColumnName = "LINE_K3ID")]
     public decimal? LineK3id { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/MesInvItemArn.cs b/MES.Service/Modes/MesInvItemArn.cs
index 518f09f..bf0d207 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/MesInvItemBarcodes.cs b/MES.Service/Modes/MesInvItemBarcodes.cs
index 078ac04..0e5e2c0 100644
--- a/MES.Service/Modes/MesInvItemBarcodes.cs
+++ b/MES.Service/Modes/MesInvItemBarcodes.cs
@@ -8,453 +8,453 @@
 [SugarTable("MES_INV_ITEM_BARCODES")]
 public class MesInvItemBarcodes
 {
-   /// <summary>
-   ///     SEQ_BARCODE_PSN_ID
-   /// </summary>
-   [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ ///     SEQ_BARCODE_PSN_ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
-   /// <summary>
-   ///     鐗╂枡鏉$爜
-   /// </summary>
-   [SugarColumn(ColumnName = "ITEM_BARCODE")]
+ /// <summary>
+ ///     鐗╂枡鏉$爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE")]
     public string ItemBarcode { get; set; }
 
-   /// <summary>
-   ///     瀹㈡埛鎴愬搧缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "C_PRODUCT_CODE")]
+ /// <summary>
+ ///     瀹㈡埛鎴愬搧缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "C_PRODUCT_CODE")]
     public string CProductCode { get; set; }
 
-   /// <summary>
-   ///     瀹㈡埛鐗╂枡鏉$爜
-   /// </summary>
-   [SugarColumn(ColumnName = "C_ITEM_BARCODE")]
+ /// <summary>
+ ///     瀹㈡埛鐗╂枡鏉$爜
+ /// </summary>
+ [SugarColumn(ColumnName = "C_ITEM_BARCODE")]
     public string CItemBarcode { get; set; }
 
-   /// <summary>
-   ///     瀹㈡埛鐗╂枡缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "C_ITEM_CODE")]
+ /// <summary>
+ ///     瀹㈡埛鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "C_ITEM_CODE")]
     public string CItemCode { get; set; }
 
-   /// <summary>
-   ///     鏈徃鐗╂枡缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "ITEM_NO")]
+ /// <summary>
+ ///     鏈徃鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
     public string ItemNo { get; set; }
 
-   /// <summary>
-   ///     鍘傚鎵规
-   /// </summary>
-   [SugarColumn(ColumnName = "LOT_NO")]
+ /// <summary>
+ ///     鍘傚鎵规
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO")]
     public string LotNo { get; set; }
 
-   /// <summary>
-   ///     鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "QUANTITY")]
+ /// <summary>
+ ///     鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "QUANTITY")]
     public decimal? Quantity { get; set; }
 
-   /// <summary>
-   ///     鏄惁鐜繚(0:鍚�,1:鏄�)
-   /// </summary>
-   [SugarColumn(ColumnName = "EP_FLAG")]
+ /// <summary>
+ ///     鏄惁鐜繚(0:鍚�,1:鏄�)
+ /// </summary>
+ [SugarColumn(ColumnName = "EP_FLAG")]
     public short? EpFlag { get; set; }
 
-   /// <summary>
-   ///     鐢熶骇宸ュ崟
-   /// </summary>
-   [SugarColumn(ColumnName = "TASK_NO")]
+ /// <summary>
+ ///     鐢熶骇宸ュ崟
+ /// </summary>
+ [SugarColumn(ColumnName = "TASK_NO")]
     public string TaskNo { 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 = "CUST_NO")]
+ /// <summary>
+ ///     瀹㈡埛缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUST_NO")]
     public string CustNo { get; set; }
 
-   /// <summary>
-   ///     鐗╂枡鏉$爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙
-   /// </summary>
-   [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")]
+ /// <summary>
+ ///     鐗╂枡鏉$爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")]
     public string ItemBarcodeText { get; set; }
 
-   /// <summary>
-   ///     鍘烶SN鐗╂枡鏉$爜
-   /// </summary>
-   [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")]
+ /// <summary>
+ ///     鍘烶SN鐗╂枡鏉$爜
+ /// </summary>
+ [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")]
     public string OldItemBarcode { get; set; }
 
-   /// <summary>
-   ///     SAP鏀惰揣鐗╂枡鍑瘉鍙�    --閲囪喘鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "MBLNR")]
+ /// <summary>
+ ///     SAP鏀惰揣鐗╂枡鍑瘉鍙�    --閲囪喘鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "MBLNR")]
     public string Mblnr { get; set; }
 
-   /// <summary>
-   ///     SAP鏀惰揣鐗╂枡鍑瘉琛屽彿  --閲囪喘鍗曡鍙�
-   /// </summary>
-   [SugarColumn(ColumnName = "ZEILE")]
+ /// <summary>
+ ///     SAP鏀惰揣鐗╂枡鍑瘉琛屽彿  --閲囪喘鍗曡鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "ZEILE")]
     public decimal? Zeile { get; set; }
 
-   /// <summary>
-   ///     鏀舵枡琛↖D
-   /// </summary>
-   [SugarColumn(ColumnName = "ROH_IN_ID")]
+ /// <summary>
+ ///     鏀舵枡琛↖D
+ /// </summary>
+ [SugarColumn(ColumnName = "ROH_IN_ID")]
     public decimal? RohInId { get; set; }
 
-   /// <summary>
-   ///     0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮�
-   /// </summary>
-   [SugarColumn(ColumnName = "BARCODESTATUS")]
+ /// <summary>
+ ///     0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODESTATUS")]
     public short? Barcodestatus { get; set; }
 
-   /// <summary>
-   ///     鍘熷鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "OLDQTY")]
+ /// <summary>
+ ///     鍘熷鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "OLDQTY")]
     public decimal? Oldqty { get; set; }
 
-   /// <summary>
-   ///     浣跨敤鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "USEQTY")]
+ /// <summary>
+ ///     浣跨敤鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "USEQTY")]
     public decimal? Useqty { get; set; }
 
-   /// <summary>
-   ///     0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾
-   /// </summary>
-   [SugarColumn(ColumnName = "LOCATION")]
+ /// <summary>
+ ///     0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾
+ /// </summary>
+ [SugarColumn(ColumnName = "LOCATION")]
     public short? Location { get; set; }
 
-   /// <summary>
-   ///     鍗曚綅
-   /// </summary>
-   [SugarColumn(ColumnName = "UNIT")]
+ /// <summary>
+ ///     鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "UNIT")]
     public string Unit { get; set; }
 
-   /// <summary>
-   ///     閲嶉噺锛堝崟浣嶏細鍏枻锛�
-   /// </summary>
-   [SugarColumn(ColumnName = "WEIGHT_UNIT")]
+ /// <summary>
+ ///     閲嶉噺锛堝崟浣嶏細鍏枻锛�
+ /// </summary>
+ [SugarColumn(ColumnName = "WEIGHT_UNIT")]
     public decimal? WeightUnit { get; set; }
 
-   /// <summary>
-   ///     鍗曚环
-   /// </summary>
-   [SugarColumn(ColumnName = "PRICE")]
+ /// <summary>
+ ///     鍗曚环
+ /// </summary>
+ [SugarColumn(ColumnName = "PRICE")]
     public decimal? Price { get; set; }
 
-   /// <summary>
-   ///     鍘熸潯鐮佹暟閲�
-   /// </summary>
-   [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")]
+ /// <summary>
+ ///     鍘熸潯鐮佹暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")]
     public decimal? OldBarQuantity { get; set; }
 
-   /// <summary>
-   ///     姹囨�绘潯鐮�
-   /// </summary>
-   [SugarColumn(ColumnName = "SUM_BARCODE")]
+ /// <summary>
+ ///     姹囨�绘潯鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUM_BARCODE")]
     public string SumBarcode { get; set; }
 
-   /// <summary>
-   ///     鐢熶骇鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "LOT_DATE")]
+ /// <summary>
+ ///     鐢熶骇鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_DATE")]
     public string LotDate { get; set; }
 
-   /// <summary>
-   ///     妯″彿
-   /// </summary>
-   [SugarColumn(ColumnName = "MOCODE")]
+ /// <summary>
+ ///     妯″彿
+ /// </summary>
+ [SugarColumn(ColumnName = "MOCODE")]
     public string Mocode { get; set; }
 
-   /// <summary>
-   ///     鏉ユ簮
-   /// </summary>
-   [SugarColumn(ColumnName = "MEMO")]
+ /// <summary>
+ ///     鏉ユ簮
+ /// </summary>
+ [SugarColumn(ColumnName = "MEMO")]
     public string Memo { get; set; }
 
-   /// <summary>
-   ///     渚涘簲鍟嗙紪鐮�
-   /// </summary>
-   [SugarColumn(ColumnName = "SUPP_NO")]
+ /// <summary>
+ ///     渚涘簲鍟嗙紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
     public string SuppNo { get; set; }
 
-   /// <summary>
-   ///     妗d綅浣庡��
-   /// </summary>
-   [SugarColumn(ColumnName = "SPOSTION")]
+ /// <summary>
+ ///     妗d綅浣庡��
+ /// </summary>
+ [SugarColumn(ColumnName = "SPOSTION")]
     public string Spostion { get; set; }
 
-   /// <summary>
-   ///     妗d綅楂樺��
-   /// </summary>
-   [SugarColumn(ColumnName = "EPOSTION")]
+ /// <summary>
+ ///     妗d綅楂樺��
+ /// </summary>
+ [SugarColumn(ColumnName = "EPOSTION")]
     public string Epostion { get; set; }
 
-   /// <summary>
-   ///     鐗╂枡绠�绉�
-   /// </summary>
-   [SugarColumn(ColumnName = "ITEM_SNAME")]
+ /// <summary>
+ ///     鐗╂枡绠�绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_SNAME")]
     public string ItemSname { get; set; }
 
-   /// <summary>
-   ///     鏄惁宸插喕缁�,1鍐荤粨
-   /// </summary>
-   [SugarColumn(ColumnName = "VISABLE")]
+ /// <summary>
+ ///     鏄惁宸插喕缁�,1鍐荤粨
+ /// </summary>
+ [SugarColumn(ColumnName = "VISABLE")]
     public short? Visable { get; set; }
 
-   /// <summary>
-   ///     渚涘簲鍟嗘壒娆�
-   /// </summary>
-   [SugarColumn(ColumnName = "TR_LOTNO")]
+ /// <summary>
+ ///     渚涘簲鍟嗘壒娆�
+ /// </summary>
+ [SugarColumn(ColumnName = "TR_LOTNO")]
     public string TrLotno { get; set; }
 
-   /// <summary>
-   ///     鍐荤粨鏃堕棿
-   /// </summary>
-   [SugarColumn(ColumnName = "FLEZZ_DATE")]
+ /// <summary>
+ ///     鍐荤粨鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "FLEZZ_DATE")]
     public DateTime? FlezzDate { get; set; }
 
-   /// <summary>
-   ///     鍐荤粨鍘熷洜
-   /// </summary>
-   [SugarColumn(ColumnName = "FLEZZ_REASON")]
+ /// <summary>
+ ///     鍐荤粨鍘熷洜
+ /// </summary>
+ [SugarColumn(ColumnName = "FLEZZ_REASON")]
     public string FlezzReason { get; set; }
 
-   /// <summary>
-   ///     鍐荤粨浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "FLEZZ_BY")]
+ /// <summary>
+ ///     鍐荤粨浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "FLEZZ_BY")]
     public string FlezzBy { get; set; }
 
-   /// <summary>
-   ///     寤堕暱淇濊川鏈�
-   /// </summary>
-   [SugarColumn(ColumnName = "DELANY_MONTH")]
+ /// <summary>
+ ///     寤堕暱淇濊川鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "DELANY_MONTH")]
     public decimal? DelanyMonth { get; set; }
 
-   /// <summary>
-   ///     鏈�灏忓寘瑁呮爣璇�
-   /// </summary>
-   [SugarColumn(ColumnName = "MINPACK_FLAG")]
+ /// <summary>
+ ///     鏈�灏忓寘瑁呮爣璇�
+ /// </summary>
+ [SugarColumn(ColumnName = "MINPACK_FLAG")]
     public short? MinpackFlag { get; set; }
 
-   /// <summary>
-   ///     鎵撳嵃ID锛岀敤鏉ュ尯鍒嗘墦鍗版鏁�
-   /// </summary>
-   [SugarColumn(ColumnName = "PRINT_ID")]
+ /// <summary>
+ ///     鎵撳嵃ID锛岀敤鏉ュ尯鍒嗘墦鍗版鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "PRINT_ID")]
     public string PrintId { get; set; }
 
-   /// <summary>
-   ///     鐜繚椤圭洰
-   /// </summary>
-   [SugarColumn(ColumnName = "EP_ITEM")]
+ /// <summary>
+ ///     鐜繚椤圭洰
+ /// </summary>
+ [SugarColumn(ColumnName = "EP_ITEM")]
     public string EpItem { get; set; }
 
-   /// <summary>
-   ///     宸ュ巶缂栧彿
-   /// </summary>
-   [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ ///     宸ュ巶缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
     public string Factory { get; set; }
 
-   /// <summary>
-   ///     鍏徃缂栧彿
-   /// </summary>
-   [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ ///     鍏徃缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
     public string Company { get; set; }
 
-   /// <summary>
-   ///     鍗℃澘缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "CB_NO")]
+ /// <summary>
+ ///     鍗℃澘缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "CB_NO")]
     public string CbNo { get; set; }
 
-   /// <summary>
-   ///     鍘傚鐢熶骇绾�
-   /// </summary>
-   [SugarColumn(ColumnName = "LINFLINE")]
+ /// <summary>
+ ///     鍘傚鐢熶骇绾�
+ /// </summary>
+ [SugarColumn(ColumnName = "LINFLINE")]
     public string Linfline { get; set; }
 
-   /// <summary>
-   ///     鏈夋晥鏈�
-   /// </summary>
-   [SugarColumn(ColumnName = "VALID_TIME")]
+ /// <summary>
+ ///     鏈夋晥鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "VALID_TIME")]
     public DateTime? ValidTime { get; set; }
 
-   /// <summary>
-   ///     璐ㄦ缁撴灉
-   /// </summary>
-   [SugarColumn(ColumnName = "IQC_STATUS")]
+ /// <summary>
+ ///     璐ㄦ缁撴灉
+ /// </summary>
+ [SugarColumn(ColumnName = "IQC_STATUS")]
     public string IqcStatus { get; set; }
 
-   /// <summary>
-   ///     灏忚溅鏉$爜
-   /// </summary>
-   [SugarColumn(ColumnName = "FCAR")]
+ /// <summary>
+ ///     灏忚溅鏉$爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FCAR")]
     public string Fcar { get; set; }
 
-   /// <summary>
-   ///     姣涢噸
-   /// </summary>
-   [SugarColumn(ColumnName = "GWEIGHT")]
+ /// <summary>
+ ///     姣涢噸
+ /// </summary>
+ [SugarColumn(ColumnName = "GWEIGHT")]
     public string Gweight { get; set; }
 
-   /// <summary>
-   ///     鍑�閲�
-   /// </summary>
-   [SugarColumn(ColumnName = "NWEIGHT")]
+ /// <summary>
+ ///     鍑�閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "NWEIGHT")]
     public string Nweight { get; set; }
 
-   /// <summary>
-   ///     淇濊川鏈�
-   /// </summary>
-   [SugarColumn(ColumnName = "EXT_DATE")]
+ /// <summary>
+ ///     淇濊川鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "EXT_DATE")]
     public decimal? ExtDate { get; set; }
 
-   /// <summary>
-   ///     渚涘簲鍟嗐�佽禒鍝併�佸渚涙枡銆佸澶�
-   /// </summary>
-   [SugarColumn(ColumnName = "BARCODETYPE")]
+ /// <summary>
+ ///     渚涘簲鍟嗐�佽禒鍝併�佸渚涙枡銆佸澶�
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODETYPE")]
     public string Barcodetype { get; set; }
 
-   /// <summary>
-   ///     渚涘簲鍟嗗悕绉�
-   /// </summary>
-   [SugarColumn(ColumnName = "SUPP_NAME")]
+ /// <summary>
+ ///     渚涘簲鍟嗗悕绉�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NAME")]
     public string SuppName { get; set; }
 
-   /// <summary>
-   ///     鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "BILL_NO")]
+ /// <summary>
+ ///     鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
     public string BillNo { get; set; }
 
-   /// <summary>
-   ///     鎬ユ枡鏍囪瘑
-   /// </summary>
-   [SugarColumn(ColumnName = "URGENT_FLAG")]
+ /// <summary>
+ ///     鎬ユ枡鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "URGENT_FLAG")]
     public short? UrgentFlag { get; set; }
 
-   /// <summary>
-   ///     棰滆壊
-   /// </summary>
-   [SugarColumn(ColumnName = "COLOR_NAME")]
+ /// <summary>
+ ///     棰滆壊
+ /// </summary>
+ [SugarColumn(ColumnName = "COLOR_NAME")]
     public string ColorName { get; set; }
 
-   /// <summary>
-   ///     浜у搧鍨嬪彿
-   /// </summary>
-   [SugarColumn(ColumnName = "BOARD_STYLE")]
+ /// <summary>
+ ///     浜у搧鍨嬪彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BOARD_STYLE")]
     public string BoardStyle { get; set; }
 
-   /// <summary>
-   ///     鏉ユ枡鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "INS_DATE")]
+ /// <summary>
+ ///     鏉ユ枡鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "INS_DATE")]
     public DateTime? InsDate { get; set; }
 
-   /// <summary>
-   ///     鍒拌揣鍗曡鍙�
-   /// </summary>
-   [SugarColumn(ColumnName = "WORK_LINE")]
+ /// <summary>
+ ///     鍒拌揣鍗曡鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_LINE")]
     public decimal? WorkLine { get; set; }
 
-   /// <summary>
-   ///     涓嶈壇鍘熷洜
-   /// </summary>
-   [SugarColumn(ColumnName = "MEMO_BAD")]
+ /// <summary>
+ ///     涓嶈壇鍘熷洜
+ /// </summary>
+ [SugarColumn(ColumnName = "MEMO_BAD")]
     public string MemoBad { get; set; }
 
-   /// <summary>
-   ///     浠诲姟鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "WORK_NO")]
+ /// <summary>
+ ///     浠诲姟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_NO")]
     public string WorkNo { get; set; }
 
-   /// <summary>
-   ///     鏉$爜鏉ユ簮鏍囪瘑锛�0-鍒濇湡鐗╂枡,1-閲囪喘鍏ュ簱锛�2銆佺敓浜ч��鏂欙紝3銆佸叾瀹冨叆搴擄紝4-瀹緵鏂�,5-鍦ㄥ簱鍒嗘枡锛�6-鍒剁▼鏉$爜
-   /// </summary>
-   [SugarColumn(ColumnName = "COME_FLG")]
+ /// <summary>
+ ///     鏉$爜鏉ユ簮鏍囪瘑锛�0-鍒濇湡鐗╂枡,1-閲囪喘鍏ュ簱锛�2銆佺敓浜ч��鏂欙紝3銆佸叾瀹冨叆搴擄紝4-瀹緵鏂�,5-鍦ㄥ簱鍒嗘枡锛�6-鍒剁▼鏉$爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COME_FLG")]
     public short? ComeFlg { get; set; }
 
-   /// <summary>
-   ///     鐢熶骇绾夸綋
-   /// </summary>
-   [SugarColumn(ColumnName = "LINE_NO")]
+ /// <summary>
+ ///     鐢熶骇绾夸綋
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_NO")]
     public string LineNo { get; set; }
 
-   /// <summary>
-   ///     涓濆嵃娆℃暟
-   /// </summary>
-   [SugarColumn(ColumnName = "SILK_PQTY")]
+ /// <summary>
+ ///     涓濆嵃娆℃暟
+ /// </summary>
+ [SugarColumn(ColumnName = "SILK_PQTY")]
     public decimal? SilkPqty { get; set; }
 
-   /// <summary>
-   ///     涓濆嵃娆℃暟姣�
-   /// </summary>
-   [SugarColumn(ColumnName = "SILK")]
+ /// <summary>
+ ///     涓濆嵃娆℃暟姣�
+ /// </summary>
+ [SugarColumn(ColumnName = "SILK")]
     public string Silk { get; set; }
 
-   /// <summary>
-   ///     涓濆嵃娲惧伐浠庤〃ID
-   /// </summary>
-   [SugarColumn(ColumnName = "SILK_ID")]
+ /// <summary>
+ ///     涓濆嵃娲惧伐浠庤〃ID
+ /// </summary>
+ [SugarColumn(ColumnName = "SILK_ID")]
     public decimal? SilkId { get; set; }
 
-   /// <summary>
-   ///     宸叉姤宸ユ爣璇�
-   /// </summary>
-   [SugarColumn(ColumnName = "WORK_FLG")]
+ /// <summary>
+ ///     宸叉姤宸ユ爣璇�
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_FLG")]
     public decimal? WorkFlg { get; set; }
 
-   /// <summary>
-   ///     鏈�鍚庡伐搴�
-   /// </summary>
-   [SugarColumn(ColumnName = "WORK_LAST")]
+ /// <summary>
+ ///     鏈�鍚庡伐搴�
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_LAST")]
     public decimal? WorkLast { get; set; }
 
-   /// <summary>
-   ///     0-鏈悎骞舵墦鍗帮紝1-鍚堝苟鎵撳嵃
-   /// </summary>
-   [SugarColumn(ColumnName = "HBDY")]
+ /// <summary>
+ ///     0-鏈悎骞舵墦鍗帮紝1-鍚堝苟鎵撳嵃
+ /// </summary>
+ [SugarColumn(ColumnName = "HBDY")]
     public decimal? Hbdy { get; set; }
 
-   /// <summary>
-   ///     0-鏈夋晥鏉$爜锛�1-鍚堝苟鎷嗗垎鐨勬潯鐮侊紝鏃犳晥
-   /// </summary>
-   [SugarColumn(ColumnName = "HBDYTM")]
+ /// <summary>
+ ///     0-鏈夋晥鏉$爜锛�1-鍚堝苟鎷嗗垎鐨勬潯鐮侊紝鏃犳晥
+ /// </summary>
+ [SugarColumn(ColumnName = "HBDYTM")]
     public decimal? Hbdytm { get; set; }
 
-   /// <summary>
-   ///     鎶ュ伐鏃堕棿
-   /// </summary>
-   [SugarColumn(ColumnName = "WORK_FLGTIME")]
+ /// <summary>
+ ///     鎶ュ伐鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_FLGTIME")]
     public string WorkFlgtime { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/MesInvItemInCItems.cs b/MES.Service/Modes/MesInvItemInCItems.cs
index 05e3293..9c3eb27 100644
--- a/MES.Service/Modes/MesInvItemInCItems.cs
+++ b/MES.Service/Modes/MesInvItemInCItems.cs
@@ -8,141 +8,141 @@
 [SugarTable("MES_INV_ITEM_IN_C_ITEMS")]
 public class MesInvItemInCItems
 {
- /// <summary>
- ///     SEQ_OUT
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+   /// <summary>
+   ///     SEQ_OUT
+   /// </summary>
+   [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
- /// <summary>
- ///     鍏ュ簱鍗昳d
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)]
+   /// <summary>
+   ///     鍏ュ簱鍗昳d
+   /// </summary>
+   [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)]
     public decimal ItemInId { get; set; }
 
- /// <summary>
- ///     楠屾敹鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
+   /// <summary>
+   ///     楠屾敹鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "QUANTITY")]
     public decimal? Quantity { 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 = "ITEM_NO")]
+   /// <summary>
+   ///     鐗╂枡缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "ITEM_NO")]
     public string ItemNo { get; set; }
 
- /// <summary>
- ///     浠撳簱缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_CODE")]
+   /// <summary>
+   ///     浠撳簱缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "DEPOT_CODE")]
     public string DepotCode { get; set; }
 
- /// <summary>
- ///     璐т綅缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
+   /// <summary>
+   ///     璐т綅缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
     public string DepotSectionCode { get; set; }
 
- /// <summary>
- ///     鐗硅浜嬮」
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
+   /// <summary>
+   ///     鐗硅浜嬮」
+   /// </summary>
+   [SugarColumn(ColumnName = "REMARK")]
     public string Remark { get; set; }
 
- /// <summary>
- ///     鐗╂枡绠�绉�
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_SNAME")]
+   /// <summary>
+   ///     鐗╂枡绠�绉�
+   /// </summary>
+   [SugarColumn(ColumnName = "ITEM_SNAME")]
     public string ItemSname { get; set; }
 
- /// <summary>
- ///     鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "UNIT")]
+   /// <summary>
+   ///     鍗曚綅
+   /// </summary>
+   [SugarColumn(ColumnName = "UNIT")]
     public string Unit { get; set; }
 
- /// <summary>
- ///     閲囪喘璁㈠崟
- /// </summary>
- [SugarColumn(ColumnName = "EBELN")]
+   /// <summary>
+   ///     閲囪喘璁㈠崟
+   /// </summary>
+   [SugarColumn(ColumnName = "EBELN")]
     public string Ebeln { get; set; }
 
- /// <summary>
- ///     鍏ュ簱鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "BILL_NO")]
+   /// <summary>
+   ///     鍏ュ簱鍗曞彿
+   /// </summary>
+   [SugarColumn(ColumnName = "BILL_NO")]
     public string BillNo { get; set; }
 
- /// <summary>
- ///     鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+   /// <summary>
+   ///     鍒嗗巶缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "FACTORY")]
     public string Factory { get; set; }
 
- /// <summary>
- ///     鍏徃浠g爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+   /// <summary>
+   ///     鍏徃浠g爜
+   /// </summary>
+   [SugarColumn(ColumnName = "COMPANY")]
     public string Company { get; set; }
 
- /// <summary>
- ///     浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
+   /// <summary>
+   ///     浠诲姟鍗曞彿
+   /// </summary>
+   [SugarColumn(ColumnName = "WORK_NO")]
     public string WorkNo { get; set; }
 
- /// <summary>
- ///     琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_LINE_NO")]
+   /// <summary>
+   ///     琛屽彿
+   /// </summary>
+   [SugarColumn(ColumnName = "EBELN_LINE_NO")]
     public decimal? EbelnLineNo { get; set; }
 
- /// <summary>
- ///     鍒拌揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "CBILL_NO")]
+   /// <summary>
+   ///     鍒拌揣鍗曞彿
+   /// </summary>
+   [SugarColumn(ColumnName = "CBILL_NO")]
     public string CbillNo { get; set; }
 
- /// <summary>
- ///     浠诲姟鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
+   /// <summary>
+   ///     浠诲姟鍗曡鍙�
+   /// </summary>
+   [SugarColumn(ColumnName = "WORK_LINE")]
     public decimal? WorkLine { get; set; }
 
- /// <summary>
- ///     鐢熶骇宸ュ崟
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
+   /// <summary>
+   ///     鐢熶骇宸ュ崟
+   /// </summary>
+   [SugarColumn(ColumnName = "TASK_NO")]
     public string TaskNo { get; set; }
 
- /// <summary>
- ///     渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
+   /// <summary>
+   ///     渚涘簲鍟�
+   /// </summary>
+   [SugarColumn(ColumnName = "SUPP_NO")]
     public string SuppNo { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/MesInvItemMoves.cs b/MES.Service/Modes/MesInvItemMoves.cs
index b65928e..07b4ba6 100644
--- a/MES.Service/Modes/MesInvItemMoves.cs
+++ b/MES.Service/Modes/MesInvItemMoves.cs
@@ -8,171 +8,171 @@
 [SugarTable("MES_INV_ITEM_MOVES")]
 public class MesInvItemMoves
 {
- /// <summary>
- ///     SEQ_INV_ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+   /// <summary>
+   ///     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>
- ///     绉诲叆瀛愬簱id
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
+   /// <summary>
+   ///     绉诲叆瀛愬簱id
+   /// </summary>
+   [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
     public decimal? InvDepotsId { get; set; }
 
- /// <summary>
- ///     绉诲叆璐т綅id
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
+   /// <summary>
+   ///     绉诲叆璐т綅id
+   /// </summary>
+   [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
     public decimal? InvDepotSectionsId { 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>
- ///     鐘舵�亅0-鍒跺崟1-杩囪处
- /// </summary>
- [SugarColumn(ColumnName = "STATUS")]
+   /// <summary>
+   ///     鐘舵�亅0-鍒跺崟1-杩囪处
+   /// </summary>
+   [SugarColumn(ColumnName = "STATUS")]
     public decimal? Status { get; set; }
 
- /// <summary>
- ///     澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
+   /// <summary>
+   ///     澶囨敞
+   /// </summary>
+   [SugarColumn(ColumnName = "REMARK")]
     public string Remark { 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 = "CHECKUSER")]
+   /// <summary>
+   ///     瀹℃牳浜�
+   /// </summary>
+   [SugarColumn(ColumnName = "CHECKUSER")]
     public string Checkuser { get; set; }
 
- /// <summary>
- ///     瀹℃牳鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "CHECKDATE")]
+   /// <summary>
+   ///     瀹℃牳鏃ユ湡
+   /// </summary>
+   [SugarColumn(ColumnName = "CHECKDATE")]
     public DateTime? Checkdate { get; set; }
 
- /// <summary>
- ///     绉诲叆瀛愬簱code
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
+   /// <summary>
+   ///     绉诲叆瀛愬簱code
+   /// </summary>
+   [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
     public string InvDepotsCode { get; set; }
 
- /// <summary>
- ///     绉诲叆璐т綅code
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
+   /// <summary>
+   ///     绉诲叆璐т綅code
+   /// </summary>
+   [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
     public string InvDepotSectionsCode { get; set; }
 
- /// <summary>
- ///     浜嬪姟绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "TRANSACTION_NO")]
+   /// <summary>
+   ///     浜嬪姟绫诲瀷缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "TRANSACTION_NO")]
     public decimal? TransactionNo { get; set; }
 
- /// <summary>
- ///     绉诲嚭瀛愬簱code
- /// </summary>
- [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
+   /// <summary>
+   ///     绉诲嚭瀛愬簱code
+   /// </summary>
+   [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
     public string FromDepotsCode { get; set; }
 
- /// <summary>
- ///     宸ュ巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY_CODE")]
+   /// <summary>
+   ///     宸ュ巶缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "FACTORY_CODE")]
     public string FactoryCode { get; set; }
 
- /// <summary>
- ///     SAP杩斿洖鍗曟嵁
- /// </summary>
- [SugarColumn(ColumnName = "SAPNO")]
+   /// <summary>
+   ///     SAP杩斿洖鍗曟嵁
+   /// </summary>
+   [SugarColumn(ColumnName = "SAPNO")]
     public string Sapno { get; set; }
 
- /// <summary>
- ///     宸插洖鍐橲AP
- /// </summary>
- [SugarColumn(ColumnName = "SAPSTATUS")]
+   /// <summary>
+   ///     宸插洖鍐橲AP
+   /// </summary>
+   [SugarColumn(ColumnName = "SAPSTATUS")]
     public short? Sapstatus { get; set; }
 
- /// <summary>
- ///     SAP杩斿洖骞翠唤
- /// </summary>
- [SugarColumn(ColumnName = "SAPYEAR")]
+   /// <summary>
+   ///     SAP杩斿洖骞翠唤
+   /// </summary>
+   [SugarColumn(ColumnName = "SAPYEAR")]
     public short? Sapyear { get; set; }
 
- /// <summary>
- ///     SAP杩斿洖淇℃伅
- /// </summary>
- [SugarColumn(ColumnName = "SAPTEXT")]
+   /// <summary>
+   ///     SAP杩斿洖淇℃伅
+   /// </summary>
+   [SugarColumn(ColumnName = "SAPTEXT")]
     public string Saptext { get; set; }
 
- /// <summary>
- ///     鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+   /// <summary>
+   ///     鍒嗗巶缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "FACTORY")]
     public string Factory { get; set; }
 
- /// <summary>
- ///     鍏徃浠g爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+   /// <summary>
+   ///     鍏徃浠g爜
+   /// </summary>
+   [SugarColumn(ColumnName = "COMPANY")]
     public string Company { get; set; }
 
- /// <summary>
- ///     鍙嶅鏍镐簨鍔$被鍨嬬紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "MTRANSACTION_NO")]
+   /// <summary>
+   ///     鍙嶅鏍镐簨鍔$被鍨嬬紪鐮�
+   /// </summary>
+   [SugarColumn(ColumnName = "MTRANSACTION_NO")]
     public decimal? MtransactionNo { get; set; }
 
- /// <summary>
- ///     鑷姩淇濆瓨瀛楁
- /// </summary>
- [SugarColumn(ColumnName = "ZD_NUM")]
+   /// <summary>
+   ///     鑷姩淇濆瓨瀛楁
+   /// </summary>
+   [SugarColumn(ColumnName = "ZD_NUM")]
     public decimal? ZdNum { get; set; }
 
- /// <summary>
- ///     鏄惁鎺ㄩ�丒RP1-鏄紝2-鍚�
- /// </summary>
- [SugarColumn(ColumnName = "TS")]
+   /// <summary>
+   ///     鏄惁鎺ㄩ�丒RP1-鏄紝2-鍚�
+   /// </summary>
+   [SugarColumn(ColumnName = "TS")]
     public decimal? Ts { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/MesInvItemMovesCDetails.cs b/MES.Service/Modes/MesInvItemMovesCDetails.cs
index ec6b0c2..0a6d2cf 100644
--- a/MES.Service/Modes/MesInvItemMovesCDetails.cs
+++ b/MES.Service/Modes/MesInvItemMovesCDetails.cs
@@ -8,224 +8,225 @@
 [SugarTable("MES_INV_ITEM_MOVES_C_DETAILS")]
 public class MesInvItemMovesCDetails
 {
- /// <summary>
- ///     seq_inv_id
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+    /// <summary>
+    ///     seq_inv_id
+    /// </summary>
+    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
+        IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_MOVE_ID")]
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_MOVE_ID")]
     public decimal? ItemMoveId { get; set; }
 
- /// <summary>
- ///     鐗╂枡鏉$爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
-    public string ItemBarcode { get; set; }
+    /// <summary>
+    ///     鐗╂枡鏉$爜
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_BARCODE")]
+    public string? ItemBarcode { get; set; }
 
- /// <summary>
- ///     瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
-    public string CItemCode { get; set; }
+    /// <summary>
+    ///     瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級
+    /// </summary>
+    [SugarColumn(ColumnName = "C_ITEM_CODE")]
+    public string? CItemCode { get; set; }
 
- /// <summary>
- ///     淇″崕鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
-    public string ItemNo { get; set; }
+    /// <summary>
+    ///     淇″崕鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_NO")]
+    public string? ItemNo { get; set; }
 
- /// <summary>
- ///     鍘傚鎵规
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO")]
-    public string LotNo { get; set; }
+    /// <summary>
+    ///     鍘傚鎵规
+    /// </summary>
+    [SugarColumn(ColumnName = "LOT_NO")]
+    public string? LotNo { get; set; }
 
- /// <summary>
- ///     鏁伴噺锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
+    /// <summary>
+    ///     鏁伴噺锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級
+    /// </summary>
+    [SugarColumn(ColumnName = "QUANTITY")]
     public decimal? Quantity { get; set; }
 
- /// <summary>
- ///     鍑哄簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�)
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_FLAG")]
+    /// <summary>
+    ///     鍑哄簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�)
+    /// </summary>
+    [SugarColumn(ColumnName = "BARCODE_FLAG")]
     public short? BarcodeFlag { get; set; }
 
- /// <summary>
- ///     鐜繚鏍囧織锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "EP_FLAG")]
+    /// <summary>
+    ///     鐜繚鏍囧織锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級
+    /// </summary>
+    [SugarColumn(ColumnName = "EP_FLAG")]
     public short? EpFlag { get; set; }
 
- /// <summary>
- ///     鍒涘缓浜�
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
-    public string CreateBy { get; set; }
+    /// <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")]
-    public string LastupdateBy { get; set; }
+    /// <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 = "INV_DEPOTS_ID")]
+    /// <summary>
+    ///     瀛愬簱id
+    /// </summary>
+    [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
     public decimal? InvDepotsId { get; set; }
 
- /// <summary>
- ///     璐т綅id
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
+    /// <summary>
+    ///     璐т綅id
+    /// </summary>
+    [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
     public decimal? InvDepotSectionsId { get; set; }
 
- /// <summary>
- ///     瀹㈡埛缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "CUST_NO")]
-    public string CustNo { get; set; }
+    /// <summary>
+    ///     瀹㈡埛缂栫爜
+    /// </summary>
+    [SugarColumn(ColumnName = "CUST_NO")]
+    public string? CustNo { get; set; }
 
- /// <summary>
- ///     浠诲姟浠ゅ彿
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
-    public string TaskNo { get; set; }
+    /// <summary>
+    ///     浠诲姟浠ゅ彿
+    /// </summary>
+    [SugarColumn(ColumnName = "TASK_NO")]
+    public string? TaskNo { get; set; }
 
- /// <summary>
- ///     绉诲嚭浠撳簱缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
-    public string FromDepotsCode { get; set; }
+    /// <summary>
+    ///     绉诲嚭浠撳簱缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
+    public string? FromDepotsCode { get; set; }
 
- /// <summary>
- ///     绉诲嚭搴撲綅缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FROM_DEPOT_SECTIONS_CODE")]
-    public string FromDepotSectionsCode { get; set; }
+    /// <summary>
+    ///     绉诲嚭搴撲綅缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "FROM_DEPOT_SECTIONS_CODE")]
+    public string? FromDepotSectionsCode { get; set; }
 
- /// <summary>
- ///     鏉$爜澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
-    public string Remark { get; set; }
+    /// <summary>
+    ///     鏉$爜澶囨敞
+    /// </summary>
+    [SugarColumn(ColumnName = "REMARK")]
+    public string? Remark { get; set; }
 
- /// <summary>
- ///     鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
-    public string Factory { get; set; }
+    /// <summary>
+    ///     鍒嗗巶缂栫爜
+    /// </summary>
+    [SugarColumn(ColumnName = "FACTORY")]
+    public string? Factory { get; set; }
 
- /// <summary>
- ///     鍏徃浠g爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
-    public string Company { get; set; }
+    /// <summary>
+    ///     鍏徃浠g爜
+    /// </summary>
+    [SugarColumn(ColumnName = "COMPANY")]
+    public string? Company { get; set; }
 
- /// <summary>
- ///     绠卞彿
- /// </summary>
- [SugarColumn(ColumnName = "BOX_NO")]
-    public string BoxNo { get; set; }
+    /// <summary>
+    ///     绠卞彿
+    /// </summary>
+    [SugarColumn(ColumnName = "BOX_NO")]
+    public string? BoxNo { get; set; }
 
- /// <summary>
- ///     鍗℃澘鍙�
- /// </summary>
- [SugarColumn(ColumnName = "KO_NO")]
-    public string KoNo { get; set; }
+    /// <summary>
+    ///     鍗℃澘鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "KO_NO")]
+    public string? KoNo { get; set; }
 
- /// <summary>
- ///     绉诲叆浠撳簱缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
-    public string InvDepotsCode { get; set; }
+    /// <summary>
+    ///     绉诲叆浠撳簱缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
+    public string? InvDepotsCode { get; set; }
 
- /// <summary>
- ///     绉诲叆搴撲綅缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
-    public string InvDepotSectionsCode { get; set; }
+    /// <summary>
+    ///     绉诲叆搴撲綅缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
+    public string? InvDepotSectionsCode { get; set; }
 
- /// <summary>
- ///     璐ㄦ缁撴灉
- /// </summary>
- [SugarColumn(ColumnName = "IQC_STATUS")]
-    public string IqcStatus { get; set; }
+    /// <summary>
+    ///     璐ㄦ缁撴灉
+    /// </summary>
+    [SugarColumn(ColumnName = "IQC_STATUS")]
+    public string? IqcStatus { get; set; }
 
- /// <summary>
- ///     灏忚溅缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FCAR")]
-    public string Fcar { get; set; }
+    /// <summary>
+    ///     灏忚溅缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "FCAR")]
+    public string? Fcar { get; set; }
 
- /// <summary>
- ///     鍏ュ簱鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "INDEP_DATE")]
+    /// <summary>
+    ///     鍏ュ簱鏃ユ湡
+    /// </summary>
+    [SugarColumn(ColumnName = "INDEP_DATE")]
     public DateTime? IndepDate { get; set; }
 
- /// <summary>
- ///     鍐荤粨鎻愪氦閲嶆锛�0锛氬喕缁撴湭鎻愪氦閲嶆锛�1锛氬喕缁撳苟鎻愪氦閲嶆
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT")]
+    /// <summary>
+    ///     鍐荤粨鎻愪氦閲嶆锛�0锛氬喕缁撴湭鎻愪氦閲嶆锛�1锛氬喕缁撳苟鎻愪氦閲嶆
+    /// </summary>
+    [SugarColumn(ColumnName = "VISABLE_SUBMIT")]
     public short? VisableSubmit { get; set; }
 
- /// <summary>
- ///     鎻愪氦閲嶆浜�
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")]
-    public string VisableSubmitBy { get; set; }
+    /// <summary>
+    ///     鎻愪氦閲嶆浜�
+    /// </summary>
+    [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")]
+    public string? VisableSubmitBy { get; set; }
 
- /// <summary>
- ///     鎻愪氦閲嶆鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")]
+    /// <summary>
+    ///     鎻愪氦閲嶆鏃堕棿
+    /// </summary>
+    [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")]
     public DateTime? VisableSubmitDate { get; set; }
 
- /// <summary>
- ///     浜у搧鍨嬪彿
- /// </summary>
- [SugarColumn(ColumnName = "BOARD_STYLE")]
-    public string BoardStyle { get; set; }
+    /// <summary>
+    ///     浜у搧鍨嬪彿
+    /// </summary>
+    [SugarColumn(ColumnName = "BOARD_STYLE")]
+    public string? BoardStyle { get; set; }
 
- /// <summary>
- ///     浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
-    public string WorkNo { get; set; }
+    /// <summary>
+    ///     浠诲姟鍗曞彿
+    /// </summary>
+    [SugarColumn(ColumnName = "WORK_NO")]
+    public string? WorkNo { get; set; }
 
- /// <summary>
- ///     浠诲姟鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
+    /// <summary>
+    ///     浠诲姟鍗曡鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "WORK_LINE")]
     public decimal? WorkLine { get; set; }
 
- /// <summary>
- ///     渚涘簲鍟嗙紪鍙�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
-    public string SuppNo { get; set; }
+    /// <summary>
+    ///     渚涘簲鍟嗙紪鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "SUPP_NO")]
+    public string? SuppNo { get; set; }
 
- /// <summary>
- ///     璋冨叆
- /// </summary>
- [SugarColumn(ColumnName = "MOVE_OK")]
+    /// <summary>
+    ///     璋冨叆
+    /// </summary>
+    [SugarColumn(ColumnName = "MOVE_OK")]
     public decimal? MoveOk { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/MesInvItemStocks.cs b/MES.Service/Modes/MesInvItemStocks.cs
index a867ce8..2a5a4d1 100644
--- a/MES.Service/Modes/MesInvItemStocks.cs
+++ b/MES.Service/Modes/MesInvItemStocks.cs
@@ -19,25 +19,25 @@
     ///     鐢熶骇璁㈠崟
     /// </summary>
     [SugarColumn(ColumnName = "TASK_NO")]
-    public string TaskNo { get; set; }
+    public string? TaskNo { get; set; }
 
     /// <summary>
     ///     鐗╂枡鏉$爜
     /// </summary>
     [SugarColumn(ColumnName = "ITEM_BARCODE")]
-    public string ItemBarcode { get; set; }
+    public string? ItemBarcode { get; set; }
 
     /// <summary>
     ///     瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級
     /// </summary>
     [SugarColumn(ColumnName = "C_ITEM_CODE")]
-    public string CItemCode { get; set; }
+    public string? CItemCode { get; set; }
 
     /// <summary>
     ///     鏈徃鐗╂枡缂栫爜锛堟棤鏉$爜鎵嬪伐褰曞叆锛屾湁鏉$爜涓哄啑浣欏瓧娈碉級
     /// </summary>
     [SugarColumn(ColumnName = "ITEM_NO")]
-    public string ItemNo { get; set; }
+    public string? ItemNo { get; set; }
 
     /// <summary>
     ///     瀛愬簱id
@@ -55,7 +55,7 @@
     ///     鍘傚鎵规
     /// </summary>
     [SugarColumn(ColumnName = "LOT_NO")]
-    public string LotNo { get; set; }
+    public string? LotNo { get; set; }
 
     /// <summary>
     ///     鏁伴噺
@@ -73,7 +73,7 @@
     ///     瀹㈡埛缂栫爜
     /// </summary>
     [SugarColumn(ColumnName = "CUSTOMER_NO")]
-    public string CustomerNo { get; set; }
+    public string? CustomerNo { get; set; }
 
     /// <summary>
     ///     閲嶉噺
@@ -85,13 +85,13 @@
     ///     瀛愬簱CODE
     /// </summary>
     [SugarColumn(ColumnName = "DEPOTS_CODE")]
-    public string DepotsCode { get; set; }
+    public string? DepotsCode { get; set; }
 
     /// <summary>
     ///     璐т綅CODE
     /// </summary>
     [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")]
-    public string DepotSectionsCode { get; set; }
+    public string? DepotSectionsCode { get; set; }
 
     /// <summary>
     ///     妫�楠屾棩鏈�
@@ -115,25 +115,25 @@
     ///     宸ュ巶缂栧彿
     /// </summary>
     [SugarColumn(ColumnName = "FACTORY")]
-    public string Factory { get; set; }
+    public string? Factory { get; set; }
 
     /// <summary>
     ///     鍏徃缂栧彿
     /// </summary>
     [SugarColumn(ColumnName = "COMPANY")]
-    public string Company { get; set; }
+    public string? Company { get; set; }
 
     /// <summary>
     ///     璐ㄦ鐘舵��
     /// </summary>
     [SugarColumn(ColumnName = "IQC_STATUS")]
-    public string IqcStatus { get; set; }
+    public string? IqcStatus { get; set; }
 
     /// <summary>
     ///     灏忚溅鏉$爜
     /// </summary>
     [SugarColumn(ColumnName = "FCAR")]
-    public string Fcar { get; set; }
+    public string? Fcar { get; set; }
 
     /// <summary>
     ///     鍐荤粨鎻愪氦閲嶆锛�0锛氬喕缁撴湭鎻愪氦閲嶆锛�1锛氬喕缁撳苟鎻愪氦閲嶆
@@ -145,7 +145,7 @@
     ///     鎻愪氦閲嶆浜�
     /// </summary>
     [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")]
-    public string VisableSubmitBy { get; set; }
+    public string? VisableSubmitBy { get; set; }
 
     /// <summary>
     ///     鎻愪氦閲嶆鏃堕棿
@@ -157,13 +157,13 @@
     ///     浜у搧鍨嬪彿
     /// </summary>
     [SugarColumn(ColumnName = "BOARD_STYLE")]
-    public string BoardStyle { get; set; }
+    public string? BoardStyle { get; set; }
 
     /// <summary>
     ///     浠诲姟鍗曞彿
     /// </summary>
     [SugarColumn(ColumnName = "WORK_NO")]
-    public string WorkNo { get; set; }
+    public string? WorkNo { get; set; }
 
     /// <summary>
     ///     浠诲姟鍗曡鍙�
@@ -175,19 +175,19 @@
     ///     渚涘簲鍟�
     /// </summary>
     [SugarColumn(ColumnName = "SUPP_NO")]
-    public string SuppNo { get; set; }
+    public string? SuppNo { get; set; }
 
     /// <summary>
     ///     鐢熶骇绾�
     /// </summary>
     [SugarColumn(ColumnName = "LINE_NO")]
-    public string LineNo { get; set; }
+    public string? LineNo { get; set; }
 
     /// <summary>
     ///     鍗婃垚鍝佸叆搴撳崟鍙�
     /// </summary>
     [SugarColumn(ColumnName = "BILL_NO")]
-    public string BillNo { get; set; }
+    public string? BillNo { get; set; }
 
     /// <summary>
     ///     閲囪喘璁㈠崟id
diff --git a/MES.Service/Modes/MesQaItemsDetect01.cs b/MES.Service/Modes/MesQaItemsDetect01.cs
index 2a26d0c..14760fb 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/MesQaItemsDetectDetail5.cs b/MES.Service/Modes/MesQaItemsDetectDetail5.cs
index d6159cc..68ee666 100644
--- a/MES.Service/Modes/MesQaItemsDetectDetail5.cs
+++ b/MES.Service/Modes/MesQaItemsDetectDetail5.cs
@@ -8,167 +8,167 @@
 [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")]
 public class MesQaItemsDetectDetail5
 {
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+   /// <summary>
+   /// </summary>
+   [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
- /// <summary>
- ///     鏍囧噯鍊肩被鍨�
- /// </summary>
- [SugarColumn(ColumnName = "FTEXT_TYPE")]
+   /// <summary>
+   ///     鏍囧噯鍊肩被鍨�
+   /// </summary>
+   [SugarColumn(ColumnName = "FTEXT_TYPE")]
     public string FtextType { get; set; }
 
- /// <summary>
- ///     鏍囧噯鍊�
- /// </summary>
- [SugarColumn(ColumnName = "FSTAND")]
+   /// <summary>
+   ///     鏍囧噯鍊�
+   /// </summary>
+   [SugarColumn(ColumnName = "FSTAND")]
     public decimal? Fstand { get; set; }
 
- /// <summary>
- ///     涓婂叕宸�
- /// </summary>
- [SugarColumn(ColumnName = "FUP_ALLOW")]
+   /// <summary>
+   ///     涓婂叕宸�
+   /// </summary>
+   [SugarColumn(ColumnName = "FUP_ALLOW")]
     public string FupAllow { get; set; }
 
- /// <summary>
- ///     涓嬪叕宸�
- /// </summary>
- [SugarColumn(ColumnName = "FDOWN_ALLOW")]
+   /// <summary>
+   ///     涓嬪叕宸�
+   /// </summary>
+   [SugarColumn(ColumnName = "FDOWN_ALLOW")]
     public string FdownAllow { 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 = "FCHECK_ITEM")]
+   /// <summary>
+   ///     妫�楠岄」鐩�
+   /// </summary>
+   [SugarColumn(ColumnName = "FCHECK_ITEM")]
     public string FcheckItem { get; set; }
 
- /// <summary>
- ///     瑙勬牸瑕佹眰
- /// </summary>
- [SugarColumn(ColumnName = "FSPEC_REQU")]
+   /// <summary>
+   ///     瑙勬牸瑕佹眰
+   /// </summary>
+   [SugarColumn(ColumnName = "FSPEC_REQU")]
     public string FspecRequ { get; set; }
 
- /// <summary>
- ///     鎶芥鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_QYT")]
+   /// <summary>
+   ///     鎶芥鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "CHECK_QYT")]
     public decimal? CheckQyt { get; set; }
 
- /// <summary>
- ///     妫�楠岀粨鏋�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_RESU")]
+   /// <summary>
+   ///     妫�楠岀粨鏋�
+   /// </summary>
+   [SugarColumn(ColumnName = "FCHECK_RESU")]
     public string FcheckResu { get; set; }
 
- /// <summary>
- ///     AC鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "FAC_QTY")]
+   /// <summary>
+   ///     AC鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "FAC_QTY")]
     public decimal? FacQty { get; set; }
 
- /// <summary>
- ///     RE鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "FRE_QTY")]
+   /// <summary>
+   ///     RE鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "FRE_QTY")]
     public decimal? FreQty { get; set; }
 
- /// <summary>
- ///     涓嶅悎鏍兼暟
- /// </summary>
- [SugarColumn(ColumnName = "FNG_QTY")]
+   /// <summary>
+   ///     涓嶅悎鏍兼暟
+   /// </summary>
+   [SugarColumn(ColumnName = "FNG_QTY")]
     public decimal? FngQty { get; set; }
 
- /// <summary>
- ///     涓嶈壇鐜�
- /// </summary>
- [SugarColumn(ColumnName = "FNG_RATE")]
+   /// <summary>
+   ///     涓嶈壇鐜�
+   /// </summary>
+   [SugarColumn(ColumnName = "FNG_RATE")]
     public decimal? FngRate { get; set; }
 
- /// <summary>
- ///     宸插綍鍏ユ暟閲�
- /// </summary>
- [SugarColumn(ColumnName = "FENTER_QTY")]
+   /// <summary>
+   ///     宸插綍鍏ユ暟閲�
+   /// </summary>
+   [SugarColumn(ColumnName = "FENTER_QTY")]
     public decimal? FenterQty { get; set; }
 
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "RELEASE_NO")]
+   /// <summary>
+   /// </summary>
+   [SugarColumn(ColumnName = "RELEASE_NO")]
     public string ReleaseNo { get; set; }
 
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
+   /// <summary>
+   /// </summary>
+   [SugarColumn(ColumnName = "COMPANY")]
     public string Company { get; set; }
 
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
+   /// <summary>
+   /// </summary>
+   [SugarColumn(ColumnName = "FACTORY")]
     public string Factory { get; set; }
 
- /// <summary>
- ///     妫�楠岄」鐩弿杩�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")]
+   /// <summary>
+   ///     妫�楠岄」鐩弿杩�
+   /// </summary>
+   [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")]
     public string FcheckItemDesc { get; set; }
 
- /// <summary>
- ///     宸ュ簭鍙�
- /// </summary>
- [SugarColumn(ColumnName = "PROC_NO")]
+   /// <summary>
+   ///     宸ュ簭鍙�
+   /// </summary>
+   [SugarColumn(ColumnName = "PROC_NO")]
     public string ProcNo { get; set; }
 
- /// <summary>
- ///     宸ヤ綔涓績缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
+   /// <summary>
+   ///     宸ヤ綔涓績缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
     public string WorkshopCenterCode { get; set; }
 
- /// <summary>
- ///     鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "FUNIT")]
+   /// <summary>
+   ///     鍗曚綅
+   /// </summary>
+   [SugarColumn(ColumnName = "FUNIT")]
     public string Funit { get; set; }
 
- /// <summary>
- ///     鐗瑰畾淇敼
- /// </summary>
- [SugarColumn(ColumnName = "GIVEN_MODIFY")]
+   /// <summary>
+   ///     鐗瑰畾淇敼
+   /// </summary>
+   [SugarColumn(ColumnName = "GIVEN_MODIFY")]
     public short? GivenModify { get; set; }
 
- /// <summary>
- ///     妫�楠屽伐鍏�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_TOOL")]
+   /// <summary>
+   ///     妫�楠屽伐鍏�
+   /// </summary>
+   [SugarColumn(ColumnName = "FCHECK_TOOL")]
     public string FcheckTool { 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; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/Purdhb.cs b/MES.Service/Modes/Purdhb.cs
index 7fff6ee..b8de0cc 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 1c3ea40..4330c13 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/service/Warehouse/MesInvItemMovesManager.cs b/MES.Service/service/Warehouse/MesInvItemMovesManager.cs
index 59d36c3..a529385 100644
--- a/MES.Service/service/Warehouse/MesInvItemMovesManager.cs
+++ b/MES.Service/service/Warehouse/MesInvItemMovesManager.cs
@@ -1,6 +1,7 @@
 锘縰sing MES.Service.DB;
 using MES.Service.Dto.service;
 using MES.Service.Modes;
+using MES.Service.util;
 using SqlSugar;
 
 namespace MES.Service.service.Warehouse;
@@ -25,6 +26,193 @@
             .OrderBy(it => it.Id, OrderByType.Desc).ToList();
     }
 
+
+    public OutItemDto ScanMoveBarcode(WarehouseQuery query)
+    {
+        var BillTypeId = 300;
+        var TransctionNo = 301;
+        query.Factory = "1000";
+        query.Company = "1000";
+
+        if (string.IsNullOrEmpty(query.billNo)) throw new Exception("璇烽�夊崟鎹彿锛�");
+
+        var mesInvItemStocks = Db.Queryable<MesInvItemStocks>()
+            .Where(s => s.ItemBarcode == query.barcode &&
+                        s.Quantity > 0 && s.DepotsCode != null).First();
+        if (mesInvItemStocks == null)
+            throw new Exception("搴撳瓨涓棤姝ゆ潯鐮侊紝璇锋牳瀵癸紒" + query.barcode);
+
+        var mesInvItemMoves = Db.Queryable<MesInvItemMoves>()
+            .Where(d => d.TransactionNo == TransctionNo
+                        && SqlFunc.IsNull(d.Status, 0) == 1).First();
+
+        if (mesInvItemMoves == null)
+            throw new Exception("鍑哄簱鍗� " + query.billNo + "涓嶅瓨鍦紝璇风‘璁わ紒");
+
+        var count = Db.Queryable<MesInvItemMoves, MesInvItemMovesCDetails>(
+                (a, b) =>
+                    new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId))
+            .Where((a, b) => b.ItemBarcode == query.barcode
+                             && a.TransactionNo == TransctionNo &&
+                             SqlFunc.IsNull(a.Status, 0) == 0).Count();
+        if (count > 0) throw new Exception("鏉$爜閲嶅鎵弿锛岃鏍稿锛�");
+
+        count = Db.Queryable<MesInvItemMoves, MesInvItemMovesCDetails>((a, b) =>
+                new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId))
+            .Where((a, b) => b.ItemBarcode == query.barcode
+                             && a.TransactionNo == TransctionNo &&
+                             SqlFunc.IsNull(b.MoveOk, 0) == 0).Count();
+
+        if (count > 0) throw new Exception("鏉$爜閲嶅鎵弿锛岃鏍稿锛�");
+
+        if (mesInvItemMoves.FromDepotsCode != mesInvItemStocks.DepotsCode)
+            throw new Exception("鏉$爜鐜板瓨浠撳簱涓庣敵璇峰嚭璐т粨搴撲笉涓�鑷达紝璇锋牳瀵癸紒");
+
+        var quantity = Db.Queryable<MesInvItemOutItems>()
+            .Where(b => b.ItemNo == mesInvItemStocks.ItemNo
+                        && b.ItemOutId == mesInvItemMoves.Id)
+            .Sum(b => b.Quantity);
+
+        if (quantity == null)
+            throw new Exception("鎵爜鐗╂枡闈炴湰娆$敵璇风墿鏂欙紝璇锋牳瀵癸紒" + query.barcode);
+
+        var sum = Db.Queryable<MesInvItemMovesCDetails>()
+            .Where(b => b.ItemNo == mesInvItemStocks.ItemNo
+                        && b.ItemMoveId == mesInvItemMoves.Id)
+            .Sum(b => b.Quantity) ?? 0;
+
+        var sumqty = sum + (mesInvItemStocks.Quantity ?? 0);
+
+        if (sumqty > quantity)
+            throw new Exception(
+                "宸叉壂鏉$爜鏁伴噺鎴栨湰娆℃壂鐮佹暟閲忥細" + sumqty + " 澶т簬鐢宠鏁伴噺锛�" + quantity + "锛岃鏍稿锛�");
+
+        List<InventoryItem> scanOutShowDb = null;
+
+        UseTransaction(db =>
+        {
+            SaveMesInvItemMovesCDetails(db, query, mesInvItemMoves,
+                mesInvItemStocks);
+
+            // Insert into mes_inv_business2
+            SaveMesInvBusiness2(db, query, BillTypeId, TransctionNo,
+                mesInvItemStocks, mesInvItemMoves);
+
+            if (TransctionNo == 303)
+                db.Updateable<MesInvItemStocks>()
+                    .SetColumns(s =>
+                        s.DepotSectionsCode == mesInvItemMoves.InvDepotsCode)
+                    .SetColumns(s =>
+                        s.DepotsCode == mesInvItemMoves.InvDepotsCode)
+                    .Where(s => s.Id == mesInvItemStocks.Id)
+                    .ExecuteCommand();
+            else
+                db.Updateable<MesInvItemStocks>()
+                    .SetColumns(s => s.DepotSectionsCode == null)
+                    .SetColumns(s => s.DepotsCode == null)
+                    .Where(s => s.Id == mesInvItemStocks.Id)
+                    .ExecuteCommand();
+
+            scanOutShowDb = ScanOutShowDb(query);
+            if (CollectionUtil.IsNullOrEmpty(scanOutShowDb))
+                db.Updateable<MesInvItemMoves>()
+                    .SetColumns(s => s.Status == 1)
+                    .SetColumns(s => s.Checkdate == DateTime.Now)
+                    .SetColumns(s => s.Checkuser == query.userName)
+                    .Where(s => s.BillNo == query.billNo).ExecuteCommand();
+
+            return 1;
+        });
+
+        var itemDto = new OutItemDto();
+        itemDto.SumItem = scanOutShowDb;
+
+        if (TransctionNo == 201) itemDto.Quantity = mesInvItemStocks.Quantity;
+
+        itemDto.ItemNo = mesInvItemStocks.ItemNo;
+
+        return itemDto;
+    }
+
+    private void SaveMesInvBusiness2(SqlSugarScope Db, WarehouseQuery query,
+        int BillTypeId,
+        int TransctionNo, MesInvItemStocks mesInvItemStocks,
+        MesInvItemMoves mesInvItemMoves)
+    {
+        var executeCommand = Db.Insertable(new MesInvBusiness2
+        {
+            Status = 1,
+            BillTypeId = BillTypeId,
+            TransactionCode = TransctionNo.ToString(),
+            BusinessType = 1,
+            ItemBarcode = query.barcode,
+            ItemNo = mesInvItemStocks.ItemNo,
+            LotNo = mesInvItemStocks.LotNo,
+            EpFlag = 1,
+            Quantity = mesInvItemStocks.Quantity,
+            FromInvDepotsCode = mesInvItemStocks.DepotsCode,
+            FromInvDepotSectionsCode = mesInvItemStocks.DepotSectionsCode,
+            ToInvDepotsCode = TransctionNo == 303
+                ? mesInvItemMoves.InvDepotsCode
+                : null,
+            ToInvDepotSectionsCode = TransctionNo == 303
+                ? mesInvItemMoves.InvDepotsCode
+                : null,
+            CreateBy = query.userName,
+            CreateDate = DateTime.Now,
+            LastupdateBy = query.userName,
+            LastupdateDate = DateTime.Now,
+            Factory = query.Factory,
+            Company = query.Company,
+            TaskNo = mesInvItemStocks.TaskNo,
+            BillNo = query.billNo,
+            WorkNo = mesInvItemStocks.WorkNo,
+            WorkLine = mesInvItemStocks.WorkLine,
+            SuppNo = mesInvItemStocks.SuppNo
+        }).ExecuteCommand();
+
+        if (executeCommand <= 0) throw new Exception("鍐欏叆MesInvBusiness2琛ㄥけ璐�");
+    }
+
+    private void SaveMesInvItemMovesCDetails(SqlSugarScope Db,
+        WarehouseQuery query,
+        MesInvItemMoves mesInvItemMoves, MesInvItemStocks mesInvItemStocks)
+    {
+        var executeCommand = Db.Insertable(new MesInvItemMovesCDetails
+        {
+            ItemMoveId = mesInvItemMoves.Id,
+            ItemBarcode = query.barcode,
+            CItemCode = mesInvItemStocks.CItemCode,
+            ItemNo = mesInvItemStocks.ItemNo,
+            LotNo = mesInvItemStocks.LotNo,
+            Quantity = mesInvItemStocks.Quantity,
+            EpFlag = mesInvItemStocks.EpFlag,
+            CreateBy = query.userName,
+            CreateDate = DateTime.Now,
+            LastupdateBy = query.userName,
+            LastupdateDate = DateTime.Now,
+            CustNo = mesInvItemStocks.CustomerNo,
+            TaskNo = mesInvItemStocks.TaskNo,
+            FromDepotsCode = mesInvItemStocks.DepotsCode,
+            FromDepotSectionsCode = mesInvItemStocks.DepotSectionsCode,
+            Factory = mesInvItemStocks.Factory,
+            Company = mesInvItemStocks.Company,
+            IqcStatus = mesInvItemStocks.IqcStatus,
+            Fcar = mesInvItemStocks.Fcar,
+            IndepDate = mesInvItemStocks.IndepDate,
+            VisableSubmit = mesInvItemStocks.VisableSubmit,
+            VisableSubmitBy = mesInvItemStocks.VisableSubmitBy,
+            VisableSubmitDate = mesInvItemStocks.VisableSubmitDate,
+            BoardStyle = mesInvItemStocks.BoardStyle,
+            WorkNo = mesInvItemStocks.WorkNo,
+            WorkLine = mesInvItemStocks.WorkLine,
+            SuppNo = mesInvItemStocks.SuppNo
+        }).ExecuteCommand();
+
+        if (executeCommand <= 0)
+            throw new Exception("鍐欏叆MesInvItemMovesCDetails琛ㄥけ璐�");
+    }
+
     //scan_out_show_DB
     public List<InventoryItem> ScanOutShowDb(WarehouseQuery query)
     {
@@ -33,6 +221,8 @@
         query.Factory = "1000";
         query.Company = "1000";
 
+        if (string.IsNullOrEmpty(query.billNo)) throw new Exception("璇烽�夊崟鎹彿锛�");
+
         var sql = string.Format(
             "select f_get_sections_code({0}, {1}, b.item_no)                       sections_code , s.erp_item_no , S.ITEM_MODEL , to_char(nvl(b.quantity, 0) - nvl(quantity_ok, 0), 'FM9999999990.00') flist from mes_inv_item_moves a join mes_inv_item_out_items b on b.item_out_id = a.id join mes_items s on b.item_no = s.item_no left join (select ITEM_MOVE_ID, item_no, sum(quantity) quantity_ok             from MES_INV_ITEM_MOVES_C_DETAILS group by ITEM_MOVE_ID, item_no) c                    on c.ITEM_MOVE_ID = a.id and b.item_no = c.item_no where 1 = 1 and a.bill_type_id = {2} and a.transaction_no = {3} and a.bill_no = {4} and nvl(b.quantity, 0) - nvl(quantity_ok, 0) > 0   and rownum < 500   AND A.STATUS = 1 order by f_get_sections_code({0}, {1}, b.item_no), s.erp_item_no ",
             query.Factory, query.Company, BillTypeId, TransctionNo,
diff --git a/MES.Service/util/CollectionUtil.cs b/MES.Service/util/CollectionUtil.cs
index 0652cd3..267fcd4 100644
--- a/MES.Service/util/CollectionUtil.cs
+++ b/MES.Service/util/CollectionUtil.cs
@@ -8,7 +8,7 @@
      */
     public static bool IsNullOrEmpty<T>(List<T> list)
     {
-        return list == null || !list.Any();
+        return list == null || list.Count == 0;
     }
 
     /**
diff --git a/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs b/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs
index d8106fb..8a5d626 100644
--- a/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs
+++ b/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs
@@ -13,6 +13,27 @@
 {
     private readonly MesInvItemMovesManager m = new();
 
+    //ScanMoveBarcode
+    [HttpPost("ScanMoveBarcode")]
+    public ResponseResult ScanMoveBarcode(WarehouseQuery query)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.ScanMoveBarcode(query);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
     // GetBillNo
     [HttpPost("GetBillNo")]
     public ResponseResult GetBillNo(WarehouseQuery query)
@@ -33,7 +54,7 @@
             return ResponseResult.ResponseError(ex);
         }
     }
-    
+
     //ScanOutShowDb
     [HttpPost("ScanOutShowDb")]
     public ResponseResult ScanOutShowDb(WarehouseQuery query)

--
Gitblit v1.9.3