From d239f2cccb5b84d52c8c202557ea8e75cc6ab984 Mon Sep 17 00:00:00 2001
From: wxw <Administrator@DESKTOP-5BIMHQ3>
Date: 星期六, 14 九月 2024 16:51:17 +0800
Subject: [PATCH] 任务管理新增功能增加分配拆垛工位功能;调整分拣码垛页面,更改拆垛机器人属性

---
 Admin.NET/WCS.Application/Service/WcsDevice/WcsDeviceService.cs |  235 ++++++++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 219 insertions(+), 16 deletions(-)

diff --git a/Admin.NET/WCS.Application/Service/WcsDevice/WcsDeviceService.cs b/Admin.NET/WCS.Application/Service/WcsDevice/WcsDeviceService.cs
index 165dd6c..71fad93 100644
--- a/Admin.NET/WCS.Application/Service/WcsDevice/WcsDeviceService.cs
+++ b/Admin.NET/WCS.Application/Service/WcsDevice/WcsDeviceService.cs
@@ -1,6 +1,8 @@
 锘�
 using Admin.NET.Core.Service;
 using Elastic.Clients.Elasticsearch;
+using WCS.Application.Entity;
+using WCS.Application.Service.WcsDevice.Dto;
 
 namespace WCS.Application;
 
