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/Womcaa.cs |  516 ++++++++++++++++++++++++++------------------------------
 1 files changed, 238 insertions(+), 278 deletions(-)

diff --git a/MES.Service/Modes/Womcaa.cs b/MES.Service/Modes/Womcaa.cs
index fc5e544..634dcf6 100644
--- a/MES.Service/Modes/Womcaa.cs
+++ b/MES.Service/Modes/Womcaa.cs
@@ -1,282 +1,242 @@
 锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-///     宸ュ崟琛�
-/// </summary>
-[SugarTable("WOMCAA")]
-public class Womcaa
+namespace MES.Service.Modes
 {
     /// <summary>
-    ///     鑷鍒�  SEQ_AOI
-    /// </summary>
-    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
+    /// 浠诲姟鍗曡〃
+    ///</summary>
+    [SugarTable("WOMCAA")]
+    public class Womcaa
+    {
+        /// <summary>
+        /// 鑷鍒� 
+        ///</summary>
+         [SugarColumn(ColumnName="ID", IsPrimaryKey = true,
         OracleSequenceName = "SEQ_AOI")]
-    public decimal? Id { get; set; }
-
-    /// <summary>
-    ///     ERPID
-    /// </summary>
-    [SugarColumn(ColumnName = "ERPID")]
-    public decimal? Erpid { get; set; }
-
-    /// <summary>
-    ///     鍗曞彿
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA001")]
-    public string? Caa001 { get; set; }
-
-    /// <summary>
-    ///     鍗曟嵁绫诲瀷 1銆佺洿鎺ュ叆搴�-鏅�氱敓浜� SCDD03_SYS2銆佺洿鎺ュ叆搴�-杩斿伐鐢熶骇 SCDD04_SYS3銆佸伐搴忔眹鎶�-鏅�氱敓浜�
-    ///     SCDD01_SYS4銆佸伐搴忔眹鎶�-杩斿伐鐢熶骇 SCDD02_SYS
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA004")]
-    public string? Caa004 { get; set; }
-
-    /// <summary>
-    ///     寮�鍗曟棩鏈�
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA005")]
-    public string? Caa005 { get; set; }
-
-    /// <summary>
-    ///     浜у搧缂栫爜
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA006")]
-    public string? Caa006 { get; set; }
-
-    /// <summary>
-    ///     鍗曚綅
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA009")]
-    public string? Caa009 { get; set; }
-
-    /// <summary>
-    ///     棰勮寮�宸ユ椂闂�
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA010")]
-    public string? Caa010 { get; set; }
-
-    /// <summary>
-    ///     棰勮瀹屽伐鏃堕棿
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA011")]
-    public string? Caa011 { get; set; }
-
-    /// <summary>
-    ///     鏁伴噺
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA012")]
-    public decimal? Caa012 { get; set; }
-
-    /// <summary>
-    ///     BOM鐗堟
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA013")]
-    public string? Caa013 { get; set; }
-
-    /// <summary>
-    ///     閿�鍞鍗曞彿
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA015")]
-    public string? Caa015 { get; set; }
-
-    /// <summary>
-    ///     澶囨敞
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA016")]
-    public string? Caa016 { get; set; }
-
-    /// <summary>
-    ///     宸叉帓鏁伴噺
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA017")]
-    public decimal? Caa017 { get; set; }
-
-    /// <summary>
-    ///     ERP婧愬崟ID
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA018")]
-    public decimal? Caa018 { get; set; }
-
-    /// <summary>
-    ///     ERP婧愬崟琛屽彿
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA019")]
-    public decimal? Caa019 { get; set; }
-
-    /// <summary>
-    ///     ERP婧愬崟鍗曞彿(浠诲姟鍗曞彿)
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA020")]
-    public string? Caa020 { get; set; }
-
-    /// <summary>
-    ///     宸ヤ綔杞﹂棿
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA021")]
-    public string? Caa021 { get; set; }
-
-    /// <summary>
-    ///     瀹℃牳鐮�
-    /// </summary>
-    [SugarColumn(ColumnName = "FSTATUS")]
-    public decimal? Fstatus { get; set; }
-
-    /// <summary>
-    ///     瀹℃牳鏃ユ湡
-    /// </summary>
-    [SugarColumn(ColumnName = "CHECK_DATE")]
-    public DateTime? CheckDate { get; set; }
-
-    /// <summary>
-    ///     瀹℃牳浜�
-    /// </summary>
-    [SugarColumn(ColumnName = "CHECK_USER")]
-    public string? CheckUser { get; set; }
-
-    /// <summary>
-    ///     鏈帓鏁伴噺
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA022")]
-    public decimal? Caa022 { get; set; }
-
-    /// <summary>
-    ///     鐘舵�� 瀹屽伐锛屾湭瀹屽伐
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA023")]
-    public string? Caa023 { get; set; }
-
-    /// <summary>
-    ///     宸插叆搴撴暟閲�
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA024")]
-    public decimal? Caa024 { get; set; }
-
-    /// <summary>
-    ///     宸ヨ壓璺嚎
-    /// </summary>
-    [SugarColumn(ColumnName = "ROUTING_ID")]
-    public string? RoutingId { get; set; }
-
-    /// <summary>
-    ///     浜х嚎
-    /// </summary>
-    [SugarColumn(ColumnName = "WORK_SHOP_ID")]
-    public string? WorkShopId { get; set; }
-
-    /// <summary>
-    ///     浠撳簱
-    /// </summary>
-    [SugarColumn(ColumnName = "DEPOT_CODE")]
-    public string? DepotCode { get; set; }
-
-    /// <summary>
-    ///     鍗曟嵁鏃ユ湡
-    /// </summary>
-    [SugarColumn(ColumnName = "CREATE_DATE")]
-    public string? CreateDate { get; set; }
-
-    /// <summary>
-    ///     璁″垝缁�
-    /// </summary>
-    [SugarColumn(ColumnName = "WORK_GROUP_ID")]
-    public string? WorkGroupId { get; set; }
-
-    /// <summary>
-    ///     璁″垝鍛�
-    /// </summary>
-    [SugarColumn(ColumnName = "PLAN_ID")]
-    public string? PlanId { get; set; }
-
-    /// <summary>
-    ///     鍏ュ簱涓婇檺
-    /// </summary>
-    [SugarColumn(ColumnName = "STOCK_INLIMITH")]
-    public string? StockInlimith { get; set; }
-
-    /// <summary>
-    ///     鍏ュ簱涓嬮檺
-    /// </summary>
-    [SugarColumn(ColumnName = "STOCK_INLIMITL")]
-    public string? StockInlimitl { get; set; }
-
-    /// <summary>
-    ///     璁″垝璺熻釜鍙�
-    /// </summary>
-    [SugarColumn(ColumnName = "MTONO")]
-    public string? Mtono { get; set; }
-
-    /// <summary>
-    ///     鎵瑰彿
-    /// </summary>
-    [SugarColumn(ColumnName = "LOT")]
-    public string? Lot { get; set; }
-
-    /// <summary>
-    ///     閿�鍞鍗曡鍙�
-    /// </summary>
-    [SugarColumn(ColumnName = "CAA015_HEAD")]
-    public string? Caa015Head { get; set; }
-
-    /// <summary>
-    ///     鐢熸垚鏂瑰紡
-    /// </summary>
-    [SugarColumn(ColumnName = "CREATE_TYPE")]
-    public string? CreateType { get; set; }
-
-    /// <summary>
-    ///     婧愬崟绫诲瀷
-    /// </summary>
-    [SugarColumn(ColumnName = "SRC_BILL_TYPE")]
-    public string? SrcBillType { get; set; }
-
-    /// <summary>
-    ///     婧愬崟缂栧彿
-    /// </summary>
-    [SugarColumn(ColumnName = "SRC_BILL_NO")]
-    public string? SrcBillNo { get; set; }
-
-    /// <summary>
-    ///     婧愬崟鍒嗗綍琛屽彿
-    /// </summary>
-    [SugarColumn(ColumnName = "SRC_BILLENTRYSEQ")]
-    public string? SrcBillentryseq { get; set; }
-
-    /// <summary>
-    ///     闇�姹傚崟鎹彿
-    /// </summary>
-    [SugarColumn(ColumnName = "SALE_ORDER_NO")]
-    public string? SaleOrderNo { get; set; }
-
-    /// <summary>
-    ///     闇�姹傚崟鎹鍙�
-    /// </summary>
-    [SugarColumn(ColumnName = "SALE_ORDER_ENTRYSEQ")]
-    public string? SaleOrderEntryseq { get; set; }
-
-    /// <summary>
-    ///     缁撴浜�
-    /// </summary>
-    [SugarColumn(ColumnName = "FORCE_CLOSERID")]
-    public string? ForceCloserid { get; set; }
-
-    /// <summary>
-    ///     缁撴绫诲瀷
-    /// </summary>
-    [SugarColumn(ColumnName = "CLOSE_TYPE")]
-    public string? CloseType { get; set; }
-
-    /// <summary>
-    ///     婧愭媶鍒嗚鍗曠紪鍙�
-    /// </summary>
-    [SugarColumn(ColumnName = "SRC_SPLIT_BILLNO")]
-    public string? SrcSplitBillno { get; set; }
-
-    /// <summary>
-    ///     鐢熶骇璁㈠崟琛屽唴鐮�
-    /// </summary>
-    [SugarColumn(ColumnName = "FMOENTRYID")]
-    public decimal? FMOENTRYID { get; set; }
-}
\ No newline at end of file
+         public decimal? Id { get; set; }
+        /// <summary>
+        /// ERPID 
+        ///</summary>
+         [SugarColumn(ColumnName="ERPID"    )]
+         public decimal? Erpid { get; set; }
+        /// <summary>
+        /// 鍗曟嵁缂栧彿 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA001"    )]
+         public string? Caa001 { get; set; }
+        /// <summary>
+        /// 鍗曟嵁绫诲瀷 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA004"    )]
+         public string? Caa004 { get; set; }
+        /// <summary>
+        /// 璁″垝涓嬭揪鏃ユ湡 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA005"    )]
+         public string? Caa005 { get; set; }
+        /// <summary>
+        /// 浜у搧缂栫爜 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA006"    )]
+         public string? Caa006 { get; set; }
+        /// <summary>
+        /// 鍗曚綅 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA009"    )]
+         public string? Caa009 { get; set; }
+        /// <summary>
+        /// 棰勮寮�宸ユ椂闂� 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA010"    )]
+         public string? Caa010 { get; set; }
+        /// <summary>
+        /// 棰勮瀹屽伐鏃堕棿 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA011"    )]
+         public string? Caa011 { get; set; }
+        /// <summary>
+        /// 宸ュ崟鏁伴噺 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA012"    )]
+         public decimal? Caa012 { get; set; }
+        /// <summary>
+        /// BOM鐗堟 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA013"    )]
+         public string? Caa013 { get; set; }
+        /// <summary>
+        /// 閿�鍞鍗曞彿 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA015"    )]
+         public string? Caa015 { get; set; }
+        /// <summary>
+        /// 澶囨敞 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA016"    )]
+         public string? Caa016 { get; set; }
+        /// <summary>
+        /// 宸叉帓鏁伴噺锛堝純鐢級 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA017"    )]
+         public decimal? Caa017 { get; set; }
+        /// <summary>
+        /// ERP鐢熶骇璁㈠崟ID 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA018"    )]
+         public decimal? Caa018 { get; set; }
+        /// <summary>
+        /// ERP鐢熶骇璁㈠崟搴忓彿 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA019"    )]
+         public decimal? Caa019 { get; set; }
+        /// <summary>
+        /// ERP鐢熶骇璁㈠崟鍗曞彿 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA020"    )]
+         public string? Caa020 { get; set; }
+        /// <summary>
+        /// 鐢熶骇杞﹂棿 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA021"    )]
+         public string? Caa021 { get; set; }
+        /// <summary>
+        /// 瀹℃牳鐮� 
+        ///</summary>
+         [SugarColumn(ColumnName="FSTATUS"    )]
+         public decimal? Fstatus { get; set; }
+        /// <summary>
+        /// 瀹℃牳鏃ユ湡 
+        ///</summary>
+         [SugarColumn(ColumnName="CHECK_DATE"    )]
+         public DateTime? CheckDate { get; set; }
+        /// <summary>
+        /// 瀹℃牳浜� 
+        ///</summary>
+         [SugarColumn(ColumnName="CHECK_USER"    )]
+         public string? CheckUser { get; set; }
+        /// <summary>
+        /// 鏈帓鏁伴噺锛堝純鐢級 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA022"    )]
+         public decimal? Caa022 { get; set; }
+        /// <summary>
+        /// &quot;宸ュ崟鐘舵�� 1銆佽鍒� 2銆佽鍒掔‘璁� 3銆佷笅杈� 4銆佸紑宸� 5銆佸畬宸� 6銆佺粨妗� 7銆佺粨绠�&quot; 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA023"    )]
+         public string? Caa023 { get; set; }
+        /// <summary>
+        /// 宸插叆搴撴暟閲� 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA024"    )]
+         public decimal? Caa024 { get; set; }
+        /// <summary>
+        /// 宸ヨ壓璺嚎 
+        ///</summary>
+         [SugarColumn(ColumnName="ROUTING_ID"    )]
+         public string? RoutingId { get; set; }
+        /// <summary>
+        /// 浜х嚎 
+        ///</summary>
+         [SugarColumn(ColumnName="WORK_SHOP_ID"    )]
+         public string? WorkShopId { get; set; }
+        /// <summary>
+        /// 浠撳簱 
+        ///</summary>
+         [SugarColumn(ColumnName="DEPOT_CODE"    )]
+         public string? DepotCode { get; set; }
+        /// <summary>
+        /// 鍗曟嵁鏃ユ湡 
+        ///</summary>
+         [SugarColumn(ColumnName="CREATE_DATE"    )]
+         public string? CreateDate { get; set; }
+        /// <summary>
+        /// 璁″垝缁� 
+        ///</summary>
+         [SugarColumn(ColumnName="WORK_GROUP_ID"    )]
+         public string? WorkGroupId { get; set; }
+        /// <summary>
+        /// 璁″垝鍛� 
+        ///</summary>
+         [SugarColumn(ColumnName="PLAN_ID"    )]
+         public string? PlanId { get; set; }
+        /// <summary>
+        /// 鍏ュ簱涓婇檺 
+        ///</summary>
+         [SugarColumn(ColumnName="STOCK_INLIMITH"    )]
+         public string? StockInlimith { get; set; }
+        /// <summary>
+        /// 鍏ュ簱涓嬮檺 
+        ///</summary>
+         [SugarColumn(ColumnName="STOCK_INLIMITL"    )]
+         public string? StockInlimitl { get; set; }
+        /// <summary>
+        /// 璁″垝璺熻釜鍙� 
+        ///</summary>
+         [SugarColumn(ColumnName="MTONO"    )]
+         public string? Mtono { get; set; }
+        /// <summary>
+        /// 鎵瑰彿 
+        ///</summary>
+         [SugarColumn(ColumnName="LOT"    )]
+         public string? Lot { get; set; }
+        /// <summary>
+        /// 閿�鍞鍗曡鍙� 
+        ///</summary>
+         [SugarColumn(ColumnName="CAA015_HEAD"    )]
+         public string? Caa015Head { get; set; }
+        /// <summary>
+        /// 鐢熸垚鏂瑰紡 
+        ///</summary>
+         [SugarColumn(ColumnName="CREATE_TYPE"    )]
+         public string? CreateType { get; set; }
+        /// <summary>
+        /// 婧愬崟绫诲瀷 
+        ///</summary>
+         [SugarColumn(ColumnName="SRC_BILL_TYPE"    )]
+         public string? SrcBillType { get; set; }
+        /// <summary>
+        /// 婧愬崟缂栫爜 
+        ///</summary>
+         [SugarColumn(ColumnName="SRC_BILL_NO"    )]
+         public string? SrcBillNo { get; set; }
+        /// <summary>
+        /// 婧愬崟鍒嗗綍琛屽彿 
+        ///</summary>
+         [SugarColumn(ColumnName="SRC_BILLENTRYSEQ"    )]
+         public string? SrcBillentryseq { get; set; }
+        /// <summary>
+        /// 闇�姹傚崟鎹彿 
+        ///</summary>
+         [SugarColumn(ColumnName="SALE_ORDER_NO"    )]
+         public string? SaleOrderNo { get; set; }
+        /// <summary>
+        /// 闇�姹傚崟鎹鍙� 
+        ///</summary>
+         [SugarColumn(ColumnName="SALE_ORDER_ENTRYSEQ"    )]
+         public string? SaleOrderEntryseq { get; set; }
+        /// <summary>
+        /// 缁撴浜� 
+        ///</summary>
+         [SugarColumn(ColumnName="FORCE_CLOSERID"    )]
+         public string? ForceCloserid { get; set; }
+        /// <summary>
+        /// 缁撴绫诲瀷 
+        ///</summary>
+         [SugarColumn(ColumnName="CLOSE_TYPE"    )]
+         public string? CloseType { get; set; }
+        /// <summary>
+        /// 婧愭媶鍒嗚鍗曠紪鍙� 
+        ///</summary>
+         [SugarColumn(ColumnName="SRC_SPLIT_BILLNO"    )]
+         public string? SrcSplitBillno { get; set; }
+        /// <summary>
+        /// 鐢熶骇璁㈠崟琛屽唴鐮� 
+        ///</summary>
+         [SugarColumn(ColumnName="FMOENTRYID"    )]
+         public decimal? Fmoentryid { get; set; }
+        /// <summary>
+        /// 鎺掍骇绾垮埆 
+        ///</summary>
+         [SugarColumn(ColumnName="PROD_LINE"    )]
+         public string? ProdLine { get; set; }
+    }
+}

--
Gitblit v1.9.3