public PG <ThongBao> GetQueryPaging(smartpaging paging = null, Expression <Func <ThongBao, bool> > where = null) { IQueryable <ThongBao> 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("ThongBaoname")) * { * boloc loc1 = loc; * query = query.Where(q => q.ThongBaoname.Contains(loc1.giatriloc)); * }*/ } } } return((new PGQuery <ThongBao>(query)).GetPG(paging)); }
public PG <ProductCat> GetQueryPaging(smartpaging paging = null, Expression <Func <ProductCat, bool> > @where = null) { IQueryable <ProductCat> query; //PHÂN QUYỀN ĐỒ query = GetList(where); if (paging.quanid != -1) { query = query.Where(w => w.QuanId == paging.quanid); } //SORTING query = query.OrderByField(paging.tentruongsort, paging.giatrisort == "asc"); //FILTERING if (paging.bolocs != null) { foreach (var loc in paging.bolocs) { //if (loc.tentruongloc.Equals("Username")) //{ // boloc loc1 = loc; // // query = query.Where(q => q.Username.Contains(loc1.giatriloc)); //} } } return((new PGQuery <ProductCat>(query)).GetPG(paging)); }
public PartialViewResult ajax_paging(smartpaging paging) { PG <ThongBao> vmpg; vmpg = _ThongBaoerv.GetQueryPaging(paging); return(PartialView(vmpg)); }
public PartialViewResult ajax_paging(smartpaging paging) { var __auth = MySsAuthUsers.GetAuth(); PG <Ban> vmpg; vmpg = _BanServ.GetQueryPaging(paging, w => w.Quan.UserId == __auth.OwnerId); return(PartialView(vmpg)); }
public PartialViewResult ajax_paging(smartpaging paging) { var __auth = MySsAuthUsers.GetAuth(); PG <Product> vmpg; if (__auth.Username == "admin") { vmpg = _ProductServ.GetQueryPaging(paging); } else { vmpg = _ProductServ.GetQueryPaging(paging, w => w.ProductCat.Quan.UserId == __auth.OwnerId); } return(PartialView(vmpg)); }
public static PG <T> GetPG <T>(this PGQuery <T> query, smartpaging paging) where T : new() { PG <T> vmpg = null; //TOTAL RECORDS int tongdong = query.values.Count(); //PAGING INFORMATION if (paging.tongdongmottrang != -1) { query.values = query.values.Skip(paging.numSkip).Take(paging.tongdongmottrang); } vmpg = new PG <T>(tongdong, paging.tranghientai, paging.tongdongmottrang, paging.fnjs); vmpg.L = query.values.ToList(); return(vmpg); }
public PartialViewResult ajax_paging(smartpaging paging) { var __auth = MySsAuthUsers.GetAuth(); PG <Quan> vmpg; if (__auth.RoleId == 1 && __auth.Username == "admin") { vmpg = _QuanServ.GetQueryPaging(paging); } else { vmpg = _QuanServ.GetQueryPaging(paging, w => w.UserId == __auth.ID); } var user = __db.Users.Find(__auth.ID); ViewBag.QuanDefaultId = user.QuanDefaultId ?? -1; return(PartialView(vmpg)); }