From 74ab9465837f8a6f9eae854059e9783eff24e173 Mon Sep 17 00:00:00 2001
From: sjz <1240968267@qq.com>
Date: 星期一, 14 七月 2025 18:06:24 +0800
Subject: [PATCH] 多组织修改
---
MES.Service/Modes/SalesDeliveryNoticeDetail.cs | 430 +++++++++++++++++++++++++++++------------------------
1 files changed, 232 insertions(+), 198 deletions(-)
diff --git a/MES.Service/Modes/SalesDeliveryNoticeDetail.cs b/MES.Service/Modes/SalesDeliveryNoticeDetail.cs
index fb36222..8856ea6 100644
--- a/MES.Service/Modes/SalesDeliveryNoticeDetail.cs
+++ b/MES.Service/Modes/SalesDeliveryNoticeDetail.cs
@@ -1,204 +1,238 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.Linq;
-using SqlSugar;
-namespace MES.Service.Modes
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 閿�鍞彂璐ч�氱煡鍗曟槑缁嗚〃
+/// </summary>
+[SugarTable("SALES_DELIVERY_NOTICE_DETAIL")]
+public class SalesDeliveryNoticeDetail
{
- /// <summary>
- /// 閿�鍞彂璐ч�氱煡鍗曟槑缁嗚〃
- ///</summary>
- [SugarTable("SALES_DELIVERY_NOTICE_DETAIL")]
- public class SalesDeliveryNoticeDetail
- {
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName="ID", OracleSequenceName = "SEQ_SALES", IsPrimaryKey = true)]
- public decimal? Id { get; set; }
- /// <summary>
- /// 閿�鍞鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName="SALES_ORDER_ID")]
- public string? SalesOrderId { get; set; }
- /// <summary>
- /// 鐗╂枡缂栫爜
- ///</summary>
- [SugarColumn(ColumnName="MATERIAL_ID")]
- public string? MaterialId { get; set; }
- /// <summary>
- /// 鐗╂枡鍚嶇О
- ///</summary>
- [SugarColumn(ColumnName="MATERIAL_NAME")]
- public string? MaterialName { get; set; }
- /// <summary>
- /// 鐗╂枡瑙勬牸
- ///</summary>
- [SugarColumn(ColumnName="MATERIAL_SPECIFICATION")]
- public string? MaterialSpecification { get; set; }
- /// <summary>
- /// 閿�鍞崟浣�
- ///</summary>
- [SugarColumn(ColumnName="SALES_UNIT_ID")]
- public string? SalesUnitId { get; set; }
- /// <summary>
- /// 閿�鍞暟閲�
- ///</summary>
- [SugarColumn(ColumnName="SALES_QUANTITY")]
- public decimal? SalesQuantity { get; set; }
- /// <summary>
- /// 鏄惁璧犲搧
- ///</summary>
- [SugarColumn(ColumnName="IS_FREE")]
- public decimal IsFree { get; set; }
- /// <summary>
- /// 瑕佽揣鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName="DELIVERY_DATE")]
- public DateTime? DeliveryDate { get; set; }
- /// <summary>
- /// 鍑鸿揣浠撳簱
- ///</summary>
- [SugarColumn(ColumnName="WAREHOUSE")]
- public string? Warehouse { get; set; }
- /// <summary>
- /// 璁″垝璺熻釜鍙�
- ///</summary>
- [SugarColumn(ColumnName="PLAN_TRACKING_NUMBER")]
- public string? PlanTrackingNumber { get; set; }
- /// <summary>
- /// 鎵瑰彿
- ///</summary>
- [SugarColumn(ColumnName="LOT_NUMBER")]
- public string? LotNumber { get; set; }
- /// <summary>
- /// 婧愬崟缂栧彿
- ///</summary>
- [SugarColumn(ColumnName="SRC_BILL_NO")]
- public string? SrcBillNo { get; set; }
- /// <summary>
- /// 璁′环鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName="PRICE_QTY")]
- public decimal? PriceQty { get; set; }
- /// <summary>
- /// 璐т富
- ///</summary>
- [SugarColumn(ColumnName="OWNER_ID")]
- public string? OwnerId { get; set; }
- /// <summary>
- /// 搴撳瓨鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName="INVENTORY_UNIT")]
- public string? InventoryUnit { get; set; }
- /// <summary>
- /// 搴撳瓨鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName="INVENTORY_QUANTITY")]
- public decimal? InventoryQuantity { get; set; }
- /// <summary>
- /// 鐗╂枡绫诲埆
- ///</summary>
- [SugarColumn(ColumnName="MATERIAL_CATEGORY")]
- public string? MaterialCategory { get; set; }
- /// <summary>
- /// 璁″垝鍙戣揣鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName="PLAN_DELIVERY_DATE")]
- public DateTime? PlanDeliveryDate { get; set; }
- /// <summary>
- /// 瓒呭彂鎺у埗鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName="OUT_LMT_UNIT")]
- public string? OutLmtUnit { get; set; }
- /// <summary>
- /// 鍑哄簱涓婇檺
- ///</summary>
- [SugarColumn(ColumnName="OUT_MAX_QTY")]
- public decimal? OutMaxQty { get; set; }
- /// <summary>
- /// 鍑哄簱涓嬮檺
- ///</summary>
- [SugarColumn(ColumnName="OUT_MIN_QTY")]
- public decimal? OutMinQty { get; set; }
- /// <summary>
- /// 浜よ揣鍦扮偣
- ///</summary>
- [SugarColumn(ColumnName="DELIVERY_LOC")]
- public string? DeliveryLoc { get; set; }
- /// <summary>
- /// 浜よ揣鍦板潃
- ///</summary>
- [SugarColumn(ColumnName="DELIVERYL_ADDRESS")]
- public string? DeliverylAddress { get; set; }
- /// <summary>
- /// 婧愬崟鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName="SOURCE_BILL_NO")]
- public string? SourceBillNo { get; set; }
- /// <summary>
- /// 璁㈠崟鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName="ORDER_BILL_NO")]
- public string? OrderBillNo { get; set; }
- /// <summary>
- /// 缁堟鐘舵��
- ///</summary>
- [SugarColumn(ColumnName="TERMINATION_STATUS")]
- public string? TerminationStatus { get; set; }
- /// <summary>
- /// 缁堟鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName="TERMINATION_DATE")]
- public DateTime? TerminationDate { get; set; }
- /// <summary>
- /// 绱鍑哄簱鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName="SUM_OUT_QTY")]
- public decimal? SumOutQty { get; set; }
- /// <summary>
- /// 鏈嚭搴撴暟閲�
- ///</summary>
- [SugarColumn(ColumnName="REMAIN_OUT_QTY")]
- public decimal? RemainOutQty { get; set; }
- /// <summary>
- /// ERP琛孖D
- ///</summary>
- [SugarColumn(ColumnName="ERP_LINE_ID")]
- public string? ErpLineId { get; set; }
- /// <summary>
- /// ERP澶碔D
- ///</summary>
- [SugarColumn(ColumnName="ERP_HEAD_ID")]
- public string? ErpHeadId { get; set; }
- /// <summary>
- /// 閿�鍞鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "SALES_ORDER")]
- public string? SalesOrder { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_SALES",
+ IsPrimaryKey = true)]
+ public decimal? Id { get; set; }
- /// <summary>
- /// 瀹㈡埛璁㈠崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "CUST_ORDER")]
- public string? CustOrder { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "SALES_ORDER_ID")]
+ public string? SalesOrderId { get; set; }
- /// <summary>
- /// 閿�鍞悎鍚岀紪鍙�
- /// </summary>
- [SugarColumn(ColumnName = "SALES_CONTRACT_NO")]
- public string? SalesContractNo { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "MATERIAL_ID")]
+ public string? MaterialId { get; set; }
- /// <summary>
- /// 瀹㈡埛鐗╂枡鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "F_KHWLMC")]
- public string? F_KHWLMC { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "MATERIAL_NAME")]
+ public string? MaterialName { get; set; }
- /// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "F_KHWLBM")]
- public string? F_KHWLBM { get; set; }
- }
+ /// <summary>
+ /// 鐗╂枡瑙勬牸
+ /// </summary>
+ [SugarColumn(ColumnName = "MATERIAL_SPECIFICATION")]
+ public string? MaterialSpecification { get; set; }
-}
+ /// <summary>
+ /// 閿�鍞崟浣�
+ /// </summary>
+ [SugarColumn(ColumnName = "SALES_UNIT_ID")]
+ public string? SalesUnitId { get; set; }
+
+ /// <summary>
+ /// 閿�鍞暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "SALES_QUANTITY")]
+ public decimal? SalesQuantity { get; set; }
+
+ /// <summary>
+ /// 鏄惁璧犲搧
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_FREE")]
+ public decimal IsFree { get; set; }
+
+ /// <summary>
+ /// 瑕佽揣鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "DELIVERY_DATE")]
+ public DateTime? DeliveryDate { get; set; }
+
+ /// <summary>
+ /// 鍑鸿揣浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "WAREHOUSE")]
+ public string? Warehouse { get; set; }
+
+ /// <summary>
+ /// 璁″垝璺熻釜鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "PLAN_TRACKING_NUMBER")]
+ public string? PlanTrackingNumber { get; set; }
+
+ /// <summary>
+ /// 鎵瑰彿
+ /// </summary>
+ [SugarColumn(ColumnName = "LOT_NUMBER")]
+ public string? LotNumber { get; set; }
+
+ /// <summary>
+ /// 婧愬崟缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "SRC_BILL_NO")]
+ public string? SrcBillNo { get; set; }
+
+ /// <summary>
+ /// 璁′环鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "PRICE_QTY")]
+ public decimal? PriceQty { get; set; }
+
+ /// <summary>
+ /// 璐т富
+ /// </summary>
+ [SugarColumn(ColumnName = "OWNER_ID")]
+ public string? OwnerId { get; set; }
+
+ /// <summary>
+ /// 搴撳瓨鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "INVENTORY_UNIT")]
+ public string? InventoryUnit { get; set; }
+
+ /// <summary>
+ /// 搴撳瓨鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "INVENTORY_QUANTITY")]
+ public decimal? InventoryQuantity { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡绫诲埆
+ /// </summary>
+ [SugarColumn(ColumnName = "MATERIAL_CATEGORY")]
+ public string? MaterialCategory { get; set; }
+
+ /// <summary>
+ /// 璁″垝鍙戣揣鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "PLAN_DELIVERY_DATE")]
+ public DateTime? PlanDeliveryDate { get; set; }
+
+ /// <summary>
+ /// 瓒呭彂鎺у埗鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "OUT_LMT_UNIT")]
+ public string? OutLmtUnit { get; set; }
+
+ /// <summary>
+ /// 鍑哄簱涓婇檺
+ /// </summary>
+ [SugarColumn(ColumnName = "OUT_MAX_QTY")]
+ public decimal? OutMaxQty { get; set; }
+
+ /// <summary>
+ /// 鍑哄簱涓嬮檺
+ /// </summary>
+ [SugarColumn(ColumnName = "OUT_MIN_QTY")]
+ public decimal? OutMinQty { get; set; }
+
+ /// <summary>
+ /// 浜よ揣鍦扮偣
+ /// </summary>
+ [SugarColumn(ColumnName = "DELIVERY_LOC")]
+ public string? DeliveryLoc { get; set; }
+
+ /// <summary>
+ /// 浜よ揣鍦板潃
+ /// </summary>
+ [SugarColumn(ColumnName = "DELIVERYL_ADDRESS")]
+ public string? DeliverylAddress { get; set; }
+
+ /// <summary>
+ /// 婧愬崟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "SOURCE_BILL_NO")]
+ public string? SourceBillNo { get; set; }
+
+ /// <summary>
+ /// 璁㈠崟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ORDER_BILL_NO")]
+ public string? OrderBillNo { get; set; }
+
+ /// <summary>
+ /// 缁堟鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "TERMINATION_STATUS")]
+ public string? TerminationStatus { get; set; }
+
+ /// <summary>
+ /// 缁堟鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "TERMINATION_DATE")]
+ public DateTime? TerminationDate { get; set; }
+
+ /// <summary>
+ /// 绱鍑哄簱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "SUM_OUT_QTY")]
+ public decimal? SumOutQty { get; set; }
+
+ /// <summary>
+ /// 鏈嚭搴撴暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "REMAIN_OUT_QTY")]
+ public decimal? RemainOutQty { get; set; }
+
+ /// <summary>
+ /// ERP琛孖D
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_LINE_ID")]
+ public string? ErpLineId { get; set; }
+
+ /// <summary>
+ /// ERP澶碔D
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_HEAD_ID")]
+ public string? ErpHeadId { get; set; }
+
+ /// <summary>
+ /// 閿�鍞鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "SALES_ORDER")]
+ public string? SalesOrder { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛璁㈠崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "CUST_ORDER")]
+ public string? CustOrder { get; set; }
+
+ /// <summary>
+ /// 閿�鍞悎鍚岀紪鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "SALES_CONTRACT_NO")]
+ public string? SalesContractNo { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "F_KHWLMC")]
+ public string? F_KHWLMC { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "F_KHWLBM")]
+ public string? F_KHWLBM { get; set; }
+
+ /// <summary>
+ /// 鏄惁瀹岀粨
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_FINISH")]
+ public decimal? IsFinish { get; set; }
+}
\ No newline at end of file
--
Gitblit v1.9.3