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/MesInvBusiness2.cs | 411 ++++++++++++++++++++++++++++++----------------------------
1 files changed, 215 insertions(+), 196 deletions(-)
diff --git a/entity/MesInvBusiness2.cs b/entity/MesInvBusiness2.cs
index 5a68af3..04db7d7 100644
--- a/entity/MesInvBusiness2.cs
+++ b/entity/MesInvBusiness2.cs
@@ -1,238 +1,257 @@
锘縰sing SqlSugar;
-namespace NewPdaSqlServer.entity
+namespace NewPdaSqlServer.entity;
+
+/// <summary>
+/// 搴撳瓨浜ゆ槗璁板綍琛�
+/// </summary>
+[SugarTable("MES_INV_BUSINESS2")]
+public class MesInvBusiness2
{
/// <summary>
- /// 搴撳瓨浜ゆ槗璁板綍琛�
- ///</summary>
- [SugarTable("MES_INV_BUSINESS2")]
- public class MesInvBusiness2
- {
- /// <summary>
- /// ID(seq_inv_id)
- /// 榛樿鍊�: (newid())
- ///</summary>
- [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
- public Guid Guid { get; set; }
+ /// ID(seq_inv_id)
+ /// 榛樿鍊�: (newid())
+ /// </summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
- /// <summary>
- /// 鐘舵�亅0-鏈氦鏄�1-宸蹭氦鏄�
- ///</summary>
- [SugarColumn(ColumnName = "STATUS")]
- public long? Status { get; set; }
+ /// <summary>
+ /// 鐘舵�亅0-鏈氦鏄�1-宸蹭氦鏄�
+ /// </summary>
+ [SugarColumn(ColumnName = "STATUS")]
+ public long? Status { get; set; }
- /// <summary>
- /// 鍗曟嵁绫诲瀷ID
- ///</summary>
- [SugarColumn(ColumnName = "BILL_TYPE_ID")]
- public long? BillTypeId { get; set; }
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_TYPE_ID")]
+ public long? BillTypeId { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷缂栫爜
- ///</summary>
- [SugarColumn(ColumnName = "TRANSACTION_CODE")]
- public string? TransactionCode { get; set; }
+ /// <summary>
+ /// 浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "TRANSACTION_CODE")]
+ public string? TransactionCode { get; set; }
- /// <summary>
- /// 浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱
- ///</summary>
- [SugarColumn(ColumnName = "BUSINESS_TYPE")]
- public long? BusinessType { get; set; }
+ /// <summary>
+ /// 浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱
+ /// </summary>
+ [SugarColumn(ColumnName = "BUSINESS_TYPE")]
+ public long? BusinessType { get; set; }
- /// <summary>
- /// 鍗曟嵁ID
- ///</summary>
- [SugarColumn(ColumnName = "BILL_ID")]
- public long? BillId { get; set; }
+ /// <summary>
+ /// 鍗曟嵁ID
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_ID")]
+ public long? BillId { 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>
- /// 鐢熶骇璁㈠崟鍙�
- ///</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 = "CUSTOMER_NO")]
- public string? CustomerNo { get; set; }
+ /// <summary>
+ /// 瀹㈡埛缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CUSTOMER_NO")]
+ public string? CustomerNo { get; set; }
- /// <summary>
- /// 鍗曟嵁琛孖D
- ///</summary>
- [SugarColumn(ColumnName = "BILL_LINE_ID")]
- public long? BillLineId { get; set; }
+ /// <summary>
+ /// 鍗曟嵁琛孖D
+ /// </summary>
+ [SugarColumn(ColumnName = "BILL_LINE_ID")]
+ public long? BillLineId { 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 = "ITEM_NO")]
- public string? ItemNo { 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 = "C_ITEM_CODE")]
+ public string? CItemCode { 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:鍚�,1:鏄�)
- ///</summary>
- [SugarColumn(ColumnName = "EP_FLAG")]
- public bool? EpFlag { get; set; }
+ /// <summary>
+ /// 鏄惁鐜繚(0:鍚�,1:鏄�)
+ /// </summary>
+ [SugarColumn(ColumnName = "EP_FLAG")]
+ public bool? EpFlag { get; set; }
- /// <summary>
- /// 鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { 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_DEPOTS_CODE")]
+ public string? FromInvDepotsCode { get; set; }
- /// <summary>
- /// 婧愯揣浣岰ODE
- ///</summary>
- [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")]
- public string? FromInvDepotSectionsCode { 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_DEPOTS_CODE")]
+ public string? ToInvDepotsCode { get; set; }
- /// <summary>
- /// 鐩殑璐т綅CODE
- ///</summary>
- [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")]
- public string? ToInvDepotSectionsCode { 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 = "DESCRIPTION")]
+ public string? Description { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- ///</summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
- public string? CreateBy { 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 = "CREATE_DATE")]
+ public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- ///</summary>
- [SugarColumn(ColumnName = "LASTUPDATE_BY")]
- public string? LastupdateBy { 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 = "LASTUPDATE_DATE")]
+ public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 瓒呮崯缁熻鏍囪瘑
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")]
- public bool? UllageStatFlag { get; set; }
+ /// <summary>
+ /// 瓒呮崯缁熻鏍囪瘑
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")]
+ public bool? UllageStatFlag { 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 = "ITEM_BARCODE2")]
- public string? ItemBarcode2 { 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 = "ITEM_BARCODE3")]
+ public string? ItemBarcode3 { 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>
- /// 閲囪喘璁㈠崟id
- ///</summary>
- [SugarColumn(ColumnName = "EBELN_K3ID")]
- public long? EbelnK3id { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟id
+ /// </summary>
+ [SugarColumn(ColumnName = "EBELN_K3ID")]
+ public long? EbelnK3id { get; set; }
- /// <summary>
- /// 閲囪喘璁㈠崟琛宨d
- ///</summary>
- [SugarColumn(ColumnName = "LINE_K3ID")]
- public long? LineK3id { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛宨d
+ /// </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>
+ /// 婧愪粨搴揑D
+ /// </summary>
+ [SugarColumn(ColumnName = "FROM_DEPOT_ID")]
+ public int? FromDepotId { get; set; }
+
+ /// <summary>
+ /// 鐩殑浠撳簱ID
+ /// </summary>
+ [SugarColumn(ColumnName = "INV_DEPOT_ID")]
+ public int? InvDepotId { get; set; }
+
+ /// <summary>
+ /// mes鍗曟嵁鏄庣粏琛宨d
+ /// </summary>
+ [SugarColumn(ColumnName = "MES_LINE")]
+ public Guid? MesLine { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3