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);
}