public void selectNAME_KOR(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } try { DataTable tb = new DataTable(); DbCommand dbCommand = conn.CreateCommand(); string selectNAME_KORQuery = MARKETDATA_SYMBOL_INFO_Table_DAO.SelectNAME_KORQuery_; selectNAME_KORQuery = selectNAME_KORQuery.Replace("@NAME_KORValue@", this.NAME_KOR_); dbCommand.CommandText = selectNAME_KORQuery; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; if (!(rowCount == 0 || rowCount == 1)) { throw new Exception(); } foreach (DataRow item in dr) { this.SYMBOL_ = item[0].ToString(); this.NAME_ENG_ = item[1].ToString(); this.NAME_KOR_ = item[2].ToString(); this.SYMBOL_TYPE_ = item[3].ToString(); this.PROVIDER_ = item[4].ToString(); this.DESCRIPTION_ = item[5].ToString(); this.TENOR_ = item[6].ToString(); this.SUB_TYPE_ = item[7].ToString(); this.LINKEDCURVE_ = item[8].ToString(); this.RATE_TYPE_ = item[9].ToString(); this.LEG_TENOR_ = item[10].ToString(); this.CURRENCY_ = item[11].ToString(); } conn.Close(); } catch (Exception) { conn.Close(); throw; } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } try { DataTable tb = new DataTable(); this.DAOList_ = new List <MARKETDATA_SYMBOL_INFO_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = MARKETDATA_SYMBOL_INFO_Table_DAOManager.SelectQuery_; selectQuery = selectQuery.Replace("@SYMBOL_TYPEKeyColumnValue@", this.KeyColumn_SYMBOL_TYPE_); 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) { MARKETDATA_SYMBOL_INFO_Table_DAO dao = new MARKETDATA_SYMBOL_INFO_Table_DAO(); dao.SYMBOL_ = item[0].ToString(); dao.NAME_ENG_ = item[1].ToString(); dao.NAME_KOR_ = item[2].ToString(); dao.SYMBOL_TYPE_ = item[3].ToString(); dao.PROVIDER_ = item[4].ToString(); dao.DESCRIPTION_ = item[5].ToString(); dao.TENOR_ = item[6].ToString(); dao.SUB_TYPE_ = item[7].ToString(); dao.LINKEDCURVE_ = item[8].ToString(); dao.RATE_TYPE_ = item[9].ToString(); dao.LEG_TENOR_ = item[10].ToString(); dao.CURRENCY_ = item[11].ToString(); this.DAOList_.Add(dao); } conn.Close(); } catch (Exception) { conn.Close(); } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); this.DAOList_ = new List <TD_MRCURVE_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = TD_MRCURVE_Table_DAOManager.SelectQuery_; selectQuery = selectQuery.Replace("@KeyColumn_RefDateValue@", this.KeyColumn_RefDate_); selectQuery = selectQuery.Replace("@KeyColumn_CurveCodeValue@", this.KeyColumn_CurveCode_); 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) { TD_MRCURVE_Table_DAO dao = new TD_MRCURVE_Table_DAO(); dao.STD_DATE_ = item[0].ToString(); dao.CURVE_CODE_ = item[1].ToString(); dao.BOND_CLASS_ID_ = item[2].ToString(); dao.D001_ = item[3].ToString(); dao.M003_ = item[4].ToString(); dao.M006_ = item[5].ToString(); dao.M009_ = item[6].ToString(); dao.M012_ = item[7].ToString(); dao.M018_ = item[8].ToString(); dao.M024_ = item[9].ToString(); dao.M030_ = item[10].ToString(); dao.M036_ = item[11].ToString(); dao.M048_ = item[12].ToString(); dao.M060_ = item[13].ToString(); dao.M084_ = item[14].ToString(); dao.M120_ = item[15].ToString(); dao.M180_ = item[16].ToString(); dao.M240_ = item[17].ToString(); dao.M360_ = item[18].ToString(); this.DAOList_.Add(dao); } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); this.DAOList_ = new List <EVENT_INFO_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = EVENT_INFO_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) { EVENT_INFO_Table_DAO dao = new EVENT_INFO_Table_DAO(); dao.EVENT_CODE_ = item[0].ToString(); dao.EVENT_DATE_ = item[1].ToString(); dao.EVENT_TYPE_ = item[2].ToString(); dao.EVENT_SUBTYPE_ = item[3].ToString(); dao.EVENT_NAME_ = item[4].ToString(); dao.EVENT_DESCRIPTION_ = item[5].ToString(); dao.CURRENCY_ = item[6].ToString(); dao.NOTIONAL_ = item[7].ToString(); dao.REMAIN_NOTIONAL_ = item[8].ToString(); dao.EVENT_AMOUNT_ = item[9].ToString(); dao.COUNTERPARTY_ = item[10].ToString(); dao.FLOATING_FLAG_ = item[11].ToString(); dao.CALCULATION_TYPE_ = item[12].ToString(); dao.FIXING_UNDERLYINGS_ = item[13].ToString(); dao.FIXING_OBSERVATION_ = item[14].ToString(); dao.FIXING_FLAG_ = item[15].ToString(); dao.EXPIRED_FLAG_ = item[16].ToString(); dao.ITEM_CODE_ = item[17].ToString(); dao.ITEM_TYPE_ = item[18].ToString(); dao.ITEM_NAME_ = item[19].ToString(); this.DAOList_.Add(dao); } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); this.DAOList_ = new List <MATSER_INFO_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = MATSER_INFO_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) { MATSER_INFO_Table_DAO dao = new MATSER_INFO_Table_DAO(); dao.ITEM_CODE_ = item[0].ToString(); dao.ITEM_NAME_ = item[1].ToString(); dao.NOTIONAL_ = item[2].ToString(); dao.REMAIN_NOTIONAL_ = item[3].ToString(); dao.CURRENCY_ = item[4].ToString(); dao.TRADE_DATE_ = item[5].ToString(); dao.MATURITY_DATE_ = item[6].ToString(); dao.COUNTERPARTY_ = item[7].ToString(); dao.EXPORT_ITEMCODE_ = item[8].ToString(); dao.TRADE_ID_ = item[9].ToString(); dao.TRADE_STATUS_ = item[10].ToString(); dao.INSTRUMENT_TYPE_ = item[11].ToString(); dao.UNDERLYING_TYPE_ = item[12].ToString(); dao.UNDERLYING_DETAIL_TYPE_ = item[13].ToString(); dao.CONTRACT_TYPE_ = item[14].ToString(); dao.CONTRACT_SUBTYPE_ = item[15].ToString(); dao.CONTRACT_DETAIL_TYPE_ = item[16].ToString(); dao.BOOKING_TYPE_ = item[17].ToString(); this.DAOList_.Add(dao); } }
public void selectInterval(DbConnection conn, DateTime startDate, DateTime endDate) { if (conn.State != ConnectionState.Open) { conn.Open(); } try { DataTable tb = new DataTable(); this.DAOList_ = new List <TD_MRSTOCKFACTOR_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string SelectInterValQuery_ = TD_MRSTOCKFACTOR_Table_DAOManager.SelectInterValQuery_; SelectInterValQuery_ = SelectInterValQuery_.Replace("@KeyColumnValue@", this.STOCK_ID_); SelectInterValQuery_ = SelectInterValQuery_.Replace("@StartDateValue@", startDate.ToString(StringFormat.DbDateFormat_)); SelectInterValQuery_ = SelectInterValQuery_.Replace("@EndDateValue@", endDate.ToString(StringFormat.DbDateFormat_)); //selectQuery = selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_); dbCommand.CommandText = SelectInterValQuery_; //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) { TD_MRSTOCKFACTOR_Table_DAO dao = new TD_MRSTOCKFACTOR_Table_DAO(); dao.STD_DATE_ = item[0].ToString(); dao.STOCK_ID_ = item[1].ToString(); dao.STOCK_NAME_ = item[2].ToString(); dao.CURR_PRICE_ = item[3].ToString(); dao.DIVIDEND_RATE_ = item[4].ToString(); this.DAOList_.Add(dao); } conn.Close(); } catch (Exception) { conn.Close(); throw; } }
public string select_date_code_id(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } try { DataTable tb = new DataTable(); DbCommand dbCommand = conn.CreateCommand(); string select_date_code_id_Query = OTC_TD_MRSTOCKFACTORVOL_Table_DAO.Select_date_code_id_Query_; select_date_code_id_Query = select_date_code_id_Query.Replace("@STD_DATEValue@", this.STD_DATE_); select_date_code_id_Query = select_date_code_id_Query.Replace("@KR_CODEValue@", this.KR_CODE_); select_date_code_id_Query = select_date_code_id_Query.Replace("@STOCK_IDValue@", this.STOCK_ID_); dbCommand.CommandText = select_date_code_id_Query; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; if (!(rowCount == 0 || rowCount == 1)) { throw new Exception(); } foreach (DataRow item in dr) { this.STD_DATE_ = item[0].ToString(); this.KR_CODE_ = item[1].ToString(); this.STOCK_ID_ = item[2].ToString(); this.VOL_ = item[3].ToString(); this.QUANTO_VOL_ = item[4].ToString(); this.QUANTO_RHO_ = item[5].ToString(); } conn.Close(); return(select_date_code_id_Query); } catch (Exception) { conn.Close(); throw; } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); this.DAOList_ = new List <POSITION_PL_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = POSITION_PL_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) { POSITION_PL_Table_DAO dao = new POSITION_PL_Table_DAO(); dao.ITEM_CODE_ = item[0].ToString(); dao.TRADE_ID_ = item[1].ToString(); dao.NOTIONAL_ = item[2].ToString(); dao.REMAIN_NOTIONAL_ = item[3].ToString(); dao.BOOK_PRICE_ = item[4].ToString(); dao.BOOK_NOTIONAL_ = item[5].ToString(); dao.EVAL_PRICE_ = item[6].ToString(); dao.BOOK_PL_ = item[7].ToString(); dao.TOTAL_EVAL_PL_ = item[8].ToString(); dao.DAILY_EVAL_PL_ = item[9].ToString(); dao.TRADE_PL_ = item[10].ToString(); dao.TOTAL_PL_ = item[11].ToString(); dao.ETC_PL_ = item[12].ToString(); dao.STD_DATE_ = item[13].ToString(); this.DAOList_.Add(dao); } }
public void select_date_id_otherid_Query(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } try { DataTable tb = new DataTable(); DbCommand dbCommand = conn.CreateCommand(); string select_date_id_otherid_Query = OTC_TD_MRELSSTOCKCORR_Table_DAO.Select_date_id_otherid_Query_; select_date_id_otherid_Query = select_date_id_otherid_Query.Replace("@STD_DATEValue@", this.STD_DATE_); select_date_id_otherid_Query = select_date_id_otherid_Query.Replace("@STOCK_IDValue@", this.STOCK_ID_); select_date_id_otherid_Query = select_date_id_otherid_Query.Replace("@OTHER_IDValue@", this.OTHER_ID_); dbCommand.CommandText = select_date_id_otherid_Query; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; if (!(rowCount == 0 || rowCount == 1)) { throw new Exception(); } foreach (DataRow item in dr) { this.STD_DATE_ = item[0].ToString(); this.STOCK_ID_ = item[1].ToString(); this.OTHER_ID_ = item[2].ToString(); this.CORR_ = item[3].ToString(); } conn.Close(); } catch (Exception) { conn.Close(); throw; } }
public void selectDateCurve(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } try { DataTable tb = new DataTable(); DbCommand dbCommand = conn.CreateCommand(); string selectDateCurveQuery = CURVE_DATA_Table_DAO.SelectDateCurveQuery_; selectDateCurveQuery = selectDateCurveQuery.Replace("@CURVE_DATEVALUE@", this.CURVE_DATE_); selectDateCurveQuery = selectDateCurveQuery.Replace("@CURVE_CODEVALUE@", this.CURVE_CODE_); dbCommand.CommandText = selectDateCurveQuery; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; if (!(rowCount == 0 || rowCount == 1)) { throw new Exception("unique curveCode violation "); } foreach (DataRow item in dr) { this.CURVE_DATE_ = item[0].ToString(); this.CURVE_CODE_ = item[1].ToString(); this.TENOR_ = item[2].ToString(); this.VALUE_ = item[3].ToString(); this.CURVE_TYPE_ = item[4].ToString(); } conn.Close(); } catch (Exception e) { conn.Close(); throw; } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); this.DAOList_ = new List <HOLIDAY_INFO_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = HOLIDAY_INFO_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) { HOLIDAY_INFO_Table_DAO dao = new HOLIDAY_INFO_Table_DAO(); dao.HOLIDAY_DATE_ = item[0].ToString(); dao.HOLIDAY_NAME_ = item[1].ToString(); dao.HOLIDAY_COUNTRY_NAME_ = item[2].ToString(); dao.HOLIDAY_CURRENCY_CODE_ = item[3].ToString(); dao.HOLIDAY_TYPE_ = item[4].ToString(); dao.USING_START_DATE_ = item[5].ToString(); dao.USING_END_DATE_ = item[6].ToString(); dao.DESCRIPTION_ = item[7].ToString(); this.DAOList_.Add(dao); } }
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 void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); this.DAOList_ = new List <CURVE_DATA_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = CURVE_DATA_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) { CURVE_DATA_Table_DAO dao = new CURVE_DATA_Table_DAO(); dao.CURVE_DATE_ = item[0].ToString(); dao.CURVE_CODE_ = item[1].ToString(); dao.TENOR_ = item[2].ToString(); dao.VALUE_ = item[3].ToString(); dao.CURVE_TYPE_ = item[4].ToString(); this.DAOList_.Add(dao); } }
public void selectInterval(DbConnection conn, DateTime startDate, DateTime endDate) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); this.DAOList_ = new List <INDEX_DATA_Table_DAO>(); DbCommand dbCommand = conn.CreateCommand(); string SelectInterValQuery_ = INDEX_DATA_Table_DAOManager.SelectInterValQuery_; SelectInterValQuery_ = SelectInterValQuery_.Replace("@KeyColumnValue@", this.INDEX_CODE_); SelectInterValQuery_ = SelectInterValQuery_.Replace("@StartDateValue@", startDate.ToString(StringFormat.DbDateFormat_)); SelectInterValQuery_ = SelectInterValQuery_.Replace("@EndDateValue@", endDate.ToString(StringFormat.DbDateFormat_)); dbCommand.CommandText = SelectInterValQuery_; //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) { INDEX_DATA_Table_DAO dao = new INDEX_DATA_Table_DAO(); dao.INDEX_DATE_ = item[0].ToString(); dao.INDEX_CODE_ = item[1].ToString(); dao.INDEX_NAME_ = item[2].ToString(); dao.INDEX_VALUE_ = item[3].ToString(); this.DAOList_.Add(dao); } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = INDEX_DATA_Table_DAO.SelectQuery_; selectQuery = selectQuery.Replace("@KeyColumnValue1@", this.INDEX_DATE_); selectQuery = selectQuery.Replace("@KeyColumnValue2@", this.INDEX_CODE_); 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; if (!(rowCount == 0 || rowCount == 1)) { throw new Exception(); } foreach (DataRow item in dr) { this.INDEX_DATE_ = item[0].ToString(); this.INDEX_CODE_ = item[1].ToString(); this.INDEX_NAME_ = item[2].ToString(); this.INDEX_VALUE_ = item[3].ToString(); } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = DISCOUNTCURVESETTING_Table_DAO.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; if (!(rowCount == 0 || rowCount == 1)) { throw new Exception(); } foreach (DataRow item in dr) { this.CURRENCY_ = item[0].ToString(); this.CURVECODE_ = item[1].ToString(); this.PROVIDER_ = item[2].ToString(); } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } DataTable tb = new DataTable(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = KOM_PSIT_INF_Table_DAOManager.SelectQuery_; //selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_); dbCommand.CommandText = selectQuery; //DbDataAdapter dataAdapter = new DbDataAdapter(dbCommand.CommandText, conn); DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand, conn); dataAdapter.Fill(tb); DataRow[] dr = tb.Select(); int rowCount = dr.Length; foreach (DataRow item in dr) { KOM_PSIT_INF_Table_DAO dao = new KOM_PSIT_INF_Table_DAO(); dao.BASC_DT_ = item[0].ToString(); dao.OFFC_CD_ = item[1].ToString(); dao.SEQ_NO_ = item[2].ToString(); dao.POSITION_ID_ = item[3].ToString(); dao.KR_CD_ = item[4].ToString(); dao.BCOF_ITM_NM_ = item[5].ToString(); dao.ISD_FUND_CD_ = item[6].ToString(); dao.CRPN_ID_ = item[7].ToString(); dao.CRPN_NM_ = item[8].ToString(); dao.DEAL_TYP_ = item[9].ToString(); dao.HOLD_QNT_ = item[10].ToString(); dao.BCOF_EXHG_RT_CD_ = item[11].ToString(); dao.PURT_AMT_ = item[12].ToString(); dao.ACBK_UPRC_ = item[13].ToString(); dao.FRC_ACBK_UPRC_ = item[14].ToString(); dao.MKT_UPRC_ = item[15].ToString(); dao.FRC_MKT_UPRC_ = item[16].ToString(); dao.FCVL_UNIT_ = item[17].ToString(); dao.FRC_FCVL_UNIT_ = item[18].ToString(); dao.FCVL_AMT_ = item[19].ToString(); dao.FRC_FCVL_AMT_ = item[20].ToString(); dao.ACBK_AMT_ = item[21].ToString(); dao.FRC_ACBK_AMT_ = item[22].ToString(); dao.MKT_AMT_ = item[23].ToString(); dao.FRC_MKT_AMT_ = item[24].ToString(); dao.WRNT_AMT_ = item[25].ToString(); dao.HOLD_MAX_QNT_ = item[26].ToString(); dao.FST_BUY_DT_ = item[27].ToString(); dao.BUY_UPRC_ = item[28].ToString(); dao.FST_BUY_AMT_ = item[29].ToString(); dao.FST_FRC_ACBK_AMT_ = item[30].ToString(); dao.DD_BY_ASES_LNG_ = item[31].ToString(); dao.DD_BY_INT_LNG_ = item[32].ToString(); dao.DD_BY_DEAL_LNG_ = item[33].ToString(); dao.DD_BY_DIVD_LNG_ = item[34].ToString(); dao.DD_EXP_ = item[35].ToString(); dao.ASES_LNG_ = item[36].ToString(); dao.ETC_PL_AMT_1_ = item[37].ToString(); dao.ETC_PL_AMT_2_ = item[38].ToString(); dao.ETC_PL_AMT_3_ = item[39].ToString(); dao.ETC_PL_AMT_4_ = item[40].ToString(); dao.ETC_PL_AMT_5_ = item[41].ToString(); dao.ETC_PL_AMT_6_ = item[42].ToString(); dao.ETC_PL_AMT_7_ = item[43].ToString(); dao.ETC_PL_AMT_8_ = item[44].ToString(); dao.ETC_PL_AMT_9_ = item[45].ToString(); dao.ETC_PL_AMT_10_ = item[46].ToString(); dao.ETC_PL_AMT_11_ = item[47].ToString(); dao.ETC_PL_AMT_12_ = item[48].ToString(); dao.ETC_PL_AMT_13_ = item[49].ToString(); dao.ETC_PL_AMT_14_ = item[50].ToString(); dao.ETC_PL_AMT_15_ = item[51].ToString(); dao.ETC_PL_AMT_16_ = item[52].ToString(); dao.ETC_PL_AMT_17_ = item[53].ToString(); dao.ETC_PL_AMT_18_ = item[54].ToString(); dao.ETC_PL_AMT_19_ = item[55].ToString(); dao.ETC_PL_AMT_20_ = item[56].ToString(); dao.ETC_PL_AMT_21_ = item[57].ToString(); dao.ETC_PL_AMT_22_ = item[58].ToString(); dao.ETC_PL_AMT_23_ = item[59].ToString(); dao.ETC_PL_AMT_24_ = item[60].ToString(); dao.ETC_PL_AMT_25_ = item[61].ToString(); dao.BCOF_AC_CD_1_ = item[62].ToString(); dao.BCOF_PRD_CD_1_ = item[63].ToString(); dao.BCOF_PRD_CD_2_ = item[64].ToString(); dao.BCOF_PRD_CD_3_ = item[65].ToString(); dao.CLTR_OFFR_AMT_ = item[66].ToString(); dao.CLTR_OFFR_YN_ = item[67].ToString(); dao.MKT_PRC_ASES_CD_ = item[68].ToString(); dao.OPT_EVET_YN_ = item[69].ToString(); dao.HDG_TRSC_YN_ = item[70].ToString(); dao.TST_ISS_TYP_ = item[71].ToString(); dao.USER_SET_YN_ = item[72].ToString(); dao.NOTE_ = item[73].ToString(); dao.FILE_DT_ = item[74].ToString(); dao.DB_INSERT_DT_ = item[75].ToString(); this.DAOList_.Add(dao); } }
public void select(DbConnection conn) { if (conn.State != ConnectionState.Open) { conn.Open(); } try { DataTable tb = new DataTable(); DbCommand dbCommand = conn.CreateCommand(); string selectQuery = TD_MRCURVE_Table_DAO.SelectQuery_; selectQuery = selectQuery.Replace("@KeyColumn_RefDateValue@", this.KeyColumn_RefDate_); selectQuery = selectQuery.Replace("@KeyColumn_BOND_CLASS_IDValue@", this.KeyColumn_BOND_CLASS_ID_); selectQuery = selectQuery.Replace("@KeyColumn_CURVE_CODEValue@", this.KeyColumn_CURVE_CODE_); 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; if (!(rowCount == 0 || rowCount == 1)) { throw new Exception(); } foreach (DataRow item in dr) { this.STD_DATE_ = item[0].ToString(); this.CURVE_CODE_ = item[1].ToString(); this.BOND_CLASS_ID_ = item[2].ToString(); this.D001_ = item[3].ToString(); this.M003_ = item[4].ToString(); this.M006_ = item[5].ToString(); this.M009_ = item[6].ToString(); this.M012_ = item[7].ToString(); this.M018_ = item[8].ToString(); this.M024_ = item[9].ToString(); this.M030_ = item[10].ToString(); this.M036_ = item[11].ToString(); this.M048_ = item[12].ToString(); this.M060_ = item[13].ToString(); this.M084_ = item[14].ToString(); this.M120_ = item[15].ToString(); this.M180_ = item[16].ToString(); this.M240_ = item[17].ToString(); this.M360_ = item[18].ToString(); } conn.Close(); } catch (Exception) { conn.Close(); } }