private void Nahrat() { try { dataGridView2.Columns.Clear(); } catch { } MySqlConnection connection = ridiciFormular.GetConnection(); String sqlQuery = "SELECT Nazev, VIN, Popis, DatumPridani as 'Datum přidání'" + " FROM mydb.stroj "; MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(sqlQuery, connection); DataSet DS = new DataSet(); mySqlDataAdapter.Fill(DS); dataGridView2.DataSource = DS.Tables[0]; }
private void Nahrat() { MySqlConnection connection = null; try { comboStroje.Items.Clear(); comboIoT.Items.Clear(); comboStroje.Items.Add("Vše"); comboIoT.Items.Add("Vše"); connection = ridiciFormular.GetConnection(); MySqlCommand mySqlCommand = new MySqlCommand("SELECT VIN FROM mydb.stroj;", connection); using (var reader = mySqlCommand.ExecuteReader()) { while (reader.Read()) { comboStroje.Items.Add(reader.GetString(reader.GetOrdinal("VIN"))); } } mySqlCommand = new MySqlCommand("SELECT SerioveCislo FROM mydb.iotprvek;", connection); using (var reader = mySqlCommand.ExecuteReader()) { while (reader.Read()) { comboIoT.Items.Add(reader.GetString(reader.GetOrdinal("SerioveCislo"))); } } } catch (Exception ex) { //MessageBox.Show("Chyba při načítání", "UPOZORNĚNÍ"); } }
private void ButtHledat_Click(object sender, EventArgs e) { MySqlConnection connection = ridiciFormular.GetConnection(); try { connection = ridiciFormular.GetConnection(); MySqlCommand mySqlCommand = new MySqlCommand("DELETE FROM mydb.udajestroj " + "WHERE IoTPrvek_SerioveCislo = N'" + dataGridView2.Rows[dataGridView2.SelectedRows[0].Index].Cells[1].Value.ToString() + "';", connection); mySqlCommand.ExecuteNonQuery(); mySqlCommand = new MySqlCommand("DELETE FROM mydb.iotprvek " + "WHERE SerioveCislo = N'" + dataGridView2.Rows[dataGridView2.SelectedRows[0].Index].Cells[1].Value.ToString() + "';", connection); mySqlCommand.ExecuteNonQuery(); } catch (Exception ex) { //MessageBox.Show("Chyba při načítání", "UPOZORNĚNÍ"); } Odstranit(); Nahrat(); }
private void NahratStav() { MySqlConnection connection = null; int[] stav = new int[6]; try { chartStav.Series.Clear(); connection = ridiciFormular.GetConnection(); List <String> VIN = new List <string>(); MySqlCommand mySqlCommand = new MySqlCommand("SELECT VIN FROM mydb.stroj;", connection); using (var reader = mySqlCommand.ExecuteReader()) { while (reader.Read()) { VIN.Add(reader.GetString(reader.GetOrdinal("VIN"))); } } foreach (string v in VIN) { mySqlCommand = new MySqlCommand("SELECT MAX(Datum) as Maximum FROM mydb.udajestroj WHERE stroj_VIN = '" + v + "';", connection); string datum = ""; using (var reader = mySqlCommand.ExecuteReader()) { if (reader.Read()) { datum = reader.GetString("Maximum"); } } mySqlCommand = new MySqlCommand("SELECT Stav FROM mydb.udajeStroj WHERE stroj_VIN = '" + v + "' AND '" + Convert.ToDateTime(datum).ToString("yyyy/MM/dd HH:mm:ss") + "' = Datum;", connection); using (var reader = mySqlCommand.ExecuteReader()) { while (reader.Read()) { if (reader.GetInt32("Stav") == 0) { stav[0]++; } else if (reader.GetInt32("Stav") == 1) { stav[1]++; } else if (reader.GetInt32("Stav") == 2) { stav[2]++; } else if (reader.GetInt32("Stav") == 3) { stav[3]++; } else if (reader.GetInt32("Stav") == 4) { stav[4]++; } else if (reader.GetInt32("Stav") == 5) { stav[5]++; } } } } } catch (Exception ex) {} chartStav.Series.Add("Stav"); chartStav.Series["Stav"].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.Pie; chartStav.Series["Stav"].IsValueShownAsLabel = true; chartStav.Series["Stav"].Label = ""; chartStav.Series["Stav"].Points.AddXY("v klidu", stav[0]); chartStav.Series["Stav"].Points.AddXY("v pohybu", stav[1]); chartStav.Series["Stav"].Points.AddXY("orá", stav[2]); chartStav.Series["Stav"].Points.AddXY("seje", stav[3]); chartStav.Series["Stav"].Points.AddXY("práškuje", stav[4]); chartStav.Series["Stav"].Points.AddXY("hnojí", stav[5]); }