From 1e1b8c262ebe02e82f93c4344f9feb9624f77b52 Mon Sep 17 00:00:00 2001
From: zyf <1071160500@qq.com>
Date: 星期二, 17 六月 2025 19:17:10 +0800
Subject: [PATCH] BOM接口优化逻辑
---
MES.Service/Modes/ProductionOrderSub.cs | 344 ++++++++++++++++++++++++++++----------------------------
1 files changed, 172 insertions(+), 172 deletions(-)
diff --git a/MES.Service/Modes/ProductionOrderSub.cs b/MES.Service/Modes/ProductionOrderSub.cs
index 034c198..870a975 100644
--- a/MES.Service/Modes/ProductionOrderSub.cs
+++ b/MES.Service/Modes/ProductionOrderSub.cs
@@ -1,209 +1,209 @@
锘縰sing SqlSugar;
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鐢熶骇璁㈠崟琛�(濮斿)瀛愯〃
-/// </summary>
-[SugarTable("PRODUCTION_ORDER_SUB")]
-public class ProductionOrderSub
+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_SUB")]
+ public class ProductionOrderSub
+ {
+ /// <summary>
+ /// SEQ_ORDER
+ ///</summary>
+ [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_ORDER", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
- /// <summary>
- /// 宸ュ崟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_ORDER_NO")]
- public string? WorkOrderNo { get; set; }
+ /// <summary>
+ /// 宸ュ崟鍗曞彿
+ ///</summary>
+ [SugarColumn(ColumnName = "WORK_ORDER_NO")]
+ public string? WorkOrderNo { get; set; }
- /// <summary>
- /// 搴忓彿
- /// </summary>
- [SugarColumn(ColumnName = "SEQUENCE_NO")]
- public long? SequenceNo { get; set; }
+ /// <summary>
+ /// 搴忓彿
+ ///</summary>
+ [SugarColumn(ColumnName = "SEQUENCE_NO")]
+ public long? SequenceNo { get; set; }
- /// <summary>
- /// 鏉愭枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "MATERIAL_CODE")]
- public string? MaterialCode { get; set; }
+ /// <summary>
+ /// 鏉愭枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName = "MATERIAL_CODE")]
+ public string? MaterialCode { get; set; }
- /// <summary>
- /// 闇�棰嗙敤閲�
- /// </summary>
- [SugarColumn(ColumnName = "REQUIRED_QTY")]
- public decimal? RequiredQty { get; set; }
+ /// <summary>
+ /// 闇�棰嗙敤閲�
+ ///</summary>
+ [SugarColumn(ColumnName = "REQUIRED_QTY")]
+ public double? RequiredQty { get; set; }
- /// <summary>
- /// 宸查鐢ㄩ噺
- /// </summary>
- [SugarColumn(ColumnName = "ISSUED_QTY")]
- public decimal? IssuedQty { get; set; }
+ /// <summary>
+ /// 宸查鐢ㄩ噺
+ ///</summary>
+ [SugarColumn(ColumnName = "ISSUED_QTY")]
+ public decimal? IssuedQty { get; set; }
- /// <summary>
- /// 浣嶇疆鍙�
- /// </summary>
- [SugarColumn(ColumnName = "LOCATION_NO")]
- public string? LocationNo { get; set; }
+ /// <summary>
+ /// 浣嶇疆鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "LOCATION_NO")]
+ public string? LocationNo { get; set; }
- /// <summary>
- /// 渚涘簲缁勭粐
- /// </summary>
- [SugarColumn(ColumnName = "SUPPLYING_ORG")]
- public string? SupplyingOrg { get; set; }
+ /// <summary>
+ /// 渚涘簲缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "SUPPLYING_ORG")]
+ public string? SupplyingOrg { get; set; }
- /// <summary>
- /// 鍙戞枡缁勭粐
- /// </summary>
- [SugarColumn(ColumnName = "ISSUING_ORG")]
- public string? IssuingOrg { get; set; }
+ /// <summary>
+ /// 鍙戞枡缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "ISSUING_ORG")]
+ public string? IssuingOrg { get; set; }
- /// <summary>
- /// 璐т富
- /// </summary>
- [SugarColumn(ColumnName = "STOCK_OWNER")]
- public string? StockOwner { get; set; }
+ /// <summary>
+ /// 璐т富
+ ///</summary>
+ [SugarColumn(ColumnName = "STOCK_OWNER")]
+ public string? StockOwner { 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>
- /// 浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "WAREHOUSE")]
- public string? Warehouse { get; set; }
+ /// <summary>
+ /// 浠撳簱
+ ///</summary>
+ [SugarColumn(ColumnName = "WAREHOUSE")]
+ public string? Warehouse { get; set; }
- /// <summary>
- /// 鍙戞枡鏂瑰紡
- /// </summary>
- [SugarColumn(ColumnName = "ISSUING_METHOD")]
- public string? IssuingMethod { get; set; }
+ /// <summary>
+ /// 鍙戞枡鏂瑰紡
+ ///</summary>
+ [SugarColumn(ColumnName = "ISSUING_METHOD")]
+ public string? IssuingMethod { get; set; }
- /// <summary>
- /// 宸ヨ壓
- /// </summary>
- [SugarColumn(ColumnName = "PROCESS")]
- public string? Process { get; set; }
+ /// <summary>
+ /// 宸ヨ壓
+ ///</summary>
+ [SugarColumn(ColumnName = "PROCESS")]
+ public string? Process { 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 = "SUPPLYING_TYPE")]
- public string? SupplyingType { get; set; }
+ /// <summary>
+ /// 渚涘簲绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "SUPPLYING_TYPE")]
+ public string? SupplyingType { get; set; }
- /// <summary>
- /// 缁勬垚鐢ㄩ噺
- /// </summary>
- [SugarColumn(ColumnName = "COMPOSITION_QTY")]
- public decimal? CompositionQty { get; set; }
+ /// <summary>
+ /// 缁勬垚鐢ㄩ噺
+ ///</summary>
+ [SugarColumn(ColumnName = "COMPOSITION_QTY")]
+ public decimal? CompositionQty { get; set; }
- /// <summary>
- /// 鏄惁鏇挎枡
- /// </summary>
- [SugarColumn(ColumnName = "IS_SUBSTITUTE")]
- public string? IsSubstitute { get; set; }
+ /// <summary>
+ /// 鏄惁鏇挎枡
+ ///</summary>
+ [SugarColumn(ColumnName = "IS_SUBSTITUTE")]
+ public string? IsSubstitute { get; set; }
- /// <summary>
- /// 鍒嗗瓙
- /// </summary>
- [SugarColumn(ColumnName = "NUMERATOR")]
- public long? Numerator { get; set; }
+ /// <summary>
+ /// 鍒嗗瓙
+ ///</summary>
+ [SugarColumn(ColumnName = "NUMERATOR")]
+ public double? Numerator { get; set; }
- /// <summary>
- /// 鍒嗘瘝
- /// </summary>
- [SugarColumn(ColumnName = "DENOMINATOR")]
- public long? Denominator { get; set; }
+ /// <summary>
+ /// 鍒嗘瘝
+ ///</summary>
+ [SugarColumn(ColumnName = "DENOMINATOR")]
+ public double? Denominator { 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澶碔D
- /// </summary>
- [SugarColumn(ColumnName = "ERP_HEADER_ID")]
- public string? ErpHeaderId { get; set; }
+ /// <summary>
+ /// ERP澶碔D
+ ///</summary>
+ [SugarColumn(ColumnName = "ERP_HEADER_ID")]
+ public string? ErpHeaderId { get; set; }
- /// <summary>
- /// 鍥哄畾鎹熻��
- /// </summary>
- [SugarColumn(ColumnName = "FIXED_LOSS")]
- public decimal? FixedLoss { get; set; }
+ /// <summary>
+ /// 鍥哄畾鎹熻��
+ ///</summary>
+ [SugarColumn(ColumnName = "FIXED_LOSS")]
+ public decimal? FixedLoss { get; set; }
- /// <summary>
- /// 鍙樺姩鎹熻�楃巼%
- /// </summary>
- [SugarColumn(ColumnName = "VARIABLE_LOSS_RATE")]
- public string? VariableLossRate { get; set; }
+ /// <summary>
+ /// 鍙樺姩鎹熻�楃巼%
+ ///</summary>
+ [SugarColumn(ColumnName = "VARIABLE_LOSS_RATE")]
+ public string? VariableLossRate { get; set; }
- /// <summary>
- /// 瀛愰」绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "SUB_ITEM_TYPE")]
- public string? SubItemType { get; set; }
+ /// <summary>
+ /// 瀛愰」绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "SUB_ITEM_TYPE")]
+ public string? SubItemType { get; set; }
- /// <summary>
- /// 瀛愰」鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "SUB_ITEM_UNIT")]
- public string? SubItemUnit { get; set; }
+ /// <summary>
+ /// 瀛愰」鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName = "SUB_ITEM_UNIT")]
+ public string? SubItemUnit { 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 = "ITEM_NO")]
- public string? ItemNo { get; set; }
+ /// <summary>
+ /// 椤规鍙�
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_NO")]
+ public string? ItemNo { get; set; }
- /// <summary>
- /// 鍙戞枡缁勭粐
- /// </summary>
- [SugarColumn(ColumnName = "ISSUING_ORG_2")]
- public string? IssuingOrg2 { get; set; }
+ /// <summary>
+ /// 鍙戞枡缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "ISSUING_ORG_2")]
+ public string? IssuingOrg2 { get; set; }
- /// <summary>
- /// 璐т富绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "OWNER_TYPE")]
- public string? OwnerType { get; set; }
+ /// <summary>
+ /// 璐т富绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "OWNER_TYPE")]
+ public string? OwnerType { get; set; }
- /// <summary>
- /// 璐т富
- /// </summary>
- [SugarColumn(ColumnName = "OWNER")]
- public string? Owner { get; set; }
+ /// <summary>
+ /// 璐т富
+ ///</summary>
+ [SugarColumn(ColumnName = "OWNER")]
+ public string? Owner { get; set; }
- /// <summary>
- /// 渚涘簲缁勭粐
- /// </summary>
- [SugarColumn(ColumnName = "SUPPLYING_ORG_2")]
- public string? SupplyingOrg2 { get; set; }
+ /// <summary>
+ /// 渚涘簲缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "SUPPLYING_ORG_2")]
+ public string? SupplyingOrg2 { get; set; }
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3