电池组放电记录查询<-------跨域>

81041

2018-11-14 929449c99fbfeade6dbafae1c06c79cec22e7f61

电池组放电记录查询<-------跨域>

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

@@ -206,7 +206,63 @@
            }

        });

    }

    //历史数据查询<-------跨域----------->

    public List serchByCondition_ky(Object obj) {

        final Batttestdata_inf bti=(Batttestdata_inf)obj;

        String sql="select num,BattGroupId,test_record_count,test_record_count_ex,test_type,record_time_interval,data_new,data_available,record_num,test_starttime,test_starttime_ex,test_starttype,record_time,test_timelong,test_stoptype,group_vol,test_curr,test_cap,max_monnum,max_monvol,min_monnum,min_monvol,mon_num,mon_vol,upload_usr_id " +

                " from db_batt_testdata.tb_batttestdata_inf where BattGroupId=?  " +

                " and  db_batt_testdata.tb_batttestdata_inf.data_available=1 " +

                " order by test_type asc,test_starttime desc ";

        return DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{bti.getBattGroupId()}, new CallBack() {



            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()){

                        Batttestdata_inf b=new Batttestdata_inf();

                        b.setNum(rs.getInt("num"));

                        b.setBattGroupId(rs.getInt("BattGroupId"));

                        b.setTest_record_count(rs.getInt("test_record_count"));

                        b.setTest_record_count_ex(rs.getInt("test_record_count_ex"));

                        b.setTest_type(rs.getInt("test_type"));

                        b.setRecord_time_interval(rs.getInt("record_time_interval"));

                        b.setData_new(rs.getInt("data_new"));

                        b.setData_available(rs.getInt("data_available"));						
                        b.setRecord_num(rs.getInt("record_num"));

                        b.setTest_starttime(rs.getTimestamp("test_starttime"));

                        b.setTest_starttime_ex(rs.getTimestamp("test_starttime_ex"));

                        b.setTest_starttype(rs.getInt("test_starttype"));

                        b.setRecord_time(rs.getTimestamp("record_time"));

                        b.setTest_timelong(rs.getInt("test_timelong"));

                        b.setTest_stoptype(rs.getInt("test_stoptype"));

                        //放电终止原因

						
                        if(bti.getNum()/100000==6185){

                            b.setTest_stoptype_reason(BattTestData.getStopType_6185(b.getTest_stoptype()));							
                        }else if(bti.getNum()/100000==4016){

                            b.setTest_stoptype_reason(BattTestData.getStopType_4016(b.getTest_stoptype()));

                        }else{

                            b.setTest_stoptype_reason(BattTestData.getStopType(b.getTest_starttype(), b.getTest_stoptype()));

                        }

                        b.setGroup_vol(rs.getFloat("group_vol"));

                        b.setTest_curr(rs.getFloat("test_curr"));

                        b.setTest_cap(rs.getFloat("test_cap"));

                        b.setMax_monnum(rs.getInt("max_monnum"));

                        b.setMax_monvol(rs.getFloat("max_monvol"));

                        b.setMin_monnum(rs.getInt("min_monnum"));

                        b.setMin_monvol(rs.getFloat("min_monvol"));

                        b.setMon_num(rs.getInt("mon_num"));

                        b.setMon_vol(rs.getFloat("mon_vol"));

                        b.setUpload_usr_id(rs.getInt("upload_usr_id"));

                        list.add(b);

                    }

                } catch (SQLException e) {

                    e.printStackTrace();

                } 
                return list;

            }

        });

    }

    //6.2根据battgroupi和test_starttime查test_record_count

    public List serchTest_record_count(Object obj) {

        Batttestdata_inf tdata=(Batttestdata_inf)obj;

@@ -1017,11 +1073,20 @@
        Batt_Maint_Dealarm bmd=new Batt_Maint_Dealarm();

        bmd.setTdata(tdata);

        bmd.setBinf(binf);

        List<Batt_Maint_Dealarm> list=bimpl.serchByInfo(bmd);

        /*List<Batt_Maint_Dealarm> list=bimpl.serchByInfo(bmd);

        for (Batt_Maint_Dealarm b : list) {

            System.out.println(b);

        }

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

        */

        Batttestdata_inf tinf=new Batttestdata_inf();

        tinf.setBattGroupId(1002095);

        tinf.setNum(910000577);

        List<Batttestdata_inf> list=bimpl.serchByCondition_ky(tinf);

        for (Batttestdata_inf b : list) {

            System.out.println(b);

        }

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



    }




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

@@ -30,10 +30,12 @@
        model=new ServiceModel();

        dao=BaseDAOFactory.getBaseDAO(BaseDAO.BATTTESTDATA_INF);

        daoB=BaseDAOFactory.getBaseDAO(BaseDAO.BATTINF);

    }

	
    public ServiceModel serchByCondition(Object obj){

        model=new ServiceModel();

    }

    /**

     * 根据电池组id查询电池组的inf表中的放电信息

     */

    public ServiceModel serchByCondition(Object obj){

        List<Batttestdata_inf> list=dao.serchByCondition(obj);        

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

            model=judge(obj);            

@@ -42,16 +44,25 @@
                model.setData(list);

            }

        }

//        for (Batttestdata_inf u :list) {

//            System.out.println(u);

//        }

        return model;

    }



	
    /**

     * 根据电池组id查询电池组的inf表中的放电信息<-------跨域----------->

     */

    public ServiceModel serchByCondition_ky(Object obj){

        List<Batttestdata_inf> list=((Batttestdata_infDAOImpl)dao).serchByCondition_ky(obj);		
        if(list!=null && list.size()>0){

            model=judge(obj);			
            if(model.getCode()!=0){

                model.setCode(1);

                model.setData(list);

            }

        }

        return model;

    }

   //测试battgroupid在batttestdata_inf中是否存在

    public ServiceModel judge(Object obj){

        model=new ServiceModel();

        Batttestdata_inf bti=(Batttestdata_inf)obj;

        if(bti.getBattGroupId()!=null){        

            //System.out.println(bti.getBattGroupId());

@@ -69,7 +80,6 @@
    //1.2/1.3电池组统计分析查询

    public ServiceModel serchByTestType1(Object obj){

        Batttestdata_inf binf=(Batttestdata_inf) obj;

        model=new ServiceModel();

        if(binf.getTest_type()==2){

            List<Batttestdata_inf> list2=((Batttestdata_infDAOImpl)dao).serchByTestType2(binf);

            List<Batttestdata_inf> list3=((Batttestdata_infDAOImpl)dao).serchByTestType3(binf);