电池放电参数设置批量

81041

2019-01-05 fdc45803b0b4468508316efc5cfd90af9c63e9c9

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

@@ -90,6 +90,14 @@
            }

            maxb++;

            sql_str.add(sql);

				
            String baoji_sql_main="REPLACE into db_user.tb_user_battgroup_baojigroup_battgroup(baoji_group_id,StationId,BattGroupId) values('100011','"+binf.getStationId()+"',"+binf.getBattGroupId()+")";

             sql_str.add(baoji_sql_main);

			    
               // System.out.println(baoji_sql_main);

            String baoji_sql="REPLACE into db_user.tb_user_battgroup_baojigroup_battgroup(baoji_group_id,StationId,BattGroupId) " + 
                      " SELECT baoji_group_id,'"+binf.getStationId()+"',"+binf.getBattGroupId()+" from  db_user.tb_user_battgroup_baojigroup_usr where uid="+((User_inf)ActionUtil.getUser()).getUId();

               sql_str.add(baoji_sql);

            {

               String msg="添加"+binf.getStationName()+"机房"+binf.getBattGroupId()+"电池组的信息";

               User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Increase, msg);

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

   public List serchByDischarge(Object obj) {

      BattInf binf=(BattInf) obj;

      Page page=binf.getPage();

      //Page page=binf.getPage();

      /*Connection conn=DBUtil.getConn();

      String numberSql=" SELECT FOUND_ROWS() number";SQL_CALC_FOUND_ROWS*/

      String sql=" select  distinct(StationId),StationName,StationName1,StationName2,StationName3,StationName4,StationName5,StationIp,FBSDeviceId,"

            + "FBSDeviceName,GroupIndexInFBSDevice,db_battinf.tb_battinf.battgroupId,BattGroupNum" +

            + "FBSDeviceName,GroupIndexInFBSDevice,db_battinf.tb_battinf.battgroupId,battGroupName,battGroupNum" +

             ",MonCount,MonCapStd,monVolStd,monResStd,MonSerStd,Load_curr,DisCurrMax"

             + ",db_ram_db.tb_fbs9100_state.dev_version  "

            + " from db_battinf.tb_battinf,db_ram_db.tb_fbs9100_state "

@@ -4422,6 +4430,7 @@
            try {

               while(rs.next()) {

                  BattInf binf = new BattInf();

                  binf.setNum(0);

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

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

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

@@ -4438,8 +4447,9 @@
                  binf.setFBSDeviceName(rs.getString("fBSDeviceName"));

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

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

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

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

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

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

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

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

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

@@ -4479,7 +4489,7 @@
      }*/

      return list;

   }



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

      //new BattInfImpl().searchAll();