From 7ee2e58c300374a15c212f9145ba9d762d64e0e6 Mon Sep 17 00:00:00 2001
From: fcx <2246384483@qq.com>
Date: 星期六, 20 十二月 2025 15:58:11 +0800
Subject: [PATCH] 1.新增MES_PROJECT.cs
---
StandardPda/MES.Service/Modes/Womcab.cs | 192 ++++++++++++++++++++++++++++++++---------------
1 files changed, 129 insertions(+), 63 deletions(-)
diff --git a/StandardPda/MES.Service/Modes/Womcab.cs b/StandardPda/MES.Service/Modes/Womcab.cs
index c5aae98..cef4c64 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,179 @@
/// 鍥哄畾鎹熻��
/// </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>
+ /// 瀛愰」绫诲瀷锛�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; }
+ [SugarColumn(ColumnName = "FREPLACEGROUP", ColumnDataType = "NUMBER(5,2)")]
+ public decimal? FreplaceGroup { 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; }
-
-
- /////----濮斿鏂板
+ [SugarColumn(ColumnName = "MUST_QTY", ColumnDataType = "NUMBER(18,3)")]
+ public decimal? MustQty { get; set; }
/// <summary>
- /// 鏄惁鍙戞崯鑰� -- 濮斿鏂板
+ /// 鐢ㄦ枡娓呭崟鐘舵�侊紙A-鍒涘缓锛孊-瀹℃牳涓紝C-宸插鏍革紝D-閲嶆柊瀹℃牳锛孼-鏆傚瓨锛�
/// </summary>
- [SugarColumn(ColumnName = "FISGETSCRAP")]
- public string? Fisgetscrap { get; set; }
+ [SugarColumn(ColumnName = "TYPEB", Length = 2)]
+ public string? TypeB { get; set; }
/// <summary>
- /// 鏄惁鍏抽敭浠� -- 濮斿鏂板
+ /// 椤圭洰
/// </summary>
- [SugarColumn(ColumnName = "FISKEYCOMPONENT")]
- public string? Fiskeycomponent { get; set; }
+ [SugarColumn(ColumnName = "PROJECT")]
+ public string? Project { get; set; }
/// <summary>
- /// 鎷ㄥ嚭缁勭粐 -- 濮斿鏂板
+ /// BOM闇�姹傞噺
/// </summary>
- [SugarColumn(ColumnName = "FSRCTRANSORGID")]
- public string? Fsrctransorgid { get; set; }
+ [SugarColumn(ColumnName = "BOMREQQTY")]
+ public decimal? Bomreqqty { get; set; }
/// <summary>
- /// 鎷ㄥ嚭浠撳簱 -- 濮斿鏂板
+ /// 瓒呴绫诲瀷
/// </summary>
- [SugarColumn(ColumnName = "FSRCTRANSSTOCKID")]
- public string? Fsrctransstockid { get; set; }
+ [SugarColumn(ColumnName = "MATERIALTYPE")]
+ public string? Materialtype { get; set; }
/// <summary>
- /// 搴撳瓨鐘舵�� -- 濮斿鏂板
+ /// 瓒呴鍙戞枡
/// </summary>
- [SugarColumn(ColumnName = "FSTOCKSTATUSID")]
- public string? Fstockstatusid { get; set; }
+ [SugarColumn(ColumnName = "ISOVERISSUE")]
+ public decimal? IsOverIssue { get; set; }
/// <summary>
- /// 闇�姹傛棩鏈� -- 濮斿鏂板
+ /// 瓒呴姣斾緥
/// </summary>
- [SugarColumn(ColumnName = "FNEEDDATE")]
- public DateTime? Fneeddate { get; set; }
+ [SugarColumn(ColumnName = "STANDARD_MATERIALSCALE")]
+ public decimal? StandardMaterialscale { get; set; }
/// <summary>
- /// 棰勭暀绫诲瀷 -- 濮斿鏂板
+ /// 鍥哄畾瓒呴閲�
/// </summary>
- [SugarColumn(ColumnName = "FRESERVETYPE")]
- public string? Freservetype { get; set; }
+ [SugarColumn(ColumnName = "FIXEDMATERIALNUM")]
+ public decimal? Fixedmaterialnum { get; set; }
/// <summary>
- /// 鐢ㄦ枡娓呭崟澶囨敞 -- 濮斿鏂板
+ /// 鏇夸唬鏂�
/// </summary>
- [SugarColumn(ColumnName = "FMEMO")]
- public string? Fmemo { get; set; }
+ [SugarColumn(ColumnName = "ISSUBSTITUTE")]
+ public decimal? IsSubstitute { get; set; }
/// <summary>
- /// ERP鐢熶骇璁㈠崟鍒嗗綍鍐呯爜 -- 濮斿鏂板
+ /// 琚浛浠ｆ枡鍝�
/// </summary>
- [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
- public string? ErpProductionEntryCode { get; set; }
+ [SugarColumn(ColumnName = "SUBSTITUTEDITEM")]
+ public decimal? Substituteditem { get; set; }
+
+ /// <summary>
+ /// 鍙戞枡鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "ISSUEUOM")]
+ public decimal? Issueuom { get; set; }
+
+ /// <summary>
+ /// 姣忚閰嶄欢鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "QPA")]
+ public decimal? Qpa { get; set; }
+
+ /// <summary>
+ /// 鎹熻�楃被鍨�
+ /// </summary>
+ [SugarColumn(ColumnName = "SCRAPTYPE")]
+ public string? Scraptype { get; set; }
+
+ /// <summary>
+ /// 鍊掑啿鏃舵満
+ /// </summary>
+ [SugarColumn(ColumnName = "BFOPOPPORTUNITY")]
+ public string? Bfopportunity { get; set; }
+
+ /// <summary>
+ /// 渚涘簲鍦扮偣
+ /// </summary>
+ [SugarColumn(ColumnName = "SUPPLYWH")]
+ public string? Supplywh { get; set; }
+
+ /// <summary>
+ /// 璁㈠崟寮�宸ラ綈濂楁鏌�
+ /// </summary>
+ [SugarColumn(ColumnName = "MOCOMPLETESETCHECK")]
+ public decimal? Mocompletesetcheck { get; set; }
+
+ /// <summary>
+ /// 璁㈠崟瀹屽伐榻愬妫�鏌�
+ /// </summary>
+ [SugarColumn(ColumnName = "MOSTARTSETCHECK")]
+ public decimal? Mostartsetcheck { get; set; }
+
+ /// <summary>
+ /// 榻愬鍙戞枡
+ /// </summary>
+ [SugarColumn(ColumnName = "ISCOUPLEISSUE")]
+ public decimal? Iscoupleissue { get; set; }
+
+ /// <summary>
+ /// 琛ㄨ澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "MEMO")]
+ public string? FDescription { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3