GroupByTableCursor<TKey, TEntity> 类

命名空间

ShadowSql.Expressions.Cursors

程序集

ShadowSql.Expressions.dll

表分组后范围筛选游标

public class GroupByTableCursor<TKey, TEntity> : GroupByCursorBase, ICursor, ITableView, ISqlEntity

类型参数

TKey

TEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

CursorBase

CursorBase<IGroupByView>

GroupByCursorBase

GroupByTableCursor<TKey, TEntity>

实现

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)

扩展方法

ShadowSqlServices.CountAsc<TGroupByCursor>(TGroupByCursor)

ShadowSqlServices.CountDesc<TGroupByCursor>(TGroupByCursor)

ShadowSqlServices.ToSelect<TKey, TEntity>(GroupByTableCursor<TKey, TEntity>)

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)

构造函数

GroupByTableCursor(GroupByTableQuery<TKey, TEntity>, int, int)

表分组后范围筛选

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

参数

groupBy GroupByTableQuery<TKey, TEntity>

分组查询

limit int

筛选数量

offset int

跳过数量

GroupByTableCursor(GroupByTableSqlQuery<TKey, TEntity>, int, int)

表分组后范围筛选

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

参数

groupBy GroupByTableSqlQuery<TKey, TEntity>

分组查询

limit int

筛选数量

offset int

跳过数量

属性

Table

表

public ITableView Table { get; }

属性值

ITableView

方法

Asc<TOrder>(Expression<Func<IGrouping<TKey, TEntity>, TOrder>>)

正序

public GroupByTableCursor<TKey, TEntity> Asc<TOrder>(Expression<Func<IGrouping<TKey, TEntity>, TOrder>> select)

参数

select Expression<Func<IGrouping<TKey, TEntity>, TOrder>>

用于选择分组键的表达式

返回

GroupByTableCursor<TKey, TEntity>

类型参数

TOrder

排序类型

Asc<TOrder>(Expression<Func<TKey, TOrder>>)

正序

public GroupByTableCursor<TKey, TEntity> Asc<TOrder>(Expression<Func<TKey, TOrder>> select)

参数

select Expression<Func<TKey, TOrder>>

用于选择分组键的表达式

返回

GroupByTableCursor<TKey, TEntity>

类型参数

TOrder

排序类型

Desc<TOrder>(Expression<Func<IGrouping<TKey, TEntity>, TOrder>>)

倒序

public GroupByTableCursor<TKey, TEntity> Desc<TOrder>(Expression<Func<IGrouping<TKey, TEntity>, TOrder>> select)

参数

select Expression<Func<IGrouping<TKey, TEntity>, TOrder>>

用于选择分组键的表达式

返回

GroupByTableCursor<TKey, TEntity>

类型参数

TOrder

排序类型

Desc<TOrder>(Expression<Func<TKey, TOrder>>)

倒序

public GroupByTableCursor<TKey, TEntity> Desc<TOrder>(Expression<Func<TKey, TOrder>> select)

参数

select Expression<Func<TKey, TOrder>>

用于选择分组键的表达式

返回

GroupByTableCursor<TKey, TEntity>

类型参数

TOrder

排序类型