ASP.NETMVC5实现分页查询的示例代码

//数据总量
int dataCount;
//每页显示的数据条数
int pageDataCount;
int pageNumber;

//总页数
int pageCount = (int)Math.Ceiling(dataCount/ (pageDataCount* 1.0));
int startLine = (pageNumber - 1) * PageDataCount + 1;
int endLine=startLine + PageDataCount - 1;

protected IDbConnection CreateConnection()
{
  IDbConnection dbCOnnection= new SqlConnection(ConnectionString);
  dbConnection.Open();
  return dbConnection;
}

//获取数据库中数据的总条数
public virtual int QueryDataCount(string tableName)
{
  using (IDbConnection dbCOnnection= CreateConnection())
  {
    var queryResult = dbConnection.Query("select count(Id) from " + tableName);
    if (queryResult == null || !queryResult.Any())
    {
      return 0;
    }
    return queryResult.First();
  }
}

public virtual IEnumerable RangeQuery(string tableName, int startline, int endline)
{
  if (string.IsNullOrEmpty(tableName))
  {
    throw new ArgumentNullException("表名不得为空或null");
  }
  if (startline <= 0)
  {
    throw new ArgumentOutOfRangeException("起始行号必须大于0");
  }
  if (endline - startline <0)
  {
    throw new ArgumentOutOfRangeException("结束行号不得小于起始行号");
  }
  using (IDbConnection dbCOnnection= CreateConnection())
  {
    var queryResult = dbConnection.Query("select top " + (endline - startline + 1) + " * from " + tableName + " where Id not in (select top " + (startline - 1) + " Id from " + tableName + " order by Id desc) order by Id desc");
    if (queryResult != null && queryResult.Any())
    {
      return queryResult;
    }
  }
  return null;
}

@*
  amount：数据总数，count：每页显示的数据条数，redierctUrl点击按钮时的跳转链接
  页面上需引用：bootstrap.min.css
*@
@helper CreatePaginateButton(int amount, int count, string redirectUrl)
{
  

    
  
  
}

@PageHelper.CreatePaginateButton(246, 10, "/usermanager/attentionlist/")