| | |
|---|
| | | "FROM web_site.tb_badbatt_mon,db_battinf.tb_battinf " +
|
|---|
| | | "where web_site.tb_badbatt_mon.battgroupid=db_battinf.tb_battinf.BattGroupId " +
|
|---|
| | | "and test_starttime>=? and test_starttime<=? " +
|
|---|
| | | "and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ?";
|
|---|
| | | "and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ? ";
|
|---|
| | |
|
|---|
| | | //选取蓄电池组条件
|
|---|
| | | String idSqlT=" and db_battinf.tb_battinf.battgroupid!=? ";
|
|---|
| | |
|---|
| | | sql=baseSql+endSql+limitSql;
|
|---|
| | | //System.out.println(sql);
|
|---|
| | | List<Batt_Maint_Dealarm> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{
|
|---|
| | | binf.getBattProductDate(),binf.getBattProductDate1(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%",
|
|---|
| | | binf.getBattProductDate(),binf.getBattProductDate1(),"%"+binf.getStationName1()+"%","%"+binf.getStationName()+"%","%"+binf.getStationName2()+"%",
|
|---|
| | | binf.getBattGroupId(),uinf.getUId(),
|
|---|
| | | (page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|---|
| | |
|
|---|
