コード例 #1
0
        /// <summary>
        /// Example of 2 SELECT.
        /// </summary>
        /// <param name="customerId">The cutomer ID.</param>
        private async Task SelectCustomerAndOrderLogAsync(int customerId)
        {
            // Display the created Customer:
            string sql = "select customer_id, fname, lname from customer "
                         + " where customer_id = @customer_id";

            AceQLCommand command = new AceQLCommand(sql, connection);

            command.Parameters.AddWithValue("@customer_id", customerId);

            using (AceQLDataReader dataReader = await command.ExecuteReaderAsync())
            {
                while (dataReader.Read())
                {
                    int    i           = 0;
                    int    customerId2 = dataReader.GetInt32(i++);
                    string fname       = dataReader.GetString(i++);
                    string lname       = dataReader.GetString(i++);

                    AceQLConsole.WriteLine();
                    AceQLConsole.WriteLine("customer_id : " + customerId2);
                    AceQLConsole.WriteLine("fname       : " + fname);
                    AceQLConsole.WriteLine("lname       : " + lname);
                }
            }

            sql = "select * from orderlog where customer_id = @customer_id and item_id = @item_id ";

            command = new AceQLCommand(sql, connection);
            command.Parameters.AddWithValue("@customer_id", customerId);
            command.Parameters.AddWithValue("@item_id", customerId);

            using (AceQLDataReader dataReader = await command.ExecuteReaderAsync())
            {
                while (dataReader.Read())
                {
                    int i           = 0;
                    int customerId2 = dataReader.GetInt32(i++);
                    int itemId2     = dataReader.GetInt32(i++);

                    string  description = dataReader.GetString(i++);
                    Decimal costPrice   = dataReader.GetDecimal(i++);

                    DateTime datePlaced  = dataReader.GetDateTime(i++).Date;
                    DateTime dateShipped = dataReader.GetDateTime(i++);

                    Stream stream = await dataReader.GetStreamAsync(i ++); // null stream

                    bool is_delivered = dataReader.GetInt32(i++) == 1 ? true : false;
                    int  quantity     = dataReader.GetInt32(i++);

                    AceQLConsole.WriteLine("customer_id : " + customerId2);
                    AceQLConsole.WriteLine("item_id     : " + itemId2);
                    AceQLConsole.WriteLine("description : " + description);
                    AceQLConsole.WriteLine("cost_price  : " + costPrice);
                    AceQLConsole.WriteLine("date_placed : " + datePlaced.Date);
                    AceQLConsole.WriteLine("date_shipped: " + dateShipped);
                    AceQLConsole.WriteLine("is_delivered: " + is_delivered);
                    AceQLConsole.WriteLine("quantity    : " + quantity);
                }
            }
        }