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/SalesOrderDetail.cs | 405 +++++++++++++++++++++++++++++----------------------------
1 files changed, 205 insertions(+), 200 deletions(-)
diff --git a/MES.Service/Modes/SalesOrderDetail.cs b/MES.Service/Modes/SalesOrderDetail.cs
index 0cce5a2..07c1416 100644
--- a/MES.Service/Modes/SalesOrderDetail.cs
+++ b/MES.Service/Modes/SalesOrderDetail.cs
@@ -9,243 +9,248 @@
public class SalesOrderDetail
{
/// <summary>
- /// SEQ_sales搴忓垪
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
public Guid Id { get; set; }
/// <summary>
- /// SEQ_sales搴忓垪
- /// </summary>
+ ///
+ ///</summary>
[SugarColumn(ColumnName = "pid")]
- public Guid? Pid { get; set; }
+ public Guid Pid { get; set; }
/// <summary>
- /// ERPID
- /// </summary>
- [SugarColumn(ColumnName = "ERP_ID")]
- public decimal? ErpID { get; set; }
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName = "erp_id")]
+ public int? ErpId { get; set; }
/// <summary>
- /// ERP澶碔D
- /// </summary>
- [SugarColumn(ColumnName = "E_HID")]
- public decimal? EHID { get; set; }
-
- /// <summary>
- /// 鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "MATERIAL_ID")]
+ /// 鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "material_id")]
public string? MaterialId { get; set; }
/// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜
- /// </summary>
+ /// 閿�鍞崟浣�
+ ///</summary>
+ [SugarColumn(ColumnName = "unit_id")]
+ public string? UnitId { get; set; }
+
+ /// <summary>
+ /// 閿�鍞暟閲�
+ ///</summary>
+ [SugarColumn(ColumnName = "qty")]
+ public decimal? Qty { get; set; }
+
+ /// <summary>
+ /// 璁′环鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName = "price_unit_id")]
+ public string? PriceUnitId { get; set; }
+
+ /// <summary>
+ /// 璁′环鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "price_unit_qty")]
+ public decimal? PriceUnitQty { get; set; }
+
+ /// <summary>
+ /// 瑕佽揣鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName = "delivery_date")]
+ public DateTime? DeliveryDate { get; set; }
+
+ /// <summary>
+ /// 鏄惁璧犲搧
+ ///</summary>
+ [SugarColumn(ColumnName = "is_free")]
+ public string? IsFree { get; set; }
+
+ /// <summary>
+ /// 璐т富绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "owner_type_id")]
+ public string? OwnerTypeId { get; set; }
+
+ /// <summary>
+ /// 璐т富
+ ///</summary>
+ [SugarColumn(ColumnName = "owner_id")]
+ public string? OwnerId { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName = "entry_note")]
+ public string? EntryNote { get; set; }
+
+ /// <summary>
+ /// 璁″垝璺熻釜鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "mto_no")]
+ public string? MtoNo { get; set; }
+
+ /// <summary>
+ /// 鎵瑰彿
+ ///</summary>
+ [SugarColumn(ColumnName = "lot")]
+ public string? Lot { get; set; }
+
+ /// <summary>
+ /// 鍙戣揣涓婇檺
+ ///</summary>
+ [SugarColumn(ColumnName = "delivery_max_qty")]
+ public decimal? DeliveryMaxQty { get; set; }
+
+ /// <summary>
+ /// 鍙戣揣涓嬮檺
+ ///</summary>
+ [SugarColumn(ColumnName = "delivery_min_qty")]
+ public decimal? DeliveryMinQty { get; set; }
+
+ /// <summary>
+ /// 瓒呭彂鎺у埗鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName = "out_lmt_unit_id")]
+ public string? OutLmtUnitId { get; set; }
+
+ /// <summary>
+ /// 涓氬姟鍏抽棴
+ ///</summary>
+ [SugarColumn(ColumnName = "mrp_close_status")]
+ public string? MrpCloseStatus { get; set; }
+
+ /// <summary>
+ /// 涓氬姟缁堟
+ ///</summary>
+ [SugarColumn(ColumnName = "mrp_terminate_status")]
+ public string? MrpTerminateStatus { get; set; }
+
+ /// <summary>
+ /// 缁堟鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName = "terminate_date")]
+ public DateTime? TerminateDate { get; set; }
+
+ /// <summary>
+ /// 缁堟浜�
+ ///</summary>
+ [SugarColumn(ColumnName = "terminater_id")]
+ public string? TerminaterId { get; set; }
+
+ /// <summary>
+ /// 婧愬崟绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "src_type")]
+ public string? SrcType { get; set; }
+
+ /// <summary>
+ /// 婧愬崟鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName = "src_bill_no")]
+ public string? SrcBillNo { get; set; }
+
+ /// <summary>
+ /// 绱鍙戣揣閫氱煡鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "deli_qty")]
+ public decimal? DeliQty { get; set; }
+
+ /// <summary>
+ /// 绱鍑哄簱鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "stock_out_qty")]
+ public decimal? StockOutQty { get; set; }
+
+ /// <summary>
+ /// 绱閫�璐ч�氱煡鏁伴噺锛堥攢鍞熀鏈級
+ ///</summary>
+ [SugarColumn(ColumnName = "base_ret_notice_qty")]
+ public decimal? BaseRetNoticeQty { get; set; }
+
+ /// <summary>
+ /// 绱閫�璐ф暟閲忥紙閿�鍞熀鏈級
+ ///</summary>
+ [SugarColumn(ColumnName = "base_return_qty")]
+ public decimal? BaseReturnQty { get; set; }
+
+ /// <summary>
+ /// 鍓╀綑鏈嚭鏁伴噺锛堥攢鍞熀鏈級
+ ///</summary>
+ [SugarColumn(ColumnName = "base_remain_out_qty")]
+ public decimal? BaseRemainOutQty { get; set; }
+
+ /// <summary>
+ /// 绱搴旀敹鏁伴噺锛堥攢鍞熀鏈級
+ ///</summary>
+ [SugarColumn(ColumnName = "basearqty")]
+ public decimal? Basearqty { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "cust_ino")]
+ public string? CustIno { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName = "cust_inm")]
+ public string? CustInm { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡瑙勬牸
+ ///</summary>
+ [SugarColumn(ColumnName = "cust_imd")]
+ public string? CustImd { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡缂栫爜
+ ///</summary>
[SugarColumn(ColumnName = "MAP_ID")]
public string? MapId { get; set; }
/// <summary>
- /// 瀹㈡埛鐗╂枡鍚嶇О
- /// </summary>
+ /// 瀹㈡埛鐗╂枡鍚嶇О
+ ///</summary>
[SugarColumn(ColumnName = "MAP_NAME")]
public string? MapName { get; set; }
/// <summary>
- /// 瀹㈡埛鐗╂枡瑙勬牸
- /// </summary>
+ /// 瀹㈡埛鐗╂枡瑙勬牸
+ ///</summary>
[SugarColumn(ColumnName = "MAP_SPEC")]
public string? MapSpec { get; set; }
/// <summary>
- /// 搴忓彿
- /// </summary>
+ /// 搴忓彿
+ ///</summary>
[SugarColumn(ColumnName = "Seq")]
public int? Seq { get; set; }
/// <summary>
- /// 閿�鍞崟浣�
- /// </summary>
- [SugarColumn(ColumnName = "UNIT_ID")]
- public string? UnitId { get; set; }
-
- /// <summary>
- /// 閿�鍞暟閲�
- /// </summary>
- [SugarColumn(ColumnName = "QTY")]
- public decimal? Qty { get; set; }
-
- /// <summary>
- /// 璁′环鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "PRICE_UNIT_ID")]
- public string? PriceUnitId { get; set; }
-
- /// <summary>
- /// 璁′环鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "PRICE_UNIT_QTY")]
- public decimal? PriceUnitQty { get; set; }
-
- /// <summary>
- /// 瑕佽揣鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "DELIVERY_DATE")]
- public DateTime? DeliveryDate { get; set; }
-
- /// <summary>
- /// 鏄惁璧犲搧
- /// </summary>
- [SugarColumn(ColumnName = "IS_FREE")]
- public string? IsFree { get; set; }
-
- ///// <summary>
- ///// 閿�鍞鍗曞彿
- ///// </summary>
- //[SugarColumn(ColumnName = "UNW_TEXT_XSDDH")]
- //public string? SalesOrderNo { get; set; }
-
- /// <summary>
- /// 渚涘簲缁勭粐
- /// </summary>
+ /// 渚涘簲缁勭粐
+ ///</summary>
[SugarColumn(ColumnName = "SUPPLY_ORG_ID")]
public string? SupplyOrgId { get; set; }
/// <summary>
- /// 搴撳瓨缁勭粐
- /// </summary>
+ /// 搴撳瓨缁勭粐
+ ///</summary>
[SugarColumn(ColumnName = "STOCK_ORG_ID")]
public string? StockOrgId { get; set; }
/// <summary>
- /// 缁撶畻缁勭粐
- /// </summary>
+ /// 缁撶畻缁勭粐
+ ///</summary>
[SugarColumn(ColumnName = "SETTLE_ORG_IDS")]
public string? SettleOrgIds { get; set; }
-
- ///// <summary>
- ///// 璺熷崟鍛�
- ///// </summary>
- //[SugarColumn(ColumnName = "UNW_BASE_GDY")]
- //public string? SalesFollowUp { get; set; }
-
/// <summary>
- /// 璐т富绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "OWNER_TYPE_ID")]
- public string? OwnerTypeId { get; set; }
-
- /// <summary>
- /// 璐т富
- /// </summary>
- [SugarColumn(ColumnName = "OWNER_ID")]
- public string? OwnerId { get; set; }
-
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "ENTRY_NOTE")]
- public string? EntryNote { get; set; }
-
- /// <summary>
- /// 璁″垝璺熻釜鍙�
- /// </summary>
- [SugarColumn(ColumnName = "MTO_NO")]
- public string? MtoNo { get; set; }
-
- /// <summary>
- /// 鎵瑰彿
- /// </summary>
- [SugarColumn(ColumnName = "LOT")]
- public string? Lot { get; set; }
-
- /// <summary>
- /// 鍙戣揣涓婇檺
- /// </summary>
- [SugarColumn(ColumnName = "DELIVERY_MAX_QTY")]
- public decimal? DeliveryMaxQty { get; set; }
-
- /// <summary>
- /// 鍙戣揣涓嬮檺
- /// </summary>
- [SugarColumn(ColumnName = "DELIVERY_MIN_QTY")]
- public decimal? DeliveryMinQty { get; set; }
-
- /// <summary>
- /// 瓒呭彂鎺у埗鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "OUT_LMT_UNIT_ID")]
- public string? OutLmtUnitId { get; set; }
-
- /// <summary>
- /// 涓氬姟鍏抽棴
- /// </summary>
- [SugarColumn(ColumnName = "MRP_CLOSE_STATUS")]
- public string? MrpCloseStatus { get; set; }
-
- /// <summary>
- /// 涓氬姟缁堟
- /// </summary>
- [SugarColumn(ColumnName = "MRP_TERMINATE_STATUS")]
- public string? MrpTerminateStatus { get; set; }
-
- /// <summary>
- /// 缁堟鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "TERMINATE_DATE")]
- public DateTime? TerminateDate { get; set; }
-
- /// <summary>
- /// 缁堟浜�
- /// </summary>
- [SugarColumn(ColumnName = "TERMINATER_ID")]
- public string? TerminaterId { get; set; }
-
- /// <summary>
- /// 婧愬崟绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "SRC_TYPE")]
- public string? SrcType { get; set; }
-
- /// <summary>
- /// 婧愬崟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "SRC_BILL_NO")]
- public string? SrcBillNo { get; set; }
-
- /// <summary>
- /// 绱鍙戣揣閫氱煡鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "DELI_QTY")]
- public decimal? DeliQty { get; set; }
-
- /// <summary>
- /// 绱鍑哄簱鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "STOCK_OUT_QTY")]
- public decimal? StockOutQty { get; set; }
-
- /// <summary>
- /// 绱閫�璐ч�氱煡鏁伴噺锛堥攢鍞熀鏈級
- [SugarColumn(ColumnName = "BASE_RET_NOTICE_QTY")]
- public decimal? BaseRetNoticeQty { get; set; } /// </summary>
-
- /// <summary>
- /// 绱閫�璐ф暟閲忥紙閿�鍞熀鏈級
- /// </summary>
- [SugarColumn(ColumnName = "BASE_RETURN_QTY")]
- public decimal? BaseReturnQty { get; set; }
-
- /// <summary>
- /// 鍓╀綑鏈嚭鏁伴噺锛堥攢鍞熀鏈級
- /// </summary>
- [SugarColumn(ColumnName = "BASE_REMAIN_OUT_QTY")]
- public decimal? BaseRemainOutQty { get; set; }
-
- /// <summary>
- /// 绱搴旀敹鏁伴噺锛堥攢鍞熀鏈級
- /// </summary>
- [SugarColumn(ColumnName = "BASEARQTY")]
- public decimal? BASEARQTY { get; set; }
-
+ /// ERP鍗曟嵁琛ㄥごid
+ ///</summary>
+ [SugarColumn(ColumnName = "e_hid")]
+ public int? EHid { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3