using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Caching;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using MySql.Data.MySqlClient;
using MySql.Data.Types;
/// <summary>
/// 說明：本文介紹如何利用AjaxPro技術實現翻頁時局部刷新，同時也介紹了翻頁所涉及到的數據庫知識(MySQL、MS SQL和Oracle)。
/// 本演示程序采用MySQL數據庫，數據庫中的數據是采用程序隨機生成的。
/// 首發地址：http://blog.csdn.net/zhoufoxcn/archive/2008/03/12/2174234.aspx
/// 作者：周公
/// 日期：2008-3-12
/// </summary>
public partial class AjaxPager : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
AjaxPro.Utility.RegisterTypeForAjax(typeof(AjaxPager));
}
/// <summary>
/// 從數據庫中指定位置讀取指定數目的數據
/// </summary>
/// <param name="startIndex">記錄的起始頁位置</param>
/// <param name="size">要讀取的記錄條數</param>
/// <returns></returns>
[AjaxPro.AjaxMethod]
public DataTable GetDataTable(int pageIndex, int size)
{
MySqlConnection connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySql"].ConnectionString);
MySqlDataAdapter adapter = new MySqlDataAdapter("select * from userlist limit " + (pageIndex-1) * size + "," + size, connection);
DataTable data = new DataTable();
adapter.Fill(data);
connection.Close();
adapter.Dispose();
return data;
}
/// <summary>
/// 傳遞div節點的html字符串
/// </summary>
/// <param name="startIndex">記錄的起始頁位置</param>
/// <param name="size">要讀取的記錄條數</param>
/// <returns></returns>
[AjaxPro.AjaxMethod]
public string GetString(int pageIndex, int size)
{
StringBuilder text = new StringBuilder();
text.Append("<table border='0' cellpadding='0' cellspacing='0' width='520px'>");
text.Append("<tr class='items' align='center'>");
text.Append("<td style='width:80px'>編號</td>");
text.Append("<td style='width:80px'>姓名</td>");
text.Append("<td style='width:80px'>年齡</td>");
text.Append("<td style='width:80px'>性別</td>");
text.Append("<td style='width:80px'>身高</td>");
text.Append("<td style='width:80px'>工資</td>");
text.Append("</tr>");
DataTable source = GetDataTable(pageIndex,size);
DataRow row;
for (int i = 0; i < source.Rows.Count; i++)
{
row = source.Rows[i];
text.Append("<tr class='table' align='center'>");
for (int column = 0; column < source.Columns.Count; column++)
{
text.Append("<td style='width:80px'>" + row[column].ToString() + "</td>");
}
text.Append("</tr>");
}
int pageCount=(int)(Math.Ceiling(GetRecordCount()/(double)size));
text.Append("<tr class='items' align='center'>");
text.Append("<td><a href='javascript：JumpPage(1)'>首頁</a></td>");
if (pageIndex < pageCount)
{
text.Append("<td><a href='javascript：JumpPage(" + (pageIndex+1) + ")'>下一頁</a></td>");
}
else
{
text.Append("<td>下一頁</a></td>");
}
if (pageIndex > 1)
{
text.Append("<td><a href='javascript：JumpPage(" + (pageIndex-1)+ ")'>上一頁</a></td>");
}
else
{
text.Append("<td>上一頁</a></td>");
}
text.Append("<td><a href='javascript：JumpPage(" + pageCount + ")'>尾頁</a><td>");
text.Append("<td>當前頁："+pageIndex+"/"+pageCount+"</td>");
text.Append("</table>");
return text.ToString();
}
/// <summary>
/// 返回記錄總條數
/// </summary>
/// <returns></returns>
[AjaxPro.AjaxMethod]
public int GetRecordCount()
{
MySqlConnection connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySql"].ConnectionString);
MySqlCommand command = new MySqlCommand("select count(userId) from userlist", connection);
connection.Open();
int count = int.Parse(command.ExecuteScalar().ToString());
connection.Close();
command.Dispose();
return count;
}
}
