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/Modes/MesInvBusiness2.cs |  419 ++++++++++++++++++++++++++++++++---------------------------
 1 files changed, 226 insertions(+), 193 deletions(-)

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>
-        /// 鍏徃浠ｇ爜 
-        ///</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>
+ ///     鍏徃浠ｇ爜
+ /// </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

--
Gitblit v1.9.3