[Adapdev-commits] Adapdev/src/Adapdev.Data/Sql ISelectQuery.cs,1.8,1.9 SelectQuery.cs,1.9,1.10

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

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