aspnet_Roles_GetAllRoles///aspnet_Roles_RoleExists

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

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

转载于:https://www.cnblogs.com/ruanbl/archive/2006/09/01/491905.html