Exemple #1
0
        public void AddEvent(Event evt)
        {
            try
               {
               hsEvent.Add(evt.EventId, evt);
               evt.OnStop += new EventHandler(eventobj_OnStop);
               evt.OnRangeChange += new EventHandler(eventobj_OnRangeChange);
               evt.OnDegreeChange += new EventHandler(eventobj_OnDegreeChange);
               evt.OnReNewEvent += new EventHandler(evt_OnReNewEvent);
               evt.OnAbort += new EventHandler(evt_OnAbort);
               if (!evt.IsReload)
               {
                   InsertAlarmTable(evt);
                   evt.setEventStatus((int)EventStatus.Alarm);
               }
               else  //事件還原
               {
                 evt.setEventStatus((int)evt.getEventStatus());
                 evt.IsReload = false;
               }

               if(evt.IsLock)
                 Program.matrix.cctvmgr.setLock(evt);
               Program.notifyServer.NotifyAll(new NotifyEventObject( EventEnumType.NEW_RSP_EVENT,"HOST",evt.EventId));
               }
               catch (Exception ex)
               {
               ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace);
               }
        }
Exemple #2
0
 public void AddEvent(Event evt)
 {
     try
        {
        hsEvent.Add(evt.EventId, evt);
        evt.OnStop += new EventHandler(eventobj_OnStop);
        evt.OnRangeChange += new EventHandler(eventobj_OnRangeChange);
        evt.OnDegreeChange += new EventHandler(eventobj_OnDegreeChange);
        evt.OnReNewEvent += new EventHandler(evt_OnReNewEvent);
        evt.OnAbort += new EventHandler(evt_OnAbort);
        InsertAlarmTable(evt);
        evt.setEventStatus((int)EventStatus.Alarm);
        Program.notifyServer.NotifyAll(new NotifyEventObject( EventEnumType.NEW_RSP_EVENT,"HOST",evt.EventId));
        }
        catch (Exception ex)
        {
        ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace);
        }
 }
Exemple #3
0
        void RemoveEvent(Event evt)
        {
            //try
               //{

            if(hsEvent.Contains(evt.EventId))
            {
                evt.clearLstOutputQueueData();

               hsEvent.Remove(evt.EventId);
               evt.OnStop -= new EventHandler(eventobj_OnStop);
               evt.OnRangeChange -= new EventHandler(eventobj_OnRangeChange);
               evt.OnDegreeChange -= new EventHandler(eventobj_OnDegreeChange);
               evt.OnReNewEvent -= new EventHandler(evt_OnReNewEvent);
               evt.OnAbort -= new EventHandler(evt_OnAbort);
            }

               //}
               //catch (Exception ex)
               //{
               //    ConsoleServer.WriteLine(ex.Message);
               //}
              // InsertAlarm(evt);
        }
