显示上一条新闻 下一条新闻

显示上一条新闻 下一条新闻 这个经常在新闻的内容的下面会显示出来，方便用户浏览，这个很好实现，看下面的sql语句就知道了

假设当前NewsID=2 select NewsTitle from NewsTable where NewsID= (select top 1 NewsID from NewsTable where NewsID>2 order by NewsID asc) or NewsID=(select top 1 NewsID from NewsTable where NewsID<2 order by NewsID desc)

这个时候我们就会很明白

上一条新闻就是

select NewsTitle from NewsTable where NewsID=(select top 1 NewsID from NewsTable where NewsID<2 order by NewsID desc)

下一条新闻就是

select NewsTitle from NewsTable where NewsID=(select top 1 NewsID from NewsTable where NewsID>2 order by NewsID asc)

到时候写个方法，将当前的id作为参数就可以很好的是实现了！

 

下面是自己总结的代码，到时候直接套用：

数据层：

    /// <summary>
        /// 上一篇  下一篇
        /// </summary>
        /// <param name="id"></param>
        /// <param name="strOrder"></param>
        /// <param name="FH"></param>
        /// <returns></returns>
        public Jiu.Model.Lt_Article GetTitle(int id,string btype,string strOrder, string FH)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select top 1 id ,title from Lt_Article where");
            strSql.Append(" id" + FH + id + " and B_Sort="+btype+"  order by " + strOrder);
            Jiu.Model.Lt_Article model = new Jiu.Model.Lt_Article();
            DataSet ds = DbHelperOleDb.Query(strSql.ToString());
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["id"].ToString() != "")
                {
                    model.Id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
                }
                model.Title = ds.Tables[0].Rows[0]["title"].ToString();
                return model;
            }
            else
            {
                return null;
            }

        }

表示层：

页面：

 

 <div class="productd2">
                            <div style="width:100%; text-align:center; margin-top:80px; margin-bottom:10px"><span runat="server" id="Up"><span style="font-size:14px; color:Green">前一篇：</span><asp:Label ID="lblUp" runat="server" Text="Label"></asp:Label></span> <span style="margin-left:40px" runat="server" id="Down"><span style="font-size:14px; color:Green">后一篇：</span><asp:Label ID="lblDown" runat="server" Text="Label"></asp:Label></span></div>
                    </div>

cs代码

 

 //上一篇 后一篇
    public void UpAndDownNews(int bid, int id)
    {
        Jiu.Model.Lt_Article NewsInfoDown = NewsManager.GetTitle(id,bid.ToString(), "id desc", "<");
        Jiu.Model.Lt_Article NewsInfoUp = NewsManager.GetTitle(id,bid.ToString(), "id asc", ">");
        if (NewsInfoUp != null)
        {
            this.lblUp.Text = "<a href='NewInfo.aspx?bid="+bid+"&id=" + NewsInfoUp.Id + "' title='" + NewsInfoUp.Title + "'>" + getTitle(NewsInfoUp.Title) + "</a>";
        }
        else
        {
            Up.Visible = false;
        }
        if (NewsInfoDown != null)
        {
            this.lblDown.Text = "<a href='NewInfo.aspx?bid=" + bid + "&id=" + NewsInfoDown.Id + "' title='" + NewsInfoDown.Title + "'>" + getTitle(NewsInfoDown.Title) + "</a>";
        }
        else
        {
            Down.Visible = false;
        }

    }