using Admin.NET.Core.Helper.ExcelHelper;
|
using DocumentFormat.OpenXml.Wordprocessing;
|
|
namespace Admin.NET.Application;
|
|
/// <summary>
|
/// 移动单输出参数
|
/// </summary>
|
public class WmsOrderMovementOutput
|
{
|
/// <summary>
|
/// 主键Id
|
/// </summary>
|
public long? Id { get; set; }
|
|
/// <summary>
|
/// 移动单号
|
/// </summary>
|
public string OrderNo { get; set; }
|
|
/// <summary>
|
/// 单据类型
|
/// </summary>
|
public Admin.NET.Application.OrderTypeEnum OrderType { get; set; }
|
|
/// <summary>
|
/// 单据类型名称
|
/// </summary>
|
public string OrderTypeName { get; set; }
|
|
/// <summary>
|
/// 业务类型
|
/// </summary>
|
public Admin.NET.Application.BusinessTypeEnum BusinessType { get; set; }
|
|
/// <summary>
|
/// 业务类型名称
|
/// </summary>
|
public string BusinessTypeName { get; set; }
|
|
/// <summary>
|
/// 单据来源
|
/// </summary>
|
public Admin.NET.Application.SourceByEnum OrderSocure { get; set; }
|
|
/// <summary>
|
/// 单据状态
|
/// </summary>
|
public Admin.NET.Application.OrderStatusEnum OrderStatus { get; set; }
|
|
/// <summary>
|
/// 单据状态名称
|
/// </summary>
|
public string OrderStatusName { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
public DateTime? CreateTime { get; set; }
|
|
/// <summary>
|
/// 修改时间
|
/// </summary>
|
public DateTime? UpdateTime { get; set; }
|
|
/// <summary>
|
/// 创建人Id
|
/// </summary>
|
public long? CreateUserId { get; set; }
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
public string CreateUserName { get; set; }
|
|
/// <summary>
|
/// 修改人Id
|
/// </summary>
|
public long? UpdateUserId { get; set; }
|
|
/// <summary>
|
/// 修改人
|
/// </summary>
|
public string UpdateUserName { get; set; }
|
|
/// <summary>
|
/// 软删除
|
/// </summary>
|
public bool IsDelete { get; set; }
|
|
/// <summary>
|
/// 计划日期/交货日期
|
/// </summary>
|
public DateTime? PlannedDate { get; set; }
|
|
/// <summary>
|
/// 成本中心
|
/// </summary>
|
public string CostCenter { get; set; }
|
|
/// <summary>
|
/// ERP单号
|
/// </summary>
|
public string ErpOrderNo { get; set; }
|
|
/// <summary>
|
/// 客户发往地
|
/// </summary>
|
public string DeliveryAddress { get; set; }
|
|
/// <summary>
|
/// 财务类型
|
/// </summary>
|
public Admin.NET.Application.FinancialTypeEnum? FinancialType { get; set; }
|
|
/// <summary>
|
/// 财务类型名称
|
/// </summary>
|
public string FinancialTypeName { get; set; }
|
|
/// <summary>
|
/// 目标库位编码
|
/// </summary>
|
public string ToPlaceCode { get; set; }
|
|
/// <summary>
|
/// 目标库位名称
|
/// </summary>
|
public string ToPlaceName { get; set; }
|
|
/// <summary>
|
/// 目标仓库编号
|
/// </summary>
|
public string ToWarehouseCode { get; set; }
|
|
/// <summary>
|
/// 目标仓库名称
|
/// </summary>
|
public string ToWarehouseName { get; set; }
|
|
/// <summary>
|
/// 源仓库编号
|
/// </summary>
|
public string SourceWarehouseCode { get; set; }
|
|
/// <summary>
|
/// 源仓库名称
|
/// </summary>
|
public string SourceWarehouseName { get; set; }
|
|
/// <summary>
|
/// 源库区编码
|
/// </summary>
|
public string SourceAreaCode { get; set; }
|
|
/// <summary>
|
/// 源库区名称
|
/// </summary>
|
public string SourceAreaName { get; set; }
|
|
/// <summary>
|
/// 优先级
|
/// </summary>
|
public int? Priority { get; set; }
|
|
/// <summary>
|
/// 单据原因
|
/// </summary>
|
public string OrderReason { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
public string Remarks { get; set; }
|
|
/// <summary>
|
/// 往来单位类型
|
/// </summary>
|
public Admin.NET.Application.BaseCustomerTypeEnum? CustType { get; set; }
|
|
/// <summary>
|
/// 类型名称
|
/// </summary>
|
public string CustTypeName { get; set; }
|
|
/// <summary>
|
/// 往来单位编号
|
/// </summary>
|
public string CustCode { get; set; }
|
|
/// <summary>
|
/// 往来单位中文名称
|
/// </summary>
|
public string CustChinaName { get; set; }
|
|
/// <summary>
|
/// 往来单位英文名称
|
/// </summary>
|
public string CustEnglishName { get; set; }
|
|
/// <summary>
|
/// 目标库区编号
|
/// </summary>
|
public string ToAreaCode { get; set; }
|
|
/// <summary>
|
/// 目标库区名称
|
/// </summary>
|
public string ToAreaName { get; set; }
|
|
/// <summary>
|
/// 关联单号
|
/// </summary>
|
public string RelationNo { get; set; }
|
|
/// <summary>
|
/// 是否已分配
|
/// </summary>
|
public bool? IsDispense { get; set; }
|
|
}
|
|
|
|
public class WmsOrderMovementExcelOutput
|
{
|
|
/// <summary>
|
/// 移动单号
|
/// </summary>
|
///
|
[ExcelDataOption(DisplayName = "单号", ColumnIndex = 1)]
|
public string OrderNo { get; set; }
|
|
|
/// <summary>
|
/// 业务类型
|
/// </summary>
|
[ExcelDataOption(DisplayName = "业务类型", ColumnIndex = 2)]
|
public string BusinessTypeName { get; set; }
|
|
/// <summary>
|
/// 单据来源
|
/// </summary>
|
[ExcelDataOption(DisplayName = "单据来源", ColumnIndex = 3)]
|
public Admin.NET.Application.SourceByEnum OrderSocure { get; set; }
|
|
/// <summary>
|
/// 单据状态
|
/// </summary>
|
[ExcelDataOption(DisplayName = "单据状态", ColumnIndex = 4)]
|
public string OrderStatusName { get; set; }
|
|
/// <summary>
|
/// 计划日期/交货日期
|
/// </summary>
|
///
|
[ExcelDataOption(DisplayName = "计划日期/交货日期", ColumnIndex = 5)]
|
public DateTime? PlannedDate { get; set; }
|
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
[ExcelDataOption(DisplayName = "创建时间", ColumnIndex = 6)]
|
public DateTime? CreateTime { get; set; }
|
|
/// <summary>
|
/// 修改时间
|
/// </summary>
|
[ExcelDataOption(DisplayName = "修改时间", ColumnIndex = 7)]
|
public DateTime? UpdateTime { get; set; }
|
|
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
[ExcelDataOption(DisplayName = "创建人", ColumnIndex = 8)]
|
public string CreateUserName { get; set; }
|
|
|
/// <summary>
|
/// 修改人
|
/// </summary>
|
[ExcelDataOption(DisplayName = "修改人", ColumnIndex = 9)]
|
public string UpdateUserName { get; set; }
|
|
|
/// <summary>
|
/// 成本中心
|
/// </summary>
|
[ExcelDataOption(DisplayName = "成本中心", ColumnIndex = 10)]
|
public string CostCenter { get; set; }
|
|
|
|
|
|
|
/// <summary>
|
/// 物料编号
|
/// </summary>
|
[ExcelDataOption(DisplayName = "物料编号", ColumnIndex = 11)]
|
public string MaterialCode { get; set; }
|
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
[ExcelDataOption(DisplayName = "物料名称", ColumnIndex = 12)]
|
public string MaterialName { get; set; }
|
|
/// <summary>
|
/// 数量
|
/// </summary>
|
[ExcelDataOption(DisplayName = "数量", ColumnIndex = 13)]
|
public decimal Quantity { get; set; }
|
|
/// <summary>
|
/// 预配数
|
/// </summary>
|
[ExcelDataOption(DisplayName = "预配数", ColumnIndex = 14)]
|
public decimal? PredetermineQuantity { get; set; }
|
|
/// <summary>
|
/// 分配数
|
/// </summary>
|
[ExcelDataOption(DisplayName = "分配数", ColumnIndex = 15)]
|
public decimal? DispenseQuantity { get; set; }
|
|
|
/// <summary>
|
/// 拣货数
|
/// </summary>
|
[ExcelDataOption(DisplayName = "拣货数", ColumnIndex = 16)]
|
public decimal? PickQuantity { get; set; }
|
|
|
|
/// <summary>
|
/// 下架数
|
/// </summary>
|
[ExcelDataOption(DisplayName = "下架数", ColumnIndex = 17)]
|
public decimal? OffShelvesQuantity { get; set; }
|
|
|
/// <summary>
|
/// 创建波次数
|
/// </summary>
|
[ExcelDataOption(DisplayName = "波次数", ColumnIndex = 18)]
|
public decimal? CreateWaveQuantity { get; set; }
|
|
|
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[ExcelDataOption(DisplayName = "单位", ColumnIndex = 19)]
|
public string Unit { get; set; }
|
|
|
|
/// <summary>
|
/// ERP库存地
|
/// </summary>
|
[ExcelDataOption(DisplayName = "ERP库存地", ColumnIndex = 20)]
|
public string ErpCode { get; set; }
|
|
/// <summary>
|
/// 供应商批次
|
/// </summary>
|
[ExcelDataOption(DisplayName = "供应商批次", ColumnIndex = 21)]
|
public string SupplierBatch { get; set; }
|
|
/// <summary>
|
/// 批次
|
/// </summary>
|
[ExcelDataOption(DisplayName = "批次", ColumnIndex = 22)]
|
public string Batch { get; set; }
|
|
/// <summary>
|
/// 容器编号
|
/// </summary>
|
[ExcelDataOption(DisplayName = "容器编号", ColumnIndex = 23)]
|
public string ContainerCode { get; set; }
|
|
|
/// <summary>
|
/// 源库位编号
|
/// </summary>
|
[ExcelDataOption(DisplayName = "源库位编号", ColumnIndex = 24)]
|
public string SourcePlaceCode { get; set; }
|
|
|
|
|
/// <summary>
|
/// 关联单号
|
/// </summary>
|
[ExcelDataOption(DisplayName = "关联单号", ColumnIndex = 25)]
|
public string RelationNo { get; set; }
|
|
|
|
/// <summary>
|
/// ERP单号
|
/// </summary>
|
|
[ExcelDataOption(DisplayName = "ERP单号", ColumnIndex = 26)]
|
public string ErpOrderNo { get; set; }
|
|
|
|
|
/// <summary>
|
/// 目标库位名称
|
/// </summary>
|
[ExcelDataOption(DisplayName = "目标库位名称", ColumnIndex = 27)]
|
public string ToPlaceName { get; set; }
|
|
|
|
/// <summary>
|
/// 源库区编码
|
/// </summary>
|
[ExcelDataOption(DisplayName = "源库区编码", ColumnIndex = 28)]
|
public string SourceAreaCode { get; set; }
|
|
|
[ExcelDataOption(DisplayName = "供应商编号", ColumnIndex = 29)]
|
public string? SupplierCode { get; set; }
|
|
|
/// <summary>
|
/// 财务类型名称
|
/// </summary>
|
[ExcelDataOption(DisplayName = "财务类型", ColumnIndex = 30)]
|
public string FinancialTypeName { get; set; }
|
|
|
/// <summary>
|
/// 源仓库名称
|
/// </summary>
|
[ExcelDataOption(DisplayName = "源仓库名称", ColumnIndex = 31)]
|
public string SourceWarehouseName { get; set; }
|
|
|
|
/// <summary>
|
/// 目标库区编号
|
/// </summary>
|
[ExcelDataOption(DisplayName = "目标库区编号", ColumnIndex = 32)]
|
public string ToAreaCode { get; set; }
|
|
/// <summary>
|
/// 目标库位编号
|
/// </summary>
|
[ExcelDataOption(DisplayName = "目标库位编号", ColumnIndex = 33)]
|
public string ToPlaceCode { get; set; }
|
|
|
/// <summary>
|
/// 优先级
|
/// </summary>
|
[ExcelDataOption(DisplayName = "优先级", ColumnIndex = 34)]
|
public int? Priority { get; set; }
|
|
/// <summary>
|
/// 单据原因
|
/// </summary>
|
[ExcelDataOption(DisplayName = "单据原因", ColumnIndex = 35)]
|
public string OrderReason { get; set; }
|
|
|
|
|
// /// <summary>
|
// /// 客户发往地
|
// /// </summary>
|
// public string DeliveryAddress { get; set; }
|
|
// /// <summary>
|
// /// 财务类型
|
// /// </summary>
|
// public Admin.NET.Application.FinancialTypeEnum? FinancialType { get; set; }
|
|
// /// <summary>
|
// /// 目标仓库名称
|
// /// </summary>
|
// public string ToWarehouseName { get; set; }
|
|
// /// <summary>
|
// /// 源仓库编号
|
// /// </summary>
|
// public string SourceWarehouseCode { get; set; }
|
|
// /// <summary>
|
// /// 源库区名称
|
// /// </summary>
|
// public string SourceAreaName { get; set; }
|
|
|
|
|
// /// <summary>
|
// /// 备注
|
// /// </summary>
|
// public string Remarks { get; set; }
|
|
|
// /// <summary>
|
// /// 类型名称
|
// /// </summary>
|
// public string CustTypeName { get; set; }
|
|
// /// <summary>
|
// /// 往来单位编号
|
// /// </summary>
|
// public string CustCode { get; set; }
|
|
// /// <summary>
|
// /// 往来单位中文名称
|
// /// </summary>
|
// public string CustChinaName { get; set; }
|
|
// /// <summary>
|
// /// 往来单位英文名称
|
// /// </summary>
|
// public string CustEnglishName { get; set; }
|
|
|
|
|
|
// /// <summary>
|
// /// 是否已分配
|
// /// </summary>
|
// public bool? IsDispense { get; set; }
|
|
|
// public string? MovementNo { get; set; }
|
// /// <summary>
|
// /// 行号
|
// /// </summary>
|
// public string LineNumber { get; set; }
|
|
|
|
|
// /// <summary>
|
// /// 跟踪码
|
// /// </summary>
|
// public string SNCode { get; set; }
|
|
|
|
// /// <summary>
|
// /// 汇总踪码后同一种物料最终可用库存(已扣减预配锁定数) 预配库存数
|
// /// </summary>
|
// public decimal RealAvailableQty { get; set; }
|
|
// /// <summary>
|
// ///实物跟踪码可用库存（未扣减预配锁定数） 分配库存数
|
// /// </summary>
|
// public decimal AvailableQty { get; set; }
|
|
|
|
// /// <summary>
|
// /// 操作备注
|
// /// </summary>
|
// public string ActionRemark { get; set; }
|
|
// /// <summary>
|
// /// 操作时间
|
// /// </summary>
|
// public DateTime? ActionTime { get; set; }
|
|
|
// public string? RelationNoLineNumber { get; set; }
|
|
|
|
|
// public string? SupplierName { get; set; }
|
|
|
|
|
}
|
|
|
|
|
/// <summary>
|
/// 绑定物料输出参数
|
/// </summary>
|
public class WmsOrderMovementKcForMaterialOutput
|
{
|
|
public string MaterialCode { get; set; }
|
|
public string? MaterialName { get; set; }
|
|
|
public decimal RealAvailableQty { get; set; }
|
|
/// <summary>
|
/// 采购单位
|
/// </summary>
|
public string? POUnit { get; set; }
|
|
/// <summary>
|
/// 库存单位
|
/// </summary>
|
public string? MaterialUnit { get; set; }
|
|
}
|
