public PageListResultBO <WF_MODULE_BO> GetDaTaByPage(WF_MODULE_SEARCHBO searchModel, int pageIndex = 1, int pageSize = 20) { var query = from tbl in this.context.WF_MODULE //join tblLuong in this.context.WF_STREAM on tbl.WF_STREAM_ID equals tblLuong.ID into jLuong //from luongxuly in jLuong.DefaultIfEmpty() select new WF_MODULE_BO { ID = tbl.ID, MODULE_CODE = tbl.MODULE_CODE, MODULE_TITLE = tbl.MODULE_TITLE, WF_STREAM_ID = tbl.WF_STREAM_ID, create_at = tbl.create_at, create_by = tbl.create_by, edit_at = tbl.edit_at, edit_by = tbl.edit_by, //TenLuong = luongxuly != null ? luongxuly.WF_NAME : "Chưa thiết lập", }; if (searchModel != null) { if (!string.IsNullOrEmpty(searchModel.sortQuery)) { query = query.OrderBy(searchModel.sortQuery); } else { query = query.OrderByDescending(x => x.ID); } } else { query = query.OrderByDescending(x => x.ID); } var resultmodel = new PageListResultBO <WF_MODULE_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 ActionResult Index() { var model = new IndexVM(); WF_MODULEBusiness = Get <WF_MODULEBusiness>(); var WF_STREAMBusiness = Get <WF_STREAMBusiness>(); var searchmodel = new WF_MODULE_SEARCHBO(); SessionManager.SetValue("wfmoduleSearchModel", null); model.LstModule = WF_MODULEBusiness.GetDaTaByPage(null); foreach (var item in model.LstModule.ListItem) { var LstIds = item.WF_STREAM_ID.ToListInt(','); var LstStreams = WF_STREAMBusiness.repository.All().Where(x => LstIds.Contains(x.ID)).ToList(); foreach (var subitem in LstStreams) { item.TenLuong += subitem.WF_NAME + ","; } } return(View(model)); }
public JsonResult getData(int indexPage, string sortQuery, int pageSize) { WF_MODULEBusiness = Get <WF_MODULEBusiness>(); var searchModel = SessionManager.GetValue("wfmoduleSearchModel") as WF_MODULE_SEARCHBO; if (!string.IsNullOrEmpty(sortQuery)) { if (searchModel == null) { searchModel = new WF_MODULE_SEARCHBO(); } searchModel.sortQuery = sortQuery; if (pageSize > 0) { searchModel.pageSize = pageSize; } SessionManager.SetValue("wfmoduleSearchModel", searchModel); } var data = WF_MODULEBusiness.GetDaTaByPage(searchModel, indexPage, pageSize); return(Json(data)); }
public JsonResult searchData(FormCollection form) { WF_MODULEBusiness = Get <WF_MODULEBusiness>(); var searchModel = SessionManager.GetValue("wfmoduleSearchModel") as WF_MODULE_SEARCHBO; if (searchModel == null) { searchModel = new WF_MODULE_SEARCHBO(); searchModel.pageSize = 20; } searchModel.QR_ID = form["QR_ID"].ToIntOrZero(); //searchModel.QR_WF_STREAM_ID = form["QR_WF_STREAM_ID"].ToIntOrZero(); var idToaNha = form["TOANHA_ID"].ToIntOrZero(); searchModel.QR_create_by = form["QR_create_by"].ToLongOrZero(); searchModel.QR_edit_by = form["QR_edit_by"].ToLongOrZero(); searchModel.QR_MODULE_CODE = form["QR_MODULE_CODE"].ToString(); searchModel.QR_MODULE_TITLE = form["QR_MODULE_TITLE"].ToString(); SessionManager.SetValue("wfmoduleSearchModel", searchModel); var data = WF_MODULEBusiness.GetDaTaByPage(searchModel, 1, searchModel.pageSize); return(Json(data)); }