From 38017dde051214ce716bb7cd32454a4f0191fc5f Mon Sep 17 00:00:00 2001
From: admin <qiutairan163@163.com>
Date: 星期三, 17 十二月 2025 13:59:38 +0800
Subject: [PATCH] GetLocatByArea获取储位增加备注显示
---
Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs | 12 ++++++++----
1 files changed, 8 insertions(+), 4 deletions(-)
diff --git a/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs b/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs
index 08a6537..0550afc 100644
--- a/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs
+++ b/Wms/WMS.BLL/BllPdaServer/PdaCrServer.cs
@@ -422,7 +422,7 @@
/// <param name="palletNo">鎵樼洏鍙�</param>
/// <param name="boxNo">绠辩爜</param>
/// <returns></returns>
- public async Task<List<StockDetailWithQtyDto>> GetStockQueryList(string locatNo, string palletNo, string boxNo)
+ public List<StockDetailWithQtyDto> GetStockQueryList(string locatNo, string palletNo, string boxNo)
{
string dataSql = "", whereStr = "";
@@ -447,7 +447,7 @@
group by a.SkuName,a.SkuNo,a.LotNo,b.LocatNo,a.PalletNo
order by a.SkuNo,a.LotNo";
}
- DataTable dataDt = await Db.Ado.GetDataTableAsync(dataSql);
+ DataTable dataDt = Db.Ado.GetDataTable(dataSql);
var result = dataDt.Rows.Cast<DataRow>().Select(e => new StockDetailWithQtyDto
{
@@ -893,7 +893,7 @@
/// <param name="areaNo"></param>
/// <returns></returns>
/// <exception cref="Exception"></exception>
- public List<string> GetLocatByArea(string areaNo)
+ public List<SysStorageLocatDto> GetLocatByArea(string areaNo)
{
try
{
@@ -901,7 +901,11 @@
{
throw new Exception("璇烽�夋嫨鍖哄煙");
}
- var _list = Db.Queryable<SysStorageLocat>().Where(w => w.IsDel == "0" && w.AreaNo == areaNo && w.WareHouseNo == "W04").Select(s => s.LocatNo).ToList();
+ var _list = Db.Queryable<SysStorageLocat>().Where(w => w.IsDel == "0" && w.AreaNo == areaNo && w.WareHouseNo == "W04").Select(s => new SysStorageLocatDto()
+ {
+ LocatNo = s.LocatNo,
+ Remark = s.Remark
+ }).ToList();
return _list;
}
--
Gitblit v1.8.0