UserDimensionValueRoleMapper.java 3.92 KB
Newer Older
eddie.woo's avatar
eddie.woo committed
1 2
package pwc.taxtech.atms.dao;

gary's avatar
gary committed
3
import java.util.List;
eddie.woo's avatar
eddie.woo committed
4 5 6 7 8
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;
9
import pwc.taxtech.atms.dpo.UserOrgRoleDto;
10 11
import pwc.taxtech.atms.entity.UserDimensionValueRole;
import pwc.taxtech.atms.entity.UserDimensionValueRoleExample;
eddie.woo's avatar
eddie.woo committed
12 13 14 15 16

@Mapper
public interface UserDimensionValueRoleMapper extends MyMapper {
    /**
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
17
     * This method corresponds to the database table user_dimension_value_role
eddie.woo's avatar
eddie.woo committed
18 19 20 21 22 23 24
     *
     * @mbg.generated
     */
    long countByExample(UserDimensionValueRoleExample example);

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

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

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

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

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

    /**
     * This method was generated by MyBatis Generator.
gary's avatar
gary committed
65
     * This method corresponds to the database table user_dimension_value_role
eddie.woo's avatar
eddie.woo committed
66 67 68 69 70 71 72
     *
     * @mbg.generated
     */
    List<UserDimensionValueRole> selectByExample(UserDimensionValueRoleExample example);

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

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

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

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

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

eddie.woo's avatar
eddie.woo committed
111
    List<UserOrgRoleDto> getUserDimensionValueRoleList();
eddie.woo's avatar
eddie.woo committed
112

gary's avatar
gary committed
113 114 115
    @Select("SELECT user_dimension_value.user_id FROM user_dimension_value_role "
            + "JOIN user_dimension_value ON user_dimension_value_role.user_dimension_value_id = user_dimension_value.id "
            + "WHERE user_dimension_value_role.role_id=#{roleId}")
116
    List<String> getUserIdByUserDimensionValueRole(@Param("roleId") String roleId);
eddie.woo's avatar
eddie.woo committed
117
}