Пример #1
0
        /*
        public String NameToCode(String name)
        {
            if (_dictNameToCode.ContainsKey(name))
            {
                return _dictNameToCode[name];
            }

            String candidate = "";
            foreach (String keyName in _dictNameToCode.Keys)
            {
                if (keyName.StartsWith(name))
                {
                    candidate += String.Format("{0}|", keyName);
                }
            }
            return candidate;
        }
         * */
        void LoadProduct()
        {
            // 상품을 읽어온다.
            DBManager dbManager = new DBManager();
            MySqlConnection con = null;

            try
            {
                String ip = CommonConfig.DB_SERVER_IP;
                con = dbManager.CreateConnection(ip, CommonConfig.DATABASE_CORREL);
                con.Open();

                LoadProduct_Raw(con);
                //logger.Info("데이터베이스에서 상품 정보를 모두 정상적으로 읽어왔습니다.");
            }
            catch (System.Exception e)
            {
                Console.WriteLine(e.ToString());
            }
            finally
            {
                dbManager.Close(con);
            }
        }
Пример #2
0
        Boolean DBOut()
        {
            DBManager dbManager = new DBManager();
            MySqlConnection con = null;

            try
            {
                String ip = CommonConfig.DB_SERVER_IP;
                con = dbManager.CreateConnection(ip, CommonConfig.DATABASE_CORREL);
                con.Open();
                return DBOutBloombergData_Raw(con);
            }
            catch (System.Exception e)
            {
                Error(e.ToString());
            }
            finally
            {
                dbManager.Close(con);
            }
            return false;
        }
Пример #3
0
        List<String> GetSectorListFromDB()
        {
            // 상품을 읽어온다.
            DBManager dbManager = new DBManager();
            MySqlConnection con = null;

            try
            {
                String ip = CommonConfig.DB_SERVER_IP;
                con = dbManager.CreateConnection(ip, CommonConfig.DATABASE_CORREL);
                con.Open();

                return GetSectorListFromDB_Raw(con);
            }
            catch (System.Exception e)
            {
                Error(e.ToString());
            }
            finally
            {
                dbManager.Close(con);
            }
            return null;
        }