public PG <Conf> GetQueryPaging(Conf_filter paging = null, Expression <Func <VD.Data.Entity.Conf, bool> > where = null) { IQueryable <Conf> query; //PHÂN QUYỀN ĐỒ query = GetList(where); //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("Key")) { boloc loc1 = loc; query = query.Where(q => q.Key.Contains(loc1.giatriloc)); } } } } return((new PGQuery <Conf>(query)).GetPG(paging)); }
public PartialViewResult ajax_paging(Conf_filter paging) { return(PartialView(_confServ.GetQueryPaging(paging))); }