/// <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); }