/// <summary>
/// Sql分页查询
/// </summary>
/// <typeparam name="TEntity">返回结果</typeparam>
/// <param name="sql">sql语句</param>
/// <param name="where">where条件</param>
/// <param name="page">当前页</param>
/// <param name="pageSize">每页显示记录数</param>
/// <param name="order">排序，例如：name desc,nickname desc</param>
/// <returns></returns>
public PagedResult <TEntity> SqlPage <TEntity>(string sql, WhereCondition where, int page, int pageSize,
string order) where TEntity : class, new()
{
string whereSql = where.BuildSql();
return(this.SqlPage <TEntity>(sql, whereSql, page, pageSize, order));
}