62,046
社区成员
发帖
与我相关
我的任务
分享
if exists(select * from view_rizhiquanbu where ID<@ID and ((@user=zhidaolaoshi or @user=gzren1 or @user=gzren2) or (@zhiwu='主任')))--上一项
select top 1 @SID=ID from view_rizhiquanbu where ID<@ID and ((@user=zhidaolaoshi)) order by ID desc
else
set @SID='0' --如果不存在上一项ID设置上一项ID为0 if exists(select * from view_rizhiquanbu where ID>@ID and ((@user=zhidaolaoshi)) select top 1 @XID=ID from view_rizhiquanbu where ID>@ID and rizhiwuxiao=1 and ((@user=zhidaolaoshi)) order by ID asc
else
set @XID='0'
#region 日志评议上下项
public SY.Model.SY_WorkBlog RZSXID(int rid,string user, out string SID, out string XID)
{
SY.Model.SY_WorkBlog rizhi = new SY.Model.SY_WorkBlog();
DataBase data = new DataBase();
string tablename = "table";
DataSet ds = new DataSet();
SqlParameter[] para ={
data.MakeInParam("@RID", SqlDbType.Int, 5, rid), data.MakeInParam("@user",SqlDbType.NVarChar,20,user)
};
ds = data.RunProcedure("proc_rz_sxID", para, tablename);
SID = ds.Tables[0].Rows[0]["SID"].ToString();
XID = ds.Tables[0].Rows[0]["XID"].ToString();
}
}
页面方法:
/// <summary>
/// 判断是否含有上下项
/// </summary>
/// <param name="SID"></param>
/// <param name="XID"></param>
public void dataButton(string SID, string XID)
{
if (SID == "0")//当SID=0时,上一项的按钮不可用
{
shang.Enabled = false;
}
else
{
shang.Enabled = true;
}
if (XID == "0")//当XID=0时,下一项的按钮不可用
{
xia.Enabled = false;
}
else
{
xia.Enabled = true;//下一项的按钮可用。
}
}
/// <summary>
/// 上一项
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void shang_Click(object sender, EventArgs e)
{
Server.Transfer("RZ_PingYi.aspx?Rid=" + SID);
}
/// <summary>
/// 下一项
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void xia_Click(object sender, EventArgs e)
{
Server.Transfer("RZ_PingYi.aspx?Rid=" + XID);
}
大概就是这个意思,你自己在整理整理