From de9b341ccc98d554f0c324478acab26d7d3cdafd Mon Sep 17 00:00:00 2001
From: qinchulong <qinchulong@hnkhzn.com>
Date: 星期六, 01 三月 2025 21:49:34 +0800
Subject: [PATCH] 新增错误信息显示

---
 项目代码/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs |  166 +++++++++++++++++++++++++++++++++++++++++++++++--------
 1 files changed, 142 insertions(+), 24 deletions(-)

diff --git "a/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs" "b/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs"
index 413c29f..b317044 100644
--- "a/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs"
+++ "b/\351\241\271\347\233\256\344\273\243\347\240\201/WCS/WIDESEAWCS_Server/WIDESEAWCS_TaskInfoService/TaskService.cs"
@@ -16,8 +16,11 @@
 #endregion << 鐗� 鏈� 娉� 閲� >>
 
 using AutoMapper;
+using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;
 using SqlSugar;
 using System.Diagnostics.CodeAnalysis;
+using WIDESEAWCS_Common.LocationEnum;
+using WIDESEAWCS_Common.StockEnum;
 using WIDESEAWCS_Common.TaskEnum;
 using WIDESEAWCS_Core;
 using WIDESEAWCS_Core.BaseRepository;
@@ -27,6 +30,7 @@
 using WIDESEAWCS_ITaskInfoService;
 using WIDESEAWCS_IWMSPart;
 using WIDESEAWCS_Model.Models;
+using WIDESEAWCS_Model.Models.System;
 using WIDESEAWCS_QuartzJob.Models;
 using WIDESEAWCS_QuartzJob.Service;
 
@@ -40,7 +44,8 @@
         private readonly IRepository<Dt_StockInfo> _stockRepository;
         private readonly IRepository<Dt_LocationInfo> _locationRepository;
         private readonly IRepository<dt_batchInfo> _batchinfoRepository;
-
+        private readonly IRepository<Dt_Task_hty> _taskhtyRepository;
+        private readonly IUnitOfWorkManage _unitOfWorkManage;
         private readonly IMapper _mapper;
 
         private Dictionary<string, OrderByType> _taskOrderBy = new()
@@ -60,12 +65,16 @@
         /// </summary>
         public IRepository<Dt_Task> Repository => BaseDal;
 
+        //SBText ITaskService.text { get => throw new NotImplementedException(); set => throw new NotImplementedException(); }
+
         public TaskService(IRepository<Dt_Task> BaseDal, IRouterService routerService, 
             ITaskExecuteDetailService taskExecuteDetailService, 
             IRepository<Dt_TaskExecuteDetail> taskExecuteDetailRepository,
             IRepository<Dt_StockInfo> stockRepository,
             IRepository<Dt_LocationInfo> locationRepository,
             IRepository<dt_batchInfo> batchRepository,
+            IRepository<Dt_Task_hty> taskhtyRepository,
+            IUnitOfWorkManage unitOfWorkManage,
             IMapper mapper) : base(BaseDal)
         {
             _routerService = routerService;
@@ -74,6 +83,8 @@
             _stockRepository = stockRepository;
             _locationRepository = locationRepository;
             _batchinfoRepository = batchRepository;
+            _taskhtyRepository = taskhtyRepository;
+            _unitOfWorkManage = unitOfWorkManage;
             _mapper = mapper;
         }
 
@@ -222,12 +233,39 @@
         /// <param name="deviceNo">璁惧缂栧彿</param>
         /// <param name="currentAddress">褰撳墠鍦板潃</param>
         /// <returns>杩斿洖浠诲姟瀹炰綋瀵硅薄锛屽彲鑳戒负null</returns>
