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