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
|
