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

linwei

2026-04-02 2418543dfc6c61fa5091e242042a7d7635f6c7c5

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

 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));

 drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/RegionServiceImpl.java

@@ -54,9 +54,11 @@
    public Region getById(Serializable id) {
        return Optional.ofNullable(id)
            .map(val -> baseMapper.selectOne(new LambdaQueryWrapper<Region>()
                .eq(Region::getId, val)
                // 1. 处理 id = ? 部分，强制转为 bigint
                .apply("id = {0}::bigint", val)
                .or()
                .eq(Region::getCode, val)))
                // 2. 处理 code = ? 部分，强制转为 varchar
                .apply("code = {0}::varchar", val)))
            .orElse(null);
    }