private static void ProcessAlarm(AlarmThreadManagerConfig cfg, double value, int reason) { // Найдем тревогу у которой время окончания - пустое. var al = GetAlarm(cfg.TagId); // Если среди тревог нет активных тревог. if (al == null) { // И если причина не нормальное состояние. if (reason != 0) { OpenAlarm(cfg, value, reason); } return; } // Если её начальное состояние совпадает с текущим, то похер эта тревога уже и так есть. if (al.SRes == reason) { return; } // Если её начальное состояние не совпадает с текущим, то зафиксируем окончание этой тревоги. CloseAlarm(al, value, reason); // И если тревога квитирована. Уберем из списка. if (al.Qted != null) { _alarms.Remove(al); } // Если состояние не стало нормальным. Добавим новую тревогу. if (reason != 0) { OpenAlarm(cfg, value, reason); } }
private static void OpenAlarm(AlarmThreadManagerConfig alarmConfig, double value, int reason) { var dateTime = DateTime.Now; var dateTimeString = dateTime.ToString(DtFormat); // Добавляем тревогу в базу. var rawVal = value.ToString().Replace(',', '.'); var sysUser = context.Alarms.Create(); sysUser.TagId = alarmConfig.TagId; sysUser.SRes = reason; sysUser.STime = dateTime; sysUser.SVal = (float)value; sysUser.ERes = -10; logger.Logged("Info", "Add Alarm [tag:" + alarmConfig.Tag + ";sval:" + sysUser.SVal + "; STime:" + dateTime + " ]...", "AlarmThreadManager", "LoadAlarmsLastStates"); context.Alarms.Add(sysUser); // сохраняем context.SaveChanges(); //MyDB.sql_query_local("insert into alarms (Tag, SRes, STime, SVal, ERes) values('" + alarmConfig.Tag + "'," + reason + ",'" + dateTimeString + "', " + rawVal + ", -10);"); //var qres2 = MyDB.sql_query_local("select id from alarms where tag='" + alarmConfig.Tag + "' and STime='" + dateTimeString + "'"); //int tid = -1; //if (qres2.count_rows > 0) // tid = Convert.ToInt32(qres2.GetValue(0, 0)); var z = (from ti in context.Alarms where ti.TagId == alarmConfig.TagId //&& ti.STime == dateTime orderby ti.STime descending select ti.Id); // from al context.Alarms .Where(d => d.TagId == alarmConfig.TagId && d.STime == dateTime).ToList(); var id = z.ToList();// Создадим тревогу чтобы не дергать каждый раз базу. var result = new AlarmThreadManagerAlarm { Id = id.First(), TagId = alarmConfig.TagId, SRes = reason, STime = dateTime, SVal = value, Qted = null, ERes = -10, ETime = DateTime.MinValue }; _alarms.Add(result); logger.Logged("Info", "add alarm [" + alarmConfig.TagId + "][" + reason + "] to alarmserver...", "AlarmThreadManager", "OpenAlarm"); }
// Перезагружает конфигурацию одной тревоги. Если к примеру изменили её через конфигуратор тревог. public void LoadOneAlarm(int tagid) { lock (ConfigLocker) { if (tagid == null) { logger.Logged("Error", " TagName is null or empty.", "AlarmThreadManager", "LoadOneAlarm"); return; } AlarmThreadManagerConfig curTag; // var cRes = MyDB.sql_query_local("SELECT * FROM Signal_Alarm_Messages WHERE input_source='" + tagName + "';"); // if (cRes.count_rows > 0) // { var tags = (from ti in context.Objects join to in context.Properties on ti.Id equals to.ObjectId where ti.Type == 2 && to.PropId == 0 && ti.Id == tagid select to.Value); var taglist = tags.ToList(); // var cRes = MyDB.sql_query_local("SELECT * FROM Signal_Alarm_Messages;"); foreach (var tagjson in taglist) { dynamic alarm = _json.Deserialize(tagjson); var tag = Convert.ToString(alarm.Connection); var tagId = Convert.ToInt32(alarm.Id); var enabled = Convert.ToBoolean(alarm.enabled); var active = Convert.ToBoolean(alarm.active); var hihiText = Convert.ToString(alarm.hihiText); var hiText = Convert.ToString(alarm.hiText); var normalText = Convert.ToString(alarm.normalText); var loText = Convert.ToString(alarm.loText); var loloText = Convert.ToString(alarm.loloText); double hihiSeverity; if (!Double.TryParse(alarm.hihiSeverity, out hihiSeverity)) { hihiSeverity = Double.MaxValue; } double hiSeverity; if (!Double.TryParse(alarm.hiSeverity, out hiSeverity)) { hiSeverity = Double.MaxValue; } double loSeverity; if (!Double.TryParse(alarm.loSeverity, out loSeverity)) { loSeverity = Double.MinValue; } double loloSeverity; if (!Double.TryParse(alarm.loloSeverity, out loloSeverity)) { loloSeverity = Double.MinValue; } curTag = new AlarmThreadManagerConfig { Tag = tag, TagId = tagId, Enabled = enabled, Active = active, HihiText = hihiText, HiText = hiText, NormalText = normalText, LoText = loText, LoloText = loloText, HihiSeverity = hihiSeverity, HiSeverity = hiSeverity, LoSeverity = loSeverity, LoloSeverity = loloSeverity }; var index = -1; for (var cfgi = 0; cfgi < _cfgs.Count; cfgi++) { if (_cfgs[cfgi].TagId == tagid) { index = cfgi; break; } } if (index != -1) { _cfgs[index] = curTag; } else { _cfgs.Add(curTag); } } } }
// Перезагружает конфигурацию одной тревоги. Если к примеру изменили её через конфигуратор тревог. public void LoadOneAlarm(int tagid) { lock (ConfigLocker) { if (tagid == null) { logger.Logged("Error", " TagName is null or empty.", "AlarmThreadManager", "LoadOneAlarm"); return; } AlarmThreadManagerConfig alarm_ = null; var tags = (from ti in context.Objects join to in context.Properties on ti.Id equals to.ObjectId where ti.Type == 2 && to.PropId == 0 && ti.Id == tagid select new { Id = ti.Id, Prop = to.Value }); var taglist = tags.ToList(); foreach (var tagjson in taglist) { dynamic alarm = _json.Deserialize(tagjson.Prop); var tag = new TagId { TagName = Convert.ToString(alarm.Connection), PollerId = Convert.ToInt32(alarm.Opc) }; var alarms = Convert.ToString(alarm.Alarms); if (alarms != null) { alarm_ = new AlarmThreadManagerConfig(); var _props = _json.Deserialize(alarms, alarm_.GetType()); alarm_ = (AlarmThreadManagerConfig)_props; if (alarm_.Enabled) { alarm_.TagId = Convert.ToInt32(tagjson.Id); alarm_.Tag = tag; if (alarm_.Sound) { _soundalarms.Add(tagjson.Id); } if (alarm_.HihiSeverity == null) { alarm_.HihiSeverity = Double.MaxValue; } if (alarm_.HiSeverity == null) { alarm_.HiSeverity = Double.MaxValue; } if (alarm_.LoSeverity == null) { alarm_.LoSeverity = Double.MinValue; } if (alarm_.LoloSeverity == null) { alarm_.LoloSeverity = Double.MinValue; } _cfgs.Add(alarm_); } var tagId = Convert.ToInt32(alarm.Id); if (alarm_.HihiSeverity == null) { alarm_.HihiSeverity = Double.MaxValue; } if (alarm_.HiSeverity == null) { alarm_.HiSeverity = Double.MaxValue; } if (alarm_.LoSeverity == null) { alarm_.LoSeverity = Double.MinValue; } if (alarm_.LoloSeverity == null) { alarm_.LoloSeverity = Double.MinValue; } } var index = -1; for (var cfgi = 0; cfgi < _cfgs.Count; cfgi++) { if (_cfgs[cfgi].TagId == tagid) { index = cfgi; break; } } if (index != -1) { _cfgs[index] = alarm_; } else { _cfgs.Add(alarm_); } } } }
// Загружает конфигурацию тревог при старте системы. public static void LoadAlarmsConfigurations() { lock (ConfigLocker) { _cfgs.Clear(); _cfgsEv.Clear(); _soundalarms.Clear(); var taglist = _tags.Where(x => x.Type == 2 && !String.IsNullOrEmpty(x.Prop)); foreach (var tagjson in taglist) { dynamic alarm = JsonConvert.DeserializeObject(tagjson.Prop); var tag = new TagId { TagName = ("Sfera." + Convert.ToString(alarm.Connection) + "." + tagjson.Name.Replace("_unreal", "")).Replace('/', '.'), PollerId = Convert.ToInt32(alarm.Opc) }; try { var events = Convert.ToString(alarm.Events); if (events != null && events != "") { var event_ = new EventThreadManagerConfig(); var _props = _json.Deserialize(events, event_.GetType()); event_ = (EventThreadManagerConfig)_props; if (event_.Enabled) { event_.Tag = tag; event_.TagId = Convert.ToInt32(tagjson.Id); _cfgsEv.Add(event_); } } } catch (Exception ex) { logger.Logged("Err", "add Event tag [" + tag.PollerId + "][" + tag.TagName + "] to alarmserver failed: " + ex.Message, "AlarmThreadManager", "LoadAlarmsLastStates"); } try { var tagId = Convert.ToInt32(tagjson.Id); var alarms = Convert.ToString(alarm.Alarms); if (alarms != null && alarms != "") { var alarm_ = new AlarmThreadManagerConfig(); var _props = _json.Deserialize(alarms, alarm_.GetType()); alarm_ = (AlarmThreadManagerConfig)_props; if (alarm_.Enabled) { alarm_.TagId = Convert.ToInt32(tagjson.Id); alarm_.Tag = tag; if (alarm_.Sound) { _soundalarms.Add(tagId); } if (alarm_.HihiSeverity == null) { alarm_.HihiSeverity = Double.MaxValue; } if (alarm_.HiSeverity == null) { alarm_.HiSeverity = Double.MaxValue; } if (alarm_.LoSeverity == null) { alarm_.LoSeverity = Double.MinValue; } if (alarm_.LoloSeverity == null) { alarm_.LoloSeverity = Double.MinValue; } _cfgs.Add(alarm_); } logger.Logged("Info", "Конфигурация тревоги [" + tag.PollerId + "][" + tag.TagName + "] добавлена...", "AlarmThreadManager", "LoadAlarmsLastStates"); } } catch (Exception ex) { logger.Logged("Err", "Неверная конфигурация тревоги [" + tag.PollerId + "][" + tag.TagName + "] : " + ex.Message, "AlarmThreadManager", "LoadAlarmsLastStates"); } } } }