Wow, talk about co-dependant!
You really need to focus on yourself. When you ask him to stop drinking, I'm sure he feels exactly the way you feel about being affectionate towards him. Are you really expecting him to make you happy? You have to make yourself happy. If you can't be happy living with someone who drinks, then just explain that to him and make plans to leave. An alcoholic MUST quit for him or herself or it will NEVER stick.