From Trojan Horses to Castle Walls: Unveiling Bilateral Backdoor Effects in Diffusion Models