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

}