From 17e8b649951cd9dbfa7ad77173f5830a678de313 Mon Sep 17 00:00:00 2001
From: zongzhibin <zongzhibin@weben-smart.com>
Date: 周六, 30 11月 2024 17:26:24 +0800
Subject: [PATCH] add
---
LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsBase/WmsBasePlace/WmsBasePlaceService.cs | 35 ++++++++++++++++++++++++++++++++---
1 files changed, 32 insertions(+), 3 deletions(-)
diff --git a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsBase/WmsBasePlace/WmsBasePlaceService.cs b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsBase/WmsBasePlace/WmsBasePlaceService.cs
index da7ecf6..f6dec3e 100644
--- a/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsBase/WmsBasePlace/WmsBasePlaceService.cs
+++ b/LA24030_LuLiPackageLine_Wms/Admin.NET.Application/Service/WmsBase/WmsBasePlace/WmsBasePlaceService.cs
@@ -12,9 +12,12 @@
public class WmsBasePlaceService : IDynamicApiController, ITransient
{
private readonly SqlSugarRepository<WmsBasePlace> _rep;
- public WmsBasePlaceService(SqlSugarRepository<WmsBasePlace> rep)
+ private readonly SqlSugarRepository<V_Station_Quan> _V_Station_Quan;
+ public WmsBasePlaceService(SqlSugarRepository<WmsBasePlace> rep,
+ SqlSugarRepository<V_Station_Quan> V_Station_Quan_Rep)
{
_rep = rep;
+ _V_Station_Quan = V_Station_Quan_Rep;
}
/// <summary>
@@ -230,8 +233,8 @@
WmsBasePlace place = new WmsBasePlace();
place.PlaceType = placeTypeEnum;
place.PlaceTypeName = placeTypeEnum.ToString();
- place.PlaceCode = aisle.ToString("00") + column.ToString("00") + layer.ToString("00");
- place.PlaceName = aisle.ToString("00") + column.ToString("00") + layer.ToString("00");
+ place.PlaceCode = aisle.ToString("00") + layer.ToString("00") + column.ToString("00");
+ place.PlaceName = aisle.ToString("00") + layer.ToString("00") + column.ToString("00");
place.AreaCode = "";
place.PlaceStatus = PlaceStatusEnum.姝ｅ父;
place.AreaName = "鏈哄櫒浜哄矝缂撳瓨鍖�";
@@ -260,5 +263,31 @@
await _rep.InsertRangeAsync(places);
}
+
+ /// <summary>
+ /// 涓嶅垎椤垫煡璇㈠簱浣嶄俊鎭�
+ /// </summary>
+ /// <param name="input"></param>
+ /// <returns></returns>
+ [HttpGet]
+ [ApiDescriptionSettings(Name = "ListView")]
+ [Description("WmsBasePlace/ListView")]
+ public async Task<List<LocationViewOutput>> ListView([FromQuery] WmsBasePlaceInput input)
+ {
+ var query = await _V_Station_Quan.AsQueryable()
+ .WhereIF(!string.IsNullOrWhiteSpace(input.SearchKey), u =>
+ u.PlaceCode.Contains(input.SearchKey.Trim())
+ // || u.WareContainerCode.Contains(input.SearchKey.Trim())
+ //|| u.Lane==input.Lane
+ //|| u.Row==input.Row
+ )
+ .OrderBy(u => u.LaneNo)
+ //.OrderBy(u => u.Row)
+ .OrderBy(u => u.LayerNo)
+ .OrderBy(u => u.ColumnNo)
+ .Select<LocationViewOutput>().ToListAsync();
+ return query;
+ }
+
}
--
Gitblit v1.9.3