机房判断是否存在

81041

2019-01-07 f330e96565000d3e3ce16dce0b255ac6956baca8

机房判断是否存在

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

Binary files differ

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

Binary files differ

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

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$10.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$11.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$12.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$13.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$14.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$15.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$16.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$17.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$18.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$19.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$20.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$21.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$22.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$23.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$24.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$25.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$26.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$27.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$28.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$29.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$30.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$31.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$32.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$33.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$34.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$35.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$36.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$37.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$38.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$39.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$40.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$41.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$42.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$43.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$44.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$45.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$46.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$47.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$48.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$49.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$50.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$51.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$52.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$53.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$54.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$55.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$56.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$57.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$58.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$59.class

Binary files differ

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

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$60.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$61.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$62.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$63.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$64.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$65.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$66.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$67.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$68.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$69.class

Binary files differ

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

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$70.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$71.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$8.class

Binary files differ

 gx_tieta/WebRoot/WEB-INF/classes/com/fgkj/dao/impl/BattInfImpl$9.class

Binary files differ

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

Binary files differ

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

Binary files differ

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

Binary files differ

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

Binary files differ

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

Binary files differ

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

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

        return SUCCESS;

    }

     //判断新增的机房是否存在

    public String judgeBattInOrNot(){

        BattInf binf=getGson().fromJson(json, BattInf.class);

        ServiceModel model = service.judgeBattInOrNot(binf);

        result = ActionUtil.tojson(model);

        return SUCCESS;

    }

    public BattInf getBif() {

        return bif;

    }


 gx_tieta/src/com/fgkj/actions/ram/Fbs9100_sysparamAction.java

