private void btnBuscarCliente_Click(object sender, EventArgs e)
{
try
{
frmBuscar frm = new frmBuscar();
frm.Consulta = "SELECT * FROM vista_cliente";
frm.ShowDialog();
straux2 = frm.ID;
if (straux2.Trim() == "")
{
return;
}
dr2 = Conexion.ObtenerDatos("SELECT * FROM cliente where idCliente = '" + straux2 + "'");
lblC.Text = "Cliente: " + dr2.ItemArray[1].ToString() + "\n" +
"Teléfono: " + dr2.ItemArray[2].ToString() + "\n" +
"Direccion: " + dr2.ItemArray[3].ToString() + ", #" + dr2.ItemArray[4].ToString() + ", " + dr2.ItemArray[5].ToString() + ", " +
dr2.ItemArray[6].ToString() + ", " + dr2.ItemArray[7].ToString();
}
catch (Exception)
{
return;
}
}
private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
frmBuscar frm = new frmBuscar();
frm.Consulta = "SELECT * FROM vista_ordencompra";
frm.ShowDialog();
idOrdenC = frm.ID;
if (idOrdenC.Trim() == "")
{
return;
}
DataRow dr = Conexion.ObtenerDatos("SELECT * FROM ordencompra where idOrdenCompra='" + idOrdenC + "'");
lblOrden.Text = "No. Orden de Compra: " + dr.ItemArray[1].ToString();
llenar();
}
catch (Exception)
{
//Log
}
}
private void btnBuscarProducto_Click(object sender, EventArgs e)
{
try
{
frmBuscar frm = new frmBuscar();
frm.Consulta = "SELECT * FROM vista_producto";
frm.ShowDialog();
straux = frm.ID;
if (straux.Trim() == "")
{
return;
}
dr1 = Conexion.ObtenerDatos("SELECT * FROM producto where idProducto = '" + straux + "'");
lblP.Text = "Código: " + dr1.ItemArray[3].ToString() + "\n" +
"Nombre: " + dr1.ItemArray[1].ToString() + "\n" +
"Precio: " + dr1.ItemArray[2].ToString();
}
catch (Exception)
{
return;
}
}
private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
frmBuscar frm = new frmBuscar();
frm.Consulta = "SELECT * FROM vista_requisicion";
frm.ShowDialog();
straux = frm.ID;
if (straux.Trim() == "")
{
return;
}
DataRow dr = Conexion.ObtenerDatos("select * from requisicion where NoRequisicion= '" + straux + "'");
txtNumero.Text = dr.ItemArray[1].ToString();
cboProducto.ValueMember = dr.ItemArray[2].ToString();
cboUnidad.ValueMember = dr.ItemArray[3].ToString();
cboEmpleado.ValueMember = dr.ItemArray[4].ToString();
txtCantidad.Text = dr.ItemArray[5].ToString();
mskFechaP.Text = dr.ItemArray[6].ToString();
mskFechaE.Text = dr.ItemArray[7].ToString();
}
catch (Exception)
{
return;
}
}
private void btnBuscarPlan_Click(object sender, EventArgs e)
{
try
{
frmBuscar frm = new frmBuscar();
frm.Consulta = "SELECT * FROM vista_almacen";
frm.ShowDialog();
straux = frm.ID;
if (straux.Trim() == "")
{
return;
}
DataRow dr = Conexion.ObtenerDatos("select * from almacen where idAlmacen = '" + straux + "'");
txtClave.Text = dr.ItemArray[9].ToString();
txtDescripcion.Text = dr.ItemArray[2].ToString();
txtNombre.Text = dr.ItemArray[1].ToString();
txtCalle.Text = dr.ItemArray[4].ToString();
msktxtNumero.Text = dr.ItemArray[5].ToString();
txtColonia.Text = dr.ItemArray[6].ToString();
txtCiudad.Text = dr.ItemArray[8].ToString();
mskCP.Text = dr.ItemArray[7].ToString();
}
catch (Exception)
{
return;
}
}
private void btnBuscar_Click(object sender, EventArgs e)
{
frmBuscar frm = new frmBuscar();
frm.Consulta = "SELECT * FROM vista_soliccotizacioncatalogo";
frm.ShowDialog();
string straux = frm.ID;
if (straux.Trim() == "")
{
return;
}
DataRow dr = Conexion.ObtenerDatos("select * from soliccotizacion where noCotizacion = '" + straux + "'");
txtNumero.Text = dr.ItemArray[1].ToString();
txtDescripción.Text = dr.ItemArray[2].ToString();
mskFecha.Text = dr.ItemArray[3].ToString();
}
private void btnBuscarPlan_Click(object sender, EventArgs e)
{
try
{
frmBuscar frm = new frmBuscar();
frm.Consulta = "SELECT * FROM vista_tipocontactocliente";
frm.ShowDialog();
straux = frm.ID;
if (straux.Trim() == "")
{
return;
}
DataRow dr = Conexion.ObtenerDatos("SELECT * FROM tipocontactocliente where idTipoContactoCliente = '" + straux + "'");
txtDescripcion.Text = dr.ItemArray[2].ToString();
}
catch (Exception)
{
return;
}
}
private void btnBuscarCliente_Click(object sender, EventArgs e)
{
try
{
frmBuscar frm = new frmBuscar();
frm.Consulta = "SELECT * FROM vista_cliente";
frm.ShowDialog();
straux2 = frm.ID;
if (straux2.Trim() == "")
{
return;
}
dr2 = Conexion.ObtenerDatos("SELECT * FROM cliente where idCliente = '" + straux2 + "'");
txtCliente.Text = "" + dr2.ItemArray[1].ToString();
}
catch (Exception)
{
return;
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
frmBuscar frm = new frmBuscar();
frm.Consulta = "SELECT * FROM vista_cotizacion";
frm.ShowDialog();
straux3 = frm.ID;
if (straux3.Trim() == "")
{
return;
}
dr3 = Conexion.ObtenerDatos("SELECT * FROM cotizacion where idCotizacion = '" + straux3 + "'");
lblCot.Text = "No. Cotización: " + dr3.ItemArray[1].ToString() + "\n" +
"Fecha: " + dr3.ItemArray[7].ToString();
}
catch (Exception)
{
return;
}
}
