LINQ对查询出来的数据进行封装

对获取的数据进行封装

public PDA_ResponseBase_DTO_OP<List<PDA_PickPacage_LO_OP>> GetPackageVali(PDA_PickPacage_DTO_IP model)
        {
            PDA_ResponseBase_DTO_OP<List<PDA_PickPacage_LO_OP>> result = new PDA_ResponseBase_DTO_OP<List<PDA_PickPacage_LO_OP>>().SuccessResponse();
            var CarrierInfo = _userInfo.DriverCarrier.Where(b => b.CarrierID == model.CarrierID).FirstOrDefault();
            if (CarrierInfo == null)
                return result.ExceptionResponse("您没有操作的权限!");
            var boxList = new TransOrderPDAQuery().QueryPacage(model.PickDeliverOrderID, model.TransOrderIDs, model.CarrierID);
            List<PDA_PickPacage_LO_OP> retList = new List<PDA_PickPacage_LO_OP>();

            retList = boxList.GroupBy(b => new { b.TransOrderID, b.TransOrderCode, b.Weight, b.Volumn, b.Amount, b.DoubleAmount }).Select(b => new PDA_PickPacage_LO_OP
            {
                TransOrderID = b.Key.TransOrderID,
                TransOrderCode = b.Key.TransOrderCode,
                Amount = b.Key.Amount,
                Weight = b.Key.Weight,
                DoubleAmount = b.Key.DoubleAmount,
                Volumn = b.Key.Volumn,
                BoxEntityList = b.Select(d => new PDA_Package_LO_OP
                {
                    PackageID = d.PackageID,
                    PackageCode = d.PackageCode
                }).ToList()
            }).ToList();

            result.data = retList;
            return result;
        }

输出数据的实体

public class PDA_PickPacage_LO_OP
    {
        public string TransOrderCode { get; set; }
        public long TransOrderID { get; set; }
        public int Amount { get; set; }
        public int DoubleAmount { get; set; }
        public decimal Volumn { get; set; }
        public decimal Weight { get; set; }
        public List<PDA_Package_LO_OP> BoxEntityList { get; set; }
    }
    public class PDA_Package_LO_OP
    {
        public long PackageID { get; set; }
        public string PackageCode { get; set; }
    }

 

posted @ 2021-03-26 16:39  东方李  阅读(166)  评论(0)    收藏  举报