| | |
|---|
| | | //批量设置放电参数时，根据省市区，电池单体型号（伏数），组数筛选出电池组
|
|---|
| | | public List serchByDischarge(Object obj) {
|
|---|
| | | BattInf binf=(BattInf) obj;
|
|---|
| | | Page page=binf.getPage();
|
|---|
| | | Connection conn=DBUtil.getConn();
|
|---|
| | | String numberSql=" SELECT FOUND_ROWS() number";
|
|---|
| | | String sql=" select SQL_CALC_FOUND_ROWS * from db_battinf.tb_battinf "
|
|---|
| | | + " where StationName1 like ? and StationName2 like ? and StationName3 like ? and StationName5 like ? "
|
|---|
| | | + " and GroupIndexInFBSDevice=? and MonVolStd=? "
|
|---|
| | | + " order by StationId asc,GroupIndexInFBSDevice asc ";
|
|---|
| | | List<BattInf> list=DAOHelper.executeQueryLimit(sql, conn, new Object[] {"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%","%"+binf.getStationName5()+"%",binf.getGroupIndexInFBSDevice(),binf.getMonVolStd()}, new CallBack() {
|
|---|
| | | + " order by StationId asc,GroupIndexInFBSDevice asc "
|
|---|
| | | + " limit ?,? ";
|
|---|
| | | List<BattInf> list=DAOHelper.executeQueryLimit(sql, conn, new Object[] {"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%","%"+binf.getStationName5()+"%",binf.getGroupIndexInFBSDevice(),binf.getMonVolStd(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | @Override
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
