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/MesInvItemArn.cs | 459 +++++++++++++++++++++++++++++++-------------------------
1 files changed, 254 insertions(+), 205 deletions(-)
diff --git a/entity/MesInvItemArn.cs b/entity/MesInvItemArn.cs
index 53c077d..fca1937 100644
--- a/entity/MesInvItemArn.cs
+++ b/entity/MesInvItemArn.cs
@@ -1,209 +1,258 @@
锘縰sing SqlSugar;
-namespace NewPdaSqlServer.entity
+namespace NewPdaSqlServer.entity;
+
+/// <summary>
+/// </summary>
+[SugarTable("MES_INV_ITEM_ARN")]
+public class MesInvItemArn
{
/// <summary>
- ///
- ///</summary>
- [SugarTable("MES_INV_ITEM_ARN")]
- public class MesInvItemArn
- {
- /// <summary>
- /// 涓婚敭
- /// 榛樿鍊�: (newid())
- ///</summary>
- [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
- public Guid Guid { get; set; }
- /// <summary>
- /// 鍒拌揣鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName="bill_no" )]
- public string BillNo { get; set; }
- /// <summary>
- /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName="status" )]
- public int? Status { get; set; }
- /// <summary>
- /// 鍘熷洜
- ///</summary>
- [SugarColumn(ColumnName="reason" )]
- public string Reason { 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>
- /// 鍗曟嵁绫诲瀷ID
- ///</summary>
- [SugarColumn(ColumnName="bill_type_id" )]
- public int? BillTypeId { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷ID
- ///</summary>
- [SugarColumn(ColumnName="transaction_id" )]
- public int? TransactionId { get; set; }
- /// <summary>
- /// 澶囨敞
- ///</summary>
- [SugarColumn(ColumnName="remark" )]
- public string Remark { get; set; }
- /// <summary>
- /// 閫佽揣鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName="paper_bill_no" )]
- public string PaperBillNo { get; set; }
- /// <summary>
- /// 閫�鏂欎汉宸ュ彿
- ///</summary>
- [SugarColumn(ColumnName="user_no_back" )]
- public string UserNoBack { get; set; }
- /// <summary>
- /// 鎻愪氦浜�
- ///</summary>
- [SugarColumn(ColumnName="check_user" )]
- public string CheckUser { get; set; }
- /// <summary>
- /// 鎻愪氦鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName="check_date" )]
- public DateTime? CheckDate { get; set; }
- /// <summary>
- /// 鍏ュ簱鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName="ins_date" )]
- public DateTime? InsDate { get; set; }
- /// <summary>
- /// 妫�楠岀粨鏋�
- ///</summary>
- [SugarColumn(ColumnName="check_res" )]
- public string CheckRes { get; set; }
- /// <summary>
- /// 宸叉崱鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName="check_qty" )]
- public int? CheckQty { get; set; }
- /// <summary>
- /// 浠撳簱id
- ///</summary>
- [SugarColumn(ColumnName="depots_id" )]
- public string DepotsId { get; set; }
- /// <summary>
- /// 浜嬪姟绫诲瀷缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="transction_no" )]
- public string TransctionNo { get; set; }
- /// <summary>
- /// 渚涘簲鍟唅d
- ///</summary>
- [SugarColumn(ColumnName="supp_id" )]
- public string SuppId { get; set; }
- /// <summary>
- /// 鎻愪氦鐘舵��
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName="fstatus" )]
- public bool? Fstatus { get; set; }
- /// <summary>
- /// 宸ュ巶缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="factory" )]
- public string Factory { get; set; }
- /// <summary>
- /// 鏄惁宸插洖鍐橲AP
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName="sapstatus" )]
- public int? Sapstatus { get; set; }
- /// <summary>
- /// 鏄惁妫�楠�
- ///</summary>
- [SugarColumn(ColumnName="ischeck" )]
- public bool? Ischeck { get; set; }
- /// <summary>
- /// 瀹℃牳鍏ュ簱浜�
- ///</summary>
- [SugarColumn(ColumnName="insby" )]
- public string Insby { get; set; }
- /// <summary>
- /// 鍏徃浠ｇ爜
- ///</summary>
- [SugarColumn(ColumnName="company" )]
- public string Company { get; set; }
- /// <summary>
- /// 鎬ユ枡鏍囪瘑
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName="urgent_flag" )]
- public bool? UrgentFlag { get; set; }
- /// <summary>
- /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="mttransction_no" )]
- public int? MttransctionNo { get; set; }
- /// <summary>
- /// IQC妫�楠屽崟鍙�
- ///</summary>
- [SugarColumn(ColumnName="iqc_release_no" )]
- public string IqcReleaseNo { get; set; }
- /// <summary>
- /// 鏄惁鏄剧ず
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName="is_visual" )]
- public int? IsVisual { get; set; }
- /// <summary>
- /// 0=閲囪喘锛�1=濮斿
- /// 榛樿鍊�: ((1))
- ///</summary>
- [SugarColumn(ColumnName="f_type" )]
- public bool? FType { get; set; }
- /// <summary>
- /// ERP鍒拌揣鍗旾D
- ///</summary>
- [SugarColumn(ColumnName="ebeln_k3id" )]
- public string EbelnK3id { get; set; }
- /// <summary>
- /// 鏉＄爜鏉″嵃杩涘害
- ///</summary>
- [SugarColumn(ColumnName="barcode_ratio" )]
- public int? BarcodeRatio { get; set; }
- /// <summary>
- /// ERP鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName="erpno" )]
- public string Erpno { get; set; }
- /// <summary>
- /// 鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐�
- ///</summary>
- [SugarColumn(ColumnName="thstatus" )]
- public int? Thstatus { get; set; }
- /// <summary>
- /// ERP閫�璐у崟鍙�
- ///</summary>
- [SugarColumn(ColumnName="erpthno" )]
- public string Erpthno { get; set; }
- /// <summary>
- /// 缁勭粐缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="organize_code" )]
- public string OrganizeCode { get; set; }
- }
-}
+ /// 涓婚敭
+ /// 榛樿鍊�: (newid())
+ /// </summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
+
+ /// <summary>
+ /// 鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "bill_no")]
+ public string? BillNo { get; set; }
+
+ /// <summary>
+ /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "status")]
+ public int? Status { get; set; }
+
+ /// <summary>
+ /// 鍘熷洜
+ /// </summary>
+ [SugarColumn(ColumnName = "reason")]
+ public string? Reason { 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>
+ /// 鍗曟嵁绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "bill_type_id")]
+ public int? BillTypeId { get; set; }
+
+ /// <summary>
+ /// 浜嬪姟绫诲瀷ID
+ /// </summary>
+ [SugarColumn(ColumnName = "transaction_id")]
+ public int? TransactionId { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "remark")]
+ public string? Remark { get; set; }
+
+ /// <summary>
+ /// 閫佽揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "paper_bill_no")]
+ public string? PaperBillNo { get; set; }
+
+ /// <summary>
+ /// 閫�鏂欎汉宸ュ彿
+ /// </summary>
+ [SugarColumn(ColumnName = "user_no_back")]
+ public string? UserNoBack { get; set; }
+
+ /// <summary>
+ /// 鎻愪氦浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "check_user")]
+ public string? CheckUser { get; set; }
+
+ /// <summary>
+ /// 鎻愪氦鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "check_date")]
+ public DateTime? CheckDate { get; set; }
+
+ /// <summary>
+ /// 鍏ュ簱鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "ins_date")]
+ public DateTime? InsDate { get; set; }
+
+ /// <summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "check_res")]
+ public string? CheckRes { get; set; }
+
+ /// <summary>
+ /// 宸叉崱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "check_qty")]
+ public int? CheckQty { get; set; }
+
+ /// <summary>
+ /// 浠撳簱id
+ /// </summary>
+ [SugarColumn(ColumnName = "depots_id")]
+ public string? DepotsId { get; set; }
+
+ /// <summary>
+ /// 浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "transction_no")]
+ public string? TransctionNo { get; set; }
+
+ /// <summary>
+ /// 渚涘簲鍟唅d
+ /// </summary>
+ [SugarColumn(ColumnName = "supp_id")]
+ public string? SuppId { get; set; }
+
+ /// <summary>
+ /// 鎻愪氦鐘舵��
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "fstatus")]
+ public bool? Fstatus { get; set; }
+
+ /// <summary>
+ /// 宸ュ巶缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "factory")]
+ public string? Factory { get; set; }
+
+ /// <summary>
+ /// 鏄惁宸插洖鍐橲AP
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "sapstatus")]
+ public int? Sapstatus { get; set; }
+
+ /// <summary>
+ /// 鏄惁妫�楠�
+ /// </summary>
+ [SugarColumn(ColumnName = "ischeck")]
+ public bool? Ischeck { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鍏ュ簱浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "insby")]
+ public string? Insby { get; set; }
+
+ /// <summary>
+ /// 鍏徃浠ｇ爜
+ /// </summary>
+ [SugarColumn(ColumnName = "company")]
+ public string? Company { get; set; }
+
+ /// <summary>
+ /// 鎬ユ枡鏍囪瘑
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "urgent_flag")]
+ public bool? UrgentFlag { get; set; }
+
+ /// <summary>
+ /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "mttransction_no")]
+ public int? MttransctionNo { get; set; }
+
+ /// <summary>
+ /// IQC妫�楠屽崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "iqc_release_no")]
+ public string? IqcReleaseNo { get; set; }
+
+ /// <summary>
+ /// 鏄惁鏄剧ず
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "is_visual")]
+ public int? IsVisual { get; set; }
+
+ /// <summary>
+ /// 0=閲囪喘锛�1=濮斿
+ /// 榛樿鍊�: ((1))
+ /// </summary>
+ [SugarColumn(ColumnName = "f_type")]
+ public bool? FType { get; set; }
+
+ /// <summary>
+ /// ERP鍒拌揣鍗旾D
+ /// </summary>
+ [SugarColumn(ColumnName = "ebeln_k3id")]
+ public string? EbelnK3id { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜鏉″嵃杩涘害
+ /// </summary>
+ [SugarColumn(ColumnName = "barcode_ratio")]
+ public int? BarcodeRatio { get; set; }
+
+ /// <summary>
+ /// ERP鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "erpno")]
+ public string? Erpno { get; set; }
+
+ /// <summary>
+ /// 鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐�
+ /// </summary>
+ [SugarColumn(ColumnName = "thstatus")]
+ public int? Thstatus { get; set; }
+
+ /// <summary>
+ /// ERP閫�璐у崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "erpthno")]
+ public string? Erpthno { get; set; }
+
+ /// <summary>
+ /// 缁勭粐缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "organize_code")]
+ public string? OrganizeCode { get; set; }
+
+ /// <summary>
+ /// 鏀舵枡缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "ReceiveOrgId")]
+ public string? ReceiveOrgId { get; set; }
+
+ [SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
+
+ [SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
+
+ [SugarColumn(IsIgnore = true)] public string? SuppNo { get; set; }
+
+ [SugarColumn(IsIgnore = true)] public string? DepotsCode { get; set; }
+}
\ No newline at end of file
--
Gitblit v1.9.3