【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了data.sql提供大家参考,希望对大家有所帮助!
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,Fir