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)); }