GroupByMultiCursorSelect 类

命名空间

ShadowSql.CursorSelect

程序集

ShadowSql.dll

GroupBy后再范围(分页)及列筛选

public sealed class GroupByMultiCursorSelect : GroupByMultiSelectBase<ICursor>, IGroupBySelect, ISelect, ISelectFields, ISqlEntity

继承

object

GetFieldBase

SelectFieldsBase

SelectBase<ICursor, IGroupByView>

GroupBySelectBase<ICursor, IMultiView>

GroupByMultiSelectBase<ICursor>

GroupByMultiCursorSelect

实现

IGroupBySelect

ISelect

ISelectFields

ISqlEntity

继承成员

GroupBySelectBase<ICursor, IMultiView>.GroupSource

SelectBase<ICursor, IGroupByView>.Source

SelectBase<ICursor, IGroupByView>.Target

SelectFieldsBase.Selected

扩展方法

ShadowSqlCoreServices.Alias<TSelectFields>(TSelectFields, ISingleSelect, string)

ShadowSqlCoreServices.Alias<TSelectFields>(TSelectFields, string, string)

ShadowSqlCoreServices.SelectSelfColumns<TSelectFields>(TSelectFields)

ShadowSqlCoreServices.Select<TSelectFields>(TSelectFields, ISingleSelect)

ShadowSqlCoreServices.Select<TSelectFields>(TSelectFields, params IEnumerable<IFieldView>)

ShadowSqlCoreServices.Select<TSelectFields>(TSelectFields, params IEnumerable<string>)

ShadowSqlServicess.Apply<TSelect>(TSelect, Action<TSelect>)

ShadowSqlServicess.SelectAggregate<TSelect>(TSelect, Func<IGroupByView, IAggregateFieldAlias>)

ShadowSqlServicess.SelectCount<TSelect>(TSelect, string)

ShadowSqlServicess.SelectGroupBy<TSelect>(TSelect)

DapperShadowCoreServices.Count(ISelect, IExecutor, object?)

DapperShadowCoreServices.CountAsync(ISelect, IExecutor, object?)

DapperShadowCoreServices.FirstAsync<T>(ISelect, IExecutor, object?)

DapperShadowCoreServices.First<T>(ISelect, IExecutor, object?)

DapperShadowCoreServices.GetAsync<T>(ISelect, IExecutor, object?)

DapperShadowCoreServices.Get<T>(ISelect, IExecutor, object?)

DapperShadowCoreServices.LongCount(ISelect, IExecutor, object?)

DapperShadowCoreServices.LongCountAsync(ISelect, IExecutor, object?)

DapperShadowServices.DapperInsertTo<TTable>(ISelect, TTable)

ShadowSqlServices.InsertTo(ISelect, string)

ShadowSqlServices.InsertTo<TTable>(ISelect, TTable)

构造函数

GroupByMultiCursorSelect(GroupByMultiCursor)

GroupBy后再范围(分页)及列筛选

public GroupByMultiCursorSelect(GroupByMultiCursor cursor)

参数

cursor GroupByMultiCursor

游标

方法

SelectAggregate<TAliasTable>(string, Func<TAliasTable, IAggregateFieldAlias>)

聚合筛选

public GroupByMultiCursorSelect SelectAggregate<TAliasTable>(string tableName, Func<TAliasTable, IAggregateFieldAlias> select) where TAliasTable : IAliasTable

参数

tableName string

表名

select Func<TAliasTable, IAggregateFieldAlias>

筛选

返回

GroupByMultiCursorSelect

类型参数

TAliasTable

SelectAggregate<TTable>(string, Func<TTable, IColumn>, Func<IPrefixField, IAggregateFieldAlias>)

聚合筛选(先定位再聚合)

public GroupByMultiCursorSelect SelectAggregate<TTable>(string tableName, Func<TTable, IColumn> select, Func<IPrefixField, IAggregateFieldAlias> aggregate) where TTable : ITable

参数

tableName string

表名

select Func<TTable, IColumn>

筛选

aggregate Func<IPrefixField, IAggregateFieldAlias>

聚合

返回

GroupByMultiCursorSelect

类型参数

TTable

SelectAggregate<TAliasTable>(string, Func<TAliasTable, IEnumerable<IAggregateFieldAlias>>)

聚合筛选

public GroupByMultiCursorSelect SelectAggregate<TAliasTable>(string tableName, Func<TAliasTable, IEnumerable<IAggregateFieldAlias>> select) where TAliasTable : IAliasTable

参数

tableName string

表名

select Func<TAliasTable, IEnumerable<IAggregateFieldAlias>>

筛选

返回

GroupByMultiCursorSelect

类型参数

TAliasTable

WriteCore(ISqlEngine, StringBuilder)

拼写分页sql

protected override void WriteCore(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql