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) { string account = "", teaAccount = ""; int college = 0; int state = Convert.ToInt32(Session["state"].ToString()); if (state == 1) { Teacher tea = (Teacher)Session["loginuser"]; account = tea.TeaAccount; college = tea.college.ColID; } else if (state == 0 || state == 2) { Teacher admin = (Teacher)Session["user"]; account = admin.TeaAccount; college = admin.college.ColID; } else if (state == 3) { Student stu = (Student)Session["loginuser"]; account = stu.StuAccount; college = stu.college.ColID; TitleRecordBll trBll = new TitleRecordBll(); bool flag = trBll.selectBystuId(account); if (flag == true) { TableBuilder tbd = new TableBuilder() { StrTable = "V_TitleRecord", StrColumn = "titleRecordId", IntColType = 0, IntOrder = 0, StrColumnlist = "*", IntPageSize = 1, IntPageNum = 1, StrWhere = "stuAccount ='" + account + "'" }; dsTea = trBll.SelectBypage(tbd, out count); teaAccount = dsTea.Tables[0].Rows[0]["teaAccount"].ToString(); } } if (!Page.IsPostBack) { roleId = Request.QueryString["roleId"]; if (roleId == "0") { strteaType = "teaType=0"; newsType = "学校公告"; } else if (roleId == "1") { strteaType = "teaType=1 and teaAccount = '" + teaAccount + "'"; newsType = "学生公告"; } else if (roleId == "2") { strteaType = "teaType=2 and collegeId=" + college; newsType = "学院公告"; } getdata(strteaType); } }