@@ -210,9 +212,9 @@
         //鑾峰彇璺烘満鐨勭姸鎬�
         foreach (var modDevice in list)
         {
-            if (_sysCacheService.ExistKey("PLCCONN" + modDevice.PlcId))
+            if (_sysCacheService.ExistKey("PLCCONN:" + modDevice.PlcId))
             {
-                var cachePlc = _sysCacheService.Get<WcsPlc>("PLCCONN" + modDevice.PlcId);
+                var cachePlc = _sysCacheService.Get<WcsPlc>("PLCCONN:" + modDevice.PlcId);
                 modDevice.Status = cachePlc.IsConn;
                 if (modDevice.Status)
                 {
@@ -231,28 +233,90 @@
                         modDevice.Wcs = Convert.ToString(wcs);
                         //浠诲姟鍙�
                         var modPositionTask = listPosition.FirstOrDefault(s => s.Text == "浠诲姟鍙�");
-                        (result, var taskNo) = modConn.GetPlcDBValue(modPositionTask.PosType, modDevice.DbNumber, modPositionTask.PlcPos, modPositionTask.StringLength);
-                        modDevice.TaskNo = Convert.ToString(taskNo);
+                        if (modPositionTask != null)
+                        {
+                            (result, var taskNo) = modConn.GetPlcDBValue(modPositionTask.PosType, modDevice.DbNumber, modPositionTask.PlcPos, modPositionTask.StringLength);
+                            modDevice.TaskNo = Convert.ToString(taskNo);
+                        }
                         //浠诲姟绫诲瀷
                         var modPositionTaskType = listPosition.FirstOrDefault(s => s.Text == "浠诲姟绫诲瀷");
-                        (result, var taskType) = modConn.GetPlcDBValue(modPositionTaskType.PosType, modDevice.DbNumber, modPositionTaskType.PlcPos);
-                        modDevice.TaskType = (TaskTypeEnum)Convert.ToInt32(taskType);
+                        if (modPositionTaskType != null)
+                        {
+                            (result, var taskType) = modConn.GetPlcDBValue(modPositionTaskType.PosType, modDevice.DbNumber, modPositionTaskType.PlcPos);
+                            modDevice.TaskType = (TaskTypeEnum)Convert.ToInt32(taskType);
+                        }
                         //璧峰宸ヤ綅
                         var modPositionStartLocatNo = listPosition.FirstOrDefault(s => s.Text == "璧峰宸ヤ綅");
-                        (result, var startLocatNo) = modConn.GetPlcDBValue(modPositionStartLocatNo.PosType, modDevice.DbNumber, modPositionStartLocatNo.PlcPos);
-                        modDevice.StartLocatNo = Convert.ToString(startLocatNo);
+                        if (modPositionStartLocatNo != null)
+                        {
+                            (result, var startLocatNo) = modConn.GetPlcDBValue(modPositionStartLocatNo.PosType, modDevice.DbNumber, modPositionStartLocatNo.PlcPos);
+                            modDevice.StartLocatNo = Convert.ToString(startLocatNo);
+                        }
                         //鐩殑宸ヤ綅
                         var modPositionEndLocatNo = listPosition.FirstOrDefault(s => s.Text == "鐩殑宸ヤ綅");
-                        (result, var endLocatNo) = modConn.GetPlcDBValue(modPositionEndLocatNo.PosType, modDevice.DbNumber, modPositionEndLocatNo.PlcPos);
-                        modDevice.EndLocatNo = Convert.ToString(endLocatNo);
+                        if (modPositionEndLocatNo != null)
+                        {
+                            (result, var endLocatNo) = modConn.GetPlcDBValue(modPositionEndLocatNo.PosType, modDevice.DbNumber, modPositionEndLocatNo.PlcPos);
+                            modDevice.EndLocatNo = Convert.ToString(endLocatNo);
+                        }
                         //鎵樼洏鐮�
                         var modPositionPalletNo = listPosition.FirstOrDefault(s => s.Text == "鎵樼洏鐮�");
-                        (result, var palletNo) = modConn.GetPlcDBValue(modPositionPalletNo.PosType, modDevice.DbNumber, modPositionPalletNo.PlcPos, modPositionPalletNo.StringLength);
-                        modDevice.PalletNo = Convert.ToString(palletNo);
-                    }
-                    catch (Exception)
-                    {
+                        if (modPositionPalletNo != null)
+                        {
+                            (result, var palletNo) = modConn.GetPlcDBValue(modPositionPalletNo.PosType, modDevice.DbNumber, modPositionPalletNo.PlcPos, modPositionPalletNo.StringLength);
+                            modDevice.PalletNo = Convert.ToString(palletNo);
+                            Console.WriteLine(modDevice.DbNumber + "." + modPositionPalletNo.PlcPos + "----------");
+                        }
+                        if (cachePlc.Type == PLCTypeEnum.ConveyorLine)
+                        {
+                            //鏀捐揣鎺�
+                            var modPositionReleaseRow = listPosition.FirstOrDefault(s => s.Text == "鏀捐揣鎺�");
+                            if (modPositionReleaseRow != null)
+                            {
+                                (result, var releaseRow) = modConn.GetPlcDBValue(modPositionReleaseRow.PosType, modDevice.DbNumber, modPositionReleaseRow.PlcPos);
+                                modDevice.ReleaseRow = Convert.ToInt32(releaseRow);
+                            }
+                            //鏀捐揣鍒�
+                            var modPositionReleaseCol = listPosition.FirstOrDefault(s => s.Text == "鏀捐揣鍒�");
+                            if (modPositionReleaseCol != null)
+                            {
+                                (result, var releaseCol) = modConn.GetPlcDBValue(modPositionReleaseCol.PosType, modDevice.DbNumber, modPositionReleaseCol.PlcPos);
+                                modDevice.ReleaseCol = Convert.ToInt32(releaseCol);
+                            }
+                            //鏀捐揣灞�
+                            var modPositionReleaseStorey = listPosition.FirstOrDefault(s => s.Text == "鏀捐揣灞�");
+                            if (modPositionReleaseStorey != null)
+                            {
+                                (result, var releaseStorey) = modConn.GetPlcDBValue(modPositionReleaseStorey.PosType, modDevice.DbNumber, modPositionReleaseStorey.PlcPos);
+                                modDevice.ReleaseStorey = Convert.ToInt32(releaseStorey);
+                            }
+                            //鍙栬揣鎺�
+                            var modPositionPickRow = listPosition.FirstOrDefault(s => s.Text == "鍙栬揣鎺�");
+                            if (modPositionPickRow != null)
+                            {
+                                (result, var pickRow) = modConn.GetPlcDBValue(modPositionPickRow.PosType, modDevice.DbNumber, modPositionPickRow.PlcPos);
+                                modDevice.PickRow = Convert.ToInt32(pickRow);
+                            }
+                            //鍙栬揣鍒�
+                            var modPositionPickCol = listPosition.FirstOrDefault(s => s.Text == "鍙栬揣鍒�");
+                            if (modPositionPickCol != null)
+                            {
+                                (result, var pickCol) = modConn.GetPlcDBValue(modPositionPickCol.PosType, modDevice.DbNumber, modPositionPickCol.PlcPos);
+                                modDevice.PickCol = Convert.ToInt32(pickCol);
+                            }
+                            //鍙栬揣灞�
+                            var modPositionPickStorey = listPosition.FirstOrDefault(s => s.Text == "鍙栬揣灞�");
+                            if (modPositionPickStorey != null)
+                            {
+                                (result, var pickStorey) = modConn.GetPlcDBValue(modPositionPickStorey.PosType, modDevice.DbNumber, modPositionPickStorey.PlcPos);
+                                modDevice.PickStorey = Convert.ToInt32(pickStorey);
+                            }
 
+                        }
+                    }
+                    catch (Exception ex)
+                    {
+                        Console.WriteLine(ex.Message);
                     }
                 }
             }
@@ -274,6 +338,113 @@
         return list;
     }
 