-        public Dt_Task QueryStackerCraneTask(string deviceNo, string currentAddress = "")
+        public Dt_Task QueryStackerCraneTask(string workTpe, string currentAddress = "")
         {
-            if (string.IsNullOrEmpty(currentAddress))
-                return BaseDal.QueryFirst(x => x.Roadway == deviceNo && (TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskInStatusEnum.Line_InFinish || TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew), TaskOrderBy);
-            else
-                return BaseDal.QueryFirst(x => x.Roadway == deviceNo && x.CurrentAddress == currentAddress && (TaskInboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskInStatusEnum.Line_InFinish || TaskOutboundTypes.Contains(x.TaskType) && x.TaskState == (int)TaskOutStatusEnum.OutNew), TaskOrderBy);
+            Dt_Task task = new Dt_Task();
+            try
+            {
+                //浼樺厛鏌ヨ褰撳墠浠诲姟姹犱腑鏄惁鏈夊彇璐у畬鎴愮殑浠诲姟
+                task = BaseDal.QueryFirst(v => v.TaskState == (int)TaskInStatusEnum.Line_Ingrab || v.TaskState == (int)TaskOutStatusEnum.SC_OutExecuting);
+                if (task != null)
+                {
+                    //浼樺厛杩斿洖鎵ц鍒颁竴鍗婄殑浠诲姟缁х画鎵ц
+                    return task;
+                }
+                //鏌ヨ褰撳墠浠诲姟姹犱腑鏄惁瀛樺湪鐘舵�佷负闈炴柊寤虹殑
+                task= BaseDal.QueryFirst(v => v.TaskState != (int)TaskInStatusEnum.InNew || v.TaskState != (int)TaskOutStatusEnum.OutNew);
+                if (task != null)
+                {
+                    throw new Exception($"褰撳墠浠诲姟姹犱腑瀛樺湪鎵ц涓殑浠诲姟,浠诲姟鍙�:銆恵task.TaskNum}銆�");
+                }
+                if (workTpe.Equals("In"))
+                {
+                    task = BaseDal.QueryData(v=>v.TaskType==(int)TaskInboundTypeEnum.Inbound && v.TaskState==(int)TaskInStatusEnum.InNew).OrderBy(v=>v.CreateDate).First();
+                }
+                else if (workTpe.Equals("Out"))
+                {
+                    task = BaseDal.QueryData(v => v.TaskType == (int)TaskOutboundTypeEnum.Outbound && v.TaskState == (int)TaskOutStatusEnum.OutNew).OrderBy(v => v.CreateDate).First();
+                }
+            }
+            catch (Exception)
+            {
+                //灏嗛敊璇俊鎭洿鏂拌嚦閿欒淇℃伅璁板綍琛�
+
+            }
+            return task;
         }
 
         /// <summary>
@@ -331,19 +369,19 @@
             {
                 Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
                 if (task == null) return WebResponseContent.Instance.Error($"鏈壘鍒拌浠诲姟淇℃伅,浠诲姟鍙�:銆恵taskNum}銆�");
-                if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OutbondGroup)
-                {
-                    task.TaskState = (int)TaskOutStatusEnum.OutPending;
-                }
-                else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.InboundGroup)
-                {
-                    task.TaskState = (int)TaskInStatusEnum.InPending;
-                }
+                //if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.OutbondGroup)
+                //{
+                //    task.TaskState = (int)TaskOutStatusEnum.OutPending;
+                //}
+                //else if (task.TaskType.GetTaskTypeGroup() == TaskTypeGroup.InboundGroup)
+                //{
+                //    task.TaskState = (int)TaskInStatusEnum.InPending;
+                //}
                 task.ExceptionMessage = message;
                 task.ModifyDate = DateTime.Now;
                 BaseDal.UpdateData(task);
 
-                _taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, task.ExceptionMessage);
+                //_taskExecuteDetailService.AddTaskExecuteDetail(task.TaskId, task.ExceptionMessage);
 
                 content = WebResponseContent.Instance.OK();
             }
@@ -355,17 +393,38 @@
         }
 
         /// <summary>
-        /// 鏇存柊浠诲姟鐘舵�佷俊鎭紝骞跺悓姝ヨ嚦WMS
+        /// 鏇存柊浠诲姟鐘舵�佷俊鎭�
         /// </summary>
         /// <param name="taskNum">浠诲姟鍙�</param>
         /// <param name="status">浠诲姟鐘舵��</param>
         public void UpdateTaskStatus(int taskNum, int status)
         {
-            Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
-            if (task == null) return;
-            task.TaskState = status;
-            task.ModifyDate = DateTime.Now;
-            BaseDal.UpdateData(task);
+            try
+            {
+                Dt_Task task = BaseDal.QueryFirst(x => x.TaskNum == taskNum);
+                if (status == 2 && task.TaskType == (int)TaskInboundTypeEnum.Inbound)
+                {
+                    task.TaskState = (int)TaskInStatusEnum.Line_InGrabExecuting;
+                }
+                else if (status == 2 && task.TaskType == (int)TaskOutboundTypeEnum.Outbound)
+                {
+                    task.TaskState = (int)TaskOutStatusEnum.Line_OutGrabExecuting;
+                }
+                if (status == 3 && task.TaskType == (int)TaskInboundTypeEnum.Inbound)
+                {
+                    task.TaskState = (int)TaskInStatusEnum.Line_InDownExecuting;
+                }
+                else if (status == 3 && task.TaskType == (int)TaskOutboundTypeEnum.Outbound)
+                {
+                    task.TaskState = (int)TaskOutStatusEnum.Line_OutWownExecuting;
+                }
+                task.ModifyDate = DateTime.Now;
+                BaseDal.UpdateData(task);
+            }
+            catch (Exception ex)
+            {
+
+            }
         }
 
         /// <summary>
@@ -493,7 +552,7 @@
         /// </summary>
         /// <param name="taskNum">浠诲姟缂栧彿</param>
         /// <returns>杩斿洖澶勭悊缁撴灉</returns>
