Self-consistent theory of Bose-condensed systems