+    [HttpPost]
+    [ApiDescriptionSettings(Name = "WriteValue")]
+    [DisplayName("鍐欏叆鍊�")]
+    public async Task WriteValue(WriteWcsDeviceInput modDevice)
+    {
+        var modPlc = await _wcsDeviceRep.Context.Queryable<WcsPlc>().FirstAsync(s => s.Id == modDevice.PlcId);
+        if (modPlc == null)
+            throw Oops.Bah("鎵句笉鍒癙LC淇℃伅");
+        var modDbDevice = await _wcsDeviceRep.AsQueryable().FirstAsync(s => s.Id == modDevice.Id);
+        PLCUtil modUtil = new PLCUtil(modPlc);
+        var listPosition = await _wcsDeviceRep.Context.Queryable<WcsPosition>().Where(s => s.DeviceId == modDevice.Id).ToListAsync();
+        var result = new IoTClient.Result();
+        //浠诲姟鍙�
+        if (modDevice.TaskNo != null)
+        {
+            var modPositionTask = listPosition.FirstOrDefault(s => s.Text == "浠诲姟鍙�");
+            if (modPositionTask != null)
+                result = modUtil.SetPlcDBValue(modPositionTask.PosType, modDbDevice.DbNumber, modPositionTask.PlcPos, modDevice.TaskNo);
+        }
+        //浠诲姟绫诲瀷
+        if (modDevice.TaskType != null)
+        {
+            var modPositionTaskType = listPosition.FirstOrDefault(s => s.Text == "浠诲姟绫诲瀷");
+            if (modPositionTaskType != null)
+                result = modUtil.SetPlcDBValue(modPositionTaskType.PosType, modDbDevice.DbNumber, modPositionTaskType.PlcPos, ((int)modDevice.TaskType).ToString());
+        }
+        //璧峰宸ヤ綅
+        if (modDevice.StartLocatNo != null)
+        {
+            var modPositionStartLocatNo = listPosition.FirstOrDefault(s => s.Text == "璧峰宸ヤ綅");
+            if (modPositionStartLocatNo != null)
+                result = modUtil.SetPlcDBValue(modPositionStartLocatNo.PosType, modDbDevice.DbNumber, modPositionStartLocatNo.PlcPos, modDevice.StartLocatNo.ToString());
+        }
+        //鐩殑宸ヤ綅
+        if (modDevice.EndLocatNo != null)
+        {
+            var modPositionEndLocatNo = listPosition.FirstOrDefault(s => s.Text == "鐩殑宸ヤ綅");
+            if (modPositionEndLocatNo != null)
+                result = modUtil.SetPlcDBValue(modPositionEndLocatNo.PosType, modDbDevice.DbNumber, modPositionEndLocatNo.PlcPos, modDevice.EndLocatNo.ToString());
+        }
+        //鎵樼洏鐮�
+        if (modDevice.PalletNo != null)
+        {
+            var modPositionPalletNo = listPosition.FirstOrDefault(s => s.Text == "鎵樼洏鐮�");
+            if (modPositionPalletNo != null)
+                result = modUtil.SetPlcDBValue(modPositionPalletNo.PosType, modDbDevice.DbNumber, modPositionPalletNo.PlcPos, modDevice.PalletNo.ToString());
+        }
+        if (modDevice.Plc != null)
+        {
+            var modPositionPLC = listPosition.FirstOrDefault(s => s.Text == "PLC娴佺▼瀛�");
+            if (modPositionPLC != null)
+                result = modUtil.SetPlcDBValue(modPositionPLC.PosType, modDbDevice.DbNumber, modPositionPLC.PlcPos, modDevice.Plc);
+        }
+        if (modDevice.Wcs != null)
+        {
+            var modPositionWCS = listPosition.FirstOrDefault(s => s.Text == "WCS娴佺▼瀛�");
+            if (modPositionWCS != null)
+                result = modUtil.SetPlcDBValue(modPositionWCS.PosType, modDbDevice.DbNumber, modPositionWCS.PlcPos, modDevice.Wcs);
+        }
+        if (modPlc.Type == PLCTypeEnum.ConveyorLine)
+        {
+            //鏀捐揣鎺�
+            if (modDevice.ReleaseRow != null)
+            {
+                var modPositionReleaseRow = listPosition.FirstOrDefault(s => s.Text == "鏀捐揣鎺�");
+                if (modPositionReleaseRow != null)
+                    modUtil.SetPlcDBValue(modPositionReleaseRow.PosType, modDbDevice.DbNumber, modPositionReleaseRow.PlcPos, modDevice.ReleaseRow.ToString());
+            }
+            //鏀捐揣鍒�
+            if (modDevice.ReleaseCol != null)
+            {
+                var modPositionReleaseCol = listPosition.FirstOrDefault(s => s.Text == "鏀捐揣鍒�");
+                if (modPositionReleaseCol != null)
+                    modUtil.SetPlcDBValue(modPositionReleaseCol.PosType, modDbDevice.DbNumber, modPositionReleaseCol.PlcPos, modDevice.ReleaseCol.ToString());
+            }
+            //鏀捐揣灞�
+            if (modDevice.ReleaseStorey != null)
+            {
+                var modPositionReleaseStorey = listPosition.FirstOrDefault(s => s.Text == "鏀捐揣灞�");
+                if (modPositionReleaseStorey != null)
+                    modUtil.SetPlcDBValue(modPositionReleaseStorey.PosType, modDbDevice.DbNumber, modPositionReleaseStorey.PlcPos, modDevice.ReleaseStorey.ToString());
+            }
+            //鍙栬揣鎺�
+            if (modDevice.PickRow != null)
+            {
+                var modPositionPickRow = listPosition.FirstOrDefault(s => s.Text == "鍙栬揣鎺�");
+                if (modPositionPickRow != null)
+                    modUtil.SetPlcDBValue(modPositionPickRow.PosType, modDbDevice.DbNumber, modPositionPickRow.PlcPos, modDevice.PickRow.ToString());
+            }
+            //鍙栬揣鍒�
+            if (modDevice.PickCol != null)
+            {
+                var modPositionPickCol = listPosition.FirstOrDefault(s => s.Text == "鍙栬揣鍒�");
+                if (modPositionPickCol != null)
+                    modUtil.SetPlcDBValue(modPositionPickCol.PosType, modDbDevice.DbNumber, modPositionPickCol.PlcPos, modDevice.PickCol.ToString());
+            }
+            //鍙栬揣灞�
+            if (modDevice.PickStorey != null)
+            {
+                var modPositionPickStorey = listPosition.FirstOrDefault(s => s.Text == "鍙栬揣灞�");
+                if (modPositionPickStorey != null)
+                    modUtil.SetPlcDBValue(modPositionPickStorey.PosType, modDbDevice.DbNumber, modPositionPickStorey.PlcPos, modDevice.PickStorey.ToString());
+            }
+        }
+        modUtil.Close();
+    }
+
     #region 鍒嗘嫞鐮佸灈
     /// <summary>
     /// 鑾峰彇鐮佸灈鏈哄櫒浜哄拰鎷嗗灈鏈哄櫒浜哄垪琛�
