using Admin.NET.Application; using Admin.NET.Application.Entity; using Admin.NET.Core.Helper.ExcelHelper; using DocumentFormat.OpenXml.Wordprocessing; namespace Admin.NET.Application; /// /// ASN主表输出参数 /// public class WmsOrderAsnOutput { /// /// 主键Id /// public long? Id { get; set; } /// /// ASN单号 /// public string AsnNo { get; set; } /// /// 单据类型 /// public Admin.NET.Application.OrderTypeEnum AsnType { get; set; } /// /// 业务类型 /// public BusinessTypeEnum BusinessType { get; set; } /// /// 业务类型名称 /// public string BusinessTypeName { get; set; } /// /// 单据类型名称 /// public string AsnTypeName { get; set; } /// /// 单据状态 /// public Admin.NET.Application.OrderStatusEnum AsnStatus { get; set; } /// /// 单据状态名称 /// public string AsnStatusName { get; set; } /// /// 需求数量 /// public virtual decimal? Quantity { get; set; } /// /// 已收货数量 /// public virtual decimal? GoodsQuantity { get; set; } /// /// 物流单号 /// public string TrackingNumber { get; set; } /// /// 释放状态 /// public int? ReleaseStatus { get; set; } /// /// 释放状态名称 /// public string ReleaseStatusName { get; set; } /// /// 是否冻结 /// public bool? IsFreeze { get; set; } /// /// 操作原因 /// public string OperReason { get; set; } /// /// 工厂ID /// public long? FactoryId { get; set; } /// /// 工厂名称 /// public string FactoryName { get; set; } /// /// 工厂编号 /// public string FactoryCode { get; set; } /// /// 创建时间 /// public DateTime? CreateTime { get; set; } /// /// 修改时间 /// public DateTime? UpdateTime { get; set; } /// /// 创建人Id /// public long? CreateUserId { get; set; } /// /// 创建人 /// public string CreateUserName { get; set; } /// /// 修改人Id /// public long? UpdateUserId { get; set; } /// /// 修改人 /// public string UpdateUserName { get; set; } /// /// 软删除 /// public bool IsDelete { get; set; } /// /// 预计到达日期 /// public DateTime? EstimatedDate { get; set; } } public class WmsOrderAsnExcelOutput { /// /// ASN单号 /// [ExcelDataOption(DisplayName = "ASN单号", ColumnIndex = 1)] public string AsnNo { get; set; } /// /// 业务类型名称 /// [ExcelDataOption(DisplayName = "业务类型", ColumnIndex = 2)] public string BusinessTypeName { get; set; } /// /// 单据状态名称 /// [ExcelDataOption(DisplayName = "单据状态", ColumnIndex = 3)] public string AsnStatusName { get; set; } /// /// 创建时间 /// [ExcelDataOption(DisplayName = "创建时间", ColumnIndex = 4)] public DateTime? CreateTime { get; set; } /// /// 修改时间 /// [ExcelDataOption(DisplayName = "修改时间", ColumnIndex = 5)] public DateTime? UpdateTime { get; set; } /// /// 创建人 /// [ExcelDataOption(DisplayName = "创建人", ColumnIndex = 6)] public string CreateUserName { get; set; } /// /// 修改人 /// [ExcelDataOption(DisplayName = "修改人", ColumnIndex = 7)] public string UpdateUserName { get; set; } /// /// 物料编号 /// [ExcelDataOption(DisplayName = "物料编号", ColumnIndex = 8)] public string MaterialCode { get; set; } /// /// 物料名称 /// [ExcelDataOption(DisplayName = "物料名称", ColumnIndex = 9)] public string MaterialName { get; set; } /// /// 需求数量 /// [ExcelDataOption(DisplayName = "需求数量", ColumnIndex = 10)] public virtual decimal? Quantity { get; set; } /// /// 已收货数量 /// [ExcelDataOption(DisplayName = "已收货数量", ColumnIndex = 11)] public virtual decimal? GoodsQuantity { get; set; } /// /// Asn行号 /// [ExcelDataOption(DisplayName = "Asn行号", ColumnIndex = 12)] public string AsnLineNumber { get; set; } /// /// PO单号 /// [ExcelDataOption(DisplayName = "PO单号", ColumnIndex = 13)] public string? PoNo { get; set; } /// /// PO单行号 /// [ExcelDataOption(DisplayName = "PO单行号", ColumnIndex = 14)] public string? PoLineNumber { get; set; } /// /// 供应商编号 /// [ExcelDataOption(DisplayName = "供应商编号", ColumnIndex = 15)] public string SupplierCode { get; set; } /// /// 供应商名称 /// [ExcelDataOption(DisplayName = "供应商名称", ColumnIndex = 16)] public string SupplierName { get; set; } /// /// 采购单位 /// [ExcelDataOption(DisplayName = "采购单位", ColumnIndex = 17)] public string? POUnit { get; set; } /// /// 一维条码 /// [ExcelDataOption(DisplayName = "一维条码", ColumnIndex = 18)] public string? SN_1d { get; set; } /// /// 二维条码 /// [ExcelDataOption(DisplayName = "二维条码", ColumnIndex = 19)] public string? SN_2d { get; set; } /// /// 包装名称 /// [ExcelDataOption(DisplayName = "包装名称", ColumnIndex = 20)] public string? Package { get; set; } /// /// 计划开始时间 /// [ExcelDataOption(DisplayName = "计划开始时间", ColumnIndex = 21)] public DateTime? PlannedStartTime { get; set; } /// /// 计划结束时间 /// [ExcelDataOption(DisplayName = "计划结束时间", ColumnIndex = 22)] public DateTime? PlannedEndTime { get; set; } /// /// 项目号 /// [ExcelDataOption(DisplayName = "项目号", ColumnIndex = 23)] public string? ProjectNo { get; set; } /// /// 收货道口 /// [ExcelDataOption(DisplayName = "收货道口", ColumnIndex = 24)] public string? Dock { get; set; } /// /// 批次 /// [ExcelDataOption(DisplayName = "批次", ColumnIndex = 25)] public string? SupplierBatch { get; set; } /// /// 供应商批次 /// [ExcelDataOption(DisplayName = "供应商批次", ColumnIndex =26)] public string? Batch { get; set; } /// /// ERP库存地 /// [ExcelDataOption(DisplayName = "ERP库存地", ColumnIndex = 27)] public string? ErpCode { get; set; } /// /// ERP单号 /// [ExcelDataOption(DisplayName = "ERP单号", ColumnIndex = 28)] public string? ErpOrderNo { get; set; } } public class WmsOrderAsnExportOutput { public WmsOrderAsn OrderDeliver { get; set; } public List OrderDeliverDetails { get; set; } }