public static void insert_ticker(string result, string pair)
{
StringBuilder sb = new StringBuilder();
BsonDocument doc = MongoHelper.get_doc_from_str(result);
BtcHelper.insert_ticker("btcchina", pair, doc["ticker"]["last"].ToString(), doc["ticker"]["sell"].ToString(), doc["ticker"]["buy"].ToString(), doc["ticker"]["high"].ToString(), doc["ticker"]["low"].ToString(), doc["ticker"]["vol"].ToString(), doc["ticker"]["date"].ToString() + "000");
}
public static void insert_trade(string result, string pair)
{
StringBuilder sb = new StringBuilder();
BsonArray list = MongoHelper.get_array_from_str(result);
BsonArray sell = new BsonArray();
BsonArray buy = new BsonArray();
for (int i = 0; i < list.Count; i++)
{
BsonDocument doc_item = new BsonDocument();
doc_item["id"] = list[i]["tid"].ToString();
doc_item["time"] = list[i]["date"].ToString();
doc_item["price"] = list[i]["price"].ToString();
doc_item["qty"] = list[i]["amount"].ToString();
if (list[i]["type"].ToString() == "sell")
{
sell.Add(doc_item);
}
if (list[i]["type"].ToString() == "buy")
{
buy.Add(doc_item);
}
}
BtcHelper.insert_trade_log("btcchina", pair, "sell", "btc", sell.ToString());
BtcHelper.insert_trade_log("btcchina", pair, "buy", "btc", buy.ToString());
}
public static void insert_ticker(string result)
{
StringBuilder sb = new StringBuilder();
BsonDocument doc = MongoHelper.get_doc_from_str(result);
BtcHelper.insert_ticker("btctrade", "btc_cny", doc["last"].ToString(), doc["sell"].ToString(), doc["buy"].ToString(), doc["high"].ToString(), doc["low"].ToString(), doc["vol"].ToString(), doc["time"].ToString() + "000");
}
public void okcoin_cn_btc_cny_trade()
{
string max_id = BtcHelper.get_trade_max_id("okcoin_cn");
string result = OkcCNApi.trade(max_id);
BsonArray list = MongoHelper.get_array_from_str(result);
for (int i = 0; i < list.Count; i++)
{
BtcHelper.insert_trade("okcoin_cn", list[i]["tid"].ToString(), list[i]["date_ms"].ToString(), list[i]["price"].ToString(), list[i]["amount"].ToString(), list[i]["type"].ToString(), "btc_cny", "btc");
}
}
public void btcchina_btc_cny_trade()
{
string max_id = BtcHelper.get_trade_max_id("btcchina");
string result = BtcchinaApi.trade_by_id(Pair.btc_cny.ToString(), max_id);
BsonArray list = MongoHelper.get_array_from_str(result);
for (int i = 0; i < list.Count; i++)
{
BtcHelper.insert_trade("btcchina", list[i]["tid"].ToString(), list[i]["date"].ToString() + "000", list[i]["price"].ToString(), list[i]["amount"].ToString(), list[i]["type"].ToString(), "btc_cny", "btc");
}
}
private void btn_test_Click(object sender, EventArgs e)
{
//this.txt_result.Text = BtceApi.trades(Pair.btc_usd.ToString());
//string max_id = BtcHelper.get_trade_max_id("btcchina");
// string result = BtcchinaApi.trade_by_id(Pair.btc_cny.ToString(), max_id);
string result = "";
StreamReader reader = new StreamReader("c:/test.txt", Encoding.Default);
result = reader.ReadToEnd();
reader.Close();
BsonArray list = MongoHelper.get_array_from_str(result);
for (int i = 0; i < list.Count; i++)
{
BtcHelper.insert_trade("btcchina", list[i]["tid"].ToString(), list[i]["date"].ToString() + "000", list[i]["price"].ToString(), list[i]["amount"].ToString(), list[i]["type"].ToString(), "btc_cny", "btc");
}
}
public static void insert_depth(string result, string pair)
{
StringBuilder sb = new StringBuilder();
BsonDocument doc = MongoHelper.get_doc_from_str(result);
BsonArray asks = doc["asks"].AsBsonArray;
BsonArray bids = doc["bids"].AsBsonArray;
BtcHelper.delete_depth("huobi", pair);
BtcHelper.insert_depth_log("huobi", pair, "sell", "btc", asks.ToString(), "");
BtcHelper.insert_depth_log("huobi", pair, "buy", "btc", bids.ToString(), "");
for (int i = 0; i < asks.Count; i++)
{
BtcHelper.insert_depth("huobi", pair, "sell", "btc", asks[i][0].ToString(), asks[i][1].ToString(), "");
}
for (int i = 0; i < bids.Count; i++)
{
BtcHelper.insert_depth("huobi", pair, "buy", "btc", bids[i][0].ToString(), bids[i][1].ToString(), "");
}
}
public void get_data_trade()
{
string max_id = BtcHelper.get_trade_max_id("btcchina");
string sql = "select * from trade_btcchina where tid={0}";
sql = string.Format(sql, max_id);
DataTable dt_temp = SQLServerHelper.get_table(sql);
sb.Append("BTCCHINA".PR(10) + dt_temp.Rows[0]["tid"].ToString().PR(15) + UnixTime.get_local_time_long(Convert.ToUInt64(dt_temp.Rows[0]["time"].ToString())).ToString("yyyy-MM-dd HH:mm:ss") + M.N);
max_id = BtcHelper.get_trade_max_id("okcoin_cn");
sql = "select * from trade_okcoin_cn where tid={0}";
sql = string.Format(sql, max_id);
dt_temp = SQLServerHelper.get_table(sql);
sb.Append("OKCOIN_CN:".PR(10) + dt_temp.Rows[0]["tid"].ToString().PR(15) + UnixTime.get_local_time_long(Convert.ToUInt64(dt_temp.Rows[0]["time"].ToString())).ToString("yyyy-MM-dd HH:mm:ss") + M.N);
this.txt_result.Text = sb.PRINT();
if (cb_btcchina_btc_cny_trade.Checked)
{
Thread thread_btcchina_btc_cny_trade = new Thread(new ThreadStart(btcchina_btc_cny_trade)); thread_btcchina_btc_cny_trade.Start();
}
if (cb_okcoin_cn_btc_cny_trade.Checked)
{
Thread thread_okcoin_cn_btc_cny_trade = new Thread(new ThreadStart(okcoin_cn_btc_cny_trade)); thread_okcoin_cn_btc_cny_trade.Start();
}
}
