public JsonResult getData(int indexPage, string sortQuery, int pageSize) { QuanLyHoSoBusiness = Get <QuanLyHoSoBusiness>(); var searchModel = SessionManager.GetValue("HoSoSearchModel") as QuanLyHoSoSearchModel; if (!string.IsNullOrEmpty(sortQuery)) { if (searchModel == null) { searchModel = new QuanLyHoSoSearchModel(); } searchModel.sortQuery = sortQuery; if (pageSize > 0) { searchModel.pageSize = pageSize; } SessionManager.SetValue("HoSoSearchModel", searchModel); } var data = QuanLyHoSoBusiness.GetPage(searchModel, indexPage, pageSize); return(Json(data)); }
public JsonResult searchData(FormCollection form) { QuanLyHoSoBusiness = Get <QuanLyHoSoBusiness>(); var searchModel = SessionManager.GetValue("HoSoSearchModel") as QuanLyHoSoSearchModel; if (searchModel == null) { searchModel = new QuanLyHoSoSearchModel(); searchModel.pageSize = 20; } searchModel.HoSoNam = form["HOSO_NAM"].ToIntOrZero(); searchModel.NamChinhLy = form["NAM_CHINHLY"].ToIntOrZero(); searchModel.KhoId = form["KHO_ID"].ToIntOrZero(); searchModel.PhongId = form["PHONG_ID"].ToIntOrZero(); searchModel.FTS = form["FTS"]; SessionManager.SetValue("HoSoSearchModel", searchModel); var data = QuanLyHoSoBusiness.GetPage(searchModel, 1, searchModel.pageSize); return(Json(data)); }
public PageListResultBO <VanBanPageListBO> GetPageForVanBan(QuanLyHoSoSearchModel searchModel, int pageNumber, int pageSize) { IQueryable <VanBanPageListBO> query = ( from hs in this.context.QUANLY_HOSO orderby hs.TIEUDE select new VanBanPageListBO { DONVI_ID = hs.DONVI_ID, HOSO_ID = hs.ID, HOSO_NAME = hs.TIEUDE, HOSO_NAM = hs.HOSO_NAM, NAM_CHINH_LY = hs.NAM_CHINHLY, KHO_ID = hs.KHO_ID, PHONG_ID = hs.PHONG_ID, FTS = hs.FTS }); if (searchModel != null) { if (searchModel.HoSoNam > 0) { query = query.Where(x => x.HOSO_NAM == searchModel.HoSoNam); } if (searchModel.NamChinhLy > 0) { query = query.Where(x => x.NAM_CHINH_LY == searchModel.NamChinhLy); } if (searchModel.KhoId > 0) { query = query.Where(x => x.KHO_ID == searchModel.KhoId); } if (searchModel.PhongId > 0) { query = query.Where(x => x.PHONG_ID == searchModel.PhongId); } if (!string.IsNullOrEmpty(searchModel.FTS)) { searchModel.FTS = searchModel.FTS.ConvertToVN(); query = query.Where(x => x.FTS.Contains(searchModel.FTS)); } if (!string.IsNullOrEmpty(searchModel.sortQuery)) { query = query.OrderBy(searchModel.sortQuery); } else { query = query.OrderByDescending(x => x.HOSO_ID); } } var resultModel = new PageListResultBO <VanBanPageListBO>(); var dataPageList = query.ToPagedList(pageNumber, pageSize); var listHoSo = dataPageList.ToList(); resultModel.Count = dataPageList.TotalItemCount; resultModel.TotalPage = dataPageList.PageCount; var listHoSoID = listHoSo.Select(x => x.HOSO_ID).ToList(); var total = query.Count(); var listVanBan = new QuanLyVanBanBusiness(new UnitOfWork()).GetByListHoSo(listHoSoID); //Lấy list van ban foreach (var item in listHoSo) { var sourceVB = listVanBan.Where(x => x.HOSO_ID == item.HOSO_ID).ToList(); //item.ListVanBan = sourceVB; item.TotalVanBan = sourceVB.Count; } resultModel.ListItem = listHoSo; return(resultModel); }
public PageListResultBO <QuanLyHoSoBO> GetPage(QuanLyHoSoSearchModel searchModel, int pageNumber, int pageSize) { IQueryable <QuanLyHoSoBO> query = ( from hs in this.context.QUANLY_HOSO join phong in this.context.DM_DANHMUC_DATA on hs.PHONG_ID equals(int) phong.ID into group1 from gPhong in group1.DefaultIfEmpty() join nguoidung in this.context.DM_NGUOIDUNG on hs.NGUOITAO equals nguoidung.ID into group2 from gNguoiDung in group2.DefaultIfEmpty() join kho in this.context.DM_DANHMUC_DATA on hs.KHO_ID equals(int) kho.ID into group3 from gKho in group3.DefaultIfEmpty() orderby hs.TIEUDE select new QuanLyHoSoBO { DONVI_ID = hs.DONVI_ID, ID = hs.ID, TIEUDE = hs.TIEUDE, HOSO_NAM = hs.HOSO_NAM, NAM_CHINHLY = hs.NAM_CHINHLY, KHO_ID = hs.KHO_ID, PHONG_ID = hs.PHONG_ID, FTS = hs.FTS, THOIGIAN_TAILIEU = hs.THOIGIAN_TAILIEU, CHUGIAI = hs.CHUGIAI, THOIHAN_BAOQUAN_ID = hs.THOIHAN_BAOQUAN_ID, HOPSO = hs.HOPSO, HOSO_SO = hs.HOSO_SO, MUCDO_TRUYCAP = hs.MUCDO_TRUYCAP, MUCLUC_SO = hs.MUCLUC_SO, NGAYTAO = hs.NGAYTAO, NGUOITAO = hs.NGUOITAO, PHONGSO = hs.PHONGSO, SOLUONG_TO = hs.SOLUONG_TO, TEN_KHO = gKho.TEXT, TEN_NGUOITAO = gNguoiDung.HOTEN, TEN_PHONG = gPhong.TEXT, TRANGTHAI = hs.TRANGTHAI }); if (searchModel != null) { if (searchModel.HoSoNam > 0) { query = query.Where(x => x.HOSO_NAM == searchModel.HoSoNam); } if (searchModel.NamChinhLy > 0) { query = query.Where(x => x.NAM_CHINHLY == searchModel.NamChinhLy); } if (searchModel.KhoId > 0) { query = query.Where(x => x.KHO_ID == searchModel.KhoId); } if (searchModel.PhongId > 0) { query = query.Where(x => x.PHONG_ID == searchModel.PhongId); } if (!string.IsNullOrEmpty(searchModel.FTS)) { searchModel.FTS = searchModel.FTS.ConvertToVN(); query = query.Where(x => x.FTS.Contains(searchModel.FTS)); } if (!string.IsNullOrEmpty(searchModel.sortQuery)) { query = query.OrderBy(searchModel.sortQuery); } else { query = query.OrderByDescending(x => x.ID); } } var resultModel = new PageListResultBO <QuanLyHoSoBO>(); var dataPageList = query.ToPagedList(pageNumber, pageSize); var listHoSo = dataPageList.ToList(); #region lấy count văn bản var vanBanBusiness = new QuanLyVanBanBusiness(new UnitOfWork()); foreach (var item in listHoSo) { item.CountVanBan = vanBanBusiness.repository.All().Where(x => x.HOSO_ID == item.ID).Count(); } #endregion resultModel.Count = dataPageList.TotalItemCount; resultModel.ListItem = listHoSo; resultModel.TotalPage = dataPageList.PageCount; return(resultModel); }