DapperGroupByMultiCursor 类
多(联)表分组后范围筛选
public class DapperGroupByMultiCursor : GroupByMultiCursor, ICursor, ITableView, ISqlEntity
- 继承
-
objectDapperGroupByMultiCursor
- 实现
- 继承成员
- 扩展方法
构造函数
DapperGroupByMultiCursor(IExecutor, GroupByMultiSqlQuery, int, int)
多(联)表分组后范围筛选
public DapperGroupByMultiCursor(IExecutor executor, GroupByMultiSqlQuery groupBy, int limit, int offset)
参数
executor
IExecutor执行器
groupBy
GroupByMultiSqlQuery分组查询
limit
int筛选数量
offset
int跳过数量
属性
Executor
执行器
public IExecutor Executor { get; }
属性值
方法
AggregateAsc<TAliasTable>(string, Func<TAliasTable, IAggregateField>)
正序
public DapperGroupByMultiCursor AggregateAsc<TAliasTable>(string tableName, Func<TAliasTable, IAggregateField> select) where TAliasTable : IAliasTable
参数
tableName
string表名
select
Func<TAliasTable, IAggregateField>筛选
返回
类型参数
TAliasTable
AggregateAsc<TTable>(string, Func<TTable, IColumn>, Func<IPrefixField, IAggregateField>)
正序
public DapperGroupByMultiCursor AggregateAsc<TTable>(string tableName, Func<TTable, IColumn> select, Func<IPrefixField, IAggregateField> aggregate) where TTable : ITable
参数
tableName
string选择表
select
Func<TTable, IColumn>定位列
aggregate
Func<IPrefixField, IAggregateField>聚合
返回
类型参数
TTable
AggregateDesc<TAliasTable>(string, Func<TAliasTable, IAggregateField>)
倒序
public DapperGroupByMultiCursor AggregateDesc<TAliasTable>(string tableName, Func<TAliasTable, IAggregateField> select) where TAliasTable : IAliasTable
参数
tableName
string表名
select
Func<TAliasTable, IAggregateField>筛选
返回
类型参数
TAliasTable
AggregateDesc<TTable>(string, Func<TTable, IColumn>, Func<IPrefixField, IAggregateField>)
倒序
public DapperGroupByMultiCursor AggregateDesc<TTable>(string tableName, Func<TTable, IColumn> select, Func<IPrefixField, IAggregateField> aggregate) where TTable : ITable
参数
tableName
string选择表
select
Func<TTable, IColumn>定位列
aggregate
Func<IPrefixField, IAggregateField>聚合
返回
类型参数
TTable