From b884e533c4d906d3e004ea51750591f04863f881 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 22 八月 2025 19:37:06 +0800
Subject: [PATCH] 基础资料的更新
---
MES.Service/Modes/MesItems.cs | 328 ++++++++++++++++++++----------------------------------
1 files changed, 120 insertions(+), 208 deletions(-)
diff --git a/MES.Service/Modes/MesItems.cs b/MES.Service/Modes/MesItems.cs
index 712d2bb..104fac4 100644
--- a/MES.Service/Modes/MesItems.cs
+++ b/MES.Service/Modes/MesItems.cs
@@ -9,412 +9,324 @@
public class MesItems
{
/// <summary>
- /// </summary>
+ ///
+ /// 榛樿鍊�: (newid())
+ ///</summary>
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
public Guid Guid { get; set; }
/// <summary>
- /// 鐗╂枡ID
- /// </summary>
+ /// 鐗╂枡ID
+ ///</summary>
[SugarColumn(ColumnName = "id")]
- public decimal Id { get; set; }
+ public long 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>
+ /// 鐗╂枡绠�绉�
+ ///</summary>
[SugarColumn(ColumnName = "item_sname")]
public string? ItemSname { get; set; }
/// <summary>
- /// 瑙勬牸鍨嬪彿
- /// </summary>
+ /// 瑙勬牸鍨嬪彿
+ ///</summary>
[SugarColumn(ColumnName = "item_model")]
public string? ItemModel { get; set; }
/// <summary>
- /// 鐗╂枡鎻忚堪
- /// </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>
+ /// 鐗╂枡绫诲瀷
+ ///</summary>
[SugarColumn(ColumnName = "item_type")]
public string? ItemType { get; set; }
/// <summary>
- /// 浜у搧鐗堟湰
- /// </summary>
+ /// 浜у搧鐗堟湰
+ ///</summary>
[SugarColumn(ColumnName = "item_version")]
public string? ItemVersion { get; set; }
/// <summary>
- /// 瀹㈡埛缂栧彿
- /// </summary>
+ /// 瀹㈡埛缂栧彿
+ ///</summary>
[SugarColumn(ColumnName = "cust_no")]
public string? CustNo { get; set; }
/// <summary>
- /// 鍒涘缓浜�
- /// </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; }
+ public decimal? Lowlimit { get; set; }
/// <summary>
- /// 鏈�澶у簱瀛�
- /// </summary>
+ /// 鏈�澶у簱瀛�
+ ///</summary>
[SugarColumn(ColumnName = "highlimit")]
- public double? Highlimit { get; set; }
+ public decimal? Highlimit { get; set; }
/// <summary>
- /// 鏈�灏忓寘瑁呮暟
- /// </summary>
+ /// 鏈�灏忓寘瑁呮暟
+ ///</summary>
[SugarColumn(ColumnName = "prd_pack")]
- public double? PrdPack { get; set; }
+ public decimal? PrdPack { get; set; }
/// <summary>
- /// 璁㈠崟鍗曚綅
- /// </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>
- /// 鐗╂枡ID
- /// </summary>
+ /// 鐗╂枡ID
+ ///</summary>
[SugarColumn(ColumnName = "e_item_id")]
public long? EItemId { get; set; }
/// <summary>
- /// ERP鏂欏彿
- /// </summary>
+ /// ERP鏂欏彿
+ ///</summary>
[SugarColumn(ColumnName = "erp_item_no")]
public string? ErpItemNo { get; set; }
/// <summary>
- /// 榛樿浠撳簱
- /// </summary>
+ /// 榛樿浠撳簱id
+ ///</summary>
[SugarColumn(ColumnName = "depot_code")]
public string? DepotCode { get; set; }
/// <summary>
- /// 鐗╂枡鍒嗙被缂栧彿
- /// </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; }
+ public int? 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; }
/// <summary>
- /// 閲囪喘鍗曚綅
- /// </summary>
+ /// 閲囪喘鍗曚綅
+ ///</summary>
[SugarColumn(ColumnName = "fpurchaseunitid")]
- public decimal Fpurchaseunitid { get; set; }
+ public string? Fpurchaseunitid { get; set; }
/// <summary>
- /// 鎹熻�楃巼
- /// </summary>
+ /// 鎹熻�楃巼
+ ///</summary>
[SugarColumn(ColumnName = "loss_percent")]
public string? LossPercent { get; set; }
/// <summary>
- /// 鍔╄鐮�
- /// </summary>
+ /// 鍔╄鐮�
+ ///</summary>
[SugarColumn(ColumnName = "mnemonic_code")]
public string? MnemonicCode { get; set; }
/// <summary>
- /// 淇濊川鏈�
- /// </summary>
+ /// 淇濊川鏈�
+ ///</summary>
[SugarColumn(ColumnName = "exp_period")]
public string? ExpPeriod { 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>
- /// 鍥剧墖1
- /// </summary>
+ /// 鍥剧墖1
+ ///</summary>
[SugarColumn(ColumnName = "bz06")]
public string? Bz06 { get; set; }
/// <summary>
- /// 鍥剧墖2
- /// </summary>
+ /// 鍥剧墖2
+ ///</summary>
[SugarColumn(ColumnName = "bz07")]
public string? Bz07 { get; set; }
/// <summary>
- /// 鍥剧墖3
- /// </summary>
+ /// 鍥剧墖3
+ ///</summary>
[SugarColumn(ColumnName = "bz08")]
public string? Bz08 { get; set; }
/// <summary>
- /// 鍥剧墖4
- /// </summary>
+ /// 鍥剧墖4
+ ///</summary>
[SugarColumn(ColumnName = "bz09")]
public string? Bz09 { get; set; }
/// <summary>
- /// 鍥剧墖5
- /// </summary>
+ /// 鍥剧墖5
+ ///</summary>
[SugarColumn(ColumnName = "bz10")]
public string? Bz10 { get; set; }
/// <summary>
- /// QC鍒嗙粍ID
- /// </summary>
+ /// QC鍒嗙粍ID
+ ///</summary>
[SugarColumn(ColumnName = "qc_teamid")]
public string? QcTeamid { get; set; }
/// <summary>
- /// 鐗╂枡ID
- /// </summary>
+ /// 鐗╂枡ID
+ ///</summary>
[SugarColumn(ColumnName = "item_id")]
public long? ItemId { get; set; }
/// <summary>
- /// 棰滆壊
- /// </summary>
+ /// 棰滆壊
+ ///</summary>
[SugarColumn(ColumnName = "color_name")]
public string? ColorName { get; set; }
/// <summary>
- /// 浣跨敤绲勭箶
- /// </summary>
+ /// 鍒涘缓缁勭粐
+ ///</summary>
+ [SugarColumn(ColumnName = "Fumbrella")]
+ public string? Fumbrella { get; set; }
+
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ ///</summary>
[SugarColumn(ColumnName = "FSubsidiary")]
public string? FSubsidiary { get; set; }
/// <summary>
- /// 鍓靛缓绲勭箶
- /// </summary>
- [SugarColumn(ColumnName = "Fumbrella")]
- public string? Fumbrella { get; set; }
+ /// 鍗曟嵁鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName = "DATA_TYPE")]
+ public string? DataType { get; set; }
[SugarColumn(IsIgnore = true)] public string? Type { get; set; }
-
-
-
- /// <summary>
- /// 浠撶鍛�
- /// </summary>
- [SugarColumn(ColumnName = "F_WPVT_BASE_QTR")]
- public string? F_WPVT_BASE_QTR { get; set; }
- /// <summary>
- /// 搴忓垪鍙风敓鎴愭椂鏈�
- /// </summary>
- [SugarColumn(ColumnName = "FSNCREATETIME")]
- public string? FSNCREATETIME { get; set; }
- /// <summary>
- /// 涓氬姟鑼冨洿
- /// </summary>
- [SugarColumn(ColumnName = "FSNMANAGETYPE")]
- public string? FSNMANAGETYPE { get; set; }
- /// <summary>
- /// 搴撳瓨绠＄悊
- /// </summary>
- [SugarColumn(ColumnName = "FISSNMANAGE")]
- public string? FISSNMANAGE { get; set; }
- /// <summary>
- /// 鐢熶骇杩芥函
- /// </summary>
- [SugarColumn(ColumnName = "FISSNPRDTRACY")]
- public string? FISSNPRDTRACY { get; set; }
- /// <summary>
- /// 搴忓垪鍙峰崟浣�
- /// </summary>
- [SugarColumn(ColumnName = "FSNUNIT")]
- public string? FSNUNIT { get; set; }
- /// <summary>
- /// 鍒堕�犵瓥鐣�
- /// </summary>
- [SugarColumn(ColumnName = "FMfgPolicyId")]
- public string? FMfgPolicyId { get; set; }
- /// <summary>
- /// 鏁版嵁鐘舵��
- /// </summary>
- [SugarColumn(ColumnName = "FDocumentStatus")]
- public string? FDocumentStatus { get; set; }
- /// <summary>
- /// 鏄惁鍏抽敭浠�
- /// </summary>
- [SugarColumn(ColumnName = "FIsKitting")]
- public string? FIsKitting { get; set; }
- /// <summary>
- /// 鍙负鑱斿壇浜у搧
- /// </summary>
- [SugarColumn(ColumnName = "FIsCoby")]
- public string? FIsCoby { get; set; }
- /// <summary>
- /// 瓒呭彂鎺у埗鏂瑰紡
- /// </summary>
- [SugarColumn(ColumnName = "FOverControlMode")]
- public string? FOverControlMode { get; set; }
- /// <summary>
- /// 鎹熻�楃巼
- /// </summary>
- [SugarColumn(ColumnName = "FLOSSPERCENT")]
- public string? FLOSSPERCENT { get; set; }
- /// <summary>
- /// 淇濊川鏈�
- /// </summary>
- [SugarColumn(ColumnName = "FExpPeriod")]
- public string? FExpPeriod { get; set; }
- /// <summary>
- /// 鏃х墿鏂欑紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "FOldNumber")]
- public string? FOldNumber { get; set; }
- /// <summary>
- /// 鏈�灏忓簱瀛�
- /// </summary>
- [SugarColumn(ColumnName = "FMinStock")]
- public string? FMinStock { get; set; }
- /// <summary>
- /// 鍏ュ簱娆犳敹姣斾緥(%)
- /// </summary>
- [SugarColumn(ColumnName = "FFinishReceiptShortRate")]
- public string? FFinishReceiptShortRate { get; set; }
-
- /// <summary>
- /// 榛樿渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "FDefaultVendor")]
- public string? FDefaultVendor { get; set; }
- /// <summary>
- /// 瀛愰」鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "FBOMUnitId")]
- public string? FBOMUnitId { get; set; }
-
-
-}
+}
\ No newline at end of file
--
Gitblit v1.9.3