An alleged Chinese spy described as a “close confidant” of Prince Andrew has lost an appeal against a decision to ban him from the UK on national security grounds.