From 554fa8ad99c42b6c0e3ed2c56358a3d7dd9ded6e Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 13 十二月 2024 14:11:45 +0800
Subject: [PATCH] 11

---
 MES.Service/Modes/Womcaa.cs |  372 +++++++++++++++++++++++++++++++++--------------------
 1 files changed, 232 insertions(+), 140 deletions(-)

diff --git a/MES.Service/Modes/Womcaa.cs b/MES.Service/Modes/Womcaa.cs
index 869e76a..0dc869e 100644
--- a/MES.Service/Modes/Womcaa.cs
+++ b/MES.Service/Modes/Womcaa.cs
@@ -3,69 +3,67 @@
 namespace MES.Service.Modes;
 
 /// <summary>
-///     宸ュ崟琛�
+///     鐢熶骇浠诲姟鍗曡〃
 /// </summary>
 [SugarTable("WOMCAA")]
 public class Womcaa
 {
     /// <summary>
-    ///     鑷鍒�  SEQ_AOI
+    ///     榛樿鍊�: (newid())
     /// </summary>
-    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
-        OracleSequenceName = "SEQ_AOI")]
-    public decimal? Id { get; set; }
+    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+    public Guid Guid { get; set; }
 
     /// <summary>
     ///     ERPID
     /// </summary>
     [SugarColumn(ColumnName = "ERPID")]
-    public decimal? Erpid { get; set; }
+    public int? Erpid { get; set; }
 
     /// <summary>
-    ///     鍗曞彿
+    ///     鍗曟嵁缂栧彿
     /// </summary>
     [SugarColumn(ColumnName = "CAA001")]
-    public string? Caa001 { get; set; }
+    public string Caa001 { get; set; }
 
     /// <summary>
-    ///     鍗曟嵁绫诲瀷 1銆佺洿鎺ュ叆搴�-鏅�氱敓浜� SCDD03_SYS2銆佺洿鎺ュ叆搴�-杩斿伐鐢熶骇 SCDD04_SYS3銆佸伐搴忔眹鎶�-鏅�氱敓浜�
-    ///     SCDD01_SYS4銆佸伐搴忔眹鎶�-杩斿伐鐢熶骇 SCDD02_SYS
+    ///     鍗曟嵁绫诲瀷(&quot;1銆佺洿鎺ュ叆搴�-鏅�氱敓浜� 2銆佺洿鎺ュ叆搴�-杩斿伐鐢熶骇 3銆佸伐搴忔眹鎶�-鏅�氱敓浜� 4銆佸伐搴忔眹鎶�-杩斿伐鐢熶骇&quot;)
     /// </summary>
     [SugarColumn(ColumnName = "CAA004")]
-    public string? Caa004 { get; set; }
+    public string Caa004 { get; set; }
 
     /// <summary>
-    ///     寮�鍗曟棩鏈�
+    ///     璁″垝涓嬭揪鏃ユ湡
     /// </summary>
     [SugarColumn(ColumnName = "CAA005")]
-    public string? Caa005 { get; set; }
+    public string Caa005 { get; set; }
 
     /// <summary>
-    ///     浜у搧缂栫爜
+    ///     浜у搧ID
     /// </summary>
     [SugarColumn(ColumnName = "CAA006")]
-    public string? Caa006 { get; set; }
+    public string Caa006 { get; set; }
 
     /// <summary>
     ///     鍗曚綅
     /// </summary>
     [SugarColumn(ColumnName = "CAA009")]
-    public string? Caa009 { get; set; }
+    public string Caa009 { get; set; }
 
     /// <summary>
     ///     棰勮寮�宸ユ椂闂�
     /// </summary>
     [SugarColumn(ColumnName = "CAA010")]
-    public string? Caa010 { get; set; }
+    public string Caa010 { get; set; }
 
     /// <summary>
     ///     棰勮瀹屽伐鏃堕棿
     /// </summary>
     [SugarColumn(ColumnName = "CAA011")]
-    public string? Caa011 { get; set; }
+    public string Caa011 { get; set; }
 
     /// <summary>
