C# (CSharp) DatabaseDataAcces.getCarPart示例

示例#1

    public static HasCarPart getHasCarPart(int id)
    {
        HasCarPart hasCarPart = null;

        SqliteCommand command = new SqliteCommand("select * from has_car_part where id = @id", DatabaseConnection.connection);

        command.Parameters.Add(new SqliteParameter("@id", id));

        IDataReader reader = command.ExecuteReader();

        if (reader.Read())
        {
            hasCarPart          = new HasCarPart();
            hasCarPart.id       = reader.GetInt32(0);
            hasCarPart.playerId = reader.GetInt32(1);
            hasCarPart.carPart  = DatabaseDataAcces.getCarPart(reader.GetInt32(2));
            hasCarPart.stars    = reader.GetInt32(3);
        }

        reader.Close();

        return(hasCarPart);
    }