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 | 324 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 324 insertions(+), 0 deletions(-)
diff --git a/MES.Service/Modes/MesItems.cs b/MES.Service/Modes/MesItems.cs
new file mode 100644
index 0000000..1242711
--- /dev/null
+++ b/MES.Service/Modes/MesItems.cs
@@ -0,0 +1,324 @@
+锘縰sing SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 鐗╂枡淇℃伅
+/// </summary>
+[SugarTable("MES_ITEMS")]
+public class MesItems
+{
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "id")]
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// 宸ュ巶
+ /// </summary>
+ [SugarColumn(ColumnName = "factory")]
+ public string? Factory { get; set; }
+
+ /// <summary>
+ /// 鍏徃缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "company")]
+ public string? Company { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡缂栫爜 = ERP鐗╂枡缂栧彿||棰滆壊缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "item_no")]
+ public string? ItemNo { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡鍚嶇О
+ /// </summary>
+ [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")]
+ public string? ItemModel { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡鎻忚堪
+ /// </summary>
+ [SugarColumn(ColumnName = "item_description")]
+ public string? ItemDescription { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡鍗曚綅
+ /// </summary>
+ [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")]
+ public string? CreateBy { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "create_date")]
+ public DateTime? CreateDate { get; set; }
+
+ /// <summary>
+ /// 鏈�鍚庢洿鏂颁汉
+ /// </summary>
+ [SugarColumn(ColumnName = "lastupdate_by")]
+ public string? LastupdateBy { get; set; }
+
+ /// <summary>
+ /// 鏈�鍚庢洿鏂版椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "lastupdate_date")]
+ public DateTime? LastupdateDate { get; set; }
+
+ /// <summary>
+ /// 鏈�浣庡簱瀛�
+ /// </summary>
+ [SugarColumn(ColumnName = "lowlimit")]
+ public double? Lowlimit { get; set; }
+
+ /// <summary>
+ /// 鏈�澶у簱瀛�
+ /// </summary>
+ [SugarColumn(ColumnName = "highlimit")]
+ public double? Highlimit { get; set; }
+
+ /// <summary>
+ /// 鏈�灏忓寘瑁呮暟
+ /// </summary>
+ [SugarColumn(ColumnName = "prd_pack")]
+ public double? PrdPack { get; set; }
+
+ /// <summary>
+ /// 璁㈠崟鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "orderunit")]
+ public string? Orderunit { get; set; }
+
+ /// <summary>
+ /// 閿�鍞崟浣�
+ /// </summary>
+ [SugarColumn(ColumnName = "saleunit")]
+ public string? Saleunit { get; set; }
+
+ /// <summary>
+ /// 搴撴埧鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "storeunit")]
+ public string? Storeunit { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "e_item_id")]
+ public long? EItemId { get; set; }
+
+ /// <summary>
+ /// ERP鏂欏彿
+ /// </summary>
+ [SugarColumn(ColumnName = "erp_item_no")]
+ public string? ErpItemNo { get; set; }
+
+ /// <summary>
+ /// 榛樿浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "depot_code")]
+ public string? DepotCode { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡鍒嗙被缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ppbom00019124")]
+ public string? Ppbom00019124 { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡鍒嗙粍
+ /// </summary>
+ [SugarColumn(ColumnName = "remarks")]
+ public string? Remarks { get; set; }
+
+ /// <summary>
+ /// 閲囪喘鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "fpurchaserid")]
+ public string? Fpurchaserid { get; set; }
+
+ /// <summary>
+ /// 绂佺敤鐘舵��
+ /// </summary>
+ [SugarColumn(ColumnName = "fforbidstatus")]
+ public string? Fforbidstatus { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡鍒嗙粍
+ /// </summary>
+ [SugarColumn(ColumnName = "fmaterialgroup")]
+ public string? Fmaterialgroup { get; set; }
+
+ /// <summary>
+ /// 瀹屽伐瓒呮敹姣斾緥
+ /// </summary>
+ [SugarColumn(ColumnName = "ffinishreceiptoverrate")]
+ public decimal? Ffinishreceiptoverrate { get; set; }
+
+ /// <summary>
+ /// 鍙戞枡鏂瑰紡
+ /// </summary>
+ [SugarColumn(ColumnName = "fissuetype")]
+ public string? Fissuetype { get; set; }
+
+ /// <summary>
+ /// 鍚敤鎵瑰彿绠＄悊
+ /// </summary>
+ [SugarColumn(ColumnName = "fisbatchmanage")]
+ public int? Fisbatchmanage { get; set; }
+
+ /// <summary>
+ /// 閲囪喘鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "fpurchaseunitid")]
+ public decimal Fpurchaseunitid { get; set; }
+
+ /// <summary>
+ /// 鎹熻�楃巼
+ /// </summary>
+ [SugarColumn(ColumnName = "loss_percent")]
+ public string? LossPercent { get; set; }
+
+ /// <summary>
+ /// 鍔╄鐮�
+ /// </summary>
+ [SugarColumn(ColumnName = "mnemonic_code")]
+ public string? MnemonicCode { get; set; }
+
+ /// <summary>
+ /// 淇濊川鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "exp_period")]
+ public string? ExpPeriod { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇杞﹂棿
+ /// </summary>
+ [SugarColumn(ColumnName = "production_workshop")]
+ public string? ProductionWorkshop { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡灞炴��
+ /// </summary>
+ [SugarColumn(ColumnName = "material_properti")]
+ public string? MaterialProperti { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "produce_unit")]
+ public string? ProduceUnit { get; set; }
+
+ /// <summary>
+ /// 濮斿鍗曚綅
+ /// </summary>
+ [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>
+ /// 浣跨敤绲勭箶
+ /// </summary>
+ [SugarColumn(ColumnName = "FSubsidiary")]
+ public string? FSubsidiary { get; set; }
+
+ /// <summary>
+ /// 鍓靛缓绲勭箶
+ /// </summary>
+ [SugarColumn(ColumnName = "Fumbrella")]
+ public string? Fumbrella { get; set; }
+
+
+ [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
+}
\ No newline at end of file
--
Gitblit v1.9.3