/// <summary>
/// 构造函数
/// </summary>
public SelectSqlForSubQuery()
: base()
{
From = new From();
MainFromItem = new FromItem();
Condition = new FilterConditionStatement();
JoinCondition = new JoinConditionStatement();
joinSubQueryConditionItem = new JoinConditionItem();
//JoinCondition.ChildCollection.Add(this.joinSubQueryConditionItem);
}
/// <summary>
/// 构造函数
/// </summary>
public SubQuerySqlStatement()
: base()
{
From = new From();
mainFromItem = new FromItem();
From.ChildCollection.Add(mainFromItem);
SelectList = new SelectFieldListStatement();
JoinCondition = new JoinConditionStatement();
FilterCondition = new ConditionStatement();
OrderByCondition = new ConditionStatement();
DictFieldAliasMapping = new Dictionary <string, string>();
}
/// <summary>
/// 根据SQLDOM元素类型初始化SQLDOM元素对象
/// </summary>
/// <param name="sqlElementType">SQLDOM元素类型</param>
/// <returns>SQLDOM元素对象</returns>
public static SqlElement GetSQLElement(int sqlElementType)
{
SqlElement element = null;
SqlElementType type = (SqlElementType)sqlElementType;
switch (type)
{
case SqlElementType.InsertField:
element = new InsertField();
break;
case SqlElementType.SqlPrimaryKeyField:
element = new SqlPrimaryKeyField();
break;
case SqlElementType.SelectListField:
element = new SelectListField();
break;
case SqlElementType.UpdateField:
element = new UpdateField();
break;
case SqlElementType.From:
element = new From();
break;
case SqlElementType.FromItem:
element = new FromItem();
break;
case SqlElementType.JoinCondition:
element = new JoinConditionStatement();
break;
case SqlElementType.OrderByCondition:
element = new ConditionStatement();
break;
case SqlElementType.FilterCondition:
element = new ConditionStatement();
break;
case SqlElementType.UnKnown:
break;
}
return(element);
}
