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 |  135 ++++++++++++++++++++++++++++++++++----------
 1 files changed, 103 insertions(+), 32 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 7498a48..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;
 
@@ -169,12 +164,19 @@
                         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());
+                            task.Remark = result.Success ? null : "NG";
+
+                            if (!result.Success && result.MessageCode == "E10001")
+                            {
+                                await HandleOutBoundError(stock, task);
+                            }
+                        }
+                        else
+                        {
+                            task.Remark = "NG";
                         }
                     }
                 }
@@ -196,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);
             });
@@ -276,7 +278,7 @@
         //task.CurrentAddress = task.NextAddress;
         //task.NextAddress = task.TargetAddress;
 
-        _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(location, lastStatus, (int)StatusChangeTypeEnum.AutomaticDelivery,task.TaskNum);
+        _locationStatusChangeRecordRepository.AddLocationStatusChangeRecord(location, lastStatus, (int)StatusChangeTypeEnum.AutomaticDelivery, task.TaskNum);
 
         LogFactory.GetLog("浠诲姟瀹屾垚").Info(true, "鏇存柊搴撳瓨鐘舵�佷笌浠诲姟鐘舵��");
         return (location, task);
@@ -293,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("搴撳瓨鍘嗗彶淇℃伅娣诲姞澶辫触");
@@ -352,7 +354,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}");
 
@@ -959,12 +961,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)
                 {
                     // 绌烘墭鐩樺叆搴撻�昏緫
@@ -982,17 +989,27 @@
                     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);
+                return await RequestTrayInTaskAsync(input);
             }
+            else
+            {
 
-            var boxing = CreateBoxingInfo(result, input.PalletCode);
-            if (boxing == null) return content.Error("缁勭洏澶辫触");
 
-            return await ProcessBasedOnProcessCode(boxing, area, input, result);
+                // 澶勭悊寮傚父鐢佃姱鎯呭喌
+                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("缁勭洏澶辫触");
+
+                return await ProcessBasedOnProcessCode(boxing, area, input, result);
+            }
         }
         catch (Exception err)
         {
@@ -1207,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(); // 鑾峰彇绗竴涓厓绱�
 
@@ -1355,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)
@@ -1375,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);
@@ -1647,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
             {
@@ -1675,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,
@@ -1706,6 +1767,8 @@
     #endregion 闈欑疆寮傚父鍙e叆搴�
 
     #endregion 澶栭儴鎺ュ彛鏂规硶
+
+
 
     #region 鍐呴儴璋冪敤鏂规硶
 
@@ -1899,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;
     }
@@ -2237,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