From eda0c8f74ce453b6e43f88fc92b1e651ce5b6095 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期四, 13 二月 2025 13:46:33 +0800
Subject: [PATCH] 1.条码表实体类型调整 2.条码库存表实体新增基础字段 3.期初入库新增入库人
---
entity/MesInvItemStocks.cs | 385 +++++++++++++++++++++++++++++-------------------------
1 files changed, 206 insertions(+), 179 deletions(-)
diff --git a/entity/MesInvItemStocks.cs b/entity/MesInvItemStocks.cs
index 27020f4..ac0078b 100644
--- a/entity/MesInvItemStocks.cs
+++ b/entity/MesInvItemStocks.cs
@@ -1,217 +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; }
+ /// 榛樿鍊�: (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 = "TASK_NO")]
+ public string? TaskNo { get; set; }
- /// <summary>
- /// 鐗╂枡鏉＄爜
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
- public string? ItemBarcode { get; set; }
+ /// <summary>
+ /// 鐗╂枡鏉＄爜
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_BARCODE")]
+ public string? ItemBarcode { get; set; }
- /// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- ///</summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
- public string? CItemCode { get; set; }
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
+ /// </summary>
+ [SugarColumn(ColumnName = "C_ITEM_CODE")]
+ public string? CItemCode { get; set; }
- /// <summary>
- /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string? ItemNo { get; set; }
+ /// <summary>
+ /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
+ public string? ItemNo { get; set; }
- /// <summary>
- /// 瀛愬簱id
- ///</summary>
- [SugarColumn(ColumnName = "DEPOTS_ID")]
- public long? DepotsId { 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>
+ /// 璐т綅id
+ /// </summary>
+ [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")]
+ public long? DepotSectionsId { get; set; }
- /// <summary>
- /// 鍘傚鎵规
- ///</summary>
- [SugarColumn(ColumnName = "LOT_NO")]
- public string? LotNo { get; set; }
+ /// <summary>
+ /// 鍘傚鎵规
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NO")]
+ public string? LotNo { get; set; }
- /// <summary>
- /// 鏁伴噺
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { 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>
+ /// 鐜繚鏍囧織锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級(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 = "CUSTOMER_NO")]
+ public string? CustomerNo { get; set; }
- /// <summary>
- /// 閲嶉噺
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_WT")]
- public decimal? ItemWt { 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 = "DEPOTS_CODE")]
+ public string? DepotsCode { get; set; }
- /// <summary>
- /// 璐т綅CODE
- ///</summary>
- [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")]
- public string? DepotSectionsCode { 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>
+ /// 妫�楠屾棩鏈�
+ /// </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>
+ /// 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>
+ /// 鍏ュ簱鏃ユ湡
+ /// 榛樿鍊�: (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 = "FACTORY")]
+ public string? Factory { get; set; }
- /// <summary>
- /// 鍏徃缂栧彿
- ///</summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string? Company { get; set; }
+ /// <summary>
+ /// 鍏徃缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "COMPANY")]
+ public string? Company { get; set; }
- /// <summary>
- /// 璐ㄩ噺鐘舵��
- ///</summary>
- [SugarColumn(ColumnName = "IQC_STATUS")]
- public string? IqcStatus { get; set; }
+ /// <summary>
+ /// 璐ㄩ噺鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "IQC_STATUS")]
+ public string? IqcStatus { get; set; }
- /// <summary>
- /// F鍗�
- ///</summary>
- [SugarColumn(ColumnName = "FCAR")]
- public string? Fcar { 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>
+ /// 鍙鎻愪氦鏍囧織锛�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_BY")]
+ public string? VisableSubmitBy { get; set; }
- /// <summary>
- /// 鍙鎻愪氦鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")]
- public DateTime? VisableSubmitDate { 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 = "BOARD_STYLE")]
+ public string? BoardStyle { get; set; }
- /// <summary>
- /// 宸ュ崟鍙�
- ///</summary>
- [SugarColumn(ColumnName = "WORK_NO")]
- public string? WorkNo { get; set; }
+ /// <summary>
+ /// 宸ュ崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "WORK_NO")]
+ public string? WorkNo { get; set; }
- /// <summary>
- /// 宸ュ崟琛屽彿
- ///</summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
- public int? WorkLine { 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 = "SUPP_NO")]
+ public string? SuppNo { get; set; }
- /// <summary>
- /// 琛屽彿
- ///</summary>
- [SugarColumn(ColumnName = "LINE_NO")]
- public string? LineNo { 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>
+ /// 鍗曟嵁缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_NO")]
+ public string? BillNo { get; set; }
- /// <summary>
- /// K3ID
- ///</summary>
- [SugarColumn(ColumnName = "EBELN_K3ID")]
- public long? EbelnK3id { 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>
+ /// 琛孠3ID
+ /// </summary>
+ [SugarColumn(ColumnName = "LINE_K3ID")]
+ public long? LineK3id { get; set; }
- /// <summary>
- /// 鐗╂枡ID
- ///</summary>
- [SugarColumn(ColumnName = "ITEM_ID")]
- public long? ItemId { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ITEM_ID")]
+ public long? ItemId { get; set; }
- [SugarColumn(ColumnName = "SUPP_ID")]
- public string? SuppId { 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