/// <summary>
/// 调用存储过程分页
/// </summary>
/// <param name="WhereClause"></param>
/// <param name="OrderBy"></param>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="TotalRows"></param>
/// <param name="StoredProcedure">存储过程名称</param>
/// <returns></returns>
public DataTable GetPager(string WhereClause, string OrderBy, int PageIndex, int PageSize, ref int TotalRows, string StoredProcedure)
{
SqlParameter[] parms = new SqlParameter[] {
new SqlParameter("@WhereClause", SqlDbType.VarChar, 2000),
new SqlParameter("@OrderBy", SqlDbType.VarChar, 2000),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@TotalRows", SqlDbType.Int),
};
parms[0].Value = WhereClause;
parms[1].Value = OrderBy;
parms[2].Value = PageIndex;
parms[3].Value = PageSize;
parms[4].Direction = ParameterDirection.Output;
DataTableCollection tables = SQLHelper.DataSet(BS.Components.Data.Config.ConnConfig.getConn, StoredProcedure, CommandType.StoredProcedure, parms).Tables;
if (tables.Count > 0)
{
DataTable dt = tables[0];
TotalRows = Convert.ToInt32(parms[4].Value != DBNull.Value ? parms[4].Value : 0);
return(dt);
}
return(null);
}
