/// <summary>
/// 获取所有角色
/// </summary>
/// <returns></returns>
public async Task <PagedResult <Roles> > GetAllRoles(RolesParameter parameter)
{
string sql = $"select * from (select ROW_NUMBER() OVER(ORDER BY r.RoleID )AS Row,r.* from Roles r where Rolename like @Rolename) rr where rr.Row between @StartIndex AND @EndIndex";
List <Roles> rolesList = await DbHelper.QueryAsync <Roles>(sql, new
{
RoleName = "%" + parameter.RoleName + "%",
StartIndex = parameter.SkipCount,
EndIndex = parameter.TakeCount
});
int totalCount = await DbHelper.QuerySingleAsync <int>("select count(0) from Roles where RoleName like @RoleName ", new { RoleName = "%" + parameter.RoleName + "%" });
return(new PagedResult <Roles>
{
PageIndex = parameter.PageIndex,
PageSize = parameter.PageSize,
TotalItemCount = totalCount,
Items = rolesList
});
}
public async Task <ActionResult> GetAllRoles(RolesParameter parameter)
{
PagedResult <WYJK.Entity.Roles> rolesList = await _userService.GetAllRoles(parameter);
return(View(rolesList));
}
