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();
}
