三层+MVC+easyui RBAC通用权限设计与实现（含数据库脚本）

USE [STWL] GO /****** Object: Table [dbo].[Menu] Script Date: 12/07/2017 10:08:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Menu]( [Id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NULL, [url] [varchar](50) NULL, [parentId] [int] NULL, [icon] [varchar](32) NULL, [code] [varchar](32) NULL, CONSTRAINT [PK_menu] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO SET IDENTITY_INSERT [dbo].[Menu] ON INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (1, N'系统管理', NULL, 0, N'ok', NULL) INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (2, N'用户管理', N'/User/Index', 1, N'ok', NULL) INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (3, N'角色管理', N'/Role/Index', 1, N'ok', NULL) INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (4, N'部门管理', N'/Dept/Index', 1, N'ok', NULL) INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (5, N'浏览', NULL, 2, NULL, NULL) INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (6, N'增加', NULL, 2, NULL, N'User-Add') INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (7, N'删除', NULL, 2, NULL, N'User-Delete') INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (8, N'修改', NULL, 2, NULL, N'User-Update') INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (9, N'设置角色', NULL, 2, NULL, N'User-SetRole') INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (10, N'重置密码', NULL, 2, NULL, N'User-ReSetPwd') INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (11, N'浏览', NULL, 3, NULL, NULL) INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (12, N'增加', NULL, 3, NULL, N'Role-Add') INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (13, N'删除', NULL, 3, NULL, N'Role-Delete') INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (14, N'修改', NULL, 3, NULL, N'Role-Update') INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (15, N'设置权限', NULL, 3, NULL, N'Role-SetPri') INSERT [dbo].[Menu] ([Id], [name], [url], [parentId], [icon], [code]) VALUES (16, N'浏览', NULL, 4, NULL, NULL) SET IDENTITY_INSERT [dbo].[Menu] OFF /****** Object: Table [dbo].[Department] Script Date: 12/07/2017 10:08:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Department]( [Id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](32) NULL, [description] [varchar](max) NULL, [parentId] [int] NULL, CONSTRAINT [PK_Department] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO SET IDENTITY_INSERT [dbo].[Department] ON INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (1, N'实践部', N'实践出真理', 0) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (2, N'项目部', N'好好做项目', 1) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (4, N'需求部', N'进行需求分析', 2) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (5, N'代码部', N'编写代码', 2) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (13, N'测试部', N'测试工作执行者', 2) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (14, N'Test', N'Test', 12) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (16, N'特然', N'定时达', 4) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (17, N'特然1', N'定时达', 4) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (18, N'treeview', N'大', 16) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (19, N'问问1', N'大萨达', 1) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (20, N'大', N'大萨达', 1) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (21, N'电风扇', N'第三方', 4) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (22, N'打上', N'sad', 19) INSERT [dbo].[Department] ([Id], [name], [description], [parentId]) VALUES (23, N'是的撒', N'大萨达', 19) SET IDENTITY_INSERT [dbo].[Department] OFF /****** Object: Table [dbo].[Role] Script Date: 12/07/2017 10:08:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Role]( [Id] [int] IDENTITY(1,1) NOT NULL, [name] [varchar](50) NULL, [description] [varchar](max) NULL, CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO SET IDENTITY_INSERT [dbo].[Role] ON INSERT [dbo].[Role] ([Id], [name], [description]) VALUES (1, N'总经理', N'管理公司一切事物') SET IDENTITY_INSERT [dbo].[Role] OFF /****** Object: Table [dbo].[Role_Privilege] Script Date: 12/07/2017 10:08:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Role_Privilege]( [roleId] [int] NOT NULL, [menuId] [int] NOT NULL ) ON [PRIMARY] GO INSERT [dbo].[Role_Privilege] ([roleId], [menuId]) VALUES (1, 1) INSERT [dbo].[Role_Privilege] ([roleId], [menuId]) VALUES (1, 2) INSERT [dbo].[Role_Privilege] ([roleId], [menuId]) VALUES (1, 5) INSERT [dbo].[Role_Privilege] ([roleId], [menuId]) VALUES (1, 6) INSERT [dbo].[Role_Privilege] ([roleId], [menuId]) VALUES (1, 7) INSERT [dbo].[Role_Privilege] ([roleId], [menuId]) VALUES (1, 8) /****** Object: Table [dbo].[Role_Menu] Script Date: 12/07/2017 10:08:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Role_Menu]( [roleId] [int] NOT NULL, [menuId] [int] NOT NULL ) ON [PRIMARY] GO INSERT [dbo].[Role_Menu] ([roleId], [menuId]) VALUES (1, 5) INSERT [dbo].[Role_Menu] ([roleId], [menuId]) VALUES (1, 6) INSERT [dbo].[Role_Menu] ([roleId], [menuId]) VALUES (1, 7) INSERT [dbo].[Role_Menu] ([roleId], [menuId]) VALUES (1, 8) /****** Object: Table [dbo].[UserInfo] Script Date: 12/07/2017 10:08:14 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[UserInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [username] [varchar](32) NULL, [loginname] [varchar](32) NULL, [password] [varchar](32) NULL, [department] [int] NULL, [phion] [varchar](32) NULL, [gender] [char](2) NULL, CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ( [Id] 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 SET ANSI_PADDING OFF GO SET IDENTITY_INSERT [dbo].[UserInfo] ON INSERT [dbo].[UserInfo] ([Id], [username], [loginname], [password], [department], [phion], [gender]) VALUES (1, N'超级管理员', N'admin', N'DB6ED069DE1C52DBD84D5AD0', 1, N'1234567', N'男') INSERT [dbo].[UserInfo] ([Id], [username], [loginname], [password], [department], [phion], [gender]) VALUES (3, N'', N'lx1', N'DB6ED069DE1C52DBD84D5AD0', 5, N'', N' ') INSERT [dbo].[UserInfo] ([Id], [username], [loginname], [password], [department], [phion], [gender]) VALUES (5, N'', N'wz', N'DB6ED069DE1C52DBD84D5AD0', 22, N'', N' ') INSERT [dbo].[UserInfo] ([Id], [username], [loginname], [password], [department], [phion], [gender]) VALUES (6, N'', N'lj',