update t_tctb_draft_main set fdeadline ='aysb' where ftemplatetype in ('draft_zzsybnsr','draft_zzsxgmnsr','draft_zzsybnsr_ybhz','draft_qysdsjb','draft_zzsybnsr_sjjt','draft_zzsybnsr_ybhz_sjjt','draft_zzsybnsr_hz_zjg_sjjt','draft_zzsxgmnsr_sjjt','draft_zzsybnsr_yz_zjg_sjjt','draft_zzsybnsr_yz_zjg','draft_zzsybnsr_hz_zjg') and (fdeadline is NULL or fdeadline=' ') and MONTH(fstartdate)=MONTH(fenddate) ;
update t_tctb_draft_main set fdeadline ='ajsb' where ftemplatetype in ('draft_zzsybnsr','draft_zzsxgmnsr','draft_zzsybnsr_ybhz','draft_qysdsjb','draft_zzsybnsr_sjjt','draft_zzsybnsr_ybhz_sjjt','draft_zzsybnsr_hz_zjg_sjjt','draft_zzsxgmnsr_sjjt','draft_zzsybnsr_yz_zjg_sjjt','draft_zzsybnsr_yz_zjg','draft_zzsybnsr_hz_zjg') and (fdeadline is NULL or fdeadline=' ') and MONTH(fstartdate)=MONTH(fenddate)-2;

