private void button4_Click(object sender, EventArgs e)
{
try
{
frmBuscaFleteros frm = new frmBuscaFleteros();
frm.ShowDialog();
f = frm.u;
if (f != null)
{
Acceso_BD oa = new Acceso_BD();
DataTable dt = oa.leerDatos("select count(*) as cant from ordenescarga o inner join clientes c on o.idclientes = c.idclientes inner join fleteros f on f.idfleteros = o.idfleteros inner join tiposcamion t on f.idtiposcamion = t.idtiposcamion left join empresas e on f.idempresas = e.idempresas inner join sucursales s on s.idsucursales = o.idsucursales where o.idfleteros = '" + f.Idfleteros + "' and o.valorizado = '0' and o.anulado = '0'");
int cant = 0;
foreach (DataRow dr in dt.Rows)
{
cant = Convert.ToInt32(dr["cant"]);
}
if (cant > 0)
{
btnOrdenFlet.Text = "Ord.Carga Pendientes " + cant.ToString();
btnOrdenFlet.Enabled = true;
}
else
{
btnOrdenFlet.Text = "";
btnOrdenFlet.Enabled = false;
}
lblFletero.Text = Convert.ToString(f.Idfleteros);
lblEmpresa.Text = f.Empresas.Idempresas.ToString();
txtEmpresa.Text = f.Empresas.Empresa;
txtFletero.Text = f.Fletero;
txtDomicilio.Text = f.Direccion;
txtLocalidad.Text = f.Localidad;
txtTelefono.Text = f.Telefono;
txtCelular.Text = f.Celular;
txtModelo.Text = f.Camion;
cmbTipoCamion.SelectedValue = f.Tiposcamion.Idtiposcamion;
txtCP.Text = f.Cp.ToString();
txtChapaA.Text = f.Chapaacoplado;
txtChapaC.Text = f.Chapacamion;
txtDocumento.Text = f.Documento.ToString();
dt = oa.leerDatos("SELECT SUM(DEBE-HABER) as saldo FROM ctactefleteros WHERE idfleteros = '" + f.Idfleteros + "' and idempresas = '" + f.Empresas.Idempresas + "'");
foreach (DataRow dr in dt.Rows)
{
txtSaldoFlet.Text = Convert.ToString(dr["saldo"]);
}
dt = oa.leerDatos("SELECT SUM(DEBE-HABER) as saldo FROM ctactefleteros WHERE idempresas = '" + f.Empresas.Idempresas + "'");
foreach (DataRow dr in dt.Rows)
{
txtSaldoEmp.Text = Convert.ToString(dr["saldo"]);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error al Guardar: " + ex.Message);
}
}
private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
frmBuscaFleteros frm = new frmBuscaFleteros();
frm.ShowDialog();
u = frm.u;
if (u != null)
{
txtCliente.Text = u.Fletero;
txtRecibimosDe.Text = u.Fletero;
txtEnConcepto.Text = cmbConceptos.Text;
buscar();
Acceso_BD oa = new Acceso_BD();
DataTable dt = oa.leerDatos("SELECT SUM(HABER-DEBE) as saldo FROM ctactefleteros WHERE idfleteros = '" + u.Idfleteros + "' and idempresas = '" + u.Empresas.Idempresas + "'");
cmbemp.SelectedValue = u.Empresas.Idempresas;
foreach (DataRow dr in dt.Rows)
{
txtSaldo.Text = Convert.ToString(dr["saldo"]);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error al Guardar: " + ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
frmBuscaFleteros frm = new frmBuscaFleteros();
frm.ShowDialog();
Fleteros u = frm.u;
if (u != null)
{
lblFletero.Text = Convert.ToString(u.Idfleteros);
txtFletero.Text = u.Fletero;
}
}
catch (Exception ex)
{
MessageBox.Show("Error al Guardar: " + ex.Message);
}
}
private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
frmBuscaFleteros frm = new frmBuscaFleteros();
frm.ShowDialog();
u = frm.u;
if (u != null)
{
Acceso_BD oa = new Acceso_BD();
DataTable dt = oa.leerDatos("select count(*) as cant from ordenescarga o inner join clientes c on o.idclientes = c.idclientes inner join fleteros f on f.idfleteros = o.idfleteros inner join tiposcamion t on f.idtiposcamion = t.idtiposcamion left join empresas e on f.idempresas = e.idempresas inner join sucursales s on s.idsucursales = o.idsucursales where o.idfleteros = '" + u.Idfleteros + "' and o.valorizado = '0' and o.anulado = '0'");
int cant = 0;
foreach (DataRow dr in dt.Rows)
{
cant = Convert.ToInt32(dr["cant"]);
}
if (cant > 0)
{
button5.Text = "Ord.Carga Pendientes " + cant.ToString();
button5.Enabled = true;
}
else
{
button5.Text = "";
button5.Enabled = false;
}
dataGridView1.Rows.Clear();
dataGridView2.Rows.Clear();
buscar1();
buscar(u.Empresas.Idempresas);
}
}
catch (Exception ex)
{
MessageBox.Show("Error al Guardar: " + ex.Message);
}
}
private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
deshabilitar();
limpiar();
frmBuscaFleteros frm = new frmBuscaFleteros();
frm.ShowDialog();
Fleteros u = frm.u;
if (u != null)
{
txtcomentario.Text = u.Comentario;
lblIdFletero.Text = Convert.ToString(u.Idfleteros);
lblIdEmpresa.Text = u.Empresas.Idempresas.ToString();
txtEmpresa.Text = u.Empresas.Empresa;
txtCliente.Text = u.Fletero;
txtDomicilio.Text = u.Direccion;
txtLocalidad.Text = u.Localidad;
txtTelefono.Text = u.Telefono;
txtCelular.Text = u.Celular;
txtFax.Text = u.Fax;
txtModelo.Text = u.Camion;
txtMail.Text = u.Mail;
cmbTipoCamion.SelectedValue = u.Tiposcamion.Idtiposcamion;
txtCP.Text = u.Cp.ToString();
txtChapaA.Text = u.Chapaacoplado;
txtChapaC.Text = u.Chapacamion;
txtDocumento.Text = u.Documento.ToString();
cmbTipoIva.SelectedValue = u.TiposIVA.IdTiposIVA;
maskedTextBox1.Text = u.Cuit;
}
}
catch (Exception ex)
{
MessageBox.Show("Error al Guardar: " + ex.Message);
}
}