GroupByTableQuery<TKey, TEntity> 类

命名空间

ShadowSql.Expressions.GroupBy

程序集

ShadowSql.Expressions.dll

分组查询

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

类型参数

TKey

TEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

GroupByBase

GroupByBase<Logic>

GroupByQueryBase<ITableView>

GroupByTableQuery<TKey, TEntity>

实现

IGroupByView

IDataQuery

IDataFilter

ITableView

ISqlEntity

IWrapper<ITableView>

继承成员

GroupByQueryBase<ITableView>.Original

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)

扩展方法

ShadowSqlServices.Take<TKey, TEntity>(GroupByTableQuery<TKey, TEntity>, int, int)

ShadowSqlServices.ToCursor<TKey, TEntity>(GroupByTableQuery<TKey, TEntity>, int, int)

ShadowSqlServices.ToSelect<TKey, TEntity>(GroupByTableQuery<TKey, TEntity>)

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)

构造函数

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

sql