~tjx/NewPdaSqlServer.git

			@@ -1,273 +1,321 @@
			using 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; }
			}