From 389d011a94ffdcc620dbfe49e96d48f8baaaf69a Mon Sep 17 00:00:00 2001
From: 展杰 <1240968267@qq.com>
Date: 星期二, 13 八月 2024 14:34:19 +0800
Subject: [PATCH] 1

---
 MES.Service/Modes/MesInvItemStocks.cs |  256 +++++++++++++++++++++++++-------------------------
 1 files changed, 129 insertions(+), 127 deletions(-)

diff --git a/MES.Service/Modes/MesInvItemStocks.cs b/MES.Service/Modes/MesInvItemStocks.cs
index 87babea..c3c46e1 100644
--- a/MES.Service/Modes/MesInvItemStocks.cs
+++ b/MES.Service/Modes/MesInvItemStocks.cs
@@ -8,194 +8,196 @@
 [SugarTable("MES_INV_ITEM_STOCKS")]
 public class MesInvItemStocks
 {
-   /// <summary>
-   /// </summary>
-   [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+    /// <summary>
+    /// SEQ_ME_ID 
+    /// </summary>
+    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ME_ID",
+        IsPrimaryKey = true)]
     public decimal Id { get; set; }
 
-   /// <summary>
-   ///     鐢熶骇璁㈠崟
-   /// </summary>
-   [SugarColumn(ColumnName = "TASK_NO")]
+    /// <summary>
+    ///     鐢熶骇璁㈠崟
+    /// </summary>
+    [SugarColumn(ColumnName = "TASK_NO")]
     public string TaskNo { get; set; }
 
