protected void initTreeView()
{
CourseManager CourseMan = new CourseManager();
AssignmentManager assignmentMan = new AssignmentManager();
List<Course> CourseList = new List<Course>();
List<Assignment> assignmentList = new List<Assignment>();
TreeView1.Nodes.Clear();
CourseList = CourseMan.GetCourseForStudent(stu.username);
//设置TreeView的节点，包括课程和相应作业
foreach (Course course in CourseList)
{
TreeNode node = new TreeNode();
node.Text = course.name;
TreeView1.Nodes.Add(node);
assignmentList = assignmentMan.getAssignment(course.num);
foreach (Assignment assignment in assignmentList)
{
//未截止
if (DateTime.Now < assignment.end_time)
{
TreeNode NodeChild = new TreeNode();
NodeChild.Text = assignment.title;
node.ChildNodes.Add(NodeChild);
NodeChild.NavigateUrl = "SubmitForm.aspx?AssignmentId=" + assignment.id + "&AssignmentTitle=" + assignment.title; ;
}
}
/*
TreeView1.Nodes[0].Expanded = firstNodeExpandFlag;
TreeView1.Nodes[0].Select();
*/
}
}
protected void initTeacherTreeView()
{
CourseManager CourseMan = new CourseManager();
List<Course> CourseList = new List<Course>();
CourseList = CourseMan.GetCourseForTeacher(tea.username);
TreeView1.Nodes.Clear();
TreeNode mycourse = new TreeNode();
mycourse.Text = "我的课程";
mycourse.NavigateUrl = "AddCourse.aspx";
//设置TreeView的节点，未截止的课程
foreach (Course course in CourseList)
{
if (DateTime.Now < course.end_time)
{
TreeNode node = new TreeNode();
node.Text = course.name;
node.NavigateUrl = "AllAssignment.aspx?Coursenum=" + course.num;
mycourse.ChildNodes.Add(node);
}
}
TreeView1.Nodes.Add(mycourse);
TreeView1.ExpandAll();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserRole"] == null || Session["UserRole"].ToString() != "Student")
{
Response.Write("<Script language='javascript'>alert('您无权访问此页面，请重新登录！');window.history.go(-1);</Script>");
return;
}
CourseManager CourseMan = new CourseManager();
List<Course> CourseList = new List<Course>();
SystemTime.Text = DateTime.Now.ToLongDateString() + " " + DateTime.Now.ToShortTimeString();
stu = (Student)Session["student"];
CourseList = CourseMan.GetCourseForStudent(stu.username);
Session["CourseList"] = CourseList;
if (CourseList.Count == 0)
Response.Redirect("SelectCourse.aspx");
foreach (Course course in CourseList)
{
AssignmentList.AddRange(AssignmentMan.getAssignment(course.num));
}
if (!IsPostBack)
{
GridView3.DataBind();
foreach (Assignment assignment in AssignmentList)
{
TimeSpan ts = Convert.ToDateTime(assignment.end_time) - DateTime.Now;
if ((assignment.end_time > DateTime.Now) && (ts.Days < 1))
{
myArray.Add(assignment);
}
TimeSpan ts2 = DateTime.Now - Convert.ToDateTime(assignment.start_time);
if ((assignment.start_time < DateTime.Now) && (ts2.Days < 7))
{
myArray2.Add(assignment);
}
}
GridView2.DataBind();
GridView1.DataBind();
}
}
//assignment表插入判断
protected void DetailsView4_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
CourseManager course = new CourseManager();
if (e.Values["course"] == null || e.Values["major"] == null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "msg1", "alert('插入失败！assignment表中course,major字段不能为空');", true);
e.Cancel = true;
return;
}
if (course.GetCourseByNum(e.Values["num"].ToString()) == null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "msg1", "alert('插入失败！assignment表中外键num不存在');", true);
e.Cancel = true;
return;
}
}
//course 插入判断
protected void DetailsView3_ItemInserting(object sender, DetailsViewInsertEventArgs e)
{
CourseManager course = new CourseManager();
TeacherManager t = new TeacherManager();
if (e.Values["num"] == null || e.Values["teacher"] == null || e.Values["name"] == null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "msg1", "alert('插入失败！course表中num,teacher,name字段都不能为空');", true);
e.Cancel = true;
return;
}
if (course.GetCourseByNum(e.Values["num"].ToString()) != null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "msg1", "alert('插入失败！course表中num已存在');", true);
e.Cancel = true;
return;
}
if (t.GetTeacher(e.Values["teacher"].ToString())==null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "msg1", "alert('插入失败！course表中外键teacher不存在');", true);
e.Cancel = true;
return;
}
}
