C# (CSharp) TradingDAO.Get_N_BookNumByStatus示例

示例#1

        protected void Page_Load(object sender, EventArgs e)
        {
            // get total number of users
            UserDAO userDao = new UserDAO();

            UserNum = userDao.GetRowCount();

            // get total pending books
            BookDAO bookDao = new BookDAO();

            TotalPendings = bookDao.GetRowCountBookByStatus(Book.STATUS_PENDING);
            TotalAccepted = bookDao.GetRowCountBookByStatus(Book.STATUS_ACCEPTED);

            // get number of lastest avaible tradings
            TradingDAO tradingDao = new TradingDAO(5);

            N_LastestAvailableTradings = tradingDao.Get_N_BookNumByStatus(tradingNum, Trading.STATUS_AVAILABLE);

            // get list of Lastest Tradings
            LastestCompletedTradings = tradingDao.GetTradingByCommand("select top 5 * from Trading order by (completedTime) desc");
            foreach (Trading trading in LastestCompletedTradings)
            {
                Lenders.Add(userDao.GetById(trading.LenderID));
                Borrowers.Add(userDao.GetById(trading.BorrowerID));
                Books.Add(bookDao.GetById(trading.BookID));
            }

            // set status
        }