| | |
|---|
| | | ",db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.StationName1 " +
|
|---|
| | | " FROM web_site.tb_battpower_off,db_battinf.tb_battinf " +
|
|---|
| | | " WHERE tb_battpower_off.dev_id=db_battinf.tb_battinf.FBSDeviceId " +
|
|---|
| | | " AND db_battinf.tb_battinf.StationName LIKE ? " +
|
|---|
| | | " AND db_battinf.tb_battinf.StationName LIKE ? AND db_battinf.tb_battinf.StationName2 LIKE ? " +
|
|---|
| | | " AND poweroff_starttime>=? " +
|
|---|
| | | " AND poweroff_starttime<=? ";
|
|---|
| | | //实时还是历史
|
|---|
| | |
|---|
| | | //分页
|
|---|
| | | String limitSql=" limit ?,?";
|
|---|
| | | sql+=limitSql;
|
|---|
| | | List<BattPower_off> list = DAOHelper.executeQueryLimit(sql, conn, new Object[]{"%"+binf.getStationName()+"%",binf.getBattProductDate(),binf.getBattProductDate1()
|
|---|
| | | List<BattPower_off> list = DAOHelper.executeQueryLimit(sql, conn, new Object[]{"%"+binf.getStationName()+"%","%"+binf.getStationName2()+"%",binf.getBattProductDate(),binf.getBattProductDate1()
|
|---|
| | | ,binf.getNum(),uinf.getUId(),"%"+binf.getStationName1()+"%",(page.getPageCurr() - 1)*page.getPageSize(),
|
|---|
| | | page.getPageSize()}, new CallBack() {
|
|---|
| | |
|
|---|
