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);
}
