예제 #1
0
        public void select(DbConnection conn)
        {
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }

            DataTable tb = new DataTable();

            this.DAOList_ = new List <OPTION_POSITION_Table_DAO>();

            DbCommand dbCommand = conn.CreateCommand();

            string selectQuery = OPTION_POSITION_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)
            {
                OPTION_POSITION_Table_DAO dao = new OPTION_POSITION_Table_DAO();

                dao.POSITIONNAME_     = item[0].ToString();
                dao.CURRPRICE_        = item[1].ToString();
                dao.PREDIFF_          = item[2].ToString();
                dao.PREDIFFRATE_      = item[3].ToString();
                dao.CURRPRICE2_       = item[4].ToString();
                dao.PREDIFF2_         = item[5].ToString();
                dao.PREDIFFRATE2_     = item[6].ToString();
                dao.TRADINGAMT_       = item[7].ToString();
                dao.IMVOL_            = item[8].ToString();
                dao.GREEK_DELTA_      = item[9].ToString();
                dao.GREEK_GAMMA_      = item[10].ToString();
                dao.GREEK_VEGA_       = item[11].ToString();
                dao.GREEK_THETA_      = item[12].ToString();
                dao.GREEK_RHO_        = item[13].ToString();
                dao.TRADINGVALUE_     = item[14].ToString();
                dao.REMAINAMT_        = item[15].ToString();
                dao.REMAINAMTPREDIFF_ = item[16].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 <OPTION_POSITION_1928_Table_DAO>();

            DbCommand dbCommand = conn.CreateCommand();

            string selectQuery = OPTION_POSITION_1928_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)
            {
                OPTION_POSITION_1928_Table_DAO dao = new OPTION_POSITION_1928_Table_DAO();

                dao.POSITIONNAME_  = item[0].ToString();
                dao.SELLBUY_       = item[1].ToString();
                dao.UNIT_          = item[2].ToString();
                dao.EVALAMT_       = item[3].ToString();
                dao.DELTA_         = item[4].ToString();
                dao.GAMMA_         = item[5].ToString();
                dao.VEGA_          = item[6].ToString();
                dao.IMVOL_         = item[7].ToString();
                dao.DELTAPOSITION_ = item[8].ToString();
                dao.TOTALRISK_     = item[9].ToString();
                dao.DELTARISK_     = item[10].ToString();
                dao.GAMMARISK_     = item[11].ToString();
                dao.VEGARISK_      = item[12].ToString();
                dao.DEEPOTM_       = item[13].ToString();
                dao.REMAINDAYS_    = item[14].ToString();

                this.DAOList_.Add(dao);
            }
        }