using CMS.Plugin.HIAWms.Domain.Shared.Enums; using MiniExcelLibs.Attributes; namespace CMS.Plugin.HIAWms.Application.Contracts.Dtos.WmsMaterialStocks { /// /// WmsMaterialStocks导出模型 /// public class WmsMaterialStocksExportModel { /// /// WmsMaterialStock导出模型 /// public class WorkSectionExportModel { /// /// 物料编号(唯一标识) /// [ExcelColumn(Name = "物料编号", Width = 25)] public string MaterialNo { get; set; } /// /// 物料名称/描述 /// [ExcelColumn(Name = "物料名称", Width = 25)] public string MaterialName { get; set; } /// /// 容器/托盘编号 /// [ExcelColumn(Name = "容器编号", Width = 25)] public string ContainerNo { get; set; } /// /// 容器状态枚举值 /// 0-空容器 1-已装载 2-故障 /// [ExcelColumn(Name = "容器状态", Width = 25)] public ContainerStatusEnum ContainerStatus { get; set; } /// /// 容器类型枚举值 /// 1-托盘 2-料箱 3-周转箱 /// [ExcelColumn(Name = "容器类型", Width = 25)] public ContainerTypeEnum ContainerType { get; set; } /// /// 当前库存数量(整数) /// [ExcelColumn(Name = "库存数量", Width = 25)] public int StockNumber { get; set; } /// /// 物料批次号(LOT) /// [ExcelColumn(Name = "物料批次", Width = 25)] public string MaterialBatch { get; set; } /// /// 供应商编码(关联供应商表) /// [ExcelColumn(Name = "供应商编号", Width = 25)] public string SupplierCode { get; set; } /// /// 物料规格型号 /// [ExcelColumn(Name = "型号", Width = 25)] public string MaterialModel { get; set; } /// /// 库位编码(库位表外键) /// [ExcelColumn(Name = "库位编号", Width = 25)] public string PlaceNo { get; set; } /// /// 库位状态枚举值 /// 1-空闲 2-占用 3-禁用 /// [ExcelColumn(Name = "库位状态", Width = 25)] public PlaceStatusEnum PlaceStatus { get; set; } /// /// 库位类型枚举值 /// 1-平面库 2-立体库 3-重型货架 /// [ExcelColumn(Name = "库位类型", Width = 25)] public PlaceTypeEnum StorageTypeNo { get; set; } /// /// 所属库区编码(区域表外键) /// [ExcelColumn(Name = "区域编号", Width = 25)] public string AreaCode { get; set; } /// /// 库区名称(显示用) /// [ExcelColumn(Name = "库区名称", Width = 25)] public string AreaName { get; set; } /// /// 检验状态 /// public MaterialCheckStatusEnum? CheckStatus { get; set; } /// /// 锁定状态 /// 0-未锁定 1-已锁定 /// [ExcelColumn(Name = "是否锁定", Width = 25)] public YesNoEnum IsLock { get; set; } /// /// 是否空托 /// [ExcelColumn(Name = "是否空托", Width = 25)] public YesNoEnum EmptyContainer { get; protected set; } /// /// 最后入库时间(可为空) /// [ExcelColumn(Name = "入库时间", Width = 25, Format = "yyyy-MM-dd HH:mm")] public DateTime? InStockTime { get; set; } /// /// 显示排序序号 /// [ExcelColumn(Name = "排序", Width = 15)] public int Sort { get; set; } /// /// 备注信息 /// [ExcelColumn(Name = "备注", Width = 30)] public string Remark { get; set; } } } }