@@ -53,6 +53,14 @@
        result = tojson(model);

        return SUCCESS;

    }

    //批量设置系统参数时，根据省市区，电池单体型号（伏数），组数筛选出电池组并读取它的实际系统参数

    public String serchBattinfAndParam() {

        BattInf binf=getGson().fromJson(json, BattInf.class);

        ServiceModel model = service.serchBattinfAndParam(binf);

        result = tojson(model);		
        return SUCCESS;	
    }

		
    

    public String getResult() {

        return result;


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

@@ -155,7 +155,7 @@
                " where db_user.tb_user_battgroup_baojigroup_battgroup.BattGroupId=db_battinf.tb_battinf.BattGroupId  " +

                " 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_user.tb_user_inf.uid=? and db_battinf.tb_battinf.Station_install=1 ) " ;

        //System.out.println(sql);

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

            


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

@@ -460,10 +460,11 @@
        }

        return dev_id;

    }

    //判断新增的电池组是否存在

    //判断新增的机房是否存在

    public List judgeBatt(Object obj){

        BattInf binf=(BattInf) obj;

        String sql="select distinct stationid from db_battinf.tb_battinf where stationname=? limit 1";

        String sql="select distinct(StationId) "

                 + "from db_battinf.tb_battinf where stationname=? limit 1";

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getStationName()}, new CallBack() {

            

            public List getResults(ResultSet rs) {

@@ -482,7 +483,8 @@
        });

        return list;

    }

     //判断新增的电池组是否存在

	
     //判断新增的机房是否存在

    public boolean judgeBattInOrNot(Object obj){

        BattInf binf=(BattInf) obj;

        String sql="select distinct stationid from db_battinf.tb_battinf where stationname=? limit 1";

@@ -4601,7 +4603,7 @@
        BattInf binf = new BattInf();

        binf.setNum(2);

        binf.setBattGroupId(1000001);

        binf.setStationName("百色");

        binf.setStationName("广西省-玉林-玉林玉州区西城里-BTS设备");

        binf.setStationName1("");

        binf.setStationName2("");

        binf.setStationName3("");

@@ -4649,15 +4651,17 @@
        System.out.println(nums);*/

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

        System.out.println(bl);*/

        List<BattInf> list=biml.serchByBatt_param(binf);

        /*List<BattInf> list=biml.serchByBatt_param(binf);

        for (BattInf b : list) {

            System.out.println(b);

        }

        }*/

        /*List<BattInf> list=biml.serchByDischarge(binf);

        for (BattInf b : list) {

            System.out.println(b);

        }*/

        System.out.println(list.size());

        boolean bl=biml.judgeBattInOrNot(binf);

        System.out.println(bl);

        //System.out.println(list.size());

    }

    

    public List getResults(ResultSet rs) {


 gx_tieta/src/com/fgkj/dao/impl/ram/Fbs9100_sysparamImpl.java

@@ -71,6 +71,13 @@
        boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sys.getDev_id()});

        return bl;

    }

    //查询系统参数前(如果没有默认数据要用REPLACE 添加一笔数据)同时发送命令

    public boolean replacePL(Object obj){

        Fbs9100_sysparam sys=(Fbs9100_sysparam) obj;

        String sql=" REPLACE  into db_ram_db.tb_fbs9100_sysparam(dev_id,op_cmd) values(?,?)";

        boolean bl=DAOHelper.executeUpdate(DBUtil.getConn(), sql, new Object[]{sys.getDev_id(),sys.getOp_cmd()});

        return bl;

    }

    public boolean del(Object obj) {

        // TODO Auto-generated method stub

        return false;


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

@@ -37,6 +37,7 @@
import com.fgkj.dto.Process_survey;

import com.fgkj.dto.ServiceModel;

import com.fgkj.dto.User_inf;

import com.sun.scenario.effect.Bloom;



public class BattInfServices {

    private ServiceModel model;

@@ -1054,6 +1055,19 @@
        }

        return model;

    }

    //判断新增的机房是否存在

    public ServiceModel judgeBattInOrNot(Object obj) {

        Boolean bl=((BattInfImpl)dao).judgeBattInOrNot(obj);

        if (bl) {

            model.setCode(1);

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

        }else{

            model.setCode(0);

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

        }

        return model;

    }



    public static void main(String[] args) {

        //new BattInfServices().findMenu();

        BattInf b=new BattInf();


 gx_tieta/src/com/fgkj/services/ram/Fbs9100_sysparamService.java

@@ -7,9 +7,13 @@
import com.fgkj.dao.BaseDAO;

import com.fgkj.dao.BaseDAOFactory;

import com.fgkj.dao.FBS9100_ComBase;

import com.fgkj.dao.impl.BattInfImpl;

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

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

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

import com.fgkj.dto.BattInf;

import com.fgkj.dto.ServiceModel;

import com.fgkj.dto.ram.Fbs9100_battparam;

import com.fgkj.dto.ram.Fbs9100_setparam;

import com.fgkj.dto.ram.Fbs9100_sysparam;



@@ -116,12 +120,89 @@
          }

          return model;    

      }



  //批量设置系统参数时，根据省市区，电池单体型号（伏数），组数筛选出电池组并读取它的实际系统参数

      public ServiceModel serchBattinfAndParam(Object obj) {

          List<BattInf> list=(new BattInfImpl()).serchByBatt_param(obj);

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

                Calendar c = Calendar.getInstance(); 
                //现在的时间(单位：毫秒) 
                long now_time = c.getTimeInMillis();

                long time=0;

                int success=0;

                int count=0;

                do {

                    for (int i = 0; i < list.size(); i++) {

                        BattInf binf=list.get(i);

                        Fbs9100_sysparam fbs_sys=new Fbs9100_sysparam();

                        fbs_sys.setDev_id(binf.getFBSDeviceId());

                            fbs_sys.setOp_cmd(FBS9100_ComBase.CMD_GetSYSSetParam);

                        if(count==0) {

                            fbs_sys.setDev_ip("127.0.0.0");

                            fbs_sys.setIPADDR("127.0.0.0");

                            fbs_sys.setSubIPADDR("127.0.0.0");

                            fbs_sys.setNetGateADDR("127.0.0.0");

                            fbs_sys.setGroupVolRange(0);

                            fbs_sys.setGroupVolSorce(0);

                            fbs_sys.setCurrentRange(0);

                            fbs_sys.setCurrentTyte(0);

                            fbs_sys.setMonomerOrder(0);

                            fbs_sys.setBackLightTime(0);

                            fbs_sys.setMACADDR("0.0.0.0.0.0");

                            fbs_sys.setLoaderCount(0);

                            fbs_sys.setDtCardCount(0);

                            fbs_sys.setPowerBreakChargeCurr(0);

                            fbs_sys.setMajorBattGroupNum(0);

                            fbs_sys.setPOF_BG_Boost_Cnt(0);

                            fbs_sys.setPOF_BG_Boost_VolStop(0);

                            fbs_sys.setPOF_BG_Boost_VolStart(0);

                              boolean bl=((Fbs9100_sysparamImpl)dao).replacePL(fbs_sys);

                              List listb=new ArrayList();

                              listb.add(fbs_sys);

                              list.get(i).setObj(listb);

                        }

                        if(binf.getNum()==0) {

                            boolean b=((Fbs9100_sysparamImpl)dao).getCmdAck(fbs_sys.getOp_cmd(), fbs_sys.getDev_id());

                            if(b) {

                                success+=1;

                                list.get(i).setNum(1);

                                List listbatt=dao.serchByCondition(fbs_sys);

                                list.get(i).setObj(listbatt);

                            }

                        }

                    }

                    count++;

                    if(success==list.size()) {

                        break;

                    }

                    Calendar cl = Calendar.getInstance(); 
                    long moment_time = cl.getTimeInMillis();

                    time=moment_time-now_time;

                }while(time<=5*1000);

                model.setData(list);

                model.setCode(1);

                model.setSum(success);

                model.setMsg("修改成功!");

          }else{

              model.setCode(0);

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

          }

          return model;

      }

    public static void main(String[] args) {

        Fbs9100_sysparamService fs=new Fbs9100_sysparamService();

        Fbs9100_sysparam sys=new Fbs9100_sysparam();

        sys.setDev_id(910000001);

        /*sys.setDev_id(910000001);

        ServiceModel model=fs.serchByCondition(sys);

        System.out.println(model);

        System.out.println(model);*/

        BattInf binf=new BattInf();

        binf.setNum(2);

        binf.setStationName("百色");

        //binf.setGroupIndexInFBSDevice(100);

        binf.setMonVolStd(12f);

        ServiceModel model=fs.serchBattinfAndParam(binf);

        List list=(List)model.getData();

        for (int i = 0; i < list.size(); i++) {

            System.out.println(((BattInf)list.get(i)).getObj());

        }

    }

}