bts设备放电

81041

2018-11-03 35e4b9b72819b2d9cc66dacd0b9cef6a49e937ec

bts设备放电

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

@@ -93,13 +93,20 @@
        result = tojson(model);

        return SUCCESS;    

      }

   //导航上实时查询61850设备的处于核容测试的数据

    //导航上实时查询61850设备的处于核容测试的数据

      public String seach6185Nuclear_cap(){

        User_inf uinf=(User_inf) getUser();

          ServiceModel model = service.seach6185Nuclear_cap(uinf);

        result = tojson(model);

        return SUCCESS;    

      }

  //导航上实时查询bts处于放电测试的数据的设备

      public String seachNuclear_cap(){

        User_inf uinf=(User_inf) getUser();

          ServiceModel model = service.seachNuclear_cap(uinf);

        result = tojson(model);

        return SUCCESS;	
      }

    public String getResult() {

        return result;

    }


 gx_tieta/src/com/fgkj/dao/FBS9100_ComBase.java

@@ -45,6 +45,13 @@
    final public static  int DEV_RES_TEST=4;       //内阻测试

    final public static  int DEV_KD_TEST=5;        //kd测试

    

    //bts设备工作状态对应关系workstate

    final public static  int ONLINE_TEST=0;  //在线检测

    final public static  int DISCHARGE=1;     //放电测试

    final public static  int CHARGE=2;    //充电测试

    final public static  int RES_TEST=3;      //内阻测试

    final public static  int NONE=4;       //未知

	
    //bts放电测试页面中的测试类型的对应关系

    final public static int CMD_TESTCMD_HR = 37;    //核容测试

    final public static int CMD_TESTCMD_RES = 50;    //内阻测试


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

@@ -743,6 +743,78 @@
        

        return list;

    }

    //导航上实时查询bts处于放电测试的数据的设备

    public List seachNuclear_cap(Object obj){

        User_inf uinf=(User_inf) obj;

        String sql="select distinct dev_id,dev_alarmstate,dev_workstate,dev_temp,dev_res_test_state,dev_testtype,dev_testgroupnum " +

                   " ,dev_captest_onlinevol,dev_captest_groupvol,dev_captest_curr,dev_captest_cap,dev_captest_timelong" +

                   " ,dev_conresist,dev_concurr,dev_condvoldp,dev_condcurr,dev_61850alarms,dev_last_captest_stop_type  " +

                   " ,db_battinf.tb_battinf.StationName,db_battinf.tb_battinf.FbsDeviceName   " +

                   " ,db_ram_db.tb_batt_rtstate.batt_test_tlong   " +

                   " from db_ram_db.tb_fbs9100_state,db_battinf.tb_battinf,db_ram_db.tb_batt_rtstate  " +

                   " where   dev_workstate="+FBS9100_ComBase.DISCHARGE+"  "+

                   " and db_battinf.tb_battinf.fbsdeviceId=db_ram_db.tb_fbs9100_state.dev_id  " +

                   " and db_battinf.tb_battinf.battgroupid=db_ram_db.tb_batt_rtstate.battgroupid " +

                   " and db_battinf.tb_battinf.fbsdeviceId in(select distinct db_battinf.tb_battinf.fbsdeviceId  from db_battinf.tb_battinf,db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr,db_user.tb_user_inf    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=? )  " +

                   " " ;

        List 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()){

                        Fbs9100_state fstate=new Fbs9100_state();

                        int dev_alarmstate=rs.getInt("dev_alarmstate");

                        String ContactorState="开关闭合";

                        if(dev_alarmstate==1 ||

                           dev_alarmstate==2 ||

                           dev_alarmstate==3 ||

                           dev_alarmstate==4 ||

                           dev_alarmstate==6 ){

                            ContactorState="开关断开";

                        }else{

                            ContactorState="开关闭合";

                        }

                        fstate.setDev_testgroupnum(rs.getInt("dev_testgroupnum"));            //被测电池组号

                        fstate.setDev_alarmstate(rs.getInt("dev_alarmstate"));

                        fstate.setDev_res_test_state(rs.getInt("dev_res_test_state"));

                        fstate.setDev_testtype(rs.getInt("dev_testtype"));

                        fstate.setNote(ContactorState);

                        fstate.setDev_workstate(rs.getInt("dev_workstate"));

                        fstate.setDev_id(rs.getInt("dev_id"));

						
                        fstate.setDev_captest_onlinevol(rs.getFloat("dev_captest_onlinevol"));

                        fstate.setDev_captest_groupvol(rs.getFloat("dev_captest_groupvol"));

                        fstate.setDev_captest_curr(rs.getFloat("dev_captest_curr"));

                        fstate.setDev_captest_cap(rs.getFloat("dev_captest_cap"));

                        fstate.setDev_captest_timelong(rs.getInt("dev_captest_timelong"));

						
                        fstate.setDev_conresist(rs.getFloat("dev_conresist"));

                        fstate.setDev_concurr(rs.getFloat("dev_concurr"));

                        fstate.setDev_condcurr(rs.getFloat("dev_condcurr"));

                        fstate.setDev_condvoldp(rs.getFloat("dev_condvoldp"));

                        fstate.setDev_61850alarms(rs.getString("dev_61850alarms"));

                        fstate.setDev_last_captest_stop_type(rs.getInt("dev_last_captest_stop_type"));

                        fstate.setDev_temp(rs.getFloat("dev_temp"));

                        fstate.setStationName(rs.getString("stationName"));

                        fstate.setDeviceName(rs.getString("FbsDeviceName"));

                        /*fstate.setOnline_vols(((Float)rs.getFloat("online_vol")).toString());

                        fstate.setGroup_vols(((Float)rs.getFloat("group_vol")).toString());

                        fstate.setGroup_currs(((Float)rs.getFloat("group_curr")).toString());*/

                        fstate.setNum(rs.getInt("batt_test_tlong"));

                        list.add(fstate);

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

		
        return list;

    }

    public static void main(String[] args) {

        Fbs9100_stateImpl fi=new Fbs9100_stateImpl();

        /*List<Fbs9100_state> list=fi.searchAll();

@@ -771,8 +843,9 @@
        User_inf uinf=new User_inf();

        uinf.setUId(1002);

       //List<Fbs9100_state> list=fi.searchByUid(uinf);

        List<Fbs9100_state> list=fi.searchDevWorkstate(fs);

       // List<Fbs9100_state> list=fi.searchDevWorkstate(fs);

       // List<Fbs9100_state> list=fi.seach6185Nuclear_cap(uinf);

        List<Fbs9100_state> list=fi.seachNuclear_cap(uinf);

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

        for(Fbs9100_state f:list){

            System.out.println(f);


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

@@ -175,6 +175,18 @@
        }

        return model;

    } 

  //导航上实时查询bts处于放电测试的数据的设备

    public ServiceModel seachNuclear_cap(Object obj){

        List list=((Fbs9100_stateImpl)dao).seachNuclear_cap(obj);

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

            model.setCode(1);

            model.setData(list);

        }else{

            model.setCode(0);

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

        }

        return model;

    } 
      public static void main(String[] args) {

        Fbs9100_stateService fs = new Fbs9100_stateService();

        Fbs9100_state f=new Fbs9100_state();