DapperGroupByAliasTableQuery<TTable> 类

命名空间

Dapper.Shadow.GroupBy

程序集

Dapper.Shadow.dll

对别名表分组

public class DapperGroupByAliasTableQuery<TTable> : GroupByAliasTableQuery<TTable>, IGroupByView, IDataQuery, IDataFilter, IDapperSource, ITableView, ISqlEntity where TTable : ITable

类型参数

TTable

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

GroupByBase

GroupByBase<Logic>

GroupByQueryBase<IAliasTable<TTable>>

GroupByAliasTableQuery<TTable>

DapperGroupByAliasTableQuery<TTable>

实现

IGroupByView

IDataQuery

IDataFilter

IDapperSource

ITableView

ISqlEntity

继承成员

GroupByAliasTableQuery<TTable>.Where

GroupByAliasTableQuery<TTable>.And(Func<TTable, IColumn>, Func<IPrefixField, IAggregateField>, Func<IAggregateField, AtomicLogic>)

GroupByAliasTableQuery<TTable>.Or(Func<TTable, IColumn>, Func<IPrefixField, IAggregateField>, Func<IAggregateField, AtomicLogic>)

GroupByAliasTableQuery<TTable>.WriteGroupBySource(ISqlEngine, StringBuilder)

GroupByQueryBase<IAliasTable<TTable>>.Source

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<TTable>(DapperGroupByAliasTableQuery<TTable>)

ShadowSqlCoreServices.And<Query>(Query, AndLogic)

ShadowSqlCoreServices.And<Query>(Query, AtomicLogic)

ShadowSqlCoreServices.And<Query>(Query, ComplexAndLogic)

ShadowSqlCoreServices.And<Query>(Query, ComplexOrLogic)

ShadowSqlCoreServices.And<Query>(Query, Logic)

ShadowSqlCoreServices.And<Query>(Query, OrLogic)

ShadowSqlCoreServices.And<Query>(Query, Func<IGroupByView, AtomicLogic>)

ShadowSqlCoreServices.And<Query>(Query, Func<IGroupByView, OrLogic>)

ShadowSqlCoreServices.And<Query>(Query, Func<ITableView, AtomicLogic>)

ShadowSqlCoreServices.And<Query>(Query, Func<ITableView, OrLogic>)

ShadowSqlCoreServices.Apply<Query>(Query, Func<Logic, IGroupByView, Logic>)

ShadowSqlCoreServices.Apply<Query>(Query, Func<Logic, ITableView, Logic>)

ShadowSqlCoreServices.Apply<Query>(Query, Func<Logic, Logic>)

ShadowSqlCoreServices.Or<Query>(Query, AndLogic)

ShadowSqlCoreServices.Or<Query>(Query, AtomicLogic)

ShadowSqlCoreServices.Or<Query>(Query, ComplexAndLogic)

ShadowSqlCoreServices.Or<Query>(Query, ComplexOrLogic)

ShadowSqlCoreServices.Or<Query>(Query, Logic)

ShadowSqlCoreServices.Or<Query>(Query, OrLogic)

ShadowSqlCoreServices.Or<Query>(Query, Func<IGroupByView, AndLogic>)

ShadowSqlCoreServices.Or<Query>(Query, Func<IGroupByView, AtomicLogic>)

ShadowSqlCoreServices.Or<Query>(Query, Func<ITableView, AndLogic>)

ShadowSqlCoreServices.Or<Query>(Query, Func<ITableView, AtomicLogic>)

DapperShadowCoreServices.Count(IDapperSource, object?)

DapperShadowCoreServices.CountAsync(IDapperSource, object?)

DapperShadowCoreServices.LongCount(IDapperSource, object?)

DapperShadowCoreServices.LongCountAsync(IDapperSource, object?)

ShadowSqlServices.ToSingle(IDataFilter, IFieldView)

ShadowSqlServices.ToSingle(IDataFilter, string)

DapperShadowServices.ToDapperSelect<TTable>(GroupByAliasTableQuery<TTable>, IExecutor)

ShadowSqlServices.Take<TTable>(GroupByAliasTableQuery<TTable>, int, int)

ShadowSqlServices.ToCursor<TTable>(GroupByAliasTableQuery<TTable>, int, int)

ShadowSqlServices.ToSingle<TTable>(GroupByAliasTableQuery<TTable>, Func<TTable, IColumn>, Func<IPrefixField, IAggregateFieldAlias>)

AggregateAsServices.AggregateAs(IGroupByView, string, string, string)

AggregateAsServices.AvgAs(IGroupByView, string, string)

AggregateAsServices.CountAs(IGroupByView, string)

AggregateAsServices.DistinctCountAs(IGroupByView, string, string)

AggregateAsServices.MaxAs(IGroupByView, string, string)

AggregateAsServices.MinAs(IGroupByView, string, string)

AggregateAsServices.SumAs(IGroupByView, string, string)

ShadowSqlCoreServices.Aggregate(IGroupByView, string, string)

ShadowSqlCoreServices.Avg(IGroupByView, string)

ShadowSqlCoreServices.Count(IGroupByView)

ShadowSqlCoreServices.DistinctCount(IGroupByView, string)

ShadowSqlCoreServices.Max(IGroupByView, string)

ShadowSqlCoreServices.Min(IGroupByView, string)

ShadowSqlCoreServices.Sum(IGroupByView, string)

ShadowSqlServices.ToSingle(IGroupByView, Func<IGroupByView, IFieldView>)

DapperShadowCoreServices.Count(ITableView, IExecutor, object?)

DapperShadowCoreServices.CountAsync(ITableView, IExecutor, object?)

DapperShadowCoreServices.LongCount(ITableView, IExecutor, object?)

DapperShadowCoreServices.LongCountAsync(ITableView, IExecutor, object?)

ShadowSqlCoreServices.AsExists(ITableView)

ShadowSqlCoreServices.AsNotExists(ITableView)

ShadowSqlCoreServices.Field(ITableView, string)

ShadowSqlCoreServices.Fields(ITableView, params IEnumerable<string>)

ShadowSqlCoreServices.Strict(ITableView, string)

构造函数

DapperGroupByAliasTableQuery(IExecutor, IAliasTable<TTable>, ISqlLogic, IField[], Logic)

对别名表分组

public DapperGroupByAliasTableQuery(IExecutor executor, IAliasTable<TTable> aliasTable, ISqlLogic where, IField[] fields, Logic having)

参数

executor IExecutor

执行器

aliasTable IAliasTable<TTable>

别名表

where ISqlLogic

查询条件

fields IField[]

字段

having Logic

分组查询条件

属性

Executor

执行器

public IExecutor Executor { get; }

属性值

IExecutor