data.sql

这是1个数据库

use park 
go

delete from UserView
go

delete from Navigator
go

delete from Enum
go

/* Common Task */

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('CommonTask','Security/SetPassword.ascx',NULL,NULL,'更改密码')


insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('CommonTask','Security/logout.ascx',NULL,NULL,'注销')
go

/* Statisitics */

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('MasterSpecialTask','Statisitics/Statisitics.ascx','Statisitics',NULL,'统计图表')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('Statisitics','Statisitics/StudentSelectCourse.ascx','',NULL,'每门课选课人数')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('Statisitics','Statisitics/EachClassSupport.ascx','',NULL,'老师得票率')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('Statisitics','Statisitics/TeacherSelectCourse.ascx','',NULL,'教师教课统计')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('Statisitics','Statisitics/ListEachCourseStudent.ascx','',NULL,'学生选课统计')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
	values('Statisitics','Statisitics/ListBelowTwo.ascx','',NULL, '少选课的学生')

go

/* Add Member */

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('MasterSpecialTask','Member/Member.ascx','MemberAdd',NULL,'添加人员')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('MemberAdd','Member/AddTeacher.ascx','',NULL,'添加老师')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('MemberAdd','Member/AddStudent.ascx','',NULL,'添加学生')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('MemberAdd','Member/ListTeacher.ascx','',NULL,'列出老师')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('MemberAdd','Member/ListStudent.ascx','',NULL,'列出学生')


go

/* Teaching Information */

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('MasterSpecialTask','CourseSystem/CourseSystem.ascx','CoursesSystem',NULL,'课程设置')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('CoursesSystem','CourseSystem/AddCourse.ascx','',NULL,'添加课程')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('CoursesSystem','CourseSystem/ListCourses.ascx','',NULL,'列出所有课程')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('CoursesSystem','CourseSystem/TeacherStatus.ascx','',NULL,'教师开课设置')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('CoursesSystem','CourseSystem/StudentStatus.ascx','',NULL,'学生选课设置')

go

/* Classes Information */

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('MasterSpecialTask','ClassSystem/ClassSystem.ascx','ClassesSystem',NULL,'班级设置')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('ClassesSystem','ClassSystem/ListClasses.ascx','',NULL,'列出所有班级')

go

/* Add Student Class */

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('MasterSpecialTask','StudentClass/StudentClass.ascx','ClassAdd',NULL,'添加学生班级')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('ClassAdd','StudentClass/AddStudentClass.ascx','',NULL,'添加学生班级')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('ClassAdd','StudentClass/ListStudentClass.ascx','',NULL,'列出学生班级')

go

insert into UserView(Role,FirstIndex,SecondIndex,ThirdIndex,Content,Title)
	values('Master','CommonTask','MasterSpecialTask',NULL,'Security/welcome.ascx','教务主任')



insert into UserView(Role,FirstIndex,SecondIndex,ThirdIndex,Content,Title)
	values('Anonymous',NULL,NULL,NULL,'Security/login.ascx','缺省用户')

/* Teacher Task Information */

insert into UserView(Role,FirstIndex,SecondIndex,ThirdIndex,Content,Title)
	values('Teacher','CommonTask','TeacherSpecialTask',NULL,'Security/welcome.ascx','教师')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
	values('TeacherSpecialTask','TeacherSystem/ShowTeacher.ascx','',NULL, '显示个人信息')

INSERT INTO Navigator
 values('TeacherSpecialTask', 'TeacherSystem/TeacherSelectCourse.ascx',NULL,NULL,'开课')

INSERT INTO Navigator 
values('TeacherSpecialTask', 'TeacherSystem/TeacherSelectedCourse.ascx', NULL,NULL, '列出已选课程')

go


/* Student Task Information */

insert into UserView(Role,FirstIndex,SecondIndex,ThirdIndex,Content,Title)
	values('Student','CommonTask','StudentSpecialTask',NULL,'Security/welcome.ascx','学生')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
	values('StudentSpecialTask','StudentSystem/ShowStudent.ascx','',NULL, '显示个人信息')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('StudentSpecialTask','StudentSystem/StudentAddClass.ascx',NULL,NULL,'选课')

insert into Navigator(IndexName,Content,ChildIndexName,Icon,Title)
values('StudentSpecialTask','StudentSystem/StudentListClasses.ascx',NULL,NULL,'列出已选课程')

go


insert into Login(UserID,[Password],Role) values ( 'default','','Anonymous' )
insert into Login(UserID,[Password],Role) values ( 'root','','Master' )   
go

delete from Content
go

