public PageListResultBO <QL_PHONG_BO> GetDaTaByPage(int?depid, QLPHONGHOP_SEARCHBO searchModel, int pageSize = 20, int pageIndex = 1) { var query = from tblPhong in this.context.QL_PHONGHOP where tblPhong.DEPID == depid select new QL_PHONG_BO { ID = tblPhong.ID, TENPHONG = tblPhong.TENPHONG, MOTA = tblPhong.MOTA, MAPHONG = tblPhong.MAPHONG, DEPID = tblPhong.DEPID, SOCHONGOI = tblPhong.SOCHONGOI, }; if (searchModel != null) { if (!string.IsNullOrEmpty(searchModel.TenPhong)) { query = query.Where(a => a.TENPHONG.Contains(searchModel.TenPhong)); } if (!string.IsNullOrEmpty(searchModel.MaPhong)) { query = query.Where(a => a.MAPHONG.Contains(searchModel.MaPhong)); } //Lọc tìm kiếm if (!string.IsNullOrEmpty(searchModel.sortQuery)) { query = query.OrderBy(searchModel.sortQuery); } else { query = query.OrderByDescending(a => a.ID); } } else { query = query.OrderByDescending(a => a.ID); } //Gán nội dung trả về var resultmodel = new PageListResultBO <QL_PHONG_BO>(); if (pageSize == -1) { var dataPageList = query.ToList(); resultmodel.Count = dataPageList.Count; resultmodel.TotalPage = 1; resultmodel.ListItem = dataPageList; } else { var dataPageList = query.ToPagedList(pageIndex, pageSize); resultmodel.Count = dataPageList.TotalItemCount; resultmodel.TotalPage = dataPageList.PageCount; resultmodel.ListItem = dataPageList.ToList(); } return(resultmodel); }
public JsonResult searchData(FormCollection form) { AssignUserInfo(); QL_PHONGHOPBusiness = Get <QL_PHONGHOPBusiness>(); var searchModel = SessionManager.GetValue("TimKiemPhong") as QLPHONGHOP_SEARCHBO; if (searchModel == null) { searchModel = new QLPHONGHOP_SEARCHBO(); searchModel.pageSize = 20; } searchModel.TenPhong = form["sea_TenPhong"]; searchModel.MaPhong = form["sea_MaPhong"];; SessionManager.SetValue("TimKiemPhong", searchModel); var data = QL_PHONGHOPBusiness.GetDaTaByPage(currentUser.DeptParentID, searchModel, searchModel.pageSize, 1); return(Json(data)); }
public JsonResult getData(int indexPage, string sortQuery, int pageSize) { AssignUserInfo(); QL_PHONGHOPBusiness = Get <QL_PHONGHOPBusiness>(); var searchModel = SessionManager.GetValue("TimKiemPhong") as QLPHONGHOP_SEARCHBO; if (!string.IsNullOrEmpty(sortQuery)) { if (searchModel == null) { searchModel = new QLPHONGHOP_SEARCHBO(); } searchModel.sortQuery = sortQuery; if (pageSize > 0) { searchModel.pageSize = pageSize; } SessionManager.SetValue("TimKiemPhong", searchModel); } var data = QL_PHONGHOPBusiness.GetDaTaByPage(currentUser.DeptParentID, searchModel, pageSize, indexPage); return(Json(data)); }