一個分頁寫一個對應的方法,只不過是資料庫表名和欄位名不同,這樣太不專業了。於是把資料庫表名和欄位名當參數提出來,調用方法時再輸進去,這樣類中的方法可移植性就好多了。
類中的代碼: /// <summary>
/// 分頁綁定資料
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <returns></returns>
public DataTable ShowPagesea(int PageIndex, int PageSize,string DataTable,string id)
{
string sql = "select top " + PageSize + " * from " + DataTable + " where " + id + " Not in (select top " + (PageIndex - 1) * PageSize + " " + id + " from " + DataTable + " order by " + id + " desc) order by " + id + " desc ";
DataTable dt = sdh.dbODSGetDataTable(sql, DataTable);
return dt;
}
/// <summary>
/// 判斷總頁數,分10頁
/// </summary>
/// <returns>總頁數</returns>
public int ShowPageCountsea(string DataTable)
{
string sql = "select count(*) from " + DataTable + " ";
int i = Convert.ToInt32(sdh.dbExecuteSql4Value(sql));
if (i % 10 == 0)
{
i = i / 10;
}
else
{
i = i / 10 + 1;
}
return i;
}