GroupBySqlQueryBase<TSource> 类

命名空间

ShadowSql.GroupBy

程序集

ShadowSql.dll

分组sql查询基类

public abstract class GroupBySqlQueryBase<TSource> : GroupByBase<SqlQuery>, IGroupByView, IDataSqlQuery, IDataFilter, ITableView, ISqlEntity where TSource : ITableView

类型参数

TSource

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

GroupByBase

GroupByBase<SqlQuery>

GroupBySqlQueryBase<TSource>

实现

IGroupByView

IDataSqlQuery

IDataFilter

ITableView

ISqlEntity

Derived

GroupByAliasTableSqlQuery<TTable>

GroupByMultiSqlQuery

GroupByTableSqlQuery<TTable>

继承成员

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)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

扩展方法

ShadowSqlServices.ToSingle(IDataFilter, IFieldView)

ShadowSqlServices.ToSingle(IDataFilter, string)

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)

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)

构造函数

GroupBySqlQueryBase(TSource, IField[], SqlQuery)

分组sql查询基类

protected GroupBySqlQueryBase(TSource source, IField[] fields, SqlQuery having)

参数

source TSource

fields IField[]

having SqlQuery

属性

Source

分组数据源表

public override ITableView Source { get; }

属性值

ITableView

方法

WriteGroupBySource(ISqlEngine, StringBuilder)

输出数据源

protected override void WriteGroupBySource(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

sql StringBuilder