AspNetPager分页
求帮忙写一个AspNetPager1根据查询条件查询的结果分页的代码例子...
[解决办法]
public void BindData()
{
string sql = @"select rownum rn,t.* from(
select a.sfzh,a.xm,a.xb,a.ysyj,a.yybf,a.bcffze,a.xskssj,a.xsjzsj,a.yhkh,a.dh,a.dyfesj,b.dwgryljfjs as ylsjje,b.jfssq from sybx a left join
(select * from zgylbx where jfssq='" + DateTime.Now.AddMonths(-1).ToString("yyyyMM") + "') b on a.sfzh=b.sfzh where a.sjqb='" + DateTime.Now.AddMonths(-1).ToString("yyyyMM") + "') t";
BLL bll = new BLL();
bll.BindingRepeaterWithAspNetPager(AspNetPager1, Repeater1, sql);
}
#region 用aspnetpager控件和repeater控件结合oracle存储过程绑定
/// <summary>
/// 用aspnetpager控件和repeater控件结合oracle存储过程绑定
/// </summary>
/// <param name="aspnetpager">aspnetpager控件</param>
/// <param name="bindingtarget">repeater控件</param>
/// <param name="pagesql">执行的sql语句</param>
public void BindingRepeaterWithAspNetPager(AspNetPager aspnetpager, Repeater bindingtarget, string pagesql)
{
int recordcount = 0;
ArrayList result = null;
MPage page = new MPage();
page.Pagesize = aspnetpager.PageSize;//每页显示的条数
page.Pageindex = aspnetpager.StartRecordIndex / aspnetpager.PageSize;//显示页的索引 从0开始
page.Pagesql = pagesql;//产生分页的sql语句 sql要求必须包含rownum字段且其别名为rn,如例子:select rownum rn,t.* from test t
bindingtarget.DataSource = GetPageRecord(page, out result);
bindingtarget.DataBind();
if (result != null && result.Count > 0)
{
if (int.TryParse(result[3].ToString(), out recordcount))
{
aspnetpager.RecordCount = recordcount;
}
else
{
aspnetpager.RecordCount = 0;
}
}
}
#endregion
#region 获取分页的记录
/// <summary>
/// 获取分页的记录
/// </summary>
/// <param name="page">封装的页面对象</param>
/// <param name="result">反馈的结果</param>
/// <returns>结果集的表</returns>
public DataTable GetPageRecord(MPage page, out ArrayList result)
{
OracleParameter[] oracleParameter = new OracleParameter[6];
oracleParameter[0] = new OracleParameter("p_pagesql", OracleType.VarChar);
oracleParameter[0].Direction = ParameterDirection.Input;
oracleParameter[0].Value = page.Pagesql;
oracleParameter[1] = new OracleParameter("p_pagesize", OracleType.Number);
oracleParameter[1].Direction = ParameterDirection.Input;
oracleParameter[1].Value = page.Pagesize;
oracleParameter[2] = new OracleParameter("p_pageindex", OracleType.Number);
oracleParameter[2].Direction = ParameterDirection.Input;
oracleParameter[2].Value = page.Pageindex;
oracleParameter[3] = new OracleParameter("p_totalcount", OracleType.Number);
oracleParameter[3].Direction = ParameterDirection.Output;
oracleParameter[4] = new OracleParameter("p_pagecount", OracleType.Number);
oracleParameter[4].Direction = ParameterDirection.Output;
oracleParameter[5] = new OracleParameter("p_currentpagedata", OracleType.Cursor);
oracleParameter[5].Direction = ParameterDirection.Output;
DataAccess da = new DataAccess();
return da.ExecuteProcedureWithTable(DBConn.sb, ref oracleParameter, "p_app_page", out result);
}
#endregion
