public partial class frmAdmonSaldos : Form
{
private OracleConnection conexionOracle;
public frmAdmonSaldos(OracleConnection conexionOracle, string tbcampoConsulta)
{
InitializeComponent();
this.conexionOracle = conexionOracle;
this.tbcampoConsulta = tbcampoConsulta;
}
private void frmAdmonSaldos_Load(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(tbcampoConsulta))
{
Cursor.Current = Cursors.WaitCursor;
dataGridView1
.DataSource = new listarFacturasAdmin
(conexionOracle, tbcampoConsulta
); dataGridView1.AutoResizeColumns();
}
else throw new Excepcion
("Número de recibo no puede ser nulo"); }
catch (Excepcion ex)
{
MessageBox.Show(ex.reporteExcepcion(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public DataTable listarFacturasAdmin(string tbcampoConsulta)
{
DataTable dt
= new DataTable
(); OracleDataAdapter adaptador
= new OracleDataAdapter
(); try
{
using (OracleCommand consulta = conexionOracle.CreateCommand())
{
consulta.CommandText=(@"Select r.invoice_id as Factura,total_amount as Valor,total_amount-paid_amount as Saldo,
null as AdminSaldo,null as CodAmin
From receivable r, cash_receipt_line cl, cash_receipt cs
Where cs.check_id=:tbcampoConsulta and r.invoice_id=cl.invoice_id and cs.check_id=cl.check_id
and total_amount-paid_amount !=0");
consulta
.Parameters.Add(new OracleParameter
(":tbcampoConsulta", OracleType
.Char)).Value = tbcampoConsulta
; adaptador.SelectCommand = consulta;
adaptador.Fill(dt);
}
}
catch (Exception ex)
{
throw e;
}
return dt;
}
public DataTable listarFacturasAdmin(OracleConnection conexionOracle, string tbcampoConsulta)
{
return new AdminSaldoAD
(conexionOracle
).listarFacturasAdmin(tbcampoConsulta
); }