string strErrMsg; // mensagens de erro
#endregion Fields
#region Methods
public static Fornecedor GetFornecedor(int id)
{
OracleDataReader dr;
OracleConnection conn = Conexao.GetInstance();
OracleCommand cmd = new OracleCommand();
cmd.CommandText = "SELECT ID_FORNECEDOR, NOME_FORNECEDOR FROM TBL_FORNECEDOR " +
"WHERE ID_FORNECEDOR = :Id";
cmd.Parameters.Add(":Id", OracleDbType.Int32).Value = id;
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
dr = cmd.ExecuteReader();
Fornecedor fornecedor = new Fornecedor();
if (dr.Read())
{
try
{
fornecedor = new Fornecedor();
fornecedor.Id = Convert.ToInt32(dr["ID_FORNECEDOR"]);
fornecedor.Nome = dr.GetString(1);
}
catch (Exception)
{
}
}
//conn.Close();
return fornecedor;
}
public static ArrayList GetFornecedores()
{
OracleDataReader dr;
OracleConnection conn = Conexao.GetInstance();
ArrayList array = new ArrayList();
OracleCommand cmd = new OracleCommand();
cmd.CommandText = "SELECT ID_FORNECEDOR, NOME_FORNECEDOR FROM TBL_FORNECEDOR ";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
dr = cmd.ExecuteReader();
Fornecedor p;
while (dr.Read())
{
try
{
p = new Fornecedor();
p.Id = Convert.ToInt32(dr["ID_FORNECEDOR"]);
p.Nome = dr.GetString(1);
array.Add(p);
}
catch (Exception)
{
}
}
conn.Close();
return array;
}
public Compras()
{
this.Fornecedor = new Fornecedor();
this.Item = new LinkedList<ItemCompra>();
}
