From 372d77eb2d8932a58da206965b30d9aca72fe15b Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期四, 15 八月 2024 10:05:00 +0800
Subject: [PATCH] aa

---
 MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs           |   79 +
 MES.Service/service/BasicData/MesStaffManager.cs                          |    2 
 MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs |  163 ++
 MES.Service/service/Warehouse/MesInvItemMovesManager.cs                   |   45 
 MES.Service/Modes/MesInvItemBarcodes.cs                                   |  600 ++++----
 MES.Service/Modes/MesInvItemInCItems.cs                                   |  184 +-
 MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs         |  204 ++
 MES.Service/Modes/Purdhb.cs                                               |  352 ++--
 MES.Service/service/QC/MesQaItemsDetectDetail5Manager.cs                  |   97 
 MES.Service/Modes/MesInvItemArn.cs                                        |  304 ++--
 MES.Service/service/Warehouse/MesInvBusiness2Manager.cs                   |   94 
 MES.Service/service/Warehouse/OpeningReceiptServer.cs                     |   37 
 MES.Service/service/Warehouse/MesDepotSectionsManager.cs                  |   45 
 MES.Service/Modes/Purdka.cs                                               |  160 +-
 MES.Service/Modes/MesInvItemMovesCDetails.cs                              |  231 +++
 MESApplication/Controllers/Warehouse/OpeningReceiptController.cs          |    2 
 MES.Service/Modes/MesInvItemMoves.cs                                      |  178 ++
 MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs               |   10 
 MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs         |  308 ++--
 MES.Service/Modes/MesQaItemsDetect01.cs                                   |  422 ++--
 MES.Service/Modes/MesInvBusiness2.cs                                      |  419 +++--
 MES.Service/Modes/MesInvItemStocks.cs                                     |    2 
 MES.Service/Modes/MesQaItemsDetectDetail5.cs                              |  326 ++--
 MES.Service/Modes/MesInvItemInCDetails.cs                                 |    3 
 MES.Service/Dto/service/InventoryItem.cs                                  |    8 
 MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs        |   42 
 MES.Service/Dto/service/WarehouseQuery.cs                                 |    4 
 27 files changed, 2,661 insertions(+), 1,660 deletions(-)

diff --git a/MES.Service/Dto/service/InventoryItem.cs b/MES.Service/Dto/service/InventoryItem.cs
index ca5767f..2d4a948 100644
--- a/MES.Service/Dto/service/InventoryItem.cs
+++ b/MES.Service/Dto/service/InventoryItem.cs
@@ -16,4 +16,12 @@
 
     [SugarColumn(ColumnName = "QTY")]
     public decimal Qty { get; set; } // 浣跨敤 decimal 鏉ヨ〃绀烘暟閲�
