From 27428ddcd208e10c15adead9d6b48d6843b0a0b6 Mon Sep 17 00:00:00 2001 From: xiaoyang <xiaoyang@hnkhzn.com> Date: 星期四, 07 十一月 2024 16:15:36 +0800 Subject: [PATCH] MOM对接代码更改 --- Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs | 831 +++++++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 688 insertions(+), 143 deletions(-) diff --git a/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs b/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs index bd89329..db6dbf3 100644 --- a/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs +++ b/Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs @@ -1,8 +1,14 @@ -锘縰sing Mapster; +锘縰sing 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; @@ -12,6 +18,7 @@ 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; @@ -22,10 +29,11 @@ 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 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, @@ -44,7 +52,9 @@ IBoxingInfoRepository boxingInfoRepository, ICellStateService cellStateService, IProcessApplyService processApplyService, - IDt_AreaInfoRepository areaInfoRepository) : base(BaseDal) + IDt_AreaInfoRepository areaInfoRepository, + IAgingInOrOutInputService agingInOrOutInputService, + IStockInfoDetailRepository stockInfoDetailRepository) : base(BaseDal) { _unitOfWorkManage = unitOfWorkManage; _outOrderRepository = outOrderRepository; @@ -63,75 +73,242 @@ _cellStateService = cellStateService; _processApplyService = processApplyService; _areaInfoRepository = areaInfoRepository; + _agingInOrOutInputService = agingInOrOutInputService; + _stockInfoDetailRepository = stockInfoDetailRepository; } #region 澶栭儴鎺ュ彛鏂规硶 - #region 鍫嗗灈鏈哄嚭搴撲换鍔″畬鎴� + #region 鍑哄簱浠诲姟瀹屾垚 /// <summary> - /// 鍫嗗灈鏈哄嚭搴撲换鍔″畬鎴� + /// 鍑哄簱浠诲姟瀹屾垚 /// </summary> /// <param name="saveModel">浠诲姟鏁版嵁鍚堥泦</param> /// <returns>杩斿洖缁撴灉闆�</returns> + //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 { - // 鏇存柊搴撳瓨鐘舵�� - // 璁剧疆搴撲綅鐘舵�佷负绌洪棽 - stock.LocationInfo.LocationStatus = LocationEnum.Free.ObjToInt(); - // 璁剧疆搴撳瓨鐘舵�佷负鍑哄簱 - stock.StockInfoDetails.ForEach(x => + if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound) { - x.Status = 2; - }); + var process = await SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() + .FirstAsync(x => x.EquipmentName == task.Roadway); + var info = JsonConvert.DeserializeObject<EquipmentParameterInfo>(process.ProcessValue); - // 鏇存柊浠诲姟鐘舵�� - task.TaskState = TaskOutStatusEnum.SC_OutFinish.ObjToInt(); - task.CurrentAddress = task.NextAddress; - task.NextAddress = task.TargetAddress; + var agingOutputDto = MapToAgingOutputDto(stock, info); + content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); + ValidateResponse(content); + } - LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍫嗗灈鏈哄嚭搴撳畬鎴�", "鏇存柊搴撳瓨鐘舵�佷笌浠诲姟鐘舵��"); + // 鏇存柊搴撳瓨鐘舵�佸拰浠诲姟鐘舵�� + (var loc, var tas) = UpdateStockAndTaskStatus(stock, task); // 浜嬪姟澶勭悊 - // 寮�濮嬩簨鍔� - _unitOfWorkManage.BeginTran(); - // 鏇存柊搴撳瓨淇℃伅 - var isStockUpdated = _stockInfoRepository.UpdateData(stock); - // 鏇存柊浠诲姟淇℃伅 - var isTaskUpdated = await Update(task); + await _unitOfWorkManage.UseTranAsync(async () => + { + await UpdateLocationAsync(loc); + await DeleteStockInfoAsync(stock.Id); + await DeleteStockInfoDetailsAsync(stock.StockInfoDetails); + await DeleteTaskAsync(task.TaskId); + }); - // 濡傛灉搴撳瓨淇℃伅鍜屼换鍔′俊鎭兘鏇存柊鎴愬姛 - 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("浠诲姟鎴栧簱瀛樻洿鏂板け璐�"); - } + return content.OK("浠诲姟瀹屾垚鎴愬姛"); } catch (Exception err) { - LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, $"绯荤粺寮傚父锛屽紓甯镐俊鎭細{err.Message}", ""); - Console.WriteLine(err.Message); + LogFactory.GetLog("浠诲姟瀹屾垚").Error(true, $"绯荤粺寮傚父锛屽紓甯镐俊鎭細{err.Message}"); return content.Error(err.Message); } } - #endregion 鍫嗗灈鏈哄嚭搴撲换鍔″畬鎴� + 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 绉诲簱浠诲姟瀹屾垚 @@ -173,47 +350,187 @@ /// </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; + // 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); - var boxDetail = boxing.BoxingInfoDetails.Adapt<List<DtStockInfoDetail>>(); - // 鍒涘缓搴撳瓨瀹炰緥妯″瀷 - DtStockInfo stock = new DtStockInfo() - { - PalletCode = task.PalletCode, - LocationCode = task.TargetAddress, - CreateDate = DateTime.Now, - Creater = "system", - IsFull = boxing.IsFull, - StockInfoDetails = boxDetail, - LocationInfo = new DtLocationInfo() - }; + // 鏇存柊鐩爣浣嶇疆鐘舵�佷负搴撳瓨涓� + locationInf.LocationStatus = (int)LocationEnum.InStock; // 鍒涘缓鍘嗗彶浠诲姟瀹炰緥妯″瀷 var taskHty = CreateHistoricalTask(task); - // 淇敼璐т綅淇℃伅涓烘湁璐� - var locationInf = await _locationRepository.QueryFirstAsync(x => x.LocationCode == task.TargetAddress); - locationInf.LocationStatus = (int)LocationEnum.InStock; - - LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍏ュ簱浠诲姟瀹屾垚", $"璐т綅鍦板潃锛歿task.TargetAddress},淇敼鍚庤揣浣嶆暟鎹細{locationInf}"); + // 鏍规嵁鏄惁鏈夌粍鐩樹俊鎭垱寤哄簱瀛樺疄渚嬫ā鍨� + 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 鍏ュ簱浠诲姟瀹屾垚 @@ -221,13 +538,15 @@ #region 浠诲姟瀹屾垚 /// <summary> - /// 浠诲姟瀹屾垚 + /// 瀹屾垚浠诲姟 /// </summary> - /// <param name="taskNum">浠诲姟鍙�</param> - /// <returns></returns> + /// <param name="taskNum">浠诲姟缂栧彿</param> + /// <returns>杩斿洖缁撴灉闆�</returns> public async Task<WebResponseContent> CompleteAsync(int taskNum) { + // 鍒濆鍖栧搷搴斿唴瀹� WebResponseContent content = new WebResponseContent(); + // 鎻愬彇浠诲姟鏁版嵁 LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鎻愬彇浠诲姟鏁版嵁", $"浠诲姟鍙凤細{taskNum}"); @@ -241,51 +560,28 @@ // 楠岃瘉搴撳瓨鏄惁瀛樺湪 var stock = await _stockInfoRepository.QueryFirstAsync(x => x.PalletCode == task.PalletCode); - if (stock == null) + + // 鏍规嵁浠诲姟绫诲瀷璋冪敤鐩稿簲鐨勫畬鎴愪换鍔℃柟娉� + switch (task.TaskType) { - LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "搴撳瓨涓嶅瓨鍦ㄥ瓨鍦紝鍒ゆ柇鏄惁鏄叆搴撲换鍔�", $"{task.TaskType}"); - if (task.TaskType == (int)TaskInboundTypeEnum.Inbound) - { + case (int)TaskInboundTypeEnum.Inbound: + case (int)TaskInboundTypeEnum.InTray: LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍏ュ簱浠诲姟", ""); return await CompleteInboundTaskAsync(task); - } - else - { - LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "搴撳瓨涓嶅瓨鍦ㄤ篃涓嶆槸鍏ュ簱浠诲姟", ""); - return content.Error("搴撳瓨涓嶅瓨鍦�"); - } - } - LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "楠岃瘉搴撳瓨鏄惁瀛樺湪", JsonConvert.SerializeObject(stock)); - if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound) - { - LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍑哄簱浠诲姟", ""); - if (task.TaskState == TaskOutStatusEnum.SC_OutExecuting.ObjToInt()) - { - LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍫嗗灈鏈哄嚭搴撳畬鎴�", ""); + case (int)TaskOutboundTypeEnum.OutTray: + case (int)TaskOutboundTypeEnum.Outbound: + LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍑哄簱浠诲姟", ""); return await CompleteStackTaskAsync(task, stock); - } - else - { - LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "搴撳瓨涓嶅瓨鍦ㄤ篃涓嶆槸鍏ュ簱浠诲姟", ""); - return content.Error("搴撳瓨涓嶅瓨鍦�"); - } - } - 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 璇锋眰浠诲姟 + #region 璇锋眰浠诲姟鍏ュ簱 /// <summary> /// 璇锋眰浠诲姟 @@ -299,10 +595,20 @@ try { + + // 璋冪敤BaseDal.QueryFirstAsync鏂规硶锛屾煡璇换鍔� + var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == input.PalletCode); + if (task != null) + { + content = await UpdateExistingTask(input, task); + return content; + } // 鍒涘缓涓�涓猅rayCellsStatusDto瀵硅薄锛屽苟璧嬪�� TrayCellsStatusDto trayCells = new TrayCellsStatusDto() { - TrayBarcode = input.PalletCode + Software = "WMS", + TrayBarcode = input.PalletCode, + EquipmentCode = "ECH001-B" }; // 璋冪敤GetTrayCellStatusAsync鏂规硶锛岃幏鍙栨暣鐩樼數鑺� @@ -310,18 +616,26 @@ // 濡傛灉鐘舵�佷负false锛屽垯杩斿洖content if (!content.Status) return content; - // 璋冪敤GetProcessApplyAsync鏂规硶锛岃幏鍙栧伐鑹虹敵璇� - ProcessApplyDto process = await GetProcessApplyAsync(content); + // 娣诲姞缁勭洏淇℃伅 + // 灏哻ontent.Data杞崲涓篟esultTrayCellsStatus瀵硅薄 + var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + var boxing = await CreateBoxingInfo(result, input.PalletCode); + + // 璋冪敤GetProcessApplyAsync鏂规硶锛岃幏鍙栧伐鑹鸿矾绾� + ProcessApplyDto process = await GetProcessApplyAsync(result); + // 濡傛灉process涓簄ull锛屽垯杩斿洖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); // 濡傛灉task涓嶄负null锛屽垯璋冪敤UpdateExistingTask鏂规硶锛屾洿鏂颁换鍔★紱鍚﹀垯璋冪敤CreateNewTask鏂规硶锛屽垱寤烘柊浠诲姟 content = task != null ? await UpdateExistingTask(input, task) : await CreateNewTask(processResponse, input); + if (content.Status) + { + var isBox = await _boxingInfoRepository.AddDataNavAsync(boxing); + } } catch (Exception err) { @@ -341,19 +655,34 @@ return await _cellStateService.GetTrayCellStatusAsync(trayCells); } - // 鑾峰彇宸ヨ壓鐢宠 - private async Task<ProcessApplyDto> GetProcessApplyAsync(WebResponseContent content) + // 鑾峰彇缁勭洏淇℃伅 + private async Task<DtBoxingInfo> CreateBoxingInfo(ResultTrayCellsStatus result, string palletCode) { - // 濡傛灉鐘舵�佷负false锛屽垯杩斿洖null - if (!content.Status) return null; + 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 = serialNoObj.BindCode, + Remark = result.TrayBarcodePropertys.ToJsonString(), + }).ToList() + }; + } - // 灏哻ontent.Data杞崲涓篟esultTrayCellsStatus瀵硅薄 - var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + // 鑾峰彇宸ヨ壓鐢宠 + private async Task<ProcessApplyDto> GetProcessApplyAsync(ResultTrayCellsStatus content) + { // 鍒涘缓涓�涓狿rocessApplyDto瀵硅薄锛屽苟璧嬪�� return new ProcessApplyDto() { - WipOrderNo = result.BindCode, - SerialNos = result.SerialNos.Select(item => new SerialNos + EquipmentCode = "ECH001-B", + Software = "WMS", + //WipOrderNo = result.BindCode, + SerialNos = content.SerialNos.Select(item => new SerialNos { SerialNo = item.SerialNo }).ToList() @@ -378,7 +707,13 @@ { case "1088": return SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() - .Where(x => x.EquipmentType == "闄堝寲" && x.WipOrderNo == apply.WipOrderNo && x.ProductDesc == apply.ProductNo) + .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: @@ -386,22 +721,238 @@ } } - #endregion 璇锋眰浠诲姟 + #endregion 璇锋眰浠诲姟鍏ュ簱 - #region 璇锋眰绌烘墭鐩� + #region 璇锋眰鍑哄簱 - public async Task<WebResponseContent> RequestTrayTaskAsync(string position) + //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 { - var area = _areaInfoRepository.QueryFirst(x => x.AreaCode == "CH"); + // 鏍规嵁鎵樼洏绫诲瀷鏌ヨ搴撳瓨淇℃伅 + DtStockInfo stockInfo = tag == 1 + ? QueryStockInfoForRealTray(areaCode, roadways) + : QueryStockInfoForEmptyTray(areaCode, roadways); - var stockInfo = _stockInfoRepository.QueryData(x => x.Remark == area.AreaCode && x.StockInfoDetails.Any(z => z.MaterielCode == "绌烘墭鐩�")).OrderBy(x => x.CreateDate).FirstOrDefault(); - // 鍒涘缓鏂颁换鍔″疄渚� - var task = new Dt_Task + if (stockInfo == null) { - CurrentAddress = stockInfo.LocationCode, + 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, @@ -416,7 +967,6 @@ TaskNum = await BaseDal.GetTaskNo(), Creater = "Systeam" }; - var taskId = await BaseDal.AddDataAsync(task); bool isResult = taskId > 0; if (isResult) @@ -433,6 +983,8 @@ Id = 0, TaskType = (int)TaskOutboundTypeEnum.OutTray }; + stockInfo.LocationInfo.LocationStatus = (int)LocationEnum.InStockDisable; + _locationRepository.UpdateData(stockInfo.LocationInfo); content.OK(data: taskDTO); } } @@ -443,7 +995,7 @@ return content; } - #endregion 璇锋眰绌烘墭鐩� + #endregion 闄堝寲璇锋眰鍑哄簱 #endregion 澶栭儴鎺ュ彛鏂规硶 @@ -693,6 +1245,8 @@ isUpdateStock = await _stockInfoRepository.AddDataNavAsync(stock); } + + // 娣诲姞鍘嗗彶浠诲姟 var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHty) > 0; @@ -745,15 +1299,6 @@ 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)TaskOutStatusEnum.SC_OutFinish; - //} - //else - //{ // 澶勭悊鍏ュ簱浠诲姟 location = await GetLocationDistributeAsync(task.Roadway); toAddress = location.LocationCode; @@ -762,10 +1307,8 @@ // 鏇存柊璐т綅淇℃伅 location.LocationStatus = (int)LocationEnum.Lock; - //} // 鏇存柊浠诲姟淇℃伅 - //task.SourceAddress = input.Position; task.CurrentAddress = input.Position; task.TargetAddress = toAddress; task.NextAddress = toAddress; @@ -843,6 +1386,7 @@ TaskNum = await BaseDal.GetTaskNo(), Creater = "Systeam" }; + // 灏濊瘯娣诲姞鏂颁换鍔� var taskId = await BaseDal.AddDataAsync(task); bool isResult = taskId > 0; @@ -852,17 +1396,18 @@ isResult = await _taskExecuteDetailRepository.AddDetailAsync(task, false, TaskDescription.GetTaskUpdateDescription(input.PalletCode, input.Position, ToAddress, TaskInStatusEnum.InNew.GetIntegralRuleTypeEnumDesc())); if (isResult) { + // 鍒涘缓WMS浠诲姟 WMSTaskDTO taskDTO = new WMSTaskDTO() { - TaskNum = 0, + TaskNum = task.TaskNum.Value, Grade = 1, - PalletCode = DateTime.Now.ToString("MMddHHmmss"), + PalletCode = task.PalletCode, RoadWay = task.Roadway, - SourceAddress = input.Position, + SourceAddress = task.SourceAddress, TargetAddress = task.Roadway, - TaskState = (int)TaskInStatusEnum.InNew, + TaskState = task.TaskState.Value, Id = 0, - TaskType = (int)TaskInboundTypeEnum.Inbound, + TaskType = task.TaskType, }; content.OK(data: taskDTO); } -- Gitblit v1.9.3