反回指定页的记录，用于静太页的生成

/// <summary>
/// SQLBuilder 的摘要说明
/// </summary>
public class SQLBuilder
{
 public SQLBuilder()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
   public static string GetPageSQL(string tableName, string fields, string idField, string whereFields, string orderFields, int pageIndex, int pageSize)
    {

        string SQL = "";
        string strTemp = "";
        string strOrder = "";
        if (whereFields != "")
        {
            strTemp += " Where " + whereFields;
        }
        if (orderFields != "")
        {
            strTemp += " Order By " + orderFields;
            strOrder=" Order By " + orderFields;
        }
        else
        {
            strTemp += " Order By " + idField;
            strOrder="  Order By " + idField;
        }
        if (pageIndex == 1)
        {
            SQL = String.Format("Select Top {0} {1} From [{2}] {3}", pageSize, fields, tableName, strTemp);
        }
        else
        {
            SQL = @"Select top {0} {1} From [{2}]
                     Where {3} NOT In( Select Top {4} {3} From [{2}] {5} ) {6}";
            SQL = String.Format(SQL, pageSize, fields, tableName, idField, pageSize * (pageIndex - 1), strTemp,strOrder);

        }

        return SQL;
    }

    /// <summary>
    /// 构建统计记录条数的查询语句
    /// </summary>
    public static string GetCountSQL(string tableName, string idField, string whereFields)
    {
        string SQL = "";
        string strTemp = "";
        if (whereFields != "")
        {
            strTemp += " Where " + whereFields;
        }
        return String.Format("Select Count({0}) From [{1}] {2}",idField,tableName,strTemp);
    }
}