/// <summary> /// 查询学生已选的论题信息 /// </summary> /// <param name="sno"></param> /// <returns></returns> public PersonalThesis QueryThesisInfo(string sno) { SqlParameter snoParameter = new SqlParameter("@sno", sno); PersonalThesis pt = new PersonalThesis(); DataTable dt = SqlHelper.ExecuteDataTableProc("QueryThesisOfStudent", new SqlParameter[] { snoParameter }); if (dt.Rows.Count < 1) { return(null); } else { #region 查询结果非空 Object[] values = new object[dt.Columns.Count]; foreach (DataRow row in dt.Rows) { int index = 0; foreach (DataColumn column in dt.Columns) { values[index++] = row[column]; } break; } try { pt.thesisId = Convert.ToInt64(values[0]); pt.name = Convert.ToString(values[1]); pt.type = Convert.ToString(values[2]); pt.content = Convert.ToString(values[3]); pt.response = Convert.ToString(values[4]); } catch (Exception e) { Console.WriteLine(e.Message); throw e; } #endregion return(pt); } }
/// <summary> /// 返回一个学生选题主页面 /// </summary> /// <returns></returns> public ActionResult Index() { var bll = new StudentBll(); string account = Session["account"].ToString(); long thesisid = bll.QueryThesisId(account); List <string> list = bll.QueryTeacherOpinionBll(account, thesisid); PersonalThesis thesis = bll.QueryThesisInfo(account); thesis = thesis ?? new PersonalThesis(-1, "", "", "", ""); int[] weight = bll.QueryThesisStatus(thesisid); int passWeight = Convert.ToInt32(HttpContext.Application["pastWeight"]); #region 论题状态判断 string thesisStatus = ""; if (weight[0] < 1) { thesisStatus = "暂时没有课题信息"; } else if (weight[0] > 0 && weight[1] < passWeight) { thesisStatus = "课题审核中"; } else if (weight[1] >= passWeight) { thesisStatus = "课题审核通过"; } else if (weight[0] == passWeight && weight[1] < passWeight) { thesisStatus = "审核不通过"; } #endregion ViewBag.status = thesisStatus; ViewBag.thesisInfo = thesis; ViewBag.advertise = list; ViewBag.username = bll.GetName(account); ViewBag.sno = account; return(View()); }