/// <summary>
/// 删除角色
/// </summary>
/// <param name="entity"></param>
public void DeleteRole(RoleEntity entity)
{
var param = new DynamicParameters();
param.Add("@roleID", entity.ID);
using (var conn = SessionFactory.CreateConnection())
{
QuickRepository.ExecuteProc(conn, "pr_sys_RoleDelete", param);
}
}
public ResponseResult DeleteRole(RoleEntity entity)
{
var result = ResponseResult.Default();
try
{
var roleService = new RoleDataService();
roleService.DeleteRole(entity);
result = ResponseResult.Success();
}
catch (System.Exception ex)
{
result = ResponseResult.Error(string.Format("删除角色数据失败!{0}", ex.Message));
}
return result;
}
/// <summary>
/// 根据角色查询用户
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public IList<RoleUserView> QueryUserByRole(RoleEntity query)
{
var strSQL = @"SELECT
ID,
RoleID,
RoleName,
RoleCode,
UserID,
UserName
FROM vw_SysRoleUserView
WHERE RoleID=@roleID
ORDER BY RoleID";
var list = QuickRepository.Query<RoleUserView>(strSQL, new { roleID = query.ID }).ToList();
return list;
}
