From 86e443e42c4bee972c5b795def4917e02f98ce40 Mon Sep 17 00:00:00 2001
From: wxw <Administrator@DESKTOP-5BIMHQ3>
Date: 星期五, 11 七月 2025 16:45:08 +0800
Subject: [PATCH] 修改问题

---
 Wms/WMS.BLL/SysServer/StorageLocatServer.cs |   75 +++++++++++++++++++++++++++++++++----
 1 files changed, 67 insertions(+), 8 deletions(-)

diff --git a/Wms/WMS.BLL/SysServer/StorageLocatServer.cs b/Wms/WMS.BLL/SysServer/StorageLocatServer.cs
index c1e7965..5676ea7 100644
--- a/Wms/WMS.BLL/SysServer/StorageLocatServer.cs
+++ b/Wms/WMS.BLL/SysServer/StorageLocatServer.cs
@@ -2,6 +2,7 @@
 using System.Collections.Generic;
 using System.Linq;
 using System.Linq.Expressions;
+using System.Reflection.Metadata;
 using System.Text;
 using System.Threading.Tasks;
 using Model.ModelDto.SysDto;
@@ -82,7 +83,7 @@
                     Flag = m.Flag,
                     FlagName = GetFlag(m.Flag),
                     Make = m.Make,
-                    MakeName = m.Make == "0"? "璺戦亾": m.Make == "1" ? "鍌ㄤ綅":"",
+                    MakeName = m.Make == "0" ? "璺戦亾" : m.Make == "1" ? "鍌ㄤ綅" : "",
                     Depth = m.Depth,
                     Row = m.Row,
                     Column = m.Column,
@@ -139,7 +140,7 @@
         {
             try
             {
-                var bl = LocatRst.EditStorageLocat(model.Id,model.AreaNo, model.Status, model.Flag, model.Temperature, url, userId);
+                var bl = LocatRst.EditStorageLocat(model.Id, model.AreaNo, model.Status, model.Flag, model.Temperature, url, userId);
 
                 return bl;
             }
@@ -274,7 +275,7 @@
                             {
                                 c1 = c.ToString();
                             }
-                             
+
                             q += await LocatRst.AddAsync(new SysStorageLocat()
                             {
                                 LocatNo = r1 + l1 + c1,
@@ -289,7 +290,7 @@
                                 Layer = c,
                                 CreateUser = userId
                             });
-                             
+
                         }
                     }
                 }
@@ -318,7 +319,7 @@
                 var depth = 0;
                 var depthString = "01";
                 // 鎺�(缁�)寰幆
-                for (int i = 1; i <= model.Row; i++)
+                for (int i = 19; i <= model.Row; i++)
                 {
                     // 鍒楀惊鐜�
                     for (int z = 1; z <= model.Col; z++)
@@ -338,7 +339,7 @@
                         //        //鍏朵綑鏉′欢
                         //    }
                         //}
-                        
+
                         q += await LocatRst.AddAsync(new SysStorageLocat()
                         {
                             // 鍖哄煙+鎺�+鍒�+灞�
@@ -908,9 +909,9 @@
         /// </summary>
         /// <param name="roadwayNo">宸烽亾</param>
         /// <returns></returns>
-        public List<string> ByRoadwayGetRow(string roadwayNo)
+        public List<string> ByRoadwayGetRow(string wareHouseNo, string roadwayNo)
         {
-            string str = $"select Row from SysStorageLocat where IsDel = '0' and WareHouseNo = 'W01' and RoadwayNo = '{roadwayNo}' group by Row order by Row";
+            string str = $"select Row from SysStorageLocat where IsDel = '0' and WareHouseNo = '{wareHouseNo}' and RoadwayNo = '{roadwayNo}' group by Row order by Row";
 
             List<string> row = Db.Ado.SqlQuery<string>(str);
             return row;
@@ -974,5 +975,63 @@
         }
 
         #endregion
+
+        /// <summary>
+        /// 鑾峰彇鍌ㄤ綅淇℃伅(瀵嗛泦搴�)
+        /// </summary>
+        /// <param name="wareHouseNo">浠撳簱</param>
+        /// <param name="row">鎺�</param>
+        /// <returns></returns>
+        public async Task<BordModelVM> GetFlatLegend(string wareHouseNo, int layer)
+        {
+            var list = await Db.Queryable<SysStorageLocat>().Where(s => s.WareHouseNo == wareHouseNo && s.Layer == layer && s.IsDel == "0").ToListAsync();
+            BordModelVM listBord = new BordModelVM()
+            {
+                Col = 15,
+                Row = 21
+            };
+
+            foreach (var modLocat in list)
+            {
+                SlotsVm mod = new SlotsVm()
+                {
+                    SlotColumn = modLocat.Column,
+                    SlotRow = modLocat.Row,
+                    SlotCode = modLocat.LocatNo,
+                    //SlotStatusCls = modLocat.Flag!="0"? "eight": modLocat.Status == "0"? "zero":,
+                    Make = modLocat.Make
+                };
+                if (modLocat.Flag != "0")
+                    mod.SlotStatusCls = "eight";
+                switch (modLocat.Status)
+                {
+                    case "0":
+                        mod.SlotStatusCls = "zero";
+                        break;
+                    case "1":
+                        mod.SlotStatusCls = "one";
+                        break;
+                    case "2":
+                        mod.SlotStatusCls = "two";
+                        break;
+                    case "3":
+                        mod.SlotStatusCls = "three";
+                        break;
+                    case "4":
+                        mod.SlotStatusCls = "four";
+                        break;
+                    case "5":
+                        mod.SlotStatusCls = "five";
+                        break;
+                    default:
+                        break;
+                }
+                listBord.SlotsVm.Add(mod);
+            }
+
+            return listBord;
+
+        }
+
     }
 }

--
Gitblit v1.8.0