吉安感知网项目-后端
linwei
2026-04-02 b7d817f4197b6e85e0fc5bdd4926d175849d233e
opt: sql改造其他模块改造13
2 files modified
12 ■■■■ changed files
drone-service/drone-system/src/main/java/org/sxkj/system/controller/DeptController.java 6 ●●●● patch | view | raw | blame | history
drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/UserServiceImpl.java 6 ●●●●● patch | view | raw | blame | history
drone-service/drone-system/src/main/java/org/sxkj/system/controller/DeptController.java
@@ -211,7 +211,11 @@
        if (deptService.submit(deptEntity)) {
            CacheUtil.clear(SYS_CACHE);
            CacheUtil.clear(SYS_CACHE, Boolean.FALSE);
            List<User> userList = userMapper.selectList(new LambdaQueryWrapper<User>().eq(User::getDeptId, dept.getId()));
            // 修正后的代码
            List<User> userList = userMapper.selectList(
                new LambdaQueryWrapper<User>()
                    .eq(User::getDeptId, String.valueOf(dept.getId())) // 关键点:转为 String
            );
            if (!userList.isEmpty()) {
                List<Long> userIds = userList.stream().map(User::getId).collect(Collectors.toList());
                userMapper.updateUserAreaCode(dept.getAreaCode(), userIds);
drone-service/drone-system/src/main/java/org/sxkj/system/service/impl/UserServiceImpl.java
@@ -110,8 +110,10 @@
    @Override
    @Transactional(rollbackFor = Exception.class)
    public boolean updateUser(User user) {
        Dept dept = deptMapper.selectOne(new LambdaQueryWrapper<Dept>().eq(Dept::getId, user.getDeptId()));
        user.setAreaCode(null == dept ? null : dept.getAreaCode());
        // 强制转为 Long 类型再查询
        Long deptId = Long.valueOf(user.getDeptId());
        Dept dept = deptMapper.selectOne(new LambdaQueryWrapper<Dept>().eq(Dept::getId, deptId));
         user.setAreaCode(null == dept ? null : dept.getAreaCode());
        String tenantId = user.getTenantId();
        Long userCount = baseMapper.selectCount(
            Wrappers.<User>query().lambda()