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) { Student student = (Student)Session["loginuser"]; string stuAccount = student.StuAccount; TitleRecordBll titleRecordBll = new TitleRecordBll(); PathBll pathBll = new PathBll(); TitleRecord titleRecord = titleRecordBll.getRtId(stuAccount); int titleRecordId = titleRecord.TitleRecordId; OpenReport openReport = titleRecordBll.getState(titleRecordId); Path path = pathBll.getState(titleRecordId, 0); openState = openReport.state; state = path.state; }
protected void Page_Load(object sender, EventArgs e) { TitleRecordBll trbll = new TitleRecordBll(); PathBll pathBll = new PathBll(); Teacher teacher = (Teacher)Session["loginuser"]; string teaAccount = teacher.TeaAccount; string op = Context.Request.Form["op"]; string type = Request.QueryString["type"]; if (!IsPostBack) { Search(); getData(Search()); } }
protected void Page_Load(object sender, EventArgs e) { TitleRecordBll trbll = new TitleRecordBll(); PathBll pathBll = new PathBll(); Path path = new Path(); Teacher teacher = (Teacher)Session["loginuser"]; string teaAccount = teacher.TeaAccount; collegeId = teacher.college.ColID; string op = Context.Request.Form["op"]; string type = Request.QueryString["type"]; if (!IsPostBack) { Search(); getPage(Search()); } string agree = Request["agree"]; if (agree != null) { string stuAccount = Request["stuAccount"]; DataSet ds = trbll.GetByAccount(stuAccount); int i = ds.Tables[0].Rows.Count - 1; TitleRecord titleRecord = new TitleRecord(); titleRecord.TitleRecordId = Convert.ToInt32(ds.Tables[0].Rows[i]["titleRecordId"].ToString()); if (agree == "yes") { path.state = 3; } else if (agree == "no") { path.state = 1; } path.type = 1; path.titleRecord = titleRecord; pathBll.updateState(path); } }
protected void Page_Load(object sender, EventArgs e) { tea = (Teacher)Session["loginuser"]; TitleRecordBll trbll = new TitleRecordBll(); PathBll pathBll = new PathBll(); Teacher teacher = (Teacher)Session["loginuser"]; string teaAccount = teacher.TeaAccount; collegeId = teacher.college.ColID; string addop = Context.Request.Form["op"]; string type = Request.QueryString["type"]; op = Request["op"]; try { if (op == "add") { string stuAccount = Request["stuAccount"]; string opinion = Request["opinion"]; GuideRecordBll guideBll = new GuideRecordBll(); GuideRecord guide = new GuideRecord(); DataSet dsTR = trbll.GetByAccount(stuAccount); int i = dsTR.Tables[0].Rows.Count - 1; guide.opinion = opinion; TitleRecord titleRecord = new TitleRecord(); titleRecord.TitleRecordId = Convert.ToInt32(dsTR.Tables[0].Rows[i]["titleRecordId"].ToString()); guide.titleRecord = titleRecord; guide.dateTime = DateTime.Now; path = pathBll.Select(titleRecord.TitleRecordId, stuAccount); guide.path = path; path.titleRecord = titleRecord; path.state = 1; path.type = 0; Result result = pathBll.updateState(path); if (result == Result.更新成功) { Result row = guideBll.Insert(guide); if (row == Result.添加成功) { StudentBll studentBll = new StudentBll(); Student stu = studentBll.GetModel(stuAccount); LogHelper.Info(this.GetType(), tea.TeaAccount + " - " + tea.TeaName + " - 教师添加 - " + stuAccount + " - " + stu.RealName + " - 学生的指导记录"); Response.Write("提交成功"); Response.End(); } else { Response.Write("提交失败"); Response.End(); } } else { Response.Write("提交失败"); Response.End(); } } else if (op == "download") { download = "download"; string account = Request["stuAccount"]; Path getTitleRecordId = pathBll.getTitleRecordId(account); int titleRecordId = getTitleRecordId.titleRecord.TitleRecordId; paperPath = pathBll.Select(titleRecordId, account); //Response.Redirect(paperPath.paperPath); Response.Write("<script>$('#loadHref').href = '" + paperPath.paperPath + "';</script>"); //Response.End(); } if (!IsPostBack) { Search(); getPage(Search()); } } catch (Exception ex) { LogHelper.Error(this.GetType(), ex); } }
public void insert() { //获取评定及成绩 double score = Convert.ToDouble(Request["score"]); string investigation = Request["investigation"]; string practice = Request["practice"]; string solveProblem = Request["solveProblem"]; string workAttitude = Request["workAttitude"]; string quality = Request["quality"]; string evaluate = Request["evaluate"]; string innovate = Request["innovate"]; string crossTea = Request["crossTea"]; //添加评定及成绩 Student student = new Student(); Plan plan = new Plan(); try { student.StuAccount = stuAccount; plan.PlanId = planId; scoreModel.student = student; scoreModel.plan = plan; scoreModel.guideScore = score; scoreModel.investigation = investigation; scoreModel.practice = practice; scoreModel.solveProblem = solveProblem; scoreModel.workAttitude = workAttitude; scoreModel.paperDesign = quality; scoreModel.innovate = innovate; scoreModel.evaluate = evaluate; //添加交叉指导教师 CrossBll crossBll = new CrossBll(); PathBll pathBll = new PathBll(); TitleRecord titleRecord = new TitleRecord(); Cross cross = new Cross(); Path path = new Path(); Teacher teacher = new Teacher(); titleRecord.TitleRecordId = titleRecordId; cross.titleRecord = titleRecord; teacher.TeaAccount = crossTea; cross.teacher = teacher; path.titleRecord = titleRecord; path.state = 3; path.type = 0; Result state = pathBll.updateState(path); if (state == Result.更新成功) { Result recordState = titlebll.updateState(titleRecord.TitleRecordId); if (recordState == Result.更新成功) { Result result = crossBll.Insert(cross); if (result == Result.添加成功) { StudentBll studentBll = new StudentBll(); Student stu = studentBll.GetModel(stuAccount); TeacherBll teacherBll = new TeacherBll(); Teacher tea = teacherBll.GetModel(crossTea); LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师指定 - " + stuAccount + " - " + stu.RealName + " - 学生的交叉指导教师 - " + teacher + " - " + tea.TeaName); Result row = sbll.insertInstructorsComments(scoreModel); if (row == Result.添加成功) { LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师添加 - " + stuAccount + " - " + stu.RealName + " - 学生的指导成绩及评定"); Response.Write("提交成功"); Response.End(); } else { Response.Write("提交失败"); Response.End(); } } else { Response.Write("提交失败"); Response.End(); } } else { Response.Write("提交失败"); Response.End(); } } else { Response.Write("提交失败"); Response.End(); } } catch (Exception ex) { LogHelper.Error(this.GetType(), ex); } }