Table of Contents

GroupByAliasTableQuery<TTable> 类

命名空间
ShadowSql.GroupBy
程序集
ShadowSql.dll

对别名表分组

public class GroupByAliasTableQuery<TTable> : GroupByQueryBase<IAliasTable<TTable>>, IGroupByView, IDataQuery, IDataFilter, ITableView, ISqlEntity where TTable : ITable

类型参数

TTable
继承
GroupByAliasTableQuery<TTable>
实现
Derived
继承成员
扩展方法

构造函数

GroupByAliasTableQuery(IAliasTable<TTable>, ISqlLogic, IField[])

对TableQuery进行分组查询

public GroupByAliasTableQuery(IAliasTable<TTable> table, ISqlLogic where, IField[] fields)

参数

table IAliasTable<TTable>
where ISqlLogic
fields IField[]

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

对别名表分组

public GroupByAliasTableQuery(IAliasTable<TTable> source, ISqlLogic where, IField[] fields, Logic having)

参数

source IAliasTable<TTable>
where ISqlLogic
fields IField[]
having Logic

属性

Where

where查询条件

public ISqlLogic Where { get; }

属性值

ISqlLogic

方法

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

按聚合逻辑查询

public GroupByAliasTableQuery<TTable> And(Func<TTable, IColumn> select, Func<IPrefixField, IAggregateField> aggregate, Func<IAggregateField, AtomicLogic> query)

参数

select Func<TTable, IColumn>
aggregate Func<IPrefixField, IAggregateField>
query Func<IAggregateField, AtomicLogic>

返回

GroupByAliasTableQuery<TTable>

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

按聚合逻辑查询

public GroupByAliasTableQuery<TTable> Or(Func<TTable, IColumn> select, Func<IPrefixField, IAggregateField> aggregate, Func<IAggregateField, AtomicLogic> query)

参数

select Func<TTable, IColumn>
aggregate Func<IPrefixField, IAggregateField>
query Func<IAggregateField, AtomicLogic>

返回

GroupByAliasTableQuery<TTable>

WriteGroupBySource(ISqlEngine, StringBuilder)

数据源拼写(+WHERE)

protected override void WriteGroupBySource(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine
sql StringBuilder
编辑本文