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/MesCustomer.cs | 341 ++++++++++++++++++++++++++++++-------------------------- 1 files changed, 183 insertions(+), 158 deletions(-) diff --git a/entity/MesCustomer.cs b/entity/MesCustomer.cs index feccfd6..94a9196 100644 --- a/entity/MesCustomer.cs +++ b/entity/MesCustomer.cs @@ -1,162 +1,187 @@ 锘縰sing SqlSugar; -namespace NewPdaSqlServer.entity +namespace NewPdaSqlServer.entity; + +/// <summary> +/// </summary> +[SugarTable("MES_CUSTOMER")] +public class MesCustomer { /// <summary> - /// - ///</summary> - [SugarTable("MES_CUSTOMER")] - public class MesCustomer - { - /// <summary> - /// - /// 榛樿鍊�: (newid()) - ///</summary> - [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )] - public Guid Guid { get; set; } - /// <summary> - /// ID - ///</summary> - [SugarColumn(ColumnName="id" )] - public int Id { get; set; } - /// <summary> - /// 瀹㈡埛缂栫爜 - ///</summary> - [SugarColumn(ColumnName="cust_no" )] - public string CustNo { get; set; } - /// <summary> - /// 鍦板尯 - ///</summary> - [SugarColumn(ColumnName="land" )] - public string Land { get; set; } - /// <summary> - /// 瀹㈡埛鍚嶇О - ///</summary> - [SugarColumn(ColumnName="cust_name" )] - public string CustName { get; set; } - /// <summary> - /// 瀹㈡埛绠�绉� - ///</summary> - [SugarColumn(ColumnName="cust_sname" )] - public string CustSname { get; set; } - /// <summary> - /// 鍦板潃 - ///</summary> - [SugarColumn(ColumnName="stras" )] - public string Stras { get; set; } - /// <summary> - /// 鐢佃瘽 - ///</summary> - [SugarColumn(ColumnName="telf1" )] - public string Telf1 { get; set; } - /// <summary> - /// 浼犵湡 - ///</summary> - [SugarColumn(ColumnName="telfx" )] - public string Telfx { get; set; } - /// <summary> - /// 鑱旂郴浜� - ///</summary> - [SugarColumn(ColumnName="anred" )] - public string Anred { get; set; } - /// <summary> - /// 鍒涘缓鏃堕棿 - ///</summary> - [SugarColumn(ColumnName="create_date" )] - public DateTime? CreateDate { get; set; } - /// <summary> - /// 鍒涘缓浜� - ///</summary> - [SugarColumn(ColumnName="create_by" )] - public string CreateBy { get; set; } - /// <summary> - /// 鏈�鍚庝慨鏀规椂闂� - ///</summary> - [SugarColumn(ColumnName="lastupdate_date" )] - public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 鏈�鍚庝慨鏀逛汉 - ///</summary> - [SugarColumn(ColumnName="lastupdate_by" )] - public string LastupdateBy { get; set; } - /// <summary> - /// 澶囨敞 - ///</summary> - [SugarColumn(ColumnName="remark" )] - public string Remark { get; set; } - /// <summary> - /// 鍏徃 - ///</summary> - [SugarColumn(ColumnName="company" )] - public string Company { get; set; } - /// <summary> - /// 鍒嗗巶缂栫爜 - ///</summary> - [SugarColumn(ColumnName="factory" )] - public string Factory { get; set; } - /// <summary> - /// 鐗╂枡鏄惁鍏辩(鏄紝鍚�) - /// 榛樿鍊�: ((0)) - ///</summary> - [SugarColumn(ColumnName="item_c" )] - public int? ItemC { get; set; } - /// <summary> - /// 鐗╂枡鏄惁鍥炲啓SAP鎺ュ彛(鏄紝鍚�) - /// 榛樿鍊�: ((0)) - ///</summary> - [SugarColumn(ColumnName="item_sap" )] - public int? ItemSap { get; set; } - /// <summary> - /// 鏄惁鎵规绠$悊(鏄紝鍚�) - /// 榛樿鍊�: ((0)) - ///</summary> - [SugarColumn(ColumnName="lot_flag" )] - public int? LotFlag { get; set; } - /// <summary> - /// WMS鏄惁鍙戦�佹暟鎹細1宸插彂閫侊紝鍏朵粬鍧囨湭鍙戦�� - /// 榛樿鍊�: ((0)) - ///</summary> - [SugarColumn(ColumnName="iscommit" )] - public int? Iscommit { get; set; } - /// <summary> - /// 绂佺敤鐘舵�� - ///</summary> - [SugarColumn(ColumnName="fforbidstatus" )] - public string Fforbidstatus { get; set; } - /// <summary> - /// 閿�鍞憳 - ///</summary> - [SugarColumn(ColumnName="fseller" )] - public string Fseller { get; set; } - /// <summary> - /// 鑷畾涔夊瓧娈�3 - ///</summary> - [SugarColumn(ColumnName="remark3" )] - public string Remark3 { get; set; } - /// <summary> - /// 鑷畾涔夊瓧娈�4 - ///</summary> - [SugarColumn(ColumnName="remark4" )] - public string Remark4 { get; set; } - /// <summary> - /// 鑷畾涔夊瓧娈�5 - ///</summary> - [SugarColumn(ColumnName="remark5" )] - public string Remark5 { get; set; } - /// <summary> - /// 鍒涘缓缁勭粐 - ///</summary> - [SugarColumn(ColumnName="Fumbrella" )] - public string Fumbrella { get; set; } - /// <summary> - /// 浣跨敤缁勭粐 - ///</summary> - [SugarColumn(ColumnName="FSubsidiary" )] - public string FSubsidiary { get; set; } - /// <summary> - /// 鍗曟嵁鐘舵�� - ///</summary> - [SugarColumn(ColumnName="DATA_TYPE" )] - public string DataType { get; set; } - } -} + /// 榛樿鍊�: (newid()) + /// </summary> + [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)] + public Guid Guid { get; set; } + + /// <summary> + /// ID + /// </summary> + [SugarColumn(ColumnName = "id")] + public int Id { get; set; } + + /// <summary> + /// 瀹㈡埛缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "cust_no")] + public string CustNo { get; set; } + + /// <summary> + /// 鍦板尯 + /// </summary> + [SugarColumn(ColumnName = "land")] + public string Land { get; set; } + + /// <summary> + /// 瀹㈡埛鍚嶇О + /// </summary> + [SugarColumn(ColumnName = "cust_name")] + public string CustName { get; set; } + + /// <summary> + /// 瀹㈡埛绠�绉� + /// </summary> + [SugarColumn(ColumnName = "cust_sname")] + public string CustSname { get; set; } + + /// <summary> + /// 鍦板潃 + /// </summary> + [SugarColumn(ColumnName = "stras")] + public string Stras { get; set; } + + /// <summary> + /// 鐢佃瘽 + /// </summary> + [SugarColumn(ColumnName = "telf1")] + public string Telf1 { get; set; } + + /// <summary> + /// 浼犵湡 + /// </summary> + [SugarColumn(ColumnName = "telfx")] + public string Telfx { get; set; } + + /// <summary> + /// 鑱旂郴浜� + /// </summary> + [SugarColumn(ColumnName = "anred")] + public string Anred { get; set; } + + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "create_date")] + public DateTime? CreateDate { get; set; } + + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "create_by")] + public string CreateBy { get; set; } + + /// <summary> + /// 鏈�鍚庝慨鏀规椂闂� + /// </summary> + [SugarColumn(ColumnName = "lastupdate_date")] + public DateTime? LastupdateDate { get; set; } + + /// <summary> + /// 鏈�鍚庝慨鏀逛汉 + /// </summary> + [SugarColumn(ColumnName = "lastupdate_by")] + public string LastupdateBy { get; set; } + + /// <summary> + /// 澶囨敞 + /// </summary> + [SugarColumn(ColumnName = "remark")] + public string Remark { get; set; } + + /// <summary> + /// 鍏徃 + /// </summary> + [SugarColumn(ColumnName = "company")] + public string Company { get; set; } + + /// <summary> + /// 鍒嗗巶缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "factory")] + public string Factory { get; set; } + + /// <summary> + /// 鐗╂枡鏄惁鍏辩(鏄紝鍚�) + /// 榛樿鍊�: ((0)) + /// </summary> + [SugarColumn(ColumnName = "item_c")] + public int? ItemC { get; set; } + + /// <summary> + /// 鐗╂枡鏄惁鍥炲啓SAP鎺ュ彛(鏄紝鍚�) + /// 榛樿鍊�: ((0)) + /// </summary> + [SugarColumn(ColumnName = "item_sap")] + public int? ItemSap { get; set; } + + /// <summary> + /// 鏄惁鎵规绠$悊(鏄紝鍚�) + /// 榛樿鍊�: ((0)) + /// </summary> + [SugarColumn(ColumnName = "lot_flag")] + public int? LotFlag { get; set; } + + /// <summary> + /// WMS鏄惁鍙戦�佹暟鎹細1宸插彂閫侊紝鍏朵粬鍧囨湭鍙戦�� + /// 榛樿鍊�: ((0)) + /// </summary> + [SugarColumn(ColumnName = "iscommit")] + public int? Iscommit { get; set; } + + /// <summary> + /// 绂佺敤鐘舵�� + /// </summary> + [SugarColumn(ColumnName = "fforbidstatus")] + public string Fforbidstatus { get; set; } + + /// <summary> + /// 閿�鍞憳 + /// </summary> + [SugarColumn(ColumnName = "fseller")] + public string Fseller { get; set; } + + /// <summary> + /// 鑷畾涔夊瓧娈�3 + /// </summary> + [SugarColumn(ColumnName = "remark3")] + public string Remark3 { get; set; } + + /// <summary> + /// 鑷畾涔夊瓧娈�4 + /// </summary> + [SugarColumn(ColumnName = "remark4")] + public string Remark4 { get; set; } + + /// <summary> + /// 鑷畾涔夊瓧娈�5 + /// </summary> + [SugarColumn(ColumnName = "remark5")] + public string Remark5 { get; set; } + + /// <summary> + /// 鍒涘缓缁勭粐 + /// </summary> + [SugarColumn(ColumnName = "Fumbrella")] + public string Fumbrella { get; set; } + + /// <summary> + /// 浣跨敤缁勭粐 + /// </summary> + [SugarColumn(ColumnName = "FSubsidiary")] + public string FSubsidiary { get; set; } + + /// <summary> + /// 鍗曟嵁鐘舵�� + /// </summary> + [SugarColumn(ColumnName = "DATA_TYPE")] + public string DataType { get; set; } +} \ No newline at end of file -- Gitblit v1.9.3