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