| | |
| | | // è·åææè®¢åID |
| | | var orderIds = pageData.Rows.Select(o => o.Id).ToList(); |
| | | |
| | | // æ¹éæ¥è¯¢ææå
³èçæç»ï¼è¿æ»¤æç©æç¼å·ä¸ºç©ºçæ°æ® |
| | | // æ¹éæ¥è¯¢ææå
³èçæç»ï¼æOutSGOrderIdååºãIdéåºæåºï¼ä¸è®¢åæç»é¡µé¢ä¿æä¸è´ |
| | | var allDetails = BaseDal.Db.Queryable<Dt_OutSGOrderDetail>() |
| | | .Where(d => orderIds.Contains(d.OutSGOrderId)) |
| | | .OrderBy(d => d.OutSGOrderId) |
| | | .OrderByDescending(d => d.Id) |
| | | .ToList(); |
| | | |
| | | // æè®¢åIDåç» |
| | | var detailsByOrderId = allDetails.GroupBy(d => d.OutSGOrderId).ToDictionary(g => g.Key, g => g.ToList()); |
| | | // æè®¢åIDåç»ï¼æ¯ç»æç»æIdéåºæåºï¼ä¸è®¢åæç»é¡µé¢ä¿æä¸è´ |
| | | var detailsByOrderId = allDetails.GroupBy(d => d.OutSGOrderId) |
| | | .ToDictionary(g => g.Key, g => g.OrderByDescending(d => d.Id).ToList()); |
| | | |
| | | // å¤çæ¯ä¸ªè®¢å |
| | | foreach (var order in pageData.Rows) |
| | |
| | | ? uniqueWidths[0] |
| | | : string.Join("/", uniqueWidths); |
| | | |
| | | // 设置æ¥å«ï¼åªæ¾ç¤ºä¸ä¸ªï¼å ä¸ºæææ¥å«ç¸åï¼ |
| | | order.BoardFluteNos = details.FirstOrDefault()?.BoardFluteNo ?? ""; |
| | | |
| | | // 设置æ¯å¦ç¼ºæï¼å¦ææä»»ä½ä¸ä¸ªæç»æ¯ç¼ºæç¶æï¼å°±è®¾ç½®ä¸ºtrue |
| | | // å¼ç¨WIDESEA_Common.OrderEnumå½åç©ºé´æ¥ä½¿ç¨OutOrderStatusEnumæä¸¾ |
| | | order.IsLackMaterial = details.Any(d => d.OutSGOrderDetailStatus == 3); // 3æ¯ç¼ºæç¶æçæä¸¾å¼ |
| | | |
| | | // çæç©æç¼ºæç¶æå符串ï¼ç©æç¼å·:ç¶æ,ç©æç¼å·:ç¶æ |
| | | var materialLackStatus = new List<string>(); |
| | | foreach (var detail in details) |
| | | { |
| | | var isLack = detail.OutSGOrderDetailStatus == 3; |
| | | materialLackStatus.Add($"{detail.MaterialNo}:{isLack.ToString().ToLower()}"); |
| | | } |
| | | order.MaterialLackStatus = string.Join(",", materialLackStatus); |
| | | } |
| | | else |
| | | { |
| | | order.MaterialNos = ""; |
| | | order.MaterialWides = ""; |
| | | order.IsLackMaterial = false; |
| | | order.MaterialLackStatus = ""; |
| | | } |
| | | } |
| | | } |
| | |
| | | try |
| | | { |
| | | //è·åæææç¨å |
| | | List<Dt_OutSGOrder> outSGOrders = BaseDal.Db.Queryable<Dt_OutSGOrder>().Includes(x => x.Details).ToList(); |
| | | List<Dt_OutSGOrderDetail> outSGOrderDetails= outSGOrders.SelectMany(x=>x.Details).ToList(); |
| | | //List<Dt_OutSGOrder> outSGOrders = BaseDal.Db.Queryable<Dt_OutSGOrder>().Includes(x => x.Details).ToList(); |
| | | //List<Dt_OutSGOrderDetail> outSGOrderDetails= outSGOrders.SelectMany(x=>x.Details).ToList(); |
| | | ////夿忮 |
| | | //Dt_OutSGOrderDetail? ExistAddOutOrderDetail = outSGOrderDetails.FirstOrDefault(x => outOrderDTOs.Select(t => t.BoardMpsDetailId).Distinct().Contains(x.BoardMpsDetailId)); |
| | | //if (ExistAddOutOrderDetail != null) |
| | |
| | | //夿工忝å¦å·²ç»åå¨ |
| | | if (ExistOutSGOrder != null) |
| | | { |
| | | outSGOrderDetail.Number = ExistOutSGOrder.Number; |
| | | ExistOutSGOrder.Details.Add(outSGOrderDetail); |
| | | } |
| | | else |
| | | { |
| | | Dt_OutSGOrder outSGOrder = _mapper.Map<Dt_OutSGOrder>(item); |
| | | outSGOrderDetail.Number = outSGOrder.Number; |
| | | outSGOrder.Details = new List<Dt_OutSGOrderDetail>() { outSGOrderDetail }; |
| | | AddOutSGOrders.Add(outSGOrder); |
| | | } |