private void SendDirectDb(REAL10003_Data real10003_data) { using (MySqlConnection conn = new MySqlConnection(Config.GetDbConnStr())) { string sql = @"INSERT into realtime_best_offered_and_bids ( stock_date ,stock_code ,offered_price ,bid_price ,created_at ,updated_at ) VALUES ( @현재시간 ,@종목코드 ,@최우선_매도호가 ,@최우선_매수호가 ,current_timestamp ,current_timestamp ); "; conn.Open(); MySqlCommand cmd = new MySqlCommand(sql, conn); cmd.Parameters.AddWithValue("@현재시간", real10003_data.현재시간); cmd.Parameters.AddWithValue("@종목코드", real10003_data.종목코드); cmd.Parameters.AddWithValue("@최우선_매도호가", real10003_data.최우선_매도호가); cmd.Parameters.AddWithValue("@최우선_매수호가", real10003_data.최우선_매수호가); cmd.ExecuteNonQuery(); } }
public override void ReceivedData(AxKHOpenAPILib.AxKHOpenAPI axKHOpenAPI, AxKHOpenAPILib._DKHOpenAPIEvents_OnReceiveRealDataEvent e) { /* * * [27] = (최우선)매도호가 //(0) * [28] = (최우선)매수호가 //(1) */ FileLog.PrintF(String.Format("최우선_매도호가 : {0} ==>", axKHOpenAPI.GetCommRealData(e.sRealType, 27).Trim())); //[0] FileLog.PrintF(String.Format("최우선_매수호가 : {0} ==>", axKHOpenAPI.GetCommRealData(e.sRealType, 28).Trim())); //[1] FileLog.PrintF(String.Format("종목코드 : {0} ==>", e.sRealKey.ToString().Trim())); FileLog.PrintF(String.Format("RealName : {0} ==>", e.sRealType.ToString().Trim())); FileLog.PrintF(String.Format("sRealData : {0} ==>", e.sRealData.ToString().Trim())); String 현재시간 = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); REAL10003_Data real10003_data = new REAL10003_Data(); real10003_data.현재시간 = 현재시간; real10003_data.최우선_매도호가 = Int32.Parse(axKHOpenAPI.GetCommRealData(e.sRealType, 27).Trim()); //[0] real10003_data.최우선_매수호가 = Int32.Parse(axKHOpenAPI.GetCommRealData(e.sRealType, 28).Trim()); //[1] real10003_data.종목코드 = e.sRealKey.ToString().Trim(); //[2] real10003_data.RealName = e.sRealType.ToString().Trim(); //[3] SendDirectFile(real10003_data); SendDirectDb(real10003_data); }
private void SendDirectFile(REAL10003_Data real10003_data) { String tmp = "{0}|{1}|{2}|{3}|{4}"; String tmp1 = String.Format(tmp, real10003_data.현재시간, real10003_data.종목코드, real10003_data.최우선_매도호가, real10003_data.최우선_매수호가, real10003_data.RealName ); System.IO.StreamWriter file = new System.IO.StreamWriter(Config.GetPath() + "\\주식우선호가.txt", true); file.WriteLine(tmp1.ToString()); file.Close(); }