| | |
|---|
| | | "tb_battdischarge_plan.discharge_state,tb_battdischarge_plan.discharge_reason,tb_battdischarge_plan.discharge_cleartype,tb_battdischarge_plan.note," +
|
|---|
| | | "tb_battdischarge_plan.preset_time,tb_battdischarge_plan.preset_cap,tb_battdischarge_plan.preset_monvol,tb_battdischarge_plan.preset_groupvol,tb_battdischarge_plan.preset_curr,tb_battdischarge_plan.preset_mon," +
|
|---|
| | | "tb_battdischarge_plan.dcvolhighlimit,tb_battdischarge_plan.chargecurrset, " +
|
|---|
| | | "db_battinf.tb_battinf.stationname1,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.battGroupName "+
|
|---|
| | | "db_battinf.tb_battinf.stationname1,db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationname5,db_battinf.tb_battinf.battGroupName "+
|
|---|
| | | "from web_site.tb_battdischarge_plan " +
|
|---|
| | | "left outer join db_battinf.tb_battinf on tb_battdischarge_plan.battgroupid=db_battinf.tb_battinf.battgroupid "+
|
|---|
| | | "where tb_battdischarge_plan.discharge_starttime>=? and tb_battdischarge_plan.discharge_starttime<=? " +
|
|---|
| | |
|---|
| | | " and db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +
|
|---|
| | | " and db_user.tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +
|
|---|
| | | " and db_user.tb_user_inf.uid=? " +
|
|---|
| | | " and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ?)";
|
|---|
| | | " and db_battinf.tb_battinf.stationname1 like ? and db_battinf.tb_battinf.stationname like ? and db_battinf.tb_battinf.stationname2 like ? and db_battinf.tb_battinf.stationname5 like ? )";
|
|---|
| | | baseSql+=userSql;
|
|---|
| | |
|
|---|
| | | String endSql="order by tb_battdischarge_plan.discharge_starttime desc ";
|
|---|
| | |
|---|
| | | "%"+binf.getStationName1()+"%",
|
|---|
| | | "%"+binf.getStationName()+"%",
|
|---|
| | | "%"+binf.getStationName2()+"%",
|
|---|
| | | "%"+binf.getStationName5()+"%",
|
|---|
| | | (bmd.getPage().getPageCurr() - 1)* bmd.getPage().getPageSize(),
|
|---|
| | | bmd.getPage().getPageSize()
|
|---|
| | | }, new CallBack() {
|
|---|
| | |
|---|
| | | BattDischarge_plan bplan=new BattDischarge_plan();
|
|---|
| | | binf.setStationName(rs.getString("stationName"));
|
|---|
| | | binf.setStationName1(rs.getString("stationName1"));
|
|---|
| | | binf.setStationName5(rs.getString("stationName5"));
|
|---|
| | | binf.setBattGroupName(rs.getString("battGroupName"));
|
|---|
| | |
|
|---|
| | | bplan.setNum(rs.getInt("num"));
|
|---|
