| | |
| | | } |
| | | //1.2.7优良电源统计上一季度的电源某一属性和参数阈值超过的次数 |
| | | public List<QuarterPwr7Res> getPwrQuarter7(String tableName) { |
| | | String sql=" select distinct record_datetime,acin1_vola,acout_vola,dcout_vol,dcout_curr " + |
| | | String sql=" select distinct record_datetime,acin1_vola,acout_curra,dcout_vol,dcout_curr " + |
| | | " from "+tableName+" " ; |
| | | sql+=" order by record_datetime asc"; |
| | | List<QuarterPwr7Res> list = sqlExecuteService.executeQuery_call(sql, new CallBack() { |
| | |
| | | QuarterPwr7Res data=new QuarterPwr7Res(); |
| | | data.setRecordDatetime(rs.getTimestamp("record_datetime")); |
| | | data.setAcin1Vola(rs.getFloat("acin1_vola")); |
| | | data.setAcoutVola(rs.getFloat("acout_vola")); |
| | | data.setAcoutCurra(rs.getFloat("acout_curra")); |
| | | data.setDcoutVol(rs.getFloat("dcout_vol")); |
| | | data.setDcoutCurr(rs.getFloat("dcout_curr")); |
| | | list.add(data); |