From 1d044540ee1b7041c7e89bdfe6d1339c99e80a4e Mon Sep 17 00:00:00 2001 From: 刘磊 <1161824510@qq.com> Date: 星期三, 08 一月 2025 14:41:16 +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 | 83 +++++++++++++++++++++++++++++++++-------- 1 files changed, 66 insertions(+), 17 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 3b6a326..78d25a5 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,19 +1,14 @@ -锘縰sing AngleSharp.Dom; -using log4net.Core; -using Mapster; +锘縰sing 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; +using WIDESEAWCS_QuartzJob.Models; + namespace WIDESEA_StorageTaskServices; @@ -203,8 +198,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); }); @@ -300,7 +295,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("搴撳瓨鍘嗗彶淇℃伅娣诲姞澶辫触"); @@ -1229,14 +1224,19 @@ /// </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 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) // 杩囨护鏉′欢 .OrderBy(x => x.OutboundTime) // 鎺掑簭 .FirstAsync(); // 鑾峰彇绗竴涓厓绱� @@ -1377,6 +1377,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) @@ -1397,9 +1401,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); @@ -1669,7 +1676,39 @@ 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" + }; + // 鍒涘缓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 { @@ -1697,7 +1736,7 @@ Grade = 1, PalletCode = taskOld.PalletCode, RoadWay = taskOld.Roadway, - SourceAddress = taskOld.CurrentAddress, + SourceAddress = taskOld.SourceAddress, TargetAddress = taskOld.TargetAddress, TaskState = taskOld.TaskState.Value, Id = 0, @@ -1728,6 +1767,8 @@ #endregion 闈欑疆寮傚父鍙e叆搴� #endregion 澶栭儴鎺ュ彛鏂规硶 + + #region 鍐呴儴璋冪敤鏂规硶 @@ -1921,6 +1962,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; } @@ -2259,7 +2304,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(); // 鍙栧嚭鏁伴噺鏈�澶氱殑缁� -- Gitblit v1.9.3