GroupByQueryBase<TSource> 类

命名空间

ShadowSql.GroupBy

程序集

ShadowSql.dll

分组sql查询基类

public abstract class GroupByQueryBase<TSource> : GroupByBase<Logic>, IGroupByView, IDataQuery, IDataFilter, ITableView, ISqlEntity where TSource : ITableView

类型参数

TSource

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

GroupByBase

GroupByBase<Logic>

GroupByQueryBase<TSource>

实现

IGroupByView

IDataQuery

IDataFilter

ITableView

ISqlEntity

衍生

GroupByAliasTableQuery<TTable>

GroupByMultiQuery

GroupByTableQuery<TTable>

继承成员

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.ToSingle(IDataFilter, IFieldView)

ShadowSqlServices.ToSingle(IDataFilter, string)

ShadowSqlCoreServices.And<Query>(Query, AndLogic)

ShadowSqlCoreServices.And<Query>(Query, AtomicLogic)

ShadowSqlCoreServices.And<Query>(Query, ComplexAndLogic)

ShadowSqlCoreServices.And<Query>(Query, ComplexOrLogic)

ShadowSqlCoreServices.And<Query>(Query, Logic)

ShadowSqlCoreServices.And<Query>(Query, OrLogic)

ShadowSqlCoreServices.And<Query>(Query, Func<IGroupByView, AtomicLogic>)

ShadowSqlCoreServices.And<Query>(Query, Func<IGroupByView, OrLogic>)

ShadowSqlCoreServices.And<Query>(Query, Func<ITableView, AtomicLogic>)

ShadowSqlCoreServices.And<Query>(Query, Func<ITableView, OrLogic>)

ShadowSqlCoreServices.Apply<Query>(Query, Func<Logic, IGroupByView, Logic>)

ShadowSqlCoreServices.Apply<Query>(Query, Func<Logic, ITableView, Logic>)

ShadowSqlCoreServices.Apply<Query>(Query, Func<Logic, Logic>)

ShadowSqlCoreServices.Or<Query>(Query, AndLogic)

ShadowSqlCoreServices.Or<Query>(Query, AtomicLogic)

ShadowSqlCoreServices.Or<Query>(Query, ComplexAndLogic)

ShadowSqlCoreServices.Or<Query>(Query, ComplexOrLogic)

ShadowSqlCoreServices.Or<Query>(Query, Logic)

ShadowSqlCoreServices.Or<Query>(Query, OrLogic)

ShadowSqlCoreServices.Or<Query>(Query, Func<IGroupByView, AndLogic>)

ShadowSqlCoreServices.Or<Query>(Query, Func<IGroupByView, AtomicLogic>)

ShadowSqlCoreServices.Or<Query>(Query, Func<ITableView, AndLogic>)

ShadowSqlCoreServices.Or<Query>(Query, Func<ITableView, AtomicLogic>)

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)

构造函数

GroupByQueryBase(TSource, IField[], Logic)

分组sql查询基类

protected GroupByQueryBase(TSource view, IField[] fields, Logic having)

参数

view TSource

fields IField[]

字段

having Logic

分组查询条件

属性

Source

分组数据源表

public override ITableView Source { get; }

属性值

ITableView

方法

WriteGroupBySource(ISqlEngine, StringBuilder)

分组数据源拼写

protected override void WriteGroupBySource(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql