using Admin.NET.Core.Service;
|
using Admin.NET.Application.Entity;
|
using Microsoft.AspNetCore.Http;
|
using System.Data;
|
using System.Web;
|
using System.Text;
|
using Admin.NET.Core;
|
|
namespace Admin.NET.Application;
|
/// <summary>
|
/// 库位视图服务
|
/// </summary>
|
[ApiDescriptionSettings(ApplicationConst.ReportCenterGroupName, Order = 100)]
|
public class WmsPlaceContainerInfoService : IDynamicApiController, ITransient
|
{
|
private readonly SqlSugarRepository<v_wms_place_container_info> _rep;
|
private readonly SqlSugarRepository<v_wms_location_view_details> _v_wms_location_view_detailsRep;
|
|
public WmsPlaceContainerInfoService(SqlSugarRepository<v_wms_place_container_info> rep, SqlSugarRepository<v_wms_location_view_details> v_wms_location_view_detailsRep)
|
{
|
_rep = rep;
|
_v_wms_location_view_detailsRep = v_wms_location_view_detailsRep;
|
}
|
|
|
|
/// <summary>
|
/// 不分页查询库位视图
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet]
|
[ApiDescriptionSettings(Name = "List")]
|
[Description("WmsPlaceContainerInfo/List")]
|
public async Task<InventoryByLocationOutput> List([FromQuery] WmsPlaceContainerInfoInput input)
|
{
|
var query = await CommonPageFilter(input).ToListAsync();
|
|
|
|
InventoryByLocationOutput output = new InventoryByLocationOutput();
|
int EmptyLocation = 0;//空库位数量
|
int EmptyContainerLocation = 0;//空托数量
|
int MaterialLocation = 0;//满托数量
|
int LockedLocation = 0;// 锁定库位数量
|
int DisableLocation = 0;//封存库位数量
|
|
|
//分组
|
var groups = query.GroupBy(x => new { x.WareLocationCode });
|
|
foreach (var gg in groups)
|
{
|
//判断状态，是空托，还是 满托，还是空库位
|
var stocks = gg.ToList();
|
|
//有物料（非RQ）的容器集合
|
var materialContinerList = stocks.Where(x => !string.IsNullOrWhiteSpace(x.MaterialCode) && x.MaterialCode != ApplicationConst.DefaultContinerMaterialCode).ToList();
|
|
|
//有货库位
|
if (materialContinerList.Count() > 0)
|
{
|
//有货库位（物料）
|
MaterialLocation++;
|
foreach (var ss in stocks)
|
{
|
ss.InventoryType = 2;
|
}
|
}else
|
|
//只有一条容器库位关系记录
|
//空库位
|
if (stocks.Count == 1 && string.IsNullOrEmpty(stocks.First().WareContainerCode) && string.IsNullOrEmpty(stocks.First().MaterialCode))
|
{
|
//空库位
|
EmptyLocation++;
|
foreach (var ss in stocks)
|
{
|
ss.InventoryType = 0;
|
}
|
}
|
else
|
{ // 物料是容器的空容器（叠托）或容器没有物料
|
EmptyContainerLocation++;
|
foreach (var ss in stocks)
|
{
|
ss.InventoryType = 1;
|
}
|
}
|
|
var item = stocks.First();
|
|
// ----------- ly0729 -库位状态-1显示 0隐藏
|
if (input.InventoryType != null)
|
{
|
if (input.InventoryType == 0)
|
{
|
item.ShowInventoryType = item.InventoryType == 0 ? "1" : "0";
|
}
|
else if (input.InventoryType == 1)
|
{
|
item.ShowInventoryType = item.InventoryType == 1 ? "1" : "0";
|
|
}
|
else if (input.InventoryType == 2)
|
{
|
item.ShowInventoryType = item.InventoryType == 2 ? "1" : "0";
|
}
|
else
|
{
|
item.ShowInventoryType = "0";
|
}
|
}
|
else
|
{
|
item.ShowInventoryType = "1";
|
}
|
// ----------- ly-库位状态-1显示 0隐藏
|
|
|
if (item.Status == PlaceStatusEnum.封存)
|
{
|
DisableLocation++;
|
}
|
else if (item.Status == PlaceStatusEnum.锁定)
|
{
|
LockedLocation++;
|
}
|
|
if (output.Lanes != null)
|
{
|
var tempInventoryByLocationOutput = output.Lanes.Where(x => x.LaneCode == item.Lane).FirstOrDefault();
|
|
if (tempInventoryByLocationOutput == null)
|
{
|
List<RowLocation> rowLocations = new List<RowLocation>() { item };
|
List<Row> rows = new List<Row>() { new Row() { RowCode = item.Row, RowLocations = rowLocations } };
|
Lane lane = new Lane() { LaneCode = item.Lane, Rows = rows };
|
output.Lanes.Add(lane);
|
}
|
else
|
{
|
var temp2 = output.Lanes.Where(x => x.LaneCode == item.Lane && x.Rows.Where(u => u.RowCode == item.Row).ToList().Count > 0).FirstOrDefault();
|
if (temp2 == null)
|
{
|
List<RowLocation> rowLocations = new List<RowLocation>() { item };
|
Row row = new Row() { RowCode = item.Row, RowLocations = rowLocations };
|
tempInventoryByLocationOutput.Rows.Add(row);
|
}
|
else
|
{
|
tempInventoryByLocationOutput.Rows.Where(u => u.RowCode == item.Row).FirstOrDefault().RowLocations.Add(item);
|
}
|
}
|
}
|
else
|
{
|
List<RowLocation> rowLocations = new List<RowLocation>() { item };
|
List<Row> rows = new List<Row>() { new Row() { RowCode = item.Row, RowLocations = rowLocations } };
|
List<Lane> lanes = new List<Lane>() { new Lane() { LaneCode = item.Lane, Rows = rows } };
|
output = new InventoryByLocationOutput() { Lanes = lanes };
|
}
|
}
|
output.EmptyLocation = EmptyLocation;
|
output.EmptyContainerLocation = EmptyContainerLocation;
|
output.MaterialLocation = MaterialLocation;
|
output.LockedLocation = LockedLocation;
|
output.DisableLocation = DisableLocation;
|
return output;
|
|
}
|
|
|
|
/// <summary>
|
/// 不分页查询库位视图
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
[HttpGet]
|
[ApiDescriptionSettings(Name = "Detail")]
|
[Description("WmsPlaceContainerInfo/Detail")]
|
public async Task<SqlSugarPagedList<v_wms_location_view_details>> Detail([FromQuery] WmsStockQuanInput input)
|
{
|
|
var query = _v_wms_location_view_detailsRep.AsQueryable()
|
.WhereIF(!string.IsNullOrWhiteSpace(input.PlaceCode), u => u.PlaceCode.Contains(input.PlaceCode.Trim()))
|
.WhereIF(!string.IsNullOrWhiteSpace(input.ContainerCode), u => u.ContainerCode.Contains(input.ContainerCode.Trim()))
|
.WhereIF(!string.IsNullOrWhiteSpace(input.MaterialCode), u => u.MaterialCode.Contains(input.MaterialCode.Trim()))
|
.Select<v_wms_location_view_details>();
|
|
return await query.OrderBuilder(input, "", "MaterialCode").ToPagedListAsync(input.Page, input.PageSize);
|
|
}
|
|
|
|
|
#region 私有方法
|
|
/// <summary>
|
/// 公共查询事务记录条件
|
/// </summary>
|
/// <param name="input"></param>
|
/// <returns></returns>
|
private ISugarQueryable<RowLocation> CommonPageFilter(WmsPlaceContainerInfoInput input)
|
{
|
var query = _rep.AsQueryable()
|
.WhereIF(!string.IsNullOrWhiteSpace(input.SearchKey), u =>
|
u.WareLocationCode.Contains(input.SearchKey.Trim())
|
|| u.WareContainerCode.Contains(input.SearchKey.Trim())
|
//|| u.Lane==input.Lane
|
//|| u.Row==input.Row
|
)
|
.WhereIF(!string.IsNullOrWhiteSpace(input.AreaCode), u => u.AreaCode.Contains(input.AreaCode.Trim()))
|
.WhereIF(!string.IsNullOrWhiteSpace(input.WareContainerCode), u => u.WareContainerCode.Contains(input.WareContainerCode.Trim()))
|
.WhereIF(!string.IsNullOrWhiteSpace(input.WareLocationCode), u => u.WareLocationCode.Contains(input.WareLocationCode.Trim()))
|
.WhereIF(!string.IsNullOrWhiteSpace(input.WareLocationName), u => u.WareLocationName.Contains(input.WareLocationName.Trim()))
|
.WhereIF(input.Lane.HasValue, u => u.Lane == input.Lane)
|
.WhereIF(input.Row.HasValue, u => u.Row == input.Row)
|
.WhereIF(input.Status.HasValue, u => u.Status == input.Status)
|
.OrderBy(u => u.Lane).OrderBy(u => u.Row)
|
.OrderBy(u => u.Column)
|
.OrderBy(u => u.Layer)
|
.Select<RowLocation>();
|
|
return query;
|
}
|
|
|
#endregion
|
|
}
|
