JoinOnBase<TJoinTable, TLeft, TRight, LTable, RTable, TFilter> 类

命名空间

ShadowSql.Join

程序集

ShadowSql.dll

联表俩俩关联基类

public abstract class JoinOnBase<TJoinTable, TLeft, TRight, LTable, RTable, TFilter> : JoinOnBase, IJoinOn, IMultiView, IDataFilter, ITableView, ISqlEntity where TJoinTable : IJoinTable where TLeft : IAliasTable<LTable> where TRight : IAliasTable<RTable> where LTable : ITable where RTable : ITable where TFilter : ISqlLogic

类型参数

TJoinTable

TLeft

TRight

LTable

RTable

TFilter

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

JoinOnBase

JoinOnBase<TJoinTable, TLeft, TRight, LTable, RTable, TFilter>

实现

IJoinOn

IMultiView

IDataFilter

ITableView

ISqlEntity

Derived

AliasJoinOnQuery<TLeft, TRight>

AliasJoinOnSqlQuery<TLeft, TRight>

JoinOnQuery<LTable, RTable>

JoinOnSqlQuery<LTable, RTable>

继承成员

JoinOnBase.JoinType

JoinOnBase._tables

JoinOnBase.Tables

JoinOnBase.GetPrefixField(string)

JoinOnBase.GetLeftCompareField(string)

JoinOnBase.GetRightCompareField(string)

JoinOnBase.FilterPrefix(ISqlEngine, StringBuilder)

JoinOnBase.WriteSource(ISqlEngine, StringBuilder)

FilterBase.WriteCore(ISqlEngine, StringBuilder)

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)

DapperShadowServices.ToDapperDelete(IMultiView, IExecutor)

DapperShadowServices.ToDapperSelect(IMultiView, IExecutor)

DapperShadowServices.ToDapperUpdate(IMultiView, IExecutor)

ShadowSqlCoreServices.Alias<TTable>(IMultiView, string)

ShadowSqlCoreServices.From(IMultiView, string)

ShadowSqlCoreServices.From<TAliasTable>(IMultiView, string)

ShadowSqlCoreServices.TableCompare(IMultiView, string, string)

ShadowSqlCoreServices.ToDelete(IMultiView)

ShadowSqlServices.ToSelect(IMultiView)

ShadowSqlServices.ToSingle(IMultiView, Func<IMultiView, IFieldView>)

ShadowSqlServices.ToUpdate(IMultiView)

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)

ShadowSqlCoreServices.Prefix(IJoinOn, IColumn)

ShadowSqlCoreServices.Prefix(IJoinOn, string)

ShadowSqlServices.ToSelect(IJoinOn)

ShadowSqlCoreServices.AsInnerJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsLeftJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsOuterJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsRightJoin<TjoinOn>(TjoinOn)

构造函数

JoinOnBase(TJoinTable, TLeft, TRight, TFilter)

联表俩俩关联基类

protected JoinOnBase(TJoinTable root, TLeft left, TRight right, TFilter filter)

参数

root TJoinTable

left TLeft

right TRight

filter TFilter

字段

_left

左表

protected readonly TLeft _left

字段值

TLeft

_root

联表

protected readonly TJoinTable _root

字段值

TJoinTable

_source

当前数据源(右表)

protected readonly TRight _source

字段值

TRight

属性

Left

左表

public TLeft Left { get; }

属性值

TLeft

PrefixFields

表前缀包装的字段

public IEnumerable<IPrefixField> PrefixFields { get; }

属性值

IEnumerable<IPrefixField>

Root

联表

public TJoinTable Root { get; }

属性值

TJoinTable

Source

当前数据源(右表)

public TRight Source { get; }

属性值

TRight

方法

GetCompareField(string)

获取比较字段

protected override ICompareField GetCompareField(string fieldName)

参数

fieldName string

返回

ICompareField

GetField(string)

获取字段

protected override IField? GetField(string fieldName)

参数

fieldName string

返回

IField

GetFields()

获取所有字段

protected override IEnumerable<IField> GetFields()

返回

IEnumerable<IField>

GetLeftField(string)

获取左边列

public override IPrefixField? GetLeftField(string columName)

参数

columName string

返回

IPrefixField

GetMember(string)

获取联表成员

public override IAliasTable? GetMember(string name)

参数

name string

返回

IAliasTable

GetRightField(string)

获取右边列

public override IPrefixField? GetRightField(string columName)

参数

columName string

返回

IPrefixField

LeftField(string)

获取右边字段

public override IField LeftField(string fieldName)

参数

fieldName string

返回

IField

NewField(string)

构造新字段

protected override IField NewField(string fieldName)

参数

fieldName string

返回

IField

RightField(string)

获取右边字段

public override IField RightField(string fieldName)

参数

fieldName string

返回

IField

WriteFilter(ISqlEngine, StringBuilder)

拼写联表条件

protected override bool WriteFilter(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

sql StringBuilder

返回

bool

WriteRightSource(ISqlEngine, StringBuilder)

拼写联接右表

protected override void WriteRightSource(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

sql StringBuilder