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