DapperGroupByAliasTableSqlQuery<TTable> 类

命名空间

Dapper.Shadow.GroupBy

程序集

Dapper.Shadow.dll

对别名表分组

public class DapperGroupByAliasTableSqlQuery<TTable> : GroupByAliasTableSqlQuery<TTable>, IGroupByView, IDataSqlQuery, IDataFilter, IDapperSource, ITableView, ISqlEntity where TTable : ITable

类型参数

TTable

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

GroupByBase

GroupByBase<SqlQuery>

GroupBySqlQueryBase<IAliasTable<TTable>>

GroupByAliasTableSqlQuery<TTable>

DapperGroupByAliasTableSqlQuery<TTable>

实现

IGroupByView

IDataSqlQuery

IDataFilter

IDapperSource

ITableView

ISqlEntity

继承成员

GroupByAliasTableSqlQuery<TTable>.Where

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

GroupByAliasTableSqlQuery<TTable>.WriteGroupBySource(ISqlEngine, StringBuilder)

GroupBySqlQueryBase<IAliasTable<TTable>>.Source

GroupByBase<SqlQuery>.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)

扩展方法

DapperShadowServices.ToDapperSelect<TTable>(DapperGroupByAliasTableSqlQuery<TTable>)

FieldQueryServices.FieldBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

FieldQueryServices.FieldBetween<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldGreaterEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldGreaterEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldGreaterValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldGreater<TQuery>(TQuery, string, string)

FieldQueryServices.FieldInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

FieldQueryServices.FieldIn<TQuery>(TQuery, string, string)

FieldQueryServices.FieldIsNull<TQuery>(TQuery, string)

FieldQueryServices.FieldLessEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldLessEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLessValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldLess<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLikeValue<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLike<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

FieldQueryServices.FieldNotBetween<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldNotEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldNotEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

FieldQueryServices.FieldNotIn<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotLikeValue<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotLike<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotNull<TQuery>(TQuery, string)

FieldQueryServices.FieldParameter<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldValue<TQuery, TValue>(TQuery, string, TValue, string)

ShadowSqlCoreServices.Apply<TGroupBy>(TGroupBy, Func<SqlQuery, IGroupByView, SqlQuery>)

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

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

ShadowSqlCoreServices.Exists<Query>(Query, ITableView)

ShadowSqlCoreServices.HavingAggregate<TGroupBy>(TGroupBy, string, string, Func<IAggregateField, AtomicLogic>)

ShadowSqlCoreServices.Having<TGroupBy>(TGroupBy, AtomicLogic)

ShadowSqlCoreServices.Having<TGroupBy>(TGroupBy, params IEnumerable<string>)

ShadowSqlCoreServices.Having<TGroupBy>(TGroupBy, Func<IGroupByView, AtomicLogic>)

ShadowSqlCoreServices.In<Query>(Query, ICompareView, ISingleSelect)

ShadowSqlCoreServices.NotExists<Query>(Query, ITableView)

ShadowSqlCoreServices.NotIn<Query>(Query, ICompareView, ISingleSelect)

ShadowSqlCoreServices.ToAnd<Query>(Query)

ShadowSqlCoreServices.ToOr<Query>(Query)

StrictQueryServices.StrictBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

StrictQueryServices.StrictBetween<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictGreaterEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictGreaterEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictGreaterValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictGreater<TQuery>(TQuery, string, string)

StrictQueryServices.StrictInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

StrictQueryServices.StrictIn<TQuery>(TQuery, string, string)

StrictQueryServices.StrictIsNull<TQuery>(TQuery, string)

StrictQueryServices.StrictLessEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictLessEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLessValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictLess<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLikeValue<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLike<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

StrictQueryServices.StrictNotBetween<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictNotEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictNotEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

StrictQueryServices.StrictNotIn<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotLikeValue<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotLike<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotNull<TQuery>(TQuery, string)

StrictQueryServices.StrictParameter<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictValue<TQuery, TValue>(TQuery, string, TValue, string)

DapperShadowCoreServices.Count(IDapperSource, object?)

DapperShadowCoreServices.CountAsync(IDapperSource, object?)

DapperShadowCoreServices.LongCount(IDapperSource, object?)

DapperShadowCoreServices.LongCountAsync(IDapperSource, object?)

ShadowSqlServices.ToSingle(IDataFilter, IFieldView)

ShadowSqlServices.ToSingle(IDataFilter, string)

DapperShadowServices.ToDapperSelect<TTable>(GroupByAliasTableSqlQuery<TTable>, IExecutor)

ShadowSqlServices.Take<TTable>(GroupByAliasTableSqlQuery<TTable>, int, int)

ShadowSqlServices.ToCursor<TTable>(GroupByAliasTableSqlQuery<TTable>, int, int)

ShadowSqlServices.ToSelect<TTable>(GroupByAliasTableSqlQuery<TTable>)

ShadowSqlServices.ToSingle<TTable>(GroupByAliasTableSqlQuery<TTable>, Func<TTable, IColumn>, Func<IPrefixField, IAggregateFieldAlias>)

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)

构造函数

DapperGroupByAliasTableSqlQuery(IExecutor, IAliasTable<TTable>, ISqlLogic, IField[], SqlQuery)

对别名表分组

public DapperGroupByAliasTableSqlQuery(IExecutor executor, IAliasTable<TTable> aliasTable, ISqlLogic where, IField[] fields, SqlQuery having)

参数

executor IExecutor

执行器

aliasTable IAliasTable<TTable>

别名表

where ISqlLogic

查询条件

fields IField[]

字段

having SqlQuery

分组查询条件

属性

Executor

执行器

public IExecutor Executor { get; }

属性值

IExecutor