| | |
| | | using WIDESEA_Common; |
| | | using WIDESEA_DTO; |
| | | using WIDESEA_IStorageTaskRepository; |
| | | using WIDESEA_Repository; |
| | | using log4net.Core; |
| | | using Mapster; |
| | | using Masuit.Tools; |
| | | using WIDESEA_DTO.MOM; |
| | | using WIDESEA_DTO.WMS; |
| | | using WIDESEA_IStorageBasicRepository; |
| | | using WIDESEA_IStoragIntegrationServices; |
| | | using WIDESEA_Model.Models; |
| | | using WIDESEA_StorageBasicRepository; |
| | | using WIDESEA_StorageTaskRepository; |
| | | using WIDESEA_StoragIntegrationServices; |
| | | |
| | | namespace WIDESEA_StorageOutTaskServices; |
| | | |
| | |
| | | private readonly IUnitOfWorkManage _unitOfWorkManage; |
| | | private readonly IDt_OutOrderRepository _outOrderRepository; |
| | | private readonly IStockInfoRepository _stockInfoRepository; |
| | | private readonly IStockInfoDetailRepository _stockInfoDetailRepository; |
| | | private readonly IDt_Task_HtyRepository _task_HtyRepository; |
| | | private readonly IDt_OutOrderAndStockRepository _outOrderAndStockRepository; |
| | | private readonly IDt_OutOrderAndStock_HtyRepository _outOrderAndStock_HtyRepository; |
| | |
| | | private readonly IPointStackerRelationRepository _pointStackerRelationRepository; |
| | | private readonly ITaskExecuteDetailRepository _taskExecuteDetailRepository; |
| | | private readonly ILocationStatusChangeRecordRepository _locationStatusChangeRecordRepository; |
| | | private readonly IBoxingInfoRepository _boxingInfoRepository; //组盘 |
| | | private readonly ICellStateService _cellStateService; //电芯属性 |
| | | private readonly IProcessApplyService _processApplyService; //工艺路线 |
| | | private readonly IDt_AreaInfoRepository _areaInfoRepository; //区域 |
| | | private readonly IAgingInOrOutInputService _agingInOrOutInputService; //静置\陈化 |
| | | |
| | | public Dt_TaskService(IDt_TaskRepository BaseDal, |
| | | IUnitOfWorkManage unitOfWorkManage, |
| | |
| | | IDt_WareAreaInfoRepository wareAreaInfoRepository, |
| | | IPointStackerRelationRepository pointStackerRelationRepository, |
| | | ITaskExecuteDetailRepository taskExecuteDetailRepository, |
| | | ILocationStatusChangeRecordRepository locationStatusChangeRecordRepository) : base(BaseDal) |
| | | ILocationStatusChangeRecordRepository locationStatusChangeRecordRepository, |
| | | IBoxingInfoRepository boxingInfoRepository, |
| | | ICellStateService cellStateService, |
| | | IProcessApplyService processApplyService, |
| | | IDt_AreaInfoRepository areaInfoRepository, |
| | | IAgingInOrOutInputService agingInOrOutInputService, |
| | | IStockInfoDetailRepository stockInfoDetailRepository) : base(BaseDal) |
| | | { |
| | | _unitOfWorkManage = unitOfWorkManage; |
| | | _outOrderRepository = outOrderRepository; |
| | |
| | | _pointStackerRelationRepository = pointStackerRelationRepository; |
| | | _taskExecuteDetailRepository = taskExecuteDetailRepository; |
| | | _locationStatusChangeRecordRepository = locationStatusChangeRecordRepository; |
| | | _boxingInfoRepository = boxingInfoRepository; |
| | | _cellStateService = cellStateService; |
| | | _processApplyService = processApplyService; |
| | | _areaInfoRepository = areaInfoRepository; |
| | | _agingInOrOutInputService = agingInOrOutInputService; |
| | | _stockInfoDetailRepository = stockInfoDetailRepository; |
| | | } |
| | | |
| | | #region 外部接口方法 |
| | | |
| | | /// <summary> |
| | | /// 堆垛机任务完成 |
| | | /// </summary> |
| | | /// <param name="saveModel">任务数据合集</param> |
| | | /// <returns>返回结果集</returns> |
| | | public async Task<WebResponseContent> CompleteStackTaskAsync(Dt_Task task, DtStockInfo stock) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | // 更新库存状态 |
| | | stock.LocationInfo.LocationStatus = LocationEnum.Free.ObjToInt(); |
| | | stock.StockInfoDetails.ForEach(x => |
| | | { |
| | | x.Status = 2; |
| | | }); |
| | | |
| | | // 更新任务状态 |
| | | task.TaskState = OutTaskStatusEnum.SC_OutFinish.ObjToInt(); |
| | | task.CurrentAddress = task.NextAddress; |
| | | task.NextAddress = task.TargetAddress; |
| | | |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", "更新库存状态与任务状态"); |
| | | |
| | | // 事务处理 |
| | | _unitOfWorkManage.BeginTran(); |
| | | var isStockUpdated = _stockInfoRepository.UpdateData(stock); |
| | | var isTaskUpdated = await Update(task); |
| | | |
| | | if (isStockUpdated && isTaskUpdated) |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", $"事务处理完成,库存状态更新:{isStockUpdated},任务状态更新:{isTaskUpdated}"); |
| | | _unitOfWorkManage.CommitTran(); |
| | | return content.OK("任务完成成功"); |
| | | } |
| | | else |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", $"事务处理失败,库存状态更新:{isStockUpdated},任务状态更新:{isTaskUpdated}"); |
| | | _unitOfWorkManage.RollbackTran(); |
| | | return content.Error("任务或库存更新失败"); |
| | | } |
| | | } |
| | | catch (Exception err) |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, $"系统异常,异常信息:{err.Message}", ""); |
| | | Console.WriteLine(err.Message); |
| | | return content.Error(err.Message); |
| | | } |
| | | } |
| | | #region 出库任务完成 |
| | | |
| | | /// <summary> |
| | | /// 出库任务完成 |
| | | /// </summary> |
| | | /// <param name="saveModel">任务数据合集</param> |
| | | /// <returns>返回结果集</returns> |
| | | public async Task<WebResponseContent> CompleteTaskAsync(Dt_Task task, DtStockInfo stock) |
| | | //public async Task<WebResponseContent> CompleteStackTaskAsync(Dt_Task task, DtStockInfo stock) |
| | | //{ |
| | | // WebResponseContent content = new WebResponseContent(); |
| | | // try |
| | | // { |
| | | // if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound) |
| | | // { |
| | | // var process = await SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() |
| | | // .FirstAsync(x => x.EquipmentName == task.Roadway); |
| | | // EquipmentParameterInfo info = JsonConvert.DeserializeObject<EquipmentParameterInfo>(process.ProcessValue); |
| | | // AgingOutputDto agingOutputDto = new AgingOutputDto() |
| | | // { |
| | | // OpFlag = 1, |
| | | // EquipmentCode = stock.LocationInfo.RoadwayNo, |
| | | // TrayBarcode = stock.PalletCode, |
| | | // SerialNos = stock.StockInfoDetails.Select(x => new SerialNoOutDto() |
| | | // { |
| | | // SlotNo = x.OrderNo.ToInt32(), |
| | | // SerialNo = x.SerialNumber, |
| | | // SerialNoResult = true, |
| | | // ParameterInfo = new List<ParameterInfo>() |
| | | // { |
| | | // new ParameterInfo() |
| | | // { |
| | | // LowerLomit =info.LowerControlLimit, |
| | | // UpperLimit = info.UpperControlLimit, |
| | | // ParameterResult = info.EquipmentAvailabilityFlag, |
| | | // ParameterCode = info.ParameterCode, |
| | | // ParameterDesc = info.Description, |
| | | // TargetValue = info.TargetValue, |
| | | // Value = info.TargetValue, |
| | | // DefectCode = info.UOMCode |
| | | // } |
| | | // } |
| | | // }).ToList() |
| | | // }; |
| | | // content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); |
| | | // var result = JsonConvert.DeserializeObject<BasicResult>(content.ToString()); |
| | | // if (!result.Success) |
| | | // { |
| | | // throw new Exception(result.MOMMessage); |
| | | // } |
| | | // } |
| | | // // 更新库存状态 |
| | | // var loation = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress); |
| | | // var detail = _stockInfoDetailRepository.QueryData(x => x.StockId == stock.Id); |
| | | |
| | | // // 设置库位状态为空闲 |
| | | // loation.LocationStatus = LocationEnum.Free.ObjToInt(); |
| | | |
| | | // // 更新任务状态 |
| | | // task.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); |
| | | // task.CurrentAddress = task.NextAddress; |
| | | // task.NextAddress = task.TargetAddress; |
| | | |
| | | // LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", "更新库存状态与任务状态"); |
| | | |
| | | // // 事务处理 |
| | | // // 开始事务 |
| | | // _unitOfWorkManage.BeginTran(); |
| | | // // 删除库存信息 |
| | | // var isStockUpdated = _stockInfoRepository.DeleteDataById(stock.Id); |
| | | // // 删除库存信息 |
| | | // var isStockDetailUpdated = _stockInfoDetailRepository.DeleteDataByIds(detail.Select(x => (object)x.Id).ToArray()); |
| | | // // 删除任务信息 |
| | | // var isTaskUpdated = BaseDal.DeleteDataById(task.TaskId); |
| | | |
| | | // // 如果库存信息和任务信息都更新成功 |
| | | // if (isStockUpdated && isTaskUpdated && isStockDetailUpdated) |
| | | // { |
| | | // // 记录日志 |
| | | // LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", $"事务处理完成,库存状态更新:{isStockUpdated},任务状态更新:{isTaskUpdated}"); |
| | | // // 提交事务 |
| | | // _unitOfWorkManage.CommitTran(); |
| | | // // 返回成功结果 |
| | | // return content.OK("任务完成成功"); |
| | | // } |
| | | // else |
| | | // { |
| | | // // 记录日志 |
| | | // LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", $"事务处理失败,库存状态更新:{isStockUpdated},任务状态更新:{isTaskUpdated}"); |
| | | // // 回滚事务 |
| | | // _unitOfWorkManage.RollbackTran(); |
| | | // // 返回失败结果 |
| | | // return content.Error("任务或库存更新失败"); |
| | | // } |
| | | // } |
| | | // catch (Exception err) |
| | | // { |
| | | // LogFactory.GetLog("任务完成").InfoFormat(true, $"系统异常,异常信息:{err.Message}", ""); |
| | | // Console.WriteLine(err.Message); |
| | | // return content.Error(err.Message); |
| | | // } |
| | | //} |
| | | |
| | | public async Task<WebResponseContent> CompleteStackTaskAsync(Dt_Task task, DtStockInfo stock) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | |
| | | try |
| | | { |
| | | // 更新出库订单和库存货位信息 |
| | | var orderStock = await UpdateOrderAndStockAsync(stock, task.PalletCode); |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成", $"更新出库订单和库存货位信息:{JsonConvert.SerializeObject(orderStock)}"); |
| | | if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound) |
| | | { |
| | | var process = await SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() |
| | | .FirstAsync(x => x.EquipmentName == task.Roadway); |
| | | var info = JsonConvert.DeserializeObject<EquipmentParameterInfo>(process.ProcessValue); |
| | | |
| | | // 检查订单是否完成并处理后续操作 |
| | | if (IsOrderComplete(orderStock)) |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成", $"订单出库完成"); |
| | | // 处理已完成订单 |
| | | await ProcessCompletedOrderAsync(orderStock, task); |
| | | } |
| | | else |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成", $"订单暂未出库完成"); |
| | | // 处理未完成订单 |
| | | await ProcessUpdateOrderAsync(orderStock, task); |
| | | var agingOutputDto = MapToAgingOutputDto(stock, info); |
| | | content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); |
| | | ValidateResponse(content); |
| | | } |
| | | |
| | | content.OK("任务完成"); |
| | | // 更新库存状态和任务状态 |
| | | (var loc, var tas) = UpdateStockAndTaskStatus(stock, task); |
| | | |
| | | // 事务处理 |
| | | await _unitOfWorkManage.UseTranAsync(async () => |
| | | { |
| | | await UpdateLocationAsync(loc); |
| | | await DeleteStockInfoAsync(stock.Id); |
| | | await DeleteStockInfoDetailsAsync(stock.StockInfoDetails); |
| | | await DeleteTaskAsync(task.TaskId); |
| | | }); |
| | | |
| | | return content.OK("任务完成成功"); |
| | | } |
| | | catch (Exception err) |
| | | { |
| | | // 记录异常信息 |
| | | Console.WriteLine(err.Message.ToString()); |
| | | content.Error("任务完成失败"); |
| | | LogFactory.GetLog("任务完成").Error(true, $"系统异常,异常信息:{err.Message}"); |
| | | return content.Error(err.Message); |
| | | } |
| | | |
| | | return content; |
| | | } |
| | | |
| | | private AgingOutputDto MapToAgingOutputDto(DtStockInfo stock, EquipmentParameterInfo info) |
| | | { |
| | | return new AgingOutputDto |
| | | { |
| | | OpFlag = 1, |
| | | EquipmentCode = stock.LocationInfo.RoadwayNo, |
| | | TrayBarcode = stock.PalletCode, |
| | | SerialNos = stock.StockInfoDetails.Select(x => new SerialNoOutDto |
| | | { |
| | | SlotNo = x.OrderNo.ToInt32(), |
| | | SerialNo = x.SerialNumber, |
| | | SerialNoResult = true, |
| | | ParameterInfo = new List<ParameterInfo> |
| | | { |
| | | new ParameterInfo |
| | | { |
| | | LowerLomit = info.LowerControlLimit, |
| | | UpperLimit = info.UpperControlLimit, |
| | | ParameterResult = info.EquipmentAvailabilityFlag, |
| | | ParameterCode = info.ParameterCode, |
| | | ParameterDesc = info.Description, |
| | | TargetValue = info.TargetValue, |
| | | Value = info.TargetValue, |
| | | DefectCode = info.UOMCode |
| | | } |
| | | } |
| | | }).ToList() |
| | | }; |
| | | } |
| | | |
| | | private void ValidateResponse(WebResponseContent content) |
| | | { |
| | | var result = JsonConvert.DeserializeObject<BasicResult>(content.ToString()); |
| | | if (!result.Success) |
| | | { |
| | | throw new Exception(result.MOMMessage); |
| | | } |
| | | } |
| | | |
| | | private (DtLocationInfo, Dt_Task) UpdateStockAndTaskStatus(DtStockInfo stock, Dt_Task task) |
| | | { |
| | | var location = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress); |
| | | var details = _stockInfoDetailRepository.QueryData(x => x.StockId == stock.Id); |
| | | |
| | | location.LocationStatus = LocationEnum.Free.ObjToInt(); |
| | | task.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); |
| | | task.CurrentAddress = task.NextAddress; |
| | | task.NextAddress = task.TargetAddress; |
| | | |
| | | LogFactory.GetLog("任务完成").Info(true, "更新库存状态与任务状态"); |
| | | return (location, task); |
| | | } |
| | | |
| | | private async Task DeleteStockInfoAsync(int stockId) |
| | | { |
| | | var isStockUpdated = await _stockInfoRepository.DeleteDataByIdAsync(stockId); |
| | | if (!isStockUpdated) |
| | | { |
| | | throw new Exception("库存信息更新失败"); |
| | | } |
| | | } |
| | | |
| | | private async Task UpdateLocationAsync(DtLocationInfo info) |
| | | { |
| | | var isStockUpdated = await _locationRepository.UpdateDataAsync(info); |
| | | if (!isStockUpdated) |
| | | { |
| | | throw new Exception("库存信息更新失败"); |
| | | } |
| | | } |
| | | |
| | | private async Task DeleteStockInfoDetailsAsync(IEnumerable<DtStockInfoDetail> details) |
| | | { |
| | | var ids = details.Select(x => (object)x.Id).ToArray(); |
| | | var isStockDetailUpdated = await _stockInfoDetailRepository.DeleteDataByIdsAsync(ids); |
| | | if (!isStockDetailUpdated) |
| | | { |
| | | throw new Exception("库存详情信息更新失败"); |
| | | } |
| | | } |
| | | |
| | | private async Task DeleteTaskAsync(int taskId) |
| | | { |
| | | var isTaskUpdated = await BaseDal.DeleteDataByIdAsync(taskId); |
| | | if (!isTaskUpdated) |
| | | { |
| | | throw new Exception("任务信息更新失败"); |
| | | } |
| | | } |
| | | |
| | | #endregion 出库任务完成 |
| | | |
| | | #region 移库任务完成 |
| | | |
| | | /// <summary> |
| | | /// 移库任务完成 |
| | |
| | | // 更新货位和库存信息 |
| | | (DtStockInfo updateStock, DtLocationInfo locationInf) = UpdateStockLocation(stock, task.NextAddress); |
| | | var taskHty = CreateHistoricalTask(task); |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "移库任务完成", $"修改后库存数据:{JsonConvert.SerializeObject(updateStock)},原先货位数据:{locationInf}"); |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "移库任务完成", $"货位地址:{task.TargetAddress},修改后库存数据:{JsonConvert.SerializeObject(updateStock)},原先货位数据:{locationInf}"); |
| | | |
| | | // 执行数据库事务 |
| | | bool isResult = await ExecuteTransaction(updateStock, taskHty, locationInf, task.TaskId); |
| | |
| | | return content; |
| | | } |
| | | |
| | | #endregion 移库任务完成 |
| | | |
| | | #region 入库任务完成 |
| | | |
| | | /// <summary> |
| | | /// 任务完成 |
| | | /// 入库任务完成 |
| | | /// </summary> |
| | | /// <param name="taskNum">任务号</param> |
| | | /// <returns></returns> |
| | | /// <param name="task">任务数据合集</param> |
| | | /// <returns>返回结果集</returns> |
| | | //public async Task<WebResponseContent> CompleteInboundTaskAsync(Dt_Task task) |
| | | //{ |
| | | // WebResponseContent content = new WebResponseContent(); |
| | | // try |
| | | // { |
| | | // var boxing = await _boxingInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode); |
| | | // var locationInf = await _locationRepository.QueryFirstAsync(x => x.LocationCode == task.TargetAddress); |
| | | |
| | | // locationInf.LocationStatus = (int)LocationEnum.InStock; |
| | | |
| | | // // 创建历史任务实例模型 |
| | | // var taskHty = CreateHistoricalTask(task); |
| | | |
| | | // // 创建库存实例模型 |
| | | // DtStockInfo stock; |
| | | // if (boxing == null) |
| | | // { |
| | | // // 空托盘 |
| | | |
| | | // stock = new DtStockInfo() |
| | | // { |
| | | // PalletCode = task.PalletCode, |
| | | // LocationCode = task.TargetAddress, |
| | | // CreateDate = DateTime.Now, |
| | | // Creater = "system", |
| | | // IsFull = boxing.IsFull, |
| | | // StockInfoDetails = new List<DtStockInfoDetail>() |
| | | // { |
| | | // new DtStockInfoDetail() |
| | | // { |
| | | // MaterielCode = "空托盘", |
| | | // Id = 0, |
| | | // } |
| | | // } |
| | | // }; |
| | | // } |
| | | // else |
| | | // { |
| | | // // 实盘 |
| | | // var boxDetail = boxing.BoxingInfoDetails.Adapt<List<DtStockInfoDetail>>(); |
| | | // // 创建库存实例模型 |
| | | // stock = new DtStockInfo() |
| | | // { |
| | | // PalletCode = task.PalletCode, |
| | | // LocationCode = task.TargetAddress, |
| | | // CreateDate = DateTime.Now, |
| | | // Creater = "system", |
| | | // IsFull = boxing.IsFull, |
| | | // StockInfoDetails = boxDetail, |
| | | // }; |
| | | |
| | | // AgingInputDto agingInputDto = new AgingInputDto() |
| | | // { |
| | | // SerialNos = boxing.BoxingInfoDetails |
| | | // .Select(item => new SerialNoInDto { SerialNo = item.SerialNumber, PositionNo = item.OrderNo }) |
| | | // .ToList(), |
| | | // TrayBarcode = task.PalletCode, |
| | | // OpFlag = 1 |
| | | // }; |
| | | // var result = await _agingInOrOutInputService.GetOCVInputAsync(agingInputDto); |
| | | // stock.Remark = JsonConvert.DeserializeObject<ResponeAgingInputDto>(result.Data.ToString()).LinedProcessFeedbackTime; |
| | | |
| | | // LogFactory.GetLog("任务完成").InfoFormat(true, "入库任务完成", $"货位地址:{task.TargetAddress},修改后货位数据:{locationInf}"); |
| | | |
| | | // } |
| | | |
| | | // // 执行数据库事务 |
| | | // bool isResult = await ExecuteTransaction(stock, taskHty, locationInf, task.TaskId); |
| | | // if (isResult) |
| | | // content.OK("入库任务完成成功"); |
| | | // else |
| | | // content.Error("入库任务完成失败"); |
| | | // } |
| | | // catch (Exception err) |
| | | // { |
| | | // Console.WriteLine(err.Message.ToString()); |
| | | // } |
| | | // return content; |
| | | //} |
| | | |
| | | /// <summary> |
| | | /// 完成入库任务 |
| | | /// </summary> |
| | | /// <param name="task">任务数据合集</param> |
| | | /// <returns>返回结果集</returns> |
| | | public async Task<WebResponseContent> CompleteInboundTaskAsync(Dt_Task task) |
| | | { |
| | | // 初始化响应内容 |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | // 获取装箱信息和目标位置信息 |
| | | var boxing = await _boxingInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode); |
| | | var locationInf = await _locationRepository.QueryFirstAsync(x => x.LocationCode == task.TargetAddress); |
| | | |
| | | // 更新目标位置状态为库存中 |
| | | locationInf.LocationStatus = (int)LocationEnum.InStock; |
| | | |
| | | // 创建历史任务实例模型 |
| | | var taskHty = CreateHistoricalTask(task); |
| | | |
| | | // 根据是否有组盘信息创建库存实例模型 |
| | | DtStockInfo stock = boxing == null ? CreateEmptyPalletStock(task, locationInf) : CreateFullPalletStock(task, locationInf, boxing); |
| | | |
| | | // 执行数据库事务 |
| | | bool isResult = await ExecuteTransaction(stock, taskHty, locationInf, task.TaskId); |
| | | if (isResult) |
| | | { |
| | | content.OK("入库任务完成成功"); |
| | | } |
| | | else |
| | | { |
| | | content.Error("入库任务完成失败"); |
| | | } |
| | | } |
| | | catch (Exception err) |
| | | { |
| | | // 记录异常信息到控制台和日志 |
| | | Console.WriteLine(err.Message.ToString()); |
| | | LogFactory.GetLog("任务完成").Error(true, err); |
| | | } |
| | | return content; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 创建空托盘的库存实例模型 |
| | | /// </summary> |
| | | private DtStockInfo CreateEmptyPalletStock(Dt_Task task, DtLocationInfo locationInf) |
| | | { |
| | | return new DtStockInfo() |
| | | { |
| | | PalletCode = task.PalletCode, |
| | | LocationCode = task.TargetAddress, |
| | | CreateDate = DateTime.Now, |
| | | Creater = "system", |
| | | IsFull = false, |
| | | AreaCode = task.Roadway, |
| | | StockInfoDetails = new List<DtStockInfoDetail>() |
| | | { |
| | | new DtStockInfoDetail() |
| | | { |
| | | MaterielCode = "空托盘", |
| | | Id = 0, |
| | | } |
| | | } |
| | | }; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 创建实盘的库存实例模型并调用MOM入库 |
| | | /// </summary> |
| | | private DtStockInfo CreateFullPalletStock(Dt_Task task, DtLocationInfo locationInf, DtBoxingInfo boxing) |
| | | { |
| | | var boxDetail = boxing.BoxingInfoDetails.Adapt<List<DtStockInfoDetail>>(); |
| | | var stock = new DtStockInfo() |
| | | { |
| | | PalletCode = task.PalletCode, |
| | | LocationCode = task.TargetAddress, |
| | | CreateDate = DateTime.Now, |
| | | Creater = "system", |
| | | IsFull = boxing.IsFull, |
| | | AreaCode = task.Roadway, |
| | | StockInfoDetails = boxDetail, |
| | | }; |
| | | |
| | | // 处理请求参数 |
| | | AgingInputDto agingInputDto = new AgingInputDto() |
| | | { |
| | | SerialNos = boxing.BoxingInfoDetails |
| | | .Select(item => new SerialNoInDto { SerialNo = item.SerialNumber, PositionNo = item.OrderNo }) |
| | | .ToList(), |
| | | TrayBarcode = task.PalletCode, |
| | | OpFlag = 1 |
| | | }; |
| | | var result = _agingInOrOutInputService.GetOCVInputAsync(agingInputDto).Result; |
| | | stock.Remark = JsonConvert.DeserializeObject<ResponeAgingInputDto>(result.Data.ToString()).LinedProcessFeedbackTime; |
| | | |
| | | // 记录日志 |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "入库任务完成", $"货位地址:{task.TargetAddress},修改后货位数据:{locationInf}"); |
| | | |
| | | return stock; |
| | | } |
| | | |
| | | #endregion 入库任务完成 |
| | | |
| | | #region 任务完成 |
| | | |
| | | /// <summary> |
| | | /// 完成任务 |
| | | /// </summary> |
| | | /// <param name="taskNum">任务编号</param> |
| | | /// <returns>返回结果集</returns> |
| | | public async Task<WebResponseContent> CompleteAsync(int taskNum) |
| | | { |
| | | // 初始化响应内容 |
| | | WebResponseContent content = new WebResponseContent(); |
| | | |
| | | // 提取任务数据 |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "提取任务数据", $"任务号:{taskNum}"); |
| | | |
| | |
| | | |
| | | // 验证库存是否存在 |
| | | var stock = await _stockInfoRepository.QueryFirstAsync(x => x.PalletCode == task.PalletCode); |
| | | if (stock == null) |
| | | { |
| | | return content.Error("库存不存在"); |
| | | } |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "验证库存是否存在", JsonConvert.SerializeObject(stock)); |
| | | |
| | | if (task.TaskType == (int)TaskTypeEnum.Outbound) |
| | | // 根据任务类型调用相应的完成任务方法 |
| | | switch (task.TaskType) |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "出库任务", ""); |
| | | if (task.TaskState == OutTaskStatusEnum.SC_OutExecuting.ObjToInt()) |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "堆垛机出库完成", ""); |
| | | case (int)TaskInboundTypeEnum.Inbound: |
| | | case (int)TaskInboundTypeEnum.InTray: |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "入库任务", ""); |
| | | return await CompleteInboundTaskAsync(task); |
| | | |
| | | case (int)TaskOutboundTypeEnum.OutTray: |
| | | case (int)TaskOutboundTypeEnum.Outbound: |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "出库任务", ""); |
| | | return await CompleteStackTaskAsync(task, stock); |
| | | } |
| | | else |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成", ""); |
| | | return await CompleteTaskAsync(task, stock); |
| | | } |
| | | } |
| | | else if (task.TaskType == (int)TaskTypeEnum.RelocationIn) |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "移库任务完成", ""); |
| | | return await CompleteTransferTaskAsync(task, stock); |
| | | } |
| | | else |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, $"任务状态异常", "无参数"); |
| | | return content.Error("任务状态异常"); |
| | | |
| | | default: |
| | | return content.Error("任务类型不存在"); |
| | | } |
| | | } |
| | | |
| | | #endregion 任务完成 |
| | | |
| | | #region 请求任务入库 |
| | | |
| | | /// <summary> |
| | | /// 请求任务 |
| | |
| | | /// <returns>包含任务信息的响应内容</returns> |
| | | public async Task<WebResponseContent> RequestTaskAsync(RequestTaskDto input) |
| | | { |
| | | // 创建一个WebResponseContent对象 |
| | | WebResponseContent content = new WebResponseContent(); |
| | | |
| | | try |
| | | { |
| | | // 根据托盘获取库存信息 |
| | | var stockInfo = await _stockInfoRepository.QueryFirstAsync(x => x.PalletCode == input.PalletCode); |
| | | // 创建一个TrayCellsStatusDto对象,并赋值 |
| | | TrayCellsStatusDto trayCells = new TrayCellsStatusDto() |
| | | { |
| | | TrayBarcode = input.PalletCode |
| | | }; |
| | | |
| | | // 获取仓库区域信息 |
| | | var areaInfo = await _wareAreaInfoRepository.QueryFirstAsync(x => x.WareAreaCode == input.AreaCode); |
| | | // 调用GetTrayCellStatusAsync方法,获取整盘电芯 |
| | | content = await GetTrayCellStatusAsync(trayCells); |
| | | // 如果状态为false,则返回content |
| | | if (!content.Status) return content; |
| | | |
| | | // 查询是否已有任务 |
| | | // 添加组盘信息 |
| | | // 将content.Data转换为ResultTrayCellsStatus对象 |
| | | var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.ToString()); |
| | | var boxing = await CreateBoxingInfo(result, input.PalletCode); |
| | | |
| | | // 调用GetProcessApplyAsync方法,获取工艺路线 |
| | | ProcessApplyDto process = await GetProcessApplyAsync(result); |
| | | |
| | | // 如果process为null,则返回content |
| | | if (process == null) return content; |
| | | |
| | | // 调用GetProcessResponseAsync方法,获取工艺响应 |
| | | var processResponse = await GetProcessResponseAsync(process, input.Position); |
| | | |
| | | // 调用BaseDal.QueryFirstAsync方法,查询任务 |
| | | var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == input.PalletCode); |
| | | |
| | | if (task != null) |
| | | // 如果task不为null,则调用UpdateExistingTask方法,更新任务;否则调用CreateNewTask方法,创建新任务 |
| | | content = task != null ? await UpdateExistingTask(input, task) : await CreateNewTask(processResponse, input); |
| | | if (content.Status) |
| | | { |
| | | // 更新现有任务 |
| | | content = await UpdateExistingTask(input, areaInfo.AreaID, task); |
| | | } |
| | | else |
| | | { |
| | | // 创建新任务 |
| | | content = await CreateNewTask(input, areaInfo.AreaID); |
| | | var isBox = await _boxingInfoRepository.AddDataNavAsync(boxing); |
| | | } |
| | | } |
| | | catch (Exception err) |
| | | { |
| | | // 错误处理 |
| | | // 如果发生异常,则调用content.Error方法,记录错误信息,并输出错误信息 |
| | | content.Error(err.Message); |
| | | Console.WriteLine(err.Message); |
| | | } |
| | | |
| | | // 返回content |
| | | return content; |
| | | } |
| | | |
| | | // 获取托盘单元格状态 |
| | | private async Task<WebResponseContent> GetTrayCellStatusAsync(TrayCellsStatusDto trayCells) |
| | | { |
| | | // 调用_cellStateService.GetTrayCellStatusAsync方法,获取托盘单元格状态 |
| | | return await _cellStateService.GetTrayCellStatusAsync(trayCells); |
| | | } |
| | | |
| | | // 获取组盘信息 |
| | | private async Task<DtBoxingInfo> CreateBoxingInfo(ResultTrayCellsStatus result, string palletCode) |
| | | { |
| | | return new DtBoxingInfo |
| | | { |
| | | PalletCode = palletCode, |
| | | IsFull = true, |
| | | BoxingInfoDetails = result.SerialNos.Select(serialNoObj => new DtBoxingInfoDetail |
| | | { |
| | | SerialNumber = serialNoObj.SerialNo, |
| | | OrderNo = serialNoObj.PositionNo.ToString(), |
| | | Status = serialNoObj.SerialNoStatus, |
| | | MaterielCode = result.BindCode, |
| | | Remark = result.TrayBarcodePropertys.ToJsonString(), |
| | | }).ToList() |
| | | }; |
| | | } |
| | | |
| | | // 获取工艺申请 |
| | | private async Task<ProcessApplyDto> GetProcessApplyAsync(ResultTrayCellsStatus content) |
| | | { |
| | | // 创建一个ProcessApplyDto对象,并赋值 |
| | | return new ProcessApplyDto() |
| | | { |
| | | //WipOrderNo = result.BindCode, |
| | | SerialNos = content.SerialNos.Select(item => new SerialNos |
| | | { |
| | | SerialNo = item.SerialNo |
| | | }).ToList() |
| | | }; |
| | | } |
| | | |
| | | // 获取工艺响应 |
| | | private async Task<List<Dt_EquipmentProcess>> GetProcessResponseAsync(ProcessApplyDto process, string position) |
| | | { |
| | | // 如果process为null,则返回null |
| | | if (process == null) return null; |
| | | |
| | | // 调用_processApplyService.GetProcessApplyAsync方法,获取工艺申请 |
| | | WebResponseContent content = await _processApplyService.GetProcessApplyAsync(process); |
| | | // 如果状态为false,则返回null |
| | | if (!content.Status) return null; |
| | | |
| | | // 将content.Data转换为ResultProcessApply对象 |
| | | var apply = JsonConvert.DeserializeObject<ResultProcessApply>(content.Data.ToString()); |
| | | // 根据position的值,返回不同的Dt_EquipmentProcess列表 |
| | | switch (position) |
| | | { |
| | | case "1088": |
| | | return SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() |
| | | .Where(x => x.EquipmentType == "陈化" && x.WipOrderNo == apply.WipOrderNo && x.ProductDesc == apply.ProductNo) |
| | | .ToList(); |
| | | |
| | | case "1339": |
| | | case "1406": |
| | | return SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() |
| | | .Where(x => x.EquipmentType == "静置" && x.WipOrderNo == apply.WipOrderNo && x.ProductDesc == apply.ProductNo) |
| | | .ToList(); |
| | | |
| | | default: |
| | | return new List<Dt_EquipmentProcess>(); |
| | | } |
| | | } |
| | | |
| | | #endregion 请求任务入库 |
| | | |
| | | #region 请求出库 |
| | | |
| | | //public async Task<WebResponseContent> RequestTrayTaskAsync(string position, int tag, string areaCdoe,List<string> roadways) |
| | | //{ |
| | | // WebResponseContent content = new WebResponseContent(); |
| | | // try |
| | | // { |
| | | // // 1==实盘 2 ==空盘 |
| | | // if (tag == 1) |
| | | // { |
| | | // // 查询库存信息 |
| | | // DtStockInfo? stockInfo = _stockInfoRepository.QueryData(x => x.AreaCode == areaCdoe && Convert.ToDateTime(x.Remark) < DateTime.Now && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && roadways.Contains(x.LocationInfo.RoadwayNo)).OrderBy(x => x.CreateDate).FirstOrDefault(); |
| | | // // 创建新任务实例 |
| | | // var task = new Dt_Task() |
| | | // { |
| | | // Grade = 1, |
| | | // Roadway = stockInfo.LocationInfo.RoadwayNo, |
| | | // TargetAddress = position, |
| | | // Dispatchertime = DateTime.Now, |
| | | // MaterialNo = "", |
| | | // NextAddress = position, |
| | | // OrderNo = null, |
| | | // PalletCode = stockInfo.PalletCode, |
| | | // SourceAddress = stockInfo.LocationCode, |
| | | // TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | // TaskType = (int)TaskOutboundTypeEnum.Outbound, |
| | | // TaskNum = await BaseDal.GetTaskNo(), |
| | | // Creater = "Systeam" |
| | | // }; |
| | | // var taskId = await BaseDal.AddDataAsync(task); |
| | | // bool isResult = taskId > 0; |
| | | // if (isResult) |
| | | // { |
| | | // WMSTaskDTO taskDTO = new WMSTaskDTO() |
| | | // { |
| | | // TaskNum = task.TaskNum.Value, |
| | | // Grade = 1, |
| | | // PalletCode = DateTime.Now.ToString("MMddHHmmss"), |
| | | // RoadWay = task.Roadway, |
| | | // SourceAddress = stockInfo.LocationCode, |
| | | // TargetAddress = task.Roadway, |
| | | // TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | // Id = 0, |
| | | // TaskType = (int)TaskOutboundTypeEnum.OutTray |
| | | // }; |
| | | // stockInfo.LocationInfo.LocationStatus = (int)LocationEnum.InStockDisable; |
| | | // _locationRepository.UpdateData(stockInfo.LocationInfo); |
| | | // content.OK(data: taskDTO); |
| | | // } |
| | | // } |
| | | // else |
| | | // { |
| | | // var stockInfo = _stockInfoRepository.QueryData(x => x.AreaCode == areaCdoe && x.StockInfoDetails.Any(z => z.MaterielCode == "空托盘") && roadways.Contains(x.LocationInfo.RoadwayNo)).OrderBy(x => x.CreateDate).FirstOrDefault(); |
| | | // // 创建新任务实例 |
| | | // var task = new Dt_Task |
| | | // { |
| | | // CurrentAddress = stockInfo.LocationCode, |
| | | // Grade = 1, |
| | | // Roadway = stockInfo.LocationInfo.RoadwayNo, |
| | | // TargetAddress = position, |
| | | // Dispatchertime = DateTime.Now, |
| | | // MaterialNo = "", |
| | | // NextAddress = position, |
| | | // OrderNo = null, |
| | | // PalletCode = stockInfo.PalletCode, |
| | | // SourceAddress = stockInfo.LocationCode, |
| | | // TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | // TaskType = (int)TaskOutboundTypeEnum.OutTray, |
| | | // TaskNum = await BaseDal.GetTaskNo(), |
| | | // Creater = "Systeam" |
| | | // }; |
| | | |
| | | // var taskId = await BaseDal.AddDataAsync(task); |
| | | // bool isResult = taskId > 0; |
| | | // if (isResult) |
| | | // { |
| | | // WMSTaskDTO taskDTO = new WMSTaskDTO() |
| | | // { |
| | | // TaskNum = task.TaskNum.Value, |
| | | // Grade = 1, |
| | | // PalletCode = DateTime.Now.ToString("MMddHHmmss"), |
| | | // RoadWay = task.Roadway, |
| | | // SourceAddress = stockInfo.LocationCode, |
| | | // TargetAddress = task.Roadway, |
| | | // TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | // Id = 0, |
| | | // TaskType = (int)TaskOutboundTypeEnum.OutTray |
| | | // }; |
| | | // content.OK(data: taskDTO); |
| | | // } |
| | | // } |
| | | // } |
| | | // catch (Exception ex) |
| | | // { |
| | | // throw; |
| | | // } |
| | | // return content; |
| | | //} |
| | | |
| | | /// <summary> |
| | | /// 请求托盘任务 |
| | | /// </summary> |
| | | /// <param name="position">目标位置</param> |
| | | /// <param name="tag">托盘类型(1:实盘,2:空盘)</param> |
| | | /// <param name="areaCode">区域编码</param> |
| | | /// <param name="roadways">巷道编码集合</param> |
| | | /// <returns>返回结果集</returns> |
| | | public async Task<WebResponseContent> RequestTrayTaskAsync(string position, int tag, string areaCode, List<string> roadways) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | // 根据托盘类型查询库存信息 |
| | | DtStockInfo stockInfo = tag == 1 |
| | | ? QueryStockInfoForRealTray(areaCode, roadways) |
| | | : QueryStockInfoForEmptyTray(areaCode, roadways); |
| | | |
| | | if (stockInfo == null) |
| | | { |
| | | return content.Error("库存信息不存在"); |
| | | } |
| | | |
| | | // 创建新任务实例 |
| | | var task = CreateTask(stockInfo, position, tag); |
| | | var taskId = await BaseDal.AddDataAsync(task); |
| | | bool isResult = taskId > 0; |
| | | if (!isResult) |
| | | { |
| | | return content.Error("任务创建失败"); |
| | | } |
| | | |
| | | // 创建任务DTO |
| | | WMSTaskDTO taskDTO = CreateTaskDTO(task); |
| | | if (tag == 1) |
| | | { |
| | | // 更新库存位置状态为不可用 |
| | | stockInfo.LocationInfo.LocationStatus = (int)LocationEnum.InStockDisable; |
| | | await _locationRepository.UpdateDataAsync(stockInfo.LocationInfo); |
| | | } |
| | | |
| | | // 返回成功响应 |
| | | return content.OK(data: taskDTO); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | // 记录异常信息并抛出 |
| | | LogFactory.GetLog("请求托盘任务").Error(true, ex); |
| | | throw; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 查询实盘库存信息 |
| | | /// </summary> |
| | | private DtStockInfo QueryStockInfoForRealTray(string areaCode, List<string> roadways) |
| | | { |
| | | return _stockInfoRepository.QueryData(x => x.AreaCode == areaCode && Convert.ToDateTime(x.Remark) < DateTime.Now && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && roadways.Contains(x.LocationInfo.RoadwayNo)) |
| | | .OrderBy(x => x.CreateDate) |
| | | .FirstOrDefault(); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 查询空盘库存信息 |
| | | /// </summary> |
| | | private DtStockInfo QueryStockInfoForEmptyTray(string areaCode, List<string> roadways) |
| | | { |
| | | return _stockInfoRepository.QueryData(x => x.AreaCode == areaCode && x.StockInfoDetails.Any(z => z.MaterielCode == "空托盘") && roadways.Contains(x.LocationInfo.RoadwayNo)) |
| | | .OrderBy(x => x.CreateDate) |
| | | .FirstOrDefault(); |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 创建任务实例 |
| | | /// </summary> |
| | | private Dt_Task CreateTask(DtStockInfo stockInfo, string position, int tag) |
| | | { |
| | | return new Dt_Task |
| | | { |
| | | Grade = 1, |
| | | Roadway = stockInfo.LocationInfo.RoadwayNo, |
| | | TargetAddress = position, |
| | | Dispatchertime = DateTime.Now, |
| | | MaterialNo = "", |
| | | NextAddress = position, |
| | | OrderNo = null, |
| | | PalletCode = stockInfo.PalletCode, |
| | | SourceAddress = stockInfo.LocationCode, |
| | | TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | TaskType = tag == 1 ? (int)TaskOutboundTypeEnum.Outbound : (int)TaskOutboundTypeEnum.OutTray, |
| | | TaskNum = BaseDal.GetTaskNo().Result, |
| | | Creater = "System" // 修正拼写错误 |
| | | }; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 创建任务DTO |
| | | /// </summary> |
| | | private WMSTaskDTO CreateTaskDTO(Dt_Task task) |
| | | { |
| | | return new WMSTaskDTO |
| | | { |
| | | TaskNum = task.TaskNum.Value, |
| | | Grade = 1, |
| | | PalletCode = task.PalletCode, |
| | | RoadWay = task.Roadway, |
| | | SourceAddress = task.SourceAddress, |
| | | TargetAddress = task.TargetAddress, |
| | | TaskState = task.TaskState.Value, |
| | | Id = 0, |
| | | TaskType = task.TaskType, |
| | | }; |
| | | } |
| | | |
| | | #endregion 请求出库 |
| | | |
| | | #region 陈化请求出库 |
| | | |
| | | // 陈化请求出库 |
| | | public async Task<WebResponseContent> OutTrayByCh(string position) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | try |
| | | { |
| | | var area = _areaInfoRepository.QueryFirst(x => x.AreaName == "陈化区"); |
| | | |
| | | // 查询库存信息 |
| | | var stockInfo = _stockInfoRepository.QueryData(x => x.AreaCode == area.AreaCode && Convert.ToDateTime(x.Remark) < DateTime.Now && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock).OrderBy(x => x.CreateDate).FirstOrDefault(); |
| | | // 创建新任务实例 |
| | | var task = new Dt_Task() |
| | | { |
| | | Grade = 1, |
| | | Roadway = stockInfo.LocationInfo.RoadwayNo, |
| | | TargetAddress = position, |
| | | Dispatchertime = DateTime.Now, |
| | | MaterialNo = "", |
| | | NextAddress = position, |
| | | OrderNo = null, |
| | | PalletCode = stockInfo.PalletCode, |
| | | SourceAddress = stockInfo.LocationCode, |
| | | TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | TaskType = (int)TaskOutboundTypeEnum.OutTray, |
| | | TaskNum = await BaseDal.GetTaskNo(), |
| | | Creater = "Systeam" |
| | | }; |
| | | var taskId = await BaseDal.AddDataAsync(task); |
| | | bool isResult = taskId > 0; |
| | | if (isResult) |
| | | { |
| | | WMSTaskDTO taskDTO = new WMSTaskDTO() |
| | | { |
| | | TaskNum = task.TaskNum.Value, |
| | | Grade = 1, |
| | | PalletCode = DateTime.Now.ToString("MMddHHmmss"), |
| | | RoadWay = task.Roadway, |
| | | SourceAddress = stockInfo.LocationCode, |
| | | TargetAddress = task.Roadway, |
| | | TaskState = (int)TaskOutStatusEnum.OutNew, |
| | | Id = 0, |
| | | TaskType = (int)TaskOutboundTypeEnum.OutTray |
| | | }; |
| | | stockInfo.LocationInfo.LocationStatus = (int)LocationEnum.InStockDisable; |
| | | _locationRepository.UpdateData(stockInfo.LocationInfo); |
| | | content.OK(data: taskDTO); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw; |
| | | } |
| | | return content; |
| | | } |
| | | |
| | | #endregion 陈化请求出库 |
| | | |
| | | #endregion 外部接口方法 |
| | | |
| | |
| | | /// <returns>更新后的订单和库存信息</returns> |
| | | private async Task<Dt_OutOrderAndStock> UpdateOrderAndStockAsync(DtStockInfo stock, string barCode) |
| | | { |
| | | //根据PalletCode获取订单和库存信息 |
| | | var orderStock = await _outOrderAndStockRepository.GetOrderAndStock(palletCode: barCode); |
| | | |
| | | //完成数量增加 |
| | | orderStock.CompletedQuantity += stock.StockInfoDetails.Sum(x => x.StockQuantity); |
| | | |
| | | //订单详情完成数量增加 |
| | | orderStock.OrderList.OrderDetailList.CompletedQuantity += stock.StockInfoDetails.Sum(x => x.StockQuantity); |
| | | |
| | | //返回更新后的订单和库存信息 |
| | | return orderStock; |
| | | } |
| | | |
| | |
| | | /// </summary> |
| | | /// <param name="orderStock">订单和库存信息</param> |
| | | /// <returns>是否完成</returns> |
| | | // 判断订单是否完成 |
| | | private bool IsOrderComplete(Dt_OutOrderAndStock orderStock) |
| | | { |
| | | // 如果出库数量等于完成出库数量,则订单完成 |
| | | return orderStock.CompletedQuantity == orderStock.OutboundQuantity; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 处理已完成的订单 |
| | | /// 创建历史任务记录 |
| | | /// </summary> |
| | | /// <param name="orderStock">订单和库存信息</param> |
| | | /// <param name="task">任务数据</param> |
| | | /// <returns>异步任务</returns> |
| | | private async Task ProcessCompletedOrderAsync(Dt_OutOrderAndStock orderStock, Dt_Task task) |
| | | { |
| | | // 创建历史订单记录 |
| | | var stockHty = CreateHistoricalOrder(orderStock); |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单已完成", $"创建历史订单记录:{JsonConvert.SerializeObject(stockHty)}"); |
| | | |
| | | // 创建获取历史任务 |
| | | var taskHty = CreateHistoricalTask(task); |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单已完成", $"创建历史任务记录:{JsonConvert.SerializeObject(taskHty)}"); |
| | | |
| | | _unitOfWorkManage.BeginTran(); |
| | | |
| | | try |
| | | { |
| | | // 添加历史任务 |
| | | var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0; |
| | | |
| | | // 删除任务数据 |
| | | var isTaskDelete = await Delete(task.TaskId); |
| | | |
| | | // 插入历史订单 |
| | | var isStockInsert = _outOrderAndStock_HtyRepository.InsertNav(stockHty); |
| | | |
| | | // 删除原订单 |
| | | var isOrderStockDelete = _outOrderAndStockRepository.DeleteNavOrderStock(orderStock); |
| | | |
| | | if (isStockInsert && isOrderStockDelete && isTaskHtyAdd && isTaskDelete) |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单已完成", $"事务处理完成,提交事务。添加历史任务:{isTaskHtyAdd},删除任务数据:{isTaskDelete},插入历史订单:{isStockInsert},删除原订单:{isOrderStockDelete}"); |
| | | _unitOfWorkManage.CommitTran(); |
| | | } |
| | | else |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单已完成", $"添加数据库失败,请检查数据是否正确,数据回滚。添加历史任务:{isTaskHtyAdd},删除任务数据:{isTaskDelete},插入历史订单:{isStockInsert},删除原订单:{isOrderStockDelete}"); |
| | | _unitOfWorkManage.RollbackTran(); |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, $"总任务出库完成,订单已完成,系统异常,异常信息:{ex.Message}", "无参数"); |
| | | _unitOfWorkManage.RollbackTran(); |
| | | throw; // 重新抛出异常以供外部捕获 |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 处理未完成订单 |
| | | /// </summary> |
| | | /// <param name="orderStock">订单和库存信息</param> |
| | | /// <param name="task">任务数据</param> |
| | | /// <returns>异步任务</returns> |
| | | private async Task ProcessUpdateOrderAsync(Dt_OutOrderAndStock orderStock, Dt_Task task) |
| | | { |
| | | // 创建获取历史任务 |
| | | var taskHty = CreateHistoricalTask(task); |
| | | |
| | | _unitOfWorkManage.BeginTran(); |
| | | try |
| | | { |
| | | // 添加历史任务 |
| | | var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0; |
| | | |
| | | // 删除任务数据 |
| | | var isTaskDelete = await Delete(task.TaskId); |
| | | |
| | | // 更新订单与库存 |
| | | var isOrderUpdated = _outOrderAndStockRepository.UpdateNavOrderStock(orderStock); |
| | | if (isTaskDelete && isTaskHtyAdd && isOrderUpdated) |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单暂未完成", $"事务处理完成,提交事务。添加历史任务:{isTaskHtyAdd},删除任务数据:{isTaskDelete},更新订单与库存:{isOrderUpdated}"); |
| | | _unitOfWorkManage.CommitTran(); |
| | | } |
| | | else |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "总任务出库完成,订单暂未完成", $"添加数据库失败,请检查数据是否正确,数据回滚。添加历史任务:{isTaskHtyAdd},删除任务数据:{isTaskDelete},更新订单与库存:{isOrderUpdated}"); |
| | | _unitOfWorkManage.RollbackTran(); |
| | | } |
| | | } |
| | | catch (Exception err) |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, $"总任务出库完成,订单暂未完成,系统异常,异常信息:{err.Message}", "无参数"); |
| | | Console.WriteLine(err.Message.ToString()); |
| | | _unitOfWorkManage.RollbackTran(); |
| | | throw; // 重新抛出异常以供外部捕获 |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 创建历史订单记录 |
| | | /// </summary> |
| | | /// <param name="orderStock">订单和库存信息</param> |
| | | /// <returns>历史订单记录</returns> |
| | | private Dt_OutOrderAndStock_Hty CreateHistoricalOrder(Dt_OutOrderAndStock orderStock) |
| | | { |
| | | var stockHty = _mapper.Map<Dt_OutOrderAndStock_Hty>(orderStock); |
| | | |
| | | //stockHty.StockList.FinishTime = DateTime.Now; |
| | | //stockHty.StockList.OperateType = (int)OperateTypeEnum.自动完成; |
| | | //stockHty.StockList.SourceId = orderStock.StockList.GroupId; |
| | | //stockHty.StockList.GroupId = 0; |
| | | |
| | | //stockHty.StockList.StockDetailList.ForEach(x => |
| | | //{ |
| | | // x.FinishTime = DateTime.Now; |
| | | // x.OperateType = (int)OperateTypeEnum.自动完成; |
| | | // x.GroupId = 0; |
| | | //}); |
| | | |
| | | stockHty.OrderList.FinishTime = DateTime.Now; |
| | | stockHty.OrderList.OperateType = (int)OperateTypeEnum.自动完成; |
| | | stockHty.OrderList.SourceId = orderStock.OrderList.Id; |
| | | stockHty.OrderList.Id = 0; |
| | | |
| | | stockHty.OrderList.orderDetailList.FinishTime = DateTime.Now; |
| | | stockHty.OrderList.orderDetailList.OperateType = (int)OperateTypeEnum.自动完成; |
| | | stockHty.OrderList.orderDetailList.Id = 0; |
| | | |
| | | return stockHty; |
| | | } |
| | | |
| | | /// <param name="task"></param> |
| | | /// <returns></returns> |
| | | private Dt_Task_Hty CreateHistoricalTask(Dt_Task task) |
| | | { |
| | | // 更新任务状态 |
| | | task.TaskState = OutTaskStatusEnum.OutFinish.ObjToInt(); |
| | | task.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); |
| | | task.CurrentAddress = task.NextAddress; |
| | | |
| | | // 创建历史任务 |
| | |
| | | taskHty.TaskId = 0; |
| | | taskHty.OperateType = (int)OperateTypeEnum.自动完成; |
| | | taskHty.SourceId = task.TaskId; |
| | | taskHty.TaskState = OutTaskStatusEnum.OutFinish.ObjToInt(); |
| | | taskHty.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); |
| | | return taskHty; |
| | | } |
| | | |
| | |
| | | /// </summary> |
| | | /// <param name="stock">库存对象</param> |
| | | /// <param name="toLocation">目标位置</param> |
| | | // 更新库存和位置信息 |
| | | private (DtStockInfo, DtLocationInfo) UpdateStockLocation(DtStockInfo stock, string toLocation) |
| | | { |
| | | // 获取库存信息 |
| | | var locationInfo = _locationRepository.QueryFirst(x => x.LocationCode == stock.LocationCode); |
| | | // 将库存状态设置为在库 |
| | | locationInfo.LocationStatus = LocationEnum.InStock.ObjToInt(); |
| | | |
| | | // 将库存位置设置为目标位置 |
| | | stock.LocationCode = toLocation; |
| | | // 将库存状态设置为在库 |
| | | stock.LocationInfo.LocationStatus = LocationEnum.InStock.ObjToInt(); |
| | | |
| | | // 返回更新后的库存和位置信息 |
| | | return (stock, locationInfo); |
| | | } |
| | | |
| | |
| | | _unitOfWorkManage.BeginTran(); |
| | | try |
| | | { |
| | | // 更新库存 |
| | | var isUpdateStock = await _stockInfoRepository.UpdateDataAsync(stock); |
| | | var isUpdateStock = true; |
| | | if (taskHty.TaskType == (int)TaskTypeEnum.Outbound) |
| | | { |
| | | // 更新库存 |
| | | isUpdateStock = await _stockInfoRepository.UpdateDataAsync(stock); |
| | | } |
| | | else |
| | | { |
| | | // 添加库存 |
| | | isUpdateStock = await _stockInfoRepository.AddDataNavAsync(stock); |
| | | } |
| | | |
| | | // 添加历史任务 |
| | | var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0; |
| | |
| | | // 提交或回滚事务 |
| | | if (isUpdateStock && isTaskHtyAdd && isTaskDelete && isUpdateLoc) |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "移库任务完成", $"事务处理完成,提交事务。添加历史任务:{isTaskHtyAdd},删除任务数据:{isTaskDelete},更新库存:{isUpdateStock},修改移库前货位状态:{isUpdateLoc}"); |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "任务完成", $"事务处理完成,提交事务。添加历史任务:{isTaskHtyAdd},删除任务数据:{isTaskDelete},更新或添加库存:{isUpdateStock},修改移库前货位状态:{isUpdateLoc}"); |
| | | _unitOfWorkManage.CommitTran(); |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "移库任务完成", $"数据处理失败,请检查数据是否正确,数据回滚。添加历史任务:{isTaskHtyAdd},删除任务数据:{isTaskDelete},更新库存:{isUpdateStock},修改移库前货位状态:{isUpdateLoc}"); |
| | | LogFactory.GetLog("任务完成").InfoFormat(true, "任务完成", $"数据处理失败,请检查数据是否正确,数据回滚。添加历史任务:{isTaskHtyAdd},删除任务数据:{isTaskDelete},更新库存:{isUpdateStock},修改移库前货位状态:{isUpdateLoc}"); |
| | | _unitOfWorkManage.RollbackTran(); |
| | | return false; |
| | | } |
| | |
| | | /// <param name="task">任务实例</param> |
| | | /// <param name="content">响应内容</param> |
| | | /// <returns></returns> |
| | | private async Task<WebResponseContent> UpdateExistingTask(RequestTaskDto input, int areaId, Dt_Task task) |
| | | private async Task<WebResponseContent> UpdateExistingTask(RequestTaskDto input, Dt_Task task) |
| | | { |
| | | // 创建WebResponseContent对象 |
| | | WebResponseContent content = new WebResponseContent(); |
| | | // 定义变量 |
| | | string toAddress; |
| | | int taskState; |
| | | string original = task.CurrentAddress; |
| | | DtLocationInfo location = new DtLocationInfo(); |
| | | int beforeStatus = 0; |
| | | |
| | | if (input.Type == (int)TaskTypeEnum.Outbound) |
| | | { |
| | | // 处理出库任务 |
| | | toAddress = await GetRoadWayAsync(areaId, task.Roadway, input.Direction, input.Area, input.Type); |
| | | taskState = (int)OutTaskStatusEnum.SC_OutFinish; |
| | | } |
| | | else |
| | | { |
| | | // 处理入库任务 |
| | | location = await GetLocationDistributeAsync(areaId, task.Roadway); |
| | | toAddress = location.LocationCode; |
| | | taskState = (int)InTaskStatusEnum.Line_InFinish; |
| | | // 处理入库任务 |
| | | location = await GetLocationDistributeAsync(task.Roadway); |
| | | toAddress = location.LocationCode; |
| | | taskState = (int)TaskInStatusEnum.Line_InFinish; |
| | | beforeStatus = location.LocationStatus; |
| | | |
| | | // 更新货位信息 |
| | | location.LocationStatus = (int)LocationEnum.Lock; |
| | | } |
| | | // 更新货位信息 |
| | | location.LocationStatus = (int)LocationEnum.Lock; |
| | | |
| | | // 更新任务信息 |
| | | task.SourceAddress = input.Position; |
| | | task.CurrentAddress = input.Position; |
| | | task.TargetAddress = toAddress; |
| | | task.NextAddress = toAddress; |
| | | task.TaskState = taskState; |
| | | |
| | | // 开始事务 |
| | | _unitOfWorkManage.BeginTran(); |
| | | // 定义变量 |
| | | bool isUpdateLo = true; |
| | | bool isUpdateChange = true; |
| | | |
| | | // 尝试更新任务 |
| | | bool isResult = await BaseDal.UpdateDataAsync(task); |
| | | bool isTaskDetail = await _taskExecuteDetailRepository.AddDetailAsync(task, true, TaskDescription.GetTaskUpdateDescription(task.PalletCode, original, input.Position, InTaskStatusEnum.Line_InFinish.GetIntegralRuleTypeEnumDesc())); |
| | | if (input.Type != (int)TaskTypeEnum.Outbound) |
| | | bool isTaskDetail = await _taskExecuteDetailRepository.AddDetailAsync(task, false, TaskDescription.GetTaskUpdateDescription(task.PalletCode, original, input.Position, TaskInStatusEnum.Line_InFinish.GetIntegralRuleTypeEnumDesc())); |
| | | |
| | | // 创建LocationChangeRecordDto对象 |
| | | LocationChangeRecordDto changeRecordDto = new LocationChangeRecordDto() |
| | | { |
| | | DtLocationStatusChangeRecord dtLocationStatusChangeRecord = new DtLocationStatusChangeRecord() |
| | | { |
| | | ChangeType = task.TaskType, |
| | | LocationCode = location.LocationCode, |
| | | LocationId = location.Id, |
| | | Creater = "System", |
| | | TaskNum = task.TaskNum, |
| | | AfterStatus = location.LocationStatus, |
| | | BeforeStatus = (int)LocationEnum.Free, |
| | | }; |
| | | isUpdateChange = await _locationStatusChangeRecordRepository.AddDataAsync(dtLocationStatusChangeRecord) > 0; |
| | | isUpdateLo = await _locationRepository.UpdateDataAsync(location); |
| | | } |
| | | // 设置变量 |
| | | AfterStatus = location.LocationStatus, |
| | | BeforeStatus = beforeStatus, |
| | | TaskNum = task.TaskNum.Value, |
| | | LocationId = location.Id, |
| | | LocationCode = location.LocationCode, |
| | | ChangeType = (int)StatusChangeTypeEnum.AutomaticStorage, |
| | | }; |
| | | // 更新位置状态 |
| | | isUpdateChange = _locationStatusChangeRecordRepository.AddStatusChangeRecord(changeRecordDto); |
| | | isUpdateLo = await _locationRepository.UpdateDataAsync(location); |
| | | |
| | | if (isResult && isUpdateLo && isTaskDetail) |
| | | { |
| | | // 提交事务 |
| | | _unitOfWorkManage.CommitTran(); |
| | | content.OK(data: task); |
| | | } |
| | | else |
| | | { |
| | | // 回滚事务 |
| | | _unitOfWorkManage.RollbackTran(); |
| | | content.Error("更新任务失败"); |
| | | } |
| | |
| | | /// <param name="areaId">区域ID</param> |
| | | /// <param name="content">响应内容</param> |
| | | /// <returns></returns> |
| | | private async Task<WebResponseContent> CreateNewTask(RequestTaskDto input, int areaId) |
| | | private async Task<WebResponseContent> CreateNewTask(List<Dt_EquipmentProcess> process, RequestTaskDto input) |
| | | { |
| | | WebResponseContent content = new WebResponseContent(); |
| | | List<string> strings = process.Select(x => x.EquipmentName).ToList(); |
| | | // 获取目标地址 |
| | | string ToAddress = await GetRoadWayAsync(areaId, input.Position, input.Direction, input.Area, input.Type); |
| | | string ToAddress = await GetRoadWayAsync(strings); |
| | | |
| | | // 创建新任务实例 |
| | | var task = new Dt_Task |
| | |
| | | OrderNo = null, |
| | | PalletCode = input.PalletCode, |
| | | SourceAddress = input.Position, |
| | | TaskState = (int)InTaskStatusEnum.InNew, |
| | | TaskState = (int)TaskInStatusEnum.InNew, |
| | | TaskType = (int)TaskTypeEnum.Inbound, |
| | | TaskNum = await BaseDal.GetTaskNo(), |
| | | TaskNum = await BaseDal.GetTaskNo(), |
| | | Creater = "Systeam" |
| | | }; |
| | | |
| | | // 尝试添加新任务 |
| | | var taskId = await BaseDal.AddDataAsync(task); |
| | | bool isResult = taskId > 0; |
| | | if (isResult) |
| | | { |
| | | task.TaskId = taskId; |
| | | isResult = await _taskExecuteDetailRepository.AddDetailAsync(task, false, TaskDescription.GetTaskUpdateDescription(input.PalletCode, input.Position, ToAddress, InTaskStatusEnum.InNew.GetIntegralRuleTypeEnumDesc())); |
| | | isResult = await _taskExecuteDetailRepository.AddDetailAsync(task, false, TaskDescription.GetTaskUpdateDescription(input.PalletCode, input.Position, ToAddress, TaskInStatusEnum.InNew.GetIntegralRuleTypeEnumDesc())); |
| | | if (isResult) |
| | | content.OK(data: task); |
| | | { |
| | | // 创建WMS任务 |
| | | WMSTaskDTO taskDTO = new WMSTaskDTO() |
| | | { |
| | | TaskNum = 0, |
| | | Grade = 1, |
| | | PalletCode = DateTime.Now.ToString("MMddHHmmss"), |
| | | RoadWay = task.Roadway, |
| | | SourceAddress = input.Position, |
| | | TargetAddress = task.Roadway, |
| | | TaskState = (int)TaskInStatusEnum.InNew, |
| | | Id = 0, |
| | | TaskType = (int)TaskInboundTypeEnum.Inbound, |
| | | }; |
| | | content.OK(data: taskDTO); |
| | | } |
| | | else |
| | | content.Error("添加任务失败"); |
| | | } |
| | |
| | | /// <param name="areaId">区域主键</param> |
| | | /// <param name="roadWay">巷道</param> |
| | | /// <returns></returns> |
| | | public async Task<DtLocationInfo> GetLocationDistributeAsync(int areaId, string roadWay) |
| | | public async Task<DtLocationInfo> GetLocationDistributeAsync(string roadWay) |
| | | { |
| | | #region 获取货位 |
| | | |
| | | try |
| | | { |
| | | var locations = await _locationRepository.QueryDataAsync(x => x.AreaId == areaId && x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay); |
| | | var locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay); |
| | | if (locations == null) |
| | | { |
| | | return null; |
| | |
| | | /// <param name="Direction">方向</param> |
| | | /// <param name="area">关系区域</param> |
| | | /// <returns></returns> |
| | | public async Task<string> GetRoadWayAsync(int areaId, string position, string Direction, string area, int type) |
| | | public async Task<string> GetRoadWayAsync(List<string> process) |
| | | { |
| | | var point = new PointStackerRelation(); |
| | | if (type == (int)TaskTypeEnum.Inbound) |
| | | { |
| | | point = await _pointStackerRelationRepository.QueryFirstAsync(x => x.Direction == Direction && x.PointCode == position && x.Area == area); |
| | | if (point == null) { return null; } |
| | | var locationInfos = await _locationRepository.QueryDataAsync(x => x.AreaId == areaId && point.StackerCode.Contains(x.RoadwayNo)); |
| | | var groupWithMinCount = locationInfos.GroupBy(x => x.RoadwayNo).OrderBy(x => x.Count()).FirstOrDefault(); |
| | | var minGroup = _locationRepository.QueryData(x => process.Contains(x.RoadwayNo) && x.LocationStatus == (int)LocationEnum.Free) |
| | | .GroupBy(x => x.RoadwayNo) |
| | | .OrderBy(g => g.Count()) // 根据每个组的元素数量排序 |
| | | .First(); // 取出数量最少的组 |
| | | |
| | | if (groupWithMinCount != null) |
| | | return groupWithMinCount.Key; |
| | | else |
| | | return null; |
| | | } |
| | | else if (type == (int)TaskTypeEnum.Outbound) |
| | | { |
| | | point = await _pointStackerRelationRepository.QueryFirstAsync(x => x.Direction == Direction && position == x.StackerCode && x.Area == area); |
| | | if (point == null) { return null; } |
| | | string minRoadwayNo = minGroup.Key; // 数量最少的组的Key |
| | | |
| | | string station = point.PointCodeList[0]; |
| | | |
| | | var rList = point.PointCodeList; |
| | | rList.Remove(station); |
| | | rList.Add(station); |
| | | |
| | | point.PointCodeList = rList; |
| | | return station; |
| | | } |
| | | else { return null; } |
| | | return minRoadwayNo; |
| | | } |
| | | |
| | | #endregion 任务请求方法 |