opt: sql改造其他模块改造9

linwei

2026-04-02 2418543dfc6c61fa5091e242042a7d7635f6c7c5

 drone-service/drone-system/src/main/java/org/sxkj/system/controller/RoleController.java

@@ -93,7 +93,8 @@
      QueryWrapper<Role> queryWrapper = Condition.getQueryWrapper(role, Role.class);
      // 不查询超级管理员角色
      // if (!AuthUtil.isAdministrator()) {
      queryWrapper.ne("id", "1123598816738675201");
      // 使用 apply 手动指定类型转换
      queryWrapper.apply("id <> {0}::bigint", "1123598816738675201");
      // }
      List<Role> list = roleService.list(queryWrapper);
      return R.data(RoleWrapper.build().listNodeVO(list));