So sorry to hear about your dog, I had to watch my healthy and robust 4 year old boxer slowly succumb to cancer a few years ago and I can imagine how hard it would be now while undergoing treatment.
Vets can do amazing things with pain management to keep them comfortable. Good luck.