部门管理

查询部门列表

/** 查询部门列表 */
getList() {
  this.loading = true;
  listDept(this.queryParams).then(response => {
    this.deptList = response.data;
    this.loading = false;
  });
}

调用后台接口

/**
 * 获取部门列表
 */
@PreAuthorize("@ss.hasPermi('system:dept:list')")
@GetMapping("/list")
public AjaxResult list(SysDept dept)
{
    List<SysDept> depts = deptService.selectDeptList(dept);
    return AjaxResult.success(deptService.buildDeptTree(depts));
}

List<SysDept> depts = deptService.selectDeptList(dept);

/**
 * 查询部门管理数据
 * 
 * @param dept 部门信息
 * @return 部门信息集合
 */
@Override
@DataScope(deptAlias = "d")
public List<SysDept> selectDeptList(SysDept dept)
{
    return deptMapper.selectDeptList(dept);
}

deptMapper.selectDeptList(dept);

执行sql：

select d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.phone, d.email, d.status, d.del_flag, d.create_by, d.create_time
from sys_dept d
      where d.del_flag = '0'
      <if test="parentId != null and parentId != 0">
   AND parent_id = #{parentId}
</if>
<if test="deptName != null and deptName != ''">
   AND dept_name like concat('%', #{deptName}, '%')
</if>
<if test="status != null and status != ''">
   AND status = #{status}
</if>
<!-- 数据范围过滤 -->
${dataScope}
order by d.parent_id, d.order_num

查询部门下拉树结构

/** 查询部门下拉树结构 */
getTreeselect() {
  treeselect().then(response => {
    this.deptOptions = response.data;
  });
}

调用后台接口

/**
 * 获取部门下拉树列表
 */
@PreAuthorize("@ss.hasPermi('system:dept:query')")
@GetMapping("/treeselect")
public AjaxResult treeselect(SysDept dept)
{
    List<SysDept> depts = deptService.selectDeptList(dept);
    return AjaxResult.success(deptService.buildDeptTreeSelect(depts));
}

List<SysDept> depts = deptService.selectDeptList(dept);

/**
 * 查询部门管理数据
 * 
 * @param dept 部门信息
 * @return 部门信息集合
 */
@Override
@DataScope(deptAlias = "d")
public List<SysDept> selectDeptList(SysDept dept)
{
    return deptMapper.selectDeptList(dept);
}

deptMapper.selectDeptList(dept);

执行sql：

select d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.phone, d.email, d.status, d.del_flag, d.create_by, d.create_time
from sys_dept d
      where d.del_flag = '0'
      <if test="parentId != null and parentId != 0">
   AND parent_id = #{parentId}
</if>
<if test="deptName != null and deptName != ''">
   AND dept_name like concat('%', #{deptName}, '%')
</if>
<if test="status != null and status != ''">
   AND status = #{status}
</if>
<!-- 数据范围过滤 -->
${dataScope}
order by d.parent_id, d.order_num