From 29f20b28392d212c04c0c40a512894f8622cfa53 Mon Sep 17 00:00:00 2001 From: wanshenmean <cathay_xy@163.com> Date: 星期三, 16 四月 2025 09:32:01 +0800 Subject: [PATCH] 合并 --- CodeManagement/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Partial/Dt_TaskService.cs | 90 +++++++++++++++++++-------------------------- 1 files changed, 38 insertions(+), 52 deletions(-) diff --git a/CodeManagement/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Partial/Dt_TaskService.cs b/CodeManagement/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Partial/Dt_TaskService.cs index 5182457..a59aa03 100644 --- a/CodeManagement/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Partial/Dt_TaskService.cs +++ b/CodeManagement/WMS/WIDESEA_WMSServer/WIDESEA_StorageTaskServices/Task/Partial/Dt_TaskService.cs @@ -20,6 +20,7 @@ /// <returns>鍖呭惈浠诲姟淇℃伅鐨勫搷搴斿唴瀹�</returns> public async Task<WebResponseContent> RequestInTask(RequestTaskDto input) { + Console.WriteLine($"{JsonConvert.SerializeObject(input)}"); // 鍒涘缓涓�涓猈ebResponseContent瀵硅薄 WebResponseContent content = new WebResponseContent(); try @@ -540,36 +541,34 @@ { if (stationManager.stationType != 7) throw new Exception("閿欒鐨勮皟鍙�"); - // 浠庣紦瀛樹腑鑾峰彇搴撳瓨淇℃伅 - IDictionary<string, DtStockInfo>? stockInfos = _simpleCacheService.HashGetAll<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo); - List<DtStockInfo> stockInfoList = stockInfos.Values.ToList(); + var stockInfo = await QueryStockInfoForEmptyTrayFRAsync("CWSC1", "10086", input.ProductionLine); - var stockinfo1 = stockInfoList.OrderBy(x => x.CreateDate) - .ToList(); - var stockinfo = stockinfo1.Where(x => x.LocationInfo != null && !x.IsFull && x.LocationInfo.RoadwayNo == stationManager.Roadway) - .FirstOrDefault(); - - if (stockinfo == null) return null; + if (stockInfo == null) return null; var task = new Dt_Task { CurrentAddress = input.Position, Grade = 2, - Roadway = input.Roadways, + Roadway = stockInfo.LocationInfo.RoadwayNo, TargetAddress = stationManager.stationLocation, Dispatchertime = DateTime.Now, MaterialNo = "", - NextAddress = input.Roadways, + NextAddress = input.Position, OrderNo = null, - PalletCode = stockinfo.PalletCode, - SourceAddress = stockinfo.LocationCode, + PalletCode = stockInfo.PalletCode, + SourceAddress = stockInfo.LocationCode, TaskState = (int)TaskOutStatusEnum.OutNew, TaskType = (int)TaskOutboundTypeEnum.OutTray, TaskNum = await BaseDal.GetTaskNo(), Creater = "System", - ProductionLine = stockinfo.ProductionLine, + ProductionLine = stockInfo.ProductionLine, }; - _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { task.PalletCode }); + + var location = _locationRepository.QueryFirst(x => x.Id == stockInfo.LocationId); + if (location == null) return null; + location.LocationStatus = (int)LocationEnum.InStockDisable; + _locationRepository.UpdateData(location); + return task; } catch (Exception ex) @@ -617,7 +616,7 @@ { try { - if (stationManager.stationType == 15) throw new Exception(""); + if (stationManager.stationType != 15) throw new Exception(""); // 鍒涘缓涓�涓猅rayCellsStatusDto瀵硅薄锛屽苟璧嬪�� TrayCellsStatusDto trayCells = new TrayCellsStatusDto() @@ -979,23 +978,17 @@ .Where(x => stackers.Contains(x.DeviceCode)) .ToList().Select(x => x.DeviceCode).ToList(); - // 浠庣紦瀛樹腑鑾峰彇搴撳瓨淇℃伅 - IDictionary<string, DtStockInfo>? stockInfos = _simpleCacheService.HashGetAll<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo); - List<DtStockInfo> stockInfoList = stockInfos.Values.ToList(); + var result = await _stockInfoRepository.Db.Queryable<DtStockInfo>() + .Includes(x => x.LocationInfo) + .Includes(x => x.StockInfoDetails) + .Where(x => x.AreaCode == areaCode && x.IsFull == false && x.ProductionLine == productLine) + .WhereIF(!deviceCode.IsNullOrEmpty(), x => deviceCode.Contains(x.LocationInfo.RoadwayNo)) + .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢 + .Where(x => x.StockInfoDetails.Any(y => y.MaterielCode == "绌烘墭鐩�")) + .OrderBy(x => x.CreateDate) // 鎺掑簭 + .FirstAsync(); - var result1 = stockInfoList.Where(x => x.ProductionLine == productLine) - .Where(x => x.AreaCode == areaCode && x.IsFull == false) - .WhereIF(!deviceCode.IsNullOrEmpty(), x => x.LocationInfo != null && deviceCode.Contains(x.LocationInfo.RoadwayNo)) - .OrderBy(x => x.CreateDate) // 鎺掑簭 - .ToList(); // 杞崲涓哄垪琛� - - var result = result1.Where(x => x.StockInfoDetails != null && x.StockInfoDetails.Any(y => y.MaterielCode == "绌烘墭鐩�")) - .Where(x => x.LocationInfo != null && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock && x.LocationInfo.AreaId == area.AreaID && x.LocationInfo.EnalbeStatus == (int)EnableEnum.Enable) // 杩囨护鏉′欢 - .FirstOrDefault(); // 鑾峰彇绗竴涓厓绱� - - if (result != null) - _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { result.PalletCode }); - else + if (result.IsNullOrEmpty()) ConsoleHelper.WriteColorLine($"甯告俯{productLine}绌烘墭鐩樺簱瀛樹笉瓒�", ConsoleColor.Red); return result; @@ -1026,29 +1019,24 @@ .Where(x => x.DeviceCode.Contains("CWSC")) // 杩囨护鏉′欢 .ToList().Select(x => x.DeviceCode).ToList(); - // 浠庣紦瀛樹腑鑾峰彇搴撳瓨淇℃伅 - IDictionary<string, DtStockInfo>? stockInfos = _simpleCacheService.HashGetAll<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo); - List<DtStockInfo> stockInfoList = stockInfos.Values.ToList(); - // 淇敼鍚庣殑鏌ヨ浠g爜 - var stockInfo1 = stockInfoList - .Where(x => x.ProductionLine == station.productLine) - .Where(x => x.AreaCode == "CWSC3" && x.IsFull == true) - .OrderBy(x => x.OutboundTime) - .ToList(); + var stockInfo = await _stockInfoRepository.Db.Queryable<DtStockInfo>() + .Includes(x => x.LocationInfo) + .Includes(x => x.StockInfoDetails) + .Where(x => x.ProductionLine == station.productLine) + .Where(x => x.AreaCode == "CWSC3" && x.IsFull == true) + // 澧炲姞瀵� LocationInfo 鐨勭┖鍊兼鏌� + .Where(x => x.LocationInfo.LocationStatus == (int)LocationEnum.InStock) + // 澧炲姞瀵� LocationInfo 鐨勭┖鍊兼鏌� + .WhereIF(!deviceCode.IsNullOrEmpty(), x => deviceCode.Contains(x.LocationInfo.RoadwayNo)) + .OrderBy(x => x.OutboundTime) + .FirstAsync(); - var stockInfo = stockInfo1 - // 澧炲姞瀵� LocationInfo 鐨勭┖鍊兼鏌� - .Where(x => x.LocationInfo != null && x.LocationInfo.LocationStatus == (int)LocationEnum.InStock) - // 澧炲姞瀵� LocationInfo 鐨勭┖鍊兼鏌� - .WhereIF(!deviceCode.IsNullOrEmpty(), x => x.LocationInfo != null && deviceCode.Contains(x.LocationInfo.RoadwayNo)) - .FirstOrDefault(); - - if (stockInfo == null) throw new Exception($"搴撳唴{station.productLine}鏃犳弧瓒虫潯浠剁殑搴撳瓨鍙嚭搴�"); + if (stockInfo.IsNullOrEmpty()) throw new Exception($"CWSC3搴撳唴{station.productLine}鏃犳弧瓒虫潯浠剁殑搴撳瓨鍙嚭搴�"); DtLocationInfo locationInfo = _locationRepository.QueryFirst(x => x.AreaId == 5 && x.LocationCode == stockInfo.LocationCode); - Dt_StationManager OutStation = _stationManagerRepository.QueryFirst(x => x.stationPLC == "1016" && x.stationType == 10 && x.Roadway == locationInfo.RoadwayNo && x.stationStatus == "1"); + Dt_StationManager OutStation = _stationManagerRepository.QueryFirst(x => x.stationPLC == "1005" && x.stationType == 10 && x.Roadway == locationInfo.RoadwayNo && x.stationStatus == "1"); // 鍒涘缓鏂颁换鍔″疄渚� var task = new Dt_Task @@ -1078,8 +1066,6 @@ BaseDal.AddData(task); stockInfo.LocationInfo.LocationStatus = (int)LocationEnum.InStockDisable; _locationRepository.UpdateData(stockInfo.LocationInfo); - - _simpleCacheService.HashDel<DtStockInfo>(WIDESEA_Cache.CacheConst.Cache_DtStockInfo, new string[] { taskDTO.PalletCode }); _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(stockInfo.LocationInfo, lastStatus, (int)StatusChangeTypeEnum.AutomaticDelivery, task.TaskNum); -- Gitblit v1.9.3