use master
go
if exists(select * from sysdatabases where name ='ElectronicInfo')
drop database ElectronicInfo
go
--======================================
--创 建 者 :zhumac
--创建时间 : 2011-05-12
--说 明 :创建数据库
--======================================
create database ElectronicInfo
on
(
filename='G:/ElectronicInfo/web/App_Data/ElectronicInfo_data.mdf',
name = 'ElectronicInfo_data',
size =5mb,
filegrowth=1mb
)
log on
(
filename ='G:/ElectronicInfo/web/App_Data/ElectronicInfo_log.ldf',
name ='ElectronicInfo_log',
size = 5mb,
filegrowth=1mb
)
go
use ElectronicInfo
go
--======================================
--创 建 者 :zhumac
--创建时间 : 2011-05-12
--说 明 :创建菜单表
--======================================
if exists(select * from sysobjects where name ='Menu')
drop table Menu
go
create table Menu
(
MenuID int not null identity(1,1) primary key , --主键 自动增长
MenuName nvarchar(30) not null, --菜单名
ParentID int --父菜单主键
)
go
--======================================
--创 建 者 :zhumac
--创建时间 : 2011-05-12
--说 明 :创建存储过程
--======================================
if exists(select * from sysobjects where name = 'GetRootCategoryID')
drop procedure GetRootCategoryID
go
CREATE PROCEDURE GetRootCategoryID
@nodeID INT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @rootID INT, @currentID INT
SELECT @rootID = ParentID, @currentID = @nodeID FROM Menu WHERE MenuID = @nodeID;
WHILE @rootID >0
BEGIN
SELECT @rootID =ParentID , @currentID = MenuID FROM Menu WHERE MenuID = @rootID;
END
select @currentID
END