package pwc.taxtech.atms.dao; import java.util.List; 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; import pwc.taxtech.atms.dpo.UserOrgRoleDto; import pwc.taxtech.atms.entity.UserDimensionValueRole; import pwc.taxtech.atms.entity.UserDimensionValueRoleExample; @Mapper public interface UserDimensionValueRoleMapper extends MyMapper { /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ long countByExample(UserDimensionValueRoleExample example); /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ int deleteByExample(UserDimensionValueRoleExample example); /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ int deleteByPrimaryKey(String id); /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ int insert(UserDimensionValueRole record); /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ int insertSelective(UserDimensionValueRole record); /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ List<UserDimensionValueRole> selectByExampleWithRowbounds(UserDimensionValueRoleExample example, RowBounds rowBounds); /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ List<UserDimensionValueRole> selectByExample(UserDimensionValueRoleExample example); /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ UserDimensionValueRole selectByPrimaryKey(String id); /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ int updateByExampleSelective(@Param("record") UserDimensionValueRole record, @Param("example") UserDimensionValueRoleExample example); /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ int updateByExample(@Param("record") UserDimensionValueRole record, @Param("example") UserDimensionValueRoleExample example); /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ int updateByPrimaryKeySelective(UserDimensionValueRole record); /** * This method was generated by MyBatis Generator. * This method corresponds to the database table user_dimension_value_role * * @mbg.generated */ int updateByPrimaryKey(UserDimensionValueRole record); List<UserOrgRoleDto> getUserDimensionValueRoleList(); @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}") List<String> getUserIdByUserDimensionValueRole(@Param("roleId") String roleId); }