<select id="selectDepartmentdoctor" parameterType="com.amenuo.yiliao.bean.departmentdoctorPO" resultType="com.amenuo.yiliao.bean.DoctorScorPo">
        SELECT
        usr.id,
        usr.realname,
        usr.user_img_url  userImgUrl,
        usr.longitude,
        usr.latitude,
        usr.begoodat,
        doc.Doctor_score/5 Doctorscore
        FROM
        tb_user_department dep
        LEFT JOIN tb_userdetail usr ON dep.user_id = usr.id
        LEFT JOIN tb_doctorscore doc ON doc.userid = usr.id
        LEFT JOIN tb_user us ON us.id=usr.id
        <where>
             dep.department_code = #{departmentcode}
            <if test="city !=null">
                AND usr.address LIKE  concat('%',#{city,jdbcType=VARCHAR},'%')
            </if>
            <if test="Frequency!=null">
                ORDER BY doc.Frequency DESC
            </if>
            <if test="Doctor_score!=null">
                ORDER BY doc.Doctor_score DESC
            </if>
            and  !ISNULL(usr.latitude) and !ISNULL(usr.latitude)  and us.delete_flag ='N'
        </where>

    </select>

//判断字符串是否包含除字母、数字、下划线以外的字符
    public bool valStr(string str)
    {
        bool isTrue = true;
        foreach (char c in str)
        {
            if ((c > 57 || c < 48) && c != '_' && (c < 65 || c > 90) && (c < 97 || c > 122))
            {
                isTrue = false;
            }
        }
        return