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