首页显示已安装机房数和全部机房数

81041

2018-11-21 99b241c6da40c9eefe6ecb0479ae2e4a3809034f

首页显示已安装机房数和全部机房数

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

@@ -385,6 +385,13 @@
        result = ActionUtil.tojson(model);

        return SUCCESS;

    }

    //首页上显示已安装数和全部基站数

    public String serchDevice(){

        User_inf uinf=(User_inf) getUser();

        ServiceModel model = service.serchDevice(uinf);

        result = ActionUtil.tojson(model);

        return SUCCESS;

    }

    

    public BattInf getBif() {

        return bif;


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

@@ -1047,7 +1047,7 @@
        return list;

    }



    //查设备总数

    //查设备总数(已经安装)

    /*public int serchByDeviceId(){

        String sql=" SELECT COUNT(DISTINCT fbsdeviceid) number FROM db_battinf.tb_battinf  limit 1";

        List<BattInf> list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{}, new CallBack() {

@@ -1106,6 +1106,39 @@
        }

        return number;

    }

    //查询设备总数(全部)

    public int serchByDeviceId_all(Object obj){

        User_inf uinf=(User_inf) obj;

        String sql=" SELECT COUNT(DISTINCT fbsdeviceid) number FROM db_battinf.tb_battinf  " +

                    " left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId " +

                    " left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +

                    " left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +

                    " where db_user.tb_user_inf.uid=?  " +

                    " limit 1";

        List<BattInf> list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {

			
            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()){

                        BattInf binf=new BattInf();

                        binf.setNum(rs.getInt("number"));

                        list.add(binf);

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

			
        });

        int number=0;//存放总数

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

            number=list.get(list.size()-1).getNum();

        }

        return number;

    }

    //-----------根据蓄电池组查不重复的MonCount(monNum)（单体编号）

    public List serchByMonNum(Object obj){

        BattInf bif = (BattInf) obj;


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

@@ -23,6 +23,7 @@
import com.fgkj.dao.impl.Batttestdata_infDAOImpl;

import com.fgkj.dao.impl.BatttestdatastopDAOImpl;

import com.fgkj.dao.impl.Process_surveyImpl;

import com.fgkj.dao.impl.ram.Bts_station_stateImpl;

import com.fgkj.dao.impl.ram.Fbs9100_setparamImpl;

import com.fgkj.db.DBUtil;

import com.fgkj.dto.App_Sys;

@@ -35,6 +36,7 @@
import com.fgkj.dto.Page;

import com.fgkj.dto.Process_survey;

import com.fgkj.dto.ServiceModel;

import com.fgkj.dto.User_inf;



public class BattInfServices {

    private ServiceModel model;

@@ -969,6 +971,15 @@
        }

        return model;

    }

    //首页上显示已安装数和全部基站数

    public ServiceModel serchDevice(Object obj){

        int devNum=(new BattInfImpl()).serchByDeviceId(obj);        //总设备数(已安装)

        int allNum=(new BattInfImpl()).serchByDeviceId_all(obj);        //总设备数(全部)

        model.setSum(allNum);

        model.setNewsum(devNum);

        return model;

    }



    public static void main(String[] args) {

        //new BattInfServices().findMenu();

        BattInf b=new BattInf();

@@ -1013,14 +1024,18 @@
        //bs.searchInform(bmd);

        //bs.serchByBattGroupName(b);

        //bs.updateIp(b);

        ServiceModel model=bs.serchMakeGroup(b);

        /*ServiceModel model=bs.serchMakeGroup(b);

        List<BattInf> list=(List) model.getData();

        for (BattInf binf : list) {

            List<Batttestdatastop> list_sdata=(List) binf.getObj();

            for (Batttestdatastop s : list_sdata) {

                System.out.println(s);

            }

         }

         }*/

        //BattTestData.run_cmd(BattTestData.STRCMD);

        User_inf uinf=new User_inf();

        uinf.setUId(1002);

        ServiceModel model=bs.serchDevice(uinf);

        System.out.println(model);

        }

    }