@RequestMapping(params = "p=del") public @ResponseBody Map<String, Object> del( @ModelAttribute SYS_Role entity, HttpSession session) { SYS_User user = (SYS_User) session.getAttribute(Const.SESSION_USER); try { String sql = SQLUtil.getDeleteSQLByModule(entity); // String querySQL = SQLUtil.getQuerySQL(SYS_Role.class) + " where " // + SQLUtil.getWhereClause(entity); // SYS_Role temp = roleDao.query(SYS_Role.class, querySQL).get(0); // LogVO l = ObjUtil.buildMetaSQL(temp, "第1/1步,删除"); // String table = "SYS_Role:" + entity.getRoleID(); // String oprinfo = "SYS_Role:" + l.getRowid(); // String descriptioin = "删除角色(编码:" + entity.getRoleID(); // sql += LogUtil.getLogSQL(user, table, sql, oprinfo, // descriptioin); // sql += l.getSql(); sql += "delete from SYS_rolemodule where roleID = '" + entity.getRoleID() + "' ;"; roleDao.jdbcTemplate.execute(sql); } catch (Exception e) { return MessageUtil.exception(user, e); } return MessageUtil.success(); }
@SuppressWarnings("unchecked") @RequestMapping(params = "p=addrolemodule") public @ResponseBody Map<String, Object> addRoleModule( @ModelAttribute SYS_Role role, String module1, String module2, String modulestr, HttpSession session, String appPlatform) { SYS_User user = (SYS_User) session.getAttribute(Const.SESSION_USER); Map<String, Object> result = new HashMap<String, Object>(); try { JSONArray jsonArray = JSONArray.fromObject(unicode(modulestr)); if (CheckUtil.isNullStr(module1)) { throw new CustomerException("请选择子系统"); } if (CheckUtil.isNullStr(module2)) { throw new CustomerException("请选择一级菜单"); } List<SYS_RoleModule> list = new ArrayList<SYS_RoleModule>(); List<SYS_RoleModule> list1 = new ArrayList<SYS_RoleModule>(); // String sql = "select * from SYS_Module where ModuleID in ('" + // module1 + "','" + module2 + "')"+" ;"; String sql = "select * from SYS_Module where ParentID = '" + module2 + "' || ModuleID = '" + module2 + "' ;"; String sql1 = "select * from SYS_Module where ModuleID = '" + module2 + "' ;"; List<SYS_Module> pars = roleDao.query(SYS_Module.class, sql); SYS_Module pars1 = roleDao.query(SYS_Module.class, sql1).get(0); if (pars.size() > 0 || "AIR".equals(appPlatform)) { for (SYS_Module temp : pars) { SYS_RoleModule rm = new SYS_RoleModule(); rm.setRomoID(UUIDUtil.get32UUID()); rm.setRoleID(role.getRoleID()); rm.setRoleName(unicode(role.getRoleName())); rm.setModuleID(temp.getModuleID()); rm.setModuleName(temp.getModuleName()); rm.setInputDate(DateUtil.getDateTimeString()); rm.setInputName(user.getUserName()); list.add(rm); } } sql += SQLUtil.getDeleteSQLByModule(list); for (Object obj : jsonArray) { SYS_Module temp = PropertyUtil.copyMap(SYS_Module.class, (Map<String, Object>) obj); SYS_RoleModule rm = new SYS_RoleModule(); rm.setRomoID(UUIDUtil.get32UUID()); rm.setRoleID(role.getRoleID()); rm.setRoleName(unicode(role.getRoleName())); rm.setModuleID(temp.getModuleID()); rm.setModuleName(temp.getModuleName()); rm.setInputDate(DateUtil.getDateTimeString()); rm.setInputName(user.getUserName()); list1.add(rm); } for (Object obj : jsonArray) { SYS_Module temp = PropertyUtil.copyMap(SYS_Module.class, (Map<String, Object>) obj); SYS_RoleModule rm = new SYS_RoleModule(); if (temp.getParentID().equals(module2)) { rm.setRomoID(UUIDUtil.get32UUID()); rm.setRoleID(role.getRoleID()); rm.setRoleName(unicode(role.getRoleName())); rm.setModuleID(pars1.getModuleID()); rm.setModuleName(pars1.getModuleName()); rm.setInputDate(DateUtil.getDateTimeString()); rm.setInputName(user.getUserName()); list1.add(rm); } break; } // if ("AIR".equals(appPlatform) && CheckUtil.isNullStr(module2)) { // sql = "delete from SYS_RoleModule where ModuleId in ('" + module1 // + "','" + module2 + "') and RoleID='" + role.getRoleID() + "'\n"+ // " ; "; // } else { // sql = "delete from SYS_RoleModule where ModuleId in ('" + module1 // + "','" + module2 + "') and RoleID='" + role.getRoleID() + "'\n" // + " ; "; // } // sql += // "delete a from SYS_RoleModule a, SYS_Module b where "+module1+" = // "+module2+/*a.ModuleID=b.ModuleID*/" and b.ParentID='"+module2+"' and RoleID='" // + role.getRoleID() + "'\n"; sql += SQLUtil.getInsertSQLByRole(list1); roleDao.jdbcTemplate.execute(sql); } catch (Exception e) { return MessageUtil.exception(user, e); } return MessageUtil.success(result); }