From 1be2fc056943ba8b9e62328430e15beee03e8a9f Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期一, 02 六月 2025 13:46:48 +0800
Subject: [PATCH] 1.生产补料优化 2.首检开发-v1
---
entity/MesInvItemStocks.cs | 418 ++++++++++++++++++++++++++++++++++-------------------------
1 files changed, 240 insertions(+), 178 deletions(-)
diff --git a/entity/MesInvItemStocks.cs b/entity/MesInvItemStocks.cs
index 9dda5fc..ac0078b 100644
--- a/entity/MesInvItemStocks.cs
+++ b/entity/MesInvItemStocks.cs
@@ -1,182 +1,244 @@
锘縰sing SqlSugar;
-namespace NewPdaSqlServer.entity
+namespace NewPdaSqlServer.entity;
+
+/// <summary>
+/// 鐗╂枡搴撳瓨琛�
+/// </summary>
+[SugarTable("MES_INV_ITEM_STOCKS")]
+public class MesInvItemStocks
{
/// <summary>
- /// 鐗╂枡搴撳瓨琛�
- ///</summary>
- [SugarTable("MES_INV_ITEM_STOCKS")]
- public class MesInvItemStocks
- {
- /// <summary>
- ///
- /// 榛樿鍊�: (newid())
- ///</summary>
- [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
- public Guid Guid { get; set; }
- /// <summary>
- /// 鐢熶骇璁㈠崟
- ///</summary>
- [SugarColumn(ColumnName="TASK_NO" )]
- public string TaskNo { 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>
- /// 瀛愬簱id
- ///</summary>
- [SugarColumn(ColumnName="DEPOTS_ID" )]
- public long? DepotsId { get; set; }
- /// <summary>
- /// 璐т綅id
- ///</summary>
- [SugarColumn(ColumnName="DEPOT_SECTIONS_ID" )]
- public long? DepotSectionsId { get; set; }
- /// <summary>
- /// 鍘傚鎵规
- ///</summary>
- [SugarColumn(ColumnName="LOT_NO" )]
- public string LotNo { get; set; }
- /// <summary>
- /// 鏁伴噺
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName="QUANTITY" )]
- public decimal? Quantity { get; set; }
- /// <summary>
- /// 鐜繚鏍囧織锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級(0-鍚︼紝1-鏄�)
- ///</summary>
- [SugarColumn(ColumnName="EP_FLAG" )]
- public byte? EpFlag { get; set; }
- /// <summary>
- /// 瀹㈡埛缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="CUSTOMER_NO" )]
- public string CustomerNo { get; set; }
- /// <summary>
- /// 閲嶉噺
- ///</summary>
- [SugarColumn(ColumnName="ITEM_WT" )]
- public decimal? ItemWt { get; set; }
- /// <summary>
- /// 瀛愬簱CODE
- ///</summary>
- [SugarColumn(ColumnName="DEPOTS_CODE" )]
- public string DepotsCode { get; set; }
- /// <summary>
- /// 璐т綅CODE
- ///</summary>
- [SugarColumn(ColumnName="DEPOT_SECTIONS_CODE" )]
- public string DepotSectionsCode { get; set; }
- /// <summary>
- /// 妫�楠屾棩鏈�
- ///</summary>
- [SugarColumn(ColumnName="CHECK_DATE" )]
- public DateTime? CheckDate { get; set; }
- /// <summary>
- /// 0 鐗╂枡 1 鍗婃垚鍝� 2 鎴愬搧
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName="ITEM_TYPE" )]
- public byte? ItemType { get; set; }
- /// <summary>
- /// 鍏ュ簱鏃ユ湡
- /// 榛樿鍊�: (getdate())
- ///</summary>
- [SugarColumn(ColumnName="INDEP_DATE" )]
- public DateTime? IndepDate { 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="IQC_STATUS" )]
- public string IqcStatus { get; set; }
- /// <summary>
- /// F鍗�
- ///</summary>
- [SugarColumn(ColumnName="FCAR" )]
- public string Fcar { get; set; }
- /// <summary>
- /// 鍙鎻愪氦鏍囧織锛�0-鍚︼紝1-鏄級
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName="VISABLE_SUBMIT" )]
- public byte? 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 int? 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>
- /// 鍗曟嵁缂栧彿
- ///</summary>
- [SugarColumn(ColumnName="BILL_NO" )]
- public string BillNo { get; set; }
- /// <summary>
- /// K3ID
- ///</summary>
- [SugarColumn(ColumnName="EBELN_K3ID" )]
- public long? EbelnK3id { get; set; }
- /// <summary>
- /// 琛孠3ID
- ///</summary>
- [SugarColumn(ColumnName="LINE_K3ID" )]
- public long? LineK3id { get; set; }
- /// <summary>
- /// 鐗╂枡ID
- ///</summary>
- [SugarColumn(ColumnName="ITEM_ID" )]
- public long? ItemId { get; set; }
- }
-}
+ /// 榛樿鍊�: (newid())
+ /// </summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇璁㈠崟
+ /// </summary>
+ [SugarColumn(ColumnName = "TASK_NO")]
+ public string? TaskNo { 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>
+ /// 瀛愬簱id
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOTS_ID")]
+ public long? DepotsId { get; set; }
+
+ /// <summary>
+ /// 璐т綅id
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")]
+ public long? DepotSectionsId { get; set; }
+
+ /// <summary>
+ /// 鍘傚鎵规
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO")]
+ public string? LotNo { get; set; }
+
+ /// <summary>
+ /// 鏁伴噺
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "QUANTITY")]
+ public decimal? Quantity { get; set; }
+
+ /// <summary>
+ /// 鐜繚鏍囧織锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級(0-鍚︼紝1-鏄�)
+ /// </summary>
+ [SugarColumn(ColumnName = "EP_FLAG")]
+ public byte? EpFlag { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "CUSTOMER_NO")]
+ public string? CustomerNo { get; set; }
+
+ /// <summary>
+ /// 閲嶉噺
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_WT")]
+ public decimal? ItemWt { get; set; }
+
+ /// <summary>
+ /// 瀛愬簱CODE
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOTS_CODE")]
+ public string? DepotsCode { get; set; }
+
+ /// <summary>
+ /// 璐т綅CODE
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")]
+ public string? DepotSectionsCode { get; set; }
+
+ /// <summary>
+ /// 妫�楠屾棩鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "CHECK_DATE")]
+ public DateTime? CheckDate { get; set; }
+
+ /// <summary>
+ /// 0 鐗╂枡 1 鍗婃垚鍝� 2 鎴愬搧
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_TYPE")]
+ public byte? ItemType { get; set; }
+
+ /// <summary>
+ /// 鍏ュ簱鏃ユ湡
+ /// 榛樿鍊�: (getdate())
+ /// </summary>
+ [SugarColumn(ColumnName = "INDEP_DATE")]
+ public DateTime? IndepDate { 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 = "IQC_STATUS")]
+ public string? IqcStatus { get; set; }
+
+ /// <summary>
+ /// F鍗�
+ /// </summary>
+ [SugarColumn(ColumnName = "FCAR")]
+ public string? Fcar { get; set; }
+
+ /// <summary>
+ /// 鍙鎻愪氦鏍囧織锛�0-鍚︼紝1-鏄級
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "VISABLE_SUBMIT")]
+ public byte? 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 int? 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>
+ /// 鍗曟嵁缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
+ public string? BillNo { get; set; }
+
+ /// <summary>
+ /// K3ID
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN_K3ID")]
+ public long? EbelnK3id { get; set; }
+
+ /// <summary>
+ /// 琛孠3ID
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_K3ID")]
+ public long? LineK3id { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
+ public long? ItemId { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPP_ID")]
+ public string? SuppId { get; set; }
+
+ /// <summary>
+ /// 浠撳簱ID
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_ID")]
+ public int? DepotId { get; set; }
+
+ /// <summary>
+ /// 鍏ュ簱浜哄憳缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "INDEP_USER_CODE")]
+ public string? IndepUserCode { get; set; }
+ /// <summary>
+ /// 璐т富id
+ /// </summary>
+ [SugarColumn(ColumnName = "Owner_Id")]
+ public string? OwnerId { get; set; }
+ /// <summary>
+ /// 璐т富绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "Owner_Type")]
+ public string? OwnerType { get; set; }
+ /// <summary>
+ /// 搴撳瓨缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "Stock_Org_Id")]
+ public string? StockOrgId { get; set; }
+}
\ No newline at end of file
--
Gitblit v1.9.3