修改

whyclxw

2024-07-01 0ce771b4a4ff5897dc91bb1b84a4561781b00ca5

 src/main/java/com/whyc/service/SubTablePageInfoService.java

@@ -133,7 +133,7 @@
    public int getCountForBreakAlm(BreakAlarmDto alm) {
        String sql="select  count(distinct  breakAlarm.num) as number from db_ckpwrdev_break_alarm." +alm.getRecordYear()+" breakAlarm ,db_ckpwrdev_break_alarm.tb_ckpowerdev_break_alarm_config,db_ckpwrdev_inf.tb_breaker_inf"
                +" where   breakAlarm.alm_id=tb_ckpowerdev_break_alarm_config.alm_id " +
                "            and tb_ckpowerdev_break_alarm_config.break_id=tb_breaker_inf.breaker_id ";
                "            and tb_ckpowerdev_break_alarm_config.breaker_id=tb_breaker_inf.breaker_id ";
        if(alm.getAlmStarttime()!=null){
            sql+=" and alm_starttime  >='"+ DateUtil.format_YYYY_MM_DD_HH_MM_SS(alm.getAlmStarttime())+"' ";
        }
@@ -173,7 +173,7 @@
    public List getListBreakAlm(BreakAlarmDto alm){
        String sql="select  breakAlarm.*,breaker_type,breaker_name,breaker_addr from db_ckpwrdev_break_alarm." +alm.getRecordYear()+" breakAlarm,db_ckpwrdev_break_alarm.tb_ckpowerdev_break_alarm_config,db_ckpwrdev_inf.tb_breaker_inf"
                +" where   breakAlarm.alm_id=tb_ckpowerdev_break_alarm_config.alm_id " +
                "            and tb_ckpowerdev_break_alarm_config.break_id=tb_breaker_inf.breaker_id ";
                "            and tb_ckpowerdev_break_alarm_config.breaker_id=tb_breaker_inf.breaker_id ";
        if(alm.getAlmStarttime()!=null){
            sql+=" and alm_starttime  >='"+ DateUtil.format_YYYY_MM_DD_HH_MM_SS(alm.getAlmStarttime())+"' ";
        }