[Adapdev-commits] Adapdev/src/Adapdev.CodeGen NVelocityTableCodeTemplate.cs,1.13,1.14

[Sean M. <int...@us...>]

Update of /cvsroot/adapdev/Adapdev/src/Adapdev.CodeGen
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv3653/src/Adapdev.CodeGen

Modified Files:
	NVelocityTableCodeTemplate.cs 
Log Message:


Index: NVelocityTableCodeTemplate.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.CodeGen/NVelocityTableCodeTemplate.cs,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** NVelocityTableCodeTemplate.cs	9 Dec 2005 05:30:30 -0000	1.13
--- NVelocityTableCodeTemplate.cs	3 Mar 2006 05:22:54 -0000	1.14
***************
*** 421,424 ****
--- 421,446 ----
  		}
  
+ 		public string GetJoinStatement(object id, ForeignKeyAssociation assoc, DbType dbType)
+ 		{
+ 			string text = String.Empty;
+ 
+ 			if(assoc.AssociationType == AssociationType.OneToOne ||
+ 				assoc.AssociationType == AssociationType.OneToMany)
+ 			{
+ 				ISelectQuery query = QueryFactory.CreateSelectQuery(dbType);
+ 				query.SetTable(assoc.SecondForeignTableName);
+ 				query.AddAll();
+ 				query.AddJoin(assoc.TableName, assoc.ColumnName, assoc.SecondForeignColumnName, JoinType.INNER);
+ 
+ 				ICriteria criteria = query.CreateCriteria();
+ 				criteria.AddEqualTo(assoc.Table.GetPrimaryKey(0).Name, id);
+ 				query.SetCriteria(criteria);
+ 
+ 				text = query.GetText();
+ 			}
+ 
+ 			return text;
+ 		}
+ 
  	}
  }
\ No newline at end of file