/// <summary> /// 返回学生电子学档 /// </summary> /// <param name="courseid"></param> /// <param name="moduleTag"></param> /// <returns></returns> public ActionResult WorksDetail(int courseid, string moduleTag) { ViewBag.courseid = courseid; //-------------------------------------------返回学生的最后得分------------------------------------------------- int mTag = 1;//如果是第一次其他页面请求过来,mTag的值为1,则默认显示该课程的第一个模块 CouScore cScore = null; if (!string.IsNullOrEmpty(moduleTag)) { mTag = Convert.ToInt32(moduleTag); } cScore = db.CouScore.Where(cs => cs.CourseId == courseid && cs.ModuleTag == mTag).FirstOrDefault(); ViewBag.cScore = cScore; //--------------------------------------返回课程某一模块的详细---------------------------------------------------------- Module module = db.Module.Where(m => m.CourseId == courseid && m.ModuleTag == mTag).FirstOrDefault(); ViewBag.module = module; //----------------------------------------------返回学生对某一模块的作业---------------------------------------------------- StudentWork sWork = db.StudentWork.Where(sw => sw.CourseId == courseid && sw.StudentId == studentId && sw.ModuleTag == mTag).FirstOrDefault(); ViewBag.sWork = sWork; //---------------------------------------返回某一模块的考试题目 学生的答案 及评分------------------------------------- if (module != null) { List <Erecord> listErecord = mHelp.SqlQuery <Erecord>("select pq.QTitle,psa.Answer,psa.AnswerScore from PaperStudentAnswers as psa join PaperQuestions as pq on psa.QuestionId=pq.Id where psa.MouduleTag=@mTag and StudentId=@studentId", new SqlParameter[] { new SqlParameter("@mTag", mTag), new SqlParameter("@studentId", studentId) }).ToList(); ViewBag.listErecord = listErecord; } //-------------------------------------------------------------------------------------------------------------------- return(View()); }
public string SetScore(FormCollection form) { int courseId = Convert.ToInt32(form["CourseId"]); Guid studentId = new Guid(form["StudentId"]); int moduleTag = Convert.ToInt32(form["ModuleTag"]); CouScore cScore = db.CouScore.Where(c => c.CourseId == courseId && c.StudentId == studentId && c.ModuleTag == moduleTag).FirstOrDefault(); if (cScore != null) { cScore.ModuleScore = form["score"]; } else { cScore = new CouScore() { CourseId = courseId, StudentId = studentId, ModuleTag = moduleTag, ModuleScore = form["score"] }; db.CouScore.Add(cScore); } db.SaveChanges(); return("OK"); }