//查询区域 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); } } }