public async Task <List <PB_Supplier> > GetQueryData(SelectQueryDTO search)
{
var q = GetIQueryable();
var where = LinqHelper.True <PB_Supplier>();
if (!search.Keyword.IsNullOrEmpty())
{
where = where.And(w => w.Name.Contains(search.Keyword) || w.Code.Contains(search.Keyword));
}
var result = await q.Where(where).OrderBy(o => o.Name).Take(search.Take).ToListAsync();
if (!search.Id.IsNullOrEmpty())
{
var one = await this.GetIQueryable().Where(w => w.Id == search.Id).SingleOrDefaultAsync();
result.Add(one);
}
return(result);
}
public async Task <List <IT_LocalMaterial> > GetQueryData(SelectQueryDTO search, string storId)
{
var q = GetIQueryable().Include(i => i.Material).Where(w => w.StorId == storId);
var where = LinqHelper.True <IT_LocalMaterial>();
if (!search.Keyword.IsNullOrEmpty())
{
where = where.And(w => w.Material.Name.Contains(search.Keyword) || w.Material.Code.Contains(search.Keyword));
}
var result = await q.Where(where).OrderBy(o => o.Material.Name).Take(search.Take).ToListAsync();
if (!search.Id.IsNullOrEmpty())
{
var one = await this.GetIQueryable().Where(w => w.Id == search.Id).SingleOrDefaultAsync();
result.Add(one);
}
return(result);
}
public async Task <List <PB_Material> > GetQueryData(SelectQueryDTO search)
{
return(await _pB_MaterialBus.GetQueryData(search));
}
public async Task <List <IT_LocalMaterial> > GetQueryData(SelectQueryDTO search)
{
return(await _iT_LocalMaterialBus.GetQueryData(search, _Op.Property.DefaultStorageId));
}
public async Task <List <PB_Customer> > GetQueryData(SelectQueryDTO search)
{
return(await _pB_CustomerBus.GetQueryData(search));
}
