コード例 #1
0
        public KospiFutureSpreadInfo GetKospiFutureSpreadInfo()
        {
            KospiFutureSpreadInfo kfsi = new KospiFutureSpreadInfo();

            kfsi.FutureCode1 = KospiFutureUtil.Ins().KFI.Code;
            kfsi.FutureCode2 = KospiFutureUtil.Ins().KFI2.Code;

            kfsi.Code = String.Format("401{0}{1}S", kfsi.FutureCode1.Substring(3, 2), kfsi.FutureCode2.Substring(3, 2));

            return kfsi;
        }
コード例 #2
0
 public void SetFutureSpreadInfo(KospiFutureSpreadInfo kfsi)
 {
     this.KFSI = kfsi;
 }
コード例 #3
0
ファイル: Program.cs プロジェクト: HongSeokHwan/legacy
        void InsertFutureSpreadInfo(KospiFutureSpreadInfo data)
        {
            DBManager dbManager = new DBManager();
            MySqlConnection con = null;

            try
            {
                String ip = IP;
                con = dbManager.CreateConnection(ip, CommonConst.DATABASE_MADVIPER);
                con.Open();

                String query_template = String.Format("insert into kospi_future_spread_info ({0}) values ({1})",
                    "code, future_1, future_2",
                    "'{0}', '{1}', '{2}'");

                String query = String.Format(
                    query_template,
                    data.Code,
                    data.FutureCode1,
                    data.FutureCode2);

                logger.Debug(query);

                MySqlCommand cmd = new MySqlCommand(query, con);
                int ret = cmd.ExecuteNonQuery();
                if (ret <= 0)
                {
                    logger.Warn(String.Format("Query: ({0})", query));
                }
            }
            catch (System.Exception ex)
            {
                logger.Warn(ex.ToString());
            }
            finally
            {
                dbManager.Close(con);
            }
        }