public ActionResult StudentList2(string tname) { int i = 0; SelectedCourseDBContext selectSno = new SelectedCourseDBContext(); SelectCourseDBContext selectCname = new SelectCourseDBContext(); BasicInfoDBContext studentMessage = new BasicInfoDBContext(); List <SelectedCourse> studentSno = selectSno.SelectedCourses.Where(u => u.TNAME == tname).ToList(); List <SelectCourse> cname = selectCname.SelectCourses.Where(u => u.TNAME == tname).ToList(); string[] className = new string[cname.Count]; List <BasicInfo> result = new List <BasicInfo>(); foreach (var n in cname) { className[i] = n.CNAME; i++; } foreach (var u in studentSno) { string name = className[1]; if (name == u.CNAME) { List <BasicInfo> message = studentMessage.Basics.Where(m => m.ID == u.SNO && u.CNAME == name && u.SEMESTER == "15-16春").ToList(); result.AddRange(message); } } return(View(result)); }
public ActionResult Welcome(FormCollection fc) { string name = fc["UserName"]; string password = fc["Password"]; BasicInfo basics = new BasicInfo(); BasicInfoDBContext basic = new BasicInfoDBContext(); //判断输入的是否为空 if (string.IsNullOrEmpty(name) || string.IsNullOrEmpty(password)) { Response.Write("<script> alert('输入用户名或密码错误,请重新输入!!');window.location.href='../Welcome/Welcome' </script>"); Response.End(); return(RedirectToAction("Welcome", "WelcomeController")); } else { var userInfoCheck = from message in basic.Basics where message.LOGN == name && message.PSW == password select message.ID; string userInfo = null; foreach (var message in userInfoCheck) { userInfo = message.ToString(); } if (userInfo == null) { Response.Write("<script> alert('输入用户名或密码错误,请重新输入!!');window.location.href='../Welcome/Welcome' </script>"); Response.End(); return(RedirectToAction("Welcome", "WelcomeController")); } //判断用户类型,返回不同页面 else if (userInfo == "Admin") { basics = basic.Basics.Find(userInfo); TempData["name"] = basics.NAME; TempData["no"] = basics.LOGN; return(Redirect("../Admin/Index")); } else if (userInfo == "T1" || userInfo == "T2" || userInfo == "T3" || userInfo == "T4" || userInfo == "T5") { basics = basic.Basics.Find(userInfo); TempData["name"] = basics.NAME; TempData["tno"] = basics.LOGN; return(RedirectToAction("Index", "Teacher")); } else { basics = basic.Basics.Find(userInfo); TempData["name"] = basics.NAME; TempData["sno"] = basics.LOGN; return(RedirectToAction("Index", "Student")); } } }
public ActionResult StudentGrade2(string tname) { int i = 0; SelectedCourseDBContext selectSno = new SelectedCourseDBContext(); BasicInfoDBContext studentMessage = new BasicInfoDBContext(); SelectCourseDBContext selectCname = new SelectCourseDBContext(); List <BasicInfo> studentName = new List <BasicInfo>(); StudentGrade result = null; List <StudentGrade> resultGrade = new List <StudentGrade>(); GradeDBContext grade = new GradeDBContext(); List <SelectedCourse> studentSno = selectSno.SelectedCourses.Where(u => u.TNAME == tname.Replace(" ", "")).ToList(); List <SelectCourse> cname = selectCname.SelectCourses.Where(u => u.TNAME == tname.Replace(" ", "")).ToList(); string[] className = new string[10]; foreach (var n in cname) { className[i] = n.CNAME.ToString().Replace(" ", ""); i++; } foreach (var u in studentSno) { string name = className[1]; if (name == u.CNAME.Replace(" ", "") && u.SEMESTER == "15-16春") { var message = studentMessage.Basics.Where(m => m.ID == u.SNO).FirstOrDefault(); var gradeStudent = grade.Grades.Where(n => n.SNO == u.SNO && n.CNO == u.CNO && n.SEMESTER == "15-16春").FirstOrDefault(); if (gradeStudent != null) { result = new StudentGrade() { SNO = message.ID, SNAME = message.NAME, GRADE = gradeStudent.GRADE }; } else { result = new StudentGrade() { SNO = message.ID, SNAME = message.NAME, GRADE = null }; } resultGrade.Add(result); } } return(View(resultGrade)); }
public string AddCourse(string tno, string tname, string cno, string cname, string credit, string cdept, string time, string selectednum, string capacity) { string lastResult = null; BasicInfoDBContext basicDbInfo = new BasicInfoDBContext(); SelectCourse selectcourse; SelectCourseDBContext selectDbContext = new SelectCourseDBContext(); var result = basicDbInfo.Basics.Where(u => u.ID == tno && u.NAME == tname).FirstOrDefault(); //判断教师是否存在 //教师是否存在 if (result == null) { lastResult = "该教师不存在,请核实!"; } //教师存在 else { var teacherTeachCourse = selectDbContext.SelectCourses.Where(u => u.TNAME == tname).ToList(); //该教师自己课程间是否冲突 foreach (var t in teacherTeachCourse) { if (t.TIME.ToString().Trim() == time || t.CNO.ToString().Trim() == cno) { lastResult = "该教师课时或课号冲突,请重新确认!"; break; } } if (lastResult == null) { selectcourse = new SelectCourse() { CNO = cno, TNO = tno, CNAME = cname, CREDIT = Convert.ToInt32(credit), CDEPT = cdept, TNAME = tname, TIME = time, SELECTEDNUM = Convert.ToInt32(selectednum), CAPACITY = Convert.ToInt32(capacity) }; selectDbContext.SelectCourses.Add(selectcourse); selectDbContext.SaveChanges(); lastResult = "添加成功!"; } } return(lastResult); }