给已审批的设备查询出连接数

81041

2018-12-19 fa91c2f8661fffdeddb5cd447a783f00b0dbd2ae

给已审批的设备查询出连接数

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/actions/Battinf_applyAction.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl$1.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl$2.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl$3.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl$4.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl$5.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl$6.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl$7.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/Battinf_applyImpl.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/services/Battinf_applyService.class

Binary files differ

 gx_tieta/src/com/fgkj/actions/Battinf_applyAction.java

@@ -52,6 +52,12 @@
        result=tojson(model);

        return SUCCESS;

    }

    //申请表中已审批通过的设备连接数

    public String devCommNum(){

        ServiceModel model=service.devCommNum();

        result=tojson(model);

        return SUCCESS;

    }

    //查询出审核完的申请和待审核的申请

    public String serchByInfo(){

        Battinf_apply bapply=ActionUtil.getGson().fromJson(json, Battinf_apply.class);


 gx_tieta/src/com/fgkj/dao/impl/Battinf_applyImpl.java

@@ -22,6 +22,8 @@
import com.fgkj.dto.Page;

import com.fgkj.dto.User_inf;

import com.fgkj.dto.User_log;

import com.fgkj.dto.ram.FBS9100;

import com.fgkj.dto.ram.Fbs9100_state;

import com.fgkj.services.User_logService;



public class Battinf_applyImpl implements BaseDAO,CallBack{

@@ -542,7 +544,34 @@
            return false;

        }

    }



    //申请表中已审批通过的设备连接数

    public List devCommNum() {

        String sql=" select  distinct db_battinf.tb_battinf_apply.FbsDeviceId,dev_commcount " +

                " from db_battinf.tb_battinf_apply,db_ram_db.tb_fbs9100_state " +

                " where apply_en=1  and db_battinf.tb_battinf_apply.FbsDeviceId=db_ram_db.tb_fbs9100_state.dev_id "

            +   " order by apply_date desc" ;

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), null, new CallBack() {

			
            @Override

            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()) {

                        Fbs9100_state fbs=new Fbs9100_state();

                        fbs.setDev_id(rs.getInt("FbsDeviceId"));

                        fbs.setDev_commcount(rs.getInt("dev_commcount"));

                        list.add(fbs);

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        return list;

		
    }

    public static void main(String[] args) throws ParseException {

        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

        Date date1 = sdf.parse("2000-01-01 00:00:00");

@@ -607,7 +636,11 @@
        System.out.println(station_id);

        int battgroup_id=BattinfGroupFactory.searchMaxBattgroupId();

        System.out.println(battgroup_id);*/

        boolean bl=bimpl.judgeBattInOrNot(binf);

        System.out.println(bl);

        /*boolean bl=bimpl.judgeBattInOrNot(binf);

        System.out.println(bl);*/

        /*List<Fbs9100_state> list=bimpl.devCommNum();

        for (Fbs9100_state f : list) {

            System.out.println(f.getDev_id()+"   "+f.getDev_commcount());

        }*/

    }

}


 gx_tieta/src/com/fgkj/services/Battinf_applyService.java

@@ -90,6 +90,19 @@
        }

        return model;

    }

    //申请表中已审批通过的设备连接数

    public ServiceModel devCommNum(){

        List list=((Battinf_applyImpl)dao).devCommNum();

        if(list!=null&&list.size()>0){

            model.setCode(1);

            model.setData(list);

            model.setMsg("查询成功!");

        }else{

            model.setCode(0);

            model.setMsg("查询失败!");

        }

        return model;

    }

    //申请人修改待审核的申请时的查询

    public ServiceModel serchbystationId(Object obj){

        List list=((Battinf_applyImpl)dao).serchbystationId(obj);