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