From eda0c8f74ce453b6e43f88fc92b1e651ce5b6095 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期四, 13 二月 2025 13:46:33 +0800
Subject: [PATCH] 1.条码表实体类型调整 2.条码库存表实体新增基础字段 3.期初入库新增入库人
---
entity/MesItems.cs | 586 +++++++++++++++++++++++++++++++--------------------------
1 files changed, 317 insertions(+), 269 deletions(-)
diff --git a/entity/MesItems.cs b/entity/MesItems.cs
index c89691a..8c10a32 100644
--- a/entity/MesItems.cs
+++ b/entity/MesItems.cs
@@ -1,273 +1,321 @@
锘縰sing SqlSugar;
-namespace NewPdaSqlServer.entity
+namespace NewPdaSqlServer.entity;
+
+/// <summary>
+/// </summary>
+[SugarTable("MES_ITEMS")]
+public class MesItems
{
/// <summary>
- ///
- ///</summary>
- [SugarTable("MES_ITEMS")]
- public class MesItems
- {
- /// <summary>
- ///
- /// 榛樿鍊�: (newid())
- ///</summary>
- [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
- public Guid Guid { get; set; }
- /// <summary>
- /// 鐗╂枡ID
- ///</summary>
- [SugarColumn(ColumnName="id" )]
- public long 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 decimal? Lowlimit { get; set; }
- /// <summary>
- /// 鏈�澶у簱瀛�
- ///</summary>
- [SugarColumn(ColumnName="highlimit" )]
- public decimal? Highlimit { get; set; }
- /// <summary>
- /// 鏈�灏忓寘瑁呮暟
- ///</summary>
- [SugarColumn(ColumnName="prd_pack" )]
- public decimal? 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 int? 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 string 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="Fumbrella" )]
- public string Fumbrella { get; set; }
- /// <summary>
- /// 浣跨敤缁勭粐
- ///</summary>
- [SugarColumn(ColumnName="FSubsidiary" )]
- public string FSubsidiary { get; set; }
- }
-}
+ /// 榛樿鍊�: (newid())
+ /// </summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "id")]
+ public long 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 decimal? Lowlimit { get; set; }
+
+ /// <summary>
+ /// 鏈�澶у簱瀛�
+ /// </summary>
+ [SugarColumn(ColumnName = "highlimit")]
+ public decimal? Highlimit { get; set; }
+
+ /// <summary>
+ /// 鏈�灏忓寘瑁呮暟
+ /// </summary>
+ [SugarColumn(ColumnName = "prd_pack")]
+ public decimal? 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 int? 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 string 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 = "Fumbrella")]
+ public string Fumbrella { get; set; }
+
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "FSubsidiary")]
+ public string FSubsidiary { get; set; }
+}
\ No newline at end of file
--
Gitblit v1.9.3