コード例 #1
0
		private void EmitFrom()
		{
			SqlTableAlias tbl;
			foreach (NPathClassName className in query.From.Classes) 
			{
				tbl = propertyPathTraverser.GetClassTableAlias(className.Name);
				if (!(includedTableAliases.Contains(tbl)))
				{
					FromTable fromTable = new FromTable();
					fromTable.Alias = tbl ;

					fromTables.Add(fromTable);
					includedTableAliases.Add(tbl);	
				
				}
			}
		}
コード例 #2
0
		private string EmitLeftOuterJoin(TableJoin tableJoin, FromTable fromTable) //, StringBuilder whereBuilder)
		{
			StringBuilder clause = new StringBuilder() ;
			IPropertyMap propertyMap = tableJoin.PropertyMap ;
			ITableMap tableMap = propertyMap.MustGetTableMap();
			ArrayList columnMaps = tableJoin.ColumnMaps;
			object hashObject = tableJoin.Parent;
			if (hashObject == null) { hashObject = propertyMap; }
			SqlTableAlias tbl = GetTableAlias(tableMap, hashObject);
			SqlColumnAlias col;
			SqlTableAlias idtbl = null;
			SqlColumnAlias idcol;
			ITableMap idTableMap;
			foreach (IColumnMap columnMap in columnMaps)
			{
				if (idtbl == null)
				{
					idTableMap = columnMap.MustGetPrimaryKeyTableMap();
					idtbl = GetTableAlias(idTableMap, tableJoin);
				}
				col = tbl.GetSqlColumnAlias(columnMap);
				idcol = idtbl.GetSqlColumnAlias(columnMap.MustGetPrimaryKeyColumnMap());
				fromTable.Alias = idtbl;
				fromTable.LinksToAlias = tbl;
				fromTable.Columns.Add(idcol); 
				fromTable.LinksToColumns.Add(col); 
				this.includedTableAliases.Add(idtbl);
			}
			if (tableJoin.BaseTableMap != null)
			{
				columnMaps = tableJoin.BaseColumnMaps;
				tbl = GetTableAlias(tableMap, hashObject);
				idtbl = null;
				foreach (IColumnMap columnMap in columnMaps)
				{
					if (idtbl == null)
					{
						if (hashObject is IPropertyMap) { hashObject = ((IPropertyMap) hashObject).ClassMap ; }
						idtbl = GetTableAlias(columnMap.MustGetPrimaryKeyTableMap(), hashObject);					
					}
					col = tbl.GetSqlColumnAlias(columnMap);
					idcol = idtbl.GetSqlColumnAlias(columnMap.MustGetPrimaryKeyColumnMap());

//					fromTable.Alias = idtbl;
//					fromTable.LinksToAlias = tbl;
//					fromTable.Columns.Add(idcol); 
//					fromTable.LinksToColumns.Add(col); 
//					this.includedTableAliases.Add(idtbl);

					fromTable.Alias = tbl;
					fromTable.LinksToAlias = idtbl;
					fromTable.Columns.Add(col); 
					fromTable.LinksToColumns.Add(idcol); 
					this.includedTableAliases.Add(tbl);

//					SqlSearchCondition search = select.SqlWhereClause.GetNextSqlSearchCondition();
//					search.GetSqlComparePredicate(col, SqlCompareOperatorType.Equals, idcol);
				}
				
			}
			return clause.ToString();			
		}
コード例 #3
0
		private void RenderLeftOuterJoinFrom(FromTable tbl)
		{
			foreach ( FromTable fromTable in fromJoinTables )
			{
				if (fromTable.LinksToAlias == tbl.Alias )
				{
					EmitFromTable(fromTable);

					RenderLeftOuterJoinFrom(fromTable);
				}					
			}
		}
コード例 #4
0
		private void EmitFromTable(FromTable fromTable)
		{
			if (fromTable.LinksToAlias != null)
			{
				SqlJoinTableSource join = select.SqlFromClause.AddSqlJoinTableSource(fromTable.Alias, fromTable.LinksToAlias, SqlJoinType.LeftOuter);
				int i = 0;

				foreach (SqlColumnAlias column in fromTable.Columns)
				{
					SqlColumnAlias linksToColumn = (SqlColumnAlias) fromTable.LinksToColumns[i];
					
					SqlSearchCondition search = join.GetNextSqlSearchCondition();
					search.GetSqlComparePredicate(column, SqlCompareOperatorType.Equals,  linksToColumn);

					i++;
				}

			}
			else
			{
				select.SqlFromClause.AddSqlAliasTableSource(fromTable.Alias);
			}

		}
コード例 #5
0
		private void GetFromClauseJoinTables() 
		{
			Hashtable tablePropertyAliases = null;
			foreach (ITableMap tableMap in this.tableAliases.Keys)
			{
				tablePropertyAliases = (Hashtable) this.tableAliases[tableMap];
				foreach (string s in tablePropertyAliases.Values)
				{
					SqlTableAlias table = select.GetSqlTableAlias(tableMap, s);
					if (!(includedTableAliases.Contains(table)))
					{
						FromTable fromTable = new FromTable() ;

						fromTable.Alias = table;
						
						fromAliasTables.Add(fromTable);

						includedTableAliases.Add(table);
					}
				}
			}
		}
コード例 #6
0
		private void GetWhereClauseJoinTables(ArrayList tableJoins)
		{
			ReferenceType refType;

			foreach (TableJoin tableJoin in tableJoins)
			{
				refType = tableJoin.PropertyMap.ReferenceType;
				if (refType != ReferenceType.None)
				{
					CreateJoin(tableJoin);
					if (tableJoin.JoinType == JoinType.InnerJoin)
					{
						EmitOldStyleInnerJoin(tableJoin);					
					}
					else
					{					
						FromTable fromTable = new FromTable();
						EmitLeftOuterJoin(tableJoin, fromTable);
						fromJoinTables.Add(fromTable);			
					}
				}
				GetWhereClauseJoinTables(tableJoin.Children);					
			}
		}