MIS系统源代码.zip

--------------------- 删除yuangong_tab表中 flag3字段 fengongsi_id字段 flag2字段的定意:1为操作员,2为非操作员 flag1字段的定意:0为离职,1为在职 加入yuangong_mm(用户密码) 加入group_id(用户组编号) --------------------- 将菜单中"部门角色权限"修改为"用户组权限设制" 将菜单中"操作员权限"删除 ----------- 新增的表 if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[group_tab]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[group_tab] GO CREATE TABLE [dbo].[group_tab] ( [group_id] [char] (5) COLLATE Chinese_PRC_CI_AS NOT NULL , [group_name] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [group_app] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[group_menu]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[group_menu] GO CREATE TABLE [dbo].[group_menu] ( [group_id] [char] (5) COLLATE Chinese_PRC_CI_AS NOT NULL , [mod_id] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [menu_id] [char] (10) COLLATE Chinese_PRC_CI_AS NULL , [type] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO