using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using WIDESEA_Common; using WIDESEA_Common.CommonEnum; using WIDESEA_Common.MaterielEnum; using WIDESEA_Core.DB.Models; namespace WIDESEA_Model.Models { [SugarTable("Dt_MedicineGoods", "药品基础信息表")] public class Dt_MedicineGoods : BaseEntity { [SugarColumn(ColumnName = "Id", IsPrimaryKey = true, IsIdentity = true, ColumnDescription = "主键")] public int Id { get; set; } /// /// 仓库编号;库房编号 /// [SugarColumn(IsNullable = true, ColumnDescription = "仓库编号")] public int WarehouseId { get; set; } /// /// 物料编码 /// [SugarColumn(ColumnName = "Goods_no", IsNullable = true, Length = 50, ColumnDescription = "药品编码(唯一)")] public string Goods_no { get; set; } /// /// 货物类型/药品/器材 /// [SugarColumn(ColumnName = "MaterialCode", IsNullable = true, Length = 50, ColumnDescription = "货物类型/药品/器材")] public string MaterialCode { get; set; } /// /// 药品通用名 /// [SugarColumn(ColumnName = "Goods_tym", IsNullable = true, Length = 50, ColumnDescription = "药品通用名")] public string Goods_tym { get; set; } /// /// 药品名称 /// [SugarColumn(ColumnName = "Goods_spm", IsNullable = true, Length = 50, ColumnDescription = "药品名称")] public string Goods_spm { get; set; } /// /// 物料规格 /// [SugarColumn(ColumnName = "Model", IsNullable = true, Length = 70, ColumnDescription = "物料规格")] public string Model { get; set; } /// /// 物料基本分类(1:成品、2:半成品、3:原材料、4:备件);全部默认成品 /// [SugarColumn(IsNullable = false, ColumnDescription = "物料基本分类(1:成品、2:半成品、3:原材料、4:备件)")] public MaterielTypeEnum MaterielType { get; set; } = MaterielTypeEnum.FinishProduct; /// /// 物料属性分类(1:大件、2:小件) /// 大件只放平库,小件根据立库最低库存数和箱规(散货)区分是否入立库 /// [SugarColumn(IsNullable = false, ColumnDescription = "物料属性分类(1:大件、2:小件)")] public MaterielSourceTypeEnum MaterielSourceType { get; set; } /// /// 生产厂家 /// [SugarColumn(ColumnName = "Factory", IsNullable = true, Length = 50, ColumnDescription = "生产厂家")] public string Factory { get; set; } /// /// 计量单位 /// [SugarColumn(ColumnName = "Unit", IsNullable = true, Length = 20, ColumnDescription = "计量单位")] public string Unit { get; set; } /// /// 单品长度,毫米为单位 /// [SugarColumn(ColumnName = "Item_Iength", IsNullable = true, ColumnDescription = "单品长度,毫米为单位")] public decimal? Item_Iength { get; set; } /// /// 单品宽度,毫米为单位 /// [SugarColumn(ColumnName = "Item_width", IsNullable = true, ColumnDescription = "单品宽度,毫米为单位")] public decimal ?Item_width { get; set; } /// /// 单品高度,毫米为单位 /// [SugarColumn(ColumnName = "Item_hight", IsNullable = true, ColumnDescription = "单品高度,毫米为单位")] public decimal? Item_hight { get; set; } /// /// 单品体积,立方毫米为单位 /// [SugarColumn(ColumnName = "Item_volumn", IsNullable = true, ColumnDescription = "单品体积,立方毫米为单位")] public decimal ?Item_volumn { get; set; } /// /// 单品重量,克为单位 /// [SugarColumn(ColumnName = "Item_weight", IsNullable = true, ColumnDescription = "单品重量,克为单位")] public decimal ?Item_weight { get; set; } /// /// 储存条件 /// [SugarColumn(ColumnName = "Storage_cond", IsNullable = true, Length = 100, ColumnDescription = "储存条件")] public string Storage_cond { get; set; } /// /// 箱规 /// [SugarColumn(IsNullable = false, ColumnDescription = "箱规")] public decimal BoxQty { get; set; } /// /// 立库最低库存数 /// [SugarColumn(IsNullable = false, ColumnDescription = "立库最低库存数")] public decimal MinQty { get; set; } /// /// 立库业务库存数;根据出入库数量变化 /// [SugarColumn(IsNullable = false, ColumnDescription = "立库业务库存数")] public decimal Business_qty { get; set; } /// /// 立库最高库存数 /// [SugarColumn(IsNullable = true, ColumnDescription = "立库最高库存数")] public float? MaxQty { get; set; } /// /// 物料状态(0:禁用、1:可用) /// [SugarColumn(IsNullable = false, ColumnDescription = "物料状态(0:禁用、1:可用)")] public EnableEnum MaterielState { get; set; } [SugarColumn(ColumnName = "GoodStatus", IsNullable = true, Length = 50, ColumnDescription = "药品状态,是否下发给wcs,未下发,下发完成")] public string GoodStatus { get; set; } [SugarColumn(IsNullable = true, Length = 200, ColumnDescription = "备注")] public string Remark { get; set; } } }