forked from kidgrow-microservices-platform
parent: 967f9117 | patch | commit | ignore whitespace
houruijun
2020-10-29 f4d5b46cfffc27d626afc3c43e8e20a11e686a00 
修正查询科室名称是否存在的时候，没有排除已经删除/禁用的科室。
1 files modified
2 ■■■■■ changed files
kidgrow-business/kidgrow-usercenter/kidgrow-usercenter-biz/src/main/resources/mapper/SysDepartmentMapper.xml 2 ●●●●● patch | view | raw | blame | history 
 kidgrow-business/kidgrow-usercenter/kidgrow-usercenter-biz/src/main/resources/mapper/SysDepartmentMapper.xml


@@ -78,7 +78,7 @@


    <select id="checkDepartmentName" resultType="string">


        SELECT org_name FROM sys_organization


WHERE org_parent_id =( SELECT org_id FROM sys_hospital WHERE id = #{hosId} )


AND org_name = #{departmentName}


AND org_name = #{departmentName} AND is_del=0 and enabled=1


    </select>


    <select id="updatePay" resultType="boolean">


        UPDATE sys_department