private void Button1_Click(object sender, EventArgs e)
{
Settings stgs = new Settings();
stgs.Reload();
if (string.IsNullOrEmpty(stgs.RutaSAE))
{
MessageBox.Show("Falta la ruta de datos");
}
else
{
FireBird datos = new FireBird();
(datos.CadenaConn as FbConnectionStringBuilder).Database =
new Settings().RutaSAE;
string sql = "select * From inve01 order by cve_art asc";
DataSet datset = datos.LeeDatos(sql);
AddColumns(datset.Tables[0]);
dataGridViewCnst.DataSource = datset.Tables[0];
dataGridViewCnst.AutoGenerateColumns = true;
/*
* if (datos.PruebaConexion())
* MessageBox.Show("bien");*/
}
}
void Button2Click(object sender, EventArgs e)
{
Settings stgs = new Settings();
stgs.Reload();
if (string.IsNullOrEmpty(stgs.RutaSAE))
{
MessageBox.Show("Falta la ruta de datos");
}
else
{
FireBird datos = new FireBird();
(datos.CadenaConn as FbConnectionStringBuilder).Database =
new Settings().RutaSAE;
string fchIni = dateTimePicker1.Value.ToString("MM/dd/yyyy");
string fchFin = dateTimePicker2.Value.ToString("MM/dd/yyyy");
string sql = "select factf01.cve_clpv" +
", clie01.nombre" +
", factf01.cve_vend" +
", infenvio01.calle as DatEnvio " +
", factf01.cve_doc" +
", factf01.fecha_doc" +
", factf01.can_tot as Importe" +
", factf01.imp_tot1" +
", factf01.imp_tot2" +
", factf01.imp_tot3" +
", factf01.imp_tot4" +
", (factf01.can_tot + factf01.imp_tot1 + factf01.imp_tot2 + " +
"factf01.imp_tot3 + factf01.imp_tot4) as Total " +
" From factf01" +
" left join clie01 on clie01.clave = factf01.cve_clpv" +
" left join infenvio01 on infenvio01.cve_info = factf01.dat_envio " +
" Where trim(factf01.cve_clpv) between '1' and 'MOSTR' And " +
" trim(factf01.cve_vend) between '1' And '99999' And " +
" factf01.fecha_doc between '" + fchIni + "' And '" + fchFin +
"' And factf01.status <> 'C'";
DataSet datset = datos.LeeDatos(sql);
dataGridView1.DataSource = datset.Tables[0];
dataGridView1.AutoGenerateColumns = true;
}
}
