Table of Contents

GroupByTableQuery<TKey, TEntity> 类

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

分组查询

public class GroupByTableQuery<TKey, TEntity> : GroupByQueryBase<ITableView>, IGroupByView, IDataQuery, IDataFilter, ITableView, ISqlEntity

类型参数

TKey
TEntity
继承
GroupByTableQuery<TKey, TEntity>
实现
继承成员
扩展方法

构造函数

GroupByTableQuery(IAliasTable, ISqlLogic, IField[])

对别名表进行分组查询

public GroupByTableQuery(IAliasTable table, ISqlLogic where, IField[] fields)

参数

table IAliasTable
where ISqlLogic
fields IField[]

GroupByTableQuery(ITable, ISqlLogic, IField[])

对表进行分组查询

public GroupByTableQuery(ITable table, ISqlLogic where, IField[] fields)

参数

table ITable
where ISqlLogic
fields IField[]

属性

Where

where查询条件

public ISqlLogic Where { get; }

属性值

ISqlLogic

方法

And(Expression<Func<IGrouping<TKey, TEntity>, bool>>)

按逻辑查询

public GroupByTableQuery<TKey, TEntity> And(Expression<Func<IGrouping<TKey, TEntity>, bool>> query)

参数

query Expression<Func<IGrouping<TKey, TEntity>, bool>>

返回

GroupByTableQuery<TKey, TEntity>

And<TParameter>(Expression<Func<IGrouping<TKey, TEntity>, TParameter, bool>>)

按逻辑查询

public GroupByTableQuery<TKey, TEntity> And<TParameter>(Expression<Func<IGrouping<TKey, TEntity>, TParameter, bool>> query)

参数

query Expression<Func<IGrouping<TKey, TEntity>, TParameter, bool>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TParameter

参数类型

Or(Expression<Func<IGrouping<TKey, TEntity>, bool>>)

按逻辑查询

public GroupByTableQuery<TKey, TEntity> Or(Expression<Func<IGrouping<TKey, TEntity>, bool>> query)

参数

query Expression<Func<IGrouping<TKey, TEntity>, bool>>

返回

GroupByTableQuery<TKey, TEntity>

Or<TParameter>(Expression<Func<IGrouping<TKey, TEntity>, TParameter, bool>>)

按逻辑查询

public GroupByTableQuery<TKey, TEntity> Or<TParameter>(Expression<Func<IGrouping<TKey, TEntity>, TParameter, bool>> query)

参数

query Expression<Func<IGrouping<TKey, TEntity>, TParameter, bool>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TParameter

参数类型

WriteGroupBySource(ISqlEngine, StringBuilder)

数据源拼写(+WHERE)

protected override void WriteGroupBySource(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine
sql StringBuilder
编辑本文