//public ActionResult Search(string title,int ? page)
//{
// var p = from t in db.Remark_User_Comments_Reply.OrderByDescending(t=>t.Remark_time)
// select t;
// if(title!=null)
// {
// page = 1;
// }
// if (p == null)
// return Content("您查找的帖子不存在!");
// else
// p = p.Where(r => (r.Title.Contains(title)));
// int pageSize = 8;
// int pageNumber = (page ?? 1);
// return View(p.ToPagedList(pageNumber,pageSize));
//}
//public ActionResult News_ten()
//{
// var news = (from n in db.News
// orderby n.News_Time
// select n).Take(10);
// return PartialView(news);
//}
//public ActionResult News(int? page)
//{
// INews1 iw = new RNews1();
// var news = iw.getallnews();
// int pagesize = 8;
// int pageNumber = (page ?? 1);
// return View(news.ToPagedList(pageNumber,pagesize));
//}
//public ActionResult Newsdetails(int Newsid)
//{
// INews2 news = new RNews2();
// return View(news.FindNewsbyid(Newsid));
//}
public ActionResult Index2(int id)
{
Session["Remarkid"] = id;
IRemarks ir = new RRemarks();
IRemarkcomments ire = new RRemarkcomments();
//ViewBag.Remarkid = id;
//var remarkcomment = db.RemarkComments.OrderByDescending(p=>p.RemarkCommentID==id);
//var remarkreply = from o in db.RemarkReply
// join b in db.RemarkComments on o.RemarkCommentID equals b.RemarkCommentID
// join c in db.Remarks on b.RemarkID equals c.RemarkID
// where c.RemarkID == id
// select o;
var ima_nam = from a in db.Users
join b in db.Remarks on a.UserID equals b.UserID
where b.RemarkID == id
select a;
TieziViewModel tiz = new TieziViewModel()
{
Gettiezi = ir.FindRemarksByID(id),
GetIma_nam = ima_nam.Take(1)
};
return(View(tiz));
}
public ActionResult HF(int pinglunid)
{
var remarkreply = from o in db.RemarkReply
join b in db.RemarkComments on o.RemarkCommentID equals b.RemarkCommentID
where b.RemarkCommentID == pinglunid
select o;
TieziViewModel tiz = new TieziViewModel()
{
Gethuifu = remarkreply
};
return(PartialView(tiz));
}
//评论的Ｇet请求
public ActionResult PL(int id)
{
id = int.Parse(Session["Remarkid"].ToString());
IRemarks ir = new RRemarks();
IRemarkcomments ire = new RRemarkcomments();
TieziViewModel tiz = new TieziViewModel()
{
Getpinglun = ire.Getcommentsbyid(id)
};
return(PartialView(tiz));
}
