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