#region << 版 本 注 释 >> /*---------------------------------------------------------------- * 命名空间:WIDESEA_TaskInfoService * 创建者:胡童庆 * 创建时间:2024/8/2 16:13:36 * 版本:V1.0.0 * 描述: * * ---------------------------------------------------------------- * 修改人: * 修改时间: * 版本:V1.0.1 * 修改说明: * *----------------------------------------------------------------*/ #endregion << 版 本 注 释 >> using AutoMapper; using MailKit.Search; using Newtonsoft.Json; using OfficeOpenXml.FormulaParsing.Excel.Functions.Text; using SqlSugar; using System; using System.Collections.Generic; using System.ComponentModel; using System.Diagnostics.CodeAnalysis; using System.Linq; using System.Reflection; using System.Reflection.Metadata; using System.Text; using System.Threading.Tasks; using System.Transactions; using WIDESEA_Common.StockEnum; using WIDESEA_Common.TaskEnum; using WIDESEA_Core; using WIDESEA_Core.BaseRepository; using WIDESEA_Core.BaseServices; using WIDESEA_Core.Enums; using WIDESEA_Core.Helper; using WIDESEA_DTO.Inbound; using WIDESEA_DTO.Stock; using WIDESEA_DTO.WCSInfo; using WIDESEA_IBasicRepository; using WIDESEA_IBasicService; using WIDESEA_IInboundService; using WIDESEA_IOutboundRepository; using WIDESEA_IOutboundService; using WIDESEA_IRecordService; using WIDESEA_IStockRepository; using WIDESEA_IStockService; using WIDESEA_ITaskInfoRepository; using WIDESEA_ITaskInfoService; using WIDESEA_Model.Models; using WIDESEA_OutboundRepository; using WIDESEA_StockRepository; using WIDESEA_TaskInfoRepository; using WIDESEAWCS_DTO.WCSInfo; namespace WIDESEA_TaskInfoService { public partial class TaskService : ServiceBase, ITaskService { private readonly IMapper _mapper; private readonly IUnitOfWorkManage _unitOfWorkManage; private readonly IBasicService _basicService; private readonly IOutboundService _outboundService; private readonly IInboundService _inboundService; private readonly IRecordService _recordService; private readonly IStockService _stockService; private readonly IInventoryInfoRepository _inventoryInfoRepository; private readonly IInventoryBatchRepository _inventoryBatchRepository; private readonly IBasicRepository _basicRepository; public ITaskRepository Repository => BaseDal; public TaskService(ITaskRepository BaseDal, IMapper mapper, IUnitOfWorkManage unitOfWorkManage, IBasicService basicService, IOutboundService outboundService, IInboundService inboundService, IRecordService recordService, IStockService stockService, IInventoryInfoRepository inventoryInfoRepository, IInventoryBatchRepository inventoryBatchRepository, IBasicRepository basicRepository) : base(BaseDal) { _mapper = mapper; _unitOfWorkManage = unitOfWorkManage; _basicService = basicService; _outboundService = outboundService; _inboundService = inboundService; _recordService = recordService; _inventoryInfoRepository = inventoryInfoRepository; _inventoryBatchRepository = inventoryBatchRepository; _stockService = stockService; _basicRepository = basicRepository; } /// /// 任务完成 /// /// 任务号 /// 返回处理结果 public WebResponseContent TaskCompleted(int taskNum) { try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum); if (task == null) { return WebResponseContent.Instance.Error("未找到任务信息"); } MethodInfo? methodInfo = GetType().GetMethod(((TaskTypeEnum)task.TaskType) + "TaskCompleted"); if (methodInfo != null) { WebResponseContent? responseContent = (WebResponseContent?)methodInfo.Invoke(this, new object[] { task }); if (responseContent != null) { return responseContent; } } return WebResponseContent.Instance.Error("未找到任务类型对应业务处理逻辑"); } catch (Exception ex) { return WebResponseContent.Instance.Error(ex.Message); } } /// /// 入库任务完成 /// /// /// public WebResponseContent InboundTaskCompleted(Dt_Task task) { Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.GetStockInfo(task.PalletCode); Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.TargetAddress); CheckCompleted(stockInfo, locationInfo); stockInfo.LocationCode = locationInfo.LocationCode; stockInfo.StockStatus = StockStatusEmun.已入库.ObjToInt(); _stockService.StockInfoService.Repository.UpdateData(stockInfo); int beforeStatus = locationInfo.LocationStatus; locationInfo.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); _basicService.LocationInfoService.Repository.UpdateData(locationInfo); BaseDal.DeleteData(task); _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, beforeStatus, StockChangeType.Inbound.ObjToInt(), stockInfo.Details.FirstOrDefault()?.OrderNo ?? "", task.TaskNum); return WebResponseContent.Instance.OK(); } /// /// 空托盘入库完成处理 /// /// 任务实体对象 /// 返回处理结果 public WebResponseContent PalletInboundTaskCompleted(Dt_Task task) { Dt_StockInfo stockInfo = new Dt_StockInfo() { PalletCode = task.PalletCode, LocationCode = task.TargetAddress, StockStatus = StockStatusEmun.已入库.ObjToInt() }; Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.TargetAddress); CheckCompleted(stockInfo, locationInfo); _stockService.StockInfoService.Repository.AddData(stockInfo); int beforeStatus = locationInfo.LocationStatus; locationInfo.LocationStatus = LocationStatusEnum.Pallet.ObjToInt(); _basicService.LocationInfoService.Repository.UpdateData(locationInfo); BaseDal.DeleteData(task); _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, beforeStatus, StockChangeType.Inbound.ObjToInt(), "", task.TaskNum); return WebResponseContent.Instance.OK(); } /// /// 验证数据 /// /// /// /// private (bool, string) CheckCompleted(Dt_StockInfo stockInfo, Dt_LocationInfo locationInfo, bool isCheckStockDetail = true) { if (stockInfo == null) { return (false, "未找到组盘信息"); } if (locationInfo == null) { return (false, "未找到货位信息"); } if (isCheckStockDetail && (stockInfo.Details == null || stockInfo.Details.Count == 0)) { return (false, "未找到组盘明细信息"); } return (true, "成功"); } /// /// 出库任务完成 /// /// /// public WebResponseContent OutboundTaskCompleted(Dt_Task task) { Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.GetStockInfo(task.PalletCode); Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.SourceAddress); CheckCompleted(stockInfo, locationInfo); stockInfo.LocationCode = locationInfo.LocationCode; stockInfo.StockStatus = StockStatusEmun.出库完成.ObjToInt(); _stockService.StockInfoService.Repository.UpdateData(stockInfo); int beforeStatus = locationInfo.LocationStatus; locationInfo.LocationStatus = LocationStatusEnum.Free.ObjToInt(); _basicService.LocationInfoService.Repository.UpdateData(locationInfo); BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, beforeStatus, StockChangeType.Inbound.ObjToInt(), stockInfo.Details.FirstOrDefault()?.OrderNo ?? "", task.TaskNum); return OnOutboundTaskCompleted?.Invoke(task) ?? WebResponseContent.Instance.OK(); } /// /// 托盘出库任务完成 /// /// /// public WebResponseContent PalletOutboundTaskCompleted(Dt_Task task) { Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.GetStockInfo(task.PalletCode); Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.SourceAddress); CheckCompleted(stockInfo, locationInfo); _stockService.StockInfoService.Repository.DeleteData(stockInfo); int beforeStatus = locationInfo.LocationStatus; locationInfo.LocationStatus = LocationStatusEnum.Free.ObjToInt(); _basicService.LocationInfoService.Repository.UpdateData(locationInfo); BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); _recordService.LocationStatusChangeRecordSetvice.AddLocationStatusChangeRecord(locationInfo, beforeStatus, StockChangeType.Inbound.ObjToInt(), stockInfo.Details.FirstOrDefault()?.OrderNo ?? "", task.TaskNum); return WebResponseContent.Instance.OK(); } public WebResponseContent OutQC(string batchNo, int qty) { WebResponseContent webResponse = new WebResponseContent().OK(); try { Dt_Inventory_Batch inventory_Batch = _inventoryBatchRepository.QueryFirst(x => x.BatchNo == batchNo); if (inventory_Batch == null) return webResponse.Error($"未找到批号【{batchNo}】的库存批次信息"); if (inventory_Batch.ProductStatus != ProductStatusEmun.待检1.ObjToInt()) return webResponse.Error($"批号【{batchNo}】已质检入库"); List _InventoryInfos = _inventoryInfoRepository.QueryData(x => x.BatchNo == batchNo && x.StockStatus == StockStatusEmun.已入库.ObjToInt()).OrderByDescending(x => x.InDate).Take(qty).ToList(); if (_InventoryInfos.Count < 1) return webResponse.Error($"未找到批号【{batchNo}】的库存"); Dt_LocationInfo locationInfo = _basicRepository.LocationInfoRepository.QueryFirst(x => x.LocationCode == _InventoryInfos.First().LocationCode); List tasks = new List(); List OutStockLockInfos = new List(); #region 生成质检出库单 Dt_OutboundOrderDetail orderDetail = new Dt_OutboundOrderDetail() { BatchNo = batchNo, Creater = "System", OrderDetailStatus = OrderDetailStatusEnum.Outbound.ObjToInt() }; Dt_OutboundOrder outboundOrder = new Dt_OutboundOrder() { CreateType = CreateType.CreateInSystem.ObjToInt(), OrderStatus = OutboundStatusEnum.出库中.ObjToInt(), OrderNo = batchNo, OrderType = OutOrderTypeEnum.Quality.ObjToInt(), Creater = "System", Details = new List() { orderDetail } }; #endregion foreach (var item in _InventoryInfos) { orderDetail.MaterielCode = item.MaterielCode; orderDetail.MaterielName = item.MaterielName; orderDetail.OrderQuantity += item.StockQuantity; orderDetail.LockQuantity += item.StockQuantity; item.OutboundQuantity = item.StockQuantity; item.StockStatus = StockStatusEmun.出库中.ObjToInt(); Dt_Task task = new Dt_Task() { CurrentAddress = item.LocationCode, Grade = 0, PalletCode = item.PalletCode, SourceIsPickPlace = item.SerialNumber == locationInfo.MaxQty, NextAddress = "1005", Roadway = "SC01", SourceAddress = item.LocationCode, TargetAddress = "1005", TaskState = OutTaskStatusEnum.OutNew.ObjToInt(), TaskType = TaskTypeEnum.OutQuality.ObjToInt(), TaskNum = BaseDal.GetTaskNum(nameof(SequenceEnum.SeqTaskNum)) }; tasks.Add(task); #region 添加出库详情 Dt_OutStockLockInfo outStockLockInfo = new Dt_OutStockLockInfo() { PalletCode = item.PalletCode, AssignQuantity = item.OutboundQuantity, MaterielCode = item.MaterielCode, BatchNo = item.BatchNo, LocationCode = item.LocationCode, MaterielName = item.MaterielName, OrderDetailId = orderDetail.Id, OrderNo = outboundOrder.OrderNo, OrderType = outboundOrder.OrderType, OriginalQuantity = item.StockQuantity, Status = OutLockStockStatusEnum.出库中.ObjToInt(), StockId = item.Id, TaskNum = task.TaskNum, OrderQuantity = orderDetail.OrderQuantity }; OutStockLockInfos.Add(outStockLockInfo); #endregion } #region 生成质检入库单 Dt_InboundOrderDetail inboundOrderDetail = new Dt_InboundOrderDetail() { BatchNo = batchNo, Creater = "System", OrderDetailStatus = OrderDetailStatusEnum.New.ObjToInt(), MaterielName = orderDetail.MaterielName, MaterielCode = orderDetail.MaterielCode, OrderQuantity = orderDetail.OrderQuantity }; Dt_InboundOrder inboundOrder = new Dt_InboundOrder() { CreateType = CreateType.CreateInSystem.ObjToInt(), OrderStatus = InboundStatusEnum.未开始.ObjToInt(), OrderNo = batchNo, OrderType = InOrderTypeEnum.Quality.ObjToInt(), Creater = "System", Details = new List() { inboundOrderDetail } }; #endregion #region 处理库存和库存批次信息 inventory_Batch.StockQuantity = Convert.ToInt32(inventory_Batch.StockQuantity - orderDetail.OrderQuantity); inventory_Batch.BoxQuantity = inventory_Batch.StockQuantity / 8; if (inventory_Batch.StockQuantity % 8 > 0) inventory_Batch.BoxQuantity++; inventory_Batch.OutboundQuantity = Convert.ToInt32(inventory_Batch.OutboundQuantity + orderDetail.OrderQuantity); #endregion #region 事务处理 Db.Ado.BeginTran(); BaseDal.AddData(tasks); _outboundService.OutboundOrderService.Repository.Db.InsertNav(outboundOrder).Include(x => x.Details).ExecuteCommand(); _outboundService.OutboundStockLockInfoService.Repository.AddData(OutStockLockInfos); _inboundService.InbounOrderService.Repository.Db.InsertNav(inboundOrder).Include(x => x.Details).ExecuteCommand(); _inventoryInfoRepository.UpdateData(_InventoryInfos); _inventoryBatchRepository.UpdateData(inventory_Batch); #region 下发任务给WCS List wMSTaskDTOs = _mapper.Map>(tasks); var ResultData = HttpHelper.PostAsync(WCSInterfaceAddress.ReceiveTask, wMSTaskDTOs.ToJson(), headers: new Dictionary()); if (ResultData.Result == null) throw new Exception($"向WCS下发出库任务超时"); WebResponseContent content = JsonConvert.DeserializeObject(ResultData.Result); if (content == null) throw new Exception($"下发出库任务WCS无响应"); if (!content.Status) throw new Exception(content.Message); #endregion Db.Ado.CommitTran(); #endregion } catch (Exception ex) { Db.Ado.RollbackTran(); webResponse.Error(ex.Message); } return webResponse; } public WebResponseContent ModifyQty(string palletCode, int qty) { WebResponseContent webResponseContent = new WebResponseContent(); try { Dt_InventoryInfo inventoryInfo = _inventoryInfoRepository.QueryFirst(x => x.PalletCode == palletCode); if (inventoryInfo == null) throw new Exception("未找到托盘信息"); if (inventoryInfo.StockStatus != StockStatusEmun.组盘暂存.ObjToInt() && inventoryInfo.StockStatus != StockStatusEmun.入库确认.ObjToInt() && inventoryInfo.StockStatus != StockStatusEmun.入库中.ObjToInt()) throw new Exception($"托盘非入库中,不可修改数量"); Dt_InboundOrderDetail orderDetail = _inboundService.InboundOrderDetailService.Repository.QueryFirst(x => x.BatchNo == inventoryInfo.BatchNo); var StockQty = inventoryInfo.StockQuantity; inventoryInfo.StockQuantity = qty; inventoryInfo.BoxQuantity = qty % 8 > 0 ? qty / 8 + 1 : qty / 8; if (orderDetail != null) { orderDetail.ReceiptQuantity -= StockQty - qty; _inboundService.InboundOrderDetailService.Repository.UpdateData(orderDetail); } _inventoryInfoRepository.UpdateData(inventoryInfo); return webResponseContent.OK(); } catch (Exception ex) { return webResponseContent.Error(ex.Message); } } public WebResponseContent ModifyBarcode(string barcode, string newBarcode) { WebResponseContent webResponseContent = new WebResponseContent(); try { Dt_Task? dt_Task = BaseDal.QueryFirst(x => x.PalletCode == barcode); if (dt_Task == null) throw new Exception($"未找到托盘号为【{barcode}】的任务!"); if (TaskEnumHelper.GetTaskTypeGroup(dt_Task.TaskType) != TaskTypeGroup.InboundGroup) throw new Exception($"只可修改入库任务,如需修改其他任务类型请联系管理员!"); Dt_InventoryInfo inventoryInfo = _inventoryInfoRepository.QueryFirst(x => x.PalletCode == newBarcode); if (inventoryInfo != null) throw new Exception($"托盘号【{newBarcode}】已存在库存信息!"); inventoryInfo = _inventoryInfoRepository.QueryFirst(x => x.PalletCode == barcode); if (inventoryInfo == null) throw new Exception($"托盘号【{barcode}】未找到库存信息!"); inventoryInfo.PalletCode = newBarcode; //var stock = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == newBarcode); //if (stock != null) throw new Exception($"托盘号【{newBarcode}】已存在库存信息!"); //stock = _stockService.StockInfoService.Repository.QueryFirst(x => x.PalletCode == barcode); //if (stock == null) throw new Exception($"托盘号【{barcode}】未找到库存信息!"); //stock.PalletCode = newBarcode; dt_Task.PalletCode = newBarcode; Db.Ado.BeginTran(); WMSTaskDTO wMSTaskDTOs = _mapper.Map(dt_Task); var ResultData = HttpHelper.PostAsync(WCSInterfaceAddress.ModifyBarcode, wMSTaskDTOs.ToJson(), headers: new Dictionary()); if (ResultData.Result == null) throw new Exception($"WCS响应超时"); WebResponseContent content = JsonConvert.DeserializeObject(ResultData.Result); if (content == null) throw new Exception($"WCS无响应"); if (!content.Status) throw new Exception(content.Message); BaseDal.UpdateData(dt_Task); //_stockService.StockInfoService.Repository.UpdateData(stock); _inventoryInfoRepository.UpdateData(inventoryInfo); Db.Ado.CommitTran(); webResponseContent.OK(); } catch (Exception ex) { Db.Ado.RollbackTran(); webResponseContent.Error(ex.Message); } return webResponseContent; } public WebResponseContent CancelTask(WMSTaskDTO WMStask) { WebResponseContent webResponseContent = new WebResponseContent(); try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == WMStask.TaskNum && x.TaskType == WMStask.TaskType); if (task == null) return WebResponseContent.Instance.Error("未找到任务信息"); Dt_StockInfo? _StockInfo = _stockService.StockInfoService.GetStockByPalletCode(task.PalletCode); if (_StockInfo != null) { Dt_StockInfoDetail? detail = _StockInfo.Details.FirstOrDefault(); if (detail != null) { Dt_InboundOrder dt_InboundOrder = _inboundService.InbounOrderService.GetInboundOrder(detail.OrderNo); Dt_InboundOrderDetail? inboundOrderDetail = dt_InboundOrder.Details.FirstOrDefault(x => x.BatchNo == detail.BatchNo); if (inboundOrderDetail != null) { inboundOrderDetail.ReceiptQuantity--; _inboundService.InboundOrderDetailService.Repository.UpdateData(inboundOrderDetail); } _stockService.StockInfoDetailService.Repository.DeleteAndMoveIntoHty(_StockInfo.Details, OperateType.AGV删除); } _stockService.StockInfoService.Repository.DeleteAndMoveIntoHty(_StockInfo, OperateType.AGV删除); } BaseDal.DeleteAndMoveIntoHty(task, /*App.User.UserId == 0 ? OperateType.自动完成 :*/ OperateType.AGV删除); } catch (Exception ex) { webResponseContent.Error(ex.Message); } return webResponseContent; } /// /// 同步任务状态 /// /// /// /// public WebResponseContent UpdateTaskStatus(WMSTaskDTO WMStask) { WebResponseContent content = new WebResponseContent(); try { Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == WMStask.TaskNum && x.TaskType == WMStask.TaskType); if (task == null) return WebResponseContent.Instance.Error("未找到任务信息"); if (TaskEnumHelper.GetTaskTypeGroup(task.TaskType) == TaskTypeGroup.InboundGroup) { int nextStatus = task.TaskState.GetNextNotCompletedStatus(); //if (WMStask.TaskState != nextStatus) return WebResponseContent.Instance.Error($"该任务状态有误,任务号:【{task.TaskNum}】,任务状态:【{task.TaskState}】"); //task.TaskState = nextStatus; task.TaskState = TaskInStatusEnum.InFinish.ObjToInt(); content = NewUpdateTaskStatusInFinish(task); } else if (TaskEnumHelper.GetTaskTypeGroup(task.TaskType) == TaskTypeGroup.OutbondGroup) { //int nextStatus = task.TaskState.GetNextNotCompletedStatus(); //if (WMStask.TaskState != nextStatus) return WebResponseContent.Instance.Error($"该任务状态有误,任务号:【{task.TaskNum}】,任务状态:【{task.TaskState}】"); //task.TaskState = nextStatus; task.TaskState = WMStask.TaskState; switch (task.TaskState) { case (int)TaskOutStatusEnum.SC_OutFinish://更新货位库存信息 content = NewUpdateTaskStatusSC_OutFinish(task); break; case (int)TaskOutStatusEnum.AGV_OutFinish: { task.CurrentAddress = WMStask.CurrentAddress; task.TargetAddress = WMStask.TargetAddress; task.NextAddress = string.Empty; content = UpdateData(task); } break; case (int)TaskOutStatusEnum.OutFinish: content = UpdateTaskStatusOutFinish(task); break; default: content = UpdateData(task); break; } } else if (task.TaskType == (int)TaskTypeEnum.Relocation) { task.TaskState = WMStask.TaskState; if (task.TaskState == (int)WIDESEA_Core.Enums.TaskRelocationStatusEnum.SC_RelocationFinish) content = UpdateTaskStatusRelocationCarFinish(task); else content = UpdateData(task); } } catch (Exception ex) { content.Error(ex.Message); } return content; } public WebResponseContent NewUpdateTaskStatusSC_OutFinish(Dt_Task task) { try { Dt_Inventory_Batch? inventory_Batch = null; Dt_OutboundOrderDetail? orderDetail = null; Dt_OutboundOrder? outboundOrder = null; Dt_InventoryInfo inventoryInfo = _inventoryInfoRepository.QueryFirst(x => x.PalletCode == task.PalletCode); if (inventoryInfo != null) { inventory_Batch = _inventoryBatchRepository.QueryFirst(x => x.BatchNo == inventoryInfo.BatchNo); orderDetail = _outboundService.OutboundOrderDetailService.Repository.QueryFirst(x => x.BatchNo == inventoryInfo.BatchNo); } Dt_LocationInfo Sourcelocation = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.SourceAddress); Dt_OutStockLockInfo outStockLockInfo = _outboundService.OutboundStockLockInfoService.Repository.QueryFirst(x => x.TaskNum == task.TaskNum && task.PalletCode == x.PalletCode); Db.Ado.BeginTran(); if (inventoryInfo != null) _inventoryInfoRepository.DeleteData(inventoryInfo); if (Sourcelocation != null) { if (BaseDal.QueryFirst(x => x.SourceAddress == task.SourceAddress && x.TaskState < TaskOutStatusEnum.SC_OutFinish.ObjToInt()) == null) Sourcelocation.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); Sourcelocation.CurrentQty--; if (Sourcelocation.CurrentQty <= 0) { Sourcelocation.CurrentQty = 0; Sourcelocation.LocationStatus = LocationStatusEnum.Free.ObjToInt(); Sourcelocation.EnableStatus = EnableStatusEnum.Normal.ObjToInt(); } _basicService.LocationInfoService.Repository.UpdateData(Sourcelocation); } if (inventory_Batch != null) { //inventory_Batch.StockQuantity -= inventoryInfo.StockQuantity; inventory_Batch.OutboundQuantity -= inventoryInfo.StockQuantity; if (inventory_Batch.StockQuantity == 0 && inventory_Batch.OutboundQuantity == 0) _inventoryBatchRepository.DeleteData(inventory_Batch); else _inventoryBatchRepository.UpdateData(inventory_Batch); } if (orderDetail != null) { if (outStockLockInfo != null) { outStockLockInfo.OrderDetailId = orderDetail.OrderId; _outboundService.OutboundStockLockInfoService.Repository.UpdateData(outStockLockInfo); } orderDetail.OverOutQuantity += inventoryInfo.StockQuantity; if (orderDetail.OverOutQuantity == orderDetail.OrderQuantity) { outboundOrder = _outboundService.OutboundOrderService.Repository.QueryFirst(x => x.Id == orderDetail.OrderId); if (outboundOrder != null) { outboundOrder.OrderStatus = OutboundStatusEnum.出库完成.ObjToInt(); _outboundService.OutboundOrderService.Repository.DeleteAndMoveIntoHty(outboundOrder, OperateType.自动完成); } orderDetail.OrderDetailStatus = OrderDetailStatusEnum.Over.ObjToInt(); _outboundService.OutboundOrderDetailService.Repository.DeleteAndMoveIntoHty(orderDetail, OperateType.自动完成); } else _outboundService.OutboundOrderDetailService.Repository.UpdateData(orderDetail); } task.CurrentAddress = "1005"; task.TargetAddress = "1008"; task.NextAddress = "1008"; UpdateData(task); Db.Ado.CommitTran(); return WebResponseContent.Instance.OK(); } catch (Exception ex) { Db.Ado.RollbackTran(); return WebResponseContent.Instance.Error(ex.Message); } } /// /// 修改任务状态为堆垛机出库完成 /// /// /// public WebResponseContent UpdateTaskStatusSC_OutFinish(Dt_Task task) { try { Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.GetStockInfo(task.PalletCode); Dt_LocationInfo Sourcelocation = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.SourceAddress); Dt_OutStockLockInfo outStockLockInfo = _outboundService.OutboundStockLockInfoService.Repository.QueryFirst(x => x.TaskNum == task.TaskNum); Db.Ado.BeginTran(); if (stockInfo != null) { _stockService.StockInfoService.Repository.DeleteAndMoveIntoHty(stockInfo, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); _stockService.StockInfoDetailService.Repository.DeleteAndMoveIntoHty(stockInfo.Details, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); } if (Sourcelocation != null) { /*if (task.TaskType == TaskOutboundTypeEnum.Outbound.ObjToInt())*/ if (BaseDal.QueryFirst(x => x.SourceAddress == task.SourceAddress && x.TaskState < TaskOutStatusEnum.SC_OutFinish.ObjToInt()) == null) Sourcelocation.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); Sourcelocation.CurrentQty--; if (Sourcelocation.CurrentQty <= 0) { Sourcelocation.CurrentQty = 0; Sourcelocation.LocationStatus = LocationStatusEnum.Free.ObjToInt(); Sourcelocation.EnableStatus = EnableStatusEnum.Normal.ObjToInt(); } _basicService.LocationInfoService.Repository.UpdateData(Sourcelocation); } if (outStockLockInfo != null) { outStockLockInfo.Status = OutLockStockStatusEnum.出库中.ObjToInt(); _outboundService.OutboundStockLockInfoService.Repository.UpdateData(outStockLockInfo); } UpdateData(task); Db.Ado.CommitTran(); return WebResponseContent.Instance.OK(); } catch (Exception ex) { Db.Ado.RollbackTran(); return WebResponseContent.Instance.Error(ex.Message); } } /// /// 更新出库任务状态完成 /// /// /// public WebResponseContent UpdateTaskStatusOutFinish(Dt_Task task) { try { Db.Ado.BeginTran(); Dt_OutStockLockInfo? outStockLockInfo = _outboundService.OutboundStockLockInfoService.Repository.QueryFirst(x => x.TaskNum == task.TaskNum && x.PalletCode == task.PalletCode); Dt_OutboundOrder? outboundOrder = null; Dt_OutboundOrderDetail? outboundOrderDetail = null; int overCount = 0; if (outStockLockInfo != null) { outboundOrderDetail = _outboundService.OutboundOrderDetailService.Repository.QueryFirst(x => x.Id == outStockLockInfo.OrderDetailId); if (outboundOrderDetail != null) { outboundOrder = Db.Queryable().Where(x => x.Id == outboundOrderDetail.OrderId).Includes(x => x.Details).First(); if (outboundOrder != null) { outboundOrderDetail.OverOutQuantity++; overCount = outboundOrder.Details.Where(x => x.OrderDetailStatus == OrderDetailStatusEnum.Over.ObjToInt()).Count(); if (outboundOrderDetail.OverOutQuantity == outboundOrderDetail.OrderQuantity) { var outboundOrderdetail = outboundOrder.Details.First(x => x.Id == outboundOrderDetail.Id); outboundOrderDetail.OrderDetailStatus = OrderDetailStatusEnum.Over.ObjToInt(); outboundOrderdetail.OverOutQuantity = outboundOrderDetail.OverOutQuantity; outboundOrderdetail.OrderDetailStatus = outboundOrderDetail.OrderDetailStatus; overCount++; } } } outStockLockInfo.Status = OutLockStockStatusEnum.出库完成.ObjToInt(); } if (outboundOrder != null && outboundOrder.Details.Count == overCount) { outboundOrder.OrderStatus = OutboundStatusEnum.出库完成.ObjToInt(); _outboundService.OutboundOrderDetailService.Repository.DeleteAndMoveIntoHty(outboundOrder.Details, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); outboundOrder.Details = null; _outboundService.OutboundOrderService.Repository.DeleteAndMoveIntoHty(outboundOrder, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); } else { if (outboundOrderDetail != null) _outboundService.OutboundOrderDetailService.Repository.UpdateData(outboundOrderDetail); } BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); if (outStockLockInfo != null) _outboundService.OutboundStockLockInfoService.Repository.UpdateData(outStockLockInfo); Db.Ado.CommitTran(); return WebResponseContent.Instance.OK(); } catch (Exception ex) { Db.Ado.RollbackTran(); return WebResponseContent.Instance.Error(ex.Message); } } /// /// 更新移库任务状态完成 /// /// /// public WebResponseContent UpdateTaskStatusRelocationCarFinish(Dt_Task task) { try { Dt_LocationInfo Sourcelocation = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.SourceAddress);//起始货位 Dt_LocationInfo Targetlocation = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.TargetAddress);//目标货位 Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.GetStockInfo(task.PalletCode);//托盘库存 Sourcelocation.CurrentQty--; //Targetlocation.CurrentQty++; stockInfo.LocationCode = Targetlocation.LocationCode; //stockInfo.SerialNumber = Targetlocation.CurrentQty; stockInfo.StockStatus = StockStatusEmun.已入库.ObjToInt(); if (Sourcelocation.CurrentQty == 0) Sourcelocation.LocationStatus = LocationStatusEnum.Free.ObjToInt(); Dt_Task _Task = BaseDal.QueryFirst(x => x.TaskNum != task.TaskNum && x.TaskType == task.TaskType && x.SourceAddress == Sourcelocation.LocationCode && x.TargetAddress == Targetlocation.LocationCode); if (_Task == null) { if (Targetlocation.CurrentQty == Targetlocation.MaxQty) Targetlocation.LocationStatus = LocationStatusEnum.Fullload.ObjToInt(); else Targetlocation.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); if (Sourcelocation.CurrentQty == 0) Sourcelocation.LocationStatus = LocationStatusEnum.Free.ObjToInt(); } task.CurrentAddress = task.NextAddress; task.NextAddress = string.Empty; task.ModifyDate = DateTime.Now; task.Modifier = "System"; Db.Ado.BeginTran(); _basicService.LocationInfoService.Repository.UpdateData(Sourcelocation); _basicService.LocationInfoService.Repository.UpdateData(Targetlocation); _stockService.StockInfoService.Repository.UpdateData(stockInfo); //BaseDal.DeleteAndMoveIntoHty(task, OperateType.自动完成); BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); Db.Ado.CommitTran(); return WebResponseContent.Instance.OK(); } catch (Exception ex) { Db.Ado.RollbackTran(); return WebResponseContent.Instance.Error(ex.Message); } } /// /// 更新入库任务状态完成 /// /// /// public WebResponseContent NewUpdateTaskStatusInFinish(Dt_Task task) { WebResponseContent content = new WebResponseContent().OK(); try { Dt_InventoryInfo inventoryInfo = _inventoryInfoRepository.QueryFirst(x => x.PalletCode == task.PalletCode); if (inventoryInfo == null) return content.Error("未找到托盘信息"); Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.TargetAddress);//货位 if (locationInfo == null) return content.Error("未找到货位信息"); if (task.TaskType == TaskTypeEnum.PalletInbound.ObjToInt()) { return content; } inventoryInfo.InDate = DateTime.Now; inventoryInfo.StockStatus = StockStatusEmun.已入库.ObjToInt(); int beforeStatus = locationInfo.LocationStatus; if (BaseDal.QueryFirst(x => x.TargetAddress == locationInfo.LocationCode && x.TaskNum != task.TaskNum) == null) locationInfo.LocationStatus = LocationStatusEnum.InStock.ObjToInt(); task.CurrentAddress = task.NextAddress; task.NextAddress = string.Empty; Dt_Inventory_Batch inventory_Batch = _inventoryBatchRepository.QueryFirst(x => x.BatchNo == inventoryInfo.BatchNo); Db.Ado.BeginTran(); if (inventory_Batch == null) { inventory_Batch = new Dt_Inventory_Batch() { BatchNo = inventoryInfo.BatchNo, BoxQuantity = inventoryInfo.BoxQuantity, MaterielCode = inventoryInfo.MaterielCode, MaterielName = inventoryInfo.MaterielName, OutboundQuantity = inventoryInfo.OutboundQuantity, StockQuantity = inventoryInfo.StockQuantity, ProductionDate = inventoryInfo.ProductionDate, ProductStatus = inventoryInfo.ProductStatus, ShelfLife = inventoryInfo.ShelfLife, ValidityPeriod = inventoryInfo.ValidityPeriod, Creater = "System" }; _inventoryBatchRepository.AddData(inventory_Batch); } else { inventory_Batch.BoxQuantity = inventory_Batch.BoxQuantity + inventoryInfo.BoxQuantity; inventory_Batch.StockQuantity = inventory_Batch.StockQuantity + inventoryInfo.StockQuantity; _inventoryBatchRepository.UpdateData(inventory_Batch); } BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); _basicService.LocationInfoService.Repository.UpdateData(locationInfo); _stockService.InventoryInfoService.Repository.UpdateData(inventoryInfo); Db.Ado.CommitTran(); } catch (Exception ex) { Db.Ado.RollbackTran(); } return content; } /// /// 更新入库任务状态完成 /// /// /// public WebResponseContent UpdateTaskStatusInFinish(Dt_Task task) { WebResponseContent content = new WebResponseContent().OK(); try { Dt_StockInfo stockInfo = _stockService.StockInfoService.Repository.GetStockInfo(task.PalletCode);//组盘库存 Dt_LocationInfo locationInfo = _basicService.LocationInfoService.Repository.QueryFirst(x => x.LocationCode == task.TargetAddress);//货位 var result = CheckCompleted(stockInfo, locationInfo); if (!result.Item1) throw new Exception(result.Item2); if (stockInfo.StockStatus != StockStatusEmun.入库中.ObjToInt()) throw new Exception($"托盘[{task.PalletCode}],该组盘状态不可入库"); Dt_StockInfoDetail stockInfoDetail = stockInfo.Details.FirstOrDefault(x => x.StockId == stockInfo.Id); List stockInfos = _stockService.StockInfoService.Repository.LocationCodesGetStockInfos(new List { stockInfo.LocationCode }).Where(x => x.StockStatus == StockStatusEmun.已入库.ObjToInt()).ToList(); if (task.TaskType == TaskTypeEnum.PalletInbound.ObjToInt()) { //stockInfo.SerialNumber = stockInfos.Count + 1; stockInfo.InDate = DateTime.Now; stockInfo.StockStatus = StockStatusEmun.已入库.ObjToInt(); stockInfoDetail.Status = StockStatusEmun.已入库.ObjToInt(); locationInfo.LocationStatus = LocationStatusEnum.Pallet.ObjToInt(); task.CurrentAddress = task.NextAddress; task.NextAddress = string.Empty; Db.Ado.BeginTran(); BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); _basicService.LocationInfoService.Repository.UpdateData(locationInfo); _stockService.StockInfoService.Repository.UpdateData(stockInfo); _stockService.StockInfoDetailService.Repository.UpdateData(stockInfoDetail); Db.Ado.CommitTran(); return content; } Db.Ado.BeginTran(); #region 入库单 Dt_InboundOrder inboundOrder = _inboundService.InbounOrderService.GetInboundOrder(stockInfoDetail.OrderNo); if (inboundOrder != null) { Dt_InboundOrderDetail inboundOrderDetail = inboundOrder.Details.FirstOrDefault(x => x.BatchNo == stockInfoDetail.BatchNo && x.MaterielCode == stockInfoDetail.MaterielCode); if (inboundOrderDetail != null) inboundOrderDetail.OrderDetailStatus = inboundOrderDetail.OverInQuantity == inboundOrderDetail.OrderQuantity ? OrderDetailStatusEnum.Over.ObjToInt() : OrderDetailStatusEnum.GroupAndInbound.ObjToInt(); if (inboundOrder.Details.FirstOrDefault(x => x.OrderDetailStatus != OrderDetailStatusEnum.Over.ObjToInt()) == null) { inboundOrder.OrderStatus = InboundStatusEnum.入库完成.ObjToInt(); } else if (inboundOrder.OrderStatus == InboundStatusEnum.未开始.ObjToInt()) { inboundOrder.OrderStatus = InboundStatusEnum.入库中.ObjToInt(); } if (inboundOrder.OrderStatus != InboundStatusEnum.入库完成.ObjToInt()) { _inboundService.InbounOrderService.Repository.UpdateData(inboundOrder); if (inboundOrderDetail != null) _inboundService.InboundOrderDetailService.Repository.UpdateData(inboundOrderDetail); } else { List orderDetails = inboundOrder.Details; inboundOrder.Details = null; _inboundService.InbounOrderService.Repository.DeleteAndMoveIntoHty(inboundOrder, OperateType.自动完成); _inboundService.InboundOrderDetailService.Repository.DeleteAndMoveIntoHty(orderDetails, OperateType.自动完成); } } #endregion //stockInfo.SerialNumber = stockInfos.Count + 1; stockInfo.InDate = DateTime.Now; stockInfo.StockStatus = StockStatusEmun.已入库.ObjToInt(); stockInfoDetail.Status = StockStatusEmun.已入库.ObjToInt(); int beforeStatus = locationInfo.LocationStatus; locationInfo.LocationStatus = locationInfo.MaxQty - locationInfo.CurrentQty == 0 ? LocationStatusEnum.Fullload.ObjToInt() : LocationStatusEnum.InStock.ObjToInt(); task.CurrentAddress = task.NextAddress; task.NextAddress = string.Empty; BaseDal.DeleteAndMoveIntoHty(task, App.User.UserId == 0 ? OperateType.自动完成 : OperateType.人工完成); _basicService.LocationInfoService.Repository.UpdateData(locationInfo); _stockService.StockInfoService.Repository.UpdateData(stockInfo); _stockService.StockInfoDetailService.Repository.UpdateData(stockInfoDetail); Db.Ado.CommitTran(); } catch (Exception ex) { Db.Ado.RollbackTran(); content.Error(ex.Message); } return content; } } }