public ActionResult Index() { using (blogEntities ct = new blogEntities()) { History h = new History(); h.CreateTime = DateTime.Now; h.Guest = "guest"; h.Url = "/"; h.IP = Request.UserHostAddress; ct.Histories.Add(h); ct.SaveChanges(); } IndexModel model = new IndexModel(); if (IsLogin) { model.Passport = base.Passport; using (blogEntities en = new blogEntities()) { var users = en.Friends.Where(f => f.Self.Equals(Passport.AccountID)).Select(f => f.FriendID).ToList(); model.Topics = (from t in en.Topics.Include("Comments") where t.Author.Equals(Passport.AccountID) || users.Contains(t.Author) orderby t.CreateTime descending select t ).ToList(); //en.Topics //.Where( // t => // t.Author.Equals(Passport.AccountID) // || users.Contains(t.Author) //) //.OrderByDescending(t => t.CreateTime) //.ToList(); if (en.Users.Count(u => u.UserID.Equals(Passport.AccountID)) > 0) { model.Author = en.Users.Where(u => u.UserID.Equals(Passport.AccountID)).First(); } } } else { return Redirect("~/Account/LogOn"); } return View(model); //return Json(model, JsonRequestBehavior.AllowGet); }
public ActionResult Index1(string userid) { ViewBag.Message = "欢迎使用 ASP.NET MVC!"; IndexModel model = new IndexModel(); model.Passport = base.Passport; using (blogEntities en = new blogEntities()) { model.Topics = en.Topics.Where(t => t.Author.Equals(userid)) .OrderByDescending(t => t.CreateTime).ToList(); if (en.Users.Count(u => u.UserID.Equals(userid)) > 0) { model.Author = en.Users.Where(u => u.UserID.Equals(userid)).First(); //model.Firends = model.Author.Friends.Select<Friend,User>() } } return View(model); }