GroupByMultiCursor 类

命名空间

ShadowSql.Cursors

程序集

ShadowSql.dll

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

public class GroupByMultiCursor : GroupByCursorBase, ICursor, ITableView, ISqlEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

CursorBase

CursorBase<IGroupByView>

GroupByCursorBase

GroupByMultiCursor

实现

ICursor

ITableView

ISqlEntity

衍生

DapperGroupByMultiCursor

继承成员

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(GroupByMultiCursor, IExecutor)

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

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

ShadowSqlServices.CountAsc<TGroupByCursor>(TGroupByCursor)

ShadowSqlServices.CountDesc<TGroupByCursor>(TGroupByCursor)

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)

构造函数

GroupByMultiCursor(GroupByMultiQuery, int, int)

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

public GroupByMultiCursor(GroupByMultiQuery groupBy, int limit, int offset)

参数

groupBy GroupByMultiQuery

分组查询

limit int

筛选数量

offset int

跳过数量

GroupByMultiCursor(GroupByMultiSqlQuery, int, int)

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

public GroupByMultiCursor(GroupByMultiSqlQuery groupBy, int limit, int offset)

参数

groupBy GroupByMultiSqlQuery

分组查询

limit int

筛选数量

offset int

跳过数量

字段

_multiTable

多(联)表

protected readonly IMultiView _multiTable

字段值

IMultiView

属性

MultiTable

多(联)表

public IMultiView MultiTable { get; }

属性值

IMultiView

方法

AggregateAsc<TAliasTable>(string, Func<TAliasTable, IAggregateField>)

正序

public GroupByMultiCursor AggregateAsc<TAliasTable>(string tableName, Func<TAliasTable, IAggregateField> select) where TAliasTable : IAliasTable

参数

tableName string

表名

select Func<TAliasTable, IAggregateField>

筛选

返回

GroupByMultiCursor

类型参数

TAliasTable

AggregateAsc<TTable>(string, Func<TTable, IColumn>, Func<IPrefixField, IAggregateField>)

正序

public GroupByMultiCursor 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>

聚合

返回

GroupByMultiCursor

类型参数

TTable

AggregateDesc<TAliasTable>(string, Func<TAliasTable, IAggregateField>)

倒序

public GroupByMultiCursor AggregateDesc<TAliasTable>(string tableName, Func<TAliasTable, IAggregateField> select) where TAliasTable : IAliasTable

参数

tableName string

表名

select Func<TAliasTable, IAggregateField>

筛选

返回

GroupByMultiCursor

类型参数

TAliasTable

AggregateDesc<TTable>(string, Func<TTable, IColumn>, Func<IPrefixField, IAggregateField>)

倒序

public GroupByMultiCursor 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>

聚合

返回

GroupByMultiCursor

类型参数

TTable