@@ -286,7 +457,7 @@
     {
         return await _wcsDeviceRep.Context.Queryable<WcsPlc>()
                 .Where(w => w.Type == PLCTypeEnum.RobotPalletizer || w.Type == PLCTypeEnum.StackingRobot)
-                .OrderBy(o => o.Type)
+                .OrderByDescending(o => o.Type)
                 .Select(u => new
                 {
                     id = u.Id,
@@ -294,6 +465,38 @@
                 }
                 ).ToListAsync();
     }
+    /// <summary>
+    /// 鑾峰彇璁惧瀵瑰簲宸ヤ綅鍒楄〃
+    /// </summary>
+    /// <param name="entry"></param>
+    /// <returns></returns>
+    [HttpGet]
+    [ApiDescriptionSettings(Name = "WcsPackStationPlcList")]
+    [DisplayName("鑾峰彇璁惧瀵瑰簲宸ヤ綅鍒楄〃")]
+    public async Task<List<WcsDeviceTaskOrderDto>> WcsPackStationPlcList([FromQuery] WcsDeviceBaseInput entry)
+    {
+        return await _wcsDeviceRep.Context.Queryable<WcsDevice>()
+                .InnerJoin<WcsPlc>((device, plc) => device.PlcId == plc.Id)
+                .LeftJoin<WcsCheckTask>((device, plc, task) => device.StationNum == task.Port)
+                .Where((device, plc, task) => device.PlcId == entry.PlcId)
+                .OrderBy((device, plc, task) => device.CreateTime)
+                .Select((device, plc, task) => new WcsDeviceTaskOrderDto()
+                {
+                    Id = device.Id,
+                    Text = device.Text,
+                    TaskNo = task.TaskNo,
+                    OrderNo = task.OrderNo,
+                    LotNo = task.LotNo,
+                    SkuNo = task.SkuNo,
+                    SkuName = task.SkuName,
+                    LineNo = task.LineNo,
+                    Status = task.Status,
+                    PZNo = task.PZNo,
+                    Qty = task.Qty,
 
+                    Type = plc.Type
+                })
+                .ToListAsync();
+    }
     #endregion
 }

--
Gitblit v1.8.0