public static void InsertToDB(AlarmInfo alm)
{
DBUtil dBUtil = new DBUtil();
Dictionary <string, object> keyValues = new Dictionary <string, object>();
try
{
string SQL = @"insert into log_alarm_his (node_name,system_alarm_code,alarm_code,alarm_desc,alarm_eng_desc,alarm_type,is_stop,need_reset,time_stamp)
values(@node_name,@system_alarm_code,@alarm_code,@alarm_desc,@alarm_eng_desc,@alarm_type,@is_stop,@need_reset,@time_stamp)";
keyValues.Add("@node_name", alm.NodeName);
keyValues.Add("@system_alarm_code", alm.SystemAlarmCode);
//keyValues.Add("@alarm_tpye", alm.AlarmType);
keyValues.Add("@alarm_code", alm.AlarmCode);
keyValues.Add("@alarm_desc", alm.Desc);
keyValues.Add("@alarm_eng_desc", alm.EngDesc);
keyValues.Add("@alarm_type", alm.Type);
keyValues.Add("@is_stop", alm.IsStop);
keyValues.Add("@need_reset", alm.NeedReset);
keyValues.Add("@time_stamp", alm.TimeStamp.ToString("yyyy-MM-dd HH:mm:ss.ffffff"));
dBUtil.ExecuteNonQueryAsync(SQL, keyValues);
}
catch (Exception e)
{
logger.Error("InsertToDB error:" + e.StackTrace);
}
}
//private static List<AlarmInfo> AlarmHistory = new List<AlarmInfo>();
public static void Add(AlarmInfo Alm)
{
AlarmList.Add(Alm);
InsertToDB(Alm);
}
public static void Remove(AlarmInfo alm)
{
AlarmList.Remove(alm);
}
