<?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.TsysUserDao">
  <resultMap id="BaseResultMap" type="com.gyee.frame.model.auto.TsysUser">
    <id column="id" jdbcType="VARCHAR" property="id" />
    <result column="username" jdbcType="VARCHAR" property="username" />
    <result column="password" jdbcType="VARCHAR" property="password" />
    <result column="nickname" jdbcType="VARCHAR" property="nickname" />
    <result column="dep_id" jdbcType="INTEGER" property="depId" />
    <result column="pos_id" jdbcType="VARCHAR" property="posId" />
    <result column="dep_name" jdbcType="INTEGER" property="depName" />
    <result column="pos_name" jdbcType="VARCHAR" property="posName" />
  </resultMap>
  
  
 <select id="queryUserName" parameterType="String" resultType="com.gyee.frame.model.auto.TsysUser">
       select * from t_sys_user where username=#{username}
 </select>
 
 
 <select id="queryUserInfo" resultMap="BaseResultMap" parameterType="String">
   	select id, username, password, nickname, 
	(select dept_name from t_sys_department dep where dep.id=tsu.dep_id)as dep_name,
	(select post_name from t_sys_position pos where pos.id=tsu.pos_id)as pos_name,
	dep_id, pos_id
	from t_sys_user tsu 
	<if test="_parameter != null and _parameter!=''" >
       where  username= #{_parameter}
    </if>
	order by id+0 DESC
  </select>
 
 
 
 
 
</mapper>