[Quantproject-developers] QuantProject/b2_DataAccess/Tables Quotes.cs,1.26,1.27

[Marco M. <mi...@us...>]

Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1539/b2_DataAccess/Tables

Modified Files:
	Quotes.cs 
Log Message:
GetTickersByOpenToCloseWinningDays has been moved to Quotes class in data layer.
Added new parameter to the method.


Index: Quotes.cs
===================================================================
RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Quotes.cs,v
retrieving revision 1.26
retrieving revision 1.27
diff -C2 -d -r1.26 -r1.27
*** Quotes.cs	2 Jun 2005 18:06:17 -0000	1.26
--- Quotes.cs	18 Sep 2005 21:03:43 -0000	1.27
***************
*** 590,598 ****
        return SqlExecutor.GetDataTable( sql );
      }
! 
      /// <summary>
      /// returns tickers counting how many times raw close is greater than raw open 
      /// for the given interval of days (within the given group of tickers).
!     /// Tickers are ordered by the number of days  raw open is greater than raw close
      /// </summary>
      public static DataTable GetTickersByOpenToCloseWinningDays( bool orderInASCMode, string groupID,
--- 590,598 ----
        return SqlExecutor.GetDataTable( sql );
      }
!     /*moved to Quotes inside data layer
      /// <summary>
      /// returns tickers counting how many times raw close is greater than raw open 
      /// for the given interval of days (within the given group of tickers).
!     /// Tickers are ordered by the number of days raw open is greater than raw close
      /// </summary>
      public static DataTable GetTickersByOpenToCloseWinningDays( bool orderInASCMode, string groupID,
***************
*** 601,604 ****
--- 601,605 ----
                                                      long maxNumOfReturnedTickers)
      {
+       
        string sql = "SELECT TOP " + maxNumOfReturnedTickers + " quotes.quTicker, tickers.tiCompanyName, " +
                    "Count(quotes.quClose) AS CloseToOpenWinningDays " +
***************
*** 617,621 ****
        return SqlExecutor.GetDataTable( sql );
      }
!     
      /// <summary>
      /// returns the average traded value for the given ticker in the specified interval
--- 618,622 ----
        return SqlExecutor.GetDataTable( sql );
      }
!     */
      /// <summary>
      /// returns the average traded value for the given ticker in the specified interval
***************
*** 811,815 ****
        DataTable dt;
        int returnValue = 0;
!     	string sql = "SELECT Count(quotes.quClose) AS CloseToOpenWinningDays " +
        						"FROM quotes WHERE " + 
      							"quotes.quDate Between " + SQLBuilder.GetDateConstant(firstQuoteDate) + " " +
--- 812,816 ----
        DataTable dt;
        int returnValue = 0;
!     	string sql = "SELECT Count(*) AS CloseToOpenWinningDays " +
        						"FROM quotes WHERE " + 
      							"quotes.quDate Between " + SQLBuilder.GetDateConstant(firstQuoteDate) + " " +