From 96ee6437185cc02f17a8286967fd0f0eb88d9328 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期一, 15 九月 2025 19:23:46 +0800 Subject: [PATCH] 111 --- MES.Service/Modes/SalesOrder.cs | 348 +++++++++++++++++++++++++++++++++++++--------------------- 1 files changed, 222 insertions(+), 126 deletions(-) diff --git a/MES.Service/Modes/SalesOrder.cs b/MES.Service/Modes/SalesOrder.cs index d6c2e24..29ddedc 100644 --- a/MES.Service/Modes/SalesOrder.cs +++ b/MES.Service/Modes/SalesOrder.cs @@ -9,134 +9,230 @@ public class SalesOrder { /// <summary> - /// SEQ_sales搴忓垪 - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] - public Guid? Id { get; set; } - - [SugarColumn(ColumnName = "ERP_ID")] - public decimal? ErpID { get; set; } // ERPID - - [SugarColumn(ColumnName = "BILL_NO")] - public string? BillNo { get; set; } // 鍗曟嵁缂栧彿 - - [SugarColumn(ColumnName = "BILL_TYPE_ID")] - public string? BillTypeId { get; set; } // 鍗曟嵁绫诲瀷 - - [SugarColumn(ColumnName = "DOCUMENT_STATUS")] - public string? DocumentStatus { get; set; } // 鍗曟嵁鐘舵�� - - [SugarColumn(ColumnName = "F_DATE")] - public DateTime? FDate { get; set; } // 鏃ユ湡 - - [SugarColumn(ColumnName = "BUSINESS_TYPE")] - public string? BusinessType { get; set; } // 涓氬姟绫诲瀷 - - [SugarColumn(ColumnName = "HEAD_DELIVERY_WAY")] - public string? HeadDeliveryWay { get; set; } // 浜よ揣鏂瑰紡 - - [SugarColumn(ColumnName = "HEAD_LOC_ID")] - public string? HeadLocId { get; set; } // 浜よ揣鍦扮偣 - - [SugarColumn(ColumnName = "SALE_ORG_ID")] - public string? SaleOrgId { get; set; } // 閿�鍞粍缁� - - //[SugarColumn(ColumnName = "UNW_TEXT_KHDD")] - //public string? UnWTextKhdd { get; set; } // 瀹㈡埛璁㈠崟 - - //[SugarColumn(ColumnName = "UNW_DATE_KHXQ")] - //public DateTime? UnWDateKhxq { get; set; } // 瀹㈡埛闇�姹備氦鏈� - - //[SugarColumn(ColumnName = "UNW_BASE_PROPERTY_KHDJ")] - //public string? UnWBasePropertyKhdj { get; set; } // 瀹㈡埛绛夌骇 - - [SugarColumn(ColumnName = "CUST_ID")] - public string? CustId { get; set; } // 瀹㈡埛 - - //[SugarColumn(ColumnName = "UNW_LARGE_TEXT_TBKHBZ")] - //public string? UnWLargetextTbkhbz { get; set; } // 娣樺疂瀹㈡埛澶囨敞 - - [SugarColumn(ColumnName = "CLOSE_STATUS")] - public string? CloseStatus { get; set; } // 鍏抽棴鐘舵�� - - [SugarColumn(ColumnName = "SALE_DEPT_ID")] - public string? SaleDeptId { get; set; } // 閿�鍞儴闂� - - [SugarColumn(ColumnName = "SALER_ID")] - public string? SalerId { get; set; } // 閿�鍞憳 - - [SugarColumn(ColumnName = "NOTE")] - public string? Note { get; set; } // 澶囨敞 - - //[SugarColumn(ColumnName = "UNW_REMARKS_KHJHDD")] - //public string? UnWRemarksKhjHdd { get; set; } // 瀹㈡埛浜よ揣鍦扮偣 - [SugarColumn(ColumnName = "RECEIVE_ID")] - public string? ReceiveId { get; set; } // 鏀惰揣鏂� - - [SugarColumn(ColumnName = "RECEIVE_CONTACT")] - public string? ReceiveContact { get; set; } // 鏀惰揣鏂硅仈绯讳汉 - - [SugarColumn(ColumnName = "SETTLE_ID")] - public string? SettleId { get; set; } // 缁撶畻鏂� - - [SugarColumn(ColumnName = "APPROVER_ID")] - public string? ApproverId { get; set; } // 瀹℃牳浜� - - [SugarColumn(ColumnName = "LINK_MAN")] - public string? LinkMan { get; set; } // 鏀惰揣浜哄鍚� - - [SugarColumn(ColumnName = "CHARGE_ID")] - public string? ChargeId { get; set; } // 浠樻鏂� - - [SugarColumn(ColumnName = "LINK_PHONE")] - public string? LinkPhone { get; set; } // 鑱旂郴鐢佃瘽 - - [SugarColumn(ColumnName = "CREATOR_ID")] - public string? CreatorId { get; set; } // 鍒涘缓浜� - - [SugarColumn(ColumnName = "CREATE_DATE")] - public DateTime? CreateDate { get; set; } // 鍒涘缓鏃ユ湡 - - [SugarColumn(ColumnName = "MODIFIER_ID")] - public string? ModifierId { get; set; } // 鏈�鍚庝慨鏀逛汉 - - [SugarColumn(ColumnName = "MODIFY_DATE")] - public DateTime? ModifyDate { get; set; } // 鏈�鍚庝慨鏀规棩鏈� - - [SugarColumn(ColumnName = "APPROVE_DATE")] - public DateTime? ApproveDate { get; set; } // 瀹℃牳鏃ユ湡 - - [SugarColumn(ColumnName = "CLOSER_ID")] - public string? CloserId { get; set; } // 鍏抽棴浜� - - [SugarColumn(ColumnName = "CLOSE_DATE")] - public DateTime? CloseDate { get; set; } // 鍏抽棴鏃ユ湡 - - [SugarColumn(ColumnName = "CHANGE_DATE")] - public DateTime? ChangeDate { get; set; } // 鍙樻洿鏃ユ湡 - - [SugarColumn(ColumnName = "CANCEL_STATUS")] - public string? CancelStatus { get; set; } // 浣滃簾鐘舵�� - - [SugarColumn(ColumnName = "CANCELLER_ID")] - public string? CancellerId { get; set; } // 浣滃簾浜� - - [SugarColumn(ColumnName = "VERSION_NO")] - public double? VersionNo { get; set; } // 鐗堟湰鍙� - - [SugarColumn(ColumnName = "CHANGE_REASON")] - public string? ChangeReason { get; set; } // 鍙樻洿鍘熷洜 - - [SugarColumn(ColumnName = "CHANGER_ID")] - public string? ChangerId { get; set; } // 鍙樻洿浜� - - [SugarColumn(ColumnName = "ENTRY_NOTE")] - public string? EntryNote { get; set; } // 澶囨敞 + /// + ///</summary> + [SugarColumn(ColumnName = "id", IsPrimaryKey = true)] + public Guid Id { get; set; } /// <summary> - /// 鍚屾鏃堕棿 - /// </summary> + /// + ///</summary> + [SugarColumn(ColumnName = "erp_id")] + public decimal? ErpId { get; set; } + + /// <summary> + /// 鍗曟嵁缂栧彿 + ///</summary> + [SugarColumn(ColumnName = "bill_no")] + public string? BillNo { get; set; } + + /// <summary> + /// 鍗曟嵁绫诲瀷 + ///</summary> + [SugarColumn(ColumnName = "bill_type_id")] + public string? BillTypeId { get; set; } + + /// <summary> + /// 鍗曟嵁鐘舵�� + ///</summary> + [SugarColumn(ColumnName = "document_status")] + public string? DocumentStatus { get; set; } + + /// <summary> + /// 鏃ユ湡 + ///</summary> + [SugarColumn(ColumnName = "f_date")] + public DateTime? FDate { get; set; } + + /// <summary> + /// 涓氬姟绫诲瀷 + ///</summary> + [SugarColumn(ColumnName = "business_type")] + public string? BusinessType { get; set; } + + /// <summary> + /// 浜よ揣鏂瑰紡 + ///</summary> + [SugarColumn(ColumnName = "head_delivery_way")] + public string? HeadDeliveryWay { get; set; } + + /// <summary> + /// 浜よ揣鍦扮偣 + ///</summary> + [SugarColumn(ColumnName = "head_loc_id")] + public string? HeadLocId { get; set; } + + /// <summary> + /// 瀹㈡埛 + ///</summary> + [SugarColumn(ColumnName = "cust_id")] + public string? CustId { get; set; } + + /// <summary> + /// 鍏抽棴鐘舵�� + ///</summary> + [SugarColumn(ColumnName = "close_status")] + public string? CloseStatus { get; set; } + + /// <summary> + /// 閿�鍞儴闂� + ///</summary> + [SugarColumn(ColumnName = "sale_dept_id")] + public string? SaleDeptId { get; set; } + + /// <summary> + /// 閿�鍞憳 + ///</summary> + [SugarColumn(ColumnName = "saler_id")] + public string? SalerId { get; set; } + + /// <summary> + /// 鍙樻洿鍘熷洜 + ///</summary> + [SugarColumn(ColumnName = "change_reason")] + public string? ChangeReason { get; set; } + + /// <summary> + /// 澶囨敞 + ///</summary> + [SugarColumn(ColumnName = "note")] + public string? Note { get; set; } + + /// <summary> + /// 缁撶畻鏂� + ///</summary> + [SugarColumn(ColumnName = "settle_id")] + public string? SettleId { get; set; } + + /// <summary> + /// 瀹℃牳浜� + ///</summary> + [SugarColumn(ColumnName = "approver_id")] + public string? ApproverId { get; set; } + + /// <summary> + /// 鏀惰揣浜哄鍚� + ///</summary> + [SugarColumn(ColumnName = "link_man")] + public string? LinkMan { get; set; } + + /// <summary> + /// 浠樻鏂� + ///</summary> + [SugarColumn(ColumnName = "charge_id")] + public string? ChargeId { get; set; } + + /// <summary> + /// 鑱旂郴鐢佃瘽 + ///</summary> + [SugarColumn(ColumnName = "link_phone")] + public string? LinkPhone { get; set; } + + /// <summary> + /// 鍒涘缓浜� + ///</summary> + [SugarColumn(ColumnName = "creator_id")] + public string? CreatorId { get; set; } + + /// <summary> + /// 鍒涘缓鏃ユ湡 + ///</summary> + [SugarColumn(ColumnName = "create_date")] + public DateTime? CreateDate { get; set; } + + /// <summary> + /// 鏈�鍚庝慨鏀逛汉 + ///</summary> + [SugarColumn(ColumnName = "modifier_id")] + public string? ModifierId { get; set; } + + /// <summary> + /// 鏈�鍚庝慨鏀规棩鏈� + ///</summary> + [SugarColumn(ColumnName = "modify_date")] + public DateTime? ModifyDate { get; set; } + + /// <summary> + /// 瀹℃牳鏃ユ湡 + ///</summary> + [SugarColumn(ColumnName = "approve_date")] + public DateTime? ApproveDate { get; set; } + + /// <summary> + /// 鍏抽棴浜� + ///</summary> + [SugarColumn(ColumnName = "closer_id")] + public string? CloserId { get; set; } + + /// <summary> + /// 鍏抽棴鏃ユ湡 + ///</summary> + [SugarColumn(ColumnName = "close_date")] + public DateTime? CloseDate { get; set; } + + /// <summary> + /// 鍙樻洿鏃ユ湡 + ///</summary> + [SugarColumn(ColumnName = "change_date")] + public DateTime? ChangeDate { get; set; } + + /// <summary> + /// 浣滃簾鐘舵�� + ///</summary> + [SugarColumn(ColumnName = "cancel_status")] + public string? CancelStatus { get; set; } + + /// <summary> + /// 浣滃簾浜� + ///</summary> + [SugarColumn(ColumnName = "canceller_id")] + public string? CancellerId { get; set; } + + /// <summary> + /// 鐗堟湰鍙� + ///</summary> + [SugarColumn(ColumnName = "version_no")] + public int? VersionNo { get; set; } + + /// <summary> + /// 鍙樻洿浜� + ///</summary> + [SugarColumn(ColumnName = "changer_id")] + public string? ChangerId { get; set; } + + /// <summary> + /// 澶囨敞 + ///</summary> + [SugarColumn(ColumnName = "entry_note")] + public string? EntryNote { get; set; } + + /// <summary> + /// + ///</summary> + [SugarColumn(ColumnName = "fbilltype")] + public string? Fbilltype { get; set; } + + /// <summary> + /// 閿�鍞粍缁嘔D + ///</summary> + [SugarColumn(ColumnName = "SALE_ORG_ID")] + public string? SaleOrgId { get; set; } + + /// <summary> + /// 鏀惰揣鏂� + ///</summary> + [SugarColumn(ColumnName = "RECEIVE_ID")] + public string? ReceiveId { get; set; } + + /// <summary> + /// 鏀惰揣鏂硅仈绯讳汉 + ///</summary> + [SugarColumn(ColumnName = "RECEIVE_CONTACT")] + public string? ReceiveContact { get; set; } + + /// <summary> + /// 鍚屾鏃堕棿 + ///</summary> [SugarColumn(ColumnName = "SYNCHRONOUS_DATE")] public DateTime? SynchronousDate { get; set; } - } \ No newline at end of file -- Gitblit v1.9.3