using Model.ModelDto.BllAsnDto;
|
using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq.Expressions;
|
using System.Text;
|
using System.Threading.Tasks;
|
using WMS.DAL;
|
using WMS.Entity.BllAsnEntity;
|
using WMS.Entity.Context;
|
using WMS.Entity.SysEntity;
|
using WMS.IBLL.IBllAsnServer;
|
|
namespace WMS.BLL.BllAsnServer
|
{
|
public class PalletUpShelfServer : DbHelper<BllPalletUpShelf>, IPalletUpShelfServer
|
{
|
private static readonly SqlSugarScope Db = DataContext.Db;
|
public PalletUpShelfServer() : base(Db)
|
{
|
}
|
|
public async Task<List<PalletUpShelfDto>> GetPalletUpShelfList(string traceNo, string taskNo, string palletNo, string skuNo, string skuName, string lotNo, string status, int page, int limit, RefAsync<int> count)
|
{
|
Expression<Func<BllPalletUpShelf, bool>> item = Expressionable.Create<BllPalletUpShelf>()
|
.AndIF(!string.IsNullOrWhiteSpace(traceNo), it => it.TraceNo.Contains(traceNo.Trim()))
|
.AndIF(!string.IsNullOrWhiteSpace(taskNo), it => it.TaskNo.Contains(taskNo.Trim()))
|
.AndIF(!string.IsNullOrWhiteSpace(palletNo), it => it.PalletNo.Contains(palletNo.Trim()))
|
.AndIF(!string.IsNullOrWhiteSpace(skuNo), it => it.SkuNo.Contains(skuNo.Trim()))
|
.AndIF(!string.IsNullOrWhiteSpace(skuName), it => it.SkuName.Contains(skuName.Trim()))
|
.AndIF(!string.IsNullOrWhiteSpace(lotNo), it => it.LotNo.Contains(lotNo.Trim()))
|
.AndIF(!string.IsNullOrWhiteSpace(status), it => it.Status == status)
|
.And(it => it.IsDel == "0")
|
.ToExpression();//注意 这一句 不能少
|
|
|
var list = await Db.Queryable<BllPalletUpShelf>().Where(item)
|
.LeftJoin<SysUserInfor>((a, b) => a.CreateUser == b.Id)
|
.LeftJoin<SysUserInfor>((a, b, c) => a.UpdateUser == c.Id)
|
.LeftJoin<SysWareHouse>((a,b,c,d)=> a.WareHouseNo == d.WareHouseNo)
|
.LeftJoin<SysStorageRoadway>((a,b,c,d,e) => a.RoadwayNo == e.RoadwayNo)
|
.LeftJoin<SysStorageArea>((a,b,c,d,e,f) => a.AreaNo == f.AreaNo)
|
.Select((a, b,c,d,e,f) => new PalletUpShelfDto
|
{
|
Id = a.Id,
|
TraceNo = a.TraceNo,
|
TaskNo = a.TaskNo,
|
PalletNo = a.PalletNo,
|
SkuNo = a.SkuNo,
|
SkuName = a.SkuName,
|
LotNo = a.LotNo,
|
Status = a.Status,
|
WareHouseNo = a.WareHouseNo,
|
WareHouseName = d.WareHouseName,
|
RoadwayNo = a.RoadwayNo,
|
RoadwayName = e.RoadwayName,
|
AreaNo = a.AreaNo,
|
AreaName = f.AreaName,
|
LocatNo = a.LocatNo,
|
|
CreateTime = a.CreateTime,
|
CreateUserName = b.RealName,
|
UpdateTime = a.UpdateTime,
|
UpdateUserName = c.RealName,
|
|
}).OrderByDescending(a => a.CreateTime).ToOffsetPageAsync(page, limit, count);
|
|
return list;
|
}
|
}
|
}
|
