public void RetornaArrayList(ref SqlCommand cmd, ref ArrayList Array)
{
this.Open();
cmd.Connection = _Conexao;
SqlDataReader dr;
try
{
dr = cmd.ExecuteReader();
while (dr.Read())
{
Array.Add(dr[0].ToString());
}
dr.Close();
}
catch (Exception ex)
{
//throw new Exception(ex.ToString());
Gerais.Enviar_Email_Para_Administradores("SGQ - ALM - EXCEPTION - RetornaArrayList " + cmd.CommandText, ex.ToString());
}
finally
{
cmd.Dispose();
this.Close();
}
}
public void RetornaString(ref SqlCommand cmd, ref string returnString)
{
this.Open();
cmd.Connection = _Conexao;
SqlDataReader dr;
try
{
dr = cmd.ExecuteReader();
if (dr.Read())
{
returnString = dr[0].ToString();
}
dr.Close();
}
catch (Exception ex)
{
//throw new Exception(ex.ToString());
Gerais.Enviar_Email_Para_Administradores("SGQ - ALM - EXCEPTION - RetornaString: ", "SQL:\n\n" + cmd.CommandText + "\n\n\nMensagem:\n\n" + ex.ToString());
}
finally
{
cmd.Dispose();
this.Close();
}
}
public void RetornaDataTable(ref SqlCommand cmd, ref DataTable returnDataTable)
{
this.Open();
cmd.Connection = _Conexao;
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
da.Fill(returnDataTable);
}
catch (Exception ex)
{
//throw new Exception(ex.ToString());
Gerais.Enviar_Email_Para_Administradores("SGQ - ALM - EXCEPTION - RetornaDataTable " + cmd.CommandText, ex.ToString());
}
finally
{
cmd.Dispose();
da.Dispose();
this.Close();
}
}
public int ExecuteNonQuery(string cmdText, CommandType cmdType, params IDbDataParameter[] parameters)
{
int Retorno = 0;
IDbCommand cmd = CriarComando(cmdText, cmdType, parameters);
try
{
Retorno = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Retorno = -1;
//throw new Exception(ex.ToString());
Gerais.Enviar_Email_Para_Administradores("SGQ - ALM - EXCEPTION - ExecuteNonQuery ", ex.ToString().Replace("\n", "<br />") + "<br /><br />" + cmdText.Replace("\n", "<br />"));
}
finally
{
cmd.Dispose();
this.Close();
}
return(Retorno);
}
public int Executar(SqlCommand cmd)
{
int retorno = 0;
cmd.CommandType = CommandType.Text;
cmd.Connection = this.connection;
cmd.CommandTimeout = 0;
try
{
if (this.connection.State != ConnectionState.Open)
{
this.connection.Open();
}
cmd.ExecuteNonQuery();
}
catch (Exception oEX)
{
retorno = -1;
Gerais.Enviar_Email_Para_Administradores("SGQ - Executar - EXCEPTION - ", oEX.ToString().Replace("\n", "<br />") + "<br /><br />" + cmd.CommandText.Replace("\n", "<br />"));
}
return(retorno);
}
