From a6ea79849f0142b5280f0c5d4b15ecc83f0d015a Mon Sep 17 00:00:00 2001 From: 刘磊 <1161824510@qq.com> Date: 星期六, 21 十二月 2024 09:52:27 +0800 Subject: [PATCH] Merge branch 'master' of http://115.159.85.185:8098/r/HuaYiZhongHeng/BaiBuLiKu --- Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs | 230 ++++++++++++++++++++++++++++++++++----------------------- 1 files changed, 137 insertions(+), 93 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 f726190..bf8748c 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,20 +1,13 @@ -锘� -using AngleSharp.Io; -using log4net.Core; +锘縰sing AngleSharp.Io; using Mapster; using Masuit.Tools; -using OfficeOpenXml.FormulaParsing.Excel.Functions.Math; -using SixLabors.Fonts.Tables.AdvancedTypographic; +using System.Text.RegularExpressions; using WIDESEA_Core.Const; using WIDESEA_DTO.MOM; using WIDESEA_DTO.WMS; using WIDESEA_IServices; using WIDESEA_IStoragIntegrationServices; -using WIDESEA_Model.Models; -using WIDESEA_Services; -using WIDESEA_StorageBasicRepository; using WIDESEAWCS_BasicInfoRepository; -using WIDESEAWCS_Model.Models; namespace WIDESEA_StorageTaskServices; @@ -76,7 +69,6 @@ #region 鍑哄簱浠诲姟瀹屾垚 - public async Task<WebResponseContent> CompleteStackTaskAsync(Dt_Task task, DtStockInfo stock) { WebResponseContent content = new WebResponseContent(); @@ -87,7 +79,7 @@ //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")) //闈炲垎瀹瑰簱鍖哄潎涓婃姤MOM鍑哄叆绔� + if (!task.Roadway.Contains("FR") && stock.ProcessCode != "OCVB") //闈炲垎瀹瑰簱鍖轰笌褰撳墠宸ュ簭鏄疧CVB鍧囦笂鎶OM鍑哄叆绔� { var agingOutputDto = MapToAgingOutputDto(stock); content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); @@ -164,13 +156,13 @@ { SlotNo = x.OrderNo.ToInt32(), SerialNo = x.SerialNumber, - SerialNoResult = isNG, + SerialNoResult = true, //isNG, ParameterInfo = new List<ParameterInfoOutput> { new ParameterInfoOutput() { Value = outHours.ToString(), ParameterCode =parameterInfo.ParameterCode, ParameterDesc = parameterInfo.Description, - ParameterResult = isNG.ToString(), + ParameterResult = "OK", //isNG.ToString(), TargetValue = parameterInfo.TargetValue, LowerLomit = parameterInfo.LowerSpecificationsLimit, UpperLimit = parameterInfo.UpperSpecificationsLimit, @@ -184,7 +176,6 @@ private void ValidateResponse(WebResponseContent content) { - } private (DtLocationInfo, Dt_Task) UpdateStockAndTaskStatus(DtStockInfo stock, Dt_Task task) @@ -304,7 +295,6 @@ // 鎵ц鏁版嵁搴撲簨鍔� await _unitOfWorkManage.UseTranAsync(async () => { - // 娣诲姞鍘嗗彶浠诲姟 var isTaskHtyAdd = await _task_HtyRepository.AddDataAsync(taskHtyNG) > 0; @@ -326,9 +316,15 @@ // 鍒涘缓鍘嗗彶浠诲姟瀹炰緥妯″瀷 var taskHty = CreateHistoricalTask(task); + if (task.TaskType == (int)TaskInboundTypeEnum.InQuality) + { + await _locationRepository.UpdateDataAsync(locationInf); + await _task_HtyRepository.AddDataAsync(taskHty); + await BaseDal.DeleteDataAsync(task); + return content.OK("鍏ュ簱浠诲姟瀹屾垚鎴愬姛"); + } // 鏍规嵁鏄惁鏈夌粍鐩樹俊鎭垱寤哄簱瀛樺疄渚嬫ā鍨� DtStockInfo stock = boxing == null ? CreateEmptyPalletStock(task, locationInf) : CreateFullPalletStock(task, locationInf, boxing); - // 鎵ц鏁版嵁搴撲簨鍔� bool isResult = await ExecuteTransaction(stock, taskHty, locationInf, task.TaskId, boxing); @@ -423,15 +419,23 @@ } else { - var station = _stationManagerRepository.QueryFirst(x => x.stationChildCode == task.SourceAddress); - if (station.stationPLC == "1017") - area = _areaInfoRepository.QueryFirst(x => x.AreaID == Convert.ToInt32(station.stationNGLocation)); - else - area = _areaInfoRepository.QueryFirst(x => x.AreaID == loation.AreaId); + //var station = _stationManagerRepository.QueryFirst(x => x.stationChildCode == task.SourceAddress); + //if (station.stationPLC == "1017") + // area = _areaInfoRepository.QueryFirst(x => x.AreaID == Convert.ToInt32(station.stationNGLocation)); + //else + // area = _areaInfoRepository.QueryFirst(x => x.AreaID == loation.AreaId); + //if (area == null) + // throw new Exception("鏈壘鍒板搴斿尯鍩熶俊鎭�"); + + if (boxing.ProcessCode == "OCV1") + area = _areaInfoRepository.QueryFirst(x => x.AreaID == 6); + + else if (boxing.ProcessCode == "OCVB") + area = _areaInfoRepository.QueryFirst(x => x.AreaID == 7); + if (area == null) throw new Exception("鏈壘鍒板搴斿尯鍩熶俊鎭�"); } - var boxDetail = boxing.BoxingInfoDetails.Adapt<List<DtStockInfoDetail>>(); boxDetail.ForEach(x => { x.Status = (int)StockStateEmun.宸插叆搴�; }); @@ -445,33 +449,51 @@ AreaCode = area.AreaCode, LocationId = loation.Id, StockInfoDetails = boxDetail, + ProcessCode = boxing.ProcessCode, + NextProcessCode = boxing.NextProcessCode, + Remark = boxing.BoxingInfoDetails.Count().ToString(), }; - // 澶勭悊璇锋眰鍙傛暟 - AgingInputDto agingInputDto = new AgingInputDto() + if (boxing.ProcessCode != "OCVB") { - SerialNos = boxing.BoxingInfoDetails - .Select(item => new SerialNoInDto { SerialNo = item.SerialNumber, PositionNo = item.OrderNo }) - .ToList(), - TrayBarcode = task.PalletCode, - OpFlag = 1, - EquipmentCode = area.Spare2, - Software = area.Spare3 - }; + // 澶勭悊璇锋眰鍙傛暟 + AgingInputDto agingInputDto = new AgingInputDto() + { + SerialNos = boxing.BoxingInfoDetails + .Select(item => new SerialNoInDto { SerialNo = item.SerialNumber, PositionNo = item.OrderNo }) + .ToList(), + TrayBarcode = task.PalletCode, + OpFlag = 1, + EquipmentCode = area.Spare2, + Software = area.Spare3 + }; - var result = _agingInOrOutInputService.GetOCVInputAsync(agingInputDto).Result; - var respone = JsonConvert.DeserializeObject<ResponeAgingInputDto>(result.Data.ToString()); - if (respone.ProductionLine == null || respone.ParameterInfos == null || respone.SpecialParameterDuration.IsNullOrEmpty()) - { - throw new Exception("MOM鏁版嵁杩斿洖閿欒"); + var result = _agingInOrOutInputService.GetOCVInputAsync(agingInputDto).Result; + var respone = JsonConvert.DeserializeObject<ResponeAgingInputDto>(result.Data.ToString()); + + bool isFull = false; + if (!task.Roadway.Contains("FR")) + { + isFull = respone.SpecialParameterDuration.IsNullOrEmpty(); + } + if (respone.ProductionLine == null || respone.ParameterInfos == null) + { + throw new Exception("MOM鏁版嵁杩斿洖閿欒"); + } + stock.LinedProcessFeedbackTime = respone.LinedProcessFeedbackTime; + stock.SpecialParameterDuration = respone.SpecialParameterDuration; + //2024骞�11鏈�16鏃ワ細鏂板瀛楁璁$畻搴斿嚭搴撴椂闂� + stock.OutboundTime = Convert.ToDateTime(respone.LinedProcessFeedbackTime == null ? DateTime.Now : respone.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(respone.SpecialParameterDuration)); + stock.ProductionLine = respone.ProductionLine; + stock.ParameterInfos = respone.ParameterInfos.ToJsonString(); + stock.StockStatus = 1; } - stock.LinedProcessFeedbackTime = respone.LinedProcessFeedbackTime; - stock.SpecialParameterDuration = respone.SpecialParameterDuration; - //2024骞�11鏈�16鏃ワ細鏂板瀛楁璁$畻搴斿嚭搴撴椂闂� - stock.OutboundTime = Convert.ToDateTime(respone.LinedProcessFeedbackTime == null ? DateTime.Now : respone.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(respone.SpecialParameterDuration)); - stock.ProductionLine = respone.ProductionLine; - stock.ParameterInfos = respone.ParameterInfos.ToJsonString(); - stock.StockStatus = 1; + else + { + stock.OutboundTime = DateTime.Now; + stock.StockStatus = 1; + stock.ProductionLine = boxing.ProductionLine; + } // 璁板綍鏃ュ織 LogFactory.GetLog("浠诲姟瀹屾垚").InfoFormat(true, "鍏ュ簱浠诲姟瀹屾垚", $"璐т綅鍦板潃锛歿task.TargetAddress},淇敼鍚庤揣浣嶆暟鎹細{locationInf}"); @@ -528,6 +550,7 @@ case (int)TaskRelocationTypeEnum.Relocation: return await CompleteTransferTaskAsync(task, stock); + default: return content.Error("浠诲姟绫诲瀷涓嶅瓨鍦�"); } @@ -538,6 +561,7 @@ #region 璇锋眰浠诲姟鍏ュ簱 #region + /// <summary> /// 璇锋眰浠诲姟宸烽亾 /// </summary> @@ -572,7 +596,6 @@ return content.OK(data: taskDTO); } } - var stock = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == input.PalletCode && x.IsFull); if (stock != null) @@ -725,18 +748,23 @@ case "CH01": areaIn = "CH001"; break; + case "JZ01": areaIn = "JZ001"; break; + case "GW01": areaIn = "GWSC1"; break; + case "CW01": areaIn = "CWSC1"; break; + case "CW02": areaIn = "CWSC2"; break; + default: break; } @@ -768,7 +796,7 @@ return content; } - #endregion + #endregion 璇锋眰浠诲姟鍏ュ簱 public async Task<WebResponseContent> RequestTaskAsync(RequestTaskDto input) { @@ -799,7 +827,7 @@ PalletCode = stock.PalletCode, SourceAddress = input.Position, CurrentAddress = input.Position, - TaskState = (int)TaskInStatusEnum.InNew, + TaskState = stock.LocationInfo.RoadwayNo.Contains("CH") ? (int)TaskInStatusEnum.InNew : (int)TaskInStatusEnum.Line_InFinish, TaskType = (int)TaskInboundTypeEnum.InQuality, TaskNum = BaseDal.GetTaskNo().Result, Creater = "System", // 淇鎷煎啓閿欒 @@ -807,12 +835,15 @@ TaskId = 0, }; - var taskDTO = CreateTaskDTO(task); + var taskDTO = CreateTaskDTO(taskNew); + BaseDal.AddData(taskNew); + return content.OK(data: taskDTO); // TODO璐ㄦ鍥炲簱 } // 鏍规嵁浣嶇疆鏌ヨ鍖哄煙淇℃伅 - var area = await QueryAreaInfoByPosition(input.Position.Replace("-1", "")); + var areaCode = Regex.Replace(input.Position, @"-(\d+)", ""); + var area = await QueryAreaInfoByPosition(areaCode); if (area == null) { return content.Error("璇ョ偣浣嶄笉鍦ㄥ尯鍩熷垪琛ㄤ腑瀛樺湪"); @@ -829,7 +860,15 @@ if (result.SerialNos.Count <= 0) { // 绌烘墭鐩樺叆搴撻�昏緫 - return await RequestTrayInTaskAsync(input); + var staion = _stationManagerRepository.QueryFirst(x => x.stationChildCode == input.Position && x.stationType == 1 && x.remark == "IN"); + if (staion != null) + { + return await HandleErrorCells(input, area); + } + else + { + return await RequestTrayInTaskAsync(input); + } } else return content.Error(result.MOMMessage); @@ -841,7 +880,6 @@ { return await HandleErrorCells(input, area, serialNosError); } - var boxing = CreateBoxingInfo(result, input.PalletCode); if (boxing == null) return content.Error("缁勭洏澶辫触"); @@ -857,6 +895,7 @@ return content; } + /// <summary> /// 鏇存柊浠诲姟璐т綅 /// </summary> @@ -872,11 +911,9 @@ return content.Error($"鏆傛湭鎵惧埌銆恵input.PalletCode}銆戠殑浠诲姟"); return content = await UpdateExistingTask(input, task); - } catch (Exception err) { - throw; } } @@ -891,7 +928,6 @@ WebResponseContent content = new WebResponseContent(); try { - // 璋冪敤BaseDal.QueryFirstAsync鏂规硶锛屾煡璇换鍔� var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == input.PalletCode); if (task != null && task.TaskState == (int)TaskInStatusEnum.InNew) @@ -912,7 +948,6 @@ return content.OK(data: task); } - var stationManagers = _stationManagerRepository.QueryData(x => x.stationType == 6 && x.stationChildCode == input.Position).FirstOrDefault(); if (stationManagers == null) { @@ -927,7 +962,6 @@ } catch (Exception) { - throw; } } @@ -947,6 +981,7 @@ PalletCode = palletCode, IsFull = true, ProcessCode = result.ProcessCode, + ProductionLine = result.ProductionLine, BoxingInfoDetails = result.SerialNos.Select(serialNoObj => new DtBoxingInfoDetail { SerialNumber = serialNoObj.SerialNo, @@ -972,7 +1007,7 @@ }; } - #endregion 璇锋眰浠诲姟鍏ュ簱 + #endregion 澶栭儴鎺ュ彛鏂规硶 #region 璇锋眰鍑哄簱锛堝疄鐩�&绌虹洏锛� @@ -984,15 +1019,15 @@ /// <param name="areaCode">鍖哄煙缂栫爜</param> /// <param name="roadways">宸烽亾缂栫爜闆嗗悎</param> /// <returns>杩斿洖缁撴灉闆�</returns> - public async Task<WebResponseContent> RequestTrayOutTaskAsync(string position, int tag, string areaCode, string productionLine) + public async Task<WebResponseContent> RequestTrayOutTaskAsync(string position, int tag, string areaCode, List<string> areaCodes, string productionLine) { WebResponseContent content = new WebResponseContent(); try { // 鏍规嵁鎵樼洏绫诲瀷鏌ヨ搴撳瓨淇℃伅 DtStockInfo stockInfo = tag == (int)TaskOutboundTypeEnum.Outbound - ? QueryStockInfoForRealTrayAsync(areaCode, productionLine).Result - : QueryStockInfoForEmptyTrayAsync(areaCode).Result; + ? areaCodes == null ? await QueryStockInfoForRealTrayAsync(areaCode, productionLine) : await QueryStockInfoForRealTrayCWAsync(areaCodes, productionLine) + : await QueryStockInfoForEmptyTrayAsync(areaCode); if (stockInfo == null) { @@ -1047,6 +1082,28 @@ .Includes(x => x.LocationInfo) // 棰勫姞杞絃ocationInfo .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) // 杩囨护鏉′欢 + .OrderBy(x => x.OutboundTime) // 鎺掑簭 + .FirstAsync(); // 鑾峰彇绗竴涓厓绱� + + //var firstOrDefault = result.FirstOrDefault(x => roadways.Contains(x.LocationInfo.RoadwayNo)); // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌 + //var firstOrDefault = result[0]; // 鏌ユ壘绗竴涓尮閰嶇殑鍏冪礌 + //return firstOrDefault; + return result; + } + + /// <summary> + /// 鏌ヨ瀹炵洏搴撳瓨淇℃伅 + /// </summary> + private async Task<DtStockInfo> QueryStockInfoForRealTrayCWAsync(List<string> areaCodes, string productionLine) + { + var area = await _areaInfoRepository.QueryFirstAsync(x => x.AreaCode == "CWSC1"); + + var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>() + .Includes(x => x.LocationInfo) // 棰勫姞杞絃ocationInfo + .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) // 杩囨护鏉′欢 .OrderBy(x => x.OutboundTime) // 鎺掑簭 @@ -1124,7 +1181,7 @@ }; } - #endregion 璇锋眰鍑哄簱 + #endregion 璇锋眰鍑哄簱锛堝疄鐩�&绌虹洏锛� #region 浠诲姟鐘舵�佹洿鏀� @@ -1174,34 +1231,7 @@ return content; } - #endregion - - #region 鍑哄簱瑙g洏 - - /// <summary> - /// 鍑哄簱瑙g洏鎺ュ彛 - /// </summary> - /// <param name="taskNum"></param> - /// <returns></returns> - public async Task<WebResponseContent> OutUnblockInterface(int taskNum) - { - WebResponseContent content = new WebResponseContent(); - try - { - var task = await BaseDal.QueryFirstAsync(x => x.TaskNum == taskNum); - if (task == null) - return content.Error("鏈壘鍒颁换鍔�"); - task.TaskState = (int)TaskOutStatusEnum.Line_OutFinish; - var taskHty = CreateHistoricalTask(task); - } - catch (Exception ex) - { - content.Error(ex.Message); - } - return content; - } - - #endregion + #endregion 浠诲姟鐘舵�佹洿鏀� #region 鎸囧畾浠诲姟鍑哄簱 @@ -1228,8 +1258,19 @@ taskType = (int)TaskOutboundTypeEnum.OutQuality; else taskType = (int)TaskOutboundTypeEnum.OutTray; - // 鍒涘缓骞舵坊鍔犱换鍔″埌鏁版嵁搴� - task = CreateTask(stockInfo, "1020-1", taskType); + + if (stockInfo.AreaCode.Contains("CH")) + { + // 鍒涘缓骞舵坊鍔犱换鍔″埌鏁版嵁搴� + task = CreateTask(stockInfo, "1020-1", taskType); + } + else + { + if (stockInfo.LocationInfo.RoadwayNo == "JZSC1") + { + task = CreateTask(stockInfo, "002-021-001", taskType); + } + } //var taskId = await BaseDal.AddDataAsync(task); //if (taskId <= 0) //{ @@ -1267,6 +1308,7 @@ return content; } + private string GetWCSIpReceiveTask() { var configs = _configService.GetConfigsByCategory(CateGoryConst.CONFIG_SYS_IPAddress); @@ -1278,6 +1320,10 @@ } return wmsBase + ipAddress; } + + #endregion 鎸囧畾浠诲姟鍑哄簱 + + #region 闈欑疆寮傚父鍙e叆搴� #endregion @@ -1500,7 +1546,6 @@ .Include(x => x.BoxingInfoDetails) .ExecuteCommandAsync(); } - } var stocks = _stockInfoRepository.QueryData(x => x.AreaCode == stock.AreaCode && x.ProductionLine == stock.ProductionLine && x.SpecialParameterDuration != stock.SpecialParameterDuration); @@ -1612,7 +1657,6 @@ _unitOfWorkManage.CommitTran(); return content.OK(data: task); } - } catch (Exception ex) { -- Gitblit v1.9.3