Update of /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29386/src/Adapdev.Data/Sql
Modified Files:
ISelectQuery.cs SelectQuery.cs
Log Message:
Restoring some more hosed files
Index: SelectQuery.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/SelectQuery.cs,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** SelectQuery.cs 16 Nov 2005 07:01:48 -0000 1.9
--- SelectQuery.cs 26 Nov 2005 09:08:59 -0000 1.10
***************
*** 147,150 ****
--- 147,169 ----
}
+ public virtual void AddJoin(string secondTable, string firstTableColumn, string secondTableColumn, string thirdTable, string thirdTableColumn, string fourthTable, string fourthTableColumn, JoinType type)
+ {
+ this._join = String.Format(" {0} {1} ON {2}.{3} = {4}.{5} {6} {7} ON {8}.{9} = {10}.{11} ",
+ this.GetJoinType(type),
+ QueryHelper.GetPreDelimeter(this.type) + secondTable + QueryHelper.GetPostDelimeter(this.type),
+ this._table,
+ QueryHelper.GetPreDelimeter(this.type) + firstTableColumn + QueryHelper.GetPostDelimeter(this.type),
+ QueryHelper.GetPreDelimeter(this.type) + secondTable + QueryHelper.GetPostDelimeter(this.type),
+ QueryHelper.GetPreDelimeter(this.type) + secondTableColumn + QueryHelper.GetPostDelimeter(this.type),
+ this.GetJoinType(type),
+ QueryHelper.GetPreDelimeter(this.type) + fourthTable + QueryHelper.GetPostDelimeter(this.type),
+ QueryHelper.GetPreDelimeter(this.type) + thirdTable + QueryHelper.GetPostDelimeter(this.type),
+ QueryHelper.GetPreDelimeter(this.type) + thirdTableColumn + QueryHelper.GetPostDelimeter(this.type),
+ QueryHelper.GetPreDelimeter(this.type) + fourthTable + QueryHelper.GetPostDelimeter(this.type),
+ QueryHelper.GetPreDelimeter(this.type) + fourthTableColumn + QueryHelper.GetPostDelimeter(this.type));
+
+ }
+
+
public void SetTable(string tableName)
{
Index: ISelectQuery.cs
===================================================================
RCS file: /cvsroot/adapdev/Adapdev/src/Adapdev.Data/Sql/ISelectQuery.cs,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** ISelectQuery.cs 16 Nov 2005 07:01:48 -0000 1.8
--- ISelectQuery.cs 26 Nov 2005 09:08:59 -0000 1.9
***************
*** 78,81 ****
--- 78,83 ----
/// <param name="type">The join type</param>
void AddJoin(string secondTable, string firstTableColumn, string secondTableColumn, JoinType type);
+
+ void AddJoin(string secondTable, string firstTableColumn, string secondTableColumn, string thirdTable, string thirdTableColumn, string fourthTable, string fourtTableColumn, JoinType joinType);
/// <summary>
/// Set's the maximum number of records to retrieve
|
