| | |
| | | return bl; |
| | | } |
| | | |
| | | //包机组重做(穿梭框)查询所有的用户 |
| | | //包机组重做(穿梭框)添加 |
| | | public boolean addPro_CS(Object obj){ |
| | | List<User_battgroup_baojigroup_battgroup> list=(List) obj; |
| | | ArrayList sql_strs=new ArrayList(); |
| | |
| | | if(list!=null&&list.size()>0){ |
| | | for (User_battgroup_baojigroup_battgroup ugroup : list) { |
| | | String sql="REPLACE into db_user.tb_user_battgroup_baojigroup_battgroup(baoji_group_id,StationId,BattGroupId) " |
| | | + " SELECT "+ugroup.getBaoji_group_id()+",StationId,BattGroupId from db_battinf.tb_battinf where FBSDeviceId="+ugroup.getDev_id() ; |
| | | + " SELECT "+ugroup.getBaoji_group_id()+",StationId,BattGroupId from db_battinf.tb_battinf where StationId="+ugroup.getStationId() ; |
| | | sql_strs.add(sql); |
| | | { |
| | | String msg="添加"+ugroup.getNote()+"至"+ugroup.getBaoji_group_name()+"包机组中"; |
| | | String msg="添加"+ugroup.getNote()+"机房至"+ugroup.getBaoji_group_name()+"包机组中"; |
| | | User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Increase, msg); |
| | | listU.add(ulog); |
| | | } |
| | |
| | | (new User_logService()).addPro(listU);//将用户的操作记录下来 |
| | | return bl; |
| | | } |
| | | //5.3包机组重做(穿梭框)删除 |
| | | public boolean delPro_CS(Object obj) { |
| | | List<User_battgroup_baojigroup_battgroup> list=(List) obj; |
| | | ArrayList sql_strs=new ArrayList(); |
| | | List<User_log> listU=new ArrayList<User_log>();//存放user_log |
| | | if(list!=null&&list.size()>0){ |
| | | for (User_battgroup_baojigroup_battgroup ugroup : list) { |
| | | String sql="delete from db_user.tb_user_battgroup_baojigroup_battgroup where baoji_group_id="+ugroup.getBaoji_group_id()+" and stationid="+ugroup.getStationId(); |
| | | sql_strs.add(sql); |
| | | { |
| | | String msg="删除"+ugroup.getBaoji_group_name()+"包机组中"+ugroup.getNote()+"机房"; |
| | | User_log ulog=UinfDaoFactory.CreateULog(UinfDaoFactory.Delete, msg); |
| | | listU.add(ulog); |
| | | } |
| | | } |
| | | } |
| | | boolean bl=DAOHelper.makeManualCommit(DBUtil.getConn(), sql_strs); |
| | | (new User_logService()).addPro(listU);//将用户的操作记录下来 |
| | | return bl; |
| | | } |
| | | //5.3删除(删除指定包机组下所有用户) |
| | | public String delAll(Object obj) { |
| | | User_battgroup_baojigroup ubao=(User_battgroup_baojigroup) obj; |