中石化告警实时修改

lxw

2020-06-22 6664d0b7b88a0efda34622bea5befec6849930ac

中石化告警实时修改

 Device_Manage/src/com/fgkj/dao/impl/Battalarm_dataImpl.java

@@ -83,7 +83,8 @@
        String sql=" select SQL_CALC_FOUND_ROWS distinct db_alarm.tb_battalarm_data.battgroupid,alm_start_time,alm_id,db_alarm.tb_battalarm_data.monnum,alm_signal_id,alm_level  "
                + "  ,FBSDeviceId,BattGroupName "
                + "  from db_alarm.tb_battalarm_data,db_battinf.tb_battinf "
                + "  where db_alarm.tb_battalarm_data.battGroupId=db_battinf.tb_battinf.battGroupId  ";
                + "  where db_alarm.tb_battalarm_data.battGroupId=db_battinf.tb_battinf.battGroupId  "
                + "  and alm_id in(119001,119002,119003,119004,119005,119006,119007,119008,119010,119011) ";
                
        //用于用户管理的电池组的筛选
        String userSql=" and db_alarm.tb_battalarm_data.BattGroupId in(select distinct db_battinf.tb_battinf.battgroupid " +
@@ -174,7 +175,8 @@
        User_inf uinf=(User_inf) obj;;
        String sql=" select count(db_alarm.tb_battalarm_data.num) as number   "
                + "  from db_alarm.tb_battalarm_data,db_battinf.tb_battinf "
                + "  where db_alarm.tb_battalarm_data.battGroupId=db_battinf.tb_battinf.battGroupId  ";
                + "  where db_alarm.tb_battalarm_data.battGroupId=db_battinf.tb_battinf.battGroupId  "
                + "  and alm_id in(119001,119002,119003,119004,119005,119006,119007,119008,119010,119011)  ";
        //用于用户管理的电池组的筛选
        String userSql=" and db_alarm.tb_battalarm_data.BattGroupId in(select distinct db_battinf.tb_battinf.battgroupid " +
                " from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf   " +