DapperGroupByMultiQuery 类

命名空间

Dapper.Shadow.GroupBy

程序集

Dapper.Shadow.dll

对MultiQuery进行分组查询

public class DapperGroupByMultiQuery : GroupByMultiQuery, IGroupByView, IDataQuery, IDataFilter, IWrapper<ITableView>, IDapperSource, ITableView, ISqlEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

GroupByBase

GroupByBase<Logic>

GroupByQueryBase<IMultiView>

GroupByMultiQuery

DapperGroupByMultiQuery

实现

IGroupByView

IDataQuery

IDataFilter

IWrapper<ITableView>

IDapperSource

ITableView

ISqlEntity

继承成员

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(DapperGroupByMultiQuery)

DapperShadowCoreServices.CountAsync(IDapperSource, object?, CancellationToken)

DapperShadowCoreServices.LongCountAsync(IDapperSource, object?, CancellationToken)

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)

构造函数

DapperGroupByMultiQuery(IExecutor, IMultiView, IField[], Logic)

对MultiQuery进行分组查询

public DapperGroupByMultiQuery(IExecutor executor, IMultiView multiTable, IField[] fields, Logic filter)

参数

executor IExecutor

执行器

multiTable IMultiView

多表(联表)

fields IField[]

字段

filter Logic

过滤条件

属性

Executor

执行器

public IExecutor Executor { get; }

属性值

IExecutor

方法

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

按逻辑查询

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

查询

返回

DapperGroupByMultiQuery

类型参数

TAliasTable

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

按逻辑查询

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

查询

返回

DapperGroupByMultiQuery

类型参数

TTable