GroupByTableCursor<TTable> 类

命名空间

ShadowSql.Cursors

程序集

ShadowSql.dll

表分组后范围筛选游标

public class GroupByTableCursor<TTable> : GroupByCursorBase, ICursor, ITableView, ISqlEntity where TTable : ITable

类型参数

TTable

继承

object

GetFieldBase

ViewBase

TableViewBase

CursorBase

CursorBase<IGroupByView>

GroupByCursorBase

GroupByTableCursor<TTable>

实现

ICursor

ITableView

ISqlEntity

继承成员

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<TTable>(GroupByTableCursor<TTable>, 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<TTable>(GroupByTableCursor<TTable>)

ShadowSqlServices.ToSingle<TTable>(GroupByTableCursor<TTable>, Func<TTable, IAggregateFieldAlias>)

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)

构造函数

GroupByTableCursor(GroupByTableQuery<TTable>, int, int)

表分组后范围筛选

public GroupByTableCursor(GroupByTableQuery<TTable> groupBy, int limit, int offset)

参数

groupBy GroupByTableQuery<TTable>

分组查询

limit int

筛选数量

offset int

跳过数量

GroupByTableCursor(GroupByTableSqlQuery<TTable>, int, int)

表分组后范围筛选

public GroupByTableCursor(GroupByTableSqlQuery<TTable> groupBy, int limit, int offset)

参数

groupBy GroupByTableSqlQuery<TTable>

分组查询

limit int

筛选数量

offset int

跳过数量

属性

Table

表

public TTable Table { get; }

属性值

TTable

方法

AggregateAsc(Func<TTable, IAggregateField>)

正序

public GroupByTableCursor<TTable> AggregateAsc(Func<TTable, IAggregateField> aggregate)

参数

aggregate Func<TTable, IAggregateField>

聚合

返回

GroupByTableCursor<TTable>

AggregateDesc(Func<TTable, IAggregateField>)

倒序

public GroupByTableCursor<TTable> AggregateDesc(Func<TTable, IAggregateField> aggregate)

参数

aggregate Func<TTable, IAggregateField>

聚合

返回

GroupByTableCursor<TTable>