public void select(DbConnection conn)
{
if (conn.State != ConnectionState.Open)
conn.Open();
DataTable tb = new DataTable();
DbCommand dbCommand = conn.CreateCommand();
string selectQuery = asfasfasf_Table_DAOManager.SelectQuery_;
//selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand.CommandText, conn);
//dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
asfasfasf_Table_DAO dao = new asfasfasf_Table_DAO();
dao.STD_DATE_ = item[0].ToString();
dao.CUST_FUND_CODE_ = item[1].ToString();
dao.FIRST_BUY_DATE_ = item[2].ToString();
dao.KR_CODE_ = item[3].ToString();
dao.ITEM_NAME_ = item[4].ToString();
dao.CURRENCY_CODE_ = item[5].ToString();
dao.FACE_AMT_ = item[6].ToString();
dao.MRO_ = item[7].ToString();
dao.SIMPONY_ = item[8].ToString();
dao.DIFF_ = item[9].ToString();
dao.FIRM_NAME_ = item[10].ToString();
dao.CREDIT_GRADE_ = item[11].ToString();
dao.FIRM_ID_ = item[12].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 = asfasfasf_Table_DAOManager.SelectQuery_;
//selectQuery.Replace("@KeyColumnValue@", this.KeyColumn_);
dbCommand.CommandText = selectQuery;
//DbDataAdapter dataAdapter = DataBaseConnectManager.CreateDataAdapter(dbCommand.CommandText, conn);
//dataAdapter.Fill(tb);
DataRow[] dr = tb.Select();
int rowCount = dr.Length;
foreach (DataRow item in dr)
{
asfasfasf_Table_DAO dao = new asfasfasf_Table_DAO();
dao.STD_DATE_ = item[0].ToString();
dao.CUST_FUND_CODE_ = item[1].ToString();
dao.FIRST_BUY_DATE_ = item[2].ToString();
dao.KR_CODE_ = item[3].ToString();
dao.ITEM_NAME_ = item[4].ToString();
dao.CURRENCY_CODE_ = item[5].ToString();
dao.FACE_AMT_ = item[6].ToString();
dao.MRO_ = item[7].ToString();
dao.SIMPONY_ = item[8].ToString();
dao.DIFF_ = item[9].ToString();
dao.FIRM_NAME_ = item[10].ToString();
dao.CREDIT_GRADE_ = item[11].ToString();
dao.FIRM_ID_ = item[12].ToString();
this.DAOList_.Add(dao);
}
}
