Beispiel #1
0
        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());
        }
Beispiel #2
0
 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();
 }
Beispiel #3
0
 private void fecharToolStripMenuItem_Click(object sender, EventArgs e)
 {
     try
     {
         if (Application.OpenForms["Form4"] == null)
         {
             Form4 frm = new Form4();
             frm.MdiParent = this;
             frm.Show();
         }
     }
     catch { }
 }