From ebb97e3faed4420ee4ef175d9b6da8de24a25741 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期二, 25 二月 2025 08:59:47 +0800
Subject: [PATCH] 1.委外退料优化 2.委外补料、超领优化
---
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