.net 存储过程分页

 前端页面

<asp:Repeater ID="rptList" runat="server" onitemcommand="rptList_ItemCommand">
<ItemTemplate>
<tr>
<td><%#Eval("ProductName")%></td>
<td><%#Eval("Number")%></td>
<td><%#Eval("NeedIntegral")%></td>
<td><%#Eval("AccName")%></td>
<td><%#Eval("AccIntegral")%></td>
<td><%# DataBinder.Eval(Container.DataItem, "ApplyTime", "{0:yyyy-MM-dd}")%></td>
<td><%#Eval("ExchangeCount")%></td>
<td>
<script type="text/javascript">
if ('<%# DataBinder.Eval(Container.DataItem, "Status")%>' == "0") {
document.write("申请中");
}
else if ('<%# DataBinder.Eval(Container.DataItem, "Status")%>' == "1") {
document.write("已发货");
}
else if ('<%# DataBinder.Eval(Container.DataItem, "Status")%>' == "2")
{
document.write("完成");
}
else {
document.write("未知");
}
</script>
</td>
<td align="center">
<asp:LinkButton ID="linkBtnUpate" runat="server" CommandArgument='<%#Eval("Id")%>' CommandName="upate" Text="更改" OnClientClick="return confirm('你确定要更改状态吗？')">

</asp:LinkButton>
</td>
</tr>
</ItemTemplate>
</asp:Repeater>

 

<webdiyer:AspNetPager PageSize="10" ID="anp" runat="server" FirstPageText='首页' AlwaysShow="true"
LastPageText='尾页' PagingButtonSpacing="" ShowPageIndexBox="Always" OnPageChanged="anpList_PageChanged"
CustomInfoHTML="共%RecordCount%条，第%CurrentPageIndex%页 /共%PageCount% 页" NextPageText="下一页"
PageIndexBoxType="DropDownList" PrevPageText="上一页" ShowCustomInfoSection="Left"
ShowMoreButtons="False" ShowPageIndex="False" SubmitButtonText="Go" TextAfterPageIndexBox="页"
TextBeforePageIndexBox="转到 ">
</webdiyer:AspNetPager>

 

后台代码

 

protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
anp.RecordCount = myList.CalcCount(GetSearchCondition());
BindRptList();
}
}

 

/// <summary>
/// 绑定用户兑换列表
/// </summary>
protected void BindRptList()
{
DataTable dtList = myList.GetList("*","Id","ASC",anp.PageSize,anp.CurrentPageIndex,GetSearchCondition()).Tables[0];

rptList.DataSource = dtList;
rptList.DataBind();

}

 

/// <summary>分页获取数据列表
///
/// </summary>
public DataSet GetList(string fileds, string order, string ordertype, int PageSize, int PageIndex, string strWhere)
{
MSSQLHelper h = new MSSQLHelper();
h.CreateStoredCommand("[proc_SplitPage]");
h.AddParameter("@tblName", "GetExchangeList");
h.AddParameter("@strFields", fileds);
h.AddParameter("@strOrder", order);
h.AddParameter("@strOrderType", ordertype);
h.AddParameter("@PageSize", PageSize);
h.AddParameter("@PageIndex", PageIndex);
h.AddParameter("@strWhere", strWhere);
DataTable dt = h.ExecuteQuery();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return ds;
}

 

/// <summary>执行查询SQL语句或存储过程
///
/// </summary>
/// <returns></returns>
public DataTable ExecuteQuery()
{
DataTable dt = new DataTable();
using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
dt.Load(sdr);
}
return dt;
}

 

/// <summary>计算记录数
///
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
public int CalcCount(string cond)
{
string sql = "select count(1) from GetExchangeList";
if (!string.IsNullOrEmpty(cond))
{
sql += " where " + cond;
}
MSSQLHelper h = new MSSQLHelper();
h.CreateCommand(sql);
return int.Parse(h.ExecuteScalar());
}