GroupByBase 类

命名空间

ShadowSql.GroupBy

程序集

ShadowSql.Core.dll

分组基类

public abstract class GroupByBase : FilterBase, IGroupByView, ITableView, ISqlEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

GroupByBase

实现

IGroupByView

ITableView

ISqlEntity

衍生

GroupByBase<TFilter>

继承成员

FilterBase.WriteFilter(ISqlEngine, StringBuilder)

FilterBase.WriteCore(ISqlEngine, StringBuilder)

ViewBase.GetCompareField(string)

扩展方法

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)

构造函数

GroupByBase(IField[])

分组基类

public GroupByBase(IField[] fields)

参数

fields IField[]

字段

属性

Columns

分组列

public IColumn[] Columns { get; }

属性值

IColumn[]

GroupByFields

分组字段

public IField[] GroupByFields { get; }

属性值

IField[]

Source

分组数据源表

public abstract ITableView Source { get; }

属性值

ITableView

方法

FilterPrefix(ISqlEngine, StringBuilder)

筛选前缀

protected override void FilterPrefix(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql

GetField(string)

获取字段

protected override IField? GetField(string fieldName)

参数

fieldName string

字段名

返回

IField

GetFields()

所有字段

protected override IEnumerable<IField> GetFields()

返回

IEnumerable<IField>

NewField(string)

分组不支持构造新字段

protected override IField NewField(string fieldName)

参数

fieldName string

字段名

返回

IField

异常

ArgumentException

WriteGroupBy(ISqlEngine, StringBuilder)

拼写分组条件

protected void WriteGroupBy(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql

异常

InvalidOperationException

WriteGroupBySource(ISqlEngine, StringBuilder)

分组数据源拼写

protected abstract void WriteGroupBySource(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql

WriteSource(ISqlEngine, StringBuilder)

拼写数据源

protected override void WriteSource(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql