| | |
|---|
| | | " ,"+AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPUP_ComError_ID+","+AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID+","+AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPUP_ComError_ID+","+AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID+") " +
|
|---|
| | | " and alm_start_time>=? and alm_start_time<=? " +
|
|---|
| | | " and stationname1 like ? and stationname2 like ? and stationname3 like ? and stationid like ? " ;
|
|---|
| | | //异常类型筛选
|
|---|
| | | String alm_typeSqlT=" and alm_type!=? ";
|
|---|
| | | String alm_typeSqlF=" and alm_type=? ";
|
|---|
| | | if(binf.getNum()==0){
|
|---|
| | | sql+=alm_typeSqlT;
|
|---|
| | | }else{
|
|---|
| | | sql+=alm_typeSqlF;
|
|---|
| | | }
|
|---|
| | | //排序
|
|---|
| | | String orderSql=" order by dev_id,alm_start_time,alm_type asc ";
|
|---|
| | | sql+=orderSql;
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | //binf.getBattInUseDate(),binf.getBattInUseDate1(),"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%","%"+binf.getStationId()+"%",
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getBattInUseDate(),binf.getBattInUseDate1(),"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%","%"+binf.getStationId()+"%",binf.getNum()}, new CallBack() {
|
|---|
| | | List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getBattInUseDate(),binf.getBattInUseDate1(),"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%","%"+binf.getStationId()+"%"}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
