UserOrganizationRoleMapper.java 3.94 KB
Newer Older
eddie.woo's avatar
eddie.woo committed
1 2 3 4 5 6 7
package pwc.taxtech.atms.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.session.RowBounds;
import pwc.taxtech.atms.MyMapper;
8
import pwc.taxtech.atms.dpo.UserOrgRoleDto;
9 10
import pwc.taxtech.atms.entity.UserOrganizationRole;
import pwc.taxtech.atms.entity.UserOrganizationRoleExample;
eddie.woo's avatar
eddie.woo committed
11

12 13
import java.util.List;

eddie.woo's avatar
eddie.woo committed
14 15 16 17
@Mapper
public interface UserOrganizationRoleMapper extends MyMapper {
    /**
     * This method was generated by MyBatis Generator.
18
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
19 20 21 22 23 24 25
     *
     * @mbg.generated
     */
    long countByExample(UserOrganizationRoleExample example);

    /**
     * This method was generated by MyBatis Generator.
26
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
27 28 29 30 31 32 33
     *
     * @mbg.generated
     */
    int deleteByExample(UserOrganizationRoleExample example);

    /**
     * This method was generated by MyBatis Generator.
34
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
35 36 37
     *
     * @mbg.generated
     */
38
    int deleteByPrimaryKey(String id);
eddie.woo's avatar
eddie.woo committed
39 40 41

    /**
     * This method was generated by MyBatis Generator.
42
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
43 44 45 46 47 48 49
     *
     * @mbg.generated
     */
    int insert(UserOrganizationRole record);

    /**
     * This method was generated by MyBatis Generator.
50
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
51 52 53 54 55 56 57
     *
     * @mbg.generated
     */
    int insertSelective(UserOrganizationRole record);

    /**
     * This method was generated by MyBatis Generator.
58
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
59 60 61 62 63 64 65
     *
     * @mbg.generated
     */
    List<UserOrganizationRole> selectByExampleWithRowbounds(UserOrganizationRoleExample example, RowBounds rowBounds);

    /**
     * This method was generated by MyBatis Generator.
66
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
67 68 69 70 71 72 73
     *
     * @mbg.generated
     */
    List<UserOrganizationRole> selectByExample(UserOrganizationRoleExample example);

    /**
     * This method was generated by MyBatis Generator.
74
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
75 76 77
     *
     * @mbg.generated
     */
78
    UserOrganizationRole selectByPrimaryKey(String id);
eddie.woo's avatar
eddie.woo committed
79 80 81

    /**
     * This method was generated by MyBatis Generator.
82
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
83 84 85 86 87 88 89
     *
     * @mbg.generated
     */
    int updateByExampleSelective(@Param("record") UserOrganizationRole record, @Param("example") UserOrganizationRoleExample example);

    /**
     * This method was generated by MyBatis Generator.
90
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
91 92 93 94 95 96 97
     *
     * @mbg.generated
     */
    int updateByExample(@Param("record") UserOrganizationRole record, @Param("example") UserOrganizationRoleExample example);

    /**
     * This method was generated by MyBatis Generator.
98
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
99 100 101 102 103 104 105
     *
     * @mbg.generated
     */
    int updateByPrimaryKeySelective(UserOrganizationRole record);

    /**
     * This method was generated by MyBatis Generator.
106
     * This method corresponds to the database table TAX_ADMIN.USER_ORGANIZATION_ROLE
eddie.woo's avatar
eddie.woo committed
107 108 109 110
     *
     * @mbg.generated
     */
    int updateByPrimaryKey(UserOrganizationRole record);
eddie.woo's avatar
eddie.woo committed
111

eddie.woo's avatar
eddie.woo committed
112
    List<UserOrgRoleDto> getUserOrganizationRoleList();
eddie.woo's avatar
eddie.woo committed
113

frank.xa.zhang's avatar
frank.xa.zhang committed
114
    @Select("SELECT USER_ORGANIZATION.USER_ID FROM USER_ORGANIZATION_ROLE "
115
            + "JOIN USER_ORGANIZATION ON USER_ORGANIZATION_ROLE.USER_ORGANIZATION_ID = USER_ORGANIZATION.ID "
116
            + "WHERE USER_ORGANIZATION_ROLE.ROLE_ID=#{roleId}")
117
    List<String> getUserIdByUserOrganizationRole(@Param("roleId") String roleId);
eddie.woo's avatar
eddie.woo committed
118
}