| | |
| | | " where tb_battgroup_baojigroup.baoji_group_id=tb_battgroup_usr.baoji_group_id" + |
| | | " and uid="+dto.getUid()+ |
| | | ")"; |
| | | sql+=" order by alm_starttime desc "; |
| | | List list = sqlExecuteService.executeQuery_call(sql, new CallBack() { |
| | | @Override |
| | | public List getResults(ResultSet rs) throws SQLException { |
| | |
| | | " where tb_battgroup_baojigroup.baoji_group_id=tb_battgroup_usr.baoji_group_id" + |
| | | " and uid="+dto.getUid()+ |
| | | ")"; |
| | | sql+=" ORDER BY alm_starttime asc limit "+dto.getLimitStart()+","+dto.getLimitEnd()+" "; |
| | | sql+=" ORDER BY alm_starttime desc limit "+dto.getLimitStart()+","+dto.getLimitEnd()+" "; |
| | | List list = sqlExecuteService.executeQuery_call(sql, new CallBack() { |
| | | @Override |
| | | public List getResults(ResultSet rs) throws SQLException { |
| | |
| | | DevalarmDataYear dataYear=new DevalarmDataYear(); |
| | | dataYear.setNum(rs.getInt("num")); |
| | | dataYear.setDevId(rs.getInt("dev_id")); |
| | | dataYear.setAlmId(rs.getInt("alm_id")); |
| | | dataYear.setAlmSignalId(rs.getInt("alm_signal_id")); |
| | | dataYear.setAlmStarttime(rs.getTimestamp("alm_starttime")); |
| | | dataYear.setAlmValue(rs.getFloat("alm_value")); |