数据分页 双TOP二分法.doc

using System;
using ;
using ;
 
/// <summary>
/// 构造分页后的SQL语句
/// </summary>
public static class PagingHelper
{
    /// <summary>
    /// 获取分页SQL语句,排序字段需要构成唯一记录
    /// </summary>
    /// <param name="_recordCount">记录总数</param>
    /// <param name="_pageSize">每页记录数</param>
    /// <param name="_pageIndex">当前页数</param>
    /// <param name="_safeSql">SQL查询语句</param>
    /// <param name="_orderField">排序字段,多个则用“,”隔开</param>
    /// <returns>分页SQL语句</returns>
    public static string CreatePagingSql(int _recordCount, int _pageSize, int _pageIndex, string _safeSql, string _orderField)
    {
        //重新组合排序字段,防止有错误
        string[] arrStrOrders = (new char[] { ',' }, );
        StringBuilder sbOriginalOrder = new StringBuilder(); //原排序字段
        StringBuilder sbReverseOrder = new StringBuilder(); //与原排序字段相反,用于分页
        for (int i = 0; i < ; i++)
        {
            arrStrOrders[i] = arrStrOrders[i].Trim();  //去除前后空格
            if (i != 0)
            {
                (", ");
                (", ");
            }
            (arrStrOrders[i]);
 
            int index = arrStrOrders[i].IndexOf(" "); //判断是否有升降标识
            if (index > 0)
            {
                //替换升