From 992a33ca68af405d08da512c46d7d59ec3ceaabc Mon Sep 17 00:00:00 2001 From: 肖洋 <cathay_xy@163.com> Date: 星期二, 11 二月 2025 14:33:47 +0800 Subject: [PATCH] 添加 ProductionLine 属性并优化任务处理逻辑 --- Code Management/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Dt_TaskService.cs | 417 ++++++++++++++++++++++++++++++++++++++++++----------------- 1 files changed, 295 insertions(+), 122 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 e9ae1ae..a001e83 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,17 +1,15 @@ -锘縰sing AngleSharp.Dom; +锘縰sing Autofac.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_StoragIntegrationServices; using WIDESEAWCS_BasicInfoRepository; +using WIDESEAWCS_QuartzJob.Models; + namespace WIDESEA_StorageTaskServices; @@ -167,15 +165,29 @@ var agingOutputDto = MapToAgingOutputDto(stock); content = await _agingInOrOutInputService.GetOCVOutputAsync(agingOutputDto); - var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); - task.Remark = result.Success ? null : "NG"; - - if (!result.Success && result.MessageCode == "E10001") + if (content.Status) { - await HandleOutBoundError(stock, task); + var result = JsonConvert.DeserializeObject<BasicResult>(content.Data.ToString()); + + if (!result.Success && result.MessageCode == "E10001") + { + await HandleOutBoundError(stock, task); + } + } + else + { + task.Remark = "NG"; + ConsoleHelper.WriteErrorLine("MOM閫氭姤鐐硅姱NG"); + return content.Error("MOM閫氭姤鐐硅姱NG"); } } } + } + + if (task.Remark == "NG") + { + ConsoleHelper.WriteErrorLine("MOM閫氭姤鐐硅姱NG"); + return content.Error("MOM閫氭姤鐐硅姱NG"); } // 鏇存柊搴撳瓨鐘舵�佸拰浠诲姟鐘舵�� @@ -194,8 +206,8 @@ await DeleteStockInfoAsync(stock.Id); await DeleteStockInfoDetailsAsync(stock.StockInfoDetails); await AddStockInfoHtyAsync(stockInfo_Hty); + await UpdateLocationAsync(loc); //璐ㄦ浠诲姟闇�瑕佹寔缁攣瀹氬簱浣� } - await UpdateLocationAsync(loc); await DeleteTaskAsync(task.TaskId); await AddTaskHtyAsync(taskHty); }); @@ -254,7 +266,7 @@ ParameterDesc = parameterInfo.Description, ParameterResult = "OK", //isNG.ToString(), TargetValue = parameterInfo.TargetValue, - LowerLomit = parameterInfo.LowerSpecificationsLimit, + LowerLimit = parameterInfo.LowerSpecificationsLimit, UpperLimit = parameterInfo.UpperSpecificationsLimit, DefectCode = defectCode, UOMCode = parameterInfo.UOMCode, @@ -268,11 +280,13 @@ { 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); @@ -289,7 +303,7 @@ private async Task AddStockInfoHtyAsync(DtStockInfo_Hty dtStock) { - var isStockAdd = await SqlSugarHelper.Db.InsertNav(dtStock).IncludesAllFirstLayer().ExecuteCommandAsync(); + var isStockAdd = await SqlSugarHelper.DbWMS.InsertNav(dtStock).IncludesAllFirstLayer().ExecuteCommandAsync(); if (!isStockAdd) { throw new Exception("搴撳瓨鍘嗗彶淇℃伅娣诲姞澶辫触"); @@ -405,6 +419,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; @@ -416,6 +431,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("鍏ュ簱浠诲姟瀹屾垚鎴愬姛"); } // 鏍规嵁鏄惁鏈夌粍鐩樹俊鎭垱寤哄簱瀛樺疄渚嬫ā鍨� @@ -425,6 +444,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 @@ -458,6 +478,7 @@ IsFull = false, AreaCode = area.AreaCode ?? "", LocationId = loation.Id, + ProductionLine = task.ProductionLine, StockInfoDetails = new List<DtStockInfoDetail>() { new DtStockInfoDetail() @@ -550,7 +571,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() @@ -725,7 +746,7 @@ return content.Error(result.MOMMessage); // 鑾峰彇寮傚父鐢佃姱 - List<SerialNoDto>? serialNosError = result.SerialNos.Where(x => x.SerialNoStatus != 1).ToList(); + List<SerialNoDto>? serialNosError = result.SerialNos.Where(x => x.SerialNoStatus != 1 && x.SerialNoStatus != 4).ToList(); if (serialNosError.Count > 0) { // TODO 鍒涘缓浠诲姟閫佽嚦NG鎺掑嚭鍙� @@ -740,7 +761,7 @@ { NGStation = efg.Select(x => x.stationNGChildCode).ToList(); } - content = await CreateNewTask(input, NGStation, 2); + content = await CreateNewTask(input, result.ProductionLine, NGStation, 2); return content.Error("瀛樺湪寮傚父鐢佃姱"); } @@ -777,7 +798,7 @@ { // TODO 閫佽嚦鍖呰 List<string> strings = stationManagers.Where(x => x.stationType == 0).Select(x => x.Roadway).ToList(); - content = await CreateNewTask(input, strings, 3); + content = await CreateNewTask(input, result.ProductionLine, strings, 3); return content; } else @@ -785,7 +806,7 @@ var config = _configService.GetByConfigKey("SYS_InStacker", "CW3InStacker"); var strings = config.ConfigValue.Split(',').ToList(); // TODO 鍏ュ簱 - content = await CreateNewTask(input, strings); + content = await CreateNewTask(input, result.ProductionLine, strings); if (content.Status) await _boxingInfoRepository.AddDataNavAsync(boxing); } @@ -874,7 +895,7 @@ List<string> strings = stationManagers.Roadway.Split(',').ToList(); Console.WriteLine(strings.ToJsonString() + "b-----------------------"); //// 璋冪敤CreateNewTask鏂规硶锛屽垱寤烘柊浠诲姟 - content = await CreateNewTask(input, strings); + content = await CreateNewTask(input, result.ProductionLine, strings); if (content.Status) { var isBox = await _boxingInfoRepository.AddDataNavAsync(boxing); @@ -930,6 +951,7 @@ Creater = "System", // 淇鎷煎啓閿欒 CreateDate = DateTime.Now, TaskId = 0, + ProductionLine = stock.ProductionLine, }; var taskDTO = CreateTaskDTO(taskNew); @@ -949,12 +971,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) { // 绌烘墭鐩樺叆搴撻�昏緫 @@ -972,17 +999,34 @@ return content.Error(result.MOMMessage); } - // 澶勭悊寮傚父鐢佃姱鎯呭喌 - var serialNosError = result.SerialNos.Where(x => x.SerialNoStatus != 1 && x.SerialNoStatus != 4).ToList(); - if (serialNosError.Count > 0) + + if (result.SerialNos.Count <= 0) { - return await HandleErrorCells(input, area, serialNosError); + var config = _configService.GetByConfigKey(CateGoryConst.CONFIG_SYS_InStacker, SysConfigConst.InboundIsEmpty); + var strings = config.ConfigValue.Split(',').ToList(); + if (strings.Contains(input.Position)) + { + // todo閫佽嚦NG鍙� + ConsoleHelper.WriteErrorLine($"褰撳墠浣嶇疆涓嶈兘鍏ョ┖鎵樼洏"); + return content.Error("褰撳墠浣嶇疆涓嶈兘鍏ョ┖鎵樼洏"); + } + else + return await RequestTrayInTaskAsync(input); } + else + { + // 澶勭悊寮傚父鐢佃姱鎯呭喌 + var serialNosError = result.SerialNos.Where(x => x.SerialNoStatus != 1 && x.SerialNoStatus != 4).ToList(); + if (serialNosError.Count > 0) + { + return await HandleErrorCells(input, area, serialNosError); + } - var boxing = CreateBoxingInfo(result, input.PalletCode); - if (boxing == null) return content.Error("缁勭洏澶辫触"); + var boxing = CreateBoxingInfo(result, input.PalletCode); + if (boxing == null) return content.Error("缁勭洏澶辫触"); - return await ProcessBasedOnProcessCode(boxing, area, input, result); + return await ProcessBasedOnProcessCode(boxing, area, input, result); + } } catch (Exception err) { @@ -1031,20 +1075,46 @@ if (task != null && task.TaskState == (int)TaskInStatusEnum.InNew) { // 鍒涘缓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, - }; + WMSTaskDTO taskDTO = CreateTaskDTO(task); + //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, + //}; return content.OK(data: task); } + + // 鏍规嵁浣嶇疆鏌ヨ鍖哄煙淇℃伅 + var areaCode = Regex.Replace(input.Position, @"-(\d+)", ""); + var area = await QueryAreaInfoByPosition(areaCode); + if (area == null) + { + return content.Error("璇ョ偣浣嶄笉鍦ㄥ尯鍩熷垪琛ㄤ腑瀛樺湪"); + } + + // 鑾峰彇鏁寸洏鐢佃姱灞炴�х姸鎬� + TrayCellsStatusDto trayCells = CreateTrayCellsStatusDto(area, input.PalletCode); + content = await GetTrayCellStatusAsync(trayCells); + if (!content.Status) + { + ConsoleHelper.WriteErrorLine($"鑾峰彇鐢佃姱鐘舵�佸け璐�:{content.Message}"); + return content; + } + + var result = JsonConvert.DeserializeObject<ResultTrayCellsStatus>(content.Data.ToString()); + if (result.ProductionLine.IsNullOrEmpty()) + { + ConsoleHelper.WriteErrorLine($"褰撳墠鎵樼洏鏃犱骇绾�,鑱旂郴MOM娣诲姞浜х嚎"); + return content.Error("褰撳墠鎵樼洏鏃犱骇绾�,鑱旂郴MOM娣诲姞浜х嚎"); + } + var stationManagers = _stationManagerRepository.QueryData(x => x.stationType == 6 && x.stationChildCode == input.Position).FirstOrDefault(); if (stationManagers == null) @@ -1054,9 +1124,8 @@ throw new Exception("鏈壘鍒扮┖鎵樼洏鍏ュ簱绔欏彴鍜屽叆搴撶珯鍙伴厤缃�"); } List<string> strings = stationManagers.Roadway.Split(',').ToList(); - Console.WriteLine(strings.ToJsonString() + "b-----------------------"); - return await CreateNewTask(input, strings, 1); + return await CreateNewTask(input, result.ProductionLine, strings, 1); } catch (Exception) { @@ -1125,12 +1194,15 @@ // 鏍规嵁鎵樼洏绫诲瀷鏌ヨ搴撳瓨淇℃伅 DtStockInfo stockInfo = tag == (int)TaskOutboundTypeEnum.Outbound ? areaCode != "CWSC1" ? await QueryStockInfoForRealTrayAsync(areaCode, areaCodes, productionLine) : await QueryStockInfoForRealTrayCWAsync(areaCodes, productionLine) - : await QueryStockInfoForEmptyTrayAsync(areaCode); + : await QueryStockInfoForEmptyTrayAsync(areaCode, position); if (stockInfo == null) { return content.Error("搴撳瓨淇℃伅涓嶅瓨鍦�"); } + + //ConsoleHelper.WriteColorLine(JsonConvert.SerializeObject(stockInfo), ConsoleColor.DarkMagenta); + // 鏂板閲嶅浠诲姟鏍¢獙 var hasTask = BaseDal.QueryFirst(x => x.PalletCode == stockInfo.PalletCode); @@ -1165,6 +1237,7 @@ { // 璁板綍寮傚父淇℃伅骞舵姏鍑� LogFactory.GetLog("璇锋眰鎵樼洏浠诲姟").Error(true, ex); + ConsoleHelper.WriteErrorLine("璇锋眰绌�/瀹炴墭鐩樹换鍔�" + ex.Message); return content.Error(ex.Message); } } @@ -1197,14 +1270,26 @@ /// </summary> private async Task<DtStockInfo> QueryStockInfoForRealTrayCWAsync(List<string> areaCodes, string productionLine) { - var area = await _areaInfoRepository.QueryFirstAsync(x => x.AreaCode == "CWSC1"); + var areaId = (await _areaInfoRepository.QueryDataAsync(x => areaCodes.Contains(x.AreaCode))).Select(x => x.AreaID).ToList(); + if (areaId.Count == 0) + { + ConsoleHelper.WriteErrorLine($"鏌ヨ甯告俯瀹炵洏搴撳瓨淇℃伅鏃�,鏈壘鍒板尯鍩熶唬鐮佷负{JsonConvert.SerializeObject(areaCodes)}鐨勬暟鎹�"); + return null; + } + + var devices = SqlSugarHelper.DbWCS.Queryable<Dt_DeviceInfo>() + .Where(x => x.DeviceStatus == "1") + .Where(x => x.DeviceRemark == "1") + .ToList(); + var deviceCode = devices.Select(x => x.DeviceCode).ToList(); 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 && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢 + .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && areaId.Contains(x.LocationInfo.AreaId) && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢 + .WhereIF(!deviceCode.IsNullOrEmpty(), x => deviceCode.Contains(x.LocationInfo.RoadwayNo)) .OrderBy(x => x.OutboundTime) // 鎺掑簭 .FirstAsync(); // 鑾峰彇绗竴涓厓绱� @@ -1217,16 +1302,32 @@ /// <summary> /// 鏌ヨ绌虹洏搴撳瓨淇℃伅 /// </summary> - private async Task<DtStockInfo> QueryStockInfoForEmptyTrayAsync(string areaCode) + private async Task<DtStockInfo> QueryStockInfoForEmptyTrayAsync(string areaCode, string position) { var area = await _areaInfoRepository.QueryFirstAsync(x => x.AreaCode == areaCode); + + ConsoleHelper.WriteColorLine(position + "..." + areaCode, ConsoleColor.Magenta); + var station = await _stationManagerRepository.QueryFirstAsync(x => x.stationChildCode == position && x.stationType == 17); + + ConsoleHelper.WriteColorLine(station.Roadway, ConsoleColor.Magenta); + var stackers = station.Roadway.Split(',').ToList(); + + + var devices = SqlSugarHelper.DbWCS.Queryable<Dt_DeviceInfo>() + .Where(x => x.DeviceStatus == "1") + .Where(x => stackers.Contains(x.DeviceCode)) + .ToList(); + + var deviceCode = devices.Select(x => x.DeviceCode).ToList(); var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>() .Includes(x => x.LocationInfo) // 棰勫姞杞絃ocationInfo .Includes(x => x.StockInfoDetails) // 棰勫姞杞絊tockInfoDetails + .Where(x => x.ProductionLine == station.productLine) .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 && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢 + .WhereIF(!deviceCode.IsNullOrEmpty(), x => deviceCode.Contains(x.LocationInfo.RoadwayNo)) .OrderBy(x => x.CreateDate) // 鎺掑簭 .FirstAsync(); // 杞崲涓哄垪琛� @@ -1242,7 +1343,7 @@ { return new Dt_Task { - Grade = tag == 104 ? 2 : 1, + Grade = tag == 104 ? (stockInfo.LocationInfo.RoadwayNo.Contains("CWSC") ? 1 : 2) : (stockInfo.LocationInfo.RoadwayNo.Contains("CWSC") ? 2 : 1), Roadway = stockInfo.LocationInfo.RoadwayNo, TargetAddress = position, Dispatchertime = DateTime.Now, @@ -1258,6 +1359,7 @@ Creater = "System", // 淇鎷煎啓閿欒 CreateDate = DateTime.Now, TaskId = 0, + ProductionLine = stockInfo.ProductionLine, }; } @@ -1277,6 +1379,7 @@ TaskState = task.TaskState.Value, Id = 0, TaskType = task.TaskType, + ProductionLine = task.ProductionLine, }; } @@ -1345,6 +1448,10 @@ { return content.Error("鏈煡璇㈠埌瀵瑰簲鐨勫簱瀛樹俊鎭�"); } + if (stockInfo.LocationInfo.LocationStatus != (int)LocationEnum.InStock) + { + return content.Error("璇ヨ揣浣嶇姸鎬佷笉绛変簬銆愭湁璐с�戣鏌ョ湅鏄惁宸茬粡鏈変换鍔★紒"); + } var task = await BaseDal.QueryFirstAsync(x => x.PalletCode == palletCode); if (task != null) @@ -1365,9 +1472,12 @@ } else { - if (stockInfo.LocationInfo.RoadwayNo == "JZSC1") + if (stockInfo.LocationInfo.RoadwayNo.Contains("JZSC")) { - task = CreateTask(stockInfo, "002-021-001", taskType); + var targetAddress = "002-021-001"; + if (stockInfo.LocationInfo.RoadwayNo == "JZSC4") + targetAddress = "001-021-001"; + task = CreateTask(stockInfo, targetAddress, taskType); } } //var taskId = await BaseDal.AddDataAsync(task); @@ -1618,7 +1728,8 @@ TaskState = (int)TaskInStatusEnum.Line_InFinish, TaskType = (int)TaskInboundTypeEnum.Inbound, TaskNum = await BaseDal.GetTaskNo(), - Creater = "Systeam" + Creater = "Systeam", + ProductionLine = result.ProductionLine }; // 鍒涘缓WMS浠诲姟 @@ -1637,7 +1748,40 @@ content.OK(data: taskDTO); } else - content.Error(result.MOMMessage); + { + var location = await GetLocationDistributeAsync(station.Roadway); + 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.InTray, + TaskNum = await BaseDal.GetTaskNo(), + Creater = "Systeam", + ProductionLine = result.ProductionLine + }; + // 鍒涘缓WMS浠诲姟 + WMSTaskDTO taskDTO = CreateWMSTaskDTO(task); + + await _unitOfWorkManage.UseTranAsync(async () => + { + // 娣诲姞浠诲姟鍒版暟鎹簱 + await BaseDal.AddDataAsync(task); + // 鏇存柊搴撳瓨浣嶇疆鐘舵�佷负涓嶅彲鐢� + location.LocationStatus = (int)LocationEnum.Lock; + await _locationRepository.UpdateDataAsync(location); + }); + + content.OK(data: taskDTO); + } } else { @@ -1665,11 +1809,12 @@ Grade = 1, PalletCode = taskOld.PalletCode, RoadWay = taskOld.Roadway, - SourceAddress = taskOld.CurrentAddress, + SourceAddress = taskOld.SourceAddress, TargetAddress = taskOld.TargetAddress, TaskState = taskOld.TaskState.Value, Id = 0, TaskType = taskOld.TaskType, + ProductionLine = taskOld.ProductionLine }; } else if (source is Dt_Task task) @@ -1685,6 +1830,7 @@ TaskState = task.TaskState.Value, Id = 0, TaskType = task.TaskType, + ProductionLine = task.ProductionLine }; } else @@ -1696,6 +1842,8 @@ #endregion 闈欑疆寮傚父鍙e叆搴� #endregion 澶栭儴鎺ュ彛鏂规硶 + + #region 鍐呴儴璋冪敤鏂规硶 @@ -1889,6 +2037,10 @@ taskHty.TaskId = 0; taskHty.OperateType = isHand ? (int)OperateTypeEnum.浜哄伐鍒犻櫎 : (int)OperateTypeEnum.鑷姩瀹屾垚; taskHty.SourceId = task.TaskId; + if (isHand) + { + taskHty.Creater = App.User.UserName != null ? App.User.UserName : "System"; + } taskHty.TaskState = TaskOutStatusEnum.OutFinish.ObjToInt(); return taskHty; } @@ -1945,16 +2097,19 @@ } } - var stocks = _stockInfoRepository.QueryData(x => x.AreaCode == stock.AreaCode && x.ProductionLine == stock.ProductionLine && x.SpecialParameterDuration != stock.SpecialParameterDuration); - if (stocks != null && stocks.Count > 0) + if (stock.IsFull) { - foreach (var item in stocks) + var stocks = _stockInfoRepository.QueryData(x => x.AreaCode == stock.AreaCode && x.ProductionLine == stock.ProductionLine && x.SpecialParameterDuration != stock.SpecialParameterDuration); + if (stocks != null && stocks.Count > 0) { - item.SpecialParameterDuration = stock.SpecialParameterDuration; - item.ParameterInfos = stock.ParameterInfos; - item.OutboundTime = Convert.ToDateTime(item.LinedProcessFeedbackTime == null ? item.CreateDate : item.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(stock.SpecialParameterDuration)); + foreach (var item in stocks) + { + item.SpecialParameterDuration = stock.SpecialParameterDuration; + item.ParameterInfos = stock.ParameterInfos; + item.OutboundTime = Convert.ToDateTime(item.LinedProcessFeedbackTime == null ? item.CreateDate : item.LinedProcessFeedbackTime).AddHours(Convert.ToDouble(stock.SpecialParameterDuration)); + } + var isUpdates = await _stockInfoRepository.UpdateDataAsync(stocks); } - var isUpdates = await _stockInfoRepository.UpdateDataAsync(stocks); } // 娣诲姞鍘嗗彶浠诲姟 @@ -1990,85 +2145,97 @@ #region 浠诲姟璇锋眰鏂规硶 + + private static readonly SemaphoreSlim _semaphoreUpdate = new SemaphoreSlim(1, 1); // 鏇存柊浠诲姟璐т綅 private async Task<WebResponseContent> UpdateExistingTask(RequestTaskDto input, Dt_Task task) { - if (task == null) - { - return new WebResponseContent().Error("浠诲姟瀵硅薄涓虹┖"); - } - + await _semaphoreUpdate.WaitAsync(); try { - // 鍒涘缓WebResponseContent瀵硅薄 - var content = new WebResponseContent(); - - // 鑾峰彇鐩爣鍦板潃鍜屾洿鏂颁换鍔$姸鎬� - - input.Position = Regex.Replace(input.Position, @"-(\d+)", ""); - if (Convert.ToInt32(input.Position) > 1999) + if (task == null) { - input.Position = (Convert.ToInt32(input.Position) - 1000).ToString(); + return new WebResponseContent().Error("浠诲姟瀵硅薄涓虹┖"); } - if (task.TaskType == (int)TaskInboundTypeEnum.InNG) + try { - // TODO 鏍规嵁宸烽亾鏌ユ壘瀵瑰簲NG鍙o紝鐜板湪榛樿鍘婚潤缃爢鍨涙満鐨勫紓甯稿彛璐т綅鍙� - task.CurrentAddress = input.Position; - task.TargetAddress = "002-021-000"; - task.NextAddress = "002-021-000"; - task.TaskState = (int)TaskInStatusEnum.Line_InFinish; - bool isResult = await BaseDal.UpdateDataAsync(task); - return content.OK(data: task); - } - else if (task.TaskType == (int)TaskInboundTypeEnum.InQuality) - { - var stockInfo = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == input.PalletCode); - task.CurrentAddress = input.Position; - task.TargetAddress = stockInfo.LocationInfo.LocationCode; - task.NextAddress = stockInfo.LocationInfo.LocationCode; - task.TaskState = (int)TaskInStatusEnum.Line_InFinish; - bool isResult = await BaseDal.UpdateDataAsync(task); - return content.OK(data: task); - } - else - { - var location = await GetLocationDistributeAsync(task.Roadway); - if (location == null) + // 鍒涘缓WebResponseContent瀵硅薄 + var content = new WebResponseContent(); + + // 鑾峰彇鐩爣鍦板潃鍜屾洿鏂颁换鍔$姸鎬� + + input.Position = Regex.Replace(input.Position, @"-(\d+)", ""); + if (Convert.ToInt32(input.Position) > 1999) { - return content.Error("鏃犳硶鑾峰彇璐т綅淇℃伅"); + input.Position = (Convert.ToInt32(input.Position) - 1000).ToString(); } - string toAddress = location.LocationCode; - int taskState = (int)TaskInStatusEnum.Line_InFinish; - int beforeStatus = location.LocationStatus; - // 鏇存柊璐т綅淇℃伅 - location.LocationStatus = (int)LocationEnum.Lock; - - // 鏇存柊浠诲姟淇℃伅 - MapTaskProperties(task, input, toAddress, taskState); - - // 寮�濮嬩簨鍔� - var isResult = await UpdateTaskAsync(task, location, beforeStatus); - if (!isResult) + if (task.TaskType == (int)TaskInboundTypeEnum.InNG) { - _unitOfWorkManage.RollbackTran(); - return content.Error("鏇存柊浠诲姟澶辫触"); + // TODO 鏍规嵁宸烽亾鏌ユ壘瀵瑰簲NG鍙o紝鐜板湪榛樿鍘婚潤缃爢鍨涙満鐨勫紓甯稿彛璐т綅鍙� + task.CurrentAddress = input.Position; + task.TargetAddress = "002-021-000"; + task.NextAddress = "002-021-000"; + task.TaskState = (int)TaskInStatusEnum.Line_InFinish; + bool isResult = await BaseDal.UpdateDataAsync(task); + return content.OK(data: task); } + else if (task.TaskType == (int)TaskInboundTypeEnum.InQuality) + { + var stockInfo = await _stockInfoRepository.QueryFirstNavAsync(x => x.PalletCode == input.PalletCode); + task.CurrentAddress = input.Position; + task.TargetAddress = stockInfo.LocationInfo.LocationCode; + task.NextAddress = stockInfo.LocationInfo.LocationCode; + task.TaskState = (int)TaskInStatusEnum.Line_InFinish; + bool isResult = await BaseDal.UpdateDataAsync(task); + return content.OK(data: task); + } + else + { + var location = await GetLocationDistributeAsync(task.Roadway); + if (location == null) + { + return content.Error("鏃犳硶鑾峰彇璐т綅淇℃伅"); + } - // 鎻愪氦浜嬪姟 - _unitOfWorkManage.CommitTran(); - return content.OK(data: task); + string toAddress = location.LocationCode; + int taskState = (int)TaskInStatusEnum.Line_InFinish; + int beforeStatus = location.LocationStatus; + // 鏇存柊璐т綅淇℃伅 + location.LocationStatus = (int)LocationEnum.Lock; + + // 鏇存柊浠诲姟淇℃伅 + MapTaskProperties(task, input, toAddress, taskState); + + // 寮�濮嬩簨鍔� + var isResult = await UpdateTaskAsync(task, location, beforeStatus); + if (!isResult) + { + _unitOfWorkManage.RollbackTran(); + return content.Error("鏇存柊浠诲姟澶辫触"); + } + + // 鎻愪氦浜嬪姟 + _unitOfWorkManage.CommitTran(); + return content.OK(data: task); + } + } + catch (Exception ex) + { + // 鍥炴粴浜嬪姟 + _unitOfWorkManage.RollbackTran(); + // 杩欓噷鍙互娣诲姞鏃ュ織璁板綍 + return new WebResponseContent().Error($"鏇存柊浠诲姟鏃跺彂鐢熼敊璇�: {ex.Message}"); } } - catch (Exception ex) + catch (Exception) { - // 鍥炴粴浜嬪姟 - _unitOfWorkManage.RollbackTran(); - // 杩欓噷鍙互娣诲姞鏃ュ織璁板綍 - return new WebResponseContent().Error($"鏇存柊浠诲姟鏃跺彂鐢熼敊璇�: {ex.Message}"); + + throw; } + finally { _semaphoreUpdate.Release(); } } private void MapTaskProperties(Dt_Task task, RequestTaskDto input, string toAddress, int taskState) @@ -2108,7 +2275,7 @@ /// <param name="process">宸烽亾</param> /// <param name="flag">鏍囪瘑锛�0-鍏ュ簱锛�1-绌烘墭鐩樺叆搴擄紝2-NG鍏ュ簱锛�3-鍑哄簱锛�</param> /// <returns></returns> - private async Task<WebResponseContent> CreateNewTask(RequestTaskDto input, List<string> process = null, int flag = 0) + private async Task<WebResponseContent> CreateNewTask(RequestTaskDto input, string productionLine, List<string> process = null, int flag = 0) { WebResponseContent content = new WebResponseContent(); @@ -2136,7 +2303,8 @@ TaskState = flag == 3 ? (int)TaskOutStatusEnum.OutNew : (int)TaskInStatusEnum.InNew, TaskType = flag == 0 ? (int)TaskInboundTypeEnum.Inbound : flag == 1 ? (int)TaskInboundTypeEnum.InTray : flag == 2 ? (int)TaskInboundTypeEnum.InNG : (int)TaskOutboundTypeEnum.Outbound, TaskNum = await BaseDal.GetTaskNo(), - Creater = "Systeam" + Creater = "Systeam", + ProductionLine = productionLine }; // 灏濊瘯娣诲姞鏂颁换鍔� @@ -2165,6 +2333,7 @@ TaskState = task.TaskState.Value, Id = 0, TaskType = task.TaskType, + ProductionLine = task.ProductionLine }; content.OK(data: taskDTO); } @@ -2227,7 +2396,11 @@ /// <returns></returns> public async Task<string> GetRoadWayAsync(List<string> process) { - var minGroup = _locationRepository.QueryData(x => process.Contains(x.RoadwayNo) && x.LocationStatus == (int)LocationEnum.Free) + var deviceCode = await SqlSugarHelper.DbWCS.Queryable<Dt_DeviceInfo>() + .Where(x => x.DeviceStatus == 1.ToString() && process.Contains(x.DeviceCode)) + .Select(x => x.DeviceCode).ToListAsync(); + + var minGroup = _locationRepository.QueryData(x => deviceCode.Contains(x.RoadwayNo) && x.LocationStatus == (int)LocationEnum.Free) .GroupBy(x => x.RoadwayNo) .OrderByDescending(g => g.Count()) // 鏍规嵁姣忎釜缁勭殑鍏冪礌鏁伴噺鎺掑簭 .ToList(); // 鍙栧嚭鏁伴噺鏈�澶氱殑缁� @@ -2336,7 +2509,7 @@ ParameterDesc = parameterInfo.Description, ParameterResult = "OK", TargetValue = parameterInfo.TargetValue, - LowerLomit = parameterInfo.LowerSpecificationsLimit, + LowerLimit = parameterInfo.LowerSpecificationsLimit, UpperLimit = parameterInfo.UpperSpecificationsLimit, DefectCode = defectCode, } -- Gitblit v1.9.3