| | |
|---|
| | | 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" +
|
|---|
| | |
|---|
| | | ","+binf.getMonCount()+","+binf.getMonCapStd()+","+binf.getMonVolStd()+","+binf.getMonResStd()+","+binf.getMonSerStd()+","+binf.getMonVolLowToAvg()+
|
|---|
| | | ",'"+binf.getBattProducer()+"','"+binf.getBattModel()+"','"+DAOHelper.sdf.format(binf.getBattProductDate())+"','"+DAOHelper.sdf.format(binf.getBattInUseDate())+"',"+binf.getLoad_curr()+",'"+binf.getInstall_user()+"',"+binf.getDisCurrMax()+",'"+binf.getStation_phone()+"',"+binf.getStation_install()+")";
|
|---|
| | | sql_str.add(sql_insert_binf);
|
|---|
| | | //给添加的机房加入包机组（管理员组）
|
|---|
| | | 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 ";
|
|---|
| | | " SELECT baoji_group_id,'"+binf.getStationId()+"',"+binf.getBattGroupId()+" from db_user.tb_user_battgroup_baojigroup_usr where uid="+bapply.getApply_uid();
|
|---|
| | | sql_str.add(baoji_sql);
|
|---|
| | | |
|---|
| | | {
|
|---|
| | | String msg="确认添加"+binf.getStationName()+"机房"+binf.getBattGroupId()+"电池组的信息";
|
|---|
| | | User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Alter, msg);
|
|---|
| | |
|---|
| | | }
|
|---|
| | | //申请表中已审批通过的设备连接数
|
|---|
| | | public List devCommNum() {
|
|---|
| | | String sql=" select distinct db_battinf.tb_battinf_apply.FbsDeviceId,dev_commcount " +
|
|---|
| | | String sql=" select distinct db_battinf.tb_battinf_apply.FbsDeviceId,dev_commcount,dev_errcommcount " +
|
|---|
| | | " from db_battinf.tb_battinf_apply,db_ram_db.tb_fbs9100_state " +
|
|---|
| | | " where apply_en=1 and db_battinf.tb_battinf_apply.FbsDeviceId=db_ram_db.tb_fbs9100_state.dev_id "
|
|---|
| | | + " order by apply_date desc" ;
|
|---|
| | |
|---|
| | | Fbs9100_state fbs=new Fbs9100_state();
|
|---|
| | | fbs.setDev_id(rs.getInt("FbsDeviceId"));
|
|---|
| | | fbs.setDev_commcount(rs.getInt("dev_commcount"));
|
|---|
| | | fbs.setDev_errcommcount(rs.getInt("dev_errcommcount"));
|
|---|
| | | list.add(fbs);
|
|---|
| | | }
|
|---|
| | | } catch (SQLException e) {
|
|---|
