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)); }