/* 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); } }
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; }
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; }