GroupByMultiQuery 类

命名空间

ShadowSql.GroupBy

程序集

ShadowSql.dll

对MultiQuery进行分组查询

public class GroupByMultiQuery : GroupByQueryBase<IMultiView>, IGroupByView, IDataQuery, IDataFilter, ITableView, ISqlEntity, IWrapper<ITableView>

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

GroupByBase

GroupByBase<Logic>

GroupByQueryBase<IMultiView>

GroupByMultiQuery

实现

IGroupByView

IDataQuery

IDataFilter

ITableView

ISqlEntity

IWrapper<ITableView>

衍生

DapperGroupByMultiQuery

继承成员

GroupByQueryBase<IMultiView>.Original

GroupByQueryBase<IMultiView>.WriteGroupBySource(ISqlEngine, StringBuilder)

GroupByBase<Logic>.WriteFilter(ISqlEngine, StringBuilder)

GroupByBase.GroupByFields

GroupByBase.Columns

GroupByBase.WriteSource(ISqlEngine, StringBuilder)

GroupByBase.WriteGroupBy(ISqlEngine, StringBuilder)

GroupByBase.FilterPrefix(ISqlEngine, StringBuilder)

GroupByBase.GetFields()

GroupByBase.GetField(string)

GroupByBase.NewField(string)

FilterBase.WriteCore(ISqlEngine, StringBuilder)

ViewBase.GetCompareField(string)

扩展方法

DapperShadowServices.ToDapperSelect(GroupByMultiQuery, IExecutor)

ShadowSqlServices.Take(GroupByMultiQuery, int, int)

ShadowSqlServices.ToCursor(GroupByMultiQuery, int, int)

ShadowSqlServices.ToSelect(GroupByMultiQuery)

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)

构造函数

GroupByMultiQuery(IMultiView, IField[])

对多表进行分组查询

public GroupByMultiQuery(IMultiView multiTable, IField[] fields)

参数

multiTable IMultiView

多表(联表)

fields IField[]

字段

GroupByMultiQuery(IMultiView, IField[], Logic)

对MultiQuery进行分组查询

public GroupByMultiQuery(IMultiView multiTable, IField[] fields, Logic filter)

参数

multiTable IMultiView

多表(联表)

fields IField[]

字段

filter Logic

过滤条件

方法

Apply<TAliasTable>(string, Func<TAliasTable, IAggregateField>, Func<Logic, IAggregateField, Logic>)

按逻辑查询

public GroupByMultiQuery Apply<TAliasTable>(string tableName, Func<TAliasTable, IAggregateField> aggregate, Func<Logic, IAggregateField, Logic> query) where TAliasTable : IAliasTable

参数

tableName string

表名

aggregate Func<TAliasTable, IAggregateField>

聚合

query Func<Logic, IAggregateField, Logic>

查询

返回

GroupByMultiQuery

类型参数

TAliasTable

Apply<TTable>(string, Func<TTable, IColumn>, Func<IPrefixField, IAggregateField>, Func<Logic, IAggregateField, Logic>)

按逻辑查询

public GroupByMultiQuery Apply<TTable>(string tableName, Func<TTable, IColumn> select, Func<IPrefixField, IAggregateField> aggregate, Func<Logic, IAggregateField, Logic> query) where TTable : ITable

参数

tableName string

表名

select Func<TTable, IColumn>

筛选

aggregate Func<IPrefixField, IAggregateField>

聚合

query Func<Logic, IAggregateField, Logic>

查询

返回

GroupByMultiQuery

类型参数

TTable