DapperGroupByMultiCursor 类

命名空间

Dapper.Shadow.Cursors

程序集

Dapper.Shadow.dll

多(联)表分组后范围筛选

public class DapperGroupByMultiCursor : GroupByMultiCursor, ICursor, ITableView, ISqlEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

CursorBase

CursorBase<IGroupByView>

GroupByCursorBase

GroupByMultiCursor

DapperGroupByMultiCursor

实现

ICursor

ITableView

ISqlEntity

继承成员

GroupByMultiCursor._multiTable

GroupByMultiCursor.MultiTable

CursorBase<IGroupByView>._source

CursorBase<IGroupByView>.Source

CursorBase<IGroupByView>.WriteCore(ISqlEngine, StringBuilder)

CursorBase<IGroupByView>.WriteSource(ISqlEngine, StringBuilder)

CursorBase<IGroupByView>.GetFields()

CursorBase<IGroupByView>.GetField(string)

CursorBase<IGroupByView>.GetCompareField(string)

CursorBase<IGroupByView>.NewField(string)

CursorBase._limit

CursorBase._offset

CursorBase.Limit

CursorBase.Offset

CursorBase.CheckAsc(string)

CursorBase.CheckDesc(string)

CursorBase.WriteOrderBy(ISqlEngine, StringBuilder)

扩展方法

DapperShadowServices.ToDapperSelect(DapperGroupByMultiCursor)

DapperShadowServices.ToDapperSingle(DapperGroupByMultiCursor, IFieldView)

ShadowSqlServices.AggregateAsc<TGroupByCursor>(TGroupByCursor, Func<IGroupByView, IAggregateField>)

ShadowSqlServices.AggregateDesc<TGroupByCursor>(TGroupByCursor, Func<IGroupByView, IAggregateField>)

ShadowSqlServices.CountAsc<TGroupByCursor>(TGroupByCursor)

ShadowSqlServices.CountDesc<TGroupByCursor>(TGroupByCursor)

DapperShadowServices.ToDapperSelect(GroupByMultiCursor, IExecutor)

ShadowSqlServices.ToSelect(GroupByMultiCursor)

DapperShadowCoreServices.CountAsync(ITableView, IExecutor, object?, CancellationToken)

DapperShadowCoreServices.LongCountAsync(ITableView, IExecutor, object?, CancellationToken)

ShadowSqlCoreServices.Field(ITableView, string)

ShadowSqlCoreServices.Fields(ITableView, params IEnumerable<string>)

ShadowSqlCoreServices.Strict(ITableView, string)

构造函数

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

属性值

IExecutor

方法

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>

筛选

返回

DapperGroupByMultiCursor

类型参数

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>

聚合

返回

DapperGroupByMultiCursor

类型参数

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>

筛选

返回

DapperGroupByMultiCursor

类型参数

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>

聚合

返回

DapperGroupByMultiCursor

类型参数

TTable