/// <summary>
/// 根据角色编号获取用户列表
/// </summary>
/// <param name="entity">角色用户搜索实体</param>
/// <returns>PageDataModel<Role2UserEntity></returns>
public Task <BasePagedListModel <Role2UserEntity> > GetListByRoleIdAsync(RoleUserSearchParam param)
{
if (param == null)
{
throw new ArgumentNullException(nameof(param));
}
return(roleUserRepository.GetListByRoleIdAsync(param));
}
public async Task <IActionResult> GetCanAddUser(RoleUserSearchParam param)
{
BasePagedListModel <UserEntity> pageDataModel = await userService.GetCanUserListByRoleIdAsync(param);
var data = new
{
total = pageDataModel.Total,
rows = pageDataModel.Data
};
return(Json(data));
}
/// <summary>
/// 根据角色编号获取用户列表
/// </summary>
/// <param name="param">角色用户搜索实体</param>
/// <returns>PageDataModel<Role2UserEntity></returns>
public async Task <BasePagedListModel <Role2UserEntity> > GetListByRoleIdAsync(RoleUserSearchParam param)
{
BasePagedListModel <Role2UserEntity> list = new BasePagedListModel <Role2UserEntity>();
try
{
#region 条件与排序
StringBuilder condition = new StringBuilder();
condition.AppendFormat("R_ID={0}", param.RoleId);
if (param.Name.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND U_NAME='{0}'", param.Name.FilterSql());
}
if (param.RealName.IsNotNullOrEmpty())
{
condition.AppendFormat(" AND U_REALNAME='{0}'", param.RealName.FilterSql());
}
#endregion
PageCriteriaModel criteria = new PageCriteriaModel();
criteria.Condition = condition.ToString();
criteria.PageIndex = param.PageIndex;
criteria.Fields = "*";
criteria.PageSize = param.PageSize;
criteria.TableName = "vw_S_ROLEUSER";
criteria.PrimaryKey = "U_ID";
if (param.SortName.IsNotNullOrEmpty() && param.SortOrder.IsNotNullOrEmpty())
{
criteria.Sort = $"{param.SortName.FilterSql()} {param.SortOrder.FilterSql()}";
}
list = await pageListRepository.GetPageDataAsync <Role2UserEntity>(connectionProvider, criteria);
}
catch (ArgumentNullException ex)
{
logger.LogError("调用方法GetListByRoleIdAsync(RoleUserSearchParam param)发生ArgumentNullException，异常信息：{0}", ex);
}
catch (SqlException ex)
{
logger.LogError("调用方法GetListByRoleIdAsync(RoleUserSearchParam param)发生SqlException，异常信息：{0}", ex);
}
catch (Exception ex)
{
logger.LogError("调用方法GetListByRoleIdAsync(RoleUserSearchParam param)发生Exception，异常信息：{0}", ex);
}
return(list);
}
