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; }
|
|
/// <summary>
|
/// 仓库编号；库房编号
|
/// </summary>
|
[SugarColumn(IsNullable = true, ColumnDescription = "仓库编号")]
|
public int WarehouseId { get; set; }
|
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "Goods_no", IsNullable = true, Length = 50, ColumnDescription = "药品编码（唯一）")]
|
public string Goods_no { get; set; }
|
|
|
/// <summary>
|
/// 货物类型/药品/器材
|
/// </summary>
|
[SugarColumn(ColumnName = "MaterialCode", IsNullable = true, Length = 50, ColumnDescription = "货物类型/药品/器材")]
|
public string MaterialCode { get; set; }
|
|
/// <summary>
|
/// 药品通用名
|
/// </summary>
|
[SugarColumn(ColumnName = "Goods_tym", IsNullable = true, Length = 50, ColumnDescription = "药品通用名")]
|
public string Goods_tym { get; set; }
|
|
|
/// <summary>
|
/// 药品名称
|
/// </summary>
|
[SugarColumn(ColumnName = "Goods_spm", IsNullable = true, Length = 50, ColumnDescription = "药品名称")]
|
public string Goods_spm { get; set; }
|
|
/// <summary>
|
/// 物料规格
|
/// </summary>
|
[SugarColumn(ColumnName = "Model", IsNullable = true, Length = 70, ColumnDescription = "物料规格")]
|
public string Model { get; set; }
|
|
/// <summary>
|
/// 物料基本分类(1:成品、2:半成品、3:原材料、4:备件)；全部默认成品
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "物料基本分类(1:成品、2:半成品、3:原材料、4:备件)")]
|
public MaterielTypeEnum MaterielType { get; set; } = MaterielTypeEnum.FinishProduct;
|
|
/// <summary>
|
/// 物料属性分类(1:大件、2:小件)
|
/// 大件只放平库，小件根据立库最低库存数和箱规(散货)区分是否入立库
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "物料属性分类(1:大件、2:小件)")]
|
public MaterielSourceTypeEnum MaterielSourceType { get; set; }
|
|
/// <summary>
|
/// 生产厂家
|
/// </summary>
|
[SugarColumn(ColumnName = "Factory", IsNullable = true, Length = 50, ColumnDescription = "生产厂家")]
|
public string Factory { get; set; }
|
|
|
/// <summary>
|
/// 计量单位
|
/// </summary>
|
[SugarColumn(ColumnName = "Unit", IsNullable = true, Length = 20, ColumnDescription = "计量单位")]
|
public string Unit { get; set; }
|
|
/// <summary>
|
/// 单品长度，毫米为单位
|
/// </summary>
|
[SugarColumn(ColumnName = "Item_Iength", IsNullable = true, ColumnDescription = "单品长度，毫米为单位")]
|
public decimal? Item_Iength { get; set; }
|
|
/// <summary>
|
/// 单品宽度，毫米为单位
|
/// </summary>
|
[SugarColumn(ColumnName = "Item_width", IsNullable = true, ColumnDescription = "单品宽度，毫米为单位")]
|
public decimal ?Item_width { get; set; }
|
|
|
/// <summary>
|
/// 单品高度，毫米为单位
|
/// </summary>
|
[SugarColumn(ColumnName = "Item_hight", IsNullable = true, ColumnDescription = "单品高度，毫米为单位")]
|
public decimal? Item_hight { get; set; }
|
|
|
/// <summary>
|
/// 单品体积，立方毫米为单位
|
/// </summary>
|
[SugarColumn(ColumnName = "Item_volumn", IsNullable = true, ColumnDescription = "单品体积，立方毫米为单位")]
|
public decimal ?Item_volumn { get; set; }
|
|
|
|
/// <summary>
|
/// 单品重量，克为单位
|
/// </summary>
|
[SugarColumn(ColumnName = "Item_weight", IsNullable = true, ColumnDescription = "单品重量，克为单位")]
|
public decimal ?Item_weight { get; set; }
|
|
/// <summary>
|
/// 储存条件
|
/// </summary>
|
[SugarColumn(ColumnName = "Storage_cond", IsNullable = true, Length = 100, ColumnDescription = "储存条件")]
|
public string Storage_cond { get; set; }
|
|
/// <summary>
|
/// 箱规
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "箱规")]
|
public decimal BoxQty { get; set; }
|
|
/// <summary>
|
/// 立库最低库存数
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "立库最低库存数")]
|
public decimal MinQty { get; set; }
|
|
/// <summary>
|
/// 立库业务库存数;根据出入库数量变化
|
/// </summary>
|
[SugarColumn(IsNullable = false, ColumnDescription = "立库业务库存数")]
|
public decimal Business_qty { get; set; }
|
|
/// <summary>
|
/// 立库最高库存数
|
/// </summary>
|
[SugarColumn(IsNullable = true, ColumnDescription = "立库最高库存数")]
|
public float? MaxQty { get; set; }
|
|
|
/// <summary>
|
/// 物料状态(0:禁用、1:可用)
|
/// </summary>
|
[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; }
|
|
|
}
|
}
|
