GroupByMultiCursor 类

命名空间

ShadowSql.Cursors

程序集

ShadowSql.dll

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

public class GroupByMultiCursor : GroupByCursorBase, ICursor, ITableView, ISqlEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

CursorBase

CursorBase<IGroupByView>

GroupByCursorBase

GroupByMultiCursor

实现

ICursor

ITableView

ISqlEntity

Derived

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._fields

CursorBase.Limit

CursorBase.Offset

CursorBase.CheckAsc(string)

CursorBase.CheckDesc(string)

CursorBase.WriteOrderBy(ISqlEngine, StringBuilder)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

扩展方法

DapperShadowServices.ToDapperSelect(GroupByMultiCursor, IExecutor)

ShadowSqlCoreServices.Asc<TCursor>(TCursor, IOrderView)

ShadowSqlCoreServices.Asc<TCursor>(TCursor, params IEnumerable<string>)

ShadowSqlCoreServices.Asc<TCursor>(TCursor, Func<ITableView, IOrderView>)

ShadowSqlCoreServices.Desc<TCursor>(TCursor, IOrderAsc)

ShadowSqlCoreServices.Desc<TCursor>(TCursor, params IEnumerable<string>)

ShadowSqlCoreServices.Desc<TCursor>(TCursor, Func<ITableView, IOrderAsc>)

ShadowSqlCoreServices.OrderBy<TCursor>(TCursor, string)

ShadowSqlCoreServices.Skip<TCursor>(TCursor, int)

ShadowSqlCoreServices.Take<TCursor>(TCursor, int)

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)

ShadowSqlServices.ToSingle(ICursor, IFieldView)

ShadowSqlServices.ToSingle(ICursor, string)

DapperShadowCoreServices.Count(ITableView, IExecutor, object?)

DapperShadowCoreServices.CountAsync(ITableView, IExecutor, object?)

DapperShadowCoreServices.LongCount(ITableView, IExecutor, object?)

DapperShadowCoreServices.LongCountAsync(ITableView, IExecutor, object?)

ShadowSqlCoreServices.AsExists(ITableView)

ShadowSqlCoreServices.AsNotExists(ITableView)

ShadowSqlCoreServices.Field(ITableView, string)

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

ShadowSqlCoreServices.Strict(ITableView, string)

构造函数

GroupByMultiCursor(GroupByMultiQuery, int, int)

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

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

参数

source GroupByMultiQuery

limit int

offset int

GroupByMultiCursor(GroupByMultiSqlQuery, int, int)

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

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

参数

source 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