凌海更新收费员

delete bm

insert bm values('01','一站')
insert bm values('02','二站')
insert bm values('03','三站')
insert bm values('04','四站')
insert bm values('05','五站')
insert bm values('06','六站')
insert bm values('07','七站')
insert bm values('08','八站')
insert bm values('09','九站')
insert bm values('10','十站')
insert bm values('11','十一站')
insert bm values('12','十二站')
insert bm values('13','十三站')
insert bm values('14','十四站')
insert bm values('15','政府站')

delete consignee

insert consignee values('01','刘尧','','','','','','1','ly','','','','01-一站','1','','1')
insert consignee values('02','刘金飞','','','','','','1','ljf','','','','02-二站','1','','1')
insert consignee values('03','侯丽艳','','','','','','1','hly','','','','03-三站','1','','1')
insert consignee values('04','刘长乐','','','','','','1','lcl','','','','04-四站','1','','1')
insert consignee values('05','王订生','','','','','','1','wds','','','','05-五站','1','','1')
insert consignee values('06','刘宝静','','','','','','1','lbj','','','','06-六站','1','','1')
insert consignee values('07','苏赢','','','','','','1','sy','','','','07-七站','1','','1')
insert consignee values('08','黎为涛','','','','','','1','lwt','','','','08-八站','1','','1')
insert consignee values('09','苏赢','','','','','','1','sy','','','','09-九站','1','','1')
insert consignee values('10','朱秀丽','','','','','','1','zxl','','','','10-十站','1','','1')
insert consignee values('11','朱秀丽','','','','','','1','zxl','','','','11-十一站','1','','1')
insert consignee values('12','郭亮','','','','','','1','gl','','','','12-十二站','1','','1')
insert consignee values('13','郭亮','','','','','','1','gl','','','','13-十三站','1','','1')
insert consignee values('14','农电新村','','','','','','1','ndxc','','','','14-十四站','1','','1')
insert consignee values('15','刘宝静','','','','','','1','lbj','','','','15-政府站','1','','1')

delete Section

insert Section select consigneeid,name from consignee

update owereportmx set collectorid = SUBSTRING(ownerid,1,2)

update owner set collectorid = SUBSTRING(ownerid,1,2)

update paydetail set collectorid = SUBSTRING(ownerid,1,2)

update Oldowe set collectorid = SUBSTRING(ownerid,1,2)

update room set collectorid = SUBSTRING(roomidtext,1,2)

update Building set collector = SUBSTRING(BuildingId,1,2)