From 4fa3f2b7d70af1539cf2731d7c54cc9769b0e14d Mon Sep 17 00:00:00 2001
From: zyf <1071160500@qq.com>
Date: 星期五, 15 十一月 2024 09:37:00 +0800
Subject: [PATCH] 委外变更单更新开工状态
---
MES.Service/Modes/ProductionOrder.cs | 460 +++++++++++++++++++++++++++++----------------------------
1 files changed, 233 insertions(+), 227 deletions(-)
diff --git a/MES.Service/Modes/ProductionOrder.cs b/MES.Service/Modes/ProductionOrder.cs
index 1a00649..968ec19 100644
--- a/MES.Service/Modes/ProductionOrder.cs
+++ b/MES.Service/Modes/ProductionOrder.cs
@@ -1,275 +1,281 @@
锘縰sing SqlSugar;
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鐢熶骇璁㈠崟琛�(濮斿)
-/// </summary>
-[SugarTable("PRODUCTION_ORDER")]
-public class ProductionOrder
+namespace MES.Service.Modes
{
/// <summary>
- /// SEQ_ORDER
- /// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ORDER",
- IsPrimaryKey = true)]
- public decimal Id { get; set; }
+ /// 鐢熶骇璁㈠崟琛�(濮斿)
+ ///</summary>
+ [SugarTable("PRODUCTION_ORDER")]
+ public class ProductionOrder
+ {
+ /// <summary>
+ /// SEQ_ORDER
+ ///</summary>
+ [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_ORDER", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
- /// <summary>
- /// 鍗曟嵁缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "ORDER_NO")]
- public string? OrderNo { get; set; }
+ /// <summary>
+ /// 鍗曟嵁缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName = "ORDER_NO")]
+ public string? OrderNo { get; set; }
- /// <summary>
- /// 璐寸墖宸ヨ壓灞炴��
- /// </summary>
- [SugarColumn(ColumnName = "SMT_PROCESS_ATTR")]
- public string? SmtProcessAttr { get; set; }
+ /// <summary>
+ /// 璐寸墖宸ヨ壓灞炴��
+ ///</summary>
+ [SugarColumn(ColumnName = "SMT_PROCESS_ATTR")]
+ public string? SmtProcessAttr { get; set; }
- /// <summary>
- /// 浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "WAREHOUSE")]
- public string? Warehouse { get; set; }
+ /// <summary>
+ /// 浠撳簱
+ ///</summary>
+ [SugarColumn(ColumnName = "WAREHOUSE")]
+ public string? Warehouse { get; set; }
- /// <summary>
- /// 鍗曟嵁鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "ORDER_DATE")]
- public DateTime? OrderDate { get; set; }
+ /// <summary>
+ /// 鍗曟嵁鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName = "ORDER_DATE")]
+ public DateTime? OrderDate { get; set; }
- /// <summary>
- /// 鍗曟嵁绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "ORDER_TYPE")]
- public string? OrderType { get; set; }
+ /// <summary>
+ /// 鍗曟嵁绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "ORDER_TYPE")]
+ public string? OrderType { get; set; }
- /// <summary>
- /// 涓氬姟鐘舵��
- /// </summary>
- [SugarColumn(ColumnName = "BUSINESS_STATUS")]
- public string? BusinessStatus { get; set; }
+ /// <summary>
+ /// 涓氬姟鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName = "BUSINESS_STATUS")]
+ public string? BusinessStatus { get; set; }
- /// <summary>
- /// 浜у搧缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "PRODUCT_CODE")]
- public string? ProductCode { get; set; }
+ /// <summary>
+ /// 浜у搧缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "PRODUCT_CODE")]
+ public string? ProductCode { get; set; }
- /// <summary>
- /// 鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "UNIT")]
- public string? Unit { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName = "UNIT")]
+ public string? Unit { get; set; }
- /// <summary>
- /// 宸ュ崟鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "WORK_ORDER_QTY")]
- public decimal? WorkOrderQty { get; set; }
+ /// <summary>
+ /// 宸ュ崟鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "WORK_ORDER_QTY")]
+ public double? WorkOrderQty { get; set; }
- /// <summary>
- /// 璁″垝缁�
- /// </summary>
- [SugarColumn(ColumnName = "PLANNING_GROUP")]
- public string? PlanningGroup { get; set; }
+ /// <summary>
+ /// 璁″垝缁�
+ ///</summary>
+ [SugarColumn(ColumnName = "PLANNING_GROUP")]
+ public string? PlanningGroup { get; set; }
- /// <summary>
- /// 璁″垝鍛�
- /// </summary>
- [SugarColumn(ColumnName = "PLANNER")]
- public string? Planner { get; set; }
+ /// <summary>
+ /// 璁″垝鍛�
+ ///</summary>
+ [SugarColumn(ColumnName = "PLANNER")]
+ public string? Planner { get; set; }
- /// <summary>
- /// 棰勮寮�宸ユ椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "ESTIMATED_START_TIME")]
- public DateTime? EstimatedStartTime { get; set; }
+ /// <summary>
+ /// 棰勮寮�宸ユ椂闂�
+ ///</summary>
+ [SugarColumn(ColumnName = "ESTIMATED_START_TIME")]
+ public DateTime? EstimatedStartTime { get; set; }
- /// <summary>
- /// 棰勮瀹屽伐鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "ESTIMATED_END_TIME")]
- public DateTime? EstimatedEndTime { get; set; }
+ /// <summary>
+ /// 棰勮瀹屽伐鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName = "ESTIMATED_END_TIME")]
+ public DateTime? EstimatedEndTime { get; set; }
- /// <summary>
- /// 璁″垝涓嬭揪鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "PLAN_RELEASE_DATE")]
- public DateTime? PlanReleaseDate { get; set; }
+ /// <summary>
+ /// 璁″垝涓嬭揪鏃ユ湡
+ ///</summary>
+ [SugarColumn(ColumnName = "PLAN_RELEASE_DATE")]
+ public DateTime? PlanReleaseDate { get; set; }
- /// <summary>
- /// 鍏ュ簱涓婇檺
- /// </summary>
- [SugarColumn(ColumnName = "STORAGE_UPPER_LIMIT")]
- public decimal? StorageUpperLimit { get; set; }
+ /// <summary>
+ /// 鍏ュ簱涓婇檺
+ ///</summary>
+ [SugarColumn(ColumnName = "STORAGE_UPPER_LIMIT")]
+ public double? StorageUpperLimit { get; set; }
- /// <summary>
- /// 鍏ュ簱涓嬮檺
- /// </summary>
- [SugarColumn(ColumnName = "STORAGE_LOWER_LIMIT")]
- public decimal? StorageLowerLimit { get; set; }
+ /// <summary>
+ /// 鍏ュ簱涓嬮檺
+ ///</summary>
+ [SugarColumn(ColumnName = "STORAGE_LOWER_LIMIT")]
+ public double? StorageLowerLimit { get; set; }
- /// <summary>
- /// 璁″垝璺熻釜鍙�
- /// </summary>
- [SugarColumn(ColumnName = "TRACKING_NO")]
- public string? TrackingNo { get; set; }
+ /// <summary>
+ /// 璁″垝璺熻釜鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "TRACKING_NO")]
+ public string? TrackingNo { get; set; }
- /// <summary>
- /// 鎵瑰彿
- /// </summary>
- [SugarColumn(ColumnName = "BATCH_NO")]
- public string? BatchNo { get; set; }
+ /// <summary>
+ /// 鎵瑰彿
+ ///</summary>
+ [SugarColumn(ColumnName = "BATCH_NO")]
+ public string? BatchNo { get; set; }
- /// <summary>
- /// BOM鐗堟
- /// </summary>
- [SugarColumn(ColumnName = "BOM_VERSION")]
- public string? BomVersion { get; set; }
+ /// <summary>
+ /// BOM鐗堟
+ ///</summary>
+ [SugarColumn(ColumnName = "BOM_VERSION")]
+ public string? BomVersion { get; set; }
- /// <summary>
- /// 閿�鍞鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "SALES_ORDER_NO")]
- public string? SalesOrderNo { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName = "SALES_ORDER_NO")]
+ public string? SalesOrderNo { get; set; }
- /// <summary>
- /// 閿�鍞鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "SALES_ORDER_LINE_NO")]
- public string? SalesOrderLineNo { get; set; }
+ /// <summary>
+ /// 閿�鍞鍗曡鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "SALES_ORDER_LINE_NO")]
+ public string? SalesOrderLineNo { get; set; }
- /// <summary>
- /// 鐢熸垚鏂瑰紡
- /// </summary>
- [SugarColumn(ColumnName = "GENERATION_METHOD")]
- public string? GenerationMethod { get; set; }
+ /// <summary>
+ /// 鐢熸垚鏂瑰紡
+ ///</summary>
+ [SugarColumn(ColumnName = "GENERATION_METHOD")]
+ public string? GenerationMethod { get; set; }
- /// <summary>
- /// ERP鐢熶骇璁㈠崟ID
- /// </summary>
- [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_ID")]
- public string? ErpProductionOrderId { get; set; }
+ /// <summary>
+ /// ERP鐢熶骇璁㈠崟ID
+ ///</summary>
+ [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_ID")]
+ public string? ErpProductionOrderId { get; set; }
- /// <summary>
- /// ERP鐢熶骇璁㈠崟搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_LINE_NO")]
- public string? ErpProductionOrderLineNo { get; set; }
+ /// <summary>
+ /// ERP鐢熶骇璁㈠崟搴忓彿
+ ///</summary>
+ [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_LINE_NO")]
+ public string? ErpProductionOrderLineNo { get; set; }
- /// <summary>
- /// ERP鐢熶骇璁㈠崟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_NO")]
- public string? ErpProductionOrderNo { get; set; }
+ /// <summary>
+ /// ERP鐢熶骇璁㈠崟鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_NO")]
+ public string? ErpProductionOrderNo { get; set; }
- /// <summary>
- /// 婧愬崟绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "SOURCE_ORDER_TYPE")]
- public string? SourceOrderType { get; set; }
+ /// <summary>
+ /// 婧愬崟绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "SOURCE_ORDER_TYPE")]
+ public string? SourceOrderType { get; set; }
- /// <summary>
- /// 婧愬崟缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "SOURCE_ORDER_NO")]
- public string? SourceOrderNo { get; set; }
+ /// <summary>
+ /// 婧愬崟缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName = "SOURCE_ORDER_NO")]
+ public string? SourceOrderNo { get; set; }
- /// <summary>
- /// 婧愬崟鍒嗗綍琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "SOURCE_ORDER_ENTRY_NO")]
- public string? SourceOrderEntryNo { get; set; }
+ /// <summary>
+ /// 婧愬崟鍒嗗綍琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName = "SOURCE_ORDER_ENTRY_NO")]
+ public string? SourceOrderEntryNo { get; set; }
- /// <summary>
- /// 闇�姹傚崟鎹彿
- /// </summary>
- [SugarColumn(ColumnName = "DEMAND_ORDER_NO")]
- public string? DemandOrderNo { get; set; }
+ /// <summary>
+ /// 闇�姹傚崟鎹彿
+ ///</summary>
+ [SugarColumn(ColumnName = "DEMAND_ORDER_NO")]
+ public string? DemandOrderNo { get; set; }
- /// <summary>
- /// 闇�姹傚崟鎹鍙�
- /// </summary>
- [SugarColumn(ColumnName = "DEMAND_ORDER_LINE_NO")]
- public string? DemandOrderLineNo { get; set; }
+ /// <summary>
+ /// 闇�姹傚崟鎹鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "DEMAND_ORDER_LINE_NO")]
+ public string? DemandOrderLineNo { get; set; }
- /// <summary>
- /// 缁撴浜�
- /// </summary>
- [SugarColumn(ColumnName = "CLOSING_PERSON")]
- public string? ClosingPerson { get; set; }
+ /// <summary>
+ /// 缁撴浜�
+ ///</summary>
+ [SugarColumn(ColumnName = "CLOSING_PERSON")]
+ public string? ClosingPerson { get; set; }
- /// <summary>
- /// 缁撴绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "CLOSING_TYPE")]
- public string? ClosingType { get; set; }
+ /// <summary>
+ /// 缁撴绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "CLOSING_TYPE")]
+ public string? ClosingType { get; set; }
- /// <summary>
- /// 婧愭媶鍒嗚鍗曠紪鍙�
- /// </summary>
- [SugarColumn(ColumnName = "SPLIT_ORDER_NO")]
- public string? SplitOrderNo { get; set; }
+ /// <summary>
+ /// 婧愭媶鍒嗚鍗曠紪鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "SPLIT_ORDER_NO")]
+ public string? SplitOrderNo { get; set; }
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "REMARKS")]
- public string? Remarks { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName = "REMARKS")]
+ public string? Remarks { get; set; }
- /// <summary>
- /// ERPID
- /// </summary>
- [SugarColumn(ColumnName = "ERP_ID")]
- public string? ErpId { get; set; }
+ /// <summary>
+ /// ERPID
+ ///</summary>
+ [SugarColumn(ColumnName = "ERP_ID")]
+ public string? ErpId { get; set; }
- /// <summary>
- /// ERP鐢熶骇璁㈠崟鍒嗗綍鍐呯爜
- /// </summary>
- [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
- public string? ErpProductionEntryCode { get; set; }
+ /// <summary>
+ /// ERP鐢熶骇璁㈠崟鍒嗗綍鍐呯爜
+ ///</summary>
+ [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
+ public string? ErpProductionEntryCode { get; set; }
- /// <summary>
- /// 閲囪喘璁㈠崟
- /// </summary>
- [SugarColumn(ColumnName = "PURCHASEORDERNO")]
- public string? PurchaseOrderNo { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟
+ ///</summary>
+ [SugarColumn(ColumnName = "PURCHASEORDERNO")]
+ public string? PurchaseOrderNo { get; set; }
- /// <summary>
- /// 閲囪喘璁㈠崟琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "PURCHASEORDERENTRYSEQ")]
- public long? PurchaseOrderEntrySeq { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛屽彿
+ ///</summary>
+ [SugarColumn(ColumnName = "PURCHASEORDERENTRYSEQ")]
+ public long? PurchaseOrderEntrySeq { get; set; }
- /// <summary>
- /// 鏍囧噯鐐规暟
- /// </summary>
- [SugarColumn(ColumnName = "STANDARDPOINTS")]
- public decimal? StandardPoints { get; set; }
+ /// <summary>
+ /// 鏍囧噯鐐规暟
+ ///</summary>
+ [SugarColumn(ColumnName = "STANDARDPOINTS")]
+ public decimal? Standardpoints { get; set; }
- /// <summary>
- /// 璁′环鐐规暟
- /// </summary>
- [SugarColumn(ColumnName = "PRICINGPOINTS")]
- public decimal? PricingPoints { get; set; }
+ /// <summary>
+ /// 璁′环鐐规暟
+ ///</summary>
+ [SugarColumn(ColumnName = "PRICINGPOINTS")]
+ public decimal? Pricingpoints { get; set; }
- /// <summary>
- /// 鍏ュ簱鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "STOCKINQTY")]
- public decimal? StockInQty { get; set; }
+ /// <summary>
+ /// 鍏ュ簱鏁伴噺
+ ///</summary>
+ [SugarColumn(ColumnName = "STOCKINQTY")]
+ public decimal? StockInQty { get; set; }
- /// <summary>
- /// 鏈叆搴撴暟閲�
- /// </summary>
- [SugarColumn(ColumnName = "NOSTOCKINQTY")]
- public decimal? NoStockInQty { get; set; }
+ /// <summary>
+ /// 鏈叆搴撴暟閲�
+ ///</summary>
+ [SugarColumn(ColumnName = "NOSTOCKINQTY")]
+ public double? NoStockInQty { get; set; }
- /// <summary>
- /// 鍏ュ簱璐т富
- /// </summary>
- [SugarColumn(ColumnName = "STOCKOWNER")]
- public string? StockOwner { get; set; }
+ /// <summary>
+ /// 鍏ュ簱璐т富
+ ///</summary>
+ [SugarColumn(ColumnName = "STOCKOWNER")]
+ public string? StockOwner { get; set; }
+
+ /// <summary>
+ /// 渚涘簲鍟�
+ ///</summary>
+ [SugarColumn(ColumnName = "SUPP_NO")]
+ public string? SUPPLIER { get; set; }
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3