-    ///     鏁伴噺
+    ///     宸ュ崟鏁伴噺
     /// </summary>
     [SugarColumn(ColumnName = "CAA012")]
     public decimal? Caa012 { get; set; }
@@ -74,55 +72,55 @@
     ///     BOM鐗堟
     /// </summary>
     [SugarColumn(ColumnName = "CAA013")]
-    public string? Caa013 { get; set; }
+    public string Caa013 { get; set; }
 
     /// <summary>
     ///     閿�鍞鍗曞彿
     /// </summary>
     [SugarColumn(ColumnName = "CAA015")]
-    public string? Caa015 { get; set; }
+    public string Caa015 { get; set; }
 
     /// <summary>
     ///     澶囨敞
     /// </summary>
     [SugarColumn(ColumnName = "CAA016")]
-    public string? Caa016 { get; set; }
+    public string Caa016 { get; set; }
 
     /// <summary>
-    ///     宸叉帓鏁伴噺
+    ///     宸叉帓鏁伴噺锛堝純鐢級
     /// </summary>
     [SugarColumn(ColumnName = "CAA017")]
-    public decimal? Caa017 { get; set; }
+    public int? Caa017 { get; set; }
 
     /// <summary>
-    ///     ERP婧愬崟ID
+    ///     ERP鐢熶骇璁㈠崟ID
     /// </summary>
     [SugarColumn(ColumnName = "CAA018")]
-    public decimal? Caa018 { get; set; }
+    public int? Caa018 { get; set; }
 
     /// <summary>
-    ///     ERP婧愬崟琛屽彿
+    ///     ERP鐢熶骇璁㈠崟搴忓彿
     /// </summary>
     [SugarColumn(ColumnName = "CAA019")]
-    public decimal? Caa019 { get; set; }
+    public int? Caa019 { get; set; }
 
     /// <summary>
-    ///     ERP婧愬崟鍗曞彿(浠诲姟鍗曞彿)
+    ///     ERP鐢熶骇璁㈠崟鍗曞彿
     /// </summary>
     [SugarColumn(ColumnName = "CAA020")]
-    public string? Caa020 { get; set; }
+    public string Caa020 { get; set; }
 
     /// <summary>
-    ///     宸ヤ綔杞﹂棿
+    ///     鐢熶骇杞﹂棿
     /// </summary>
     [SugarColumn(ColumnName = "CAA021")]
-    public string? Caa021 { get; set; }
+    public string Caa021 { get; set; }
 
     /// <summary>
     ///     瀹℃牳鐮�
     /// </summary>
     [SugarColumn(ColumnName = "FSTATUS")]
-    public decimal? Fstatus { get; set; }
+    public int? Fstatus { get; set; }
 
     /// <summary>
     ///     瀹℃牳鏃ユ湡
@@ -134,192 +132,286 @@
     ///     瀹℃牳浜�
     /// </summary>
     [SugarColumn(ColumnName = "CHECK_USER")]
-    public string? CheckUser { get; set; }
+    public string CheckUser { get; set; }
 
     /// <summary>
-    ///     鏈帓鏁伴噺
+    ///     鏈帓鏁伴噺锛堝純鐢級
     /// </summary>
     [SugarColumn(ColumnName = "CAA022")]
-    public decimal? Caa022 { get; set; }
+    public int? Caa022 { get; set; }
 
     /// <summary>
-    ///     鐘舵�� 瀹屽伐锛屾湭瀹屽伐
+    ///     涓氬姟鐘舵��(&quot;1锛岃鍒掞紝2銆佽鍒掔‘璁� 2銆佷笅杈� 4銆佸紑宸� 5銆佸畬宸� 6銆佺粨妗堬紝7銆佺粨绠�&quot;)
     /// </summary>
     [SugarColumn(ColumnName = "CAA023")]
-    public string? Caa023 { get; set; }
+    public string Caa023 { get; set; }
 
     /// <summary>
     ///     宸插叆搴撴暟閲�
     /// </summary>
     [SugarColumn(ColumnName = "CAA024")]
