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())); }