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