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); } }