/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public static DbDataReader Select(RoleAuthorizationEntity entity, DbConnection connection, DbTransaction transaction)
{
var reader = KandaTableDataGateway._factory.CreateReader(connection, transaction);
reader.CommandText = @"usp_SelectRoleAuthorizations";
KandaDbDataMapper.MapToParameters(reader, entity);
reader.ExecuteReader();
return(reader);
}
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public static int Insert(RoleAuthorizationEntity entity, DbConnection connection, DbTransaction transaction)
{
var command = KandaTableDataGateway._factory.CreateCommand(connection, transaction);
command.CommandText = @"usp_InsertRoleAuthorizations";
KandaDbDataMapper.MapToParameters(command, entity);
var result = KandaTableDataGateway._factory.CreateParameter(@"Result", DbType.Int32, sizeof(int), ParameterDirection.ReturnValue, DBNull.Value);
command.Parameters.Add(result);
command.ExecuteNonQuery();
return((int)result.Value);
}
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public IEnumerable <RoleAuthorizationEntity> Get(RoleAuthorizationEntity entity, DbConnection connection, DbTransaction transaction)
{
var reader = default(DbDataReader);
try
{
reader = RoleAuthorizationsGateway.Select(entity, connection, transaction);
var entities = KandaDbDataMapper.MapToEnumerable <RoleAuthorizationEntity>(reader);
return(entities);
}
finally
{
if (reader != null)
{
reader.Close();
}
}
}
/// <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);
}
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public bool Create(RoleAuthorizationEntity entity, DbConnection connection, DbTransaction transaction)
{
var created = RoleAuthorizationsGateway.Insert(entity, connection, transaction);
return(created == 1);
}
/// <summary>
///
/// </summary>
/// <param name="entity"></param>
/// <param name="connection"></param>
/// <param name="transaction"></param>
/// <returns></returns>
public bool Update(RoleAuthorizationEntity entity, DbConnection connection, DbTransaction transaction)
{
var updated = RoleAuthorizationsGateway.Update(entity, connection, transaction);
return(updated == 1);
}
