[Quantproject-developers] QuantProject/b2_DataAccess DataBase.cs, 1.15, 1.16

[Glauco S. <gla...@us...>]

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess
In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv14805/b2_DataAccess

Modified Files:
	DataBase.cs 
Log Message:
the method
getFilterForDailyTimes()
now returnes a "in (...)" sql where clause.
In the previous revision, the method returned a list of "or" where clauses.
The resulting sql statement is much shorter, now

Index: DataBase.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/DataBase.cs,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
*** DataBase.cs	14 Jan 2009 23:37:51 -0000	1.15
--- DataBase.cs	22 Jan 2009 18:58:46 -0000	1.16
***************
*** 209,232 ****
  		#region getFilterForDailyTimes
  		
- //		#region getFilterForDailyTime
- //		private getFilterForDailyTime( DateTime dateTime )
- //		{
- //			string filterForDailyTime =
- //				"(Format([baDateTimeForOpen],'hh:mm:ss')>='" +
- //				this.getSqlTimeConstantForFirstDailyBar() + "')";
- //		}
- //		#endregion getFilterForDailyTime
- 		
  		private static string getFilterForDailyTimes( List< Time > dailyTimes )
  		{
! 			string filterForDailyTimes = "";
  			foreach( Time time in dailyTimes )
  				filterForDailyTimes =
  					filterForDailyTimes +
! 					SQLBuilder.GetFilterForTime(
! 						"baDateTimeForOpen" , SqlComparisonOperator.Equal , time ) +
! 					" or ";
  			filterForDailyTimes = filterForDailyTimes.Substring(
! 				0 , filterForDailyTimes.Length - " or ".Length );
  			return filterForDailyTimes;
  		}
--- 209,224 ----
  		#region getFilterForDailyTimes
  		
  		private static string getFilterForDailyTimes( List< Time > dailyTimes )
  		{
! 			string filterForDailyTimes =
! 				SQLBuilder.GetFormatFunctionForTime( "baDateTimeForOpen" ) + " in ( ";
  			foreach( Time time in dailyTimes )
  				filterForDailyTimes =
  					filterForDailyTimes +
! 					SQLBuilder.GetTimeConstant( time ) +
! 					" , ";
  			filterForDailyTimes = filterForDailyTimes.Substring(
! 				0 , filterForDailyTimes.Length - " , ".Length );
! 			filterForDailyTimes += " )";
  			return filterForDailyTimes;
  		}