/// <summary>
/// 某个用户的班级信息
/// </summary>
/// <param name="id"></param>
public ActionResult Class(int id)
{
UserClassViewData viewData = new UserClassViewData();
viewData.user = GetUser();
int userID = viewData.user.UserID;
//班级通知
viewData.NotifyList = (from n in CQGJ.Notify
from nm in CQGJ.NotifyMap
from c in CQGJ.Classes
from s in CQGJ.Student
where s.Classes == c && s.User.UserID == userID
&& nm.ObjectID == s.Classes.ClassID && nm.Notify == n
select n).ToList();
//以往班级
viewData.ClassList = (from c in CQGJ.Classes
from s in CQGJ.Student
where s.Classes == c && s.User.UserID == userID && c.Status == 3 //修改刘涛, status=2为开班中，3为结束
select c).ToList();
//现在班级
viewData.CureentClassesList = (from c in CQGJ.Classes
from s in CQGJ.Student
where s.Classes == c && s.User.UserID == userID //修改刘涛, status=2为开班中，3为结束
select c).ToList();
//所在班级
foreach (Classes c in viewData.CureentClassesList)
{
if (c.ClassID == id)
{
viewData.Classes = c;
}
}
int ClassID = viewData.Classes.ClassID;
// int TID = viewData.Classes.Teacher
viewData.ClassBBS = (from b in CQGJ.BBS
where b.Classes.ClassID == ClassID
select b).First();
viewData.userlist = (from s in CQGJ.Student
where s.Classes.ClassID == id
select s.User).ToList();
viewData.userlist.Remove(viewData.user);
viewData.courselist = (from c in CQGJ.Course where c.Classes.ClassID == ClassID select c).ToList();
viewData.learnlist = (from l in CQGJ.LearnGain where l.CourseResult.Course.Classes.ClassID == ClassID && l.CourseResult.Student.User.UserID == userID select l).ToList();
viewData.paperlist = (from p in CQGJ.Paper where p.CourseResult.Course.Classes.ClassID == ClassID && p.CourseResult.Student.User.UserID == userID select p).ToList();
if (viewData.ClassBBS != null)
{
int BBSID = viewData.ClassBBS.BBSID;
//班级论坛帖子
viewData.BBSItemList = (from b in CQGJ.BBSItem
orderby b.SubmitTime descending
where b.BBS.BBSID == BBSID && b.ParentID == -1
select b).Take(10).ToList();
}
viewData.user = GetUser();
return View("Class", viewData);
}
/// <summary>
/// 某个用户的班级信息
/// </summary>
/// <param name="id"></param>
public void Class(int id)
{
IsLogin();
UserClassViewData viewData = new UserClassViewData();
viewData.user = (CQGJ.passport.User)HttpContext.Session["userobject"];
int userID = viewData.user.UserID;
userID = ToUserID(userID); //zhuanhua
//班级通知
viewData.NotifyList = (from n in CQGJ.Notify
from nm in CQGJ.NotifyMap
from c in CQGJ.Classes
from s in CQGJ.Student
where s.Classes == c && s.User.UserID == userID && c.Status == 2
&& nm.ObjectID == s.Classes.ClassID && nm.Notify==n
select n).ToList();
//以往班级
viewData.ClassList = (from c in CQGJ.Classes
from s in CQGJ.Student
where s.Classes == c && s.User.UserID == userID && c.Status == 3 //修改刘涛, status=2为开班中，3为结束
select c).ToList();
//现在班级
viewData.CureentClassesList = (from c in CQGJ.Classes
from s in CQGJ.Student
where s.Classes == c && s.User.UserID == userID //修改刘涛, status=2为开班中，3为结束
select c).ToList();
string str = ConfigurationManager.AppSettings["PhotoUrl"].ToString();
viewData.URL = str;
try
{
//所在班级
foreach (Classes c in viewData.CureentClassesList)
{
if (c.ClassID == id)
{
viewData.Classes = c;
}
}
int ClassID = viewData.Classes.ClassID;
// int TID = viewData.Classes.Teacher
viewData.ClassBBS = (from b in CQGJ.BBS where b.Classes.ClassID == ClassID select b).First();
//viewData.teacher = (from t in CQGJ.Teacher where t.TeacherID == ClassID select b).First();
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.userlist.Remove(viewData.user);
}
catch
{
;
}
try
{
int ClassID = viewData.Classes.ClassID;
viewData.courselist = (from c in CQGJ.Course where c.Classes.ClassID == ClassID select c).ToList();
viewData.learnlist = (from l in CQGJ.LearnGain where l.CourseResult.Course.Classes.ClassID == ClassID && l.CourseResult.Student.User.UserID == userID select l).ToList();
viewData.paperlist = (from p in CQGJ.Paper where p.CourseResult.Course.Classes.ClassID == ClassID && p.CourseResult.Student.User.UserID == userID select p).ToList();
}
catch
{
;
}
if (viewData.ClassBBS != null)
{
int BBSID = viewData.ClassBBS.BBSID;
//班级论坛帖子
viewData.BBSItemList = (from b in CQGJ.BBSItem
orderby b.SubmitTime descending
where b.BBS.BBSID == BBSID && b.ParentID == -1
select b).Take(10).ToList();
}
viewData.user = (CQGJ.passport.User)HttpContext.Session["userobject"];
RenderView("Class", viewData);
}
