public static DataTable QueryTable(this DbOperator op, string sql, PageInfo pageInfo)
{
if (pageInfo == null)
{
return(op.ExecuteTableWithoutType(sql));
}
int rowCount;
var result = op.PagingTable(sql, pageInfo.PageIndex, pageInfo.PageSize, out rowCount);
pageInfo.RowCount = rowCount;
return(result);
}
public static DataTable PagingTable(this DbOperator op, string sql, int pageIndex, int pageSize, out int rowCount)
{
return(op.PagingTable(sql, pageIndex, pageSize, out rowCount, true));
}