public ActionResult Index(int id) { DM_THAOTACBusiness = Get <DM_THAOTACBusiness>(); DM_CHUCNANGBusiness = Get <DM_CHUCNANGBusiness>(); var searchmodel = new DM_THAOTAC_SEARCHBO(); SessionManager.SetValue("dmthaotacSearchModel", null); var data = new IndexVM(); data.ListThaoTac = DM_THAOTACBusiness.GetDaTaByPage(id, null); data.ChucNang = DM_CHUCNANGBusiness.Find(id); return(View(data)); }
public JsonResult searchData(FormCollection form) { DM_THAOTACBusiness = Get <DM_THAOTACBusiness>(); var searchModel = SessionManager.GetValue("dmthaotacSearchModel") as DM_THAOTAC_SEARCHBO; if (searchModel == null) { searchModel = new DM_THAOTAC_SEARCHBO(); searchModel.pageSize = 20; } searchModel.QR_MA = form["QR_MA"]; searchModel.QR_THAOTAC = form["QR_THAOTAC"]; searchModel.QR_CHUCNANGID = form["QR_ID"].ToIntOrZero(); SessionManager.SetValue("dmthaotacSearchModel", searchModel); var data = DM_THAOTACBusiness.GetDaTaByPage(searchModel.QR_CHUCNANGID, searchModel, 1, searchModel.pageSize); return(Json(data)); }
public JsonResult getData(int indexPage, string sortQuery, int pageSize, int idchucnang) { DM_THAOTACBusiness = Get <DM_THAOTACBusiness>(); var searchModel = SessionManager.GetValue("dmthaotacSearchModel") as DM_THAOTAC_SEARCHBO; if (!string.IsNullOrEmpty(sortQuery)) { if (searchModel == null) { searchModel = new DM_THAOTAC_SEARCHBO(); } searchModel.sortQuery = sortQuery; if (pageSize > 0) { searchModel.pageSize = pageSize; } SessionManager.SetValue("dmthaotacSearchModel", searchModel); } var data = DM_THAOTACBusiness.GetDaTaByPage(idchucnang, searchModel, indexPage, pageSize); return(Json(data)); }
public PageListResultBO <DM_THAOTAC_BO> GetDaTaByPage(int idchucnang, DM_THAOTAC_SEARCHBO searchModel, int pageIndex = 1, int pageSize = 20) { var query = from tbl in this.context.DM_THAOTAC.Where(x => x.DM_CHUCNANG_ID == idchucnang) select new DM_THAOTAC_BO { DM_THAOTAC_ID = tbl.DM_THAOTAC_ID, MA_THAOTAC = tbl.MA_THAOTAC, TEN_THAOTAC = tbl.TEN_THAOTAC, TRANGTHAI = tbl.TRANGTHAI, NGAYTAO = tbl.NGAYTAO, NGAYSUA = tbl.NGAYSUA, DM_CHUCNANG_ID = tbl.DM_CHUCNANG_ID, NGUOITAO = tbl.NGUOITAO, NGUOISUA = tbl.NGUOISUA, MENU_LINK = tbl.MENU_LINK, TT_HIENTHI = tbl.TT_HIENTHI, IS_HIENTHI = tbl.IS_HIENTHI, ICONPATH = tbl.ICONPATH, CSSCLASS = tbl.CSSCLASS, }; if (searchModel != null) { if (!string.IsNullOrEmpty(searchModel.QR_MA)) { query = query.Where(x => x.MA_THAOTAC.Contains(searchModel.QR_MA)); } if (!string.IsNullOrEmpty(searchModel.QR_THAOTAC)) { query = query.Where(x => x.TEN_THAOTAC.Contains(searchModel.QR_THAOTAC)); } if (!string.IsNullOrEmpty(searchModel.sortQuery)) { query = query.OrderBy(searchModel.sortQuery); } else { query = query.OrderByDescending(x => x.DM_THAOTAC_ID); } } else { query = query.OrderByDescending(x => x.DM_THAOTAC_ID); } var resultmodel = new PageListResultBO <DM_THAOTAC_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); }