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