public PartialViewResult ajax_paging(User_filter paging) { PG <User> vmpg; vmpg = _userServ.GetQueryPaging(paging, w => w.RoleId == 2); return(PartialView(vmpg)); }
public PartialViewResult ajax_paging(User_filter paging) { PG <User> vmpg; vmpg = _userServ.GetQueryPaging(paging, w => w.Username != "vuondao"); return(PartialView(vmpg)); }
public PartialViewResult ajax_paging(User_filter paging) { var __auth = MySsAuthUsers.GetAuth(); PG <User> vmpg; vmpg = _userServ.GetQueryPaging(paging, w => w.OwnerId == __auth.ID); return(PartialView(vmpg)); }
public PG <User> GetQueryPaging(User_filter paging = null, Expression <Func <VD.Data.Entity.User, bool> > where = null) { IQueryable <User> query; //PHÂN QUYỀN ĐỒ query = GetList(where); if (paging.roleid != null && paging.roleid != -1) { query = query.Where(w => w.RoleId == paging.roleid); } if (paging.isvip) { query = query.Where(w => w.IsVip1); } //SORTING query = query.OrderByField(paging.tentruongsort, paging.giatrisort == "asc"); //FILTERING if (paging.bolocs != null) { foreach (var loc in paging.bolocs) { if (loc.tentruongloc.Equals("full_text_search")) { boloc loc1 = loc; query = query.FullTextSearch(loc1.giatriloc, true); } else { if (loc.tentruongloc.Equals("Username")) { boloc loc1 = loc; query = query.Where(q => q.Username.Contains(loc1.giatriloc)); } } } } return((new PGQuery <User>(query)).GetPG(paging)); }