Local density theory of magnetism and its interrelation with compositional order in alloys