-   /// <summary>
-   ///     鐗╂枡鏉＄爜
-   /// </summary>
-   [SugarColumn(ColumnName = "ITEM_BARCODE")]
+    /// <summary>
+    ///     鐗╂枡鏉＄爜
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_BARCODE")]
     public string ItemBarcode { 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>
-   ///     瀛愬簱id
-   /// </summary>
-   [SugarColumn(ColumnName = "DEPOTS_ID")]
+    /// <summary>
+    ///     瀛愬簱id
+    /// </summary>
+    [SugarColumn(ColumnName = "DEPOTS_ID")]
     public decimal? DepotsId { get; set; }
 
-   /// <summary>
-   ///     璐т綅id
-   /// </summary>
-   [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")]
+    /// <summary>
+    ///     璐т綅id
+    /// </summary>
+    [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")]
     public decimal? DepotSectionsId { 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 = "CUSTOMER_NO")]
+    /// <summary>
+    ///     瀹㈡埛缂栫爜
+    /// </summary>
+    [SugarColumn(ColumnName = "CUSTOMER_NO")]
     public string CustomerNo { get; set; }
 
-   /// <summary>
-   ///     閲嶉噺
-   /// </summary>
-   [SugarColumn(ColumnName = "ITEM_WT")]
+    /// <summary>
+    ///     閲嶉噺
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_WT")]
     public decimal? ItemWt { get; set; }
 
-   /// <summary>
-   ///     瀛愬簱CODE
-   /// </summary>
-   [SugarColumn(ColumnName = "DEPOTS_CODE")]
+    /// <summary>
+    ///     瀛愬簱CODE
+    /// </summary>
+    [SugarColumn(ColumnName = "DEPOTS_CODE")]
     public string DepotsCode { get; set; }
 
-   /// <summary>
-   ///     璐т綅CODE
-   /// </summary>
-   [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")]
+    /// <summary>
+    ///     璐т綅CODE
+    /// </summary>
+    [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")]
     public string DepotSectionsCode { get; set; }
 
-   /// <summary>
-   ///     妫�楠屾棩鏈�
-   /// </summary>
-   [SugarColumn(ColumnName = "CHECK_DATE")]
+    /// <summary>
+    ///     妫�楠屾棩鏈�
+    /// </summary>
+    [SugarColumn(ColumnName = "CHECK_DATE")]
     public DateTime? CheckDate { get; set; }
 
-   /// <summary>
-   ///     0 鐗╂枡 1 鍗婃垚鍝� 2 鎴愬搧
-   /// </summary>
-   [SugarColumn(ColumnName = "ITEM_TYPE")]
+    /// <summary>
+    ///     0 鐗╂枡 1 鍗婃垚鍝� 2 鎴愬搧
+    /// </summary>
+    [SugarColumn(ColumnName = "ITEM_TYPE")]
     public short? ItemType { get; set; }
 
-   /// <summary>
-   ///     鍏ュ簱鏃ユ湡
-   /// </summary>
-   [SugarColumn(ColumnName = "INDEP_DATE")]
+    /// <summary>
+    ///     鍏ュ簱鏃ユ湡
+    /// </summary>
+    [SugarColumn(ColumnName = "INDEP_DATE")]
     public DateTime? IndepDate { 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 = "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>
-   ///     鍐荤粨鎻愪氦閲嶆锛�0锛氬喕缁撴湭鎻愪氦閲嶆锛�1锛氬喕缁撳苟鎻愪氦閲嶆
-   /// </summary>
-   [SugarColumn(ColumnName = "VISABLE_SUBMIT")]
+    /// <summary>
+    ///     鍐荤粨鎻愪氦閲嶆锛�0锛氬喕缁撴湭鎻愪氦閲嶆锛�1锛氬喕缁撳苟鎻愪氦閲嶆
+    /// </summary>
+    [SugarColumn(ColumnName = "VISABLE_SUBMIT")]
     public short? VisableSubmit { get; set; }
 
-   /// <summary>
-   ///     鎻愪氦閲嶆浜�
-   /// </summary>
-   [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")]
+    /// <summary>
+    ///     鎻愪氦閲嶆浜�
+    /// </summary>
+    [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")]
     public string VisableSubmitBy { get; set; }
 
-   /// <summary>
-   ///     鎻愪氦閲嶆鏃堕棿
-   /// </summary>
-   [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")]
+    /// <summary>
+    ///     鎻愪氦閲嶆鏃堕棿
+    /// </summary>
+    [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")]
     public DateTime? VisableSubmitDate { get; set; }
 
-   /// <summary>
-   ///     浜у搧鍨嬪彿
-   /// </summary>
-   [SugarColumn(ColumnName = "BOARD_STYLE")]
+    /// <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 = "WORK_LINE")]
+    /// <summary>
+    ///     浠诲姟鍗曡鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "WORK_LINE")]
     public decimal? WorkLine { get; set; }
 
-   /// <summary>
-   ///     渚涘簲鍟�
-   /// </summary>
-   [SugarColumn(ColumnName = "SUPP_NO")]
+    /// <summary>
+    ///     渚涘簲鍟�
+    /// </summary>
+    [SugarColumn(ColumnName = "SUPP_NO")]
     public string SuppNo { get; set; }
 
-   /// <summary>
-   ///     鐢熶骇绾�
-   /// </summary>
-   [SugarColumn(ColumnName = "LINE_NO")]
+    /// <summary>
+    ///     鐢熶骇绾�
+    /// </summary>
+    [SugarColumn(ColumnName = "LINE_NO")]
     public string LineNo { get; set; }
 
-   /// <summary>
-   ///     鍗婃垚鍝佸叆搴撳崟鍙�
-   /// </summary>
-   [SugarColumn(ColumnName = "BILL_NO")]
+    /// <summary>
+    ///     鍗婃垚鍝佸叆搴撳崟鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "BILL_NO")]
     public string BillNo { get; set; }
 
-   /// <summary>
-   ///     閲囪喘璁㈠崟id
-   /// </summary>
-   [SugarColumn(ColumnName = "EBELN_K3ID")]
+    /// <summary>
+    ///     閲囪喘璁㈠崟id
+    /// </summary>
+    [SugarColumn(ColumnName = "EBELN_K3ID")]
     public decimal? EbelnK3id { get; set; }
 
-   /// <summary>
-   ///     閲囪喘璁㈠崟琛宨d
-   /// </summary>
-   [SugarColumn(ColumnName = "LINE_K3ID")]
+    /// <summary>
+    ///     閲囪喘璁㈠崟琛宨d
+    /// </summary>
+    [SugarColumn(ColumnName = "LINE_K3ID")]
     public decimal? LineK3id { get; set; }
 }
\ No newline at end of file

--
Gitblit v1.9.3