//查询区域
private void button1_Click(object sender, EventArgs e)
{
List <Dictionary <String, String> > list =
new Services().queryData(int.Parse(user["id"]), dateTimePicker1.Text, dateTimePicker2.Text);
//foreach(Dictionary<String, String> dir in list)
//{
// foreach(String key in dir.Keys)
// {
// Console.WriteLine(key + " " + dir[key]);
// }
//}
if (list != null)
{
clearChart(chart1);
clearChart(chart2);
clearChart(chart3);
clearListView();
foreach (Dictionary <String, String> dy in list)
{
try
{
DataModel dm = new DataModel(ObjectStringSwap.string2Bytes(dy["dataval"]));
if (dm.Tag)
{
//Console.WriteLine(dm.ToString());
setValueOfListView(dy, dm);
if (dy["name"].Equals("m1"))
{
Tools.setAValueOfChartToQuery(chart1, dy["gt"], dm);
}
else if (dy["name"].Equals("m2"))
{
Tools.setAValueOfChartToQuery(chart2, dy["gt"], dm);
}
else if (dy["name"].Equals("m3"))
{
Tools.setAValueOfChartToQuery(chart3, dy["gt"], dm);
}
}
}
catch (Exception e1)
{
Console.WriteLine(e1.StackTrace);
}
}
}
}
//查询数据
private void button2_Click(object sender, EventArgs e)
{
listView1.Items.Clear();
List <Dictionary <String, String> > list =
new Services().queryData(1, dateTimePicker1.Text, dateTimePicker2.Text);
if (list != null)
{
foreach (Dictionary <String, String> dir in list)
{
DataModel dm = new DataModel(ObjectStringSwap.string2Bytes(dir["dataval"]));
ListViewItem li = new ListViewItem();
li.SubItems.Clear();
li.SubItems[0].Text = dir["name"];
li.SubItems.Add(dm.Pm25.ToString());
li.SubItems.Add(dm.Pm10.ToString());
li.SubItems.Add(dm.Temperature.ToString());
li.SubItems.Add(dm.Humidity.ToString());
li.SubItems.Add(dir["gt"]);
listView1.Items.Add(li);
}
}
}
public static bool insert(int mid, String dt, DataModel dm)
{
MySqlConnection con = DBUtils.getConnection();
try
{
String str = ObjectStringSwap.bytes2String(dm.Bs);
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "insert into datas(mid, dataval, gt) values(?1, ?2, ?3)";
cmd.Parameters.AddWithValue("?1", mid);
cmd.Parameters.AddWithValue("?2", str);
cmd.Parameters.AddWithValue("?3", dt);
return(cmd.ExecuteNonQuery() > 0);
}
catch (Exception e)
{
Console.WriteLine("*" + e.StackTrace);
}
finally
{
DBUtils.close(con);
}
return(false);
}
