| | |
|---|
| | | ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,MonVolLowToAvg,BattProducer,BattModel,BattProductDate,BattInUseDate,Load_curr,install_user,DisCurrMax,station_phone "
|
|---|
| | | + ",longitude,latitude,address " +
|
|---|
| | | " from db_battinf.tb_battinf_apply " +
|
|---|
| | | " where apply_en=? order by apply_date desc" +
|
|---|
| | | " limit ?,? ";
|
|---|
| | | List<Battinf_apply> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{bapply.getApply_en(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|---|
| | | " where ";
|
|---|
| | | //未审批
|
|---|
| | | if(bapply.getApply_en()==0) {
|
|---|
| | | sql+=" apply_en=? and check_en!=? ";
|
|---|
| | | }else {
|
|---|
| | | sql+=" apply_en=? and check_en=? ";
|
|---|
| | | }
|
|---|
| | | sql+=" order by apply_date desc limit ?,?";
|
|---|
| | | List<Battinf_apply> list=DAOHelper.executeQueryLimit(sql, conn, new Object[]{bapply.getApply_en(),bapply.getCheck_en(),(page.getPageCurr()-1)*page.getPageSize(),page.getPageSize()}, new CallBack() {
|
|---|
| | |
|
|---|
| | | public List getResults(ResultSet rs) {
|
|---|
| | | List list=new ArrayList();
|
|---|
| | |
|---|
| | | Battinf_apply bapply=new Battinf_apply();
|
|---|
| | | bapply.setApply_date(ActionUtil.getSimpDate(date2));
|
|---|
| | | bapply.setApply_uid(1004);
|
|---|
| | | |
|---|
| | | bapply.setApply_en(1);
|
|---|
| | | bapply.setCheck_en(1);
|
|---|
| | |
|
|---|
| | | BattInf binf=new BattInf();
|
|---|
| | | binf.setStationName("广西省-百色-GX百色乐业县立新小区WF-BTS设备");
|
|---|
| | |
|---|
| | |
|
|---|
| | | Page page=new Page();
|
|---|
| | | page.setPageCurr(1);
|
|---|
| | | page.setPageSize(10);
|
|---|
| | | page.setPageSize(20);
|
|---|
| | | binf.setPage(page);
|
|---|
| | | bapply.setBinf(binf);
|
|---|
| | | /*List list=bimpl.serchByCondition(page);
|
|---|
| | | System.out.println(list.size());*/
|
|---|
| | | List list=bimpl.serchByCondition(bapply);
|
|---|
| | | System.out.println(list.size());
|
|---|
| | | /*List list=new ArrayList();
|
|---|
| | | list.add(bapply);
|
|---|
| | | boolean bl=bimpl.add(list);
|
|---|
| | |
|---|
| | | for (Fbs9100_state f : list) {
|
|---|
| | | System.out.println(f.getDev_id()+" "+f.getDev_commcount());
|
|---|
| | | }*/
|
|---|
| | | List list=bimpl.serchById(bapply);
|
|---|
| | | System.err.println(list.size());
|
|---|
| | | /*List list=bimpl.serchById(bapply);
|
|---|
| | | System.err.println(list.size());*/
|
|---|
| | | }
|
|---|
| | | }
|
|---|
