public String GetKey(String ticker, String dataType, DateTime version, String currency)
{
StringPacket sp = new StringPacket("", kParserForKey);
sp.Encode(ticker);
sp.Encode(dataType);
sp.Encode(version.ToString("yyyy-MM-dd"));
sp.Encode(currency);
return sp.GetStream();
}
protected void Page_Load(object sender, EventArgs e)
{
//172.27.105.133:8080/DataQuote.aspx?ticker=Kospi2 Index&fromDate=2000-01-01&toDate=2012-01-16
String ticker = Request.Params["ticker"];
String fromDate = Request.Params["fromDate"];
String toDate = Request.Params["toDate"];
String query = String.Format(
"select * from raw_price_data where Ticker = '{0}' and datetime >= '{1}' and datetime <= '{2}' order by DateTime",
ticker, fromDate, toDate);
DataRowCollection rows = ServerLib.DBUtil.SelectFromDB(query, ServerLib.DBConst.kMarketDataDatabase);
WriteHeader();
for (int i = 0; i < rows.Count; ++i)
{
DataRow row = rows[i];
//String ticker = Convert.ToString(row["Ticker"]);
String dateTime = Convert.ToString(row["DateTime"]);
String close = Convert.ToString(row["LastPrice"]);
String open = Convert.ToString(row["Open"]);
String high = Convert.ToString(row["High"]);
String low = Convert.ToString(row["Low"]);
StringPacket sp = new StringPacket("", ",");
sp.Encode(ticker);
sp.Encode(dateTime);
sp.Encode(open);
sp.Encode(high);
sp.Encode(low);
sp.Encode(close);
Response.Write(String.Format("{0}<br>", sp.GetStream()));
}
Response.Write("*/"); // end signal
}
void WriteHeader()
{
Response.Write("/*"); // start signal
StringPacket sp = new StringPacket("", ",");
sp.Encode("Ticker");
sp.Encode("DateTime");
sp.Encode("Open");
sp.Encode("High");
sp.Encode("Low");
sp.Encode("Close");
Response.Write(String.Format("{0}<br>", sp.GetStream()));
}
