protected ArrayList SelecionarPorNomeQuery(string nomeQuery, Hashtable parametros, DataAccess.RecuperaObjetoDelegate recuperaFunction)
{
ArrayList result = new ArrayList();
DbCommand command = null;
IDataReader dr = null;
try
{
if ((nomeQuery == null) | (nomeQuery.Trim().Length == 0))
{
throw new ArgumentNullException("nomeQuery", "Argumento n\x00e3o pode ser nulo ou vazio.");
}
String queryString = GerenciadorDoArquivoDeQueries.Instancia.ObterQuery(nomeQuery);
// var database = DatabaseFactory.CreateDatabase();
command = CommandFactory.GetCommand(database, queryString);
MapeamentoParametrosSQLServer mapper = new MapeamentoParametrosSQLServer();
mapper.SubstituiParametrosQueriesList(command, parametros);
dr = database.ExecuteReader(command);
var sqlDataReader = ((RefCountingDataReader)dr).InnerReader as MySqlDataReader;
while (dr.Read())
{
Object obj = recuperaFunction(sqlDataReader);
result.Add(RuntimeHelpers.GetObjectValue(obj));
}
return(result);
}
catch (Exception ex)
{
throw ex;
}
finally
{
bool flag = dr != null;
if (flag)
{
dr.Close();
dr.Dispose();
}
flag = (command != null);
if (flag)
{
command.Dispose();
}
}
}
protected ArrayList SelecionarFiltradoPorNomeQuery(string nomeQuery, Hashtable parametros, bool comPaginacao, DataAccess.RecuperaObjetoDelegate recuperaFunction)
{
if (comPaginacao)
{
return(SelecionarPaginadoPorNomeQuery(nomeQuery, parametros, recuperaFunction));
}
else
{
return(SelecionarPorNomeQuery(nomeQuery, parametros, recuperaFunction));
}
}
