62,041
社区成员
发帖
与我相关
我的任务
分享
#region// 取出上一篇下一篇文章
public void BindNextUp()
{
showid = Convert.ToString(SQLUtil.CutIntFromStr(Request["showid"]));
if (showid != null && showid != "")
{
sqls.Sys_Paras.Add(new SqlParameter("@logid", SQLUtil.FilerSql(showid)));
DataTable dtnextup = new DataTable();
string strNextUp = "select * from (select top 1 logid,title from dbo.space_MyReleased where logid>case when (select count(*) ";
strNextUp += " from dbo.space_MyReleased where state=1 and delstate=0 and logid > @logid) > 0 then @logid else @logid - 1 end order by logid)as a union ";
strNextUp += " select * from (select top 1 logid,title from dbo.space_MyReleased where state=1 and delstate=0 and logid< case when ";
strNextUp += " (select count(*) from dbo.space_MyReleased where state=1 and delstate=0 and logid < @logid) > 0 then @logid else @logid + 1 end order by logid desc) as b ";
sqls.Fill_DT(strNextUp, dtnextup);
if (dtnextup.Rows.Count > 0)
{
this.up.Text = "<a class='MsHref1' href=MyLogLeft.aspx?showid=" + dtnextup.Rows[0]["logid"].ToString() + ">" + dtnextup.Rows[0]["title"].ToString() + "</a>";
for (int i = 0; i < dtnextup.Rows.Count; i++)
{
int upid = Convert.ToInt32(dtnextup.Rows[i]["logid"].ToString());
//判断传递的ID大小来显示上一篇下一篇
if (upid == Convert.ToInt32(SQLUtil.FilerSql(showid)))//查询ID相等的
{
this.netx.Text = "<a class='MsHref1' href=MyLogLeft.aspx?showid=" + dtnextup.Rows[i]["logid"].ToString() + ">" + dtnextup.Rows[i]["title"].ToString() + "</a>";
}
else if (upid < Convert.ToInt32(showid))//查出ID小于ShowID的
{
this.up.Text = "<a class='MsHref1' href=MyLogLeft.aspx?showid=" + dtnextup.Rows[i]["logid"].ToString() + ">" + dtnextup.Rows[i]["title"].ToString() + "</a>";
}
else
{
this.netx.Text = "<a class='MsHref1' href=MyLogLeft.aspx?showid=" + dtnextup.Rows[i]["logid"].ToString() + ">" + dtnextup.Rows[i]["title"].ToString() + "</a>";
}
}
} sqls.Sys_Paras.Clear();
}
}
#endregion
<!--上一篇下一篇-->
<div class="MLDiv3" >
<div style="float: left" > « 上一篇:【<asp:Label ID="up" runat="server"/>】</div>
<div align="right" >下一篇:【<asp:Label ID="netx" runat="server" ></asp:Label> 】 </div>
</div>