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]);
}
