From 3a6f7cb36dff0ec99edddbb53078947fcf08a47e Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期六, 19 七月 2025 09:32:15 +0800
Subject: [PATCH] 1.用料清单变更

---
 MES.Service/Modes/MesItems.cs |  216 +++++++++++++++++++++++++++++++++---------------------
 1 files changed, 132 insertions(+), 84 deletions(-)

diff --git a/MES.Service/Modes/MesItems.cs b/MES.Service/Modes/MesItems.cs
index c63f30d..1242711 100644
--- a/MES.Service/Modes/MesItems.cs
+++ b/MES.Service/Modes/MesItems.cs
@@ -9,231 +9,303 @@
 public class MesItems
 {
     /// <summary>
+    /// </summary>
+    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+    public Guid Guid { get; set; }
+
+    /// <summary>
     ///     鐗╂枡ID
     /// </summary>
-    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
+    [SugarColumn(ColumnName = "id")]
     public decimal Id { get; set; }
 
     /// <summary>
     ///     宸ュ巶
     /// </summary>
-    [SugarColumn(ColumnName = "FACTORY")]
+    [SugarColumn(ColumnName = "factory")]
     public string? Factory { get; set; }
 
     /// <summary>
     ///     鍏徃缂栧彿
     /// </summary>
-    [SugarColumn(ColumnName = "COMPANY")]
+    [SugarColumn(ColumnName = "company")]
     public string? Company { get; set; }
 
     /// <summary>
     ///     鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿
     /// </summary>
-    [SugarColumn(ColumnName = "ITEM_NO")]
+    [SugarColumn(ColumnName = "item_no")]
     public string? ItemNo { get; set; }
 
     /// <summary>
     ///     鐗╂枡鍚嶇О
     /// </summary>
-    [SugarColumn(ColumnName = "ITEM_NAME")]
+    [SugarColumn(ColumnName = "item_name")]
     public string? ItemName { get; set; }
 
+    /// <summary>
+    ///     鐗╂枡绠�绉�
+    /// </summary>
+    [SugarColumn(ColumnName = "item_sname")]
+    public string? ItemSname { get; set; }
 
     /// <summary>
     ///     瑙勬牸鍨嬪彿
     /// </summary>
-    [SugarColumn(ColumnName = "ITEM_MODEL")]
+    [SugarColumn(ColumnName = "item_model")]
     public string? ItemModel { get; set; }
 
+    /// <summary>
+    ///     鐗╂枡鎻忚堪
+    /// </summary>
+    [SugarColumn(ColumnName = "item_description")]
+    public string? ItemDescription { get; set; }
 
     /// <summary>
     ///     鐗╂枡鍗曚綅
     /// </summary>
-    [SugarColumn(ColumnName = "ITEM_UNIT")]
+    [SugarColumn(ColumnName = "item_unit")]
     public string? ItemUnit { get; set; }
 
+    /// <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")]
+    [SugarColumn(ColumnName = "create_by")]
     public string? CreateBy { get; set; }
 
     /// <summary>
     ///     鍒涘缓鏃堕棿
     /// </summary>
-    [SugarColumn(ColumnName = "CREATE_DATE")]
+    [SugarColumn(ColumnName = "create_date")]
     public DateTime? CreateDate { get; set; }
 
     /// <summary>
     ///     鏈�鍚庢洿鏂颁汉
     /// </summary>
-    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+    [SugarColumn(ColumnName = "lastupdate_by")]
     public string? LastupdateBy { get; set; }
 
     /// <summary>
     ///     鏈�鍚庢洿鏂版椂闂�
     /// </summary>
-    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
+    [SugarColumn(ColumnName = "lastupdate_date")]
     public DateTime? LastupdateDate { get; set; }
 
     /// <summary>
     ///     鏈�浣庡簱瀛�
     /// </summary>
-    [SugarColumn(ColumnName = "LOWLIMIT")]
+    [SugarColumn(ColumnName = "lowlimit")]
     public double? Lowlimit { get; set; }
 
     /// <summary>
     ///     鏈�澶у簱瀛�
     /// </summary>
-    [SugarColumn(ColumnName = "HIGHLIMIT")]
+    [SugarColumn(ColumnName = "highlimit")]
     public double? Highlimit { get; set; }
 
     /// <summary>
     ///     鏈�灏忓寘瑁呮暟
     /// </summary>
-    [SugarColumn(ColumnName = "PRD_PACK")]
+    [SugarColumn(ColumnName = "prd_pack")]
     public double? PrdPack { get; set; }
 
+    /// <summary>
+    ///     璁㈠崟鍗曚綅
+    /// </summary>
+    [SugarColumn(ColumnName = "orderunit")]
+    public string? Orderunit { get; set; }
 
     /// <summary>
     ///     閿�鍞崟浣�
     /// </summary>
-    [SugarColumn(ColumnName = "SALEUNIT")]
+    [SugarColumn(ColumnName = "saleunit")]
     public string? Saleunit { get; set; }
 
     /// <summary>
     ///     搴撴埧鍗曚綅
     /// </summary>
-    [SugarColumn(ColumnName = "STOREUNIT")]
+    [SugarColumn(ColumnName = "storeunit")]
     public string? Storeunit { get; set; }
-
-    /// <summary>
-    ///     鐢熶骇鍗曚綅
-    /// </summary>
-    [SugarColumn(ColumnName = "PRODUCTUNIT")]
-    public string? Productunit { get; set; }
 
     /// <summary>
     ///     鐗╂枡ID
     /// </summary>
-    [SugarColumn(ColumnName = "E_ITEM_ID")]
-    public decimal? EItemId { get; set; }
+    [SugarColumn(ColumnName = "e_item_id")]
+    public long? EItemId { get; set; }
 
     /// <summary>
     ///     ERP鏂欏彿
     /// </summary>
-    [SugarColumn(ColumnName = "ERP_ITEM_NO")]
+    [SugarColumn(ColumnName = "erp_item_no")]
     public string? ErpItemNo { get; set; }
 
     /// <summary>
     ///     榛樿浠撳簱
     /// </summary>
-    [SugarColumn(ColumnName = "DEPOT_CODE")]
+    [SugarColumn(ColumnName = "depot_code")]
     public string? DepotCode { get; set; }
 
+    /// <summary>
+    ///     鐗╂枡鍒嗙被缂栧彿
+    /// </summary>
+    [SugarColumn(ColumnName = "ppbom00019124")]
+    public string? Ppbom00019124 { get; set; }
 
     /// <summary>
     ///     鐗╂枡鍒嗙粍
     /// </summary>
-    [SugarColumn(ColumnName = "REMARKS")]
+    [SugarColumn(ColumnName = "remarks")]
     public string? Remarks { get; set; }
 
     /// <summary>
     ///     閲囪喘鍛�
     /// </summary>
-    [SugarColumn(ColumnName = "FPURCHASERID")]
+    [SugarColumn(ColumnName = "fpurchaserid")]
     public string? Fpurchaserid { get; set; }
 
     /// <summary>
     ///     绂佺敤鐘舵��
     /// </summary>
-    [SugarColumn(ColumnName = "FFORBIDSTATUS")]
+    [SugarColumn(ColumnName = "fforbidstatus")]
     public string? Fforbidstatus { get; set; }
 
     /// <summary>
     ///     鐗╂枡鍒嗙粍
     /// </summary>
-    [SugarColumn(ColumnName = "FMATERIALGROUP")]
+    [SugarColumn(ColumnName = "fmaterialgroup")]
     public string? Fmaterialgroup { get; set; }
 
     /// <summary>
     ///     瀹屽伐瓒呮敹姣斾緥
     /// </summary>
-    [SugarColumn(ColumnName = "FFINISHRECEIPTOVERRATE")]
+    [SugarColumn(ColumnName = "ffinishreceiptoverrate")]
     public decimal? Ffinishreceiptoverrate { get; set; }
 
     /// <summary>
     ///     鍙戞枡鏂瑰紡
     /// </summary>
-    [SugarColumn(ColumnName = "FISSUETYPE")]
+    [SugarColumn(ColumnName = "fissuetype")]
     public string? Fissuetype { get; set; }
 
     /// <summary>
     ///     鍚敤鎵瑰彿绠＄悊
     /// </summary>
-    [SugarColumn(ColumnName = "FISBATCHMANAGE")]
+    [SugarColumn(ColumnName = "fisbatchmanage")]
     public int? Fisbatchmanage { get; set; }
 
     /// <summary>
     ///     閲囪喘鍗曚綅
     /// </summary>
-    [SugarColumn(ColumnName = "FPURCHASEUNITID")]
-    public decimal? Fpurchaseunitid { get; set; }
+    [SugarColumn(ColumnName = "fpurchaseunitid")]
+    public decimal Fpurchaseunitid { get; set; }
 
     /// <summary>
-    ///     鑷畾涔夊瓧娈�1
+    ///     鎹熻�楃巼
     /// </summary>
-    [SugarColumn(ColumnName = "REMARK1")]
-    public string? Remark1 { get; set; }
+    [SugarColumn(ColumnName = "loss_percent")]
+    public string? LossPercent { get; set; }
 
     /// <summary>
-    ///     鑷畾涔夊瓧娈�2
+    ///     鍔╄鐮�
     /// </summary>
-    [SugarColumn(ColumnName = "REMARK2")]
-    public string? Remark2 { get; set; }
+    [SugarColumn(ColumnName = "mnemonic_code")]
+    public string? MnemonicCode { get; set; }
 
     /// <summary>
-    ///     鑷畾涔夊瓧娈�3
+    ///     淇濊川鏈�
     /// </summary>
-    [SugarColumn(ColumnName = "REMARK3")]
-    public string? Remark3 { get; set; }
-
-    /// <summary>
-    ///     鑷畾涔夊瓧娈�4
-    /// </summary>
-    [SugarColumn(ColumnName = "REMARK4")]
-    public string? Remark4 { get; set; }
-
-    /// <summary>
-    ///     鑷畾涔夊瓧娈�5
-    /// </summary>
-    [SugarColumn(ColumnName = "REMARK5")]
-    public string? Remark5 { get; set; }
+    [SugarColumn(ColumnName = "exp_period")]
+    public string? ExpPeriod { get; set; }
 
     /// <summary>
     ///     鐢熶骇杞﹂棿
     /// </summary>
-    [SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")]
+    [SugarColumn(ColumnName = "production_workshop")]
     public string? ProductionWorkshop { get; set; }
 
     /// <summary>
     ///     鐗╂枡灞炴��
     /// </summary>
-    [SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
+    [SugarColumn(ColumnName = "material_properti")]
     public string? MaterialProperti { get; set; }
 
     /// <summary>
     ///     鐢熶骇鍗曚綅
     /// </summary>
-    [SugarColumn(ColumnName = "PRODUCE_UNIT")]
+    [SugarColumn(ColumnName = "produce_unit")]
     public string? ProduceUnit { get; set; }
 
     /// <summary>
     ///     濮斿鍗曚綅
     /// </summary>
-    [SugarColumn(ColumnName = "SUBCON_UNIT")]
+    [SugarColumn(ColumnName = "subcon_unit")]
     public string? SubconUnit { get; set; }
+
+    /// <summary>
+    ///     鍥剧墖1
+    /// </summary>
+    [SugarColumn(ColumnName = "bz06")]
+    public string? Bz06 { get; set; }
+
+    /// <summary>
+    ///     鍥剧墖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>
+    ///     鐗╂枡ID
+    /// </summary>
+    [SugarColumn(ColumnName = "item_id")]
+    public long? ItemId { get; set; }
+
+    /// <summary>
+    ///     棰滆壊
+    /// </summary>
+    [SugarColumn(ColumnName = "color_name")]
+    public string? ColorName { get; set; }
 
     /// <summary>
     ///     浣跨敤绲勭箶
@@ -247,30 +319,6 @@
     [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; }
 
     [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
 }
\ No newline at end of file

--
Gitblit v1.9.3