| | |
|---|
| | | sqlT+=station2SqlF;
|
|---|
| | | sqlE+=station2SqlF;
|
|---|
| | | }
|
|---|
| | | //用于区县
|
|---|
| | | String station5SqlT=" and stationname5!=? ";//全部
|
|---|
| | | String station5SqlF=" and stationname5=? ";
|
|---|
| | | if(binf.getStationName5().equals("")){
|
|---|
| | | sqlT+=station5SqlT;
|
|---|
| | | sqlE+=station5SqlT;
|
|---|
| | | }else{
|
|---|
| | | sqlT+=station5SqlF;
|
|---|
| | | sqlE+=station5SqlF;
|
|---|
| | | }
|
|---|
| | | //按照battgroupid排序
|
|---|
| | | String tendSql=" order by db_batt_testdata.tb_batttestdatastop_"+binf.getBattGroupId()+".test_record_count asc,db_batt_testdata.tb_batttestdatastop_" +binf.getBattGroupId()+".mon_num asc ";
|
|---|
| | | String eendSql=" order by db_batt_testdata.tb_battresdata_"+binf.getBattGroupId()+".test_record_count asc,db_batt_testdata.tb_battresdata_" +binf.getBattGroupId()+".mon_num asc ";
|
|---|
| | |
|---|
| | | if(tdata.getTest_type()==BattTestData.BATT_DISCHARGE){
|
|---|
| | | sql=sqlT;
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getBattGroupId(),tdata.getTest_type(),binf.getMonNum(),binf.getStationName1(),binf.getStationName2(),binf.getStationName()},new BattinfThirdImpl());
|
|---|
| | | list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getBattGroupId(),tdata.getTest_type(),binf.getMonNum(),binf.getStationName1(),binf.getStationName2(),binf.getStationName5(),binf.getStationName()},new BattinfThirdImpl());
|
|---|
| | | }else if(tdata.getTest_type()==BattTestData.BATT_RES){
|
|---|
| | | sql=sqlE;
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getBattGroupId(),tdata.getTest_type(),binf.getMonNum()*10+1,binf.getStationName1(),binf.getStationName2(),binf.getStationName()},new CallBack() {
|
|---|
| | | list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getBattGroupId(),tdata.getTest_type(),binf.getMonNum()*10+1,binf.getStationName1(),binf.getStationName2(),binf.getStationName5(),binf.getStationName()},new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
