protected void Page_Load(object sender, EventArgs e) { Student student = (Student)Session["loginuser"]; string stuAccount = student.StuAccount; TitleRecordBll trecordBll = new TitleRecordBll(); ds = trecordBll.GetByAccount(stuAccount); if (ds != null) { int i = ds.Tables[0].Rows.Count - 1; int titleRecordId = Convert.ToInt32(ds.Tables[0].Rows[i]["titleRecordId"].ToString()); name = ds.Tables[0].Rows[i]["teaName"].ToString(); sex = ds.Tables[0].Rows[i]["teaSex"].ToString(); phone = ds.Tables[0].Rows[i]["teaPhone"].ToString(); email = ds.Tables[0].Rows[i]["teaEmail"].ToString(); GuideRecordBll guideBll = new GuideRecordBll(); dsGuide = guideBll.Select(titleRecordId); if (dsGuide != null) { int j = dsGuide.Tables[0].Rows.Count - 1; if (j < 0) { opinion = "<h3 class='text-primary'>教师未回复,请耐心等待</h3>"; } else { opinion = "教师最新回复:" + dsGuide.Tables[0].Rows[j]["opinion"].ToString(); } } else { opinion = "<h3 class='text-primary'>教师未回复,请耐心等待</h3>"; } } }
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(); student = (Student)Session["loginuser"]; stuAccount = student.StuAccount; stuName = student.RealName; profession = student.profession.ProName; dsTR = trbll.GetByAccount(stuAccount); if (dsTR == null) { opinion = "暂未选题"; } else { for (int i = 0; i < dsTR.Tables[0].Rows.Count; i++) { string stuaccount = dsTR.Tables[0].Rows[i]["stuAccount"].ToString(); if (stuaccount == stuAccount) { title = dsTR.Tables[0].Rows[0]["title"].ToString(); teaName = dsTR.Tables[0].Rows[0]["teaName"].ToString(); planId = Convert.ToInt32(dsTR.Tables[0].Rows[0]["planId"].ToString()); titleRecordId = Convert.ToInt32(dsTR.Tables[0].Rows[0]["titleRecordId"].ToString()); break; } } OpenReport openReport = trbll.getState(titleRecordId); state = openReport.state; or = orbll.Select(titleRecordId); open = orbll.Select(titleRecordId); if (open == null) { opinion = "教师未回复,请耐心等待"; } else { opinion = open.teacherOpinion; deanOpinion = open.deanOpinion; } } Result result = orbll.isOpenReport(stuAccount, planId); if (result == Result.记录存在) { insert(); } }
protected void Page_Load(object sender, EventArgs e) { stuAccount = Request.QueryString["stuAccount"]; if (stuAccount != null) { Session["stuAccount"] = stuAccount; } else { stuAccount = Session["stuAccount"].ToString(); } ds = titlebll.GetByAccount(stuAccount); planId = Convert.ToInt32(ds.Tables[0].Rows[0]["planId"]); string op = Request["op"]; if (op == "submit") { insert(); } }
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); } }
//获取表格数据 public void getPage(String strWhere) { string currentPage = Request.QueryString["currentPage"]; if (currentPage == null || currentPage.Length <= 0) { currentPage = "1"; } CrossBll crossBll = new CrossBll(); Teacher tea = (Teacher)Session["loginuser"]; teaAccount = tea.TeaAccount; TitleRecordBll trbll = new TitleRecordBll(); DataSet ds = trbll.GetByAccount(teaAccount); if (ds != null) { int i = ds.Tables[0].Rows.Count - 1; int titleRecoreId = Convert.ToInt32(ds.Tables[0].Rows[i]["titleRecordId"].ToString()); } DataSet dsTRAll = trbll.Select(); string where1 = "teaAccount = " + teaAccount; string where2 = "teaAccount = " + teaAccount + " and " + strWhere; TableBuilder tabuilder = new TableBuilder() { StrTable = "V_Cross", StrWhere = strWhere == null || strWhere == "" ? where1 : where2, IntColType = 0, IntOrder = 0, IntPageNum = int.Parse(currentPage), IntPageSize = pagesize, StrColumn = "titleRecordId", StrColumnlist = "*" }; getCurrentPage = int.Parse(currentPage); dsTR = crossBll.SelectBypage(tabuilder, out count); }
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); } } }
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); } }
protected void Page_Load(object sender, EventArgs e) { TitleRecordBll trbll = new TitleRecordBll(); OpenReportBll orbll = new OpenReportBll(); Teacher teacher = (Teacher)Session["loginuser"]; string teaAccount = teacher.TeaAccount; DataSet ds = trbll.GetByAccount(teaAccount); int titleRecordId = 0; string account = Request.QueryString["stuAccount"]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string stuaccount = ds.Tables[0].Rows[i]["stuAccount"].ToString(); if (stuaccount == account) { stuAccount = stuaccount; stuName = ds.Tables[0].Rows[i]["realName"].ToString(); proName = ds.Tables[0].Rows[i]["proName"].ToString(); title = ds.Tables[0].Rows[i]["title"].ToString(); titleRecordId = Convert.ToInt32(ds.Tables[0].Rows[i]["titleRecordId"].ToString()); break; } } or = orbll.Select(titleRecordId); teaName = teacher.TeaName; string op = Request["op"]; string teacherOpinion = Request["teacherOpinion"]; string deanOpinion = Request["deanOpinion"]; try { if (op == "no") { int openId = or.openId; Result row = orbll.teaInsert(openId, teacherOpinion); Result state = orbll.updateState(1, titleRecordId); if (deanOpinion != "") { Result dean = orbll.deanInsert(openId, teacherOpinion); if (row == Result.添加成功 && dean == Result.添加成功) { LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师不同意并回复 - " + stuAccount + " - " + stuName + " - 学生的开题报告"); Response.Write("提交成功"); Response.End(); } else { Response.Write("提交失败"); Response.End(); } } if (row == Result.添加成功) { LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师不同意并回复 - " + stuAccount + " - " + stuName + " - 学生的开题报告"); Response.Write("提交成功"); Response.End(); } else { Response.Write("提交失败"); Response.End(); } } else if (op == "yes") { int openId = or.openId; Result row = orbll.teaInsert(openId, teacherOpinion); Result state = orbll.updateState(3, titleRecordId); if (deanOpinion != "") { Result dean = orbll.deanInsert(openId, teacherOpinion); if (row == Result.添加成功 && dean == Result.添加成功 && state == Result.更新成功) { LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师同意并回复 - " + stuAccount + " - " + stuName + " - 学生的开题报告"); Response.Write("提交成功"); Response.End(); } else { Response.Write("提交失败"); Response.End(); } } if (row == Result.添加成功 && state == Result.更新成功) { LogHelper.Info(this.GetType(), teacher.TeaAccount + " - " + teacher.TeaName + " - 教师同意并回复 - " + stuAccount + " - " + stuName + " - 学生的开题报告"); Response.Write("提交成功"); Response.End(); } else { Response.Write("提交失败"); Response.End(); } } } catch (Exception ex) { LogHelper.Error(this.GetType(), ex); } }
protected void Page_Load(object sender, EventArgs e) { TitleRecordBll trbll = new TitleRecordBll(); ScoreBll sbll = new ScoreBll(); Student student = (Student)Session["loginuser"]; stuAccount = student.StuAccount; stuName = student.RealName; proName = student.profession.ProName; DataSet dsTR = trbll.GetByAccount(stuAccount); if (dsTR == null) { content = "暂未选题"; } else { int planId = 0; for (int i = 0; i < dsTR.Tables[0].Rows.Count; i++) { string stuaccount = dsTR.Tables[0].Rows[i]["stuAccount"].ToString(); if (stuaccount == stuAccount) { titleRecordId = Convert.ToInt32(dsTR.Tables[0].Rows[0]["titleRecordId"].ToString()); title = dsTR.Tables[0].Rows[0]["title"].ToString(); planId = Convert.ToInt32(dsTR.Tables[0].Rows[0]["planId"].ToString()); break; } } Score _score = sbll.getState(titleRecordId.ToString()); state = _score.state; if (state == 0 || state == 1 || state == 2) { content = "暂无成绩"; } else { //获取成绩 DataSet ds = sbll.Select(stuAccount, planId); int openState = Convert.ToInt32(ds.Tables[0].Rows[0]["openState"].ToString()); if (openState == 0) { Response.Write("成绩还未开放查询,请耐心等待"); Response.End(); } else { double guideScore = 0, crossScore = 0, defenceScore = 0; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string remarks = ds.Tables[0].Rows[i]["remarks"].ToString(); if (remarks == "指导成绩") { guideScore = Convert.ToDouble(ds.Tables[0].Rows[i]["score"].ToString()); } else if (remarks == "交叉评阅") { crossScore = Convert.ToDouble(ds.Tables[0].Rows[i]["score"].ToString()); } else if (remarks == "答辩成绩") { defenceScore = Convert.ToDouble(ds.Tables[0].Rows[i]["score"].ToString()); } } score = guideScore * 0.4 + crossScore * 0.3 + defenceScore * 0.3; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { stuAccount = Request.QueryString["stuAccount"]; titleRecordId = Convert.ToInt32(Request.QueryString["titleRecordId"]); if (stuAccount != null) { Session["stuAccount"] = stuAccount; Session["titleRecordId"] = titleRecordId; } else { stuAccount = Session["stuAccount"].ToString(); titleRecordId = Convert.ToInt32(Session["titleRecordId"].ToString()); } } //获取查重报告状态 Path path = pathBll.getState(titleRecordId, 1); if (path == null) { checkState = 0; } else { checkState = path.state; } //获取中期质量报告状态 MedtermQualityBll qualityBll = new MedtermQualityBll(); MedtermQuality medterm = qualityBll.getState(titleRecordId); if (medterm == null) { midState = 0; } else { midState = medterm.state; } //获取论文完成状态 Path pathPaper = pathBll.getState(titleRecordId, 0); if (pathPaper == null) { paperState = 0; } else { paperState = pathPaper.state; } getData = titlebll.GetByAccount(stuAccount); int i = getData.Tables[0].Rows.Count - 1; planId = Convert.ToInt32(getData.Tables[0].Rows[i]["planId"]); int proId = Convert.ToInt32(getData.Tables[0].Rows[i]["proId"]); teacher = (Teacher)Session["loginuser"]; TeacherBll teaBll = new TeacherBll(); int a = teacher.college.ColID; dsTitle = teaBll.getByColl(teacher.college.ColID, teacher.TeaAccount); string op = Request["op"]; if (op == "submit") { insert(); } }