Exemplo n.º 1
0
        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);
            }
        }
Exemplo n.º 4
0
        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
        }
        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
        }
        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_ = 
        }