private void button1_Click(object sender, EventArgs e) { try { string SQL1 = "INSERT INTO graficovendas SELECT idSacoles,sabor, SUM( quantidade ) AS quant FROM vendas_sacoles INNER JOIN sacoles ON vendas_sacoles.sacoles_idsacoles = sacoles.idSacoles && sacoles.tipo=1 INNER JOIN vendas ON vendas_sacoles.vendas_idvendas = vendas.idvendas WHERE data like '%2013%' GROUP BY sacoles.idSacoles ORDER BY quant DESC"; string SQL = "SELECT sabor, SUM( quantidade ) AS quant FROM vendas_sacoles INNER JOIN sacoles ON vendas_sacoles.sacoles_idsacoles = sacoles.idSacoles && sacoles.tipo=1 INNER JOIN vendas ON vendas_sacoles.vendas_idvendas = vendas.idvendas WHERE data like '%2013%' GROUP BY sacoles.idSacoles ORDER BY quant DESC"; string SQL_APAGAR = "DELETE FROM graficovendas"; MySqlConnection combo10 = new MySqlConnection("SERVER=localhost;" + " DATABASE=banco_rr_sacoles;" + " UID=root;" + "PASSWORD=12345;"); MySqlDataAdapter sql40 = new MySqlDataAdapter(SQL, combo10); MySqlCommand comandos = new MySqlCommand(SQL1, combo10); MySqlCommand comandodrop = new MySqlCommand(SQL_APAGAR, combo10); combo10.Open(); comandodrop.ExecuteNonQuery(); comandos.ExecuteNonQuery(); DataTable dt40 = new DataTable(); //int rt = 0; //string lcSQL = "SELECT idvendas FROM vendas ORDER BY idvendas DESC LIMIT 1"; /* MySqlConnection conn = new MySqlConnection("SERVER=localhost;" + " DATABASE=banco_rr_sacoles;" + " UID=root;" + "PASSWORD=12345;"); MySqlCommand command = new MySqlCommand(lcSQL, conn); command.Parameters.AddWithValue("idvendas", rt); conn.Open(); MySqlDataReader dr = command.ExecuteReader(); while (dr.Read()) { dr.GetInt32(0); } */ // while (Reader.Read()) // { // label1.Content = "" + Reader.GetString(0); // } //connection.Close(); sql40.Fill(dt40); BindingSource source = new BindingSource(); dgv.DataSource = dt40; //source.DataSource = dt40; //dgv.Rows.Add(cmbxsacolescre.Text, nupdowCre.Text, "R$ " + (String.Format("{0:0.00}", Resultado))); //nupdowCre.Maximum = int.Parse(tbxEstCre.Text); combo10.Close(); } catch (MySqlException ex) { MessageBox.Show("Erro!!" + ex.Message, "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Information); } Form4 form = new Form4(); form.Show(); //$result = mysql_query($query) or die(mysql_error()); }
private void sucoToolStripMenuItem4_Click(object sender, EventArgs e) { dataSistema = DateTime.Now.ToShortDateString(); string data = "", sDataF = ""; data = dataSistema; DateTime d = Convert.ToDateTime(data); sDataF = d.ToString("yyyyMMdd"); int ano = DateTime.Now.Year; try { string SQL1 = "INSERT INTO graficovendas SELECT idSacoles,sabor, SUM( quantidade ) AS quant FROM vendas_sacoles INNER JOIN sacoles ON vendas_sacoles.sacoles_idsacoles = sacoles.idSacoles && sacoles.tipo=2 INNER JOIN vendas ON vendas_sacoles.vendas_idvendas = vendas.idvendas WHERE data LIKE '%" + ano + "%' GROUP BY sacoles.idSacoles ORDER BY quant DESC"; string SQL_APAGAR = "DELETE FROM graficovendas"; MySqlConnection combo10 = new MySqlConnection("SERVER=localhost;" + " DATABASE=banco_rr_sacoles;" + " UID=root;" + "PASSWORD=12345;"); MySqlCommand comandos = new MySqlCommand(SQL1, combo10); MySqlCommand comandodrop = new MySqlCommand(SQL_APAGAR, combo10); combo10.Open(); comandodrop.ExecuteNonQuery(); comandos.ExecuteNonQuery(); DataTable dt40 = new DataTable(); combo10.Close(); } catch (MySqlException ex) { MessageBox.Show("Erro!!" + ex.Message, "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Information); } Form4 form = new Form4(); form.MdiParent = this; form.Show(); }
private void fecharToolStripMenuItem_Click(object sender, EventArgs e) { try { if (Application.OpenForms["Form4"] == null) { Form4 frm = new Form4(); frm.MdiParent = this; frm.Show(); } } catch { } }