public void select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
conn.Open();
DataTable tb = new DataTable();
this.DAOList_ = new List<OTC_TD_MRSTOCKFACTORVOL_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = OTC_TD_MRSTOCKFACTORVOL_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)
{
OTC_TD_MRSTOCKFACTORVOL_Table_DAO dao = new OTC_TD_MRSTOCKFACTORVOL_Table_DAO();
dao.STD_DATE_ = item[0].ToString();
dao.KR_CODE_ = item[1].ToString();
dao.STOCK_ID_ = item[2].ToString();
dao.VOL_ = item[3].ToString();
dao.QUANTO_VOL_ = item[4].ToString();
dao.QUANTO_RHO_ = item[5].ToString();
this.DAOList_.Add(dao);
}
}
public override string value(DateTime dateTime, Excel_instrumentViewModel e_instVM, Excel_underlyingInfoViewModel excel_uivm)
{
OTC_TD_MRSTOCKFACTORVOL_Table_DAO dao = new OTC_TD_MRSTOCKFACTORVOL_Table_DAO();
dao.STD_DATE_ = StringConverter.dbDateTimeToDateString(dateTime);
dao.STOCK_ID_ = excel_uivm.KrCode_;
dao.KR_CODE_ = e_instVM.MasterInformationViewModel_.Export_itemcode_;
string sql = dao.select_date_code_id(DataBaseConnectManager.ConnectionFactory("MRO"));
if (dao.STOCK_ID_ == "KR7060980000")
{
dao.VOL_ = "0.33";
}
//SQL_Logger.addLog(sql);
return(dao.VOL_);
}
public void select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
DataTable tb = new DataTable();
this.DAOList_ = new List <OTC_TD_MRSTOCKFACTORVOL_Table_DAO>();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = OTC_TD_MRSTOCKFACTORVOL_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)
{
OTC_TD_MRSTOCKFACTORVOL_Table_DAO dao = new OTC_TD_MRSTOCKFACTORVOL_Table_DAO();
dao.STD_DATE_ = item[0].ToString();
dao.KR_CODE_ = item[1].ToString();
dao.STOCK_ID_ = item[2].ToString();
dao.VOL_ = item[3].ToString();
dao.QUANTO_VOL_ = item[4].ToString();
dao.QUANTO_RHO_ = item[5].ToString();
this.DAOList_.Add(dao);
}
}
public override string value(DateTime dateTime, Excel_instrumentViewModel e_instVM, Excel_underlyingInfoViewModel excel_uivm)
{
OTC_TD_MRSTOCKFACTORVOL_Table_DAO dao = new OTC_TD_MRSTOCKFACTORVOL_Table_DAO();
dao.STD_DATE_ = StringConverter.dbDateTimeToDateString(dateTime);
dao.STOCK_ID_ = excel_uivm.KrCode_;
dao.KR_CODE_ = e_instVM.MasterInformationViewModel_.Export_itemcode_;
string sql = dao.select_date_code_id(DataBaseConnectManager.ConnectionFactory("MRO"));
if (dao.STOCK_ID_ == "KR7060980000")
{
dao.VOL_ = "0.33";
}
//SQL_Logger.addLog(sql);
return dao.VOL_;
}
