private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
deshabilitar();
limpiar();
frmBuscaEmpresas frm = new frmBuscaEmpresas();
frm.ShowDialog();
Empresas u = frm.u;
if (u != null)
{
lblId.Text = Convert.ToString(u.Idempresas);
txtEmpresas.Text = u.Empresa;
txtDomicilio.Text = u.Direccion;
txtLocalidad.Text = u.Localidad;
txtTelefono.Text = u.Telefono;
txtTelefono2.Text = u.Telefono2;
txtCelular.Text = u.Celular;
txtComentarios.Text = u.Comentario;
txtMail.Text = u.Mail;
}
}
catch (Exception ex)
{
MessageBox.Show("Error al Buscar: " + ex.Message);
}
}
private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
frmBuscaEmpresas frm = new frmBuscaEmpresas();
frm.ShowDialog();
u = frm.u;
if (u != null)
{
txtEmpresas.Text = u.Empresa;
Acceso_BD oacceso = new Acceso_BD();
DataTable dt = oacceso.leerDatos("select (sum(DEBE)-sum(HABER)) as saldo, f.fletero from ctactefleteros c inner join fleteros f on c.idfleteros = f.idfleteros where c.idempresas = '" + u.Idempresas + "' group by fletero");
int x = 0;
dataGridView1.Rows.Clear();
if (dt.Rows.Count > 0)
{
dataGridView1.Rows.Add(dt.Rows.Count);
double debe = 0;
double haber = 0;
foreach (DataRow dr in dt.Rows)
{
dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dataGridView1.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
double saldo = Convert.ToDouble(dr["saldo"]);
string fletero = Convert.ToString(dr["fletero"]);
dataGridView1.Rows[x].Cells[0].Value = fletero;
if (saldo < 0)
{
dataGridView1.Rows[x].Cells[1].Value = 0;
haber = haber + Math.Abs(saldo);
dataGridView1.Rows[x].Cells[2].Value = Math.Abs(saldo);
}
else
{
dataGridView1.Rows[x].Cells[1].Value = saldo;
debe = debe + saldo;
dataGridView1.Rows[x].Cells[2].Value = 0;
}
x++;
}
label2.Text = (haber - debe).ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error al Buscar: " + ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
frmBuscaEmpresas frm = new frmBuscaEmpresas();
frm.ShowDialog();
Empresas u = frm.u;
if (u != null)
{
lblIdEmpresa.Text = Convert.ToString(u.Idempresas);
txtEmpresa.Text = u.Empresa;
}
}
catch (Exception ex)
{
MessageBox.Show("Error al Buscar: " + ex.Message);
}
}
