GroupByMultiSelect 类

命名空间

ShadowSql.Select

程序集

ShadowSql.dll

联表分组后再筛选列

public sealed class GroupByMultiSelect : GroupByMultiSelectBase<IGroupByView>, IGroupBySelect, ISelect, ISelectFields, ISqlEntity

继承

object

GetFieldBase

SelectFieldsBase

SelectBase<IGroupByView, IGroupByView>

GroupBySelectBase<IGroupByView, IMultiView>

GroupByMultiSelectBase<IGroupByView>

GroupByMultiSelect

实现

IGroupBySelect

ISelect

ISelectFields

ISqlEntity

继承成员

GroupBySelectBase<IGroupByView, IMultiView>.GroupSource

SelectBase<IGroupByView, IGroupByView>.Source

SelectBase<IGroupByView, IGroupByView>.Target

SelectFieldsBase.Selected

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

扩展方法

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

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

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)

构造函数

GroupByMultiSelect(GroupByMultiQuery)

GroupBy后再筛选列

public GroupByMultiSelect(GroupByMultiQuery groupBy)

参数

groupBy GroupByMultiQuery

GroupByMultiSelect(GroupByMultiSqlQuery)

GroupBy后再筛选列

public GroupByMultiSelect(GroupByMultiSqlQuery groupBy)

参数

groupBy GroupByMultiSqlQuery

方法

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

聚合筛选

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

参数

tableName string

select Func<TAliasTable, IAggregateFieldAlias>

返回

GroupByMultiSelect

类型参数

TAliasTable

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

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

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

返回

GroupByMultiSelect

类型参数

TTable

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

聚合筛选

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

参数

tableName string

select Func<TAliasTable, IEnumerable<IAggregateFieldAlias>>

返回

GroupByMultiSelect

类型参数

TAliasTable