A Chinese businessman, described as a "close confidant" of the Duke of York, has lost an appeal against a decision to bar him from entering the UK on national security grounds.