From 1653a432611f93b2595efbd335ae2d83b7e42f5c Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 14 二月 2025 08:25:39 +0800
Subject: [PATCH] 采购订单的项目，供应商，物料增加U9id的转换
---
StandardPda/MES.Service/Modes/MesItems.cs | 234 ++++++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 179 insertions(+), 55 deletions(-)
diff --git a/StandardPda/MES.Service/Modes/MesItems.cs b/StandardPda/MES.Service/Modes/MesItems.cs
index d830cb6..20bb6ab 100644
--- a/StandardPda/MES.Service/Modes/MesItems.cs
+++ b/StandardPda/MES.Service/Modes/MesItems.cs
@@ -27,7 +27,7 @@
public string? Company { get; set; }
/// <summary>
- /// 鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿
+ /// 鐗╂枡缂栫爜
/// </summary>
[SugarColumn(ColumnName = "ITEM_NO")]
public string? ItemNo { get; set; }
@@ -111,6 +111,12 @@
public double? Lowlimit { get; set; }
/// <summary>
+ /// 瀹夊叏搴撳瓨閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "Safe_Stock")]
+ public double? SafeStock { get; set; }
+
+ /// <summary>
/// 鏈�澶у簱瀛�
/// </summary>
[SugarColumn(ColumnName = "HIGHLIMIT")]
@@ -139,12 +145,6 @@
/// </summary>
[SugarColumn(ColumnName = "STOREUNIT")]
public string? Storeunit { get; set; }
-
- /// <summary>
- /// 鐢熶骇鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "PRODUCTUNIT")]
- public string? Productunit { get; set; }
/// <summary>
/// 鐗╂枡ID
@@ -210,7 +210,7 @@
/// 鍚敤鎵瑰彿绠＄悊
/// </summary>
[SugarColumn(ColumnName = "FISBATCHMANAGE")]
- public decimal? Fisbatchmanage { get; set; }
+ public string? Fisbatchmanage { get; set; }
/// <summary>
/// 閲囪喘鍗曚綅
@@ -222,13 +222,13 @@
/// 鍒涘缓缁勭粐
/// </summary>
[SugarColumn(ColumnName = "CREATE_ORG")]
- public decimal CreateOrg { get; set; }
+ public decimal? CreateOrg { get; set; }
/// <summary>
/// 浣跨敤缁勭粐
/// </summary>
[SugarColumn(ColumnName = "USE_ORG")]
- public decimal UseOrg { get; set; }
+ public string? UseOrg { get; set; }
/// <summary>
/// 鎹熻�楃巼
@@ -255,7 +255,11 @@
public string? ProductionWorkshop { get; set; }
/// <summary>
- /// 鐗╂枡灞炴��
+ /// 鐗╂枡灞炴�� 0=妯″瀷锛�1=鎸夎鍗曟嫞璐э紝2=鎸夎鍗曡閰嶏紝3=鍙�夌被锛�4=濮斿鍔犲伐浠讹紝
+ /// 5=宸ュ簭濮斿浠讹紝6=铏氭嫙锛�7=璁″垝锛�8=绯诲垪锛�9=閲囪喘浠讹紝10=鍒堕�犱欢锛�
+ /// 11=鏈�缁堣閰嶄欢锛�12=濂椾欢锛�13=宸ヨ壓锛�14=浣庡�兼槗鑰楀搧锛�15=鍟嗗搧锛�
+ /// 16=鏉傞」鏂欏搧锛�17=鏈嶅姟锛�18=璧勪骇锛�19=澶囦欢锛�20=閰嶆柟锛�
+ /// 21=閲嶅锛�22=璐圭敤鎬ф枡鍝�
/// </summary>
[SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
public string? MaterialProperti { get; set; }
@@ -320,82 +324,202 @@
[SugarColumn(ColumnName = "COLOR_NAME")]
public string? ColorName { get; set; }
- [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
+ /// <summary>
+ /// 璁惧
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_TEXT8")]
+ public string? FWwcText8 { get; set; }
/// <summary>
- /// 鎺ュ彛瀛楁璋冩暣锛氭爣鍑嗙増鎺ュ彛鏂板瀛楁銆�
+ /// 鍔熺巼
/// </summary>
- /// <remarks>
- /// 淇敼浜猴細
- /// <姹犲崡楠�>
- /// 淇敼鏃ユ湡锛�<2024-12-31>
- /// 淇敼璇存槑锛�
- /// - 鍘熶唬鐮侊細绌�
- /// - 鏂板锛�
- /// </remarks>
- /// <summary>
- /// 鏃х墿鏂欑紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "FOLDNUMBER")]
- public string? FOLDNUMBER { get; set; }
+ [SugarColumn(ColumnName = "F_WWC_DECIMAL")]
+ public string? FWwcDecimal { get; set; }
/// <summary>
- /// 鏈�灏忓簱瀛�
+ /// 鍗曞皬鏃朵骇鑳�
/// </summary>
- [SugarColumn(ColumnName = "FMINSTOCK")]
- public double? FMINSTOCK { get; set; }
+ [SugarColumn(ColumnName = "F_WWC_DECIMAL1")]
+ public string? FWwcDecimal1 { get; set; }
/// <summary>
- /// 鍏ュ簱娆犳敹姣斾緥(%)
+ /// 浜烘暟
/// </summary>
- [SugarColumn(ColumnName = "FFINISHRECEIPTSHORTRATE")]
- public decimal? FFINISHRECEIPTSHORTRATE { get; set; }
+ [SugarColumn(ColumnName = "F_WWC_DECIMAL2")]
+ public string? FWwcDecimal2 { get; set; }
/// <summary>
- /// 榛樿渚涘簲鍟�
+ /// 浜哄伐灏忔椂宸ヨ祫
/// </summary>
- [SugarColumn(ColumnName = "FDEFAULTVENDOR")]
- public string? FDEFAULTVENDOR { get; set; }
+ [SugarColumn(ColumnName = "F_WWC_DECIMAL3")]
+ public string? FWwcDecimal3 { get; set; }
/// <summary>
- /// 鏁版嵁鐘舵��(Z=鏆傚瓨,A=鍒涘缓,B=瀹℃牳涓�,C=宸插鏍�,D=閲嶆柊瀹℃牳)
+ /// 浜哄伐瀹氶
/// </summary>
- [SugarColumn(ColumnName = "FDOCUMENTSTATUS")]
- public string? FDOCUMENTSTATUS { get; set; }
+ [SugarColumn(ColumnName = "F_WWC_DECIMAL4")]
+ public string? FWwcDecimal4 { get; set; }
/// <summary>
- /// 鍒堕�犵瓥鐣�
+ /// 鏍囧噯浜ц兘
/// </summary>
- [SugarColumn(ColumnName = "FMFGPOLICYID")]
- public string? FMFGPOLICYID { get; set; }
+ [SugarColumn(ColumnName = "FBCN")]
+ public string? Fbcn { get; set; }
/// <summary>
- /// 瀛愰」鍗曚綅
+ /// 閽㈢綉
/// </summary>
- [SugarColumn(ColumnName = "FBOMUNITID")]
- public string? FBOMUNITID { get; set; }
+ [SugarColumn(ColumnName = "FGW")]
+ public string? Fgw { get; set; }
/// <summary>
- /// 鏄惁鍏抽敭浠�
+ /// 娌诲叿
/// </summary>
- [SugarColumn(ColumnName = "FISKITTING")]
- public string? FISKITTING { get; set; }
+ [SugarColumn(ColumnName = "FYJ")]
+ public string? Fyj { get; set; }
/// <summary>
- /// 鍙负鑱斿壇浜у搧
+ /// 璁惧
/// </summary>
- [SugarColumn(ColumnName = "FISCOBY")]
- public string? FISCOBY { get; set; }
+ [SugarColumn(ColumnName = "FSB")]
+ public string? Fsb { get; set; }
/// <summary>
- /// 瓒呭彂鎺у埗鏂瑰紡
+ /// 鍥惧彿
/// </summary>
- [SugarColumn(ColumnName = "FOVERCONTROLMODE")]
- public string? FOVERCONTROLMODE { get; set; }
+ [SugarColumn(ColumnName = "F_WWC_TEXT1")]
+ public string? FWwcText1 { get; set; }
/// <summary>
/// 妯″叿缂栧彿
/// </summary>
- [SugarColumn(ColumnName = "F_MJBH")]
- public string? F_MJBH { get; set; }
+ [SugarColumn(ColumnName = "F_WWC_TEXT2")]
+ public string? FWwcText2 { get; set; }
+
+ /// <summary>
+ /// 妯″叿鍑烘暟
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_TEXT3")]
+ public string? FWwcText3 { get; set; }
+
+ /// <summary>
+ /// 娉ㄥ鍛ㄦ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_TEXT4")]
+ public string? FWwcText4 { get; set; }
+
+ /// <summary>
+ /// 鍗曞弻鑹�
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_TEXT5")]
+ public string? FWwcText5 { get; set; }
+
+ /// <summary>
+ /// 娉ㄥ浠跺惃浣�
+ /// </summary>
+ [SugarColumn(ColumnName = "F_WWC_TEXT6")]
+ public string? FWwcText6 { get; set; }
+
+ /// <summary>
+ /// 澶栭儴鏂欏彿
+ /// </summary>
+ [SugarColumn(ColumnName = "CATALOG_NO")]
+ public string? CatalogNo { get; set; }
+
+
+ /// <summary>
+ /// 棰嗘枡鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "MATERIAL_OUT_UOMID")]
+ public string? MaterialOutUomid { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇閮ㄩ棬
+ /// </summary>
+ [SugarColumn(ColumnName = "PUB_DESC_SEG38")]
+ public string? PubDescSeg38 { get; set; }
+
+ /// <summary>
+ /// 椤圭洰锛堢爺鍙戯級
+ /// </summary>
+ [SugarColumn(ColumnName = "DESCRIPTION")]
+ public string? Description { get; set; }
+
+ /// <summary>
+ /// 椤圭洰锛堟姤琛級
+ /// </summary>
+ [SugarColumn(ColumnName = "PRIVATE_DESC_SEG4")]
+ public string? PrivateDescSeg4 { get; set; }
+
+ /// <summary>
+ /// 鎶ヨ〃椤圭洰锛堟眹鎬伙級
+ /// </summary>
+ [SugarColumn(ColumnName = "PRIVATE_DESC_SEG9")]
+ public string? PrivateDescSeg9 { get; set; }
+
+ /// <summary>
+ /// 鍙屾暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_DUAL_QUANTITY")]
+ public string? IsDualQuantity { get; set; }
+
+ /// <summary>
+ /// 鍙屽崟浣�
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_DUAL_UOM")]
+ public string? IsDualUom { get; set; }
+
+ /// <summary>
+ /// 澶氬崟浣�
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_MULTY_UOM")]
+ public string? IsMultyUom { get; set; }
+
+ /// <summary>
+ /// 鍥哄畾杞崲鐜�
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_VAR_RATIO")]
+ public string? IsVarRatio { get; set; }
+
+ /// <summary>
+ /// 杞崲鐜囩瓥鐣�
+ /// </summary>
+ [SugarColumn(ColumnName = "CONVER_RATIO_RULE")]
+ public string? ConverRatioRule { get; set; }
+
+ /// <summary>
+ /// 鏍囧噯搴撳懆
+ /// </summary>
+ [SugarColumn(ColumnName = "PRIVATE_DESC_SEG11")]
+ public string? PrivateDescSeg11 { get; set; }
+
+ /// <summary>
+ /// 鍝佺墝鍒嗙被
+ /// </summary>
+ [SugarColumn(ColumnName = "PRIVATE_DESC_SEG7")]
+ public string? PrivateDescSeg7 { get; set; }
+
+ /// <summary>
+ /// BU锛堜笟鍔″崟鍏冿級
+ /// </summary>
+ [SugarColumn(ColumnName = "PRIVATE_DESC_SEG2")]
+ public string? PrivateDescSeg2 { get; set; }
+
+ /// <summary>
+ /// BU锛堜笟鍔″崟鍏冿級
+ /// </summary>
+ [SugarColumn(ColumnName = "DOCUMENT_STATUS")]
+ public string? DocumentStatus { get; set; }
+
+ /// <summary>
+ /// 鏄惁鐢熸晥
+ /// </summary>
+ [SugarColumn(ColumnName = "FORBID_STATUS")]
+ public string? ForbidStatus { get; set; }
+
+ /// <summary>
+ /// 鏃х墿鏂欑紪鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "Old_ITEM_NO")]
+ public string? OldItemNo { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3