将以前写的SQL2分查找法通用分页存储过程算法 改成.net类实现

using System;

namespace CountryPark.DAL
...{
    /**//**//**//// <summary>
    /// PageList 的摘要说明。
    /// </summary>
    public sealed class PageList
    ...{
        static PageList()
        ...{
        }
       
        /**//**//**//// <summary>
        /// 分页查询数据记录总数获取
        /// </summary>
        /// <param name="_tbName">----要显示的表或多个表的连接</param>
        /// <param name="_ID">----主表的主键</param>
        /// <param name="_strCondition">----查询条件,不需where</param>       
        /// <param name="_Dist">----是否添加查询字段的 DISTINCT 默认0不添加/1添加</param>
        /// <returns></returns>
        public static string getPageListCounts(string _tbName, string _ID, string _strCondition, int _Dist)
        ...{           
            //---存放取得查询结果总数的查询语句                   
            //---对含有DISTINCT的查询进行SQL构造
            //---对含有DISTINCT的总数查询进行SQL构造
            string strTmp="", SqlSelect="", SqlCounts="";
           
            if (_Dist == 0)
            ...{
                SqlSelect = "SELECT ";
                SqlCounts = "COUNT(*)";
            }
            else
            ...{
                SqlSelect = "SELECT DISTINCT ";
                SqlCounts = "COUNT(DISTINCT "+ _ID +")";
            }
            if (_strCondition == string.Empty)
            ...{
                strTmp = SqlSelect +" @Counts="+ SqlCounts +" FROM "+ _tbName;
            }
            else
            ...{
                strTmp = SqlSelect +" @Counts="+ SqlCounts +" FROM "+ " WHERE (1=1) "+ _strCondition;
            }
            return strTmp;
        }

        /**//**//**//// <summary>
        /// 获取分页数据查询SQL
        /// </summary>
        /// <param name="_tbName">----要显示的表或多个表的连接</param>
        /// <param name="_fldName">----要显示的字段列表</param>
        /// <param name="_PageSize">----每页显示的记录个数</param>
        /// <param name="_Page">----要显示那一页的记录</param>
        /// <param name="_PageCount">----查询结果分页后的总页数</param>
        /// <param name="_Counts">----查询到的记录数</param>

[1] [2] [3] [4] [5] [6]  下一页