package com.example.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.example.entity.Department;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
@Mapper
|
public interface DepartmentMapper extends BaseMapper<Department> {
|
|
@Select("SELECT * FROM sys_department WHERE deleted = 0 AND parent_code = #{parentCode} ORDER BY sort_order")
|
List<Department> selectByParentCode(@Param("parentCode") String parentCode);
|
|
@Select("SELECT * FROM sys_department WHERE deleted = 0 AND dept_code = #{deptCode}")
|
Department selectByDeptCode(@Param("deptCode") String deptCode);
|
}
|
