private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { try { List <Form> OpenForms = new List <Form>(); ventas ventas = new ventas(); Cotizaciones cot = new Cotizaciones(); foreach (Form frm in Application.OpenForms) { if (frm.Name == "ventas") { ventas = (ventas)frm; ventas.txtProducto.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString(); ventas.txtDescripcion.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString(); // ventas.txtPallet.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString(); ventas.textBox5.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString(); ventas.textBox4.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString(); ventas.txtPrecio.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString(); ventas.cantidad.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString(); ventas.txtUniMedAduana.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString(); ventas.txtSAT.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString(); ventas.txtAduana.Text = dataGridView1.CurrentRow.Cells[8].Value.ToString(); ventas.txtFraccion.Text = dataGridView1.CurrentRow.Cells[10].Value.ToString(); ventas.txtMedida.Text = dataGridView1.CurrentRow.Cells[9].Value.ToString(); this.Close(); break; } else if (frm.Name == "Cotizaciones") { cot = (Cotizaciones)frm; cot.txtProducto.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString(); cot.txtDescripcion.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString(); cot.txtMedida.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString(); //cot.txtPallet.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString(); cot.txtTam.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString(); cot.txtPrecio.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString(); cot.txtCan.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString(); this.Close(); break; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnVentas_Click(object sender, EventArgs e) { if (ventas == null) { ventas = new ventas(); ventas.Owner = this; ventas.FormClosed += ventas_FormClosed; ventas.dateTimePicker1.Value = DateTime.Today; ventas.Show(); } else { ventas.Activate(); } }
private void button1_Click(object sender, EventArgs e) { ventas inf = new ventas(); compras com = new compras(); Cotizaciones coti = new Cotizaciones(); if (dataGridView1.SelectedRows.Count > 0) { if (cmdReporte.Text.Equals("Ventas")) { inf.txtFolio.Text = dataGridView1.CurrentRow.Cells["Id"].Value.ToString(); inf.dateTimePicker1.Text = dataGridView1.CurrentRow.Cells["date"].Value.ToString(); inf.txtIva.Text = dataGridView1.CurrentRow.Cells["iva"].Value.ToString(); inf.txtNumCliente.Text = dataGridView1.CurrentRow.Cells["num"].Value.ToString(); //inf.txtCajasContenido.Text = dataGridView1.CurrentRow.Cells["cajas"].Value.ToString(); inf.comboBox3.Text = dataGridView1.CurrentRow.Cells["nombreP"].Value.ToString(); inf.comboMoneda.Text = dataGridView1.CurrentRow.Cells["currency"].Value.ToString(); inf.txtCondiciones.Text = dataGridView1.CurrentRow.Cells["cond"].Value.ToString(); inf.txtLugarExpe.Text = dataGridView1.CurrentRow.Cells["lugar"].Value.ToString(); inf.txtSubtotal.Text = dataGridView1.CurrentRow.Cells["subtotal"].Value.ToString(); inf.txtTotal.Text = dataGridView1.CurrentRow.Cells["total"].Value.ToString(); //inf.txtCajasContenido.Text = dataGridView1.CurrentRow.Cells[""].Value.ToString(); inf.dateTimePicker1.Enabled = false; inf.txtIva.Enabled = false; //inf.txtCajasContenido.Enabled = false; inf.comboBox3.Enabled = false; inf.txtLugarExpe.Enabled = false; inf.txtCondiciones.Enabled = false; inf.comboMoneda.Enabled = false; inf.txtPallet.Enabled = false; inf.txtCantidad.Enabled = false; inf.cantidad.Text = "0"; inf.button2.Visible = false; inf.btnArticulo.Visible = false; inf.btnMostrar.Visible = true; inf.button4.Visible = false; inf.btnAgregarProd.Visible = false; inf.btnEliminar.Visible = false; inf.btnMostrar.Visible = false; //inf.txtFolio.Visible = false; inf.dataGridView1.Visible = false; inf.dataGridView2.Visible = true; inf.textBox3.Enabled = false; inf.ShowDialog(); } else if (cmdReporte.Text.Equals("Compras")) { com.txtFolioCompra.Text = dataGridView1.CurrentRow.Cells["Id"].Value.ToString(); com.dateTimePicker1.Text = dataGridView1.CurrentRow.Cells["fecha"].Value.ToString(); //com.txtTipo.Text = dataGridView1.CurrentRow.Cells["tipo"].Value.ToString(); //com.txtName.Text = dataGridView1.CurrentRow.Cells["product"].Value.ToString(); //com.txtPrecioUnitario.Text = dataGridView1.CurrentRow.Cells["price"].Value.ToString(); com.prov.Text = dataGridView1.CurrentRow.Cells["provider"].Value.ToString(); com.txtNoPro.Text = dataGridView1.CurrentRow.Cells["numberP"].Value.ToString(); com.txtTot.Text = dataGridView1.CurrentRow.Cells["total"].Value.ToString(); //com.txtCantidad.Text = dataGridView1.CurrentRow.Cells["amountPurchased"].Value.ToString(); //com.txtTotalCompra.Text = dataGridView1.CurrentRow.Cells["total"].Value.ToString(); //com.txtDescripcion.Text = dataGridView1.CurrentRow.Cells["description"].Value.ToString(); com.dateTimePicker1.Enabled = false; com.txtTipo.Enabled = false; com.dataGridView1.Visible = false; com.dataGridView2.Visible = true; com.button2.Visible = false; com.prov.Enabled = false; com.txtTot.Enabled = false; com.txtPrecioUnitario.Enabled = false; com.txtName.Enabled = false; com.txtDescripcion.Enabled = false; com.btnGuardar.Visible = false; com.btrRegreso.Visible = false; com.button1.Visible = false; com.button3.Visible = false; com.ShowDialog(); } else if (cmdReporte.Text.Equals("Cotizaciones")) { coti.txtFolio.Text = dataGridView1.CurrentRow.Cells["Id"].Value.ToString(); coti.Date.Text = dataGridView1.CurrentRow.Cells["date"].Value.ToString(); coti.pallet.Text = dataGridView1.CurrentRow.Cells["pallet"].Value.ToString(); coti.Expiration.Text = dataGridView1.CurrentRow.Cells["expiration"].Value.ToString(); coti.IdClient.Text = dataGridView1.CurrentRow.Cells["idCliente"].Value.ToString(); coti.ico.Text = dataGridView1.CurrentRow.Cells["icoterm"].Value.ToString(); coti.Customer.Text = dataGridView1.CurrentRow.Cells["customerName"].Value.ToString(); coti.txtTotal.Text = dataGridView1.CurrentRow.Cells["total"].Value.ToString(); coti.txtSubtotal.Text = dataGridView1.CurrentRow.Cells["subtotal"].Value.ToString(); coti.divisa.Text = dataGridView1.CurrentRow.Cells["currency"].Value.ToString(); coti.txtIva.Text = dataGridView1.CurrentRow.Cells["IVA"].Value.ToString(); coti.place.Text = dataGridView1.CurrentRow.Cells["place"].Value.ToString(); coti.Condicion.Text = dataGridView1.CurrentRow.Cells["cond"].Value.ToString(); coti.textBox1.Text = dataGridView1.CurrentRow.Cells["producto"].Value.ToString(); coti.flete.Text = dataGridView1.CurrentRow.Cells["flete"].Value.ToString(); coti.txtCan.Text = "0"; coti.Date.Enabled = false; coti.pallet.Enabled = false; coti.place.Enabled = false; coti.textBox1.Enabled = false; coti.Expiration.Enabled = false; coti.ico.Enabled = false; coti.divisa.Enabled = false; coti.txtIva.Enabled = false; coti.Customer.Enabled = false; coti.Condicion.Enabled = false; coti.flete.Enabled = false; coti.txtPallet.Enabled = false; coti.txtMedida.Enabled = false; coti.btnArticulo.Visible = false; coti.btnAgregarProd.Visible = false; coti.btnEliminar.Visible = false; coti.button2.Visible = false; coti.button3.Visible = false; coti.button1.Visible = false; coti.button5.Visible = false; coti.TablaDeVenta.Visible = false; coti.dataGridView1.Visible = true; coti.ShowDialog(); } } else { MessageBox.Show("Seleccione una fila por favor"); } }
private void ventas_Load(object sender, EventArgs e) { //dateTimePicker1.Value = DateTime.Today; txtCantidad.Enabled = false; SqlCommand cm = new SqlCommand("select name from FinishedProducts", connection); connection.Open(); SqlDataReader registro = cm.ExecuteReader(); while (registro.Read()) { comboBox1.Items.Add(registro["name"].ToString()); } connection.Close(); SqlCommand d = new SqlCommand("select name from clientes", connection); connection.Open(); SqlDataReader r = d.ExecuteReader(); while (r.Read()) { comboBox3.Items.Add(r["name"].ToString()); } connection.Close(); SqlCommand cm2 = new SqlCommand("select nombres + '-' + primerApellido +'-' + segundoApellido as name from clientesFisicos", connection); connection.Open(); SqlDataReader r2 = cm2.ExecuteReader(); while (r2.Read()) { comboBox3.Items.Add(r2["name"].ToString()); } connection.Close(); ventas ven = new ventas(); string query = "select max(Id) from ventas"; // jess SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\William carmona\Documents\Desarrollo\Cagada Adrian\WaareDev\BD\fruteria.mdf;Integrated Security=True"); // karina //SqlConnection con = new SqlConnection(@"Server=tcp:OMEN-LAPTOP18\SQLEXPRESS02,49172;DataBase= fruteria; User Id=Cliente ; Password=cliente1234"); SqlCommand cmd = new SqlCommand(query, con); try { con.Open(); string pcount = Convert.ToString(cmd.ExecuteScalar()); if (this.txtFolio.Text.Equals("")) { //string pcount = Convert.ToString(cmd.ExecuteScalar()); if (pcount.Length == 0) { txtFolio.Text = "1"; } else { int pcount1 = Convert.ToInt32(pcount); int pcountAdd = pcount1 + 1; txtFolio.Text = pcountAdd.ToString(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con.Close(); } SqlCommand com = new SqlCommand("select * from detalleVenta where folio='" + txtFolio.Text + "'", connection); SqlDataAdapter adap = new SqlDataAdapter(); adap.SelectCommand = com; DataTable tabla = new DataTable(); adap.Fill(tabla); dataGridView2.DataSource = tabla; this.dataGridView2.Columns[0].HeaderText = "Folio"; this.dataGridView2.Columns[1].HeaderText = "Pallet x contenido"; this.dataGridView2.Columns[2].HeaderText = "TamaƱo"; this.dataGridView2.Columns[3].HeaderText = "Medida"; this.dataGridView2.Columns[4].HeaderText = "Producto"; this.dataGridView2.Columns[5].HeaderText = "DescripciĆ³n"; this.dataGridView2.Columns[6].HeaderText = "Precio"; this.dataGridView2.Columns[7].HeaderText = "Cajas"; this.dataGridView2.Columns[8].HeaderText = "Total"; //SqlCommand c = new SqlCommand("select * from FinishedProducts where name='"+txtProducto.Text+"'",connection); //SqlDataAdapter ad = new SqlDataAdapter(); //ad.SelectCommand = c; //DataTable tab = new DataTable(); //ad.Fill(tab); //dataGridView3.DataSource = tab; //try //{ // List<Form> OpenForms = new List<Form>(); //} }
private void ventas_FormClosed(object sender, FormClosedEventArgs e) { ventas = null; cotizaciones = null; }