public PagingObject <Security_Role> Search(SearchRoleModel search, int pageIndex, int pageSize) { var query = db.From <Security_Role>(); int limit = 0; if (pageIndex == 0 || pageIndex < pageSize) { limit = 0; } else { limit = (pageIndex / pageSize); } if (!string.IsNullOrEmpty(search.Name)) { query.Where(x => x.RoleName.ToLower().Contains(search.Name.ToLower())); } return(_roleManagementRepository.Paging(query, limit, pageSize)); }
public async Task <IActionResult> QueryRoleUsers([FromForm] SearchRoleModel search) { JsonQTable ret; if (search == null || string.IsNullOrEmpty(search.roleCode)) { ret = new JsonQTable(); ret.error = "角色代码不能为空"; return(Json(ret)); } PageView page = new PageView(); page.PageIndex = search.page - 1; page.PageSize = search.rp; page.SortName = search.sortname; page.SortOrder = search.sortorder; PagedList <IUserInfo> list = await _service.QueryRoleUsers(search.roleCode, search.queryText, page); ret = JsonQTable.ConvertFromPagedList(list, search.colkey, search.colsArray); return(Json(ret)); }
public ActionResult GetData(SearchRoleModel search, int pageIndex, int pageSize) { if (!CheckAuthorizer.Authorize(Permission.VIEW)) { return(RedirectToAction("Index", "Login")); } try { var data = _roleManagementService.Search(search, pageIndex, pageSize); var total = data.Total; return(Json(new { data = data.DataList, total }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { _log.Error("GetData RoleManagement error : " + ex); return(null); } }