From f998563858724f373ea1ff112bdf781a5a46ee8a Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期四, 05 六月 2025 21:13:14 +0800
Subject: [PATCH] 代码提交
---
StandardPda/MES.Service/Modes/Womcab.cs | 152 +++++++++++++++++++-------------------------------
1 files changed, 59 insertions(+), 93 deletions(-)
diff --git a/StandardPda/MES.Service/Modes/Womcab.cs b/StandardPda/MES.Service/Modes/Womcab.cs
index c5aae98..e8cac3c 100644
--- a/StandardPda/MES.Service/Modes/Womcab.cs
+++ b/StandardPda/MES.Service/Modes/Womcab.cs
@@ -3,7 +3,7 @@
namespace MES.Service.Modes;
/// <summary>
-/// 宸ュ崟瀛愯〃
+/// 浠诲姟鍗曠墿鏂欒〃
/// </summary>
[SugarTable("WOMCAB")]
public class Womcab
@@ -11,18 +11,17 @@
/// <summary>
/// 鑷鍒�
/// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
- OracleSequenceName = "SEQ_CAB")]
- public decimal? Id { get; set; }
+ [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_CAB", IsPrimaryKey = true)]
+ public decimal Id { get; set; }
/// <summary>
- /// ERPID
+ /// 鐢熶骇鐢ㄦ枡娓呭崟琛屽唴鐮�
/// </summary>
[SugarColumn(ColumnName = "ERPID")]
public decimal? Erpid { get; set; }
/// <summary>
- /// 鍗曞彿
+ /// 宸ュ崟鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "CAB001")]
public string? Cab001 { get; set; }
@@ -73,16 +72,16 @@
/// 鏄惁鏇挎枡
/// </summary>
[SugarColumn(ColumnName = "CAB014")]
- public string? Cab014 { get; set; }
+ public decimal? Cab014 { get; set; }
/// <summary>
- /// PID
+ /// 鐢熶骇璁㈠崟琛屽唴鐮�
/// </summary>
[SugarColumn(ColumnName = "PID")]
public decimal? Pid { get; set; }
/// <summary>
- /// ERP澶碔D
+ /// 鐢熶骇璁㈠崟琛屽唴鐮�
/// </summary>
[SugarColumn(ColumnName = "EID")]
public decimal? Eid { get; set; }
@@ -136,7 +135,7 @@
public string? IssueType { get; set; }
/// <summary>
- /// 渚涘簲绫诲瀷
+ /// 渚涘簲绫诲瀷 C閲囪喘 Z鑷埗 W濮斿
/// </summary>
[SugarColumn(ColumnName = "SUPPLY_TYPE")]
public string? SupplyType { get; set; }
@@ -157,112 +156,79 @@
/// 鍥哄畾鎹熻��
/// </summary>
[SugarColumn(ColumnName = "SCRAPQTY")]
- public decimal? SCRAPQTY { get; set; }
+ public decimal? Scrapqty { get; set; }
/// <summary>
/// 鍙樺姩鎹熻�楃巼
/// </summary>
[SugarColumn(ColumnName = "SCRAPRATE")]
- public decimal? SCRAPRATE { get; set; }
-
+ public decimal? Scraprate { get; set; }
/// <summary>
- /// 搴斿彂鏁伴噺
+ /// 閿�鍞鍗曞彿
/// </summary>
- [SugarColumn(ColumnName = "Must_Qty")]
- public decimal? MustQty { get; set; }
+ [SugarColumn(ColumnName = "SALES_ORDER")]
+ public string? SalesOrder { get; set; }
/// <summary>
- /// 椤规鍙�
+ /// 闇�姹傚崟鎹�
/// </summary>
- [SugarColumn(ColumnName = "FREPLACEGROUP")]
- public int? Freplacegroup { get; set; }
+ [SugarColumn(ColumnName = "F_WWC_TEXT1")]
+ public string? FWwcText1 { get; set; }
/// <summary>
- /// 浣跨敤姣斾緥锛�%锛�
+ /// 璁″垝瀹屽伐鏃ユ湡
/// </summary>
- [SugarColumn(ColumnName = "USE_RATE")]
- public decimal? UseRate { get; set; }
+ [SugarColumn(ColumnName = "F_WWC_DATE")]
+ public DateTime? FWwcDate { get; set; }
+
+ /// <summary>
+ /// 鏃х墿鏂欑紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_BASEPROPERTY")]
+ public string? FWwcBaseproperty { get; set; }
+
+ /// <summary>
+ /// 浣跨敤姣斾緥
+ /// </summary>
+ [SugarColumn(ColumnName = "FUSERATE")]
+ public decimal? Fuserate { get; set; }
/// <summary>
/// 瀛愰」绫诲瀷 1鏍囧噯浠� 2杩旇繕浠� 3鏇夸唬浠�
/// </summary>
- [SugarColumn(ColumnName = "MATERIAL_TYPE")]
+ [SugarColumn(ColumnName = "FMATERIALTYPE")]
+ public decimal? Fmaterialtype { get; set; }
+
+
+ /// <summary>
+ /// 搴斿彂鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "MUST_QTY", ColumnDataType = "NUMBER(18,3)")]
+ public decimal? MustQty { get; set; }
+
+ /// <summary>
+ /// 鐢ㄦ枡娓呭崟鐘舵�侊紙A-鍒涘缓锛孊-瀹℃牳涓紝C-宸插鏍革紝D-閲嶆柊瀹℃牳锛孼-鏆傚瓨锛�
+ /// </summary>
+ [SugarColumn(ColumnName = "TYPEB", Length = 2)]
+ public string? TypeB { get; set; }
+
+
+ /// <summary>
+ /// 瀛愰」绫诲瀷锛�1-鏍囧噯浠� 2-杩旇繕浠� 3-鏇夸唬浠讹級
+ /// </summary>
+ [SugarColumn(ColumnName = "MATERIAL_TYPE", Length = 1)]
public string? MaterialType { get; set; }
/// <summary>
- /// A锛屽垱寤� B锛屽鏍镐腑 C锛屽凡瀹℃牳 D锛岄噸鏂板鏍� Z锛屾殏瀛�
+ /// 浣跨敤姣斾緥锛�%锛�
/// </summary>
- [SugarColumn(ColumnName = "TYPEB")]
- public string? Typeb { get; set; }
-
+ [SugarColumn(ColumnName = "USE_RATE", ColumnDataType = "NUMBER(5,2)")]
+ public decimal? UseRate { get; set; }
/// <summary>
- /// A锛屽垱寤� B锛屽鏍镐腑 C锛屽凡瀹℃牳 D锛岄噸鏂板鏍� Z锛屾殏瀛�
+ /// 椤规
/// </summary>
- [SugarColumn(ColumnName = "WR_F_XIFG_BASE_QTR")]
- public string? WR_F_XIFG_Base_qtr { get; set; }
-
- /// <summary>
- /// A锛屽垱寤� B锛屽鏍镐腑 C锛屽凡瀹℃牳 D锛岄噸鏂板鏍� Z锛屾殏瀛�
- /// </summary>
- [SugarColumn(ColumnName = "WR_F_XIFG_BASE_83G")]
- public string? WR_F_XIFG_Base_83g { get; set; }
-
-
- /////----濮斿鏂板
-
- /// <summary>
- /// 鏄惁鍙戞崯鑰� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FISGETSCRAP")]
- public string? Fisgetscrap { get; set; }
-
- /// <summary>
- /// 鏄惁鍏抽敭浠� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FISKEYCOMPONENT")]
- public string? Fiskeycomponent { get; set; }
-
- /// <summary>
- /// 鎷ㄥ嚭缁勭粐 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FSRCTRANSORGID")]
- public string? Fsrctransorgid { get; set; }
-
- /// <summary>
- /// 鎷ㄥ嚭浠撳簱 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FSRCTRANSSTOCKID")]
- public string? Fsrctransstockid { get; set; }
-
- /// <summary>
- /// 搴撳瓨鐘舵�� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FSTOCKSTATUSID")]
- public string? Fstockstatusid { get; set; }
-
- /// <summary>
- /// 闇�姹傛棩鏈� -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FNEEDDATE")]
- public DateTime? Fneeddate { get; set; }
-
- /// <summary>
- /// 棰勭暀绫诲瀷 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FRESERVETYPE")]
- public string? Freservetype { get; set; }
-
- /// <summary>
- /// 鐢ㄦ枡娓呭崟澶囨敞 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "FMEMO")]
- public string? Fmemo { get; set; }
-
- /// <summary>
- /// ERP鐢熶骇璁㈠崟鍒嗗綍鍐呯爜 -- 濮斿鏂板
- /// </summary>
- [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
- public string? ErpProductionEntryCode { get; set; }
+ [SugarColumn(ColumnName = "FREPLACEGROUP", ColumnDataType = "NUMBER(5,2)")]
+ public decimal? FreplaceGroup { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3