| | |
|---|
| | | return num; |
|---|
| | | } |
|---|
| | | //锁的告警历史记录 |
|---|
| | | public List<LockHis> getLockAlmHisList(LockAlarmHis his) { |
|---|
| | | public List<LockAlarmHis> getLockAlmHisList(LockAlarmHis his) { |
|---|
| | | String sql="SELECT * FROM db_lock_alarm."+ his.getRecordYear()+" history " + |
|---|
| | | " where history.lock_id="+ his.getLockId() ; |
|---|
| | | if(his.getStartTime()!=null){ |
|---|
| | |
|---|
| | | sql+=" and alm_start_time <='"+ThreadLocalUtil.format(his.getEndTime(),1)+"' "; |
|---|
| | | } |
|---|
| | | sql+=" ORDER BY alm_start_time asc limit "+ his.getLimitStart()+","+ his.getLimitEnd()+" "; |
|---|
| | | List<LockHis> list=sqlExecuteService.executeQuery_call(sql, new CallBack() { |
|---|
| | | List<LockAlarmHis> list=sqlExecuteService.executeQuery_call(sql, new CallBack() { |
|---|
| | | @Override |
|---|
| | | public List getResults(ResultSet rs) throws SQLException { |
|---|
| | | List list=new ArrayList(); |
|---|
