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 PG <Contact> GetQueryPaging(Contact_filter paging = null, Expression <Func <Contact, bool> > where = null) { IQueryable <Contact> query; //PHÂN QUYỀN ĐỒ query = base.GetList(where); if (paging.contactstatusid != -1) { query = query.Where(w => w.ContactStatusId == paging.contactstatusid); } //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 <Contact>(query)).GetPG(paging)); }
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 <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)); }
public PG <DonHang> GetQueryPaging(donhang_sp paging = null, Expression <Func <DonHang, bool> > where = null) { IQueryable <DonHang> query; //PHÂN QUYỀN ĐỒ query = GetList(where); if (paging.quanid != -1) { query = query.Where(w => w.QuanId == paging.quanid); } if (paging.trangthaigiaohangid != -1) { query = query.Where(w => w.TrangThaiGiaoHangId == paging.trangthaigiaohangid); } if (paging.trangthaithanhtoanid != -1) { query = query.Where(w => w.TrangThaiThanhToanId == paging.trangthaithanhtoanid); } if (paging.ban != -1) { query = query.Where(w => w.Ban == paging.ban); } if (paging.loctg) { query = query.Where(e => EntityFunctions.TruncateTime(e.CreatedDate) >= paging.tu && EntityFunctions.TruncateTime(e.CreatedDate) <= EntityFunctions.TruncateTime(paging.den)); } //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; int id_loc = -1; if (int.TryParse(loc1.giatriloc, out id_loc)) { query = query.Where(q => q.Id == id_loc); } } } } PG <DonHang> vmpg = null; //TOTAL RECORDS int tongdong = query.Count(); decimal tongtien = query.Sum(s => (decimal?)s.TongTienHang) ?? 0; //PAGING INFORMATION if (paging.tongdongmottrang != -1) { query = query.Skip(paging.numSkip).Take(paging.tongdongmottrang); } vmpg = new PG <DonHang>(tongdong, paging.tranghientai, paging.tongdongmottrang, paging.fnjs); vmpg.L = query.ToList(); vmpg.TongTien = tongtien; return(vmpg); }