<?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.zjrs.zwnw.portal.entity.SysUserMapper">
    <resultMap id="BaseResultMap" type="org.mohrss.leaf.core.security.model.BaseUser">
        <id column="USERID" jdbcType="VARCHAR" property="userid"/>
        <result column="USERNAME" jdbcType="VARCHAR" property="username"/>
        <result column="LOGINID" jdbcType="VARCHAR" property="loginid"/>
        <result column="ORGID" jdbcType="VARCHAR" property="orgid"/>
        <result column="PASSWD" jdbcType="VARCHAR" property="passwd"/>
        <result column="CREATEUSERID" jdbcType="VARCHAR" property="createuserid"/>
        <result column="CREATETIME" jdbcType="TIMESTAMP" property="createtime"/>
        <result column="SORTNO" jdbcType="DECIMAL" property="sortno"/>
        <result column="SEX" jdbcType="CHAR" property="sex"/>
        <result column="FAILNO" jdbcType="DECIMAL" property="failno"/>
        <result column="PWEDITDATE" jdbcType="TIMESTAMP" property="pweditdate"/>
        <result column="USERSTATE" jdbcType="CHAR" property="userstate"/>
        <result column="USERTYPE" jdbcType="VARCHAR" property="usertype"/>
        <result column="CARDTYPE" jdbcType="CHAR" property="cardtype"/>
        <result column="CARDID" jdbcType="VARCHAR" property="cardid"/>
        <result column="PWEXPIRETYPE" jdbcType="CHAR" property="pwexpiretype"/>
        <result column="LOCKTIME" jdbcType="TIMESTAMP" property="locktime"/>
        <result column="UNLOCKTIME" jdbcType="TIMESTAMP" property="unlocktime"/>
        <result column="LOCKREASON" jdbcType="VARCHAR" property="lockreason"/>
        <result column="USEREXPIREDATE" jdbcType="TIMESTAMP" property="userexpiredate"/>
        <result column="PWEXPIREDATE" jdbcType="TIMESTAMP" property="pwexpiredate"/>
        <result column="REMARK" jdbcType="VARCHAR" property="remark"/>
        <result column="TEL" jdbcType="VARCHAR" property="tel"/>
        <result column="MOBILE" jdbcType="VARCHAR" property="mobile"/>
        <result column="USERADDR" jdbcType="VARCHAR" property="useraddr"/>
        <result column="EMAIL" jdbcType="VARCHAR" property="email"/>
    </resultMap>
    <sql id="Base_Column_List">
        USERID, USERNAME, LOGINID, ORGID, PASSWD, CREATEUSERID, CREATETIME, SORTNO, SEX,
        FAILNO, PWEDITDATE, USERSTATE, USERTYPE, CARDTYPE, CARDID, PWEXPIRETYPE, LOCKTIME,
        UNLOCKTIME, LOCKREASON, USEREXPIREDATE, PWEXPIREDATE, REMARK, TEL, MOBILE, USERADDR,
        EMAIL
    </sql>

    <select id="queryAllUserInfo" resultType="HashMap">
        select userid,username from sysuser order by createtime asc
    </select>

</mapper>
