[摘要]陸續在今年寫了固定資產和低值易耗品，採購模具管理以及將要進行的製程管理等子系統，都是各自寫一個小程序，每次都要搭建下環境。每做一個小系統部署的時候都得打包一次。乾脆做一個簡易框架去實現吧。

權限管理仿照自己協同工作平臺。

表一：菜單管理

CREATE TABLE [dbo].[WinForm_MenuInfo]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](100) NOT NULL, [PARENTID] [int] NOT NULL, [FORMNAME] [nvarchar](200) NULL, [TYPE] [int] NULL, [SORTINDEX] [int] NULL, CONSTRAINT [PK_WinForm_MenuInfo] 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]GOALTER TABLE [dbo].[WinForm_MenuInfo] ADD CONSTRAINT [DF_WinForm_MenuInfo_PARENTID] DEFAULT ((-1)) FOR [PARENTID]GOALTER TABLE [dbo].[WinForm_MenuInfo] ADD CONSTRAINT [DF_WinForm_MenuInfo_TYPE] DEFAULT ((0)) FOR [TYPE]GOALTER TABLE [dbo].[WinForm_MenuInfo] ADD CONSTRAINT [DF_WinForm_MenuInfo_SORTINDEX] DEFAULT ((0)) FOR [SORTINDEX]GO

1

表二：角色管理

CREATE TABLE [dbo].[WinForm_RoleInfo]( [ID] [int] IDENTITY(1,1) NOT NULL, [NAME] [nvarchar](100) NOT NULL, [DESCRIPT] [nvarchar](500) NULL, [PARENTID] [int] NOT NULL, CONSTRAINT [PK_WinForm_RoleInfo] 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

1

表三：角色菜單

CREATE TABLE [dbo].[WinForm_RoleMenu]( [id] [int] IDENTITY(1,1) NOT NULL, [rid] [int] NOT NULL, [mid] [int] NOT NULL, CONSTRAINT [PK_WinForm_RoleMenu] 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

1

菜單管理：

角色授權：

用戶角色管理