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; } }