asp.net MVC实现文章的“上一篇下一篇”

由于这个东西的原理没有什么难的(只是实现的时候有少量的坑),故直接上代码以便查阅。另:本文给出的Action附送了点击量统计。

public ActionResult SingleNews(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
var news = storeDB.articles.Find(id); var prev = storeDB.articles.Where(p => p.ID<id).OrderByDescending(p => p.ID).Take().ToList();
var next = storeDB.articles.Where(p => p.ID>id).Take().ToList(); if(prev.Count>)
{
ViewBag.preTitle = prev.ElementAt().title;
ViewBag.preId = prev.ElementAt().ID;
}
else
{
ViewBag.preTitle = "没有了";
ViewBag.preId = id;
} if (next.Count>)
{
ViewBag.nextTitle = next.ElementAt().title;
ViewBag.nextId = next.ElementAt().ID;
}
else
{
ViewBag.nextTitle = "没有了";
ViewBag.nextId = id;
} //记录点击量
if(news!=null)
{
news.clickCount += ;
storeDB.Entry(news).State = EntityState.Modified;
storeDB.SaveChanges();
} return View(news);
}

视图中的相关代码:

<div>
<label>上一篇:</label>@Html.ActionLink((string)ViewBag.preTitle, "NewsContent", new { id=ViewBag.pre})
<label>下一篇:</label>@Html.ActionLink((string)ViewBag.nextTitle, "NewsContent", new { id=ViewBag.next})
</div>

本文参考了下面这篇文章并在此基础上做了改进:http://www.cnblogs.com/denny402/p/3215384.html

上一篇:SSAS动态添加分区(一)


下一篇:【PowerOJ1740】 圆桌问题