/// <summary> /// 帖子浏览 /// </summary> /// <returns></returns> public ActionResult Browse() { var postid = Request["postid"].ToInt(); if (postid > 0) { using (var db = new ClubEntitie()) { var post = db.Post.Include(a => a.User).Include(a => a.Type).FirstOrDefault(a => a.id == postid); var user = db.User.OrderByDescending(a => a.id).Include(a => a.Level).ToList(); ViewBag.User = user; //查询赞帖子的用户 var praiserecord = db.PraiseRecord.OrderByDescending(a => a.id).Include(a => a.User).Where(a => a.Postid == postid).ToList(); ViewBag.praiserecord = praiserecord; var listpraiserecord = new List <PraiserecordModel>(); foreach (var item in praiserecord) { var praiserecordmodel = new PraiserecordModel(); praiserecordmodel.postid = item.Postid; praiserecordmodel.userid = item.Userid; praiserecordmodel.username = item.User.Name; praiserecordmodel.userimage = item.User.Image; praiserecordmodel.time = item.CreateTime; listpraiserecord.Add(praiserecordmodel); } ViewData["praiserecord"] = listpraiserecord; //查询收藏帖子的用户 var collection = db.Collection.OrderByDescending(a => a.id).Include(a => a.User).ToList(); ViewBag.collection = collection; //查询帖子回复的信息 var reply = db.Reply.OrderByDescending(a => a.id).Include(a => a.User).Where(a => a.Postid == postid).ToList(); var listreply = new List <ReplyModel>(); foreach (var item in reply) { var replyModel = new ReplyModel(); replyModel.postid = item.Postid; replyModel.userid = item.Userid; replyModel.username = item.User.Name; replyModel.userlevel = item.User.Level.Name; replyModel.userimage = item.User.Image; replyModel.content = item.Contents; replyModel.recoverytime = item.Recoverytime; listreply.Add(replyModel); } ViewData["reply"] = listreply; //更新帖子访问量 post.Visit += 1; db.SaveChanges(); return(View(post)); } } return(View()); }
/// <summary> /// 用户赞贴、收藏 /// </summary> /// <returns></returns> public ActionResult PraiseCollect() { var key = Request["key"].ToInt(); var postid = Request["postid"].ToInt(); var userid = Request["userid"].ToInt(); using (var db = new ClubEntitie()) { if (key == 1) { var praiserecord = new PraiseRecord(); praiserecord.Postid = postid; praiserecord.Userid = userid; praiserecord.CreateTime = DateTime.Now; db.PraiseRecord.Add(praiserecord); db.SaveChanges(); } else { var collection = new Collection(); collection.Postid = postid; collection.Userid = userid; collection.CreateTime = DateTime.Now; db.Collection.Add(collection); db.SaveChanges(); } //查询赞帖子的用户 var praiserecords = db.PraiseRecord.OrderByDescending(a => a.id).Include(a => a.User).Where(a => a.Postid == postid).ToList(); ViewBag.praiserecord = praiserecords; var listpraiserecord = new List <PraiserecordModel>(); foreach (var item in praiserecords) { var praiserecordmodel = new PraiserecordModel(); praiserecordmodel.postid = item.Postid; praiserecordmodel.userid = item.Userid; praiserecordmodel.username = item.User.Name; praiserecordmodel.userimage = item.User.Image; praiserecordmodel.time = item.CreateTime; listpraiserecord.Add(praiserecordmodel); } if (Request.IsAjaxRequest()) { return(PartialView("_PraiseRecord", listpraiserecord)); } } return(RedirectToAction("Browse")); }