//answer表插入判断 protected void DetailsView7_ItemInserting(object sender, DetailsViewInsertEventArgs e) { StudentManager stu = new StudentManager(); ProblemManager p = new ProblemManager(); if (e.Values["student"] == null || e.Values["problem"] == null) { ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "msg1", "alert('插入失败!answer表中Student,prob字段不能为空');", true); e.Cancel = true; return; } if (stu.GetStudent(e.Values["student"].ToString()) == null) { ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "msg1", "alert('插入失败!answer表中外键student字段不存在');", true); e.Cancel = true; return; } if(p.GetProblemById(int.Parse(e.Values["problem"].ToString()))==null) { ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "msg1", "alert('插入失败!answer表中外键problem字段不存在');", true); e.Cancel = true; return; } }
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; } //获取作业id id = Request.QueryString["AssignmentId"]; header_text.Text = Request.QueryString["AssignmentTitle"]; ProblemManager ProblemMan = new ProblemManager(); stu = (Student)Session["student"]; ProblemList = ProblemMan.GetProblem(System.Int32.Parse(id)); if (ProblemList.Count != 0) { //动态创建问题及回答区域 //加载上次答案 AnswerList = AnswerMan.GetAnswerList(stu.username, System.Int32.Parse(id)); accessory = AccessoryMan.GetAccessory(stu.username, System.Int32.Parse(id)); for (int i = 0; i < ProblemList.Count; i++) { string pro = "<p>" + ProblemList[i].title + "</p>"; Control ct = ParseControl(pro); PlaceHolder1.Controls.Add(ct); string an = "<p><textarea cols='120' rows='15' name='TA' id='TA" + i + "'></textarea></p>"; //加载已有答案 if (AnswerList != null) { an = "<p><textarea cols='120' rows='15' name='TA' id='TA" + i + "'>" + AnswerList[i].content + "</textarea></p>"; submitFlag = false; } Control ct2 = ParseControl(an); PlaceHolder1.Controls.Add(ct2); } //加载已有附件 if (accessory != null) { fileTips.Text = "已有附件,无需再添加!"; FileUpload2.Enabled = false; } } else { header_text.Text = " 逗你玩呢,哈哈哈哈。"; submit.Enabled = false; submit2.Enabled = false; export.Enabled = false; export2.Enabled = false; fileTips.Enabled = false; FileUpload2.Enabled = false; } }