Exemple #4
0
        void InsertAlarmTable(Event evt)
        {
            string sql;
            //   if(! evt.IsReNew)
               if (evt is Host.Event.Jam.JamRange )
               {

               sql = "insert into tblSysAlarmLog (EVENTID,ALARMCLASS,TIMESTAMP,LINEID,DIRECTION,START_MILEAGE,END_MILEAGE,DEGREE,OriginalEventID,DeviceName) values({0},{1},'{2}','{3}','{4}',{5},{6},{7},{8},'{9}')";
               sql = string.Format(sql, evt.EventId, evt.EventClass, RemoteInterface.DbCmdServer.getTimeStampString(DateTime.Now), evt.getLineId(),
                   evt.getDir(), evt.getStartMileM(), evt.getEndMileM(), evt.getDegree(), evt.OrgEventId,(evt  as  Jam.JamRange).DeviceName);
               }
               else if(evt is Host.Event.Jam.RampJamRange)
               {
               sql = "insert into tblSysAlarmLog (EVENTID,ALARMCLASS,TIMESTAMP,LINEID,DIRECTION,START_MILEAGE,END_MILEAGE,DEGREE,OriginalEventID,DivisionID,DeviceName) values({0},{1},'{2}','{3}','{4}',{5},{6},{7},{8},'{9}','{10}')";
               sql =string.Format(sql, evt.EventId, evt.EventClass, RemoteInterface.DbCmdServer.getTimeStampString(DateTime.Now), evt.getLineId(),
                   evt.getDir(), evt.getStartMileM(), evt.getEndMileM(), evt.getDegree(), evt.OrgEventId, (evt as Jam.RampJamRange).rampVDData.divisionId, (evt as Jam.RampJamRange).rampVDData.deviceName);
               }

               else if(evt is Host.Event.MovingConstruct.MovingConstructRange)
               {
                 sql = "insert into tblSysAlarmLog (EVENTID,ALARMCLASS,TIMESTAMP,LINEID,DIRECTION,START_MILEAGE,END_MILEAGE,OriginalEventID,mc_id,mc_notifier,mc_blocktypeid,mc_blocklane,mc_memo) values({0},{1},'{2}','{3}','{4}',{5},{6},{7},{8},'{9}',{10},'{11}','{12}')";
               sql =string.Format(sql, evt.EventId, evt.EventClass, RemoteInterface.DbCmdServer.getTimeStampString(DateTime.Now), evt.getLineId(),
                   evt.getDir(), evt.getStartMileM(), evt.getEndMileM(),  evt.OrgEventId,
                   (evt as MovingConstruct.MovingConstructRange).id, (evt as MovingConstruct.MovingConstructRange).notifier, (evt as MovingConstruct.MovingConstructRange).blockTypeId,

                    (evt as MovingConstruct.MovingConstructRange).blocklane, (evt as MovingConstruct.MovingConstructRange).description);
               }

               else if(evt is Host.Event.Weather.WeatherRange)

               {

            sql = "insert into tblSysAlarmLog (EVENTID,ALARMCLASS,TIMESTAMP,LINEID,DIRECTION,START_MILEAGE,END_MILEAGE,DEGREE,OriginalEventID,DeviceName) values({0},{1},'{2}','{3}','{4}',{5},{6},{7},{8},'{9}')";
            sql=string.Format(sql,evt.EventId, evt.EventClass, RemoteInterface.DbCmdServer.getTimeStampString(DateTime.Now), evt.getLineId(),
                   evt.getDir(), evt.getStartMileM(), evt.getEndMileM(), evt.getDegree(), evt.OrgEventId,((Host.Event.Weather.WeatherRange)evt).DeviceName);

               }
               else if (evt is Host.Event.TEM.TemRangeData)
               {
               sql = (evt as Host.Event.TEM.TemRangeData).getSQL_tInsertAlarmData();

               }
               else if(evt is Host.Event.IID.IIDRange)
               {
               Host.Event.IID.IIDRange iidevt = evt as Host.Event.IID.IIDRange;
               sql = "insert into tblSysAlarmLog (EVENTID,ALARMCLASS,TIMESTAMP,LINEID,DIRECTION,START_MILEAGE,END_MILEAGE,DEGREE,OriginalEventID,CAM_ID,LANE_ID) values({0},{1},'{2}','{3}','{4}',{5},{6},{7},{8},{9},{10})";
               sql = string.Format(sql, iidevt.EventId, iidevt.EventClass, RemoteInterface.DbCmdServer.getTimeStampString(DateTime.Now), iidevt.getLineId(),
                          iidevt.getDir(), iidevt.getStartMileM(), iidevt.getEndMileM(), iidevt.getDegree(), iidevt.OrgEventId,iidevt.Cam_ID,iidevt.Lane_Id);
               }
               else
               {

               sql = "insert into tblSysAlarmLog (EVENTID,ALARMCLASS,TIMESTAMP,LINEID,DIRECTION,START_MILEAGE,END_MILEAGE,DEGREE,OriginalEventID) values({0},{1},'{2}','{3}','{4}',{5},{6},{7},{8})";
               sql = string.Format(sql, evt.EventId, evt.EventClass, RemoteInterface.DbCmdServer.getTimeStampString(DateTime.Now), evt.getLineId(),
                      evt.getDir(), evt.getStartMileM(), evt.getEndMileM(), evt.getDegree(), evt.OrgEventId);

               }
               try
               {
               System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Global.Db2ConnectionString);
               System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand(sql);

               cmd.Connection = cn;
               try
               {
                   cn.Open();
                   cmd.ExecuteNonQuery();

               }
               catch(Exception ex)
               {
                   Util.SysLog("evtlerr.log",ex.Message+","+ex.StackTrace);
               }

               finally
               {
                   cn.Close();
               }

            //   Program.matrix.dbServer.SendSqlCmd(sql);
               }
               catch (Exception ex)
               {
               ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace);
               }
        }