From a619299816f2f632c7c6ba3a1bb869e2c212797d Mon Sep 17 00:00:00 2001
From: fcx <2246384483@qq.com>
Date: 星期五, 19 十二月 2025 14:12:33 +0800
Subject: [PATCH] 对添加巡检单物料编码进行去重
---
StandardPda/MES.Service/Modes/Womcab.cs | 136 ++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 134 insertions(+), 2 deletions(-)
diff --git a/StandardPda/MES.Service/Modes/Womcab.cs b/StandardPda/MES.Service/Modes/Womcab.cs
index cb15d19..cef4c64 100644
--- a/StandardPda/MES.Service/Modes/Womcab.cs
+++ b/StandardPda/MES.Service/Modes/Womcab.cs
@@ -11,7 +11,7 @@
/// <summary>
/// 鑷鍒�
/// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_CAB", IsPrimaryKey = true)]
public decimal Id { get; set; }
/// <summary>
@@ -186,7 +186,7 @@
/// 鏃х墿鏂欑紪鐮�
/// </summary>
[SugarColumn(ColumnName = "F_WWC_BASEPROPERTY")]
- public string? FWwcBaseproperty { get; set; }
+ public string? FwwcBaseproperty { get; set; }
/// <summary>
/// 浣跨敤姣斾緥
@@ -199,4 +199,136 @@
/// </summary>
[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>
+ /// 浣跨敤姣斾緥锛�%锛�
+ /// </summary>
+ [SugarColumn(ColumnName = "USE_RATE", ColumnDataType = "NUMBER(5,2)")]
+ public decimal? UseRate { get; set; }
+
+ /// <summary>
+ /// 椤规
+ /// </summary>
+ [SugarColumn(ColumnName = "FREPLACEGROUP", ColumnDataType = "NUMBER(5,2)")]
+ public decimal? FreplaceGroup { 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>
+ /// 椤圭洰
+ /// </summary>
+ [SugarColumn(ColumnName = "PROJECT")]
+ public string? Project { get; set; }
+
+ /// <summary>
+ /// BOM闇�姹傞噺
+ /// </summary>
+ [SugarColumn(ColumnName = "BOMREQQTY")]
+ public decimal? Bomreqqty { get; set; }
+
+ /// <summary>
+ /// 瓒呴绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "MATERIALTYPE")]
+ public string? Materialtype { get; set; }
+
+ /// <summary>
+ /// 瓒呴鍙戞枡
+ /// </summary>
+ [SugarColumn(ColumnName = "ISOVERISSUE")]
+ public decimal? IsOverIssue { get; set; }
+
+ /// <summary>
+ /// 瓒呴姣斾緥
+ /// </summary>
+ [SugarColumn(ColumnName = "STANDARD_MATERIALSCALE")]
+ public decimal? StandardMaterialscale { get; set; }
+
+ /// <summary>
+ /// 鍥哄畾瓒呴閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "FIXEDMATERIALNUM")]
+ public decimal? Fixedmaterialnum { get; set; }
+
+ /// <summary>
+ /// 鏇夸唬鏂�
+ /// </summary>
+ [SugarColumn(ColumnName = "ISSUBSTITUTE")]
+ public decimal? IsSubstitute { get; set; }
+
+ /// <summary>
+ /// 琚浛浠ｆ枡鍝�
+ /// </summary>
+ [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