-    public decimal? Caa024 { get; set; }
+    public int? Caa024 { get; set; }
 
     /// <summary>
     ///     宸ヨ壓璺嚎
     /// </summary>
     [SugarColumn(ColumnName = "ROUTING_ID")]
-    public string? RoutingId { get; set; }
+    public string RoutingId { get; set; }
 
     /// <summary>
     ///     浜х嚎
     /// </summary>
     [SugarColumn(ColumnName = "WORK_SHOP_ID")]
-    public string? WorkShopId { get; set; }
+    public string WorkShopId { get; set; }
 
     /// <summary>
     ///     浠撳簱
     /// </summary>
     [SugarColumn(ColumnName = "DEPOT_CODE")]
-    public string? DepotCode { get; set; }
+    public string DepotCode { get; set; }
 
     /// <summary>
     ///     鍗曟嵁鏃ユ湡
     /// </summary>
     [SugarColumn(ColumnName = "CREATE_DATE")]
-    public string? CreateDate { get; set; }
+    public string CreateDate { get; set; }
 
     /// <summary>
     ///     璁″垝缁�
     /// </summary>
     [SugarColumn(ColumnName = "WORK_GROUP_ID")]
-    public string? WorkGroupId { get; set; }
+    public string WorkGroupId { get; set; }
 
     /// <summary>
     ///     璁″垝鍛�
     /// </summary>
     [SugarColumn(ColumnName = "PLAN_ID")]
-    public string? PlanId { get; set; }
+    public string PlanId { get; set; }
 
     /// <summary>
     ///     鍏ュ簱涓婇檺
     /// </summary>
     [SugarColumn(ColumnName = "STOCK_INLIMITH")]
-    public string? StockInlimith { get; set; }
+    public string StockInlimith { get; set; }
 
     /// <summary>
     ///     鍏ュ簱涓嬮檺
     /// </summary>
     [SugarColumn(ColumnName = "STOCK_INLIMITL")]
-    public string? StockInlimitl { get; set; }
+    public string StockInlimitl { get; set; }
 
     /// <summary>
-    ///     璁″垝璺熻釜鍙�
+    ///     涓昏溅闂磋皟搴﹀崟
     /// </summary>
     [SugarColumn(ColumnName = "MTONO")]
-    public string? Mtono { get; set; }
+    public string Mtono { get; set; }
 
     /// <summary>
-    ///     鎵瑰彿
+    ///     鎵规
     /// </summary>
     [SugarColumn(ColumnName = "LOT")]
-    public string? Lot { get; set; }
+    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 = "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; }
+    public string SaleOrderEntryseq { get; set; }
 
     /// <summary>
-    ///     缁撴浜�
+    ///     寮哄埗鍏抽棴浜�
     /// </summary>
     [SugarColumn(ColumnName = "FORCE_CLOSERID")]
-    public string? ForceCloserid { get; set; }
+    public string ForceCloserid { get; set; }
 
     /// <summary>
-    ///     缁撴绫诲瀷
+    ///     鍏抽棴绫诲瀷
     /// </summary>
     [SugarColumn(ColumnName = "CLOSE_TYPE")]
