Table of Contents

GroupByMultiSqlQuery 类

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

对MultiQuery进行分组查询

public class GroupByMultiSqlQuery : GroupBySqlQueryBase<IMultiView>, IGroupByView, IDataSqlQuery, IDataFilter, ITableView, ISqlEntity
继承
GroupByMultiSqlQuery
实现
Derived
继承成员
扩展方法

构造函数

GroupByMultiSqlQuery(IMultiView, IField[])

对多表进行分组查询

public GroupByMultiSqlQuery(IMultiView multiTable, IField[] fields)

参数

multiTable IMultiView
fields IField[]

GroupByMultiSqlQuery(IMultiView, IField[], SqlQuery)

对MultiQuery进行分组查询

public GroupByMultiSqlQuery(IMultiView multiTable, IField[] fields, SqlQuery filter)

参数

multiTable IMultiView
fields IField[]
filter SqlQuery

方法

HavingAggregate<TAliasTable>(string, Func<TAliasTable, IAggregateField>, Func<IAggregateField, AtomicLogic>)

按逻辑查询

public GroupByMultiSqlQuery HavingAggregate<TAliasTable>(string tableName, Func<TAliasTable, IAggregateField> aggregate, Func<IAggregateField, AtomicLogic> query) where TAliasTable : IAliasTable

参数

tableName string
aggregate Func<TAliasTable, IAggregateField>
query Func<IAggregateField, AtomicLogic>

返回

GroupByMultiSqlQuery

类型参数

TAliasTable

HavingAggregate<TTable>(string, Func<TTable, IColumn>, Func<IPrefixField, IAggregateField>, Func<IAggregateField, AtomicLogic>)

按逻辑查询

public GroupByMultiSqlQuery HavingAggregate<TTable>(string tableName, Func<TTable, IColumn> select, Func<IPrefixField, IAggregateField> aggregate, Func<IAggregateField, AtomicLogic> query) where TTable : ITable

参数

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

返回

GroupByMultiSqlQuery

类型参数

TTable
编辑本文