欧美性猛交XXXX免费看蜜桃,成人网18免费韩国,亚洲国产成人精品区综合,欧美日韩一区二区三区高清不卡,亚洲综合一区二区精品久久

               /// <summary>
               /// 生成取得記錄總數的語(yǔ)句
               /// </summary>
               /// <param name="sql">原查詢(xún)語(yǔ)句</param>
               /// <returns>取得記錄總數的語(yǔ)句</returns>
               private string     MakeRecordCountsSql(string sql)
               {
                   string sqlGetRecordCounts = "select Count(*) from (" + sql + ") as TempTable";
                   return sqlGetRecordCounts;
               }

               /// <summary>
               /// 生成分頁(yè)查詢(xún)語(yǔ)句
               /// </summary>
               /// <param name="sql">原查詢(xún)語(yǔ)句</param>
               /// <param name="orderField">用于分頁(yè)排序的字段</param>
               /// <param name="pageNumber">頁(yè)碼</param>
               /// <param name="pageSize">頁(yè)面記錄數量</param>
               /// <param name="recordCounts">記錄總數</param>
               /// <param name="pageCounts">頁(yè)面總數</param>
               /// <returns>分頁(yè)查詢(xún)語(yǔ)句</returns>
               private string MakePagingSql(string sql, string orderField, int pageNumber, int pageSize, int recordCounts, out int pageCounts)
               {
                   // 計算頁(yè)面數量
                   if (Convert.ToInt32(pageNumber) < 1) pageNumber = 1;
                   if (Convert.ToInt32(pageSize) < 1) pageSize = 1;
                   pageCounts = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(recordCounts) / Convert.ToDouble(pageSize)));

                   string sqlQuery = "";
                   if (pageNumber == 1)
                   {
                       sqlQuery = "select top " + pageSize + " * from (" + sql + ") as TempTable order by " + orderField     + " desc";
                   }
                   else
                   {
                       sqlQuery = "select top " + pageSize + " * from (" + sql + ") as TempTable where " + orderField     + " < (select min(" + orderField     + ") as MinID from ( select top " + (pageNumber - 1) * pageSize + "     * from (" + sql + ") as MaxTempTable order by " + orderField     + " desc) as MinTempTable) order by " + orderField     + " desc";
                   }
                   return sqlQuery;
               }