aspnet_Roles_GetAllRoles
ALTER PROCEDURE dbo.aspnet_Roles_GetAllRoles ----获取全部角色
(
@ApplicationName NVARCHAR(256))
AS
BEGIN
DECLARE @ApplicationId UNIQUEIDENTIFIER
SELECT @ApplicationId = NULL
SELECT @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
IF (@ApplicationId IS NULL)
RETURN
SELECT RoleName
FROM dbo.aspnet_Roles WHERE ApplicationId = @ApplicationId
ORDER BY RoleName
/*好象是最简单的一个了,按RoleName排序*/
END
aspnet_Roles_RoleExists(
@ApplicationName NVARCHAR(256))
AS
BEGIN
DECLARE @ApplicationId UNIQUEIDENTIFIER
SELECT @ApplicationId = NULL
SELECT @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
IF (@ApplicationId IS NULL)
RETURN
SELECT RoleName
FROM dbo.aspnet_Roles WHERE ApplicationId = @ApplicationId
ORDER BY RoleName
/*好象是最简单的一个了,按RoleName排序*/
END
ALTER PROCEDURE dbo.aspnet_Roles_RoleExists
@ApplicationName NVARCHAR(256),
@RoleName NVARCHAR(256)
AS
BEGIN
DECLARE @ApplicationId UNIQUEIDENTIFIER
SELECT @ApplicationId = NULL
SELECT @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
IF (@ApplicationId IS NULL)
RETURN(0)
/*返回@ApplicationId的一段,开始烦这段代码了,都要来个,写的时候还真辛苦啊他们,当然不是我*/
IF (EXISTS (SELECT RoleName FROM dbo.aspnet_Roles WHERE LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId ))
/*如果存在此角色返回1,不存在返回0.这个好象也很简单*/
RETURN(1)
ELSE
RETURN(0)
END
@ApplicationName NVARCHAR(256),
@RoleName NVARCHAR(256)
AS
BEGIN
DECLARE @ApplicationId UNIQUEIDENTIFIER
SELECT @ApplicationId = NULL
SELECT @ApplicationId = ApplicationId FROM aspnet_Applications WHERE LOWER(@ApplicationName) = LoweredApplicationName
IF (@ApplicationId IS NULL)
RETURN(0)
/*返回@ApplicationId的一段,开始烦这段代码了,都要来个,写的时候还真辛苦啊他们,当然不是我*/
IF (EXISTS (SELECT RoleName FROM dbo.aspnet_Roles WHERE LOWER(@RoleName) = LoweredRoleName AND ApplicationId = @ApplicationId ))
/*如果存在此角色返回1,不存在返回0.这个好象也很简单*/
RETURN(1)
ELSE
RETURN(0)
END