public ActionResult AddAttend(int id) { TrainResultListViewData viewData = new TrainResultListViewData(); Classes classes = (from c in CQGJ.Classes where c.ClassID == id select c).First(); viewData.Classes = classes; viewData.UserList = (from s in CQGJ.Student where s.Classes.ClassID == id select s.User).ToList(); //班级课程 viewData.CourseList = (from cs in CQGJ.Course where cs.Classes.ClassID == id select cs).ToList(); if (GetString("flag") != "") { Course course = viewData.CourseList.First(); foreach (var u in viewData.UserList) { int temp = 0; if (GetString("user-" + u.UserID.ToString()) == "on") { temp = 1; } Student student = (from s in CQGJ.Student from cs in CQGJ.Course where cs.CourseID == course.CourseID && cs.Classes == s.Classes && s.User.UserID == u.UserID select s).First(); var result = (from cr in CQGJ.CourseResult from s in CQGJ.Student where cr.Course.CourseID == course.CourseID && cr.Student.StudentID == student.StudentID select cr); Attend attend = new Attend(); if (result.Count() <= 0) { CourseResult r = new CourseResult(); r.Course = course; r.Student = student; r.Mark = temp.ToString(); CQGJ.AddToCourseResult(r); CQGJ.SaveChanges(); attend.CourseResult = r; } else { attend.CourseResult = result.First(); } attend.Status = temp; attend.AttendTime = DateTime.Now; CQGJ.AddToAttend(attend); CQGJ.SaveChanges(); } return RedirectToAction("attendlist"); } return View("AddAttend", viewData); }
/// <summary> /// 查看/编辑成绩(参数:课程结果ID) /// </summary> public ActionResult EditResult(int id) { TrainResultListViewData viewData = new TrainResultListViewData(); Classes classes = (from c in CQGJ.Classes where c.ClassID == id select c).First(); viewData.Classes = classes; viewData.UserList = (from s in CQGJ.Student where s.Classes.ClassID == id select s.User).ToList(); //班级课程 viewData.CourseList = (from cs in CQGJ.Course where cs.Classes.ClassID == id select cs).ToList(); if (GetString("flag") != "") { foreach (var co in viewData.CourseList) { foreach (var u in viewData.UserList) { int temp = GetInt(co.CourseID.ToString() + "-" + u.UserID.ToString()); Student student = (from s in CQGJ.Student from cs in CQGJ.Course where cs.CourseID == co.CourseID && cs.Classes == s.Classes && s.User.UserID == u.UserID select s).First(); var result = (from cr in CQGJ.CourseResult from s in CQGJ.Student where cr.Course.CourseID == co.CourseID && cr.Student.StudentID == student.StudentID select cr); if (result.Count() > 0) { result.First().Mark = temp.ToString(); } else { CourseResult r = new CourseResult(); r.Course = co; r.Student = student; r.Mark = temp.ToString(); CQGJ.AddToCourseResult(r); } CQGJ.SaveChanges(); } } } return View("Editresult", viewData); }
/// <summary> /// 论文保存 - 创建新论文时 /// </summary> public ActionResult PaperCreate() { UserPLViewData viewData = new UserPLViewData(); viewData.user = GetUser(); int userID = viewData.user.UserID; int id = GetInt("pCourse"); var courseResultTemp = (from cr in CQGJ.CourseResult where cr.Course.CourseID == id && cr.Student.User.UserID == userID select cr); bool flag = false; viewData.course = (from c in CQGJ.Course where c.CourseID == id select c).First(); CourseResult crTmp = new CourseResult(); try { crTmp = courseResultTemp.First(); } catch { flag = true; } if (flag) { crTmp.Course = viewData.course; crTmp.Student = (from s in CQGJ.Student where s.User.UserID == userID select s).First(); CQGJ.AddToCourseResult(crTmp); CQGJ.SaveChanges(true); } Paper newpaper = new Paper(); newpaper.CourseResult = crTmp; newpaper.Content = GetString("Content"); newpaper.PaperType = "1";//现在没有用 newpaper.Title = GetString("pTitle"); newpaper.PublishDate = DateTime.Now; newpaper.Publisher = viewData.user.Username; CQGJ.AddToPaper(newpaper); CQGJ.SaveChanges(true); return RedirectToAction("mypaper", "user"); }
/// <summary> /// 心得体会保存 - 创建时 /// </summary> public ActionResult LearnCreate() { UserPLViewData viewData = new UserPLViewData(); viewData.user = GetUser(); int userID = viewData.user.UserID; int id = GetInt("lCourse"); var courseResultTemp = (from cr in CQGJ.CourseResult where cr.Course.CourseID == id && cr.Student.User.UserID == userID select cr); bool flag = false; viewData.course = (from c in CQGJ.Course where c.CourseID == id select c).First(); CourseResult crTmp = new CourseResult(); try { crTmp = courseResultTemp.First(); } catch { flag = true; } if (flag) { crTmp.Course = viewData.course; crTmp.Student = (from s in CQGJ.Student where s.User.UserID == userID select s).First(); CQGJ.AddToCourseResult(crTmp); CQGJ.SaveChanges(true); } LearnGain learn = new LearnGain(); learn.CourseResult = crTmp; learn.Content = GetString("Content"); learn.Title = GetString("lTitle"); learn.PubTime = DateTime.Now; CQGJ.AddToLearnGain(learn); CQGJ.SaveChanges(true); return RedirectToAction("mylearn", "user"); }