| | |
| | | using System.Linq; |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | using WIDESEA_Common.CommonEnum; |
| | | using WIDESEA_Common.OrderEnum; |
| | | using WIDESEA_Common.StockEnum; |
| | | using WIDESEA_Common.WareHouseEnum; |
| | | using WIDESEA_Core; |
| | | using WIDESEA_Core.BaseRepository; |
| | | using WIDESEA_Core.BaseServices; |
| | | using WIDESEA_Core.Enums; |
| | | using WIDESEA_Core.Helper; |
| | | using WIDESEA_External.Model; |
| | | using WIDESEA_IApprovalRepository; |
| | | using WIDESEA_IBasicRepository; |
| | | using WIDESEA_ICheckRepository; |
| | | using WIDESEA_ICheckService; |
| | | using WIDESEA_IInboundRepository; |
| | |
| | | private readonly IPurchaseOrderDetailRepository _purchaseOrderDetailRepository; |
| | | private readonly IOutboundRepository _outboundRepository; |
| | | private readonly IStockRepository _stockRepository; |
| | | public CheckOrderResultService(ICheckOrderResultRepository BaseDal, IUnitOfWorkManage unitOfWorkManage, ICheckOrderRepository checkOrderRepository, IReceiveOrderRepository receiveOrderRepository, ICheckOrderService checkOrderService, IPurchaseOrderRepository purchaseOrderRepository, IPurchaseOrderDetailRepository purchaseOrderDetailRepository, IOutboundRepository outboundRepository, IStockRepository stockRepository) : base(BaseDal) |
| | | private readonly IWarehouseRepository _warehouseRepository; |
| | | private readonly IReceiveOrderDetailRepository _receiveOrderDetailRepository; |
| | | |
| | | public CheckOrderResultService(ICheckOrderResultRepository BaseDal, IUnitOfWorkManage unitOfWorkManage, ICheckOrderRepository checkOrderRepository, IReceiveOrderRepository receiveOrderRepository, ICheckOrderService checkOrderService, IPurchaseOrderRepository purchaseOrderRepository, IPurchaseOrderDetailRepository purchaseOrderDetailRepository, IOutboundRepository outboundRepository, IStockRepository stockRepository,IWarehouseRepository warehouseRepository, IReceiveOrderDetailRepository receiveOrderDetailRepository) : base(BaseDal) |
| | | { |
| | | _checkOrderRepository = checkOrderRepository; |
| | | _unitOfWorkManage = unitOfWorkManage; |
| | |
| | | _purchaseOrderDetailRepository = purchaseOrderDetailRepository; |
| | | _outboundRepository = outboundRepository; |
| | | _stockRepository = stockRepository; |
| | | _warehouseRepository=warehouseRepository; |
| | | _receiveOrderDetailRepository = receiveOrderDetailRepository; |
| | | } |
| | | |
| | | /// <summary> |
| | |
| | | { |
| | | return content.Error($"æªæ¾å°è¯¥è´¨æ£å"); |
| | | } |
| | | Dt_Warehouse warehouse = _warehouseRepository.QueryFirst(x => x.WarehouseId == checkOrder.WarehouseId); |
| | | Dt_ReceiveOrder receiveOrder = _receiveOrderRepository.Db.Queryable<Dt_ReceiveOrder>().Where(x => x.ReceiveOrderNo == checkOrder.ReceiveOrderNo).Includes(x => x.Details).First(); |
| | | if (receiveOrder.ReceiveOrderStatus!=ReceiveOrderStatusEnum.Completed.ObjToInt()) |
| | | { |
| | |
| | | } |
| | | return content; |
| | | } |
| | | public WebResponseContent CommitCheckResult(ERPCheckModel checkModel) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | Dt_CheckOrder checkOrder = _checkOrderRepository.QueryFirst(x => x.CheckOrderNo == checkModel.Code); |
| | | //è·åè´¨æ£å对åºçæ¶è´§å |
| | | if (checkOrder == null) |
| | | { |
| | | return content.Error($"æªæ¾å°è¯¥è´¨æ£å"); |
| | | } |
| | | Dt_Warehouse warehouse = _warehouseRepository.QueryFirst(x => x.WarehouseId == checkOrder.WarehouseId); |
| | | //è·åæ¶è´§å |
| | | Dt_ReceiveOrder receiveOrder = _receiveOrderRepository.Db.Queryable<Dt_ReceiveOrder>().Where(x => x.ReceiveOrderNo == checkOrder.ReceiveOrderNo).Includes(x => x.Details).First(); |
| | | if (receiveOrder.ReceiveOrderStatus != ReceiveOrderStatusEnum.Completed.ObjToInt()) |
| | | { |
| | | return content.Error($"{receiveOrder.ReceiveOrderNo}æ¶è´§åæªå®ææ æ³è´¨æ£"); |
| | | } |
| | | if (checkOrder.CheckOrderStatus == CheckOrderStatusEnum.Checked.ObjToInt()) |
| | | { |
| | | return content.Error($"è¯¥åæ®å·²ç»æ£éªå®æ"); |
| | | } |
| | | Dt_CheckOrderResult? checkOrderResult = null; |
| | | Dt_PurchaseOrder? purchaseOrder = null; |
| | | Dt_PurchaseOrderDetail? purchaseOrderDetail = null; |
| | | if (checkModel.Details.Count>0) |
| | | { |
| | | |
| | | ERPCheckResult eRPCheckResult = checkModel.Details.FirstOrDefault(); |
| | | if (eRPCheckResult.Result == CheckResultEnum.Return.ToString())//éè´§ |
| | | { |
| | | checkOrder.DefectedNote = eRPCheckResult.Result; |
| | | checkOrder.ReturnQuantity += (float)Convert.ToDecimal(eRPCheckResult.Quantity); |
| | | } |
| | | else |
| | | { |
| | | return content.Error($"æªæ¾å°ç¼ºé·ç±»å"); |
| | | } |
| | | //æ£éªç»æ |
| | | checkOrderResult = new Dt_CheckOrderResult() |
| | | { |
| | | Quantity = (float)Convert.ToDecimal(eRPCheckResult.Quantity), |
| | | CheckOrderId = checkOrder.CheckOrderId, |
| | | DefectCode = eRPCheckResult.DefectCode, |
| | | Result = eRPCheckResult.Result, |
| | | Note = eRPCheckResult.Note, |
| | | SampleCount = 0, |
| | | }; |
| | | //è·å对åºéè´åæ£é¤æ¶è´§æ°é |
| | | Dt_ReceiveOrderDetail receiveOrderDetail = receiveOrder.Details.First(x => x.RowNo == checkOrder.ReceiveDetailRowNo); |
| | | purchaseOrder = _purchaseOrderRepository.Db.Queryable<Dt_PurchaseOrder>().Where(x => x.PurchaseOrderNo == receiveOrderDetail.PurchaseOrderNo).Includes(x => x.Details).Where(x => x.Details.Any(v => v.RowNo == receiveOrderDetail.PurchaseOrderDetailRowNo)).First(); |
| | | if (purchaseOrder == null) |
| | | { |
| | | return content.Error("æªæ¾å°å¯¹åºæ¶è´§éè´å"); |
| | | } |
| | | purchaseOrderDetail = purchaseOrder.Details.FirstOrDefault(); |
| | | if (purchaseOrderDetail == null) |
| | | { |
| | | return content.Error("æªæ¾å°é货对åºçéè´åæç»"); |
| | | } |
| | | purchaseOrderDetail.PurchaseDetailReceiveQty -= (float)Convert.ToDecimal(eRPCheckResult.Quantity); |
| | | } |
| | | //夿æ£éªåæ ¼ç»æ |
| | | if (checkModel.Result == CheckAcceptEnum.Accept.ToString()) |
| | | { |
| | | checkOrder.Result = CheckAcceptEnum.Accept.ToString(); |
| | | } |
| | | else if (checkModel.Result == CheckAcceptEnum.UnAccept.ToString()) |
| | | { |
| | | checkOrder.Result = CheckAcceptEnum.UnAccept.ToString(); |
| | | } |
| | | else |
| | | { |
| | | return content.Error("æªæ¾å°æ£éªç±»å"); |
| | | } |
| | | checkOrder.CheckOrderStatus = CheckOrderStatusEnum.Checked.ObjToInt(); |
| | | List<Dt_ReceiveOrderDetail> receiveOrderDetails = new List<Dt_ReceiveOrderDetail>(); |
| | | //æ ¹æ®æ£éªæ°éæ£é¤åæ ¼æ°é |
| | | if (checkOrderResult != null) |
| | | { |
| | | checkOrder.QualifiedQuantity = checkOrder.ReceivedQuantity - checkOrderResult.Quantity; |
| | | //æ´æ°æ¶è´§æ£éªåæ ¼æ è¯ |
| | | if (warehouse.WarehouseCode == WarehouseEnum.HA152.ToString() || warehouse.WarehouseCode == WarehouseEnum.HA58.ToString()) |
| | | { |
| | | receiveOrderDetails = receiveOrder.Details.Where(x=>x.RowNo==checkOrder.ReceiveDetailRowNo).OrderByDescending(x => x.RowNo).Take((int)checkOrderResult.Quantity).ToList(); |
| | | receiveOrderDetails.ForEach(x => |
| | | { |
| | | x.IsCheckOk = WhetherEnum.True.ObjToInt(); |
| | | }); |
| | | } |
| | | } |
| | | else |
| | | { |
| | | checkOrder.QualifiedQuantity = checkOrder.ReceivedQuantity; |
| | | } |
| | | checkOrder.CheckUserName = App.User.UserName; |
| | | |
| | | _unitOfWorkManage.BeginTran(); |
| | | if (receiveOrderDetails.Count > 0) |
| | | { |
| | | _receiveOrderDetailRepository.UpdateData(receiveOrderDetails); |
| | | } |
| | | //æ´æ°éè´å |
| | | if (checkOrderResult != null && purchaseOrder != null && purchaseOrderDetail != null) |
| | | { |
| | | BaseDal.AddData(checkOrderResult); |
| | | if (purchaseOrder.PurchaseOrderStatus >= PurchaseOrderStatusEnum.Received.ObjToInt()) |
| | | { |
| | | purchaseOrder.PurchaseOrderStatus = PurchaseOrderStatusEnum.Receiving.ObjToInt(); |
| | | _purchaseOrderRepository.UpdateData(purchaseOrder); |
| | | } |
| | | if (purchaseOrderDetail.PurchaseDetailStatus == PurchaseOrderDetailStatusEnum.Received.ObjToInt()) |
| | | { |
| | | purchaseOrderDetail.PurchaseDetailStatus = PurchaseOrderDetailStatusEnum.Receiving.ObjToInt(); |
| | | } |
| | | _purchaseOrderDetailRepository.UpdateData(purchaseOrderDetail); |
| | | } |
| | | if (string.IsNullOrEmpty(checkModel.CreatorCode)) |
| | | { |
| | | //ERP䏿¥ |
| | | WebResponseContent responseContent = _checkOrderService.FeedbackCheckResult(checkOrder, checkOrderResult != null ? new List<Dt_CheckOrderResult> { checkOrderResult } : new List<Dt_CheckOrderResult>()); |
| | | if (!responseContent.Status) |
| | | { |
| | | throw new Exception(responseContent.Message); |
| | | } |
| | | } |
| | | checkOrder.UploadStatus = CheckUploadEnum.UploadOk.ObjToInt(); |
| | | _checkOrderRepository.UpdateData(checkOrder); |
| | | _unitOfWorkManage.CommitTran(); |
| | | content.OK(); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | _unitOfWorkManage.RollbackTran(); |
| | | return content.Error($"{ex.Message}"); |
| | | } |
| | | return content; |
| | | } |
| | | /// <summary> |
| | | /// æäº¤éæ£ç¡®è®¤ç»æ |
| | | /// </summary> |
| | |
| | | try |
| | | { |
| | | Dt_CheckOrder checkOrder = _checkOrderRepository.QueryFirst(x => x.CheckOrderId == checkOrderId); |
| | | //è·åè´¨æ£å对åºçæ¶è´§å |
| | | //è·åè´¨æ£å |
| | | if (checkOrder == null) |
| | | { |
| | | return content.Error($"æªæ¾å°è¯¥è´¨æ£å"); |
| | |
| | | { |
| | | return content.Error($"æ°éè¶
åº"); |
| | | } |
| | | if (checkResult.Result == InspectResultEnum.Return.ToString())//éè´§ |
| | | //夿æ£éªç»æ |
| | | if (checkResult.Result == InspectResultEnum.Return.ToString()) |
| | | { |
| | | checkOrder.DefectedNote = checkResult.Note; |
| | | checkOrder.ReturnQuantity += checkResult.Quantity; |
| | |
| | | Note = checkResult.Note, |
| | | SampleCount = checkResult.SampleCount, |
| | | }; |
| | | if (Math.Round(checkResult.Quantity,2) == Math.Round(stockInfoDetails.Sum(x=>x.StockQuantity),2)) |
| | | foreach (var item in stockInfo.Details) |
| | | { |
| | | DelStockDetails = stockInfo.Details; |
| | | } |
| | | else |
| | | { |
| | | foreach (var item in stockInfo.Details) |
| | | if (checkResult.Quantity == 0) |
| | | { |
| | | if (checkResult.Quantity == 0) |
| | | { |
| | | break; |
| | | } |
| | | else if(checkResult.Quantity< item.StockQuantity) |
| | | { |
| | | checkResult.Quantity = 0; |
| | | item.StockQuantity -= checkResult.Quantity; |
| | | stockInfoDetails.Add(item); |
| | | } |
| | | else if (checkResult.Quantity >= item.StockQuantity) |
| | | { |
| | | checkResult.Quantity = (float)Math.Round((checkResult.Quantity-item.StockQuantity), 2); |
| | | DelStockDetails.Add(item); |
| | | } |
| | | break; |
| | | } |
| | | else if (checkResult.Quantity < item.StockQuantity) |
| | | { |
| | | item.StockQuantity -= checkResult.Quantity; |
| | | item.OutboundQuantity = 0; |
| | | checkResult.Quantity = 0; |
| | | stockInfoDetails.Add(item); |
| | | } |
| | | else if (checkResult.Quantity >= item.StockQuantity) |
| | | { |
| | | checkResult.Quantity = (float)Math.Round((checkResult.Quantity - item.StockQuantity), 2); |
| | | DelStockDetails.Add(item); |
| | | } |
| | | } |
| | | |
| | | } |
| | | if (IsAccept == InspectAcceptEnum.Accept.ObjToInt()) |
| | | { |
| | |
| | | checkOrder.QualifiedQuantity = checkOrder.ReceivedQuantity; |
| | | } |
| | | checkOrder.CheckUserName = App.User.UserName; |
| | | List<Dt_StockInfoDetail> initialStockDetails = stockInfo.Details.Where(x=> !(stockInfoDetails.Select(v=>v.Id).ToList()).Contains(x.Id)).ToList(); |
| | | _unitOfWorkManage.BeginTran(); |
| | | |
| | | if (checkOrderResult != null) |
| | |
| | | //æ¸
é¤åºåæ°é |
| | | if (stockInfoDetails.Count>0) |
| | | { |
| | | stockInfoDetails.ForEach(x => |
| | | { |
| | | x.Status = StockStatusEmun.鿣åºå宿.ObjToInt(); |
| | | }); |
| | | _stockRepository.StockInfoDetailRepository.UpdateData(stockInfoDetails); |
| | | } |
| | | if (initialStockDetails.Count>0) |
| | | { |
| | | initialStockDetails.ForEach(x => |
| | | { |
| | | x.OutboundQuantity = 0; |
| | | x.Status = StockStatusEmun.鿣åºå宿.ObjToInt(); |
| | | }); |
| | | _stockRepository.StockInfoDetailRepository.UpdateData(initialStockDetails); |
| | | } |
| | | if (DelStockDetails.Count>0) |
| | | { |
| | |
| | | { |
| | | _stockRepository.StockInfoRepository.DeleteAndMoveIntoHty(stockInfo, App.User.UserId == 0 ? OperateTypeEnum.èªå¨å®æ : OperateTypeEnum.äººå·¥å®æ); |
| | | } |
| | | else |
| | | { |
| | | stockInfo.StockStatus = StockStatusEmun.鿣åºå宿.ObjToInt(); |
| | | _stockRepository.StockInfoRepository.UpdateData(stockInfo); |
| | | } |
| | | //ERP䏿¥ |
| | | WebResponseContent responseContent = _checkOrderService.FeedbackInspectResult(checkOrder, checkOrderResult != null ? new List<Dt_CheckOrderResult> { checkOrderResult } : new List<Dt_CheckOrderResult>()); |
| | | if (!responseContent.Status) |