+
+    [SugarColumn(ColumnName = "sections_code")]
+    public string SectionsCode { get; set; }
+
+    [SugarColumn(ColumnName = "erp_item_no")]
+    public string ErpItemNo { get; set; }
+
+    [SugarColumn(ColumnName = "flist")] public string Flist { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Dto/service/WarehouseQuery.cs b/MES.Service/Dto/service/WarehouseQuery.cs
index ea3e707..b3f0734 100644
--- a/MES.Service/Dto/service/WarehouseQuery.cs
+++ b/MES.Service/Dto/service/WarehouseQuery.cs
@@ -19,4 +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 82f13d9..89ddce5 100644
--- a/MES.Service/Modes/MesInvBusiness2.cs
+++ b/MES.Service/Modes/MesInvBusiness2.cs
@@ -1,194 +1,227 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.Linq;
-using SqlSugar;
-namespace MES.Service.Modes
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+///     搴撳瓨浜ゆ槗璁板綍琛�
+/// </summary>
+[SugarTable("MES_INV_BUSINESS2")]
+public class MesInvBusiness2
 {
-    /// <summary>
-    /// 搴撳瓨浜ゆ槗璁板綍琛�
-    ///</summary>
-    [SugarTable("MES_INV_BUSINESS2")]
-    public class MesInvBusiness2
-    {
-        /// <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"    )]
-         public decimal? Status { get; set; }
-        /// <summary>
-        /// 鍗曟嵁绫诲瀷ID 
-        ///</summary>
-         [SugarColumn(ColumnName="BILL_TYPE_ID"    )]
-         public decimal? BillTypeId { get; set; }
-        /// <summary>
-        /// 浜嬪姟绫诲瀷缂栫爜 
-        ///</summary>
-         [SugarColumn(ColumnName="TRANSACTION_CODE"    )]
-         public string TransactionCode { get; set; }
-        /// <summary>
-        /// 浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱 
-        ///</summary>
-         [SugarColumn(ColumnName="BUSINESS_TYPE"    )]
-         public decimal? BusinessType { get; set; }
-        /// <summary>
-        /// 鍗曟嵁ID 
-        ///</summary>
-         [SugarColumn(ColumnName="BILL_ID"    )]
-         public decimal? BillId { get; set; }
-        /// <summary>
-        /// 鍗曟嵁缂栫爜 
-        ///</summary>
-         [SugarColumn(ColumnName="BILL_NO"    )]
-         public string BillNo { get; set; }
-        /// <summary>
-        /// 鐢熶骇璁㈠崟鍙� 
-        ///</summary>
-         [SugarColumn(ColumnName="TASK_NO"    )]
-         public string TaskNo { get; set; }
-        /// <summary>
-        /// 瀹㈡埛缂栧彿 
-        ///</summary>
-         [SugarColumn(ColumnName="CUSTOMER_NO"    )]
-         public string CustomerNo { get; set; }
-        /// <summary>
-        /// 鍗曟嵁琛孖D 
-        ///</summary>
-         [SugarColumn(ColumnName="BILL_LINE_ID"    )]
-         public decimal? BillLineId { get; set; }
-        /// <summary>
-        /// 鐗╂枡鏉$爜 
-        ///</summary>
-         [SugarColumn(ColumnName="ITEM_BARCODE"    )]
-         public string ItemBarcode { get; set; }
-        /// <summary>
-        /// 鏈徃鐗╂枡缂栫爜 
-        ///</summary>
-         [SugarColumn(ColumnName="ITEM_NO"    )]
-         public string ItemNo { get; set; }
-        /// <summary>
-        /// 瀹㈡埛鐗╂枡缂栫爜 
-        ///</summary>
-         [SugarColumn(ColumnName="C_ITEM_CODE"    )]
-         public string CItemCode { get; set; }
-        /// <summary>
-        /// 鍘傚鎵规 
-        ///</summary>
-         [SugarColumn(ColumnName="LOT_NO"    )]
-         public string LotNo { get; set; }
-        /// <summary>
-        /// 鏄惁鐜繚(0:鍚�,1:鏄�) 
-        ///</summary>
-         [SugarColumn(ColumnName="EP_FLAG"    )]
-         public short? EpFlag { get; set; }
-        /// <summary>
-        /// 鏁伴噺 
-        ///</summary>
-         [SugarColumn(ColumnName="QUANTITY"    )]
-         public decimal? Quantity { get; set; }
-        /// <summary>
-        /// 婧愬瓙搴揅ODE 
-        ///</summary>
-         [SugarColumn(ColumnName="FROM_INV_DEPOTS_CODE"    )]
-         public string FromInvDepotsCode { get; set; }
-        /// <summary>
-        /// 婧愯揣浣岰ODE 
-        ///</summary>
-         [SugarColumn(ColumnName="FROM_INV_DEPOT_SECTIONS_CODE"    )]
-         public string FromInvDepotSectionsCode { get; set; }
-        /// <summary>
-        /// 鐩殑瀛愬簱CODE 
-        ///</summary>
-         [SugarColumn(ColumnName="TO_INV_DEPOTS_CODE"    )]
-         public string ToInvDepotsCode { get; set; }
-        /// <summary>
-        /// 鐩殑璐т綅CODE 
-        ///</summary>
-         [SugarColumn(ColumnName="TO_INV_DEPOT_SECTIONS_CODE"    )]
-         public string ToInvDepotSectionsCode { get; set; }
-        /// <summary>
-        /// 浜ゆ槗寮傚父淇℃伅 
-        ///</summary>
-         [SugarColumn(ColumnName="DESCRIPTION"    )]
-         public string Description { get; set; }
-        /// <summary>
-        /// 鍒涘缓浜� 
-        ///</summary>
-         [SugarColumn(ColumnName="CREATE_BY"    )]
-         public string CreateBy { get; set; }
-        /// <summary>
-        /// 鍒涘缓鏃堕棿 
-        ///</summary>
-         [SugarColumn(ColumnName="CREATE_DATE"    )]
-         public DateTime? CreateDate { get; set; }
-        /// <summary>
-        /// 鏈�鍚庢洿鏂颁汉 
-        ///</summary>
-         [SugarColumn(ColumnName="LASTUPDATE_BY"    )]
-         public string LastupdateBy { get; set; }
-        /// <summary>
-        /// 鏈�鍚庢洿鏂版椂闂� 
-        ///</summary>
-         [SugarColumn(ColumnName="LASTUPDATE_DATE"    )]
-         public DateTime? LastupdateDate { get; set; }
-        /// <summary>
-        /// 瓒呮崯缁熻鏍囪瘑 
-        ///</summary>
-         [SugarColumn(ColumnName="ULLAGE_STAT_FLAG"    )]
-         public short? UllageStatFlag { get; set; }
-        /// <summary>
-        /// 鍒嗗巶缂栫爜 
-        ///</summary>
-         [SugarColumn(ColumnName="FACTORY"    )]
-         public string Factory { get; set; }
-        /// <summary>
-        /// 鍏徃浠g爜 
-        ///</summary>
-         [SugarColumn(ColumnName="COMPANY"    )]
-         public string Company { get; set; }
-        /// <summary>
-        /// 绠卞彿鏉$爜 
-        ///</summary>
-         [SugarColumn(ColumnName="ITEM_BARCODE2"    )]
-         public string ItemBarcode2 { get; set; }
-        /// <summary>
-        /// 鍗℃澘鏉$爜 
-        ///</summary>
-         [SugarColumn(ColumnName="ITEM_BARCODE3"    )]
-         public string ItemBarcode3 { get; set; }
-        /// <summary>
-        /// 浠诲姟鍗曞彿 
-        ///</summary>
-         [SugarColumn(ColumnName="WORK_NO"    )]
-         public string WorkNo { get; set; }
-        /// <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="LINE_NO"    )]
-         public string LineNo { get; set; }
-        /// <summary>
-        /// 閲囪喘璁㈠崟id 
-        ///</summary>
-         [SugarColumn(ColumnName="EBELN_K3ID"    )]
-         public decimal? EbelnK3id { get; set; }
-        /// <summary>
-        /// 閲囪喘璁㈠崟琛宨d 
-        ///</summary>
-         [SugarColumn(ColumnName="LINE_K3ID"    )]
-         public decimal? LineK3id { get; set; }
-    }
-}
+ /// <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")]
+    public decimal? Status { get; set; }
+
+ /// <summary>
+ ///     鍗曟嵁绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+    public decimal? BillTypeId { get; set; }
+
+ /// <summary>
+ ///     浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_CODE")]
+    public string TransactionCode { get; set; }
+
+ /// <summary>
+ ///     浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱
+ /// </summary>
+ [SugarColumn(ColumnName = "BUSINESS_TYPE")]
+    public decimal? BusinessType { get; set; }
+
+ /// <summary>
+ ///     鍗曟嵁ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_ID")]
+    public decimal? BillId { get; set; }
+
+ /// <summary>
+ ///     鍗曟嵁缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
+    public string BillNo { get; set; }
+
+ /// <summary>
+ ///     鐢熶骇璁㈠崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "TASK_NO")]
+    public string TaskNo { get; set; }
+
+ /// <summary>
+ ///     瀹㈡埛缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUSTOMER_NO")]
+    public string CustomerNo { get; set; }
+
+ /// <summary>
+ ///     鍗曟嵁琛孖D
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_LINE_ID")]
+    public decimal? BillLineId { get; set; }
+
+ /// <summary>
+ ///     鐗╂枡鏉$爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE")]
+    public string ItemBarcode { get; set; }
+
+ /// <summary>
+ ///     鏈徃鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
+    public string ItemNo { get; set; }
+
+ /// <summary>
+ ///     瀹㈡埛鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "C_ITEM_CODE")]
+    public string CItemCode { get; set; }
+
+ /// <summary>
+ ///     鍘傚鎵规
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO")]
+    public string LotNo { get; set; }
+
+ /// <summary>
+ ///     鏄惁鐜繚(0:鍚�,1:鏄�)
+ /// </summary>
+ [SugarColumn(ColumnName = "EP_FLAG")]
+    public short? EpFlag { get; set; }
+
+ /// <summary>
+ ///     鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "QUANTITY")]
+    public decimal? Quantity { get; set; }
+
+ /// <summary>
+ ///     婧愬瓙搴揅ODE
+ /// </summary>
+ [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")]
+    public string FromInvDepotsCode { get; set; }
+
+ /// <summary>
+ ///     婧愯揣浣岰ODE
+ /// </summary>
+ [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")]
+    public string FromInvDepotSectionsCode { get; set; }
+
+ /// <summary>
+ ///     鐩殑瀛愬簱CODE
+ /// </summary>
+ [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")]
+    public string ToInvDepotsCode { get; set; }
+
+ /// <summary>
+ ///     鐩殑璐т綅CODE
+ /// </summary>
+ [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")]
+    public string ToInvDepotSectionsCode { get; set; }
+
+ /// <summary>
+ ///     浜ゆ槗寮傚父淇℃伅
+ /// </summary>
+ [SugarColumn(ColumnName = "DESCRIPTION")]
+    public string Description { get; set; }
+
+ /// <summary>
+ ///     鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
+    public string CreateBy { get; set; }
+
+ /// <summary>
+ ///     鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+    public DateTime? CreateDate { get; set; }
+
+ /// <summary>
+ ///     鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+    public string LastupdateBy { get; set; }
+
+ /// <summary>
+ ///     鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+    public DateTime? LastupdateDate { get; set; }
+
+ /// <summary>
+ ///     瓒呮崯缁熻鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")]
+    public short? UllageStatFlag { get; set; }
+
+ /// <summary>
+ ///     鍒嗗巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+    public string Factory { get; set; }
+
+ /// <summary>
+ ///     鍏徃浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+    public string Company { get; set; }
+
+ /// <summary>
+ ///     绠卞彿鏉$爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE2")]
+    public string ItemBarcode2 { get; set; }
+
+ /// <summary>
+ ///     鍗℃澘鏉$爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE3")]
+    public string ItemBarcode3 { get; set; }
+
+ /// <summary>
+ ///     浠诲姟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_NO")]
+    public string WorkNo { get; set; }
+
+ /// <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 = "LINE_NO")]
+    public string LineNo { get; set; }
+
+ /// <summary>
+ ///     閲囪喘璁㈠崟id
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN_K3ID")]
+    public decimal? EbelnK3id { get; set; }
+
+ /// <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 bf0d207..518f09f 100644
--- a/MES.Service/Modes/MesInvItemArn.cs
+++ b/MES.Service/Modes/MesInvItemArn.cs
@@ -8,232 +8,232 @@
 [SugarTable("MES_INV_ITEM_ARN")]
 public class MesInvItemArn
 {
-   /// <summary>
-   ///     ID(SEQ_INV_ID)
-   /// </summary>
-   [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ ///     ID(SEQ_INV_ID)
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
-   /// <summary>
-   ///     鍒拌揣鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "BILL_NO")]
+ /// <summary>
+ ///     鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
     public string BillNo { get; set; }
 
-   /// <summary>
-   ///     鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
-   /// </summary>
-   [SugarColumn(ColumnName = "STATUS")]
+ /// <summary>
+ ///     鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
     public short? Status { get; set; }
 
-   /// <summary>
-   ///     鍘熷洜
-   /// </summary>
-   [SugarColumn(ColumnName = "REASON")]
+ /// <summary>
+ ///     鍘熷洜
+ /// </summary>
+ [SugarColumn(ColumnName = "REASON")]
     public string Reason { get; set; }
 
-   /// <summary>
-   ///     鍒涘缓浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "CREATE_BY")]
+ /// <summary>
+ ///     鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
     public string CreateBy { get; set; }
 
-   /// <summary>
-   ///     鍒涘缓鏃堕棿
-   /// </summary>
-   [SugarColumn(ColumnName = "CREATE_DATE")]
+ /// <summary>
+ ///     鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
     public DateTime? CreateDate { get; set; }
 
-   /// <summary>
-   ///     鏈�鍚庢洿鏂颁汉
-   /// </summary>
-   [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ /// <summary>
+ ///     鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
     public string LastupdateBy { get; set; }
 
-   /// <summary>
-   ///     鏈�鍚庢洿鏂版椂闂�
-   /// </summary>
-   [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <summary>
+ ///     鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
     public DateTime? LastupdateDate { get; set; }
 
-   /// <summary>
-   ///     鍗曟嵁绫诲瀷ID
-   /// </summary>
-   [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+ /// <summary>
+ ///     鍗曟嵁绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_TYPE_ID")]
     public decimal? BillTypeId { get; set; }
 
-   /// <summary>
-   ///     浜嬪姟绫诲瀷ID
-   /// </summary>
-   [SugarColumn(ColumnName = "TRANSACTION_ID")]
+ /// <summary>
+ ///     浜嬪姟绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_ID")]
     public decimal? TransactionId { get; set; }
 
-   /// <summary>
-   ///     澶囨敞
-   /// </summary>
-   [SugarColumn(ColumnName = "REMARK")]
+ /// <summary>
+ ///     澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK")]
     public string Remark { get; set; }
 
-   /// <summary>
-   ///     閫佽揣鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "PAPER_BILL_NO")]
+ /// <summary>
+ ///     閫佽揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "PAPER_BILL_NO")]
     public string PaperBillNo { get; set; }
 
-   /// <summary>
-   ///     閫�鏂欎汉宸ュ彿
-   /// </summary>
-   [SugarColumn(ColumnName = "USER_NO_BACK")]
+ /// <summary>
+ ///     閫�鏂欎汉宸ュ彿
+ /// </summary>
+ [SugarColumn(ColumnName = "USER_NO_BACK")]
     public string UserNoBack { get; set; }
 
-   /// <summary>
-   ///     鎻愪氦浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_USER")]
+ /// <summary>
+ ///     鎻愪氦浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_USER")]
     public string CheckUser { get; set; }
 
-   /// <summary>
-   ///     鎻愪氦鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_DATE")]
+ /// <summary>
+ ///     鎻愪氦鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_DATE")]
     public DateTime? CheckDate { get; set; }
 
-   /// <summary>
-   ///     鍏ュ簱鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "INS_DATE")]
+ /// <summary>
+ ///     鍏ュ簱鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "INS_DATE")]
     public DateTime? InsDate { get; set; }
 
-   /// <summary>
-   ///     妫�楠岀粨鏋�
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_RES")]
+ /// <summary>
+ ///     妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_RES")]
     public string CheckRes { get; set; }
 
-   /// <summary>
-   ///     宸叉崱鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_QTY")]
+ /// <summary>
+ ///     宸叉崱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QTY")]
     public decimal? CheckQty { get; set; }
 
-   /// <summary>
-   ///     浠撳簱缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "DEPOTS_CODE")]
+ /// <summary>
+ ///     浠撳簱缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOTS_CODE")]
     public string DepotsCode { get; set; }
 
-   /// <summary>
-   ///     浜嬪姟绫诲瀷缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "TRANSCTION_NO")]
+ /// <summary>
+ ///     浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSCTION_NO")]
     public string TransctionNo { get; set; }
 
-   /// <summary>
-   ///     渚涘簲鍟嗙紪鐮�
-   /// </summary>
-   [SugarColumn(ColumnName = "SUPP_NO")]
+ /// <summary>
+ ///     渚涘簲鍟嗙紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
     public string SuppNo { get; set; }
 
-   /// <summary>
-   ///     鎻愪氦鐘舵��
-   /// </summary>
-   [SugarColumn(ColumnName = "FSTATUS")]
+ /// <summary>
+ ///     鎻愪氦鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "FSTATUS")]
     public short? Fstatus { get; set; }
 
-   /// <summary>
-   ///     宸ュ巶缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ ///     宸ュ巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
     public string Factory { get; set; }
 
-   /// <summary>
-   ///     鏄惁宸插洖鍐橲AP
-   /// </summary>
-   [SugarColumn(ColumnName = "SAPSTATUS")]
+ /// <summary>
+ ///     鏄惁宸插洖鍐橲AP
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPSTATUS")]
     public short? Sapstatus { get; set; }
 
-   /// <summary>
-   ///     纭鍏ュ簱鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "INS_DATE")]
+ /// <summary>
+ ///     纭鍏ュ簱鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "INS_DATE")]
     public DateTime? Insdate { get; set; }
 
-   /// <summary>
-   ///     鏄惁妫�楠�
-   /// </summary>
-   [SugarColumn(ColumnName = "ISCHECK")]
+ /// <summary>
+ ///     鏄惁妫�楠�
+ /// </summary>
+ [SugarColumn(ColumnName = "ISCHECK")]
     public decimal? Ischeck { get; set; }
 
-   /// <summary>
-   ///     瀹℃牳鍏ュ簱浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "INSBY")]
+ /// <summary>
+ ///     瀹℃牳鍏ュ簱浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "INSBY")]
     public string Insby { get; set; }
 
-   /// <summary>
-   ///     鍏徃浠g爜
-   /// </summary>
-   [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ ///     鍏徃浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
     public string Company { get; set; }
 
-   /// <summary>
-   ///     鎬ユ枡鏍囪瘑
-   /// </summary>
-   [SugarColumn(ColumnName = "URGENT_FLAG")]
+ /// <summary>
+ ///     鎬ユ枡鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "URGENT_FLAG")]
     public short? UrgentFlag { get; set; }
 
-   /// <summary>
-   ///     鍐查攢浜嬪姟绫诲瀷缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
+ /// <summary>
+ ///     鍐查攢浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
     public decimal? MttransctionNo { get; set; }
 
-   /// <summary>
-   ///     IQC妫�楠屽崟鍙�
-   /// </summary>
-   [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
+ /// <summary>
+ ///     IQC妫�楠屽崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
     public string IqcReleaseNo { get; set; }
 
-   /// <summary>
-   ///     鏄惁鏄剧ず
-   /// </summary>
-   [SugarColumn(ColumnName = "IS_VISUAL")]
+ /// <summary>
+ ///     鏄惁鏄剧ず
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_VISUAL")]
     public decimal? IsVisual { get; set; }
 
-   /// <summary>
-   ///     0=閲囪喘锛�1=濮斿
-   /// </summary>
-   [SugarColumn(ColumnName = "F_TYPE")]
+ /// <summary>
+ ///     0=閲囪喘锛�1=濮斿
+ /// </summary>
+ [SugarColumn(ColumnName = "F_TYPE")]
     public decimal? FType { get; set; }
 
-   /// <summary>
-   ///     ERP鍒拌揣鍗旾D
-   /// </summary>
-   [SugarColumn(ColumnName = "EBELN_K3ID")]
+ /// <summary>
+ ///     ERP鍒拌揣鍗旾D
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN_K3ID")]
     public string EbelnK3id { get; set; }
 
-   /// <summary>
-   ///     鏉$爜鏉″嵃杩涘害
-   /// </summary>
-   [SugarColumn(ColumnName = "BARCODE_RATIO")]
+ /// <summary>
+ ///     鏉$爜鏉″嵃杩涘害
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_RATIO")]
     public decimal? BarcodeRatio { get; set; }
 
-   /// <summary>
-   ///     ERP鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "ERPNO")]
+ /// <summary>
+ ///     ERP鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ERPNO")]
     public string Erpno { get; set; }
 
-   /// <summary>
-   ///     鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐�
-   /// </summary>
-   [SugarColumn(ColumnName = "THSTATUS")]
+ /// <summary>
+ ///     鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐�
+ /// </summary>
+ [SugarColumn(ColumnName = "THSTATUS")]
     public short? Thstatus { get; set; }
 
-   /// <summary>
-   ///     ERP閫�璐у崟鍙�
-   /// </summary>
-   [SugarColumn(ColumnName = "ERPTHNO")]
+ /// <summary>
+ ///     ERP閫�璐у崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "ERPTHNO")]
     public string Erpthno { get; set; }
 
 
diff --git a/MES.Service/Modes/MesInvItemBarcodes.cs b/MES.Service/Modes/MesInvItemBarcodes.cs
index 0e5e2c0..078ac04 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/MesInvItemInCDetails.cs b/MES.Service/Modes/MesInvItemInCDetails.cs
index be92da1..0bf8253 100644
--- a/MES.Service/Modes/MesInvItemInCDetails.cs
+++ b/MES.Service/Modes/MesInvItemInCDetails.cs
@@ -11,7 +11,8 @@
     /// <summary>
     ///     SEQ_OUT
     /// </summary>
-    [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_INV_ID", IsPrimaryKey = true)]
+    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
+        IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
     /// <summary>
diff --git a/MES.Service/Modes/MesInvItemInCItems.cs b/MES.Service/Modes/MesInvItemInCItems.cs
index 9c3eb27..05e3293 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
new file mode 100644
index 0000000..b65928e
--- /dev/null
+++ b/MES.Service/Modes/MesInvItemMoves.cs
@@ -0,0 +1,178 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+///     鐗╂枡绉诲簱涓昏〃
+/// </summary>
+[SugarTable("MES_INV_ITEM_MOVES")]
+public class MesInvItemMoves
+{
+ /// <summary>
+ ///     SEQ_INV_ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+    public decimal Id { get; set; }
+
+ /// <summary>
+ ///     绉诲簱鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
+    public string BillNo { get; set; }
+
+ /// <summary>
+ ///     绉诲叆瀛愬簱id
+ /// </summary>
+ [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
+    public decimal? InvDepotsId { get; set; }
+
+ /// <summary>
+ ///     绉诲叆璐т綅id
+ /// </summary>
+ [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
+    public decimal? InvDepotSectionsId { get; set; }
+
+ /// <summary>
+ ///     鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
+    public string CreateBy { get; set; }
+
+ /// <summary>
+ ///     鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
+    public DateTime? CreateDate { get; set; }
+
+ /// <summary>
+ ///     鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+    public string LastupdateBy { get; set; }
+
+ /// <summary>
+ ///     鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+    public DateTime? LastupdateDate { get; set; }
+
+ /// <summary>
+ ///     鐘舵�亅0-鍒跺崟1-杩囪处
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
+    public decimal? Status { get; set; }
+
+ /// <summary>
+ ///     澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "REMARK")]
+    public string Remark { get; set; }
+
+ /// <summary>
+ ///     鍗曟嵁绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+    public decimal? BillTypeId { get; set; }
+
+ /// <summary>
+ ///     浜嬪姟绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_ID")]
+    public decimal? TransactionId { get; set; }
+
+ /// <summary>
+ ///     瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECKUSER")]
+    public string Checkuser { get; set; }
+
+ /// <summary>
+ ///     瀹℃牳鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECKDATE")]
+    public DateTime? Checkdate { get; set; }
+
+ /// <summary>
+ ///     绉诲叆瀛愬簱code
+ /// </summary>
+ [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
+    public string InvDepotsCode { get; set; }
+
+ /// <summary>
+ ///     绉诲叆璐т綅code
+ /// </summary>
+ [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
+    public string InvDepotSectionsCode { get; set; }
+
+ /// <summary>
+ ///     浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_NO")]
+    public decimal? TransactionNo { get; set; }
+
+ /// <summary>
+ ///     绉诲嚭瀛愬簱code
+ /// </summary>
+ [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
+    public string FromDepotsCode { get; set; }
+
+ /// <summary>
+ ///     宸ュ巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY_CODE")]
+    public string FactoryCode { get; set; }
+
+ /// <summary>
+ ///     SAP杩斿洖鍗曟嵁
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPNO")]
+    public string Sapno { get; set; }
+
+ /// <summary>
+ ///     宸插洖鍐橲AP
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPSTATUS")]
+    public short? Sapstatus { get; set; }
+
+ /// <summary>
+ ///     SAP杩斿洖骞翠唤
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPYEAR")]
+    public short? Sapyear { get; set; }
+
+ /// <summary>
+ ///     SAP杩斿洖淇℃伅
+ /// </summary>
+ [SugarColumn(ColumnName = "SAPTEXT")]
+    public string Saptext { get; set; }
+
+ /// <summary>
+ ///     鍒嗗巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+    public string Factory { get; set; }
+
+ /// <summary>
+ ///     鍏徃浠g爜
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+    public string Company { get; set; }
+
+ /// <summary>
+ ///     鍙嶅鏍镐簨鍔$被鍨嬬紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "MTRANSACTION_NO")]
+    public decimal? MtransactionNo { get; set; }
+
+ /// <summary>
+ ///     鑷姩淇濆瓨瀛楁
+ /// </summary>
+ [SugarColumn(ColumnName = "ZD_NUM")]
+    public decimal? ZdNum { get; set; }
+
+ /// <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
new file mode 100644
index 0000000..ec6b0c2
--- /dev/null
+++ b/MES.Service/Modes/MesInvItemMovesCDetails.cs
@@ -0,0 +1,231 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+///     鐗╂枡绉诲簱鏉$爜鏄庣粏浠庤〃
+/// </summary>
+[SugarTable("MES_INV_ITEM_MOVES_C_DETAILS")]
+public class MesInvItemMovesCDetails
+{
+ /// <summary>
+ ///     seq_inv_id
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+    public decimal Id { get; set; }
+
+ /// <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 = "C_ITEM_CODE")]
+    public string CItemCode { 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 = "QUANTITY")]
+    public decimal? Quantity { get; set; }
+
+ /// <summary>
+ ///     鍑哄簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�)
+ /// </summary>
+ [SugarColumn(ColumnName = "BARCODE_FLAG")]
+    public short? BarcodeFlag { get; set; }
+
+ /// <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_DATE")]
+    public DateTime? CreateDate { get; set; }
+
+ /// <summary>
+ ///     鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+    public string LastupdateBy { get; set; }
+
+ /// <summary>
+ ///     鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+    public DateTime? LastupdateDate { get; set; }
+
+ /// <summary>
+ ///     瀛愬簱id
+ /// </summary>
+ [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
+    public decimal? InvDepotsId { get; set; }
+
+ /// <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 = "TASK_NO")]
+    public string TaskNo { 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 = "REMARK")]
+    public string Remark { get; set; }
+
+ /// <summary>
+ ///     鍒嗗巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+    public string Factory { 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 = "KO_NO")]
+    public string KoNo { 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 = "IQC_STATUS")]
+    public string IqcStatus { get; set; }
+
+ /// <summary>
+ ///     灏忚溅缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FCAR")]
+    public string Fcar { get; set; }
+
+ /// <summary>
+ ///     鍏ュ簱鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "INDEP_DATE")]
+    public DateTime? IndepDate { get; set; }
+
+ /// <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_DATE")]
+    public DateTime? VisableSubmitDate { 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_LINE")]
+    public decimal? WorkLine { get; set; }
+
+ /// <summary>
+ ///     渚涘簲鍟嗙紪鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
+    public string SuppNo { get; set; }
+
+ /// <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 c3c46e1..a867ce8 100644
--- a/MES.Service/Modes/MesInvItemStocks.cs
+++ b/MES.Service/Modes/MesInvItemStocks.cs
@@ -9,7 +9,7 @@
 public class MesInvItemStocks
 {
     /// <summary>
-    /// SEQ_ME_ID 
+    ///     SEQ_ME_ID
     /// </summary>
     [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ME_ID",
         IsPrimaryKey = true)]
diff --git a/MES.Service/Modes/MesQaItemsDetect01.cs b/MES.Service/Modes/MesQaItemsDetect01.cs
index 14760fb..2a26d0c 100644
--- a/MES.Service/Modes/MesQaItemsDetect01.cs
+++ b/MES.Service/Modes/MesQaItemsDetect01.cs
@@ -8,324 +8,324 @@
 [SugarTable("MES_QA_ITEMS_DETECT_01")]
 public class MesQaItemsDetect01
 {
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
-   /// <summary>
-   ///     妫�楠屽崟鍙�
-   /// </summary>
-   [SugarColumn(ColumnName = "RELEASE_NO")]
+ /// <summary>
+ ///     妫�楠屽崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "RELEASE_NO")]
     public string ReleaseNo { get; set; }
 
-   /// <summary>
-   ///     妫�楠屾棩鏈�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_DATE")]
+ /// <summary>
+ ///     妫�楠屾棩鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_DATE")]
     public DateTime? FcheckDate { get; set; }
 
-   /// <summary>
-   ///     妫�楠屼汉鍛�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_BY")]
+ /// <summary>
+ ///     妫�楠屼汉鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_BY")]
     public string FcheckBy { get; set; }
 
-   /// <summary>
-   ///     鐗╂枡缂栫爜
-   /// </summary>
-   [SugarColumn(ColumnName = "ITEM_NO")]
+ /// <summary>
+ ///     鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
     public string ItemNo { get; set; }
 
-   /// <summary>
-   ///     鏉ユ枡鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "FBATCH_QTY")]
+ /// <summary>
+ ///     鏉ユ枡鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FBATCH_QTY")]
     public decimal? FbatchQty { get; set; }
 
-   /// <summary>
-   ///     鍒ゅ畾缁撴灉
-   /// </summary>
-   [SugarColumn(ColumnName = "FRECE_QTY")]
+ /// <summary>
+ ///     鍒ゅ畾缁撴灉
+ /// </summary>
+ [SugarColumn(ColumnName = "FRECE_QTY")]
     public string FreceQty { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "SUPP_NO")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
     public string SuppNo { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "FNG_DESC")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_DESC")]
     public string FngDesc { get; set; }
 
-   /// <summary>
-   ///     妫�楠岀粨鏋�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_RESU")]
+ /// <summary>
+ ///     妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_RESU")]
     public string FcheckResu { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "FREVIEW")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FREVIEW")]
     public string Freview { get; set; }
 
-   /// <summary>
-   ///     妫�楠屾按鍑�
-   /// </summary>
-   [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
+ /// <summary>
+ ///     妫�楠屾按鍑�
+ /// </summary>
+ [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
     public string SampleSizeNo { get; set; }
 
-   /// <summary>
-   ///     妫�楠屾按骞�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_LEVEL")]
+ /// <summary>
+ ///     妫�楠屾按骞�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_LEVEL")]
     public string FcheckLevel { get; set; }
 
-   /// <summary>
-   ///     鎷掓敹姘村钩
-   /// </summary>
-   [SugarColumn(ColumnName = "FAC_LEVEL")]
+ /// <summary>
+ ///     鎷掓敹姘村钩
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_LEVEL")]
     public string FacLevel { get; set; }
 
-   /// <summary>
-   ///     鎶芥鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_QTY")]
+ /// <summary>
+ ///     鎶芥鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QTY")]
     public string CheckQty { get; set; }
 
-   /// <summary>
-   ///     鎵规鍙�  --鍒拌揣鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "LOT_NO")]
+ /// <summary>
+ ///     鎵规鍙�  --鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO")]
     public string LotNo { get; set; }
 
-   /// <summary>
-   ///     鏄惁鎺ㄩ��
-   /// </summary>
-   [SugarColumn(ColumnName = "FMOVE")]
+ /// <summary>
+ ///     鏄惁鎺ㄩ��
+ /// </summary>
+ [SugarColumn(ColumnName = "FMOVE")]
     public string Fmove { get; set; }
 
-   /// <summary>
-   ///     鏄惁澶勭悊
-   /// </summary>
-   [SugarColumn(ColumnName = "FHANDLE")]
+ /// <summary>
+ ///     鏄惁澶勭悊
+ /// </summary>
+ [SugarColumn(ColumnName = "FHANDLE")]
     public string Fhandle { get; set; }
 
-   /// <summary>
-   ///     鍒涘缓浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "CREATE_BY")]
+ /// <summary>
+ ///     鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_BY")]
     public string CreateBy { get; set; }
 
-   /// <summary>
-   ///     鍒涘缓鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "CREATE_DATE")]
+ /// <summary>
+ ///     鍒涘缓鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATE_DATE")]
     public DateTime? CreateDate { get; set; }
 
-   /// <summary>
-   ///     鏇存柊浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ /// <summary>
+ ///     鏇存柊浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
     public string LastupdateBy { get; set; }
 
-   /// <summary>
-   ///     鏇存柊鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+ /// <summary>
+ ///     鏇存柊鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
     public DateTime? LastupdateDate { get; set; }
 
-   /// <summary>
-   ///     鏄惁瀹℃牳
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_FLAG")]
+ /// <summary>
+ ///     鏄惁瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_FLAG")]
     public decimal? Modify1Flag { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_BY")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_BY")]
     public string Modify1By { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_DATE")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_DATE")]
     public DateTime? Modify1Date { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "FACTORY")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
     public string Factory { get; set; }
 
-   /// <summary>
-   ///     XRF娴嬭瘯鎶ュ憡缂栧彿
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_REPNO")]
+ /// <summary>
+ ///     XRF娴嬭瘯鎶ュ憡缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_REPNO")]
     public string FcheckRepno { get; set; }
 
-   /// <summary>
-   ///     绗笁鏂规姤鍛�
-   /// </summary>
-   [SugarColumn(ColumnName = "FTHIRD_REP")]
+ /// <summary>
+ ///     绗笁鏂规姤鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "FTHIRD_REP")]
     public string FthirdRep { get; set; }
 
-   /// <summary>
-   ///     鏄惁浣滃簾
-   /// </summary>
-   [SugarColumn(ColumnName = "FCANCEL")]
+ /// <summary>
+ ///     鏄惁浣滃簾
+ /// </summary>
+ [SugarColumn(ColumnName = "FCANCEL")]
     public decimal? Fcancel { get; set; }
 
-   /// <summary>
-   ///     鎻愪氦鏍囪瘑
-   /// </summary>
-   [SugarColumn(ColumnName = "FSUBMIT")]
+ /// <summary>
+ ///     鎻愪氦鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "FSUBMIT")]
     public decimal? Fsubmit { get; set; }
 
-   /// <summary>
-   ///     妫�楠屼緷鎹�
-   /// </summary>
-   [SugarColumn(ColumnName = "FCHECK_ACCORD")]
+ /// <summary>
+ ///     妫�楠屼緷鎹�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ACCORD")]
     public string FcheckAccord { get; set; }
 
-   /// <summary>
-   ///     绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱)
-   /// </summary>
-   [SugarColumn(ColumnName = "FTYPE")]
+ /// <summary>
+ ///     绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱)
+ /// </summary>
+ [SugarColumn(ColumnName = "FTYPE")]
     public short? Ftype { get; set; }
 
-   /// <summary>
-   ///     鍗曚綅
-   /// </summary>
-   [SugarColumn(ColumnName = "ITEM_UNIT")]
+ /// <summary>
+ ///     鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_UNIT")]
     public string ItemUnit { get; set; }
 
-   /// <summary>
-   ///     鍑鸿揣鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "OUT_DATE")]
+ /// <summary>
+ ///     鍑鸿揣鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "OUT_DATE")]
     public string OutDate { get; set; }
 
-   /// <summary>
-   ///     鏄惁鍏嶆
-   /// </summary>
-   [SugarColumn(ColumnName = "FEXEMPTION")]
+ /// <summary>
+ ///     鏄惁鍏嶆
+ /// </summary>
+ [SugarColumn(ColumnName = "FEXEMPTION")]
     public decimal? Fexemption { get; set; }
 
-   /// <summary>
-   ///     妗d綅鏍囧噯
-   /// </summary>
-   [SugarColumn(ColumnName = "FGEAR_STAND")]
+ /// <summary>
+ ///     妗d綅鏍囧噯
+ /// </summary>
+ [SugarColumn(ColumnName = "FGEAR_STAND")]
     public string FgearStand { get; set; }
 
-   /// <summary>
-   ///     涓嶈壇澶勭悊鏂规硶
-   /// </summary>
-   [SugarColumn(ColumnName = "FNG_HANDLE")]
+ /// <summary>
+ ///     涓嶈壇澶勭悊鏂规硶
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_HANDLE")]
     public string FngHandle { get; set; }
 
-   /// <summary>
-   ///     绠$悊缂栧彿
-   /// </summary>
-   [SugarColumn(ColumnName = "FMANAGE_NO")]
+ /// <summary>
+ ///     绠$悊缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "FMANAGE_NO")]
     public string FmanageNo { get; set; }
 
-   /// <summary>
-   ///     杞崲鏁伴噺
-   /// </summary>
-   [SugarColumn(ColumnName = "FCOVERT_QTY")]
+ /// <summary>
+ ///     杞崲鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FCOVERT_QTY")]
     public string FcovertQty { get; set; }
 
-   /// <summary>
-   ///     鐗堟湰
-   /// </summary>
-   [SugarColumn(ColumnName = "FVERSION")]
+ /// <summary>
+ ///     鐗堟湰
+ /// </summary>
+ [SugarColumn(ColumnName = "FVERSION")]
     public decimal? Fversion { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "COMPANY")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
     public string Company { get; set; }
 
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "FSECOND_RESU")]
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FSECOND_RESU")]
     public string FsecondResu { get; set; }
 
-   /// <summary>
-   ///     鏈�澶ф娊妫�鏁�
-   /// </summary>
-   [SugarColumn(ColumnName = "MAX_CHECK_QTY")]
+ /// <summary>
+ ///     鏈�澶ф娊妫�鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "MAX_CHECK_QTY")]
     public decimal? MaxCheckQty { get; set; }
 
-   /// <summary>
-   ///     鐗瑰畾淇敼鏄惁瀹℃牳
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_FLAG1")]
+ /// <summary>
+ ///     鐗瑰畾淇敼鏄惁瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_FLAG1")]
     public decimal? Modify1Flag1 { get; set; }
 
-   /// <summary>
-   ///     鐗瑰畾淇敼瀹℃牳浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_BY1")]
+ /// <summary>
+ ///     鐗瑰畾淇敼瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_BY1")]
     public string Modify1By1 { get; set; }
 
-   /// <summary>
-   ///     鐗瑰畾淇敼瀹℃牳鏃堕棿
-   /// </summary>
-   [SugarColumn(ColumnName = "MODIFY1_DATE1")]
+ /// <summary>
+ ///     鐗瑰畾淇敼瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "MODIFY1_DATE1")]
     public DateTime? Modify1Date1 { get; set; }
 
-   /// <summary>
-   ///     灏忔壒娆″彿
-   /// </summary>
-   [SugarColumn(ColumnName = "LOT_NO1")]
+ /// <summary>
+ ///     灏忔壒娆″彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO1")]
     public string LotNo1 { get; set; }
 
-   /// <summary>
-   ///     閲囪喘鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "LOT_NO2")]
+ /// <summary>
+ ///     閲囪喘鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO2")]
     public string LotNo2 { get; set; }
 
-   /// <summary>
-   ///     浜у搧鍨嬪彿
-   /// </summary>
-   [SugarColumn(ColumnName = "BOARD_STYLE")]
+ /// <summary>
+ ///     浜у搧鍨嬪彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BOARD_STYLE")]
     public string BoardStyle { get; set; }
 
-   /// <summary>
-   ///     浠诲姟鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "WORK_NO")]
+ /// <summary>
+ ///     浠诲姟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_NO")]
     public string WorkNo { get; set; }
 
-   /// <summary>
-   ///     鍒拌揣鏃堕棿
-   /// </summary>
-   [SugarColumn(ColumnName = "DHA018")]
+ /// <summary>
+ ///     鍒拌揣鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHA018")]
     public string Dha018 { get; set; }
 
-   /// <summary>
-   ///     琛屽彿
-   /// </summary>
-   [SugarColumn(ColumnName = "DHB002")]
+ /// <summary>
+ ///     琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB002")]
     public decimal? Dhb002 { get; set; }
 
-   /// <summary>
-   ///     鍒拌揣鍗曞彿
-   /// </summary>
-   [SugarColumn(ColumnName = "DHB001")]
+ /// <summary>
+ ///     鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "DHB001")]
     public string Dhb001 { get; set; }
 
-   /// <summary>
-   ///     渚涘簲鍟�
-   /// </summary>
-   [SugarColumn(ColumnName = "LIFNR")]
+ /// <summary>
+ ///     渚涘簲鍟�
+ /// </summary>
+ [SugarColumn(ColumnName = "LIFNR")]
     public string Lifnr { get; set; }
 
-   /// <summary>
-   ///     閫�鏂欐柟寮�
-   /// </summary>
-   [SugarColumn(ColumnName = "FMRMODE")]
+ /// <summary>
+ ///     閫�鏂欐柟寮�
+ /// </summary>
+ [SugarColumn(ColumnName = "FMRMODE")]
     public string Fmrmode { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/MesQaItemsDetectDetail5.cs b/MES.Service/Modes/MesQaItemsDetectDetail5.cs
index 9421a04..d6159cc 100644
--- a/MES.Service/Modes/MesQaItemsDetectDetail5.cs
+++ b/MES.Service/Modes/MesQaItemsDetectDetail5.cs
@@ -1,154 +1,174 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.Linq;
-using SqlSugar;
-namespace MES.Service.Modes
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+///     鏉ユ枡妫�楠屼粠琛�
+/// </summary>
+[SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")]
+public class MesQaItemsDetectDetail5
 {
-    /// <summary>
-    /// 鏉ユ枡妫�楠屼粠琛�
-    ///</summary>
-    [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")]
-    public class MesQaItemsDetectDetail5
-    {
-        /// <summary>
-        ///  
-        ///</summary>
-         [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true   )]
-         public decimal Id { get; set; }
-        /// <summary>
-        /// 鏍囧噯鍊肩被鍨� 
-        ///</summary>
-         [SugarColumn(ColumnName="FTEXT_TYPE"    )]
-         public string FtextType { get; set; }
-        /// <summary>
-        /// 鏍囧噯鍊� 
-        ///</summary>
-         [SugarColumn(ColumnName="FSTAND"    )]
-         public decimal? Fstand { get; set; }
-        /// <summary>
-        /// 涓婂叕宸� 
-        ///</summary>
-         [SugarColumn(ColumnName="FUP_ALLOW"    )]
-         public string FupAllow { get; set; }
-        /// <summary>
-        /// 涓嬪叕宸� 
-        ///</summary>
-         [SugarColumn(ColumnName="FDOWN_ALLOW"    )]
-         public string FdownAllow { get; set; }
-        /// <summary>
-        /// 妫�楠屾按鍑� 
-        ///</summary>
-         [SugarColumn(ColumnName="SAMPLE_SIZE_NO"    )]
-         public string SampleSizeNo { get; set; }
-        /// <summary>
-        /// 妫�楠屾按骞� 
-        ///</summary>
-         [SugarColumn(ColumnName="FCHECK_LEVEL"    )]
-         public string FcheckLevel { get; set; }
-        /// <summary>
-        /// 鎷掓敹姘村钩 
-        ///</summary>
-         [SugarColumn(ColumnName="FAC_LEVEL"    )]
-         public string FacLevel { get; set; }
-        /// <summary>
-        /// 妫�楠岄」鐩� 
-        ///</summary>
-         [SugarColumn(ColumnName="FCHECK_ITEM"    )]
-         public string FcheckItem { get; set; }
-        /// <summary>
-        /// 瑙勬牸瑕佹眰 
-        ///</summary>
-         [SugarColumn(ColumnName="FSPEC_REQU"    )]
-         public string FspecRequ { get; set; }
-        /// <summary>
-        /// 鎶芥鏁伴噺 
-        ///</summary>
-         [SugarColumn(ColumnName="CHECK_QYT"    )]
-         public decimal? CheckQyt { get; set; }
-        /// <summary>
-        /// 妫�楠岀粨鏋� 
-        ///</summary>
-         [SugarColumn(ColumnName="FCHECK_RESU"    )]
-         public string FcheckResu { get; set; }
-        /// <summary>
-        /// AC鏁伴噺 
-        ///</summary>
-         [SugarColumn(ColumnName="FAC_QTY"    )]
-         public decimal? FacQty { get; set; }
-        /// <summary>
-        /// RE鏁伴噺 
-        ///</summary>
-         [SugarColumn(ColumnName="FRE_QTY"    )]
-         public decimal? FreQty { get; set; }
-        /// <summary>
-        /// 涓嶅悎鏍兼暟 
-        ///</summary>
-         [SugarColumn(ColumnName="FNG_QTY"    )]
-         public decimal? FngQty { get; set; }
-        /// <summary>
-        /// 涓嶈壇鐜� 
-        ///</summary>
-         [SugarColumn(ColumnName="FNG_RATE"    )]
-         public decimal? FngRate { get; set; }
-        /// <summary>
-        /// 宸插綍鍏ユ暟閲� 
-        ///</summary>
-         [SugarColumn(ColumnName="FENTER_QTY"    )]
-         public decimal? FenterQty { get; set; }
-        /// <summary>
-        ///  
-        ///</summary>
-         [SugarColumn(ColumnName="RELEASE_NO"    )]
-         public string ReleaseNo { get; set; }
-        /// <summary>
-        ///  
-        ///</summary>
-         [SugarColumn(ColumnName="COMPANY"    )]
-         public string Company { get; set; }
-        /// <summary>
-        ///  
-        ///</summary>
-         [SugarColumn(ColumnName="FACTORY"    )]
-         public string Factory { get; set; }
-        /// <summary>
-        /// 妫�楠岄」鐩弿杩� 
-        ///</summary>
-         [SugarColumn(ColumnName="FCHECK_ITEM_DESC"    )]
-         public string FcheckItemDesc { get; set; }
-        /// <summary>
-        /// 宸ュ簭鍙� 
-        ///</summary>
-         [SugarColumn(ColumnName="PROC_NO"    )]
-         public string ProcNo { get; set; }
-        /// <summary>
-        /// 宸ヤ綔涓績缂栫爜 
-        ///</summary>
-         [SugarColumn(ColumnName="WORKSHOP_CENTER_CODE"    )]
-         public string WorkshopCenterCode { get; set; }
-        /// <summary>
-        /// 鍗曚綅 
-        ///</summary>
-         [SugarColumn(ColumnName="FUNIT"    )]
-         public string Funit { get; set; }
-        /// <summary>
-        /// 鐗瑰畾淇敼 
-        ///</summary>
-         [SugarColumn(ColumnName="GIVEN_MODIFY"    )]
-         public short? GivenModify { get; set; }
-        /// <summary>
-        /// 妫�楠屽伐鍏� 
-        ///</summary>
-         [SugarColumn(ColumnName="FCHECK_TOOL"    )]
-         public string FcheckTool { get; set; }
-        /// <summary>
-        /// 鏇存柊浜� 
-        ///</summary>
-         [SugarColumn(ColumnName="LASTUPDATE_BY"    )]
-         public string LastupdateBy { get; set; }
-        /// <summary>
-        /// 鏇存柊鏃堕棿 
-        ///</summary>
-         [SugarColumn(ColumnName="LASTUPDATE_DATE"    )]
-         public DateTime? LastupdateDate { get; set; }
-    }
-}
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+    public decimal Id { get; set; }
+
+ /// <summary>
+ ///     鏍囧噯鍊肩被鍨�
+ /// </summary>
+ [SugarColumn(ColumnName = "FTEXT_TYPE")]
+    public string FtextType { get; set; }
+
+ /// <summary>
+ ///     鏍囧噯鍊�
+ /// </summary>
+ [SugarColumn(ColumnName = "FSTAND")]
+    public decimal? Fstand { get; set; }
+
+ /// <summary>
+ ///     涓婂叕宸�
+ /// </summary>
+ [SugarColumn(ColumnName = "FUP_ALLOW")]
+    public string FupAllow { get; set; }
+
+ /// <summary>
+ ///     涓嬪叕宸�
+ /// </summary>
+ [SugarColumn(ColumnName = "FDOWN_ALLOW")]
+    public string FdownAllow { get; set; }
+
+ /// <summary>
+ ///     妫�楠屾按鍑�
+ /// </summary>
+ [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")]
+    public string SampleSizeNo { get; set; }
+
+ /// <summary>
+ ///     妫�楠屾按骞�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_LEVEL")]
+    public string FcheckLevel { get; set; }
+
+ /// <summary>
+ ///     鎷掓敹姘村钩
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_LEVEL")]
+    public string FacLevel { get; set; }
+
+ /// <summary>
+ ///     妫�楠岄」鐩�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ITEM")]
+    public string FcheckItem { get; set; }
+
+ /// <summary>
+ ///     瑙勬牸瑕佹眰
+ /// </summary>
+ [SugarColumn(ColumnName = "FSPEC_REQU")]
+    public string FspecRequ { get; set; }
+
+ /// <summary>
+ ///     鎶芥鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_QYT")]
+    public decimal? CheckQyt { get; set; }
+
+ /// <summary>
+ ///     妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_RESU")]
+    public string FcheckResu { get; set; }
+
+ /// <summary>
+ ///     AC鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FAC_QTY")]
+    public decimal? FacQty { get; set; }
+
+ /// <summary>
+ ///     RE鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "FRE_QTY")]
+    public decimal? FreQty { get; set; }
+
+ /// <summary>
+ ///     涓嶅悎鏍兼暟
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_QTY")]
+    public decimal? FngQty { get; set; }
+
+ /// <summary>
+ ///     涓嶈壇鐜�
+ /// </summary>
+ [SugarColumn(ColumnName = "FNG_RATE")]
+    public decimal? FngRate { get; set; }
+
+ /// <summary>
+ ///     宸插綍鍏ユ暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "FENTER_QTY")]
+    public decimal? FenterQty { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "RELEASE_NO")]
+    public string ReleaseNo { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+    public string Company { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FACTORY")]
+    public string Factory { get; set; }
+
+ /// <summary>
+ ///     妫�楠岄」鐩弿杩�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")]
+    public string FcheckItemDesc { get; set; }
+
+ /// <summary>
+ ///     宸ュ簭鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "PROC_NO")]
+    public string ProcNo { get; set; }
+
+ /// <summary>
+ ///     宸ヤ綔涓績缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
+    public string WorkshopCenterCode { get; set; }
+
+ /// <summary>
+ ///     鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "FUNIT")]
+    public string Funit { get; set; }
+
+ /// <summary>
+ ///     鐗瑰畾淇敼
+ /// </summary>
+ [SugarColumn(ColumnName = "GIVEN_MODIFY")]
+    public short? GivenModify { get; set; }
+
+ /// <summary>
+ ///     妫�楠屽伐鍏�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCHECK_TOOL")]
+    public string FcheckTool { get; set; }
+
+ /// <summary>
+ ///     鏇存柊浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+    public string LastupdateBy { get; set; }
+
+ /// <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 b8de0cc..7fff6ee 100644
--- a/MES.Service/Modes/Purdhb.cs
+++ b/MES.Service/Modes/Purdhb.cs
@@ -8,267 +8,267 @@
 [SugarTable("PURDHB")]
 public class Purdhb
 {
- /// <summary>
- ///     鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB001")]
+   /// <summary>
+   ///     鍗曞彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB001")]
     public string Dhb001 { get; set; }
 
- /// <summary>
- ///     搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB002")]
+   /// <summary>
+   ///     搴忓彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB002")]
     public string Dhb002 { get; set; }
 
- /// <summary>
- ///     鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DHB003")]
+   /// <summary>
+   ///     鐗╂枡缂栫爜
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB003")]
     public string Dhb003 { get; set; }
 
- /// <summary>
- ///     鐗╂枡鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "DHB004")]
+   /// <summary>
+   ///     鐗╂枡鍚嶇О
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB004")]
     public string Dhb004 { get; set; }
 
- /// <summary>
- ///     鐗╂枡瑙勬牸
- /// </summary>
- [SugarColumn(ColumnName = "DHB005")]
+   /// <summary>
+   ///     鐗╂枡瑙勬牸
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB005")]
     public string Dhb005 { get; set; }
 
- /// <summary>
- ///     浜よ揣鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB006")]
+   /// <summary>
+   ///     浜よ揣鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB006")]
     public decimal? Dhb006 { get; set; }
 
- /// <summary>
- ///     鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "DHB007")]
+   /// <summary>
+   ///     鍗曚綅
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB007")]
     public string Dhb007 { get; set; }
 
- /// <summary>
- ///     浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "DHB008")]
+   /// <summary>
+   ///     浠撳簱
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB008")]
     public string Dhb008 { get; set; }
 
- /// <summary>
- ///     浠撳簱鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "DHB009")]
+   /// <summary>
+   ///     浠撳簱鍚嶇О
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB009")]
     public string Dhb009 { get; set; }
 
- /// <summary>
- ///     鎵瑰彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB010")]
+   /// <summary>
+   ///     鎵瑰彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB010")]
     public string Dhb010 { get; set; }
 
- /// <summary>
- ///     鏉ユ簮鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB011")]
+   /// <summary>
+   ///     鏉ユ簮鍗曞彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB011")]
     public string Dhb011 { get; set; }
 
- /// <summary>
- ///     鏉ユ簮搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB012")]
+   /// <summary>
+   ///     鏉ユ簮搴忓彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB012")]
     public decimal? Dhb012 { get; set; }
 
- /// <summary>
- ///     娓呯偣鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB013")]
+   /// <summary>
+   ///     娓呯偣鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB013")]
     public decimal? Dhb013 { get; set; }
 
- /// <summary>
- ///     鍒板巶鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "DHB014")]
+   /// <summary>
+   ///     鍒板巶鏃ユ湡
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB014")]
     public string Dhb014 { get; set; }
 
- /// <summary>
- ///     楠屾敹鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB015")]
+   /// <summary>
+   ///     楠屾敹鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB015")]
     public decimal? Dhb015 { get; set; }
 
- /// <summary>
- ///     楠岄��鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB016")]
+   /// <summary>
+   ///     楠岄��鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB016")]
     public decimal? Dhb016 { get; set; }
 
- /// <summary>
- ///     杩涜揣鍗曚环
- /// </summary>
- [SugarColumn(ColumnName = "DHB017")]
+   /// <summary>
+   ///     杩涜揣鍗曚环
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB017")]
     public decimal? Dhb017 { get; set; }
 
- /// <summary>
- ///     杩涜揣閲戦
- /// </summary>
- [SugarColumn(ColumnName = "DHB018")]
+   /// <summary>
+   ///     杩涜揣閲戦
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB018")]
     public decimal? Dhb018 { get; set; }
 
- /// <summary>
- ///     瀹㈡埛鏂欏彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB019")]
+   /// <summary>
+   ///     瀹㈡埛鏂欏彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB019")]
     public string Dhb019 { get; set; }
 
- /// <summary>
- ///     閮ㄩ棬缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB020")]
+   /// <summary>
+   ///     閮ㄩ棬缂栧彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB020")]
     public string Dhb020 { get; set; }
 
- /// <summary>
- ///     璧犲搧鏁�
- /// </summary>
- [SugarColumn(ColumnName = "DHB021")]
+   /// <summary>
+   ///     璧犲搧鏁�
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB021")]
     public decimal? Dhb021 { get; set; }
 
- /// <summary>
- ///     鏇存柊ERP
- /// </summary>
- [SugarColumn(ColumnName = "DHB022")]
+   /// <summary>
+   ///     鏇存柊ERP
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB022")]
     public string Dhb022 { get; set; }
 
- /// <summary>
- ///     妫�楠岀姸鎬�
- /// </summary>
- [SugarColumn(ColumnName = "DHB023")]
+   /// <summary>
+   ///     妫�楠岀姸鎬�
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB023")]
     public string Dhb023 { get; set; }
 
- /// <summary>
- ///     澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "DHB024")]
+   /// <summary>
+   ///     澶囨敞
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB024")]
     public string Dhb024 { get; set; }
 
- /// <summary>
- ///     瀹℃牳
- /// </summary>
- [SugarColumn(ColumnName = "AUDITING")]
+   /// <summary>
+   ///     瀹℃牳
+   /// </summary>
+   [SugarColumn(ColumnName = "AUDITING")]
     public decimal? Auditing { get; set; }
 
- /// <summary>
- ///     ERP閲囪喘鍗曞彿ID
- /// </summary>
- [SugarColumn(ColumnName = "DHB026")]
+   /// <summary>
+   ///     ERP閲囪喘鍗曞彿ID
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB026")]
     public decimal? Dhb026 { get; set; }
 
- /// <summary>
- ///     ERP閲囪喘搴忓彿ID
- /// </summary>
- [SugarColumn(ColumnName = "DHB027")]
+   /// <summary>
+   ///     ERP閲囪喘搴忓彿ID
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB027")]
     public decimal? Dhb027 { get; set; }
 
- /// <summary>
- ///     ERP鐗╂枡ID
- /// </summary>
- [SugarColumn(ColumnName = "DHB028")]
+   /// <summary>
+   ///     ERP鐗╂枡ID
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB028")]
     public decimal? Dhb028 { get; set; }
 
- /// <summary>
- ///     寰呮鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB029")]
+   /// <summary>
+   ///     寰呮鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB029")]
     public decimal? Dhb029 { get; set; }
 
- /// <summary>
- ///     妫�楠屾棩鏈�
- /// </summary>
- [SugarColumn(ColumnName = "DHB030")]
+   /// <summary>
+   ///     妫�楠屾棩鏈�
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB030")]
     public string Dhb030 { get; set; }
 
- /// <summary>
- ///     妫�楠屽憳
- /// </summary>
- [SugarColumn(ColumnName = "DHB031")]
+   /// <summary>
+   ///     妫�楠屽憳
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB031")]
     public string Dhb031 { get; set; }
 
- /// <summary>
- ///     鍏ュ簱鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DHB032")]
+   /// <summary>
+   ///     鍏ュ簱鏁伴噺
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB032")]
     public decimal? Dhb032 { get; set; }
 
- /// <summary>
- ///     鍏ュ簱浜�
- /// </summary>
- [SugarColumn(ColumnName = "DHB033")]
+   /// <summary>
+   ///     鍏ュ簱浜�
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB033")]
     public string Dhb033 { get; set; }
 
- /// <summary>
- ///     鍏ュ簱鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "DHB034")]
+   /// <summary>
+   ///     鍏ュ簱鏃堕棿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB034")]
     public string Dhb034 { get; set; }
 
- /// <summary>
- ///     閫�璐ф暟閲�
- /// </summary>
- [SugarColumn(ColumnName = "DHB035")]
+   /// <summary>
+   ///     閫�璐ф暟閲�
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB035")]
     public decimal? Dhb035 { get; set; }
 
- /// <summary>
- ///     ERPID
- /// </summary>
- [SugarColumn(ColumnName = "DHB037")]
+   /// <summary>
+   ///     ERPID
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB037")]
     public decimal? Dhb037 { get; set; }
 
- /// <summary>
- ///     閫�璐т汉
- /// </summary>
- [SugarColumn(ColumnName = "DHB036")]
+   /// <summary>
+   ///     閫�璐т汉
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB036")]
     public string Dhb036 { get; set; }
 
- /// <summary>
- ///     ERP鍘熷垎褰曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DHB038")]
+   /// <summary>
+   ///     ERP鍘熷垎褰曞彿
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB038")]
     public decimal? Dhb038 { get; set; }
 
- /// <summary>
- ///     ERP婧愬崟鍐呯爜
- /// </summary>
- [SugarColumn(ColumnName = "DHB039")]
+   /// <summary>
+   ///     ERP婧愬崟鍐呯爜
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB039")]
     public decimal? Dhb039 { get; set; }
 
- /// <summary>
- ///     ERP婧愬崟绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "DHB040")]
+   /// <summary>
+   ///     ERP婧愬崟绫诲瀷
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB040")]
     public decimal? Dhb040 { get; set; }
 
- /// <summary>
- ///     ERP璁㈠崟鍐呯爜
- /// </summary>
- [SugarColumn(ColumnName = "DHB041")]
+   /// <summary>
+   ///     ERP璁㈠崟鍐呯爜
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB041")]
     public decimal? Dhb041 { get; set; }
 
- /// <summary>
- ///     鑷鍒�
- /// </summary>
- [SugarColumn(ColumnName = "ID")]
+   /// <summary>
+   ///     鑷鍒�
+   /// </summary>
+   [SugarColumn(ColumnName = "ID")]
     public decimal? Id { get; set; }
 
- /// <summary>
- ///     鏄惁妫�楠岋紝1涓哄凡妫�
- /// </summary>
- [SugarColumn(ColumnName = "ISCHECK")]
+   /// <summary>
+   ///     鏄惁妫�楠岋紝1涓哄凡妫�
+   /// </summary>
+   [SugarColumn(ColumnName = "ISCHECK")]
     public decimal? Ischeck { get; set; }
 
- /// <summary>
- ///     浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "DHB042")]
+   /// <summary>
+   ///     浠撳簱
+   /// </summary>
+   [SugarColumn(ColumnName = "DHB042")]
     public string Dhb042 { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/Modes/Purdka.cs b/MES.Service/Modes/Purdka.cs
index 4330c13..1c3ea40 100644
--- a/MES.Service/Modes/Purdka.cs
+++ b/MES.Service/Modes/Purdka.cs
@@ -8,123 +8,123 @@
 [SugarTable("PURDKA")]
 public class Purdka
 {
- /// <summary>
- ///     鑷鍒�
- /// </summary>
- [SugarColumn(ColumnName = "ID")]
+   /// <summary>
+   ///     鑷鍒�
+   /// </summary>
+   [SugarColumn(ColumnName = "ID")]
     public decimal? Id { get; set; }
 
- /// <summary>
- ///     鍒涘缓浜哄憳
- /// </summary>
- [SugarColumn(ColumnName = "CREATEUSER")]
+   /// <summary>
+   ///     鍒涘缓浜哄憳
+   /// </summary>
+   [SugarColumn(ColumnName = "CREATEUSER")]
     public string Createuser { get; set; }
 
- /// <summary>
- ///     鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATETIME")]
+   /// <summary>
+   ///     鍒涘缓鏃堕棿
+   /// </summary>
+   [SugarColumn(ColumnName = "CREATETIME")]
     public string Createtime { get; set; }
 
- /// <summary>
- ///     淇敼鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "MODIFYTIME")]
+   /// <summary>
+   ///     淇敼鏃堕棿
+   /// </summary>
+   [SugarColumn(ColumnName = "MODIFYTIME")]
     public string Modifytime { get; set; }
 
- /// <summary>
- ///     淇敼浜哄憳
- /// </summary>
- [SugarColumn(ColumnName = "MODIFYUSER")]
+   /// <summary>
+   ///     淇敼浜哄憳
+   /// </summary>
+   [SugarColumn(ColumnName = "MODIFYUSER")]
     public string Modifyuser { get; set; }
 
- /// <summary>
- ///     瀹℃牳
- /// </summary>
- [SugarColumn(ColumnName = "AUDITING")]
+   /// <summary>
+   ///     瀹℃牳
+   /// </summary>
+   [SugarColumn(ColumnName = "AUDITING")]
     public string Auditing { get; set; }
 
- /// <summary>
- ///     閫�璐у崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "DKA001")]
+   /// <summary>
+   ///     閫�璐у崟鍙�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA001")]
     public string Dka001 { get; set; }
 
- /// <summary>
- ///     閫�璐х被鍨�
- /// </summary>
- [SugarColumn(ColumnName = "DKA002")]
+   /// <summary>
+   ///     閫�璐х被鍨�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA002")]
     public string Dka002 { get; set; }
 
- /// <summary>
- ///     閫�璐ф棩鏈�
- /// </summary>
- [SugarColumn(ColumnName = "DKA003")]
+   /// <summary>
+   ///     閫�璐ф棩鏈�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA003")]
     public string Dka003 { get; set; }
 
- /// <summary>
- ///     閫�璐ф椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "DKA004")]
+   /// <summary>
+   ///     閫�璐ф椂闂�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA004")]
     public string Dka004 { get; set; }
 
- /// <summary>
- ///     渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "DKA005")]
+   /// <summary>
+   ///     渚涘簲鍟�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA005")]
     public string Dka005 { get; set; }
 
- /// <summary>
- ///     渚涘簲鍟嗗悕绉�
- /// </summary>
- [SugarColumn(ColumnName = "DKA006")]
+   /// <summary>
+   ///     渚涘簲鍟嗗悕绉�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA006")]
     public string Dka006 { get; set; }
 
- /// <summary>
- ///     閮ㄩ棬
- /// </summary>
- [SugarColumn(ColumnName = "DKA007")]
+   /// <summary>
+   ///     閮ㄩ棬
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA007")]
     public string Dka007 { get; set; }
 
- /// <summary>
- ///     瀹℃牳鑰�
- /// </summary>
- [SugarColumn(ColumnName = "DKA008")]
+   /// <summary>
+   ///     瀹℃牳鑰�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA008")]
     public string Dka008 { get; set; }
 
- /// <summary>
- ///     瀹℃牳鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "DKA009")]
+   /// <summary>
+   ///     瀹℃牳鏃ユ湡
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA009")]
     public string Dka009 { get; set; }
 
- /// <summary>
- ///     閫�璐х姸鎬侊紝0鎴栫┖涓烘湭閫�璐э紝1涓哄凡閫�瀹�
- /// </summary>
- [SugarColumn(ColumnName = "DKA010")]
+   /// <summary>
+   ///     閫�璐х姸鎬侊紝0鎴栫┖涓烘湭閫�璐э紝1涓哄凡閫�瀹�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA010")]
     public string Dka010 { get; set; }
 
- /// <summary>
- ///     ERPID
- /// </summary>
- [SugarColumn(ColumnName = "ERPID")]
+   /// <summary>
+   ///     ERPID
+   /// </summary>
+   [SugarColumn(ColumnName = "ERPID")]
     public decimal? Erpid { get; set; }
 
- /// <summary>
- ///     淇濈鍛樼紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "DKA011")]
+   /// <summary>
+   ///     淇濈鍛樼紪鐮�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA011")]
     public string Dka011 { get; set; }
 
- /// <summary>
- ///     楠屾敹鍛樼紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "DKA012")]
+   /// <summary>
+   ///     楠屾敹鍛樼紪鐮�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA012")]
     public string Dka012 { get; set; }
 
- /// <summary>
- ///     鏄惁鎺ㄩ�佺孩瀛楀叆搴�1-鎺ㄩ�侊紝0-鏈帹閫�
- /// </summary>
- [SugarColumn(ColumnName = "DKA013")]
+   /// <summary>
+   ///     鏄惁鎺ㄩ�佺孩瀛楀叆搴�1-鎺ㄩ�侊紝0-鏈帹閫�
+   /// </summary>
+   [SugarColumn(ColumnName = "DKA013")]
     public decimal? Dka013 { get; set; }
 }
\ No newline at end of file
diff --git a/MES.Service/service/BasicData/MesStaffManager.cs b/MES.Service/service/BasicData/MesStaffManager.cs
index 5dc3db7..1f5f4dc 100644
--- a/MES.Service/service/BasicData/MesStaffManager.cs
+++ b/MES.Service/service/BasicData/MesStaffManager.cs
@@ -149,7 +149,7 @@
             Status = 0,
             Isdeparture = 0,
             CheckFlag = 0,
-            ExpFiel12 = 0,
+            ExpFiel12 = 0
         };
     }
 
diff --git a/MES.Service/service/QC/MesQaItemsDetectDetail5Manager.cs b/MES.Service/service/QC/MesQaItemsDetectDetail5Manager.cs
index 8fda982..a471429 100644
--- a/MES.Service/service/QC/MesQaItemsDetectDetail5Manager.cs
+++ b/MES.Service/service/QC/MesQaItemsDetectDetail5Manager.cs
@@ -1,78 +1,79 @@
-锘縰sing SqlSugar;
-using System;
-using System.Collections.Generic;
-using MES.Service.DB;
+锘縰sing MES.Service.DB;
 using MES.Service.Modes;
+using SqlSugar;
 
-namespace MES.Service.service.QC
+namespace MES.Service.service.QC;
+
+public class
+    MesQaItemsDetectDetail5Manager : Repository<MesQaItemsDetectDetail5>
 {
-public class MesQaItemsDetectDetail5Manager : Repository<MesQaItemsDetectDetail5>
-{
- 
     //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
 
     //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesQaItemsDetectDetail5Manager.cs
 
 
     #region 鏁欏鏂规硶
+
     /// <summary>
-    /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
+    ///     浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
     /// </summary>
     public void Study()
     {
-	     
-	   /*********鏌ヨ*********/
+        /*********鏌ヨ*********/
 
-        var data1 = base.GetById(1);//鏍规嵁ID鏌ヨ
-        var data2 = base.GetList();//鏌ヨ鎵�鏈�
-        var data3 = base.GetList(it => 1 == 1);  //鏍规嵁鏉′欢鏌ヨ  
+        var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ
+        var data2 = base.GetList(); //鏌ヨ鎵�鏈�
+        var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ  
         //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊
 
-        var p = new PageModel() { PageIndex = 1, PageSize = 2 };// 鍒嗛〉鏌ヨ
+        var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ
         var data5 = base.GetPageList(it => 1 == 1, p);
-        Console.Write(p.TotalCount);//杩斿洖鎬绘暟
+        Console.Write(p.TotalCount); //杩斿洖鎬绘暟
 
-        var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// 鍒嗛〉鏌ヨ鍔犳帓搴�
-        Console.Write(p.TotalCount);//杩斿洖鎬绘暟
-     
-        List<IConditionalModel> conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴�
-        conModels.Add(new ConditionalModel() { FieldName= typeof(MesQaItemsDetectDetail5).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1
-        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc);
+        var data6 =
+            base.GetPageList(it => 1 == 1, p,
+                it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴�
+        Console.Write(p.TotalCount); //杩斿洖鎬绘暟
 
-        base.AsQueryable().Where(x => 1 == 1).ToList();//鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘
+        var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴�
+        conModels.Add(new ConditionalModel
+        {
+            FieldName = typeof(MesQaItemsDetectDetail5).GetProperties()[0].Name,
+            ConditionalType = ConditionalType.Equal, FieldValue = "1"
+        }); //id=1
+        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());
 
- 
+        AsQueryable().Where(x => 1 == 1)
+            .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘
+
 
         /*********鎻掑叆*********/
-        var insertData = new MesQaItemsDetectDetail5() { };//娴嬭瘯鍙傛暟
-        var insertArray = new MesQaItemsDetectDetail5[] { insertData };
-        base.Insert(insertData);//鎻掑叆
-        base.InsertRange(insertArray);//鎵归噺鎻掑叆
-        var id = base.InsertReturnIdentity(insertData);//鎻掑叆杩斿洖鑷鍒�
-        base.AsInsertable(insertData).ExecuteCommand();//鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆
+        var insertData = new MesQaItemsDetectDetail5(); //娴嬭瘯鍙傛暟
+        var insertArray = new[] { insertData };
+        base.Insert(insertData); //鎻掑叆
+        base.InsertRange(insertArray); //鎵归噺鎻掑叆
+        var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒�
+        AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆
 
 
-
-		/*********鏇存柊*********/
-	    var updateData = new MesQaItemsDetectDetail5() {  };//娴嬭瘯鍙傛暟
-        var updateArray = new MesQaItemsDetectDetail5[] { updateData };//娴嬭瘯鍙傛暟
-        base.Update(updateData);//鏍规嵁瀹炰綋鏇存柊
-        base.UpdateRange(updateArray);//鎵归噺鏇存柊
+        /*********鏇存柊*********/
+        var updateData = new MesQaItemsDetectDetail5(); //娴嬭瘯鍙傛暟
+        var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟
+        base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊
+        base.UpdateRange(updateArray); //鎵归噺鏇存柊
         //base.Update(it => new MesQaItemsDetectDetail5() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1
-        base.AsUpdateable(updateData).ExecuteCommand();  //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏�
+        AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏�
 
 
+        /*********鍒犻櫎*********/
+        var deldata = new MesQaItemsDetectDetail5(); //娴嬭瘯鍙傛暟
+        base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎
+        base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎
+        base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎
+        base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎
+        AsDeleteable().Where(it => 1 == 2)
+            .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
+    }
 
-		/*********鍒犻櫎*********/
-	    var deldata = new MesQaItemsDetectDetail5() {  };//娴嬭瘯鍙傛暟
-        base.Delete(deldata);//鏍规嵁瀹炰綋鍒犻櫎
-        base.DeleteById(1);//鏍规嵁涓婚敭鍒犻櫎
-        base.DeleteById(new int[] { 1,2});//鏍规嵁涓婚敭鏁扮粍鍒犻櫎
-        base.Delete(it=>1==2);//鏍规嵁鏉′欢鍒犻櫎
-        base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
-    } 
     #endregion
-
- 
- }
 }
\ No newline at end of file
diff --git a/MES.Service/service/Warehouse/MesDepotSectionsManager.cs b/MES.Service/service/Warehouse/MesDepotSectionsManager.cs
index 3a02a02..0fbb744 100644
--- a/MES.Service/service/Warehouse/MesDepotSectionsManager.cs
+++ b/MES.Service/service/Warehouse/MesDepotSectionsManager.cs
@@ -17,21 +17,17 @@
             .Select((a, b) => a.DepotSectionName).Single();
 
         if (sectionName == null)
-        {
             throw new Exception("搴撲綅缂栫爜 " + query.sectionCode + " 涓嶅瓨鍦紝璇风‘璁わ紒");
-        }
 
         return sectionName;
     }
 
+    //搴撲綅鍙樻洿
     public MesDepotSections ScanInDepotSectionsName(WarehouseQuery query)
     {
-        
         if (string.IsNullOrEmpty(query.sectionCode))
-        {
             throw new Exception("璇锋壂搴撲綅鏉$爜!");
-        }
-        
+
         var mesDepotSections = Db.Queryable<MesDepotSections, MesDepots>(
                 (a, b) =>
                     new JoinQueryInfos(JoinType.Inner, a.DepotId == b.DepotId))
@@ -44,20 +40,47 @@
             }).First();
 
         if (mesDepotSections == null)
-        {
             throw new Exception("搴撲綅缂栫爜" + query.sectionCode + " 涓嶅瓨鍦紝璇风‘璁�!");
-        }
 
         return mesDepotSections;
     }
 
+    //搴撲綅鍙樻洿
     public MesInvItemStocks ScanEditBarcode(WarehouseQuery entity)
     {
         if (string.IsNullOrEmpty(entity.sectionCode))
-        {
             throw new Exception("璇锋壂搴撲綅鏉$爜!");
-        }
 
-        return null;
+        var mesDepotSections = Db.Queryable<MesDepotSections, MesDepots>(
+                (a, b) =>
+                    new JoinQueryInfos(JoinType.Inner,
+                        a.Zuid.ToString() == b.Zuid))
+            .Where((a, b) => a.DepotSectionCode == entity.sectionCode)
+            .First();
+        if (mesDepotSections == null)
+            throw new Exception("搴撲綅缂栫爜" + entity.sectionCode + " 涓嶅瓨鍦紝璇风‘璁わ紒");
+
+        var mesInvItemStocks = Db.Queryable<MesInvItemStocks>()
+            .Where(s => s.ItemBarcode == entity.barcode).First();
+
+        if (mesInvItemStocks == null) throw new Exception("鏉$爜鍦ㄤ粨搴撲腑涓嶅瓨鍦紝璇锋牳瀵癸紒");
+
+        if (mesInvItemStocks.DepotsCode != mesDepotSections.DepotCode)
+            throw new Exception(
+                "鏉$爜鍘熶粨搴擄細" + mesInvItemStocks.DepotsCode + " 涓庣洰鏍囦粨搴擄細" +
+                mesDepotSections.DepotCode + " 涓嶄竴鑷达紝搴撲綅鍙樻洿澶辫触锛�");
+
+        UseTransaction(db =>
+        {
+            return db.Updateable<MesInvItemStocks>()
+                .SetColumns(s => s.DepotsCode == mesDepotSections.DepotCode)
+                .SetColumns(s => s.DepotSectionsCode == entity.sectionCode)
+                .Where(s => s.ItemBarcode == entity.barcode)
+                .ExecuteCommand();
+        });
+
+        return mesInvItemStocks;
     }
+
+    //璋冩嫧鍏ュ簱
 }
\ No newline at end of file
diff --git a/MES.Service/service/Warehouse/MesInvBusiness2Manager.cs b/MES.Service/service/Warehouse/MesInvBusiness2Manager.cs
index 8704a00..13679e8 100644
--- a/MES.Service/service/Warehouse/MesInvBusiness2Manager.cs
+++ b/MES.Service/service/Warehouse/MesInvBusiness2Manager.cs
@@ -1,78 +1,78 @@
-锘縰sing SqlSugar;
-using System;
-using System.Collections.Generic;
-using MES.Service.DB;
+锘縰sing MES.Service.DB;
 using MES.Service.Modes;
+using SqlSugar;
 
-namespace MES.Service.service.Warehouse
-{
+namespace MES.Service.service.Warehouse;
+
 public class MesInvBusiness2Manager : Repository<MesInvBusiness2>
 {
- 
     //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
 
     //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesInvBusiness2Manager.cs
 
 
     #region 鏁欏鏂规硶
+
     /// <summary>
-    /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
+    ///     浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
     /// </summary>
     public void Study()
     {
-	     
-	   /*********鏌ヨ*********/
+        /*********鏌ヨ*********/
 
-        var data1 = base.GetById(1);//鏍规嵁ID鏌ヨ
-        var data2 = base.GetList();//鏌ヨ鎵�鏈�
-        var data3 = base.GetList(it => 1 == 1);  //鏍规嵁鏉′欢鏌ヨ  
+        var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ
+        var data2 = base.GetList(); //鏌ヨ鎵�鏈�
+        var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ  
         //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊
 
-        var p = new PageModel() { PageIndex = 1, PageSize = 2 };// 鍒嗛〉鏌ヨ
+        var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ
         var data5 = base.GetPageList(it => 1 == 1, p);
-        Console.Write(p.TotalCount);//杩斿洖鎬绘暟
+        Console.Write(p.TotalCount); //杩斿洖鎬绘暟
 
-        var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// 鍒嗛〉鏌ヨ鍔犳帓搴�
-        Console.Write(p.TotalCount);//杩斿洖鎬绘暟
-     
-        List<IConditionalModel> conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴�
-        conModels.Add(new ConditionalModel() { FieldName= typeof(MesInvBusiness2).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1
-        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc);
+        var data6 =
+            base.GetPageList(it => 1 == 1, p,
+                it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴�
+        Console.Write(p.TotalCount); //杩斿洖鎬绘暟
 
-        base.AsQueryable().Where(x => 1 == 1).ToList();//鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘
+        var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴�
+        conModels.Add(new ConditionalModel
+        {
+            FieldName = typeof(MesInvBusiness2).GetProperties()[0].Name,
+            ConditionalType = ConditionalType.Equal, FieldValue = "1"
+        }); //id=1
+        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());
 
- 
+        AsQueryable().Where(x => 1 == 1)
+            .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘
+
 
         /*********鎻掑叆*********/
-        var insertData = new MesInvBusiness2() { };//娴嬭瘯鍙傛暟
-        var insertArray = new MesInvBusiness2[] { insertData };
-        base.Insert(insertData);//鎻掑叆
-        base.InsertRange(insertArray);//鎵归噺鎻掑叆
-        var id = base.InsertReturnIdentity(insertData);//鎻掑叆杩斿洖鑷鍒�
-        base.AsInsertable(insertData).ExecuteCommand();//鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆
+        var insertData = new MesInvBusiness2(); //娴嬭瘯鍙傛暟
+        var insertArray = new[] { insertData };
+        base.Insert(insertData); //鎻掑叆
+        base.InsertRange(insertArray); //鎵归噺鎻掑叆
+        var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒�
+        AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆
 
 
-
-		/*********鏇存柊*********/
-	    var updateData = new MesInvBusiness2() {  };//娴嬭瘯鍙傛暟
-        var updateArray = new MesInvBusiness2[] { updateData };//娴嬭瘯鍙傛暟
-        base.Update(updateData);//鏍规嵁瀹炰綋鏇存柊
-        base.UpdateRange(updateArray);//鎵归噺鏇存柊
+        /*********鏇存柊*********/
+        var updateData = new MesInvBusiness2(); //娴嬭瘯鍙傛暟
+        var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟
+        base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊
+        base.UpdateRange(updateArray); //鎵归噺鏇存柊
         //base.Update(it => new MesInvBusiness2() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1
-        base.AsUpdateable(updateData).ExecuteCommand();  //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏�
+        AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏�
 
 
+        /*********鍒犻櫎*********/
+        var deldata = new MesInvBusiness2(); //娴嬭瘯鍙傛暟
+        base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎
+        base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎
+        base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎
+        base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎
+        AsDeleteable().Where(it => 1 == 2)
+            .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
+    }
 
-		/*********鍒犻櫎*********/
-	    var deldata = new MesInvBusiness2() {  };//娴嬭瘯鍙傛暟
-        base.Delete(deldata);//鏍规嵁瀹炰綋鍒犻櫎
-        base.DeleteById(1);//鏍规嵁涓婚敭鍒犻櫎
-        base.DeleteById(new int[] { 1,2});//鏍规嵁涓婚敭鏁扮粍鍒犻櫎
-        base.Delete(it=>1==2);//鏍规嵁鏉′欢鍒犻櫎
-        base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
-    } 
     #endregion
-
- 
- }
 }
\ No newline at end of file
diff --git a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
index 49ad635..f4a9f24 100644
--- a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
+++ b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
@@ -59,8 +59,8 @@
         // 鏌ヨ
         var result = Db
             .Queryable<MesQaItemsDetect01, MesInvItemArn, MesInvItemArnDetail,
-                MesItems, MesUnit,MesQaItemsDetectDetail5>(
-                (a, d, b, c, t,z) => new object[]
+                MesItems, MesUnit, MesQaItemsDetectDetail5>(
+                (a, d, b, c, t, z) => new object[]
                 {
                     JoinType.Inner, d.BillNo == a.LotNo,
                     JoinType.Inner, d.Id == b.Mid && b.ItemNo == a.ItemNo,
@@ -70,9 +70,9 @@
                     JoinType.Inner, c.Fpurchaseunitid == t.Id,
                     JoinType.Inner, z.ReleaseNo == a.ReleaseNo
                 })
-            .Where((a, d, b, c, t,z) => a.FngHandle == "閫�璐�" && 
-                      z.FcheckResu == "涓嶅悎鏍�" &&
-                                      query.ItemArnDetailIds.Contains(b.Id))
+            .Where((a, d, b, c, t, z) => a.FngHandle == "閫�璐�" &&
+                                         z.FcheckResu == "涓嶅悎鏍�" &&
+                                         query.ItemArnDetailIds.Contains(b.Id))
             .Select((a, d, b, c, t) => new Material
             {
                 FmrMode = a.Fmrmode,
diff --git a/MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs b/MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs
new file mode 100644
index 0000000..cf8c2a3
--- /dev/null
+++ b/MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs
@@ -0,0 +1,79 @@
+锘縰sing MES.Service.DB;
+using MES.Service.Modes;
+using SqlSugar;
+
+namespace MES.Service.service.Warehouse;
+
+public class
+    MesInvItemMovesCDetailsManager : Repository<MesInvItemMovesCDetails>
+{
+    //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
+
+    //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesInvItemMovesCDetailsManager.cs
+
+
+    #region 鏁欏鏂规硶
+
+    /// <summary>
+    ///     浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
+    /// </summary>
+    public void Study()
+    {
+        /*********鏌ヨ*********/
+
+        var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ
+        var data2 = base.GetList(); //鏌ヨ鎵�鏈�
+        var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ  
+        //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊
+
+        var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ
+        var data5 = base.GetPageList(it => 1 == 1, p);
+        Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+        var data6 =
+            base.GetPageList(it => 1 == 1, p,
+                it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴�
+        Console.Write(p.TotalCount); //杩斿洖鎬绘暟
+
+        var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴�
+        conModels.Add(new ConditionalModel
+        {
+            FieldName = typeof(MesInvItemMovesCDetails).GetProperties()[0].Name,
+            ConditionalType = ConditionalType.Equal, FieldValue = "1"
+        }); //id=1
+        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());
+
+        AsQueryable().Where(x => 1 == 1)
+            .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘
+
+
+        /*********鎻掑叆*********/
+        var insertData = new MesInvItemMovesCDetails(); //娴嬭瘯鍙傛暟
+        var insertArray = new[] { insertData };
+        base.Insert(insertData); //鎻掑叆
+        base.InsertRange(insertArray); //鎵归噺鎻掑叆
+        var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒�
+        AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆
+
+
+        /*********鏇存柊*********/
+        var updateData = new MesInvItemMovesCDetails(); //娴嬭瘯鍙傛暟
+        var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟
+        base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊
+        base.UpdateRange(updateArray); //鎵归噺鏇存柊
+        //base.Update(it => new MesInvItemMovesCDetails() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1
+        AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏�
+
+
+        /*********鍒犻櫎*********/
+        var deldata = new MesInvItemMovesCDetails(); //娴嬭瘯鍙傛暟
+        base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎
+        base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎
+        base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎
+        base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎
+        AsDeleteable().Where(it => 1 == 2)
+            .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣�
+    }
+
+    #endregion
+}
\ No newline at end of file
diff --git a/MES.Service/service/Warehouse/MesInvItemMovesManager.cs b/MES.Service/service/Warehouse/MesInvItemMovesManager.cs
new file mode 100644
index 0000000..59d36c3
--- /dev/null
+++ b/MES.Service/service/Warehouse/MesInvItemMovesManager.cs
@@ -0,0 +1,45 @@
+锘縰sing MES.Service.DB;
+using MES.Service.Dto.service;
+using MES.Service.Modes;
+using SqlSugar;
+
+namespace MES.Service.service.Warehouse;
+
+public class MesInvItemMovesManager : Repository<MesInvItemMoves>
+{
+    //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
+
+    //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesInvItemMovesManager.cs
+
+    public List<MesInvItemMoves> GetBillNo(WarehouseQuery query)
+    {
+        query.Factory = "1000";
+        query.Company = "1000";
+
+        return Db.Queryable<MesInvItemMoves>()
+            .Where(it =>
+                SqlFunc.IsNull(it.Status, 0) == 1 &&
+                SqlFunc.IsNull(it.Ts, 0) != 1)
+            .Where(it =>
+                it.Factory == query.Factory && it.Company == query.Company)
+            .OrderBy(it => it.Id, OrderByType.Desc).ToList();
+    }
+
+    //scan_out_show_DB
+    public List<InventoryItem> ScanOutShowDb(WarehouseQuery query)
+    {
+        var BillTypeId = 300;
+        var TransctionNo = 301;
+        query.Factory = "1000";
+        query.Company = "1000";
+
+        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,
+            query.billNo);
+
+        var results = Db.Ado.SqlQuery<InventoryItem>(sql);
+
+        return results;
+    }
+}
\ No newline at end of file
diff --git a/MES.Service/service/Warehouse/OpeningReceiptServer.cs b/MES.Service/service/Warehouse/OpeningReceiptServer.cs
index 74dc31e..d525417 100644
--- a/MES.Service/service/Warehouse/OpeningReceiptServer.cs
+++ b/MES.Service/service/Warehouse/OpeningReceiptServer.cs
@@ -18,37 +18,26 @@
     public MesInvItemBarcodes ScanInBarcodeQC(WarehouseQuery query)
     {
         if (string.IsNullOrWhiteSpace(query.sectionCode))
-        {
             throw new Exception("璇锋壂搴撲綅鏉$爜锛�");
-        }
 
         var depotCode = GetDepotCode(query.sectionCode);
         if (depotCode == null)
-        {
             throw new Exception($"002[搴撲綅缂栫爜 {query.sectionCode} 涓嶅瓨鍦紝璇风‘璁わ紒");
-        }
 
         var checkBarcodeAlreadyReceived =
             CheckBarcodeAlreadyReceived(query.barcode);
 
-        if (checkBarcodeAlreadyReceived > 0)
-        {
-            throw new Exception("鏉$爜閲嶅鎵弿锛岃鏍稿锛�");
-        }
+        if (checkBarcodeAlreadyReceived > 0) throw new Exception("鏉$爜閲嶅鎵弿锛岃鏍稿锛�");
 
         if (CheckBarcodeInStock(query.barcode) > 0)
-        {
             throw new Exception("鏉$爜宸插湪搴撳瓨涓紝璇锋牳瀵癸紒");
-        }
 
         var barcodeInfo = GetBarcodeInfo(query.barcode);
         if (barcodeInfo == null || barcodeInfo.ComeFlg != 0)
-        {
             throw new Exception("鏉$爜涓嶆槸鏈熷垵鏉$爜锛屾棤娉曠敤鏈熷垵鍏ュ簱锛�");
-        }
 
         var inventoryItemInId = GetOrCreateInventoryItemInId(barcodeInfo,
-            depotCode, query.userName, out string billNo);
+            depotCode, query.userName, out var billNo);
 
         UseTransaction(db =>
         {
@@ -71,15 +60,12 @@
         var mesInvItemBarcodes = Db.Queryable<MesInvItemBarcodes>()
             .Where(s => s.ItemBarcode == query.barcode).Count();
 
-        if (mesInvItemBarcodes <= 0)
-        {
-            throw new Exception("鏉$爜涓嶅瓨鍦�");
-        }
+        if (mesInvItemBarcodes <= 0) throw new Exception("鏉$爜涓嶅瓨鍦�");
 
         var mesInvItemInCDetails = Db.Queryable<MesInvItemInCDetails>()
             .Where(s => s.ItemBarcode == query.barcode).Single();
 
-        PurchaseInventory entity = new PurchaseInventory
+        var entity = new PurchaseInventory
         {
             ItemIns = GetMesInvItemIns(mesInvItemInCDetails.ItemInId),
             InvItemInCDetails =
@@ -153,10 +139,7 @@
             TaskNo = barcodeInfo.TaskNo
         }).ExecuteCommand();
 
-        if (executeCommand <= 0)
-        {
-            throw new Exception("鍐欏叆澶辫触");
-        }
+        if (executeCommand <= 0) throw new Exception("鍐欏叆澶辫触");
     }
 
     private decimal GetOrCreateInventoryItemInId(MesInvItemBarcodes barcodeInfo,
@@ -264,10 +247,7 @@
             SuppNo = barcodeInfo.SuppNo
         }).ExecuteCommand();
 
-        if (executeCommand <= 0)
-        {
-            throw new Exception("鍐欏叆澶辫触");
-        }
+        if (executeCommand <= 0) throw new Exception("鍐欏叆澶辫触");
     }
 
     private void InsertBusinessRecord(MesInvItemBarcodes barcodeInfo,
@@ -300,9 +280,6 @@
             SuppNo = barcodeInfo.SuppNo
         }).ExecuteCommand();
 
-        if (executeCommand <= 0)
-        {
-            throw new Exception("鍐欏叆澶辫触");
-        }
+        if (executeCommand <= 0) throw new Exception("鍐欏叆澶辫触");
     }
 }
\ No newline at end of file
diff --git a/MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs b/MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs
index 8819082..0cfbcc2 100644
--- a/MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs
+++ b/MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs
@@ -16,6 +16,48 @@
 
     /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/
 
+    //ScanInDepotSectionsName
+    [HttpPost("ScanInDepotSectionsName")]
+    public ResponseResult ScanInDepotSectionsName(WarehouseQuery query)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.ScanInDepotSectionsName(query);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    //ScanEditBarcode
+    [HttpPost("ScanEditBarcode")]
+    public ResponseResult ScanEditBarcode(WarehouseQuery query)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.ScanEditBarcode(query);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
     //GetSectionName
     [HttpPost("GetSectionName")]
     public ResponseResult GetSectionName(WarehouseQuery query)
diff --git a/MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs b/MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs
index c50ee43..bbcda91 100644
--- a/MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs
+++ b/MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs
@@ -1,170 +1,162 @@
-锘縰sing Microsoft.AspNetCore.Mvc;
-using Microsoft.Extensions.Logging;
-using SqlSugar;
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using System.Threading.Tasks;
-using System.Dynamic;
+锘縰sing System.Dynamic;
 using MES.Service.Modes;
-using MES.Service.service;
 using MES.Service.service.Warehouse;
 using MES.Service.util;
+using Microsoft.AspNetCore.Mvc;
 
-namespace MESApplication.Controllers.Warehouse
+namespace MESApplication.Controllers.Warehouse;
+
+[ApiController]
+[Route("api/[controller]")]
+public class MesInvBusiness2Controller : ControllerBase
 {
-    [ApiController]
-    [Route("api/[controller]")]
-    public class MesInvBusiness2Controller : ControllerBase
+    private readonly MesInvBusiness2Manager m = new();
+
+
+    /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/
+
+    /// <summary>
+    ///     鑾峰彇鎵�鏈�
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("GetList")]
+    public ResponseResult GetList()
     {
-        
-        private MesInvBusiness2Manager m = new MesInvBusiness2Manager();
-
-
-        /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/
-
-        /// <summary>
-        /// 鑾峰彇鎵�鏈�
-        /// </summary>
-        /// <returns></returns>
-        [HttpPost("GetList")]
-        public ResponseResult GetList()
+        try
         {
-            try
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.GetList();
+            return new ResponseResult
             {
-                dynamic resultInfos = new ExpandoObject();
-                resultInfos.tbBillList = m.GetList();
-                return new ResponseResult
-                {
-                    status = 0,
-                    message = "OK",
-                    data = resultInfos
-                };
-            }
-            catch (Exception ex)
-            {
-                return ResponseResult.ResponseError(ex);
-            }
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
         }
-
-
-        /// <summary>
-        /// 鏍规嵁涓婚敭鑾峰彇
-        /// </summary>
-        /// <returns></returns>
-        [HttpPost("GetById")]
-        public ResponseResult GetById(int id)
+        catch (Exception ex)
         {
-            try
-            {
-                dynamic resultInfos = new ExpandoObject();
-                resultInfos.tbBillList = m.GetById(id);
-                return new ResponseResult
-                {
-                    status = 0,
-                    message = "OK",
-                    data = resultInfos
-                };
-            }
-            catch (Exception ex)
-            {
-                return ResponseResult.ResponseError(ex);
-            }
-        }
-
-        /// <summary>
-        /// 鏍规嵁涓婚敭鍒犻櫎
-        /// </summary>
-        /// <returns></returns>
-        [HttpPost("DeleteByIds")]
-        public ResponseResult DeleteByIds([FromBody] object[] ids)
-        {
-            try
-            {
-                dynamic resultInfos = new ExpandoObject();
-                resultInfos.tbBillList = m.DeleteByIds(ids);
-                return new ResponseResult
-                {
-                    status = 0,
-                    message = "OK",
-                    data = resultInfos
-                };
-            }
-            catch (Exception ex)
-            {
-                return ResponseResult.ResponseError(ex);
-            }
-        }
-
-        /// <summary>
-        /// 娣诲姞 
-        /// </summary>
-        /// <returns></returns>
-        [HttpPost("Insert")]
-        public ResponseResult Add([FromBody] MesInvBusiness2 data)
-        {
-            try
-            {
-                dynamic resultInfos = new ExpandoObject();
-                resultInfos.tbBillList = m.Insert(data);
-                return new ResponseResult
-                {
-                    status = 0,
-                    message = "OK",
-                    data = resultInfos
-                };
-            }
-            catch (Exception ex)
-            {
-                return ResponseResult.ResponseError(ex);
-            }
-        }
-        /// <summary>
-        /// 娣诲姞杩斿洖鑷
-        /// </summary>
-        /// <returns></returns>
-        [HttpPost("InsertReturnIdentity")]
-        public ResponseResult InsertReturnIdentity([FromBody] MesInvBusiness2 data)
-        {
-            try
-            {
-                dynamic resultInfos = new ExpandoObject();
-                resultInfos.tbBillList = m.InsertReturnIdentity(data);
-                return new ResponseResult
-                {
-                    status = 0,
-                    message = "OK",
-                    data = resultInfos
-                };
-            }
-            catch (Exception ex)
-            {
-                return ResponseResult.ResponseError(ex);
-            }
-        }
-
-        /// <summary>
-        /// 淇敼
-        /// </summary>
-        /// <returns></returns>
-        [HttpPost("Update")]
-        public ResponseResult Update([FromBody] MesInvBusiness2 data)
-        {
-            try
-            {
-                dynamic resultInfos = new ExpandoObject();
-                resultInfos.tbBillList = m.Update(data);
-                return new ResponseResult
-                {
-                    status = 0,
-                    message = "OK",
-                    data = resultInfos
-                };
-            }
-            catch (Exception ex)
-            {
-                return ResponseResult.ResponseError(ex);
-            }
+            return ResponseResult.ResponseError(ex);
         }
     }
-}
+
+
+    /// <summary>
+    ///     鏍规嵁涓婚敭鑾峰彇
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("GetById")]
+    public ResponseResult GetById(int id)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.GetById(id);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     鏍规嵁涓婚敭鍒犻櫎
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("DeleteByIds")]
+    public ResponseResult DeleteByIds([FromBody] object[] ids)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.DeleteByIds(ids);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     娣诲姞
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("Insert")]
+    public ResponseResult Add([FromBody] MesInvBusiness2 data)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.Insert(data);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     娣诲姞杩斿洖鑷
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("InsertReturnIdentity")]
+    public ResponseResult InsertReturnIdentity([FromBody] MesInvBusiness2 data)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.InsertReturnIdentity(data);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     淇敼
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("Update")]
+    public ResponseResult Update([FromBody] MesInvBusiness2 data)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.Update(data);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+}
\ No newline at end of file
diff --git a/MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs b/MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs
new file mode 100644
index 0000000..fb0be61
--- /dev/null
+++ b/MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs
@@ -0,0 +1,163 @@
+锘縰sing System.Dynamic;
+using MES.Service.Modes;
+using MES.Service.service.Warehouse;
+using MES.Service.util;
+using Microsoft.AspNetCore.Mvc;
+
+namespace MESApplication.Controllers.Warehouse;
+
+[ApiController]
+[Route("api/[controller]")]
+public class MesInvItemMovesCDetailsController : ControllerBase
+{
+    private readonly MesInvItemMovesCDetailsManager m = new();
+
+
+    /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/
+
+    /// <summary>
+    ///     鑾峰彇鎵�鏈�
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("GetList")]
+    public ResponseResult GetList()
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.GetList();
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+
+    /// <summary>
+    ///     鏍规嵁涓婚敭鑾峰彇
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("GetById")]
+    public ResponseResult GetById(int id)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.GetById(id);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     鏍规嵁涓婚敭鍒犻櫎
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("DeleteByIds")]
+    public ResponseResult DeleteByIds([FromBody] object[] ids)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.DeleteByIds(ids);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     娣诲姞
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("Insert")]
+    public ResponseResult Add([FromBody] MesInvItemMovesCDetails data)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.Insert(data);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     娣诲姞杩斿洖鑷
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("InsertReturnIdentity")]
+    public ResponseResult InsertReturnIdentity(
+        [FromBody] MesInvItemMovesCDetails data)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.InsertReturnIdentity(data);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     淇敼
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("Update")]
+    public ResponseResult Update([FromBody] MesInvItemMovesCDetails data)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.Update(data);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+}
\ No newline at end of file
diff --git a/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs b/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs
new file mode 100644
index 0000000..d8106fb
--- /dev/null
+++ b/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs
@@ -0,0 +1,204 @@
+锘縰sing System.Dynamic;
+using MES.Service.Dto.service;
+using MES.Service.Modes;
+using MES.Service.service.Warehouse;
+using MES.Service.util;
+using Microsoft.AspNetCore.Mvc;
+
+namespace MESApplication.Controllers.Warehouse;
+
+[ApiController]
+[Route("api/[controller]")]
+public class MesInvItemMovesController : ControllerBase
+{
+    private readonly MesInvItemMovesManager m = new();
+
+    // GetBillNo
+    [HttpPost("GetBillNo")]
+    public ResponseResult GetBillNo(WarehouseQuery query)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.GetBillNo(query);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+    
+    //ScanOutShowDb
+    [HttpPost("ScanOutShowDb")]
+    public ResponseResult ScanOutShowDb(WarehouseQuery query)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.GetBillNo(query);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+
+    /// <summary>
+    ///     鑾峰彇鎵�鏈�
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("GetList")]
+    public ResponseResult GetList()
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.GetList();
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+
+    /// <summary>
+    ///     鏍规嵁涓婚敭鑾峰彇
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("GetById")]
+    public ResponseResult GetById(int id)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.GetById(id);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     鏍规嵁涓婚敭鍒犻櫎
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("DeleteByIds")]
+    public ResponseResult DeleteByIds([FromBody] object[] ids)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.DeleteByIds(ids);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     娣诲姞
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("Insert")]
+    public ResponseResult Add([FromBody] MesInvItemMoves data)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.Insert(data);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     娣诲姞杩斿洖鑷
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("InsertReturnIdentity")]
+    public ResponseResult InsertReturnIdentity(
+        [FromBody] MesInvItemMoves data)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.InsertReturnIdentity(data);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     淇敼
+    /// </summary>
+    /// <returns></returns>
+    [HttpPost("Update")]
+    public ResponseResult Update([FromBody] MesInvItemMoves data)
+    {
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            resultInfos.tbBillList = m.Update(data);
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+}
\ No newline at end of file
diff --git a/MESApplication/Controllers/Warehouse/OpeningReceiptController.cs b/MESApplication/Controllers/Warehouse/OpeningReceiptController.cs
index 9ed6425..cda99fa 100644
--- a/MESApplication/Controllers/Warehouse/OpeningReceiptController.cs
+++ b/MESApplication/Controllers/Warehouse/OpeningReceiptController.cs
@@ -31,7 +31,7 @@
             return ResponseResult.ResponseError(ex);
         }
     }
-    
+
     [HttpPost("GetForm")]
     public ResponseResult GetForm(WarehouseQuery query)
     {

--
Gitblit v1.9.3