protected void Page_Load(object sender, EventArgs e) { Student student = (Student)Session["loginuser"]; string stuAccount = student.StuAccount; TitleRecordBll titleRecordBll = new TitleRecordBll(); TitleRecord titleRecord = titleRecordBll.getRtId(stuAccount); int rtId = titleRecord.TitleRecordId; Path path = pathBll.getState(rtId, 1); pstate = path.state; if (rtId == 0) { //未选题 state = 3; } else { Result result = pathBll.selectByTitleRecordId(rtId.ToString()); if (result == Result.记录存在) { //显示页面 state = 1; } else { state = 0; } } }
public void getData() { PathBll pathBll = new PathBll(); MedtermQualityBll mqBll = new MedtermQualityBll(); ScoreBll scoreBll = new ScoreBll(); GuideRecordBll guideBll = new GuideRecordBll(); CrossBll crossBll = new CrossBll(); DefenceBll dfBll = new DefenceBll(); state = Session["state"].ToString(); if (state == "3") { student = (Student)Session["loginuser"]; stuNO = student.StuAccount; recordResult = Record.selectBystuId(stuNO); if (recordResult) { ds = Record.GetByAccount(stuNO); title = ds.Tables[0].Rows[0]["title"].ToString(); //获取标题 planId = ds.Tables[0].Rows[0]["planId"].ToString(); //获取批次ID Plan plan = planBll.Select(int.Parse(planId)); //获取批次信息 startTime = plan.StartTime; //批次开始时间 endTime = plan.EndTime; //批次结束时间 string dsTime = ds.Tables[0].Rows[0]["createTime"].ToString(); selectTime = Convert.ToDateTime(dsTime); //学生选定题目时间 //获取选题记录ID来取得学生开题报告的信息 titleRecordId = ds.Tables[0].Rows[0]["titleRecordId"].ToString(); if (opBll.selectByRecordId(int.Parse(titleRecordId)) == true) { opReport = opBll.Select(int.Parse(titleRecordId)); opTime = opReport.reportTime; teacherOpenning = opReport.teacherOpinion; pathRe = pathBll.selectByTitleRecordId(titleRecordId); if (pathRe == Result.记录存在) { Path pathRecordId = pathBll.getTitleRecordId(stuNO); TitleRecord tr = pathRecordId.titleRecord; pathds = pathBll.getModel(tr.TitleRecordId, stuNO); //遍历路径信息(type为0时) checkReport = pathBll.getCheckReport(tr.TitleRecordId); //查重 mq = mqBll.Select(tr.TitleRecordId); //遍历中期质量报告 scoreDs = scoreBll.Select(stuNO, int.Parse(planId)); //获取学生成绩 crossGuideDs = crossBll.Select(tr.TitleRecordId); //遍历交叉指导信息 corssDs = crossBll.SelectByStu(stuNO); defenceDs = dfBll.getModel(tr.TitleRecordId.ToString()); //遍历答辩记录信息 } } } //else //{ // Response.Write("你还没有选题,请先进行选题"); //} } else { Response.Write("管理员和教师没有进度条"); } }
protected void Page_Load(object sender, EventArgs e) { TitleRecordBll trbll = new TitleRecordBll(); MedtermQualityBll mqbll = new MedtermQualityBll(); MedtermQuality medterm = new MedtermQuality(); state = Convert.ToInt32(Session["state"].ToString()); int titleRecordId = 0; string op = Request["op"]; if (!IsPostBack) { string stuAccount = Request.QueryString["stuAccount"]; if (stuAccount != null) { Session["stuAccount"] = stuAccount; } else { if (state == 3) { Student student = (Student)Session["loginuser"]; stuAccount = student.StuAccount; } else { stuAccount = Session["stuAccount"].ToString(); } } } if (state == 1) { Teacher teacher = (Teacher)Session["loginuser"]; string teaAccount = teacher.TeaAccount; string acount = Session["stuAccount"].ToString(); TitleRecord titleRecord = trbll.getRtIdByTea(acount, teaAccount); TitleRecord stuTitle = trbll.GetTitleRecord(titleRecord.TitleRecordId); mq = mqbll.Select(titleRecord.TitleRecordId); if (mq == null) { content = "学生未提交中期质量检查"; } else { planFinishSituation = mq.planFinishSituation; stuAccount = acount; stuName = stuTitle.student.RealName; proName = stuTitle.profession.ProName; title = stuTitle.title.title; collegeName = teacher.college.ColName; teaName = teacher.TeaName; MedtermQuality medtermQuality = mqbll.getState(titleRecord.TitleRecordId); mstate = medtermQuality.state; if (mstate == 3) { teacherOpinion = mq.teacherOpinion; } } if (op == "teacher") { try { string opinion = Request["teacher"]; medterm.teacherOpinion = opinion; medterm.dateTime = DateTime.Now; medterm.titleRecord = titleRecord; medterm.state = 3; Result row = mqbll.teaInsert(medterm); if (row == Result.添加成功) { LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师提交 - " + stuTitle.student.StuAccount + " - " + stuTitle.student.RealName + " - 学生的中期质量报告意见"); Response.Write("提交成功"); Response.End(); } else { Response.Write("提交失败"); Response.End(); } } catch (Exception ex) { LogHelper.Error(this.GetType(), ex); } } } else if (state == 3) { try { Student student = (Student)Session["loginuser"]; stuAccount = student.StuAccount; stuName = student.RealName; proName = student.profession.ProName; collegeName = student.college.ColName; DataSet ds = trbll.GetByAccount(stuAccount); TitleRecordBll titleRecordBll = new TitleRecordBll(); TitleRecord titleRecord = titleRecordBll.getRtId(stuAccount); int rtId = titleRecord.TitleRecordId; Result result = pathBll.selectByTitleRecordId(rtId.ToString()); if (ds == null) { content = "暂未选题"; } else { if (result == Result.记录存在) { mq = mqbll.Select(titleRecord.TitleRecordId); if (mq != null) { planFinishSituation = mq.planFinishSituation; } for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string stuaccount = ds.Tables[0].Rows[i]["stuAccount"].ToString(); if (stuaccount == stuAccount) { title = ds.Tables[0].Rows[0]["title"].ToString(); teaName = ds.Tables[0].Rows[0]["teaName"].ToString(); titleRecordId = Convert.ToInt32(ds.Tables[0].Rows[i]["titleRecordId"].ToString()); break; } } MedtermQuality medtermQuality = mqbll.getState(titleRecordId); mstate = medtermQuality.state; if (mstate == 3) { teacherOpinion = mq.teacherOpinion; } } else { content = "暂未提交论文"; } } if (op == "student") { string plan = Request["student"]; medterm.planFinishSituation = plan; medterm.dateTime = DateTime.Now; titleRecord.TitleRecordId = titleRecordId; medterm.titleRecord = titleRecord; medterm.state = 2; Result row = mqbll.stuInsert(medterm); if (row == Result.添加成功) { LogHelper.Info(this.GetType(), student.StuAccount + " - " + student.RealName + " - 学生提交中期质量报告"); Response.Write("提交成功"); Response.End(); } else { Response.Write("提交失败"); Response.End(); } } } catch (Exception ex) { LogHelper.Error(this.GetType(), ex); } } }