From e59d1777a111b6573b93afc58cca18c8c026ed9b Mon Sep 17 00:00:00 2001 From: 肖洋 <cathay_xy@163.com> Date: 星期六, 04 一月 2025 09:57:43 +0800 Subject: [PATCH] 更新输送线目标地址和日志记录逻辑 --- Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs | 596 +++++++++++++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 515 insertions(+), 81 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 c940d53..b8ee868 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,11 +1,18 @@ -锘縰sing Mapster; +锘縰sing AngleSharp.Dom; +using log4net.Core; +using Mapster; using Masuit.Tools; +using SixLabors.Fonts.Tables.AdvancedTypographic; +using System.Diagnostics; using System.Text.RegularExpressions; +using System.Threading.Tasks; using WIDESEA_Core.Const; using WIDESEA_DTO.MOM; using WIDESEA_DTO.WMS; using WIDESEA_IServices; using WIDESEA_IStoragIntegrationServices; +using WIDESEA_StorageBasicRepository; +using WIDESEA_StoragIntegrationServices; using WIDESEAWCS_BasicInfoRepository; namespace WIDESEA_StorageTaskServices; @@ -75,18 +82,107 @@ { if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound) { + #region 鑰佺増鏈� //var process = await SqlSugarHelper.Db.Queryable<Dt_EquipmentProcess>() // .FirstAsync(x => x.EquipmentName == task.Roadway); //var info = JsonConvert.DeserializeObject<ResponseEqptRunDto>(process.ProcessValue); - if (!task.Roadway.Contains("FR") && stock.ProcessCode != "OCVB") //闈炲垎瀹瑰簱鍖轰笌褰撳墠宸ュ簭鏄疧CVB鍧囦笂鎶OM鍑哄叆绔� + //if (!task.Roadway.Contains("FR") && stock.ProcessCode != "OCVB") //闈炲垎瀹瑰簱鍖轰笌褰撳墠宸ュ簭鏄疧CVB鍧囦笂鎶OM鍑哄叆绔� + //{ + // var agingOutputDto = MapToAgingOutputDto(stock); + // content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); + // //ValidateResponse(content); + // var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); + // if (!result.Success || !agingOutputDto.SerialNos[0].SerialNoResult) + // { + // if (result.MessageCode == "E10001") + // { + // var area = _areaInfoRepository.QueryFirst(x => x.AreaCode == stock.AreaCode); + // if (area == null) + // { + // throw new Exception("鏈壘鍒板搴旂殑搴撳尯淇℃伅"); + // } + // var trayCells = new TrayCellsStatusDto() + // { + // Software = area.Spare3, + // TrayBarcode = task.PalletCode, + // EquipmentCode = area.Spare2, + // SceneType = area.Spare4 + // }; + // content = await _cellStateService.GetTrayCellStatusAsync(trayCells); + // if (!content.Status) return content; + + // var ResultTray = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + // if (ResultTray.SerialNos.Count > 0) + // { + // var parameterInfo = JsonConvert.DeserializeObject<List<ParameterInfo>>(stock.ParameterInfos).FirstOrDefault(y => y.Description.Contains("鏃堕棿")); + // if (parameterInfo == null) throw new Exception(""); + + // var outHours = (DateTime.Now - (stock.LinedProcessFeedbackTime == null ? stock.CreateDate : stock.LinedProcessFeedbackTime.ToDateTime())).TotalHours; + + // var isNG = outHours > parameterInfo.LowerSpecificationsLimit.ToDouble() && outHours < parameterInfo.UpperSpecificationsLimit.ToDouble(); + + // var defectCode = string.Empty; + // if (!isNG) defectCode = "TQCK"; + // var outputDto = new AgingOutputDto + // { + // OpFlag = 1, + // Software = area.Spare3, + // EquipmentCode = area.Spare2, + // TrayBarcode = stock.PalletCode, + // SerialNos = ResultTray.SerialNos.Select(x => new SerialNoOutDto + // { + // SlotNo = x.PositionNo, + // SerialNo = x.SerialNo, + // SerialNoResult = true, //isNG, + // ParameterInfo = new List<ParameterInfoOutput> { + // new ParameterInfoOutput() { + // Value = outHours.ToString(), + // ParameterCode =parameterInfo.ParameterCode, + // ParameterDesc = parameterInfo.Description, + // ParameterResult = "OK", //isNG.ToString(), + // TargetValue = parameterInfo.TargetValue, + // LowerLomit = parameterInfo.LowerSpecificationsLimit, + // UpperLimit = parameterInfo.UpperSpecificationsLimit, + // DefectCode = defectCode, + // UOMCode = parameterInfo.UOMCode, + // } + // } + // }).ToList() + // }; + + // content = await _agingInOrOutInputService.GetOCVOutputAsync(outputDto); + // result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); + // if (!result.Success) + // task.Remark = "NG"; + // } + // } + // else + // task.Remark = "NG"; + // } + //} + #endregion 鑰佺増鏈� + + if (task.TaskType == (int)TaskOutboundTypeEnum.Outbound) { - var agingOutputDto = MapToAgingOutputDto(stock); - content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); - //ValidateResponse(content); - var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); - if (!result.Success || !agingOutputDto.SerialNos[0].SerialNoResult) + if (!task.Roadway.Contains("FR") && stock.ProcessCode != "OCVB") { - task.Remark = "NG"; + var agingOutputDto = MapToAgingOutputDto(stock); + content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); + + if (content.Status) + { + var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); + task.Remark = result.Success ? null : "NG"; + + if (!result.Success && result.MessageCode == "E10001") + { + await HandleOutBoundError(stock, task); + } + } + else + { + task.Remark = "NG"; + } } } } @@ -94,6 +190,10 @@ // 鏇存柊搴撳瓨鐘舵�佸拰浠诲姟鐘舵�� (var loc, var tas) = UpdateStockAndTaskStatus(stock, task); var taskHty = task.Adapt<Dt_Task_Hty>(); + taskHty.FinishTime = DateTime.Now; + + DtStockInfo_Hty stockInfo_Hty = stock.Adapt<DtStockInfo_Hty>(); + stockInfo_Hty.ModifyDate = DateTime.Now; // 浜嬪姟澶勭悊 await _unitOfWorkManage.UseTranAsync(async () => @@ -102,9 +202,9 @@ { await DeleteStockInfoAsync(stock.Id); await DeleteStockInfoDetailsAsync(stock.StockInfoDetails); + await AddStockInfoHtyAsync(stockInfo_Hty); } await UpdateLocationAsync(loc); - //if (task.Roadway.Contains("FR") || task.Roadway.Contains("GW") || task.TaskType == (int)TaskOutboundTypeEnum.OutTray) //濡傛灉鏄垎瀹规垨楂樻俯鍑哄簱 灏嗕换鍔″垹闄� await DeleteTaskAsync(task.TaskId); await AddTaskHtyAsync(taskHty); }); @@ -173,19 +273,17 @@ }; } - private void ValidateResponse(WebResponseContent content) - { - } - private (DtLocationInfo, Dt_Task) UpdateStockAndTaskStatus(DtStockInfo stock, Dt_Task task) { var location = _locationRepository.QueryFirst(x => x.LocationCode == task.SourceAddress && x.RoadwayNo == task.Roadway); //var details = _stockInfoDetailRepository.QueryData(x => x.StockId == stock.Id); - + int lastStatus = location.LocationStatus; location.LocationStatus = (int)LocationEnum.Free; task.TaskState = (int)TaskOutStatusEnum.OutFinish; //task.CurrentAddress = task.NextAddress; //task.NextAddress = task.TargetAddress; + + _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(location, lastStatus, (int)StatusChangeTypeEnum.AutomaticDelivery,task.TaskNum); LogFactory.GetLog("浠诲姟瀹屾垚").Info(true, "鏇存柊搴撳瓨鐘舵�佷笌浠诲姟鐘舵��"); return (location, task); @@ -197,6 +295,15 @@ if (!isStockUpdated) { throw new Exception("搴撳瓨淇℃伅鏇存柊澶辫触"); + } + } + + private async Task AddStockInfoHtyAsync(DtStockInfo_Hty dtStock) + { + var isStockAdd = await SqlSugarHelper.Db.InsertNav(dtStock).IncludesAllFirstLayer().ExecuteCommandAsync(); + if (!isStockAdd) + { + throw new Exception("搴撳瓨鍘嗗彶淇℃伅娣诲姞澶辫触"); } } @@ -252,7 +359,7 @@ try { // 鏇存柊璐т綅鍜屽簱瀛樹俊鎭� - (DtStockInfo updateStock, DtLocationInfo locationInForm, DtLocationInfo locationInfoTo) = UpdateStockLocation(stock, task); + (DtStockInfo updateStock, DtLocationInfo locationInForm, DtLocationInfo locationInfoTo) = UpdateStockLocation(stock, task); var taskHty = CreateHistoricalTask(task); LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "绉诲簱浠诲姟瀹屾垚", $"璐т綅鍦板潃锛歿task.TargetAddress},淇敼鍚庡簱瀛樻暟鎹細{JsonConvert.SerializeObject(updateStock)}锛屽師鍏堣揣浣嶆暟鎹細{locationInForm}"); @@ -285,7 +392,7 @@ WebResponseContent content = new WebResponseContent(); try { - if (task.TaskType == (int)TaskInboundTypeEnum.InNG) + if (task.TaskType == (int)TaskInboundTypeEnum.InNG || task.TaskType == (int)TaskInboundTypeEnum.InQuality) { task.TaskState = (int)TaskInStatusEnum.SC_InFinish; // 鍒涘缓鍘嗗彶浠诲姟瀹炰緥妯″瀷 @@ -309,6 +416,7 @@ var boxing = await _boxingInfoRepository.QueryFirstNavAsync(x => x.PalletCode == task.PalletCode); var locationInf = await _locationRepository.QueryFirstAsync(x => x.LocationCode == task.TargetAddress && x.RoadwayNo == task.Roadway); + int lastStatus = locationInf.LocationStatus; // 鏇存柊鐩爣浣嶇疆鐘舵�佷负搴撳瓨涓� locationInf.LocationStatus = (int)LocationEnum.InStock; @@ -320,6 +428,10 @@ await _locationRepository.UpdateDataAsync(locationInf); await _task_HtyRepository.AddDataAsync(taskHty); await BaseDal.DeleteDataAsync(task); + + //璁板綍璐т綅鍙樺姩淇℃伅 + _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(locationInf, lastStatus, (int)StatusChangeTypeEnum.AutomaticStorage, task.TaskNum); + return content.OK("鍏ュ簱浠诲姟瀹屾垚鎴愬姛"); } // 鏍规嵁鏄惁鏈夌粍鐩樹俊鎭垱寤哄簱瀛樺疄渚嬫ā鍨� @@ -329,6 +441,7 @@ bool isResult = await ExecuteTransaction(stock, taskHty, locationInf, task.TaskId, boxing); if (isResult) { + _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(locationInf, lastStatus, (int)StatusChangeTypeEnum.AutomaticStorage, task.TaskNum); content.OK("鍏ュ簱浠诲姟瀹屾垚鎴愬姛"); } else @@ -454,7 +567,7 @@ Remark = boxing.BoxingInfoDetails.Count().ToString(), }; - if (boxing.ProcessCode != "OCVB" && !task.Roadway.Contains("FR")) + if (boxing.ProcessCode != "OCVB" || !task.Roadway.Contains("FR")) { // 澶勭悊璇锋眰鍙傛暟 AgingInputDto agingInputDto = new AgingInputDto() @@ -539,6 +652,7 @@ case (int)TaskInboundTypeEnum.Inbound: case (int)TaskInboundTypeEnum.InTray: case (int)TaskInboundTypeEnum.InNG: + case (int)TaskInboundTypeEnum.InQuality: LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍏ュ簱浠诲姟", ""); return await CompleteInboundTaskAsync(task); @@ -852,11 +966,17 @@ // 鍒涘缓骞惰幏鍙栨暣鐩樼數鑺姸鎬� TrayCellsStatusDto trayCells = CreateTrayCellsStatusDto(area, input.PalletCode); content = await GetTrayCellStatusAsync(trayCells); - if (!content.Status) return content; + if (!content.Status) + { + ConsoleHelper.WriteErrorLine($"鑾峰彇鐢佃姱鐘舵�佸け璐�:{content.Message}"); + return content; + } var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + if (!result.Success) { + ConsoleHelper.WriteErrorLine($"鑾峰彇鐢佃姱鐘舵�佸け璐�:{result.MOMMessage}"); if (result.SerialNos.Count <= 0) { // 绌烘墭鐩樺叆搴撻�昏緫 @@ -875,7 +995,7 @@ } // 澶勭悊寮傚父鐢佃姱鎯呭喌 - var serialNosError = result.SerialNos.Where(x => x.SerialNoStatus != 1).ToList(); + var serialNosError = result.SerialNos.Where(x => x.SerialNoStatus != 1 && x.SerialNoStatus != 4).ToList(); if (serialNosError.Count > 0) { return await HandleErrorCells(input, area, serialNosError); @@ -914,7 +1034,7 @@ } catch (Exception err) { - throw; + return content.Error(err.Message); } } @@ -1026,7 +1146,7 @@ { // 鏍规嵁鎵樼洏绫诲瀷鏌ヨ搴撳瓨淇℃伅 DtStockInfo stockInfo = tag == (int)TaskOutboundTypeEnum.Outbound - ? areaCodes == null ? await QueryStockInfoForRealTrayAsync(areaCode, productionLine) : await QueryStockInfoForRealTrayCWAsync(areaCodes, productionLine) + ? areaCode != "CWSC1" ? await QueryStockInfoForRealTrayAsync(areaCode, areaCodes, productionLine) : await QueryStockInfoForRealTrayCWAsync(areaCodes, productionLine) : await QueryStockInfoForEmptyTrayAsync(areaCode); if (stockInfo == null) @@ -1074,7 +1194,7 @@ /// <summary> /// 鏌ヨ瀹炵洏搴撳瓨淇℃伅 /// </summary> - private async Task<DtStockInfo> QueryStockInfoForRealTrayAsync(string areaCode, string productionLine) + private async Task<DtStockInfo> QueryStockInfoForRealTrayAsync(string areaCode, List<string> devices, string productionLine) { var area = await _areaInfoRepository.QueryFirstAsync(x => x.AreaCode == areaCode); @@ -1083,7 +1203,8 @@ .Includes(x => x.StockInfoDetails) // 棰勫姞杞絊tockInfoDetails .Where(x => x.AreaCode == areaCode && x.OutboundTime < DateTime.Now && x.IsFull == true) // 杩囨护鏉′欢 .WhereIF(!productionLine.IsNullOrEmpty(), x => x.ProductionLine == productionLine) - .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID) // 杩囨护鏉′欢 + .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢 + .WhereIF(!devices.IsNullOrEmpty(), x => devices.Contains(x.LocationInfo.RoadwayNo)) .OrderBy(x => x.OutboundTime) // 鎺掑簭 .FirstAsync(); // 鑾峰彇绗竴涓厓绱� @@ -1094,7 +1215,7 @@ } /// <summary> - /// 鏌ヨ瀹炵洏搴撳瓨淇℃伅 + /// 鏌ヨ甯告俯瀹炵洏搴撳瓨淇℃伅 /// </summary> private async Task<DtStockInfo> QueryStockInfoForRealTrayCWAsync(List<string> areaCodes, string productionLine) { @@ -1105,7 +1226,7 @@ .Includes(x => x.StockInfoDetails) // 棰勫姞杞絊tockInfoDetails .Where(x => areaCodes.Contains(x.AreaCode) && x.OutboundTime < DateTime.Now && x.IsFull == true) // 杩囨护鏉′欢 .WhereIF(!productionLine.IsNullOrEmpty(), x => x.ProductionLine == productionLine) - .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID) // 杩囨护鏉′欢 + .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢 .OrderBy(x => x.OutboundTime) // 鎺掑簭 .FirstAsync(); // 鑾峰彇绗竴涓厓绱� @@ -1127,7 +1248,7 @@ .Includes(x => x.StockInfoDetails) // 棰勫姞杞絊tockInfoDetails .Where(x => x.AreaCode == areaCode && x.IsFull == false) .Where(x => x.StockInfoDetails.Any(y => y.MaterielCode == "绌烘墭鐩�")) - .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID) // 杩囨护鏉′欢 + .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢 .OrderBy(x => x.CreateDate) // 鎺掑簭 .FirstAsync(); // 杞崲涓哄垪琛� @@ -1143,7 +1264,7 @@ { return new Dt_Task { - Grade = 1, + Grade = tag == 104 ? 2 : 1, Roadway = stockInfo.LocationInfo.RoadwayNo, TargetAddress = position, Dispatchertime = DateTime.Now, @@ -1170,7 +1291,7 @@ return new WMSTaskDTO { TaskNum = task.TaskNum.Value, - Grade = 1, + Grade = task.Grade.Value, PalletCode = task.PalletCode, RoadWay = task.Roadway, SourceAddress = task.SourceAddress, @@ -1325,8 +1446,131 @@ #region 闈欑疆寮傚父鍙e叆搴� - public async Task<WebResponseContent> CreateAndSendInboundTask(string locationCode, string palletCode, string position) + public async Task<WebResponseContent> CreateAndSendInboundTask(string palletCode, string position) { + #region + //WebResponseContent content = new WebResponseContent(); + //try + //{ + // // 鏌ヨ搴撳瓨淇℃伅 + // var stockInfo = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == palletCode); + // if (stockInfo == null) + // { + // var taskOld = BaseDal.QueryFirst(x => x.PalletCode == palletCode); + // if (!taskOld.IsNullOrEmpty()) + // {// 鍒涘缓WMS浠诲姟 + // WMSTaskDTO taskDTO = new WMSTaskDTO() + // { + // TaskNum = taskOld.TaskNum.Value, + // Grade = 1, + // PalletCode = taskOld.PalletCode, + // RoadWay = taskOld.Roadway, + // SourceAddress = taskOld.CurrentAddress, + // TargetAddress = taskOld.TargetAddress, + // TaskState = taskOld.TaskState.Value, + // Id = 0, + // TaskType = taskOld.TaskType, + // }; + // return content.OK(data: taskDTO); + // } + // var area = _areaInfoRepository.QueryFirst(x => x.AreaID == 2); + // var station = _stationManagerRepository.QueryFirst(x => x.stationChildCode == position); + // TrayCellsStatusDto trayCells = CreateTrayCellsStatusDto(area, palletCode); + // content = await GetTrayCellStatusAsync(trayCells); + // if (!content.Status) return content; + + // ConsoleHelper.WriteErrorLine(content.ToJsonString()); + // var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + // if (!result.Success) return content.Error(result.MOMMessage); + + // if (result.SerialNos.Count > 0) + // { + // var boxing = CreateBoxingInfo(result, palletCode); + // if (boxing == null) return content.Error("缁勭洏澶辫触"); + + // // 鑾峰彇宸ヨ壓璺嚎 + // ProcessApplyDto process = await GetProcessApplyAsync(result); + // // 璧嬪�间笂浣嶈蒋浠跺悕绉板拰璁惧缂栫爜 + // process.Software = area.Spare3; + // process.EquipmentCode = area.Spare2; + // content = await _processApplyService.GetProcessApplyAsync(process); + // if (!content.Status) return content.Error("宸ヨ壓鐢宠澶辫触"); + + // var resultProcessApply = JsonConvert.DeserializeObject<ResultProcessApply>(content.Data.ToString()); + // if (!resultProcessApply.Success) return content.Error("宸ヨ壓鐢宠澶辫触"); + + // var number = resultProcessApply.ProcessInfo.Where(x => x.ProcessCode.Contains(boxing.ProcessCode)).FirstOrDefault().Number.ToInt32(); + // foreach (var item in resultProcessApply.ProcessInfo) + // { + // if (item.Number.ToInt32() == number + 1) + // { + // boxing.NextProcessCode = item.ProcessCode; + // } + // } + // var location = await GetLocationDistributeAsync(station.Roadway); + + // ConsoleHelper.WriteErrorLine(location.ToJsonString()); + + // // 鍒涘缓鏂颁换鍔″疄渚� + // var task = new Dt_Task + // { + // CurrentAddress = station.stationLocation, + // Grade = 1, + // Roadway = station.Roadway, + // TargetAddress = location.LocationCode, + // Dispatchertime = DateTime.Now, + // MaterialNo = "", + // NextAddress = location.LocationCode, + // OrderNo = null, + // PalletCode = palletCode, + // SourceAddress = position, + // TaskState = (int)TaskInStatusEnum.Line_InFinish, + // TaskType = (int)TaskInboundTypeEnum.Inbound, + // TaskNum = await BaseDal.GetTaskNo(), + // Creater = "Systeam" + // }; + + // // 鍒涘缓WMS浠诲姟 + // WMSTaskDTO taskDTO = 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, + // }; + + // await _unitOfWorkManage.UseTranAsync(async () => + // { + // // 娣诲姞浠诲姟鍒版暟鎹簱 + // await BaseDal.AddDataAsync(task); + // // 鏇存柊搴撳瓨浣嶇疆鐘舵�佷负涓嶅彲鐢� + // location.LocationStatus = (int)LocationEnum.InStockDisable; + // await _locationRepository.UpdateDataAsync(location); + // await _boxingInfoRepository.AddDataNavAsync(boxing); + // }); + + // content.OK(data: taskDTO); + // } + // else + // content.Error(result.MOMMessage); + // } + // else + // { + // // TODO璐ㄦ鍥炲簱 + // var area = _areaInfoRepository.QueryFirst(x => x.AreaID == 2); + // } + //} + //catch (Exception ex) + //{ + // content.Error(ex.Message); + //} + //return content; + #endregion WebResponseContent content = new WebResponseContent(); try { @@ -1334,65 +1578,88 @@ var stockInfo = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == palletCode); if (stockInfo == null) { + var taskOld = BaseDal.QueryFirst(x => x.PalletCode == palletCode); + if (taskOld != null) + { + // 鍒涘缓WMS浠诲姟 + WMSTaskDTO taskDTO = CreateWMSTaskDTO(taskOld); + return content.OK(data: taskDTO); + } var area = _areaInfoRepository.QueryFirst(x => x.AreaID == 2); var station = _stationManagerRepository.QueryFirst(x => x.stationChildCode == position); TrayCellsStatusDto trayCells = CreateTrayCellsStatusDto(area, palletCode); content = await GetTrayCellStatusAsync(trayCells); if (!content.Status) return content; + ConsoleHelper.WriteErrorLine(content.ToJsonString()); var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); - if (!result.Success) + if (result == null || !result.Success) return content.Error(result?.MOMMessage ?? "Deserialization error"); + + if (result.SerialNos.Count > 0) { - if (result.SerialNos.Count <= 0) + var boxing = CreateBoxingInfo(result, palletCode); + if (boxing == null) return content.Error("缁勭洏澶辫触"); + + // 鑾峰彇宸ヨ壓璺嚎 + ProcessApplyDto process = await GetProcessApplyAsync(result); + // 璧嬪�间笂浣嶈蒋浠跺悕绉板拰璁惧缂栫爜 + process.Software = area.Spare3; + process.EquipmentCode = area.Spare2; + + content = await _processApplyService.GetProcessApplyAsync(process); + if (!content.Status) return content.Error("宸ヨ壓鐢宠澶辫触"); + + var resultProcessApply = JsonConvert.DeserializeObject<ResultProcessApply>(content.Data.ToString()) as ResultProcessApply; + if (resultProcessApply == null || !resultProcessApply.Success) return content.Error("宸ヨ壓鐢宠澶辫触"); + + var number = resultProcessApply.ProcessInfo.Where(x => x.ProcessCode.Contains(boxing.ProcessCode)).FirstOrDefault()?.Number.ToInt32() ?? 0; + foreach (var item in resultProcessApply.ProcessInfo) { - var location = await GetLocationDistributeAsync(station.Roadway); - // 鍒涘缓鏂颁换鍔″疄渚� - var task = new Dt_Task + if (item.Number.ToInt32() == number + 1) { - CurrentAddress = locationCode, - Grade = 1, - Roadway = station.Roadway, - TargetAddress = location.LocationCode, - Dispatchertime = DateTime.Now, - MaterialNo = "", - NextAddress = location.LocationCode, - OrderNo = null, - PalletCode = palletCode, - SourceAddress = locationCode, - TaskState = (int)TaskInStatusEnum.Line_InFinish, - TaskType = (int)TaskInboundTypeEnum.Inbound, - TaskNum = await BaseDal.GetTaskNo(), - Creater = "Systeam" - }; - - // 鍒涘缓WMS浠诲姟 - WMSTaskDTO taskDTO = new WMSTaskDTO() - { - TaskNum = task.TaskNum.Value, - Grade = 1, - PalletCode = task.PalletCode, - RoadWay = task.Roadway, - SourceAddress = task.SourceAddress, - TargetAddress = task.Roadway, - TaskState = task.TaskState.Value, - Id = 0, - TaskType = task.TaskType, - }; - - await _unitOfWorkManage.UseTranAsync(async () => - { - // 娣诲姞浠诲姟鍒版暟鎹簱 - await BaseDal.AddDataAsync(task); - // 鏇存柊搴撳瓨浣嶇疆鐘舵�佷负涓嶅彲鐢� - location.LocationStatus = (int)LocationEnum.InStockDisable; - await _locationRepository.UpdateDataAsync(location); - }); - - content.OK(data: taskDTO); + boxing.NextProcessCode = item.ProcessCode; + } } - else - content.Error(result.MOMMessage); + var location = await GetLocationDistributeAsync(station.Roadway); + + ConsoleHelper.WriteErrorLine(location.ToJsonString()); + + // 鍒涘缓鏂颁换鍔″疄渚� + var task = new Dt_Task + { + CurrentAddress = station.stationLocation, + Grade = 1, + Roadway = station.Roadway, + TargetAddress = location.LocationCode, + Dispatchertime = DateTime.Now, + MaterialNo = "", + NextAddress = location.LocationCode, + OrderNo = null, + PalletCode = palletCode, + SourceAddress = position, + TaskState = (int)TaskInStatusEnum.Line_InFinish, + TaskType = (int)TaskInboundTypeEnum.Inbound, + TaskNum = await BaseDal.GetTaskNo(), + Creater = "Systeam" + }; + + // 鍒涘缓WMS浠诲姟 + WMSTaskDTO taskDTO = CreateWMSTaskDTO(task); + + await _unitOfWorkManage.UseTranAsync(async () => + { + // 娣诲姞浠诲姟鍒版暟鎹簱 + await BaseDal.AddDataAsync(task); + // 鏇存柊搴撳瓨浣嶇疆鐘舵�佷负涓嶅彲鐢� + location.LocationStatus = (int)LocationEnum.Lock; + await _locationRepository.UpdateDataAsync(location); + await _boxingInfoRepository.AddDataNavAsync(boxing); + }); + + content.OK(data: taskDTO); } + else + content.Error(result.MOMMessage); } else { @@ -1402,9 +1669,50 @@ } catch (Exception ex) { + // 鏇磋缁嗙殑鏃ュ織璁板綍锛屽彲浣跨敤鏃ュ織妗嗘灦鏇挎崲 Console.WriteLine + Console.WriteLine($"Error in CreateAndSendInboundTask: {ex.Message}"); content.Error(ex.Message); } return content; + } + + + private WMSTaskDTO CreateWMSTaskDTO(object source) + { + if (source is Dt_Task taskOld) + { + return new WMSTaskDTO() + { + TaskNum = taskOld.TaskNum.Value, + Grade = 1, + PalletCode = taskOld.PalletCode, + RoadWay = taskOld.Roadway, + SourceAddress = taskOld.CurrentAddress, + TargetAddress = taskOld.TargetAddress, + TaskState = taskOld.TaskState.Value, + Id = 0, + TaskType = taskOld.TaskType, + }; + } + else if (source is 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, + }; + } + else + { + throw new ArgumentException("Invalid source object type for WMSTaskDTO creation."); + } } #endregion 闈欑疆寮傚父鍙e叆搴� @@ -1451,6 +1759,35 @@ public async Task<bool> Delete(List<int> ids) { return await BaseDal.Delete(ids); + } + + public override WebResponseContent DeleteData(object[] key) + { + WebResponseContent content = new WebResponseContent(); + // 鍒涘缓鍘嗗彶浠诲姟瀹炰緥妯″瀷 + try + { + Dt_Task task = BaseDal.QueryFirst(x => x.TaskId == Convert.ToInt32(key[0])); + if (task == null) + { + return content.Error("鏈壘鍒颁换鍔′俊鎭�!"); + } + var taskHtyNG = CreateHistoricalTask(task, true); + + // 鎵ц鏁版嵁搴撲簨鍔� + + // 娣诲姞鍘嗗彶浠诲姟 + var isTaskHtyAdd = _task_HtyRepository.AddData(taskHtyNG) > 0; + + // 鍒犻櫎浠诲姟鏁版嵁 + var isTaskDelete = BaseDal.Delete(task.TaskId); + + return content.OK("鍒犻櫎鎴愬姛!"); + } + catch (Exception ex) + { + return content.Error("鍒犻櫎浠诲姟寮傚父锛�" + ex.Message); + } } /// <summary> @@ -1562,7 +1899,7 @@ /// </summary> /// <param name="task"></param> /// <returns></returns> - private Dt_Task_Hty CreateHistoricalTask(Dt_Task task) + private Dt_Task_Hty CreateHistoricalTask(Dt_Task task, bool isHand = false) { // 鏇存柊浠诲姟鐘舵�� task.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); @@ -1572,7 +1909,7 @@ var taskHty = _mapper.Map<Dt_Task_Hty>(task); taskHty.FinishTime = DateTime.Now; taskHty.TaskId = 0; - taskHty.OperateType = (int)OperateTypeEnum.鑷姩瀹屾垚; + taskHty.OperateType = isHand ? (int)OperateTypeEnum.浜哄伐鍒犻櫎 : (int)OperateTypeEnum.鑷姩瀹屾垚; taskHty.SourceId = task.TaskId; taskHty.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); return taskHty; @@ -1690,6 +2027,13 @@ var content = new WebResponseContent(); // 鑾峰彇鐩爣鍦板潃鍜屾洿鏂颁换鍔$姸鎬� + + input.Position = Regex.Replace(input.Position, @"-(\d+)", ""); + if (Convert.ToInt32(input.Position) > 1999) + { + input.Position = (Convert.ToInt32(input.Position) - 1000).ToString(); + } + if (task.TaskType == (int)TaskInboundTypeEnum.InNG) { // TODO 鏍规嵁宸烽亾鏌ユ壘瀵瑰簲NG鍙o紝鐜板湪榛樿鍘婚潤缃爢鍨涙満鐨勫紓甯稿彛璐т綅鍙� @@ -1702,7 +2046,7 @@ } else if (task.TaskType == (int)TaskInboundTypeEnum.InQuality) { - var stockInfo = _stockInfoRepository.QueryFirst(x => x.PalletCode == input.PalletCode); + var stockInfo = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == input.PalletCode); task.CurrentAddress = input.Position; task.TargetAddress = stockInfo.LocationInfo.LocationCode; task.NextAddress = stockInfo.LocationInfo.LocationCode; @@ -1854,6 +2198,8 @@ return content; } + + private static readonly SemaphoreSlim _semaphore = new SemaphoreSlim(1, 1); /// <summary> /// 鏌ユ壘璐т綅 /// </summary> @@ -1864,16 +2210,17 @@ { #region 鑾峰彇璐т綅 + await _semaphore.WaitAsync(); try { List<DtLocationInfo> locations; if (IsFull) { - locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay); + locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay && x.EnalbeStatus == (int)EnableEnum.Enable); } else { - locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay /*&& x.LocationType ==*/); + locations = await _locationRepository.QueryDataAsync(x => x.LocationStatus == (int)LocationEnum.Free && x.RoadwayNo == roadWay && x.EnalbeStatus == (int)EnableEnum.Enable); } if (locations == null) @@ -1887,6 +2234,10 @@ { Console.WriteLine(err.Message.ToString()); return null; + } + finally + { + _semaphore.Release(); } #endregion 鑾峰彇璐т綅 @@ -1938,6 +2289,89 @@ return minRoadwayNo; } + // 鏂扮殑鍑哄簱閿欒澶勭悊閫昏緫 + private async Task HandleOutBoundError(DtStockInfo stock, Dt_Task task) + { + WebResponseContent content = new WebResponseContent(); + var area = _areaInfoRepository.QueryFirst(x => x.AreaCode == stock.AreaCode); + if (area == null) + { + throw new Exception("鏈壘鍒板搴旂殑搴撳尯淇℃伅"); + } + + var trayCells = new TrayCellsStatusDto + { + Software = area.Spare3, + TrayBarcode = task.PalletCode, + EquipmentCode = area.Spare2, + SceneType = area.Spare4 + }; + + content = await _cellStateService.GetTrayCellStatusAsync(trayCells); + if (!content.Status) return; + + var ResultTray = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + if (ResultTray.SerialNos.Count > 0) + { + var parameterInfo = GetParameterInfo(stock); + + var outHours = CalculateOutHours(stock); + var isNG = outHours > parameterInfo.LowerSpecificationsLimit.ToDouble() + && outHours < parameterInfo.UpperSpecificationsLimit.ToDouble(); + + var defectCode = !isNG ? "TQCK" : string.Empty; + + var outputDto = CreateAgingOutputDto(area, stock, ResultTray, parameterInfo, outHours, defectCode); + content = await _agingInOrOutInputService.GetOCVOutputAsync(outputDto); + + var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); + if (!result.Success) + task.Remark = "NG"; + } + } + + // 璁$畻鍑哄簱灏忔椂鐨勬柟娉� + private double CalculateOutHours(DtStockInfo stock) => + (DateTime.Now - Convert.ToDateTime(stock.LinedProcessFeedbackTime ?? stock.CreateDate.ToString())).TotalHours; + + // 鐢熸垚 AgingOutputDto 鐨勫皝瑁呮柟娉� + private AgingOutputDto CreateAgingOutputDto(Dt_AreaInfo area, DtStockInfo stock, ResultTrayCellsStatus resultTray, + ParameterInfo parameterInfo, double outHours, string defectCode) + { + return new AgingOutputDto + { + OpFlag = 1, + Software = area.Spare3, + EquipmentCode = area.Spare2, + TrayBarcode = stock.PalletCode, + SerialNos = resultTray.SerialNos.Select(x => new SerialNoOutDto + { + SlotNo = x.PositionNo, + SerialNo = x.SerialNo, + SerialNoResult = true, + ParameterInfo = new List<ParameterInfoOutput> + { + new ParameterInfoOutput + { + Value = outHours.ToString(), + ParameterCode = parameterInfo.ParameterCode, + ParameterDesc = parameterInfo.Description, + ParameterResult = "OK", + TargetValue = parameterInfo.TargetValue, + LowerLomit = parameterInfo.LowerSpecificationsLimit, + UpperLimit = parameterInfo.UpperSpecificationsLimit, + DefectCode = defectCode, + } + } + }).ToList() + }; + } + + // 鑾峰彇鍙傛暟淇℃伅鐨勮緟鍔╂柟娉� + private ParameterInfo GetParameterInfo(DtStockInfo stock) => + JsonConvert.DeserializeObject<List<ParameterInfo>>(stock.ParameterInfos) + .FirstOrDefault(y => y.Description.Contains("鏃堕棿")); + #endregion 浠诲姟璇锋眰鏂规硶 #endregion private 鍐呴儴鏂规硶 -- Gitblit v1.9.3