public void bookingPL() { POSITION_PL_Table_DAO dao = new POSITION_PL_Table_DAO(); dao.TRADE_ID_ = this.tradeID_; dao.BOOK_PRICE_ = this.bookValue_; dao.insert(DataBaseConnectManager.ConnectionFactory("myDB")); //dao.TOTAL_EVAL_PL_ = }
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(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 loadBookingInfo() { POSITION_PL_Table_DAO dao = new POSITION_PL_Table_DAO(); dao.KeyColumn_ = this.tradeID_; dao.select(DataBaseConnectManager.ConnectionFactory("myDB")); #region setFromDao this.BookValue_ = dao.BOOK_PRICE_; #endregion }