public async Task <PageResult <IT_RecordBook> > GetDataListAsync(IT_RecordBookPageInput input)
{
var q = GetIQueryable()
.Include(i => i.FromLocation)
.Include(i => i.ToLocation)
.Include(i => i.FromStorage)
.Include(i => i.ToStorage)
.Include(i => i.Material)
.Include(i => i.Measure);
var where = LinqHelper.True <IT_RecordBook>();
var search = input.Search;
if (!search.LocalName.IsNullOrEmpty())
{
where = where.And(w => w.FromLocation.Name.Contains(search.LocalName) || w.ToLocation.Name.Contains(search.LocalName) ||
w.ToLocation.Code.Contains(search.LocalName) || w.ToLocation.Code.Contains(search.LocalName));
}
if (!search.BarCodeBatchNo.IsNullOrEmpty())
{
where = where.And(w => w.BatchNo.Contains(search.BarCodeBatchNo) || w.BarCode.Contains(search.BarCodeBatchNo));
}
if (!search.MaterialName.IsNullOrEmpty())
{
where = where.And(w => w.Material.Code.Contains(search.MaterialName) || w.Material.Name.Contains(search.MaterialName));
}
if (!search.RefCode.IsNullOrEmpty())
{
where = where.And(w => w.RefCode.Contains(search.RefCode));
}
if (!search.Type.IsNullOrEmpty())
{
where = where.And(w => w.Type.Contains(search.Type));
}
return(await q.Where(where).GetPageResultAsync(input));
}
public async Task <PageResult <IT_RecordBook> > GetDataList(IT_RecordBookPageInput input)
{
return(await _iT_RecordBookBus.GetDataListAsync(input));
}
