使用oracle做的数据上传系统后台
kongdeqiang
2026-03-23 79619d4274f3bb8d4b90a0e7ddafc17e3c9028bf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
package com.example.service.impl;
 
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.entity.Department;
import com.example.mapper.DepartmentMapper;
import com.example.service.DepartmentService;
import org.springframework.stereotype.Service;
 
import java.util.ArrayList;
import java.util.List;
 
@Service
public class DepartmentServiceImpl extends ServiceImpl<DepartmentMapper, Department> implements DepartmentService {
 
    @Override
    public List<Department> getDepartmentTree() {
        return baseMapper.selectByParentCode("0");
    }
 
    @Override
    public Department getByDeptCode(String deptCode) {
        return baseMapper.selectByDeptCode(deptCode);
    }
 
    @Override
    public boolean checkDeptCodeExists(String deptCode) {
        return baseMapper.selectByDeptCode(deptCode) != null;
    }
 
    @Override
    public List<String> getChildDeptCodes(String deptCode) {
        List<String> result = new ArrayList<>();
        result.add(deptCode);
        collectChildDeptCodes(deptCode, result);
        return result;
    }
 
    private void collectChildDeptCodes(String parentCode, List<String> result) {
        if (parentCode == null || parentCode.isEmpty()) {
            return;
        }
        List<Department> children = baseMapper.selectByParentCode(parentCode);
        for (Department child : children) {
            if (child.getDeptCode() != null && !child.getDeptCode().equals(parentCode)) {
                result.add(child.getDeptCode());
                collectChildDeptCodes(child.getDeptCode(), result);
            }
        }
    }
 
    @Override
    public List<Department> getDepartmentTreeWithPermission(String deptCode) {
        Department currentDept = getByDeptCode(deptCode);
        if (currentDept == null) {
            return new ArrayList<>();
        }
        List<Department> result = new ArrayList<>();
        result.add(currentDept);
        collectChildDepartments(deptCode, result);
        return result;
    }
 
    private void collectChildDepartments(String parentCode, List<Department> result) {
        if (parentCode == null || parentCode.isEmpty()) {
            return;
        }
        List<Department> children = baseMapper.selectByParentCode(parentCode);
        for (Department child : children) {
            if (child.getDeptCode() != null && !child.getDeptCode().equals(parentCode)) {
                result.add(child);
                collectChildDepartments(child.getDeptCode(), result);
            }
        }
    }
}