[Quantproject-developers] QuantProject/b2_DataAccess/Tables Bars.cs, 1.7, 1.8
Brought to you by:
glauco_1
|
From: Marco M. <mi...@us...> - 2009-02-05 23:17:25
|
Update of /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv3450/b2_DataAccess/Tables Modified Files: Bars.cs Log Message: Fixed bugs in GetOpen and GetClose methods Index: Bars.cs =================================================================== RCS file: /cvsroot/quantproject/QuantProject/b2_DataAccess/Tables/Bars.cs,v retrieving revision 1.7 retrieving revision 1.8 diff -C2 -d -r1.7 -r1.8 *** Bars.cs 14 Jan 2009 23:36:27 -0000 1.7 --- Bars.cs 5 Feb 2009 22:11:54 -0000 1.8 *************** *** 130,134 **** /// <param name="intervalFrameInSeconds">interval frame in seconds for the ticker's bars</param> /// <returns></returns> ! public static float GetClose( string ticker, DateTime dateTime, int intervalFrameInSeconds ) { DataTable dataTable = SqlExecutor.GetDataTable( --- 130,134 ---- /// <param name="intervalFrameInSeconds">interval frame in seconds for the ticker's bars</param> /// <returns></returns> ! public static double GetClose( string ticker, DateTime dateTime, int intervalFrameInSeconds ) { DataTable dataTable = SqlExecutor.GetDataTable( *************** *** 136,141 **** "where " + Bars.TickerFieldName + "='" + ticker + "' and " + Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " + ! "and " + Bars.DateTimeForOpen + "=" + SQLBuilder.GetDateConstant(dateTime) ); ! return (float)dataTable.Rows[0][0]; } /// <summary> --- 136,141 ---- "where " + Bars.TickerFieldName + "='" + ticker + "' and " + Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " + ! "and " + Bars.DateTimeForOpen + "=" + SQLBuilder.GetDateTimeConstant(dateTime) ); ! return (double)dataTable.Rows[0][0]; } /// <summary> *************** *** 146,150 **** /// <param name="intervalFrameInSeconds">interval frame in seconds for the ticker's bars</param> /// <returns></returns> ! public static float GetOpen( string ticker, DateTime dateTime, int intervalFrameInSeconds ) { DataTable dataTable = SqlExecutor.GetDataTable( --- 146,150 ---- /// <param name="intervalFrameInSeconds">interval frame in seconds for the ticker's bars</param> /// <returns></returns> ! public static double GetOpen( string ticker, DateTime dateTime, int intervalFrameInSeconds ) { DataTable dataTable = SqlExecutor.GetDataTable( *************** *** 152,157 **** "where " + Bars.TickerFieldName + "='" + ticker + "' and " + Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " + ! "and " + Bars.DateTimeForOpen + "=" + SQLBuilder.GetDateConstant(dateTime) ); ! return (float)dataTable.Rows[0][0]; } --- 152,157 ---- "where " + Bars.TickerFieldName + "='" + ticker + "' and " + Bars.IntervalFrameInSeconds + "='" + intervalFrameInSeconds + "' " + ! "and " + Bars.DateTimeForOpen + "=" + SQLBuilder.GetDateTimeConstant(dateTime) ); ! return (double)dataTable.Rows[0][0]; } |