1

huanghongfeng

2025-06-06 f5b8c1ae89286dada20ea433ffac84f4c9e72a29

 ´úÂë¹ÜÀí/WMS/WIDESEA_WMSServer/WIDESEA_TaskInfoService/Task_HtyService.cs

@@ -14,6 +14,7 @@
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Core;
using WIDESEA_Core.Attributes;
using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
using WIDESEA_Core.Enums;
@@ -96,7 +97,7 @@
            //获取排序字段
            Dictionary<string, OrderByType> orderbyDic = options.GetPageDataSort(TProperties);
            List<Dt_Task_Hty> entities = BaseDal.QueryData(wheres, orderbyDic);
            var stockdct = entities
            /*var stockdct = entities
                .GroupBy(x => new { x.TaskType,x.MaterialType })
                .Select(g => new Dt_Task_Htyt
                {
@@ -105,6 +106,30 @@
                    PalletCodequantity = g.Count(),
                })
                .ToList();

            byte[] data = exporter.ExportAsByteArray(stockdct).Result;*/

            var stockdct = entities
     .Select(g => new Dt_Task_Htykt
     {
         TaskNum = g.TaskNum,
         PalletCode = g.PalletCode,
         Roadway = g.Roadway,
         TaskType = g.TaskType.ToString() == "100" ? "出库" : g.TaskType.ToString() == "104" ? "出空托" : g.TaskType.ToString() == "200" ? "入库" : "移库",
         TaskStatus = g.TaskStatus.ToString()=="290"?"入库完成":"出库完成", // æˆ–者可以根据具体状态码转换
         SourceAddress = g.SourceAddress,
         TargetAddress = g.TargetAddress,
         Remark = g.Remark,
         Creater = g.Creater,
         CreateDate = g.CreateDate,
         Modifier = g.Modifier,
         ModifyDate = g.ModifyDate,
         MaterialType = g.MaterialType.ToString() == "0" ? "原材料" : "成品",
         PalletCodequantity = g.PalletCodequantity.ToString(), // è½¬æ¢ä¸ºå­—符串
         PLCTo = g.PLCTo.ToString(), // æˆ–者可以根据具体值转换
         OperateType = g.OperateType.ToString()
     })
     .ToList();

            byte[] data = exporter.ExportAsByteArray(stockdct).Result;

@@ -130,4 +155,56 @@
        [ExporterHeader(DisplayName = "数量")]
        public int PalletCodequantity { get; set; }
    }


    public class Dt_Task_Htykt
    {
        [ExporterHeader(DisplayName = "任务号")]
        public int TaskNum { get; set; }

        [ExporterHeader(DisplayName = "托盘编号")]
        public string PalletCode { get; set; }

        [ExporterHeader(DisplayName = "巷道号")]
        public string Roadway { get; set; }

        [ExporterHeader(DisplayName = "任务类型")]
        public string TaskType { get; set; }

        [ExporterHeader(DisplayName = "任务状态")]
        public string TaskStatus { get; set; }

        [ExporterHeader(DisplayName = "起始地址")]
        public string SourceAddress { get; set; }

        [ExporterHeader(DisplayName = "目标地址")]
        public string TargetAddress { get; set; }

        [ExporterHeader(DisplayName = "备注")]
        public string Remark { get; set; }

        [ExporterHeader(DisplayName = "创建人")]
        public string Creater { get; set; }

        [ExporterHeader(DisplayName = "创建时间")]
        public DateTime CreateDate { get; set; }

        [ExporterHeader(DisplayName = "修改人")]
        public string Modifier { get; set; }

        [ExporterHeader(DisplayName = "修改日期")]
        public DateTime? ModifyDate { get; set; }

        [ExporterHeader(DisplayName = "物料类型")]
        public string MaterialType { get; set; }

        [ExporterHeader(DisplayName = "托盘数量")]
        public string PalletCodequantity { get; set; }

        [ExporterHeader(DisplayName = "原材料去向")]
        public string PLCTo { get; set; }

        [ExporterHeader(DisplayName = "完成情况")]
        public string OperateType { get; set; }
    }
}