申请添加修改

81041

2018-12-26 e3e09bc29f2ddc1600e27a8d0ec12981215e68b2

申请添加修改

 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/Battinf_applyImpl.class

Binary files differ

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

@@ -4373,6 +4373,78 @@
        }

        return battgroupid;

    }

	
    //批量设置放电参数时，根据省市区，电池单体型号（伏数），组数筛选出电池组

    public List serchByDischarge(Object obj) {

        BattInf binf=(BattInf) obj;

        Connection conn=DBUtil.getConn();

        String numberSql=" SELECT FOUND_ROWS() number";

        String sql=" select SQL_CALC_FOUND_ROWS * from db_battinf.tb_battinf "

                + "  where StationName1 like ? and StationName2 like ? and StationName3 like ? and StationName5 like ? "

                + "  and GroupIndexInFBSDevice=?   and MonVolStd=? "

                + "  order by StationId asc,GroupIndexInFBSDevice asc ";

        List<BattInf> list=DAOHelper.executeQueryLimit(sql, conn, new Object[] {"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%","%"+binf.getStationName5()+"%",binf.getGroupIndexInFBSDevice(),binf.getMonVolStd()}, new CallBack() {

			
            @Override

            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()) {

                        BattInf binf = new BattInf();

                        binf.setStationId(rs.getString("stationId"));

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

                        binf.setStationName1(rs.getString("stationName1"));

                        binf.setStationName2(rs.getString("stationName2"));

                        binf.setStationName3(rs.getString("stationName3"));

                        binf.setStationName4(rs.getString("stationName4"));

                        binf.setStationName5(rs.getString("stationName5"));

                        binf.setStationIp(rs.getString("stationIp"));

                        binf.setFBSDeviceId(rs.getInt("fBSDeviceId"));

						
                        binf.setFbsDeviceIp(rs.getString("fbsDeviceIp"));

                        binf.setFbsDeviceIp_YM(rs.getString("fbsDeviceIp_YM"));

                        binf.setFbsDeviceIp_WG(rs.getString("fbsDeviceIp_WG"));

                        binf.setFBSDeviceName(rs.getString("fBSDeviceName"));

                        binf.setGroupIndexInFBSDevice(rs.getInt("groupIndexInFBSDevice"));

                        binf.setBattGroupId(rs.getInt("battGroupId"));

                        binf.setBattGroupNum(rs.getInt("battGroupNum"));

                        binf.setBattGroupName(rs.getString("battGroupName"));

                        binf.setFloatVolLevel(rs.getFloat("floatVolLevel"));

                        binf.setOfflineVolLevel(rs.getFloat("offlineVolLevel"));

                        binf.setBattFloatCurrent(rs.getFloat("battFloatCurrent"));

                        binf.setMonCount(rs.getInt("monCount"));

                        binf.setMonCapStd(rs.getFloat("monCapStd"));

                        binf.setMonVolStd(rs.getFloat("monVolStd"));

                        binf.setMonResStd(rs.getFloat("monResStd"));

                        binf.setMonSerStd(rs.getFloat("monSerStd"));

                        binf.setMonVolLowToAvg(rs.getFloat("monVolLowToAvg"));

                        binf.setBattProducer(rs.getString("battProducer"));

                        binf.setBattModel(rs.getString("battModel"));

                        binf.setBattProductDate(rs.getDate("battProductDate"));

                        binf.setBattInUseDate(rs.getDate("battInUseDate"));

                        binf.setLoad_curr(rs.getFloat("load_curr"));

                        binf.setInstall_user(rs.getString("install_user"));

                        binf.setDisCurrMax(rs.getFloat("disCurrMax"));

                        binf.setStation_phone(rs.getString("station_phone"));

                        binf.setStation_install(rs.getInt("station_install"));

                        list.add(binf);

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        //去掉limit条件后的总数

        int number=LimitNumberFactory.GetLimtitNumber(conn, numberSql);

        //System.out.println("number: "+number);

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

            list.get(list.size()-1).setNum(number);

        }

        return list;

    }



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

        //new BattInfImpl().searchAll();

        

@@ -4382,11 +4454,14 @@
        binf.setBattGroupId(1000001);

        binf.setStationName("广西省-百色-GX百色乐业县立新小区WF-BTS设备");

        binf.setStationName1("");

        binf.setStationName2("");

        binf.setStationName2("百色");

        binf.setStationName3("");

        binf.setStationName5("");

        binf.setBattGroupName("");

        binf.setBattProducer("1");

        binf.setStationId("42000575");

        binf.setGroupIndexInFBSDevice(0);

        binf.setMonVolStd(2f);

        User_inf uinf=new User_inf();

        uinf.setUId(1002);

        

@@ -4423,8 +4498,13 @@
        System.out.println(list.size());*/

        /*int nums=biml.serchByInstall_count(uinf);

        System.out.println(nums);*/

        boolean bl=biml.judgeBattInOrNot(binf);

        System.out.println(bl);

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

        System.out.println(bl);*/

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

        for (BattInf b : list) {

            System.out.println(b);

        }

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

    }

    

    public List getResults(ResultSet rs) {


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

@@ -94,7 +94,7 @@
                int uid=((User_inf)ActionUtil.getUser()).getUId();

                bapply.setApply_uid(uid);

                BattInf binf=bapply.getBinf();

                String sql = "insert into db_battinf.tb_battinf_apply(" +

                String sql = "replace into db_battinf.tb_battinf_apply(" +

                        "apply_uid,apply_date,StationId,StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,FbsDeviceIp,FbsDeviceIp_YM,FbsDeviceIp_WG,"

                        + "FBSDeviceName,GroupIndexInFBSDevice,battgroupId,BattGroupNum,BattGroupName,FloatVolLevel,OfflineVolLevel,BattFloatCurrent" +

                        ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,MonVolLowToAvg,BattProducer,BattModel,BattProductDate,BattInUseDate,Load_curr,install_user,DisCurrMax,station_phone" +