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