/// <summary> /// 获取角色下的用户列表(分页) /// </summary> /// <param name="request"></param> /// <param name="page"></param> /// <param name="rows"></param> /// <returns></returns> public ActionResult GetPagingRoleUsers(GetPagingRoleUsersRequest request, int page, int rows) { var result = string.Empty; if (request == null) { request = new GetPagingRoleUsersRequest(); } request.PageIndex = page; request.PageSize = rows; var rs = _roleService.GetPagingRoleUsers(request); if (rs.ReturnCode == ReturnCodeType.Success) { result = "{\"total\": " + rs.Content.TotalCount + ",\"rows\":" + rs.Content.Entities.ToJson(dateTimeFormat: DateTimeTypeConst.DATETIME) + "}"; } return(Content(result)); }
/// <summary> /// 获取角色下的用户列表(分页) /// </summary> /// <param name="request"></param> /// <returns></returns> public PagingResult <GetPagingRoleUsersResponse> GetPagingRoleUsers(GetPagingRoleUsersRequest request) { PagingResult <GetPagingRoleUsersResponse> result = null; var totalCount = 0; var startIndex = (request.PageIndex - 1) * request.PageSize + 1; var endIndex = request.PageIndex * request.PageSize; using (var conn = DapperHelper.CreateConnection()) { var multi = conn.QueryMultiple(@"--获取指定角色下的所有用户(分页) SELECT rs.* FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY u.created_time DESC ) AS RowNum , u.id , u.user_id AS UserId , u.user_name AS UserName , u.is_change_pwd AS IsChangePwd , u.enable_flag AS EnableFlag , u.created_by AS CreatedBy , u.created_time AS CreatedTime , u.last_updated_by AS LastUpdatedBy , u.last_updated_time AS LastUpdatedTime FROM dbo.t_rights_user AS u LEFT JOIN dbo.t_rights_user_role AS userRole ON u.id = userRole.user_id WHERE userRole.role_id = @RoleId ) AS rs WHERE rs.RowNum BETWEEN @Start AND @End; --获取指定角色下的所有用户total SELECT COUNT(DISTINCT u.id) FROM dbo.t_rights_user AS u LEFT JOIN dbo.t_rights_user_role AS userRole ON u.id = userRole.user_id WHERE userRole.role_id = @RoleId;", new { @RoleId = request.RoleId, @Start = startIndex, @End = endIndex }); var query1 = multi.Read <GetPagingRoleUsersResponse>(); var query2 = multi.Read <int>(); totalCount = query2.First(); result = new PagingResult <GetPagingRoleUsersResponse>(totalCount, request.PageIndex, request.PageSize, query1); } return(result); }
/// <summary> /// 获取角色下的用户列表(分页) /// </summary> /// <param name="request"></param> /// <param name="page"></param> /// <param name="rows"></param> /// <returns></returns> public ActionResult GetPagingRoleUsers(GetPagingRoleUsersRequest request, int page, int rows) { var result = string.Empty; if (request == null) { request = new GetPagingRoleUsersRequest(); } request.PageIndex = page; request.PageSize = rows; using (var factory = new ChannelFactory <IRightsRoleService>("*")) { var client = factory.CreateChannel(); var rs = client.GetPagingRoleUsers(request); if (rs.ReturnCode == ReturnCodeType.Success) { result = "{\"total\": " + rs.Content.TotalCount + ",\"rows\":" + rs.Content.Entities.ToJson(dateTimeFormat: DateTimeTypeConst.DATETIME) + "}"; } } return(Content(result)); }
/// <summary> /// 获取角色下的用户列表(分页) /// </summary> /// <param name="request"></param> /// <returns></returns> public ServiceResult <PagingResult <GetPagingRoleUsersResponse> > GetPagingRoleUsers(GetPagingRoleUsersRequest request) { var result = new ServiceResult <PagingResult <GetPagingRoleUsersResponse> > { ReturnCode = ReturnCodeType.Error, Content = new PagingResult <GetPagingRoleUsersResponse>() }; var rs = _roleDao.GetPagingRoleUsers(request); result.ReturnCode = ReturnCodeType.Success; result.Content = rs; return(result); }