<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.xinelu.applet.mapper.healthconsultation.HealthConsultationMapper">

    <select id="selectPatientById" resultType="com.xinelu.manage.domain.patientinfo.PatientInfo">
        SELECT patient_name,
               phone
        FROM patient_info
        WHERE id = #{patientId}
    </select>

    <select id="selectHospitalDepartmentList"
            resultType="com.xinelu.applet.vo.healthconsultation.HealthConsultationVO">
        select id departmentId,
               department_name
        from hospital_department_info
        order by department_sort asc
    </select>
</mapper>
