private void PopulateDataGridView(String cond) { My_SQL mysql = new My_SQL(); OdbcDataReader res; res = mysql.hazConsulta("select " + cam[0] + "," + cam[1] + "," + cam[2] + "," + cam[3] + " from clientes,acciones,detalle where clientes.curp=detalle.curp and acciones.clave=detalle.clave and clientes.curp='" + val[0] + "'"); int i; float acc, tot = 0; String[] row = new String[4]; if (res.HasRows) { while (res.Read()) { for (i = 0; i < 3; i++) { row[i] = res.GetString(i); } acc = float.Parse(res.GetString(i)) * int.Parse(row[2]); tot += acc; row[3] = acc.ToString(); dgv.Rows.Add(row); } } total.Text = tot.ToString(); }
private void btnEliminar_Click(object sender, EventArgs e) { if (sel >= 0) { My_SQL mysql; OdbcDataReader res; int nq; mysql = new My_SQL(); res = mysql.hazConsulta("select * from detalle where " + cam[0] + "='" + val[0] + "'"); if (res.HasRows) { MessageBox.Show("El registro esta vinculado a una transaccion"); } else { mysql = new My_SQL(); nq = mysql.hazNoConsulta("delete from " + roll + " where " + cam[0] + " = '" + val[0] + "'"); dgv.Hide(); SetupDataGridView(); PopulateDataGridView(""); actualiza(); MessageBox.Show("Registro Borrado"); } } }
private void dgv_RowsRemoved(object sender, DataGridViewRowsRemovedEventArgs e) { My_SQL mysql; OdbcDataReader res; int nq; mysql = new My_SQL(); res = mysql.hazConsulta("select * from detalle where " + cam[0] + "='" + val[0] + "'"); if (res.HasRows) { MessageBox.Show("El registro esta vinculado a una transaccion"); } else { mysql = new My_SQL(); nq = mysql.hazNoConsulta("delete from " + roll + " where " + cam[0] + " = '" + val[0] + "'"); int row = e.RowIndex; if (row >= e.RowCount) { row = e.RowCount - 1; } if (row >= 0 && e.RowCount > 1) { DataGridView ob = (DataGridView)sender; for (int i = 0; i < colums; i++) { val[i] = (String)ob.Rows[e.RowIndex].Cells[i].Value; } sel = row; } MessageBox.Show("Registro Borrado"); } }
private void PopulateDataGridView(String cond) { My_SQL mysql = new My_SQL(); OdbcDataReader res; if (roll == "clientes" || roll == "acciones") { res = mysql.hazConsulta("select * from " + roll + "" + cond); } else { if (roll == "comprasClientes") { res = mysql.hazConsulta("select * from clientes" + cond); } else { if (roll == "comprasAcciones") { res = mysql.hazConsulta("select * from acciones" + cond); } else { res = mysql.hazConsulta("select " + cam[0] + "," + cam[1] + "," + cam[2] + "," + cam[3] + "," + cam[4] + " from clientes,acciones,detalle where clientes.curp=detalle.curp and acciones.clave=detalle.clave" + cond); } } } int i; String[] row = new String[colums]; if (res.HasRows) { while (res.Read()) { for (i = 0; i < colums; i++) { row[i] = res.GetString(i); } dgv.Rows.Add(row); } } }
private void PopulateDataGridView(String cond) { My_SQL mysql = new My_SQL(); OdbcDataReader res = mysql.hazConsulta("select * from clientes" + cond); int i; String[] row = new String[3]; if (res.HasRows) { while (res.Read()) { for (i = 0; i < 3; i++) { row[i] = res.GetString(i); } dgv.Rows.Add(row); p++; } } }
private void movimiento(int cant, String c, String a) { int i, nq; My_SQL buy; OdbcDataReader res; buy = new My_SQL(); res = buy.hazConsulta(c); String[] cliente = new String[3]; if (res.HasRows) { while (res.Read()) { for (i = 0; i < 3; i++) { cliente[i] = res.GetString(i); } } } else { MessageBox.Show("El cliente" + val[0] + " dejo de existir"); return; } buy = new My_SQL(); res = buy.hazConsulta(a); String[] accion = new String[4]; if (res.HasRows) { while (res.Read()) { for (i = 0; i < 4; i++) { accion[i] = res.GetString(i); } } } else { MessageBox.Show("Las acciones" + val[2] + " dejaron de existir"); return; } float saldo = float.Parse(cliente[2]); float precio = float.Parse(accion[2]); int stock = int.Parse(accion[1]); if (uso == "Comprar") { if (cant * precio > saldo) { MessageBox.Show(cliente[1] + " no tiene saldo Suficiente"); } else { if (stock < cant) { MessageBox.Show(accion[0] + " no tiene acciones suficientes"); } else { buy = new My_SQL(); nq = buy.hazNoConsulta("update clientes set saldo='" + (saldo - (precio * cant)).ToString() + "' where curp='" + cliente[0] + "'"); buy = new My_SQL(); nq = buy.hazNoConsulta("update acciones set stock='" + (stock - cant).ToString() + "' where clave='" + accion[0] + "'"); buy = new My_SQL(); res = buy.hazConsulta("select * from detalle where curp='" + cliente[0] + "' and clave='" + accion[0] + "'"); String[] detalle = new String[3]; if (res.HasRows) { while (res.Read()) { for (i = 0; i < 3; i++) { detalle[i] = res.GetString(i); } } buy = new My_SQL(); nq = int.Parse(detalle[0]); nq = buy.hazNoConsulta("update detalle set cant='" + (nq + cant).ToString() + "' where curp='" + cliente[0] + "' && clave='" + accion[0] + "'"); } else { buy = new My_SQL(); nq = buy.hazNoConsulta("insert into detalle values('" + cant.ToString() + "','" + cliente[0] + "','" + accion[0] + "')"); } frmGrafica reporte = new frmGrafica("Reporte", 5); reporte.Show(); this.Close(); } } } else { nq = int.Parse(val[4]); if (cant > nq) { MessageBox.Show(cliente[1] + " no tiene Acciones Suficientes"); } else { buy = new My_SQL(); nq = buy.hazNoConsulta("update clientes set saldo='" + (saldo + (precio * cant)).ToString() + "' where curp='" + cliente[0] + "'"); buy = new My_SQL(); nq = buy.hazNoConsulta("update acciones set stock='" + (stock + cant).ToString() + "' where clave='" + accion[0] + "'"); nq = int.Parse(val[4]); nq -= cant; if (nq > 0) { buy = new My_SQL(); nq = buy.hazNoConsulta("update detalle set cant='" + nq.ToString() + "' where curp='" + cliente[0] + "' and clave='" + accion[0] + "'"); } else { buy = new My_SQL(); nq = buy.hazNoConsulta("delete from detalle where curp='" + val[0] + "' and clave='" + val[2] + "'"); } this.Close(); } } }