From 62f6435ffed439deb76093ec0aceac7f3bbd6549 Mon Sep 17 00:00:00 2001
From: wxw <Administrator@DESKTOP-5BIMHQ3>
Date: 星期二, 29 四月 2025 14:33:32 +0800
Subject: [PATCH] 修改问题
---
Wms/WMS.BLL/SysServer/StorageLocatServer.cs | 68 ++++++++++++++-------------------
1 files changed, 29 insertions(+), 39 deletions(-)
diff --git a/Wms/WMS.BLL/SysServer/StorageLocatServer.cs b/Wms/WMS.BLL/SysServer/StorageLocatServer.cs
index 30f6152..6891d49 100644
--- a/Wms/WMS.BLL/SysServer/StorageLocatServer.cs
+++ b/Wms/WMS.BLL/SysServer/StorageLocatServer.cs
@@ -260,20 +260,27 @@
}
foreach (var item in _list)
{
- if (model.AisleNum > 0)
- {
- if (item.LocatNo != _list[0].LocatNo)
+ //if (model.AisleNum > 0)
+ //{
+ //if (item.LocatNo != _list[0].LocatNo)
+ //{
+ // item.AisleOne = _list[0].LocatNo;
+ //}
+ if (model.AisleNum == 0)
{
- item.AisleOne = _list[0].LocatNo;
- }
- if (model.AisleNum > 1)
+ if (item.LocatNo != _list[0].LocatNo)
+ {
+ item.AisleOne = _list[0].LocatNo;
+ }
+ }
+ if (model.AisleNum == 1)
{
if (item.LocatNo != _list[model.Col-1].LocatNo)
{
- item.AisleTwo = _list[model.Col - 1].LocatNo;
+ item.AisleOne = _list[model.Col - 1].LocatNo;
}
}
- }
+ //}
await LocatRst.AddAsync(item);
}
return _list.Count;
@@ -840,45 +847,28 @@
/// <param name="wareHouseNo">浠撳簱</param>
/// <param name="row">鎺�</param>
/// <returns></returns>
- public List<SysStorageLocat> GetFlatLibraryLegend(string wareHouseNo, string row)
+ public List<LocatDto> GetFlatLibraryLegend(string row)
{
try
{
- //涓�妤煎尯鍩�
- //List<string> row1 = new List<string>()
- //{
- // "B01",
- // "B02",
- // "B03",
- // "B04",
- // "B05",
- // "B06",
- // "B07",
- //};
- ////浜屾ゼ鍖哄煙
- //List<string> row3 = new List<string>()
- //{
- // "B11",
- // "B12",
- // "B13",
- // "B14",
- // "B15",
- //};
- string row1 = "'B01','B02','B03','B04','B05','B06','B07'";
- string row3 = "'B11','B12','B13','B14','B15'";
- string str = $"select * from SysStorageLocat where IsDel = '0' and WareHouseNo = '{wareHouseNo}' and ";
- if (row == "1")
+ var area = Db.Queryable<SysStorageArea>().Where(m => m.IsDel == "0" && m.Status == "0" ).ToList();
+
+ var areaStr = new List<string>();
+ if (row == "3")
{
- str += $" AreaNo in ({row1})";
+ areaStr = area.Where(m => m.AreaName.Contains("3妤�")).Select(m => m.AreaNo).ToList();
}
- else if (row == "3")
+ else if (row == "4")
{
- str += $" AreaNo in ({row3})";
+ areaStr = area.Where(m => m.AreaName.Contains("4妤�")).Select(m => m.AreaNo).ToList();
}
- var list = Db.Ado.SqlQuery<SysStorageLocat>(str);
-
- //var list = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.WareHouseNo == wareHouseNo && row == "1" ? row1.Contains(m.AreaNo) : row3.Contains(m.AreaNo)).ToList();
+ var list = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && areaStr.Contains(m.AreaNo)).Select(m => new LocatDto()
+ {
+ AreaNo2 =m.LocatNo.Substring(0,3),
+ LocatNo = m.LocatNo
+
+ }, true).ToList();
return list;
}
--
Gitblit v1.8.0