public JsonResult searchData(FormCollection form) { LOAITAILIEU_THUOCTINHBusiness = Get <LOAITAILIEU_THUOCTINHBusiness>(); var searchModel = SessionManager.GetValue("thuoctinhSearch") as TAILIEU_THUOCTINH_SEARCH; if (searchModel == null) { searchModel = new TAILIEU_THUOCTINH_SEARCH(); searchModel.pageSize = 20; } searchModel.LOAI_TAILIEU = form["LOAI_TAILIEU"].ToIntOrZero(); searchModel.TEN_THUOCTINH = form["TEN_THUOCTINH"]; if (!string.IsNullOrEmpty(form["TRANGTHAI"])) { searchModel.TRANGTHAI = form["TRANGTHAI"].Equals("1"); } else { searchModel.TRANGTHAI = null; } SessionManager.SetValue("thuoctinhSearch", searchModel); var data = LOAITAILIEU_THUOCTINHBusiness.GetDaTaByPage(searchModel, 1, searchModel.pageSize); return(Json(data)); }
public PageListResultBO <LOAITAILIEU_THUOCTINH_BO> GetDaTaByPage(TAILIEU_THUOCTINH_SEARCH searchModel, int pageIndex = 1, int pageSize = 20) { var query = from thuoctinh in this.context.LOAITAILIEU_THUOCTINH join danhmuc in this.context.DM_DANHMUC_DATA on thuoctinh.DANHMUC_ID equals danhmuc.ID into group1 from g1 in group1.DefaultIfEmpty() select new LOAITAILIEU_THUOCTINH_BO { ID = thuoctinh.ID, DANHMUC_ID = thuoctinh.DANHMUC_ID, MOTA = thuoctinh.MOTA, TEN_DANHMUC = g1.TEXT, TEN_THUOCTINH = thuoctinh.TEN_THUOCTINH, TRANGTHAI = thuoctinh.TRANGTHAI }; if (searchModel != null) { if (!string.IsNullOrEmpty(searchModel.sortQuery)) { query = query.OrderBy(searchModel.sortQuery); } else { query = query.OrderByDescending(x => x.TEN_DANHMUC); } } else { query = query.OrderByDescending(x => x.TEN_DANHMUC); } var resultmodel = new PageListResultBO <LOAITAILIEU_THUOCTINH_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 getData(int indexPage, string sortQuery, int pageSize) { LOAITAILIEU_THUOCTINHBusiness = Get <LOAITAILIEU_THUOCTINHBusiness>(); var searchModel = SessionManager.GetValue("thuoctinhSearch") as TAILIEU_THUOCTINH_SEARCH; if (!string.IsNullOrEmpty(sortQuery)) { if (searchModel == null) { searchModel = new TAILIEU_THUOCTINH_SEARCH(); } searchModel.sortQuery = sortQuery; if (pageSize > 0) { searchModel.pageSize = pageSize; } SessionManager.SetValue("thuoctinhSearch", searchModel); } var data = LOAITAILIEU_THUOCTINHBusiness.GetDaTaByPage(searchModel, indexPage, pageSize); return(Json(data)); }