<?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.gyee.frame.mapper.custom.RoleVueDao">
  <resultMap id="BaseResultMap" type="com.gyee.frame.model.auto.TvueRole">
    <result column="id" jdbcType="VARCHAR" property="id" />
    <result column="name" jdbcType="VARCHAR" property="name" />
  </resultMap>
  
   <sql id="Base_Column_List">
    id, name
   </sql>
  <select id="queryUserRole" parameterType="String" resultType="com.gyee.frame.model.auto.TvueRole">
        select r.id,r.name  from t_vue_role r
		LEFT JOIN t_vue_role_user ru ON  r.id=ru.sys_role_id
		where ru.sys_user_id=#{userid}
 </select>
</mapper>