public void UpdateAuthorizationListByRoleId(RoleAuthorizationRelation roleAuthorizationRelation)
{
if (roleAuthorizationRelation == null)
{
return;
}
List <SqlExpression> list = new List <SqlExpression>();
List <CommandParameter> list2 = new List <CommandParameter>();
list2.Add(new CommandParameter("@role", roleAuthorizationRelation.Role));
SqlExpression sqlExpression = new SqlExpression
{
Sql = "DELETE FROM [RoleAuthorization] WHERE [Role] = @role"
};
sqlExpression.ParameterList = this._dataBase.CommandParameterToSqlParameter(list2);
list.Add(sqlExpression);
foreach (Authorization current in roleAuthorizationRelation.AuthorizationList)
{
list.Add(RelationalMappingUnity.GetSqlExpression(new RoleAuthorization
{
Domain = roleAuthorizationRelation.Domain,
Role = roleAuthorizationRelation.Role,
AuthorizationKey = current.Key
}, SqlExpressionType.Insert));
}
this._dataBase.ExcuteSqlExpression(list);
}
public ActionResult UpdateAuthorizationListByRoleId()
{
RoleAuthorizationRelation roleAuthorizationRelation = RequestArgs <RoleAuthorizationRelation>();
if (roleAuthorizationRelation == null)
{
return(RespondResult(false, "参数无效。"));
}
roleAuthorizationRelation.Domain = UserContext.Domain.Id;
_settingsManager.UpdateAuthorizationListByRoleId(roleAuthorizationRelation);
return(RespondResult());
}
/// <summary>
/// 更新指定角色的权限集合
/// </summary>
/// <param name="roleAuthorizationRelation"></param>
public void UpdateAuthorizationListByRoleId(RoleAuthorizationRelation roleAuthorizationRelation)
{
if (roleAuthorizationRelation == null)
{
Debug.Assert(false, "authorizationWrapper 为空");
return;
}
List <SqlExpression> sqlList = new List <SqlExpression>();
List <CommandParameter> parameterList = new List <CommandParameter>();
parameterList.Add(new CommandParameter("@role", roleAuthorizationRelation.Role));
SqlExpression deleteSql = new SqlExpression()
{
Sql = "DELETE FROM [RoleAuthorization] WHERE [Role] = @role"
};
deleteSql.ParameterList = _dataBase.CommandParameterToSqlParameter(parameterList);
sqlList.Add(deleteSql);
foreach (var item in roleAuthorizationRelation.AuthorizationList)
{
RoleAuthorizationEntity roleAuthorizationr = new RoleAuthorizationEntity();
roleAuthorizationr.Domain = roleAuthorizationRelation.Domain;
roleAuthorizationr.Role = roleAuthorizationRelation.Role;
roleAuthorizationr.AuthorizationKey = item.Key;
sqlList.Add(RelationalMappingUnity.GetSqlExpression(
roleAuthorizationr, SqlExpressionType.Insert));
}
_dataBase.ExcuteSqlExpression(sqlList);
}