-        public WebResponseContent StackCraneTaskCompleted(int taskNum)
+        public WebResponseContent StackCraneTaskCompleted(int taskNum,float weight)
         {
             WebResponseContent content = new WebResponseContent();
             try
@@ -505,18 +564,77 @@
                 }
                 if (nawtask.TaskType == (int)TaskInboundTypeEnum.Inbound)
                 {
-                    
+                    var batck = _batchinfoRepository.QueryFirst(v=>v.Id==1);
                     //鏂板缓搴撳瓨
+                    Dt_StockInfo stock = new Dt_StockInfo();
+                    stock.LocationCode = nawtask.TargetAddress;
+                    stock.Weight = (decimal)weight;
+                    stock.StockStatus = (int)stockEnum.Lock;
+                    stock.BatchNo = batck.Batch;
+                    //淇敼璐т綅淇℃伅
+                    var location = _locationRepository.QueryFirst(v=>v.LocationCode==nawtask.TargetAddress);
+                    location.LocationStatus = (int)LocationStatusEnum.InStock;
+                    //澶勭悊浠诲姟淇℃伅
+                    Dt_Task_hty taskhty = new Dt_Task_hty();
+                    taskhty.TaskNum = nawtask.TaskNum;
+                    taskhty.Roadway = nawtask.Roadway;
+                    taskhty.TaskType = nawtask.TaskType;
+                    taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish;
+                    taskhty.SourceAddress = nawtask.SourceAddress;
+                    taskhty.TargetAddress = nawtask.TargetAddress;
+                    taskhty.ExceptionMessage = nawtask.ExceptionMessage;
+                    taskhty.Grade = nawtask.Grade;
+                    taskhty.Dispatchertime = nawtask.Dispatchertime;
+                    taskhty.Remark = nawtask.Remark;
+                    //寮�濮嬫暟鎹簱浜嬪姟
+                    _unitOfWorkManage.BeginTran();
+                    _stockRepository.AddData(stock);
+                    _locationRepository.UpdateData(location);
+                    _taskhtyRepository.AddData(taskhty);
+                    BaseDal.DeleteData(nawtask);
+                    //鎻愪氦浜嬪姟
+                    _unitOfWorkManage.CommitTran();
                 }
                 else if (nawtask.TaskType == (int)TaskOutboundTypeEnum.Outbound)
                 {
-
+                    //鏌ユ壘搴撳瓨
+                    var stock = _stockRepository.QueryFirst(v=>v.LocationCode== nawtask.TargetAddress);
+                    if (stock == null) 
+                    {
+                        throw new Exception($"鏈壘鍒板簱瀛樹俊鎭揣浣嶅彿:銆恵nawtask.TargetAddress}銆�");
+                    }
+                    //淇敼璐т綅鐘舵��
+                    var location = _locationRepository.QueryFirst(v => v.LocationCode == nawtask.TargetAddress);
+                    location.LocationStatus = (int)LocationStatusEnum.Free;
+                    //鍑嗗鍘嗗彶浠诲姟鏁版嵁
+                    Dt_Task_hty taskhty = new Dt_Task_hty();
+                    taskhty.TaskNum = nawtask.TaskNum;
+                    taskhty.Roadway = nawtask.Roadway;
+                    taskhty.TaskType = nawtask.TaskType;
+                    taskhty.TaskState = (int)TaskInStatusEnum.Line_InFinish;
+                    taskhty.SourceAddress = nawtask.SourceAddress;
+                    taskhty.TargetAddress = nawtask.TargetAddress;
+                    taskhty.ExceptionMessage = nawtask.ExceptionMessage;
+                    taskhty.Grade = nawtask.Grade;
+                    taskhty.Dispatchertime = nawtask.Dispatchertime;
+                    taskhty.Remark = nawtask.Remark;
+                    //寮�濮嬫暟鎹簱浜嬪姟
+                    _unitOfWorkManage.BeginTran();
+                    _stockRepository.DeleteData(stock);
+                    _locationRepository.UpdateData(location);
+                    _taskhtyRepository.AddData(taskhty);
+                    BaseDal.DeleteData(nawtask);
+                    //鎻愪氦浜嬪姟
+                    _unitOfWorkManage.CommitTran();
                 }
                 content = WebResponseContent.Instance.OK();
             }
             catch (Exception ex)
             {
+                //鍥炴粴浜嬪姟
+                _unitOfWorkManage.RollbackTran();
                 content = WebResponseContent.Instance.Error($"浠诲姟瀹屾垚寮傚父,浠诲姟鍙�:銆恵taskNum}銆�");
+                UpdateTaskExceptionMessage(taskNum,ex.Message);
             }
             return content;
         }

--
Gitblit v1.9.3