insert into Content(Content,[Help],Role,NextContent)
	values('Security/login.ascx',NULL,'Anonymous',NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Security/welcome.ascx',NULL,'Master',NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Security/logout.ascx',NULL,'Master',NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Member/AddTeacher.ascx',NULL,'Master','Member/ListTeacher.ascx')

insert into Content(Content,[Help],Role,NextContent)
	values('Member/ListTeacher.ascx',NULL,'Master',NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Member/AddStudent.ascx',NULL,'Master','Member/ListStudent.ascx')

insert into Content(Content,[Help],Role,NextContent)
	values('Member/ListStudent.ascx',NULL,'Master',NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('ClassSystem/ListClasses.ascx',NULL,'Master',NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('ClassSystem/EditClass.ascx',NULL,'Master','ClassSystem/ListClasses.ascx')

insert into Content(Content,[Help],Role,NextContent)
	values('StudentClass/AddStudentClass.ascx',NULL,'Master','StudentClass/ListStudentClass.ascx')

insert into Content(Content,[Help],Role,NextContent)
	values('StudentClass/ListStudentClass.ascx',NULL,'Master',NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Security/welcome.ascx',NULL,'Student',NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Security/logout.ascx',NULL,'Student',NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Security/welcome.ascx',NULL,'Teacher',NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Security/logout.ascx',NULL,'Teacher',NULL)

go

insert into Content(Content,[Help],Role,NextContent)
	values('Security/SetPassword.ascx',NULL,'Master','Security/Success.ascx')
insert into Content(Content,[Help],Role,NextContent)
	values('Security/Success.ascx',NULL,'Master', null)

insert into Content(Content,[Help],Role,NextContent)
	values('Security/SetPassword.ascx',NULL,'Teacher','Security/Success.ascx')
insert into Content(Content,[Help],Role,NextContent)
	values('Security/Success.ascx',NULL,'Teacher', null)

insert into Content(Content,[Help],Role,NextContent)
	values('Security/SetPassword.ascx',NULL,'Student','Security/Success.ascx')
insert into Content(Content,[Help],Role,NextContent)
	values('Security/Success.ascx',NULL,'Student', null)
go

insert into Content(Content,[Help],Role,NextContent)
	values('Statisitics/EachClassSupport.ascx',NULL,'Master', NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Statisitics/StudentSelectCourse.ascx',NULL,'Master', NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Statisitics/TeacherSelectCourse.ascx',NULL,'Master', NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Statisitics/ListEachCourseStudent.ascx',NULL,'Master', NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('Statisitics/ListBelowTwo.ascx',NULL,'Master', NULL)

go

insert into Content(Content,[Help],Role,NextContent)
	values('CourseSystem/AddCourse.ascx',NULL,'Master', 'CourseSystem/EditCourse.ascx')

insert into Content(Content,[Help],Role,NextContent)
	values('CourseSystem/ListCourses.ascx',NULL,'Master', NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('CourseSystem/TeacherStatus.ascx',NULL,'Master', NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('CourseSystem/StudentStatus.ascx',NULL,'Master', NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('CourseSystem/EditCourse.ascx',NULL,'Master', 'CourseSystem/EditCourse.ascx')

INSERT INTO Content(Content,[Help],Role,NextContent)
 values('TeacherSystem/TeacherSelectCourse.ascx',NULL, 'Teacher', 'TeacherSystem/TeacherSelectedCourse.ascx')

INSERT INTO Content(Content,[Help],Role,NextContent)
 values('TeacherSystem/ConfirmDelete.ascx',NULL, 'Teacher', 'TeacherSystem/TeacherSelectedCourse.ascx')

INSERT INTO Content(Content,[Help],Role,NextContent)
 values('TeacherSystem/TeacherSelectedCourse.ascx',NULL, 'Teacher', NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('TeacherSystem/ShowTeacher.ascx',NULL,'Teacher', NULL)
	

insert into Content(Content,[Help],Role,NextContent)
	values('StudentSystem/StudentAddClass.ascx',NULL,'Student', 'StudentSystem/StudentListClasses.ascx')

insert into Content(Content,[Help],Role,NextContent)
	values('StudentSystem/StudentListClasses.ascx',NULL,'Student', NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('StudentSystem/ShowStudent.ascx',NULL,'Student', NULL)	

insert into Content(Content,[Help],Role,NextContent)
	values('CourseSystem/StopSelecting.ascx',NULL,'Teacher', NULL)

insert into Content(Content,[Help],Role,NextContent)
	values('CourseSystem/StopSelecting.ascx',NULL,'Student', NULL)

INSERT INTO Content(Content,[Help],Role,NextContent)
VALUES('Member/EditTeacher.ascx', NULL, 'Master', 'Member/ListTeacher.ascx')

INSERT INTO Content(Content,[Help],Role,NextContent)	
VALUES('Member/EditStudent.ascx', NULL, 'Master', 'Member/ListStudent.ascx')
go

/* Help goes Here */
insert into Content(Content,[Help],Role,NextContent)
	values('Member/Member.ascx',NULL,'Master', NULL)
insert into Content(Content,[Help],Role,NextContent)
	values('Statisitics/Statisitics.ascx',NULL,'Master', NULL)
insert into Content(Content,[Help],Role,NextContent)
	values('StudentClass/StudentClass.ascx',NULL,'Master', NULL)
insert into Content(Content,[Help],Role,NextContent)
	values('ClassSystem/ClassSystem.ascx',NULL,'Master', NULL)
insert into Content(Content,[Help],Role,NextContent)
	values('CourseSystem/CourseSystem.ascx',NULL,'Master', NULL)


insert into Enum(Type,Info) values(1,'开课')
insert into Enum(Type,Info) values(2,'学生班级')
insert into Enum(Type,Info) values(3,'停课')

insert into Enum(Type,Info) values(11,'助教')
insert into Enum(Type,Info) values(12,'讲师')
insert into Enum(Type,Info) values(13,'副教授')
insert into Enum(Type,Info) values(14,'教授')
go