需要五张表:
用户表,菜单表,角色表,用户角色表,角色菜单表
思路:角色是表示一个组,这个角色对应多个菜单,将用户加入到角色即组中,该用户即获得对应菜单的权限
表结构如下:
CREATE TABLE [dbo].[User](
[UserID] [nvarchar](50) NOT NULL,
[UserName] [nvarchar](50) NOT NULL,
[Password] [nvarchar](500) NOT NULL,
[Enable] [nvarchar](1) NOT NULL,
[Mail] [nvarchar](50) NULL,
[AddTime] [datetime2](7) NOT NULL,
[IsLock] [nvarchar](1) NOT NULL,
[QZTC] [nvarchar](1) NOT NULL,
[UserType] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
(
[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_Enable] DEFAULT (N'N') FOR [Enable]
GO
ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_AddTime] DEFAULT (getdate()) FOR [AddTime]
GO
ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_IsLock] DEFAULT (N'N') FOR [IsLock]
GO
ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_QZTC] DEFAULT (N'N') FOR [QZTC]
GO
ALTER TABLE [dbo].[User] A