日期:2014-05-17 浏览次数:20575 次
//分页方法
/// <summary>
/// 分页获取数据
/// </summary>
/// <param name="tableName">数据表名称</param>
/// <param name="columns">列名,为空则默认检索所有字段</param>
/// <param name="where">检索条件,可以为空</param>
/// <param name="orderColumns">排序字段+排序规则</param>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="pageIndex">要显示的页码</param>
/// <param name="recordCount">总记录数</param>
/// <returns></returns>
public DataSet GetData(string tableName, string columns, string where, string orderColumns, int pageSize, int pageIndex, ref int recordCount)
{
if (string.IsNullOrEmpty(tableName))
{
return null;
}
else
{
string getCountSql = string.Format("SELECT COUNT (*) FROM {0} WHERE 1=1 {1}", tableName, where);
recordCount = tools.GetRecordCount(getCountSql);
int rowStart = pageIndex * pageSize;
int rowEnd = (pageIndex + 1) * pageSize;
string sql = "";
if (!string.IsNullOrEmpty(orderColumns))
{
orderColumns = " order by " + orderColumns;
}
if (string.IsNullOrEmpty(columns))
{
columns = " * ";