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);
}
public ActionResult ResultList(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();
return View("ResultList", 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);
}
public void ResultList(int id)
{
TrainResultListViewData viewData = new TrainResultListViewData();
Classes classes = (from c in CQGJ.Classes
where c.ClassID == id
select c).First();
viewData.Classes = classes;
List<int> ListID = (from s in CQGJ.Student
where s.Classes.ClassID == id
select s.User.UserID).ToList();
passport.CQGJPassport cqgjp = new CQGJ.passport.CQGJPassport();
viewData.UserList = new List<CQGJ.passport.User>();
for (int i = 0; i < ListID.Count; ++i)
{
ListID[i] = ToPassportUserID(ListID[i]);
CQGJ.passport.User user = cqgjp.GetCQGJUser(ListID[i]);
viewData.UserList.Add(user);
}
//班级课程
viewData.CourseList = (from cs in CQGJ.Course
where cs.Classes.ClassID == id
select cs).ToList();
RenderView("ResultList", viewData);
}
public void EditResult(int id)
{
TrainResultListViewData viewData = new TrainResultListViewData();
Classes classes = (from c in CQGJ.Classes
where c.ClassID == id
select c).First();
viewData.Classes = classes;
List<int> ListID = (from s in CQGJ.Student
where s.Classes.ClassID == id
select s.User.UserID).ToList();
passport.CQGJPassport cqgjp = new CQGJ.passport.CQGJPassport();
viewData.UserList = new List<CQGJ.passport.User>();
for (int i = 0; i < ListID.Count; ++i)
{
ListID[i] = ToPassportUserID(ListID[i]);
CQGJ.passport.User user = cqgjp.GetCQGJUser(ListID[i]);
viewData.UserList.Add(user);
}
//班级课程
viewData.CourseList = (from cs in CQGJ.Course
where cs.Classes.ClassID == id
select cs).ToList();
if (GetString("flag") != "")
{
foreach (var co in viewData.CourseList)
{
for (int i = 0; i < ListID.Count; i++)
{
int temp = GetInt(co.CourseID.ToString() + "-" + i.ToString());
int x = ListID[i];
Student student = (from s in CQGJ.Student
from cs in CQGJ.Course
where cs.CourseID == co.CourseID && cs.Classes == s.Classes && s.User.UserID == x
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();
}
}
}
RenderView("Editresult", viewData);
}
public void AddAttend(int id)
{
TrainResultListViewData viewData = new TrainResultListViewData();
Classes classes = (from c in CQGJ.Classes
where c.ClassID == id
select c).First();
viewData.Classes = classes;
List<int> ListID = (from s in CQGJ.Student
where s.Classes.ClassID == id
select s.User.UserID).ToList();
passport.CQGJPassport cqgjp = new CQGJ.passport.CQGJPassport();
viewData.UserList = new List<CQGJ.passport.User>();
for (int i = 0; i < ListID.Count; ++i)
{
ListID[i] = ToPassportUserID(ListID[i]);
CQGJ.passport.User user = cqgjp.GetCQGJUser(ListID[i]);
viewData.UserList.Add(user);
}
//班级课程
viewData.CourseList = (from cs in CQGJ.Course
where cs.Classes.ClassID == id
select cs).ToList();
if (GetString("flag") != "")
{
Course course = viewData.CourseList.First();
for (int i = 0; i < ListID.Count; i++)
{
int temp = 0;
if (GetString("user-" + i.ToString()) == "on")
{ temp = 1; }
int x = ListID[i];
Student student = (from s in CQGJ.Student
from cs in CQGJ.Course
where cs.CourseID == course.CourseID && cs.Classes == s.Classes && s.User.UserID == x
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();
}
RedirectToAction("attendlist");
}
RenderView("AddAttend", viewData);
}
