private void Save_Device(object sender, RoutedPropertyChangedEventArgs <object> e) { TreeViewItem save = ((sender as TreeView).SelectedItem as TreeViewItem); //MessageBox.Show(lbi.Content.ToString()); string saveName = save.Uid.ToString(); if (saveName == null || "".Equals(saveName)) { return; } if (saveDevice.Children != null) { saveDevice.Children.Clear(); } if (saveName.Equals("Alarm")) { Alarm alarm = RoomManagerBean.Alarm; saveDevice.Children.Add(alarm); alarm.SetValue(Grid.RowProperty, 0); alarm.SetValue(Grid.ColumnProperty, 0); } else if (saveName.Equals("History")) { HistoryAlarm alarm = RoomManagerBean.HistoryAlarm; saveDevice.Children.Add(alarm); alarm.SetValue(Grid.RowProperty, 0); alarm.SetValue(Grid.ColumnProperty, 0); } }
private void Alarm_History(object sender, RoutedEventArgs e) { if (saveDevice.Children != null) { saveDevice.Children.Clear(); } HistoryAlarm alarm = RoomManagerBean.HistoryAlarm; RoomClass _Rclass = new RoomClass(); DataSet _HistoryAlarmSet = _Rclass.queryHistoryAlarmList(); alarm.page.ShowPages(alarm.alarmGrid, _HistoryAlarmSet, BaseRequest.PAGE_SIZE); saveDevice.Children.Add(alarm); alarm.SetValue(Grid.RowProperty, 0); alarm.SetValue(Grid.ColumnProperty, 0); }
public static DataTable searchAlarmInfo(string alarmDatePicker1, string alarmDatePicker2, string selKeyTxt) { DataTable dt = HistoryAlarm.GetAlarmTable(); string sql = DB_SQL.Sel_AlarmInfo(alarmDatePicker1, alarmDatePicker2, selKeyTxt); SqlConnection conn = null; SqlCommand cmd = null; SqlDataReader objSqlReader = null; if ((alarmDatePicker1 == "" || alarmDatePicker2 == "") && selKeyTxt == "") { MessageBox.Show("请选择正确的时间段!"); } else { try { using (conn = new SqlConnection(DB_SQL.conStr)) { using (cmd = new SqlCommand(sql, conn)) { conn.Open(); objSqlReader = cmd.ExecuteReader(); int n = 0; while (objSqlReader.Read()) { n += 1; DataRow dr = dt.NewRow(); dr[0] = objSqlReader[0].ToString().Trim(); dr[1] = objSqlReader[1].ToString().Trim(); switch (objSqlReader[2].ToString().Trim()) { case "0": dr[2] = "已处理"; break; case "1": dr[2] = "未处理"; break; } dt.Rows.Add(dr); } if (n == 0) { MessageBox.Show("没有报警!"); } } } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString() + "打开数据库失败!"); } finally { if (objSqlReader != null) { objSqlReader.Close(); } if (cmd != null) { cmd.Dispose(); } if (conn != null) { conn.Close(); conn.Dispose(); } } } return(dt); }
private void AlarmHistory_Click(object sender, RoutedEventArgs e) { DataContext = new HistoryAlarm(); }