private void fillSqlCritTable()
{
try
{
string connStr = Program.connStr;
MySqlConnection conn = new MySqlConnection(connStr);
conn.Open();
var lastEntry = "SELECT DateTime FROM `machine_stats` WHERE id = (SELECT MAX(id) FROM `machine_stats`)";
MySqlCommand command = new MySqlCommand(lastEntry, conn);
string returnedDate = command.ExecuteScalar().ToString(); //Получаем правильно
DateTime maxDateDT = DateTime.Parse(returnedDate);
DateTime minDateDT = maxDateDT.AddHours(-24);
string minDate = DatToDB.reverseDate(minDateDT.ToString()); //Считаем правильно
string maxDate = DatToDB.reverseDate(maxDateDT.ToString());
conn.Close();
var select = String.Format("SELECT * FROM `machine_stats` WHERE ((`DateTime` >= '{0}') AND (`DateTime` <= '{1}') AND ((`Temp` >= '{2}') OR (`Vibr` >= '{3}') OR " +
"(`Power` >= '{4}') OR (`Load` >= '{5}') OR (`Wtime` >= '{6}')))", minDate, maxDate, Program.critTemp, Program.critVibr, Program.critPow, Program.critLoad, Program.critTime);
//Запрос обрабатывается
var dataAdapter = new MySqlDataAdapter(select, conn);
var ds = new DataSet();
dataAdapter.Fill(ds); //А ds пустой!
dataGridView1.ReadOnly = true;
dataGridView1.DataSource = ds.Tables[0];
}
catch
{
MessageBox.Show("Проверьте подключение к интернету");
}
}
private void fillSqlCritTable()
{
try
{
string connStr = "server=baltika.mysql.database.azure.com;user=sailor@baltika;database=smartfactory;password=Baltika123;charset=utf8;";
MySqlConnection conn = new MySqlConnection(connStr);
conn.Open();
var lastEntry = "SELECT DateTime FROM `machine_stats` WHERE id = (SELECT MAX(id) FROM `machine_stats`)";
MySqlCommand command = new MySqlCommand(lastEntry, conn);
string returnedDate = command.ExecuteScalar().ToString(); //Получаем правильно
DateTime maxDateDT = DateTime.Parse(returnedDate);
DateTime minDateDT = maxDateDT.AddHours(-24);
string minDate = DatToDB.reverseDate(minDateDT.ToString()); //Считаем правильно
string maxDate = DatToDB.reverseDate(maxDateDT.ToString());
conn.Close();
var select = String.Format("SELECT * FROM `machine_stats` WHERE ((`DateTime` >= '{0}') AND (`DateTime` <= '{1}') AND ((`Temp` BETWEEN '{2}' AND '{3}') OR (`Vibr` BETWEEN '{4}' AND '{5}') OR " +
"(`Power` BETWEEN '{6}' AND '{7}') OR (`Load` BETWEEN '{8}' AND '{9}') OR (`Wtime` BETWEEN '{10}' AND '{11}')))", minDate, maxDate, Program.dangTemp, Program.critTemp, Program.dangVibr, Program.critVibr,
Program.dangPow, Program.critPow, Program.dangLoad, Program.critLoad, Program.dangTime, Program.critTime);
//Запрос обрабатывается
var dataAdapter = new MySqlDataAdapter(select, conn);
var ds = new DataSet();
dataAdapter.Fill(ds); //А ds пустой!
dataGridView1.ReadOnly = true;
dataGridView1.DataSource = ds.Tables[0];
}
catch
{
MessageBox.Show("Проверьте подключение к сети");
}
}