/// <summary>
/// 根据用户ID和授权类型获取列表
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="type">授权类型</param>
/// <returns></returns>
public List <BlackIPInfo> FindByUser(int userId, AuthrizeType type)
{
string sql = string.Format(@"SELECT t.* FROM {0}BLACKIP t INNER JOIN {0}BLACKIP_USER m
ON t.ID=m.BLACKIP_ID WHERE m.User_ID = {1} and t.AuthorizeType={2} and t.Forbid=0 ", OraclePortal.gc._securityTablePre, userId, (int)type);
return(GetList(sql, null));
}
/// <summary>
/// 根据用户ID和授权类型获取列表
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="type">授权类型</param>
/// <returns></returns>
public List <BlackIPInfo> FindByUser(int userId, AuthrizeType type)
{
string sql = string.Format(@"SELECT t.* FROM T_ACL_BLACKIP t INNER JOIN T_ACL_BLACKIP_USER m
ON t.ID=m.BLACKIP_ID WHERE m.User_ID = {0} and t.AuthorizeType={1} and t.Forbid=0 ", userId, (int)type);
return(GetList(sql, null));
}
/// <summary>
/// 根据用户ID和授权类型获取列表
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="type">授权类型</param>
/// <returns></returns>
public List <BlackIPInfo> FindByUser(int userId, AuthrizeType type)
{
IBlackIP dal = baseDal as IBlackIP;
return(dal.FindByUser(userId, type));
}
