易语言mysql菜单权限分配_菜单权限分配源码奉送V2.0

*****菜单权限分配源码奉送V2.0*****

针对以前版本功能有所扩展，增加了模块单元的操作控制

//使用ActionMainMenuBar、ActionManager、ActionToolBar效果更佳

//也可以MainMenu、ToolBar、ActionList的组合

数据库表：

CREATE TABLE [操作员] (

[操作员ID] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[姓名] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[口令] [varchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[级别] [tinyint] NOT NULL CONSTRAINT [DF_操作员_级别] DEFAULT (2),

[部门ID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[标志] [bit] NOT NULL CONSTRAINT [DF_操作员_标志] DEFAULT (0),

CONSTRAINT [PK_操作员] PRIMARY KEY  CLUSTERED

(

[操作员ID]

)  ON [PRIMARY]

) ON [PRIMARY]

GO

CREATE TABLE [操作员权限] (

[操作员ID] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[功能ID] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[Visible] [bit] NOT NULL CONSTRAINT [DF_操作员权限_Visible] DEFAULT (0),

[Enabled] [bit] NOT NULL CONSTRAINT [DF_操作员权限_Enabled] DEFAULT (0),

[权限组ID] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[操作标识] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,

CONSTRAINT [PK_操作员权限] PRIMARY KEY  CLUSTERED

(

[操作员ID],

[功能ID]

)  ON [PRIMARY]

) ON [PRIMARY]

GO

CREATE TABLE [权限组] (

[权限组ID] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[权限组名称] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[标志] [tinyint] NOT NULL CONSTRAINT [DF_权限组_标志] DEFAULT (0),

CONSTRAINT [PK_权限组] PRIMARY KEY  CLUSTERED

(