<!-- 根据bs_dir_rel表查询bs_dir_info表的id --><select id="selectDirectoryByprojectID" resultType="com.westone.dmp.rdm.bean.vo.DirVo">
SELECT di.id,di.name,di.description,di.parent_id,di.sort
FROM bs_dir_info di
WHERE di.id =(SELECT dr.dir_id FROM bs_dir_rel dr WHERE project_id = #{projectID})</select>
<!--查询所有数据--><select id="getDirectory" parameterType="String" resultMap="BaseResultMap">
SELECT id,name,description,parent_id,sort FROM bs_dir_info
</select>