private void treeView1_AfterSelect(object sender, TreeViewEventArgs e)
{
TreeNode node = treeView1.SelectedNode;
// MessageBox.Show(""+node.Text);
try
{
int number_function;
int device_number;
using (TextReader reader = File.OpenText("data1.txt"))
{
number_function = int.Parse(reader.ReadLine());
device_number = int.Parse(reader.ReadLine());
}
string commandSQL = "SELECT * FROM Data;";// + node.Text + ";";//TABLE_VALUES_REGISTERS_" + "1;";//device_number + ";";
dataGridViewTableDB.DataSource = mySqlHelper.GetTable(commandSQL);
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
}
private void UpdateGraphic_Date(string commandSQL, int row_date, int row_other_line)
{
DataTable dt = mySqlHelper.GetTable(commandSQL);
int M = dt.Columns.Count;
int N = dt.Rows.Count;
DateTime[] x = new DateTime[N];
double[] y = new double[N];
for (int i = 0; i < N; i++)
{
x[i] = Convert.ToDateTime(dt.Rows[i][row_date]);
y[i] = Convert.ToInt32(dt.Rows[i][row_other_line]);
}
ShowGraphic(chart1, x, y, "Дата: " + String.Format("{0:dd/MM/yyyy}", x[0]), "");
}
private void setFilter(string commandSQL)
{
DataTable dt = mySqlHelper.GetTable(commandSQL);
int M = dt.Columns.Count;
int N = dt.Rows.Count;
if (N == 0 && M == 0)
{
MessageBox.Show("Дані на цей день відсутні.");
}
else
{
string result = "";
result = "\nДані з параметром " + paramFilter + ":\n"
+ "День: " + String.Format("{0:dd/MM/yyyy}", dt.Rows[0][0]) + "\n";
result += "Device_number: " + Math.Round(Convert.ToDouble(dt.Rows[0][1]), 1).ToString() + " \n";
result += "Register_number: " + Math.Round(Convert.ToDouble(dt.Rows[0][2]), 1).ToString() + " \n";
result += "Value_register: " + Math.Round(Convert.ToDouble(dt.Rows[0][3]), 1).ToString() + " \n";
richTextBox1.AppendText(result);
}
}
