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