package com.cloud.user.dao;
|
|
import java.util.List;
|
import java.util.Map;
|
import java.util.Set;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import com.cloud.model.sys.SysRole;
|
|
/**
|
* 用户角色关系
|
*
|
* @author bsk
|
*
|
*/
|
@Mapper
|
public interface UserRoleDao {
|
|
int deleteUserRole(Map<String,Object> params);
|
|
//@Insert("insert into sys_role_user(userId, roleId,orgId) values(#{id}, #{roleId},#{orgId,jdbcType=INTEGER})")
|
int saveUserRoles(Map<String,Object> map);
|
|
/**
|
* 根据用户id获取角色
|
*
|
* @param userId
|
* @param orgId
|
* @return
|
*/
|
//@Select("select r.* from sys_role_user ru inner join sys_role r on r.id = ru.roleId where ru.userId = #{userId} and r.orgId= #{orgId}")
|
Set<SysRole> findRolesByUserId(@Param("userId") Long userId,@Param("orgId") Long orgId);
|
|
List<Integer> findRolesIdsByUserId(Map<String, Object> params);
|
|
List<Integer> findRolesIds(Long id);
|
|
void deleteUserRoleByParams(Map<String, Object> params);
|
|
Integer findUserRoleCount(Map<String, Object> params);
|
}
|
