设备实时告警筛选出已安装的设备

81041

2018-11-01 05cf9f772d0fbbd761a462d70fbeeaed054eba0b

 gx_tieta/src/com/fgkj/dao/impl/Batt_devalarm_dataImpl.java

@@ -309,7 +309,7 @@
            " db_battinf.tb_battinf.stationName,db_battinf.tb_battinf.stationName5,db_battinf.tb_battinf.FbsDeviceName  " +

            " FROM db_alarm.tb_devalarm_data,db_battinf.tb_battinf " +

            " WHERE  " +

            " tb_devalarm_data.dev_id=db_battinf.tb_battinf.FbsDeviceId " ;

            " tb_devalarm_data.dev_id=db_battinf.tb_battinf.FbsDeviceId  and tb_battinf.station_intall=1 " ;

      //设备实时告警

      String alarmTypeSql=" AND alm_cleared_type=0 ";

      baseSql+=alarmTypeSql;