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; }
}
}