From f6598be8fdb51673c0a48ddeac8bd0e622835b35 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 16 七月 2025 11:58:10 +0800
Subject: [PATCH] 111
---
MES.Service/Modes/MesItems.cs | 322 ++++++++++++++++++++++++++++++++++-------------------
1 files changed, 204 insertions(+), 118 deletions(-)
diff --git a/MES.Service/Modes/MesItems.cs b/MES.Service/Modes/MesItems.cs
index 8633f72..89236f3 100644
--- a/MES.Service/Modes/MesItems.cs
+++ b/MES.Service/Modes/MesItems.cs
@@ -9,285 +9,371 @@
public class MesItems
{
/// <summary>
- /// 鐗╂枡ID
- /// </summary>
+ /// 鐗╂枡ID
+ ///</summary>
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
public decimal Id { get; set; }
/// <summary>
- /// 宸ュ巶
- /// </summary>
+ /// 宸ュ巶
+ ///</summary>
[SugarColumn(ColumnName = "FACTORY")]
public string? Factory { get; set; }
/// <summary>
- /// 鍏徃缂栧彿
- /// </summary>
+ /// 鍏徃缂栧彿
+ ///</summary>
[SugarColumn(ColumnName = "COMPANY")]
public string? Company { get; set; }
/// <summary>
- /// 鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿
- /// </summary>
+ /// 鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿
+ ///</summary>
[SugarColumn(ColumnName = "ITEM_NO")]
public string? ItemNo { get; set; }
/// <summary>
- /// 鐗╂枡鍚嶇О
- /// </summary>
+ /// 鐗╂枡鍚嶇О
+ ///</summary>
[SugarColumn(ColumnName = "ITEM_NAME")]
public string? ItemName { get; set; }
+ /// <summary>
+ /// 鐗╂枡绠�绉�
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_SNAME")]
+ public string? ItemSname { get; set; }
/// <summary>
- /// 瑙勬牸鍨嬪彿
- /// </summary>
+ /// 瑙勬牸鍨嬪彿
+ ///</summary>
[SugarColumn(ColumnName = "ITEM_MODEL")]
public string? ItemModel { get; set; }
+ /// <summary>
+ /// 鐗╂枡鎻忚堪
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_DESCRIPTION")]
+ public string? ItemDescription { get; set; }
/// <summary>
- /// 鐗╂枡鍗曚綅
- /// </summary>
+ /// 鐗╂枡鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "ITEM_UNIT")]
public string? ItemUnit { get; set; }
+ /// <summary>
+ /// 鐗╂枡绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_TYPE")]
+ public string? ItemType { get; set; }
/// <summary>
- /// 鍒涘缓浜�
- /// </summary>
+ /// 浜у搧鐗堟湰
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_VERSION")]
+ public string? ItemVersion { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName = "CUST_NO")]
+ public string? CustNo { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
[SugarColumn(ColumnName = "CREATE_BY")]
public string? CreateBy { get; set; }
/// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
[SugarColumn(ColumnName = "CREATE_DATE")]
public DateTime? CreateDate { get; set; }
/// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ ///</summary>
[SugarColumn(ColumnName = "LASTUPDATE_BY")]
public string? LastupdateBy { get; set; }
/// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ ///</summary>
[SugarColumn(ColumnName = "LASTUPDATE_DATE")]
public DateTime? LastupdateDate { get; set; }
/// <summary>
- /// 鏈�浣庡簱瀛�
- /// </summary>
+ /// 鏈�浣庡簱瀛�
+ ///</summary>
[SugarColumn(ColumnName = "LOWLIMIT")]
public double? Lowlimit { get; set; }
/// <summary>
- /// 鏈�澶у簱瀛�
- /// </summary>
+ /// 鏈�澶у簱瀛�
+ ///</summary>
[SugarColumn(ColumnName = "HIGHLIMIT")]
public double? Highlimit { get; set; }
/// <summary>
- /// 鏈�灏忓寘瑁呮暟
- /// </summary>
+ /// 鏈�灏忓寘瑁呮暟
+ ///</summary>
[SugarColumn(ColumnName = "PRD_PACK")]
public double? PrdPack { get; set; }
+ /// <summary>
+ /// 璁㈠崟鍗曚綅
+ ///</summary>
+ [SugarColumn(ColumnName = "ORDERUNIT")]
+ public string? Orderunit { get; set; }
/// <summary>
- /// 閿�鍞崟浣�
- /// </summary>
+ /// 閿�鍞崟浣�
+ ///</summary>
[SugarColumn(ColumnName = "SALEUNIT")]
public string? Saleunit { get; set; }
/// <summary>
- /// 搴撴埧鍗曚綅
- /// </summary>
+ /// 搴撴埧鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "STOREUNIT")]
public string? Storeunit { get; set; }
/// <summary>
- /// 鐢熶骇鍗曚綅
- /// </summary>
+ /// 鐢熶骇鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "PRODUCTUNIT")]
public string? Productunit { get; set; }
/// <summary>
- /// 鐗╂枡ID
- /// </summary>
+ /// 鐗╂枡ID
+ ///</summary>
[SugarColumn(ColumnName = "E_ITEM_ID")]
public decimal? EItemId { get; set; }
/// <summary>
- /// ERP鏂欏彿
- /// </summary>
+ /// ERP鏂欏彿
+ ///</summary>
[SugarColumn(ColumnName = "ERP_ITEM_NO")]
public string? ErpItemNo { get; set; }
/// <summary>
- /// 榛樿浠撳簱
- /// </summary>
+ /// 榛樿浠撳簱
+ ///</summary>
[SugarColumn(ColumnName = "DEPOT_CODE")]
public string? DepotCode { get; set; }
+ /// <summary>
+ /// 鐗╂枡鍒嗙被缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName = "PPBOM00019124")]
+ public string? Ppbom00019124 { get; set; }
/// <summary>
- /// 鐗╂枡鍒嗙粍
- /// </summary>
+ /// 鐗╂枡鍒嗙粍
+ ///</summary>
[SugarColumn(ColumnName = "REMARKS")]
public string? Remarks { get; set; }
/// <summary>
- /// 閲囪喘鍛�
- /// </summary>
+ /// 閲囪喘鍛�
+ ///</summary>
[SugarColumn(ColumnName = "FPURCHASERID")]
public string? Fpurchaserid { get; set; }
/// <summary>
- /// 绂佺敤鐘舵��
- /// </summary>
+ /// 绂佺敤鐘舵��
+ ///</summary>
[SugarColumn(ColumnName = "FFORBIDSTATUS")]
public string? Fforbidstatus { get; set; }
/// <summary>
- /// 鐗╂枡鍒嗙粍
- /// </summary>
+ /// 鐗╂枡鍒嗙粍
+ ///</summary>
[SugarColumn(ColumnName = "FMATERIALGROUP")]
public string? Fmaterialgroup { get; set; }
/// <summary>
- /// 瀹屽伐瓒呮敹姣斾緥
- /// </summary>
+ /// 瀹屽伐瓒呮敹姣斾緥
+ ///</summary>
[SugarColumn(ColumnName = "FFINISHRECEIPTOVERRATE")]
public decimal? Ffinishreceiptoverrate { get; set; }
/// <summary>
- /// 鍙戞枡鏂瑰紡
- /// </summary>
+ /// 鍙戞枡鏂瑰紡
+ ///</summary>
[SugarColumn(ColumnName = "FISSUETYPE")]
public string? Fissuetype { get; set; }
/// <summary>
- /// 鍚敤鎵瑰彿绠＄悊
- /// </summary>
+ /// 鍚敤鎵瑰彿绠＄悊
+ ///</summary>
[SugarColumn(ColumnName = "FISBATCHMANAGE")]
- public int? Fisbatchmanage { get; set; }
+ public decimal? Fisbatchmanage { get; set; }
/// <summary>
- /// 閲囪喘鍗曚綅
- /// </summary>
+ /// 閲囪喘鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "FPURCHASEUNITID")]
- public decimal? Fpurchaseunitid { get; set; }
+ public decimal Fpurchaseunitid { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�1
- /// </summary>
+ /// 鑷畾涔夊瓧娈�1
+ ///</summary>
[SugarColumn(ColumnName = "REMARK1")]
public string? Remark1 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�2
- /// </summary>
+ /// 鑷畾涔夊瓧娈�2
+ ///</summary>
[SugarColumn(ColumnName = "REMARK2")]
public string? Remark2 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�3
- /// </summary>
+ /// 鑷畾涔夊瓧娈�3
+ ///</summary>
[SugarColumn(ColumnName = "REMARK3")]
public string? Remark3 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�4
- /// </summary>
+ /// 鑷畾涔夊瓧娈�4
+ ///</summary>
[SugarColumn(ColumnName = "REMARK4")]
public string? Remark4 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�5
- /// </summary>
+ /// 鑷畾涔夊瓧娈�5
+ ///</summary>
[SugarColumn(ColumnName = "REMARK5")]
public string? Remark5 { get; set; }
/// <summary>
- /// 鐢熶骇杞﹂棿
- /// </summary>
+ /// 鐢熶骇杞﹂棿
+ ///</summary>
[SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")]
public string? ProductionWorkshop { get; set; }
/// <summary>
- /// 鐗╂枡灞炴��
- /// </summary>
+ /// 鐗╂枡灞炴��
+ ///</summary>
[SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
public string? MaterialProperti { get; set; }
/// <summary>
- /// 鐢熶骇鍗曚綅
- /// </summary>
+ /// 鐢熶骇鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "PRODUCE_UNIT")]
public string? ProduceUnit { get; set; }
/// <summary>
- /// 濮斿鍗曚綅
- /// </summary>
+ /// 濮斿鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "SUBCON_UNIT")]
public string? SubconUnit { get; set; }
/// <summary>
- /// 浣跨敤绲勭箶
- /// </summary>
- [SugarColumn(ColumnName = "FSubsidiary")]
- public string? FSubsidiary { get; set; }
+ /// 鍥剧墖1
+ ///</summary>
+ [SugarColumn(ColumnName = "BZ06")]
+ public string? Bz06 { get; set; }
/// <summary>
- /// 鍓靛缓绲勭箶
- /// </summary>
- [SugarColumn(ColumnName = "Fumbrella")]
+ /// 鍥剧墖2
+ ///</summary>
+ [SugarColumn(ColumnName = "BZ07")]
+ public string? Bz07 { get; set; }
+
+ /// <summary>
+ /// 鍥剧墖3
+ ///</summary>
+ [SugarColumn(ColumnName = "BZ08")]
+ public string? Bz08 { get; set; }
+
+ /// <summary>
+ /// 鍥剧墖4
+ ///</summary>
+ [SugarColumn(ColumnName = "BZ09")]
+ public string? Bz09 { get; set; }
+
+ /// <summary>
+ /// 鍥剧墖5
+ ///</summary>
+ [SugarColumn(ColumnName = "BZ10")]
+ public string? Bz10 { get; set; }
+
+ /// <summary>
+ /// QC鍒嗙粍ID
+ ///</summary>
+ [SugarColumn(ColumnName = "QC_TEAMID")]
+ public string? QcTeamid { get; set; }
+
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "FSUBSIDIARY")]
+ public string? Fsubsidiary { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "FUMBRELLA")]
public string? Fumbrella { get; set; }
/// <summary>
- /// 鎹熻�楃巼
- /// </summary>
- [SugarColumn(ColumnName = "FLOSSPERCENT")]
- public string? FLOSSPERCENT { get; set; }
-
- /// <summary>
- /// 鍔╄鐮�
- /// </summary>
- [SugarColumn(ColumnName = "FMnemonicCode")]
-
- public string? FMnemonicCode { get; set; }
-
- /// <summary>
- /// 淇濊川鏈�
- /// </summary>
- [SugarColumn(ColumnName = "FExpPeriod")]
- public string? FExpPeriod { get; set; }
-
- /// <summary>
- /// 棰滆壊
- /// </summary>
- [SugarColumn(ColumnName = "COLOR_NAME")]
- public string? ColorName { get; set; }
- /// <summary>
- /// 鏄惁鍏抽敭浠�
- /// </summary>
- [SugarColumn(ColumnName = "FIsKitting")]
- public string? FIsKitting { get; set; }
+ /// 閫傞厤浜х嚎
+ ///</summary>
+ [SugarColumn(ColumnName = "AP_LINE")]
+ public decimal? ApLine { get; set; }
/// <summary>
- /// 鍝佺墝鏂癸紙鍘熶骇鍦帮級
- /// </summary>
- [SugarColumn(ColumnName = "Provenance")]
- public string? Provenance { get; set; }
+ /// 鍔╄鐮�
+ ///</summary>
+ [SugarColumn(ColumnName = "FMNEMONICCODE")]
+ public string? Fmnemoniccode { get; set; }
+
/// <summary>
- /// 鏉愯川
- /// </summary>
+ /// 淇濊川鏈�
+ ///</summary>
+ [SugarColumn(ColumnName = "FEXPPERIOD")]
+ public string? Fexpperiod { get; set; }
+
+ /// <summary>
+ /// 棰滆壊
+ ///</summary>
+ [SugarColumn(ColumnName = "COLOR_NAME")]
+ public string? ColorName { get; set; }
+
+ /// <summary>
+ /// 鎹熻�楃巼
+ ///</summary>
+ [SugarColumn(ColumnName = "FLOSSPERCENT")]
+ public string? Flosspercent { get; set; }
+
+ /// <summary>
+ /// 鏍囧噯浜ц兘
+ ///</summary>
+ [SugarColumn(ColumnName = "SP_CAPACITY")]
+ public string? SpCapacity { get; set; }
+
+ /// <summary>
+ /// 鏄惁鍏抽敭浠�
+ ///</summary>
+ [SugarColumn(ColumnName = "FISKITTING")]
+ public string? Fiskitting { get; set; }
+
+ /// <summary>
+ /// 鍘熶骇鍦帮紙鍝佺墝鏂癸級
+ ///</summary>
+ [SugarColumn(ColumnName = "PROVENANCE")]
+ public string? Provenance { get; set; }
+
+ /// <summary>
+ /// 鏉愯川
+ ///</summary>
[SugarColumn(ColumnName = "MATERIAL")]
public string? Material { get; set; }
-
+
[SugarColumn(IsIgnore = true)] public string? Type { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3