/// <summary>
/// 初始化表连接项
/// </summary>
/// <param name="joinType">连接类型</param>
/// <param name="table">表名</param>
/// <param name="schema">架构</param>
/// <param name="alias">别名</param>
/// <param name="raw">使用原始值</param>
public JoinItem(string joinType, string table, string schema = null, string alias = null, bool raw = false)
{
JoinType = joinType;
Table = new SqlItem(table, schema, alias, raw);
Conditions = new List <List <OnItem> >();
}
/// <summary>
/// 初始化连接条件项
/// </summary>
/// <param name="left">左表列名</param>
/// <param name="right">右表列名</param>
/// <param name="operator">条件运算符</param>
public OnItem(SqlItem left, SqlItem right, Operator @operator)
{
Left = left;
Right = right;
Operator = @operator;
}
/// <summary>
/// 初始化表连接项
/// </summary>
/// <param name="joinType">连接类型</param>
/// <param name="table">表</param>
/// <param name="conditions">连接条件列表</param>
public JoinItem(string joinType, SqlItem table, List <List <OnItem> > conditions)
{
JoinType = joinType;
Table = table;
Conditions = conditions;
}
/// <summary>
/// 初始化连接条件项
/// </summary>
/// <param name="left">左表列名</param>
/// <param name="right">右表列名</param>
/// <param name="operator">条件运算符</param>
public OnItem(string left, string right, Operator @operator)
{
Left = new SqlItem(left);
Right = new SqlItem(right);
Operator = @operator;
}