AliasJoinOnQuery<TLeft, TRight> 类

命名空间

ShadowSql.Join

程序集

ShadowSql.dll

联表俩俩关联查询

public class AliasJoinOnQuery<TLeft, TRight> : JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>, IJoinOn, IMultiView, IDataQuery, IDataFilter, ITableView, ISqlEntity, IWrapper<ITableView> where TLeft : IAliasTable<ITable> where TRight : IAliasTable<ITable>

类型参数

TLeft

TRight

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

JoinOnBase

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>

AliasJoinOnQuery<TLeft, TRight>

实现

IJoinOn

IMultiView

IDataQuery

IDataFilter

ITableView

ISqlEntity

IWrapper<ITableView>

继承成员

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>._root

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.Root

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>._left

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>._source

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.Left

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.Source

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.PrefixFields

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.GetLeftField(string)

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.GetRightField(string)

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.LeftField(string)

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.RightField(string)

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.GetMember(string)

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.GetFields()

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.GetField(string)

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.NewField(string)

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.GetCompareField(string)

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.WriteRightSource(ISqlEngine, StringBuilder)

JoinOnBase<JoinTableQuery, TLeft, TRight, ITable, ITable, Logic>.WriteFilter(ISqlEngine, StringBuilder)

JoinOnBase.JoinType

JoinOnBase._tables

JoinOnBase.Tables

JoinOnBase.GetLeftField(string)

JoinOnBase.GetRightField(string)

JoinOnBase.GetPrefixField(string)

JoinOnBase.LeftField(string)

JoinOnBase.RightField(string)

JoinOnBase.GetLeftCompareField(string)

JoinOnBase.GetRightCompareField(string)

JoinOnBase.GetMember(string)

JoinOnBase.FilterPrefix(ISqlEngine, StringBuilder)

JoinOnBase.WriteRightSource(ISqlEngine, StringBuilder)

JoinOnBase.WriteSource(ISqlEngine, StringBuilder)

FilterBase.WriteFilter(ISqlEngine, StringBuilder)

FilterBase.WriteCore(ISqlEngine, StringBuilder)

ViewBase.GetCompareField(string)

GetFieldBase.GetFields()

GetFieldBase.GetField(string)

GetFieldBase.NewField(string)

扩展方法

DapperShadowServices.ToDapperDelete(IMultiView, IExecutor)

DapperShadowServices.ToDapperSelect(IMultiView, IExecutor)

DapperShadowServices.ToDapperUpdate(IMultiView, IExecutor)

ShadowSqlServices.ToSelect(IMultiView)

ShadowSqlServices.ToSelect(IMultiView)

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)

ShadowSqlExtendServices.LeftTableJoin<TLeft, TRight, TAliasTable>(AliasJoinOnQuery<TLeft, TRight>, TAliasTable)

ShadowSqlExtendServices.RightTableJoin<TLeft, TRight, TAliasTable>(AliasJoinOnQuery<TLeft, TRight>, TAliasTable)

ShadowSqlServices.ApplyLeft<TJoinOn>(TJoinOn, string, Func<Logic, ICompareView, Logic>)

ShadowSqlServices.ApplyRight<TJoinOn>(TJoinOn, string, Func<Logic, ICompareView, Logic>)

ShadowSqlServices.Apply<TLeft, TRight>(AliasJoinOnQuery<TLeft, TRight>, Func<Logic, TLeft, TRight, Logic>)

ShadowSqlServices.GroupBy<TLeft, TRight>(AliasJoinOnQuery<TLeft, TRight>, Func<TLeft, TRight, IField[]>)

ShadowSqlServices.ToSelect(IJoinOn)

ShadowSqlServices.ToSelect(IJoinOn)

构造函数

AliasJoinOnQuery(JoinTableQuery, TLeft, TRight)

联表俩俩关联查询

public AliasJoinOnQuery(JoinTableQuery joinTable, TLeft left, TRight right)

参数

joinTable JoinTableQuery

联表

left TLeft

左

right TRight

右

AliasJoinOnQuery(JoinTableQuery, TLeft, TRight, Logic)

联表俩俩关联查询

public AliasJoinOnQuery(JoinTableQuery joinTable, TLeft left, TRight right, Logic onQuery)

参数

joinTable JoinTableQuery

联表

left TLeft

左

right TRight

右

onQuery Logic

查询逻辑

方法

Apply(Func<TLeft, IPrefixField>, Func<TRight, IPrefixField>, Func<Logic, IPrefixField, IPrefixField, Logic>)

按列查询

public AliasJoinOnQuery<TLeft, TRight> Apply(Func<TLeft, IPrefixField> left, Func<TRight, IPrefixField> right, Func<Logic, IPrefixField, IPrefixField, Logic> logic)

参数

left Func<TLeft, IPrefixField>

左

right Func<TRight, IPrefixField>

右

logic Func<Logic, IPrefixField, IPrefixField, Logic>

查询逻辑

返回

AliasJoinOnQuery<TLeft, TRight>

ApplyLeft(Func<Logic, TLeft, Logic>)

查询左表

public AliasJoinOnQuery<TLeft, TRight> ApplyLeft(Func<Logic, TLeft, Logic> query)

参数

query Func<Logic, TLeft, Logic>

查询

返回

AliasJoinOnQuery<TLeft, TRight>

ApplyRight(Func<Logic, TRight, Logic>)

查询右表

public AliasJoinOnQuery<TLeft, TRight> ApplyRight(Func<Logic, TRight, Logic> query)

参数

query Func<Logic, TRight, Logic>

查询

返回

AliasJoinOnQuery<TLeft, TRight>