public override void loadDefinedSymbolFromDB() { MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager(); // equity 쪽을 죄다 로드함. daoM.KeyColumn_ = "equity".ToUpper(); daoM.KeyColumn_SYMBOL_TYPE_ = "equity".ToUpper(); try { daoM.select(DataBaseConnectManager.ConnectionFactory("myDB")); this.definedEquitySymbolList_.Clear(); foreach (var item in daoM.DAOList_) { Excel_equitySymbolViewModel esvm = new Excel_equitySymbolViewModel(); esvm.setFromDAO(item); this.definedEquitySymbolList_.Add(esvm); } } catch (Exception) { //OutputLogViewModel.addResult("index data load error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_)); } }
public override void loadDefinedSymbolFromDB() { MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager(); // ir 쪽을 죄다 로드함. daoM.KeyColumn_ = "ircurve".ToUpper(); daoM.KeyColumn_SYMBOL_TYPE_ = "ircurve".ToUpper(); try { daoM.select(DataBaseConnectManager.ConnectionFactory("myDB")); this.definedIRCurveSymbolList_.Clear(); foreach (var item in daoM.DAOList_) { Excel_irCurveSymbolViewModel eicvm = new Excel_irCurveSymbolViewModel(); eicvm.setFromDAO(item); this.definedIRCurveSymbolList_.Add(eicvm); } } catch (Exception) { //OutputLogViewModel.addResult("index data load error , code : " + code + " date : " + refDate.ToString(StringFormat.DbDateFormat_)); } }
public void loadMarketDataSymbolFromDB() { this.symbolDAOList_.Clear(); MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager(); daoM.selectAll(DataBaseConnectManager.ConnectionFactory("myDB")); foreach (var item in daoM.DAOList_) { this.symbolDAOList_.Add(item); } }
public static List <Excel_marketDataSymbol> getDefinedSymbolFiltering(string filter) { List <Excel_marketDataSymbol> symbols = new List <Excel_marketDataSymbol>(); MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager(); daoM.selectFiltering(DataBaseConnectManager.ConnectionFactory("myDB"), filter); foreach (var item in daoM.DAOList_) { Excel_marketDataSymbol e_mds = new Excel_marketDataSymbol(); e_mds.setFromDAO(item); symbols.Add(e_mds); } return(symbols); }
public static List <Excel_marketDataSymbol> getDefinedSymbolALL() { List <Excel_marketDataSymbol> symbols = new List <Excel_marketDataSymbol>(); MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager(); daoM.selectAll(DataBaseConnectManager.ConnectionFactory("myDB")); foreach (var item in daoM.DAOList_) { string underType = item.SYMBOL_TYPE_; //Excel_marketDataSymbol e_mds = Excel_loaderViewModel.CreateSymbolViewModel(underType); Excel_marketDataSymbol e_mds = new Excel_marketDataSymbol(); e_mds.setFromDAO(item); symbols.Add(e_mds); } return(symbols); }
public static List<Excel_marketDataSymbol> getDefinedSymbolFiltering(string filter) { List<Excel_marketDataSymbol> symbols = new List<Excel_marketDataSymbol>(); MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager(); daoM.selectFiltering(DataBaseConnectManager.ConnectionFactory("myDB"), filter); foreach (var item in daoM.DAOList_) { Excel_marketDataSymbol e_mds = new Excel_marketDataSymbol(); e_mds.setFromDAO(item); symbols.Add(e_mds); } return symbols; }
public static List<Excel_marketDataSymbol> getDefinedSymbolALL() { List<Excel_marketDataSymbol> symbols = new List<Excel_marketDataSymbol>(); MARKETDATA_SYMBOL_INFO_Table_DAOManager daoM = new MARKETDATA_SYMBOL_INFO_Table_DAOManager(); daoM.selectAll(DataBaseConnectManager.ConnectionFactory("myDB")); foreach (var item in daoM.DAOList_) { string underType = item.SYMBOL_TYPE_; //Excel_marketDataSymbol e_mds = Excel_loaderViewModel.CreateSymbolViewModel(underType); Excel_marketDataSymbol e_mds = new Excel_marketDataSymbol(); e_mds.setFromDAO(item); symbols.Add(e_mds); } return symbols; }