菜单相关sql语名.sql

纯ajax无限级树形菜单 纯ajax无限级树形菜单源码

--创建表
CREATE TABLE [dbo].[SysBaseData](
	[BaseDataID] [int] NOT NULL,
	[BaseDataCode] [char](10) NOT NULL,
	[BaseDataName] [varchar](30) NOT NULL,
	[ParentCode] [char](10) NOT NULL,
	[Description] [varchar](100) NULL,
	[LevelType] [int] NOT NULL,
	[VaildType] [char](1) NOT NULL,
	[PathCode] [varchar](100) NULL,
	[SerialNumberID] [int] NOT NULL,
 CONSTRAINT [PK_SysBaseData] PRIMARY KEY NONCLUSTERED 
(
	[BaseDataID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

-- 插入数据
 if exists (select * from sysobjects where id = OBJECT_ID('[SysBaseData]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [SysBaseData] 
 CREATE TABLE [SysBaseData] (  [BaseDataID] [int] NOT NULL , [BaseDataCode] [char] (10) NOT NULL , [BaseDataName] [varchar] (30) NOT NULL , [ParentCode] [char] (10) NOT NULL , [Description] [varchar] (100) NULL ,  [LevelType] [int] NOT NULL , [VaildType] [char] (1) NOT NULL , [PathCode] [varchar] (100) NULL ,  [SerialNumberID] [int] NOT NULL )
 ALTER TABLE [SysBaseData] WITH NOCHECK ADD CONSTRAINT [PK_SysBaseData] PRIMARY KEY  NONCLUSTERED ( [BaseDataID] )

 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 1 , '0         ' , '基础数据' , '-1        ' , 1 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 2 , 'ZD        ' , '总队机关' , '0         ' , 2 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 3 , 'ZD01      ' , '司令部' , 'ZD        ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 4 , 'ZD02      ' , '政治部' , 'ZD        ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 5 , 'ZD03      ' , '后勤部' , 'ZD        ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 6 , 'ZD04      ' , '防火部' , 'ZD        ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 7 , 'SZZD      ' , '市州支队' , '0         ' , 2 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 8 , 'SZZD01    ' , '长沙市消防支队' , 'SZZD      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 9 , 'SZZD02    ' , '湘潭市消防支队' , 'SZZD      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 10 , 'SZZD03    ' , '株州市消防支队' , 'SZZD      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 11 , 'WZLM      ' , '网站栏目(包含专题)' , '0         ' , 2 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 12 , 'WZLM01    ' , '消防新闻' , 'WZLM      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 13 , 'WZLM02    ' , '通知通告' , 'WZLM      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 14 , 'WZLM0101  ' , '总队消闻' , 'WZLM01    ' , 4 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 15 , 'WZLM0102  ' , '支队新闻' , 'WZLM01    ' , 4 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 16 , 'WZQX      ' , '网站权限' , '0         ' , 2 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 17 , 'WZQX01    ' , '基础数据管理' , 'WZQX      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 18 , 'WZQX02    ' , '用户管理' , 'WZQX      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 19 , 'WZQX03    ' , '数据维护管理' , 'WZQX      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 20 , 'WZQX04    ' , '软件下载管理' , 'WZQX      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 21 , 'WZQX05    ' , '首页管理' , 'WZQX      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 22 , 'RJLB      ' , '软件类别' , '0         ' , 2 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 23 , 'RJLB01    ' , '系统软件' , 'RJLB      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 24 , 'RJLB02    ' , '应用软件' , 'RJLB      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 25 , 'RJLB03    ' , '业务软件' , 'RJLB      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 26 , 'DCCK      ' , '弹出窗口模式' , '0         ' , 2 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 27 , 'DCCK01    ' , '春节' , 'DCCK      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 28 , 'DCCK02    ' , '端午节' , 'DCCK      ' , 3 , '0' , 0 )
 INSERT [SysBaseData] ( [BaseDataID] , [BaseDataCode] , [BaseDataName] , [ParentCode] , [LevelType] , [VaildType] , [SerialNumberID] ) VALUES ( 29 , 'DCCK02    ' , '中秋节' , 'DCCK      ' , 3 , '0' , 0 )