From 5dc3cc86f5835369cd830f2a83318b9a8d69cf69 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 15 七月 2025 16:20:19 +0800
Subject: [PATCH] 11
---
MES.Service/Modes/MesItems.cs | 377 +++++++++++++++++++++++++++++++++--------------------
1 files changed, 234 insertions(+), 143 deletions(-)
diff --git a/MES.Service/Modes/MesItems.cs b/MES.Service/Modes/MesItems.cs
index 868dba2..b8ab9d1 100644
--- a/MES.Service/Modes/MesItems.cs
+++ b/MES.Service/Modes/MesItems.cs
@@ -9,280 +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; }
+ public string Factory { get; set; }
/// <summary>
- /// 鍏徃缂栧彿
- /// </summary>
+ /// 鍏徃缂栧彿
+ ///</summary>
[SugarColumn(ColumnName = "COMPANY")]
- public string? Company { get; set; }
+ public string Company { get; set; }
/// <summary>
- /// 鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿
- /// </summary>
+ /// 鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿
+ ///</summary>
[SugarColumn(ColumnName = "ITEM_NO")]
- public string? ItemNo { get; set; }
+ public string ItemNo { get; set; }
/// <summary>
- /// 鐗╂枡鍚嶇О
- /// </summary>
+ /// 鐗╂枡鍚嶇О
+ ///</summary>
[SugarColumn(ColumnName = "ITEM_NAME")]
- public string? ItemName { get; set; }
-
+ public string ItemName { get; set; }
/// <summary>
- /// 瑙勬牸鍨嬪彿
- /// </summary>
+ /// 鐗╂枡绠�绉�
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_SNAME")]
+ public string ItemSname { get; set; }
+
+ /// <summary>
+ /// 瑙勬牸鍨嬪彿
+ ///</summary>
[SugarColumn(ColumnName = "ITEM_MODEL")]
- public string? ItemModel { get; set; }
-
+ public string ItemModel { get; set; }
/// <summary>
- /// 鐗╂枡鍗曚綅
- /// </summary>
+ /// 鐗╂枡鎻忚堪
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_DESCRIPTION")]
+ public string ItemDescription { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "ITEM_UNIT")]
- public string? ItemUnit { get; set; }
-
+ public string ItemUnit { get; set; }
/// <summary>
- /// 鍒涘缓浜�
- /// </summary>
+ /// 鐗╂枡绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName = "ITEM_TYPE")]
+ public string ItemType { get; set; }
+
+ /// <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; }
+ 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; }
+ 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; }
+ public string Saleunit { get; set; }
/// <summary>
- /// 搴撴埧鍗曚綅
- /// </summary>
+ /// 搴撴埧鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "STOREUNIT")]
- public string? Storeunit { get; set; }
+ public string Storeunit { get; set; }
/// <summary>
- /// 鐢熶骇鍗曚綅
- /// </summary>
+ /// 鐢熶骇鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "PRODUCTUNIT")]
- public string? Productunit { get; set; }
+ 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; }
+ public string ErpItemNo { get; set; }
/// <summary>
- /// 榛樿浠撳簱
- /// </summary>
+ /// 榛樿浠撳簱
+ ///</summary>
[SugarColumn(ColumnName = "DEPOT_CODE")]
- public string? DepotCode { get; set; }
-
+ public string DepotCode { get; set; }
/// <summary>
- /// 鐗╂枡鍒嗙粍
- /// </summary>
+ /// 鐗╂枡鍒嗙被缂栧彿
+ ///</summary>
+ [SugarColumn(ColumnName = "PPBOM00019124")]
+ public string Ppbom00019124 { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡鍒嗙粍
+ ///</summary>
[SugarColumn(ColumnName = "REMARKS")]
- public string? Remarks { get; set; }
+ public string Remarks { get; set; }
/// <summary>
- /// 閲囪喘鍛�
- /// </summary>
+ /// 閲囪喘鍛�
+ ///</summary>
[SugarColumn(ColumnName = "FPURCHASERID")]
- public string? Fpurchaserid { get; set; }
+ public string Fpurchaserid { get; set; }
/// <summary>
- /// 绂佺敤鐘舵��
- /// </summary>
+ /// 绂佺敤鐘舵��
+ ///</summary>
[SugarColumn(ColumnName = "FFORBIDSTATUS")]
- public string? Fforbidstatus { get; set; }
+ public string Fforbidstatus { get; set; }
/// <summary>
- /// 鐗╂枡鍒嗙粍
- /// </summary>
+ /// 鐗╂枡鍒嗙粍
+ ///</summary>
[SugarColumn(ColumnName = "FMATERIALGROUP")]
- public string? Fmaterialgroup { get; set; }
+ 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; }
+ 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; }
+ public string Remark1 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�2
- /// </summary>
+ /// 鑷畾涔夊瓧娈�2
+ ///</summary>
[SugarColumn(ColumnName = "REMARK2")]
- public string? Remark2 { get; set; }
+ public string Remark2 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�3
- /// </summary>
+ /// 鑷畾涔夊瓧娈�3
+ ///</summary>
[SugarColumn(ColumnName = "REMARK3")]
- public string? Remark3 { get; set; }
+ public string Remark3 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�4
- /// </summary>
+ /// 鑷畾涔夊瓧娈�4
+ ///</summary>
[SugarColumn(ColumnName = "REMARK4")]
- public string? Remark4 { get; set; }
+ public string Remark4 { get; set; }
/// <summary>
- /// 鑷畾涔夊瓧娈�5
- /// </summary>
+ /// 鑷畾涔夊瓧娈�5
+ ///</summary>
[SugarColumn(ColumnName = "REMARK5")]
- public string? Remark5 { get; set; }
+ public string Remark5 { get; set; }
/// <summary>
- /// 鐢熶骇杞﹂棿
- /// </summary>
+ /// 鐢熶骇杞﹂棿
+ ///</summary>
[SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")]
- public string? ProductionWorkshop { get; set; }
+ public string ProductionWorkshop { get; set; }
/// <summary>
- /// 鐗╂枡灞炴��
- /// </summary>
+ /// 鐗╂枡灞炴��
+ ///</summary>
[SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
- public string? MaterialProperti { get; set; }
+ public string MaterialProperti { get; set; }
/// <summary>
- /// 鐢熶骇鍗曚綅
- /// </summary>
+ /// 鐢熶骇鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "PRODUCE_UNIT")]
- public string? ProduceUnit { get; set; }
+ public string ProduceUnit { get; set; }
/// <summary>
- /// 濮斿鍗曚綅
- /// </summary>
+ /// 濮斿鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "SUBCON_UNIT")]
- public string? SubconUnit { get; set; }
+ 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>
+ [SugarColumn(ColumnName = "AP_LINE")]
+ public decimal? ApLine { get; set; }
+
+ /// <summary>
+ /// 鍔╄鐮�
+ ///</summary>
+ [SugarColumn(ColumnName = "FMNEMONICCODE")]
+ public string Fmnemoniccode { get; set; }
/// <summary>
- /// 鍔╄鐮�
- /// </summary>
- [SugarColumn(ColumnName = "FMnemonicCode")]
-
- public string? FMnemonicCode { get; set; }
+ /// 淇濊川鏈�
+ ///</summary>
+ [SugarColumn(ColumnName = "FEXPPERIOD")]
+ public string Fexpperiod { get; set; }
/// <summary>
- /// 淇濊川鏈�
- /// </summary>
- [SugarColumn(ColumnName = "FExpPeriod")]
- public string? FExpPeriod { get; set; }
-
- /// <summary>
- /// 棰滆壊
- /// </summary>
+ /// 棰滆壊
+ ///</summary>
[SugarColumn(ColumnName = "COLOR_NAME")]
- public string? ColorName { get; set; }
+ public string ColorName { get; set; }
+
/// <summary>
- /// 鏄惁鍏抽敭浠�
- /// </summary>
- [SugarColumn(ColumnName = "FIsKitting")]
- public string? FIsKitting { get; set; }
-
+ /// 鎹熻�楃巼
+ ///</summary>
+ [SugarColumn(ColumnName = "FLOSSPERCENT")]
+ public string Flosspercent { get; set; }
+
/// <summary>
- /// 鍝佺墝鏂癸紙鍘熶骇鍦帮級
- /// </summary>
- [SugarColumn(ColumnName = "Provenance")]
- public string? Provenance { get; set; }
-
-
+ /// 鏍囧噯浜ц兘
+ ///</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