public Excel_yieldCurveViewModel discountCurve(DateTime refDate, string currencyCode) { //조회함 Excel_yieldCurveViewModel e_ycvm = new Excel_yieldCurveViewModel(); DISCOUNTCURVESETTING_Table_DAO dao = new DISCOUNTCURVESETTING_Table_DAO(); //dao.CURRENCY_ = cvm.CurrencyCode_; dao.KeyColumn_ = currencyCode; dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); string provider = dao.PROVIDER_; string curveCode = dao.CURVECODE_; e_ycvm.Code_ = curveCode; e_ycvm.Currency_ = currencyCode; IRCurveMarketDataLoader loader = IRCurveMarketDataLoader.CreateMarketDataLoader(provider); ObservableCollection <Excel_irCurveDataViewModel> e_ircdvmList = new ObservableCollection <Excel_irCurveDataViewModel>(); loader.load(refDate, curveCode, e_ircdvmList); foreach (var item in e_ircdvmList[0].Excel_rateDataViewModelList_) { Excel_rateDataViewModel e_rdvm = new Excel_rateDataViewModel(); e_rdvm.RateType_ = item.RateType_; e_rdvm.Tenor_ = item.Tenor_; e_rdvm.Value_ = item.Value_; e_ycvm.Excel_rateDataViewModel_.Add(e_rdvm); } e_ycvm.Excel_interpolationViewModel_ = new Excel_interpolationViewModel(); //e_ycvm.loadCurve(); return(e_ycvm); }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); this.DAOList_ = new List <DISCOUNTCURVESETTING_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = DISCOUNTCURVESETTING_Table_DAOManager.SelectQuery_; //selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_); dbCommand.CommandText = selectQuery; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; foreach (DataRow item in dr) { DISCOUNTCURVESETTING_Table_DAO dao = new DISCOUNTCURVESETTING_Table_DAO(); dao.CURRENCY_ = item[0].ToString(); dao.CURVECODE_ = item[1].ToString(); dao.PROVIDER_ = item[2].ToString(); this.DAOList_.Add(dao); } }