-    public string? CloseType { get; set; }
+    public string CloseType { get; set; }
+
+    /// <summary>
+    ///     鍒嗗崟鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "SRC_SPLIT_BILLNO")]
+    public string SrcSplitBillno { get; set; }
+
+    /// <summary>
+    ///     鏄惁绠℃帶
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_SCZZ")]
+    public int? ErpSczz { get; set; }
+
+    /// <summary>
+    ///     鏄惁濮旀墭
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_WTZZ")]
+    public int? ErpWtzz { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "MAIN_PRODUCT_NO")]
+    public string MainProductNo { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")]
+    public int? MainProductQty { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")]
+    public string CustomerItemNumber { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")]
+    public string PackingListNumber { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "CUSTOMER_NAME")]
+    public string CustomerName { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "CUSTOMER")]
+    public string Customer { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "TYPE")]
+    public string Type { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "JA_BS")]
+    public string JaBs { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "JA_TIME")]
+    public DateTime? JaTime { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "YP_NUM")]
+    public int? YpNum { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "CAA011_1")]
+    public string Caa0111 { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_GYZZ")]
+    public int? ErpGyzz { get; set; }
+
+    /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_FLZZ")]
+    public int? ErpFlzz { get; set; }
+
+    /// <summary>
+    ///     鏄惁鍏ュ簱
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_SLZZ")]
+    public int? ErpSlzz { get; set; }
+
+    /// <summary>
+    ///     鏄惁閫�搴�
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_RKZZ")]
+    public int? ErpRkzz { get; set; }
+
+    /// <summary>
+    ///     鏄惁鎹㈣揣
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_RKHZ")]
+    public int? ErpRkhz { get; set; }
+
+    /// <summary>
+    ///     鏄惁瀵勫敭
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_JJDS")]
+    public int? ErpJjds { get; set; }
+
+    /// <summary>
+    ///     鏄惁鎸夋
+    /// </summary>
+    [SugarColumn(ColumnName = "ERP_BZDS")]
+    public int? ErpBzds { get; set; }
+
+    /// <summary>
+    ///     鏄惁鏂板缓
+    /// </summary>
+    [SugarColumn(ColumnName = "CAA025")]
+    public int? Caa025 { get; set; }
+
+    /// <summary>
+    ///     閲囪喘璁㈠崟鍙�
+    /// </summary>
+    [SugarColumn(ColumnName = "FPURORDERNO")]
+    public string Fpurorderno { get; set; }
+
+    /// <summary>
+    ///     閲囪喘璁㈠崟琛屽彿
+    /// </summary>
+    [SugarColumn(ColumnName = "FPURORDERENTRYSEQ")]
+    public string Fpurorderentryseq { get; set; }
+
+    /// <summary>
+    ///     澶囨敞锛堣〃浣擄級
+    /// </summary>
+    [SugarColumn(ColumnName = "Btbz")]
+    public string Btbz { get; set; }
 
     /// <summary>
     ///     婧愭媶鍒嗚鍗曠紪鍙�
     /// </summary>
-    [SugarColumn(ColumnName = "SRC_SPLIT_BILLNO")]
-    public string? SrcSplitBillno { get; set; }
-
+    [SugarColumn(ColumnName = "fmoentryid")]
+    public string Fmoentryid { get; set; }
 
     /// <summary>
-    ///     鐢熶骇缁勭粐ID
+    ///     鎺掍骇绾垮埆
     /// </summary>
-    [SugarColumn(ColumnName = "ERP_SCZZ")]
-    public string? EerSczz { get; set; }
-
-    /// <summary>
-    ///     濮旀墭缁勭粐ID
-    /// </summary>
-    [SugarColumn(ColumnName = "ERP_WTZZ")]
-    public string? EerWtzz { get; set; }
-
-    /// <summary>
-    ///     涓讳骇鍝佺紪鐮�
-    /// </summary>
-    [SugarColumn(ColumnName = "MAIN_PRODUCT_NO")]
-    public string? MainProductNo { get; set; }
-
-    /// <summary>
-    ///     涓讳骇鍝佺敓浜ф暟閲�
-    /// </summary>
-    [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")]
-    public string? MainProductQty { get; set; }
-
-    /// <summary>
-    ///     瀹㈡埛璐у彿
-    /// </summary>
-    [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")]
-    public string? CustomerItemNumber { get; set; }
-
-    /// <summary>
-    ///     鍖呰鍗曞彿
-    /// </summary>
-    [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")]
-    public string? PackingListNumber { get; set; }
-
-    /// <summary>
-    ///     瀹㈡埛鍚嶇О
-    /// </summary>
-    [SugarColumn(ColumnName = "CUSTOMER_NAME")]
-    public string? CustomerName { get; set; }
-
-    /// <summary>
-    ///     瀹㈡埛
-    /// </summary>
-    [SugarColumn(ColumnName = "CUSTOMER")]
-    public string? Customer { get; set; }
+    [SugarColumn(ColumnName = "prod_line")]
+    public string ProdLine { get; set; }
 }
\ No newline at end of file

--
Gitblit v1.9.3