营销平台虚拟数据添加

--修改线路的配送部门
--update mmsdelivercir a set a.orgid=(select old_dept_code from dc_dept@lk_sjck where dept_type='0206' and old_up_dept_code=a.corpid)

--添加区公司虚拟客户经理
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900001,100096,'桥口虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900002,100091,'汉阳虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900003,100031,'江岸虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900004,100067,'江汉虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900005,100100,'青山虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900006,100073,'洪山虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900007,100080,'武昌虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900008,100037,'江夏虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900009,100046,'新洲虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900010,100042,'东西湖虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900011,100055,'汉南虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900012,100086,'蔡甸虚拟客户经理',12,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(6900013,100058,'黄陂虚拟客户经理',12,1);

insert into employee(userid,employeenum,modifiedby) values(6900001,6900001,1);
insert into employee(userid,employeenum,modifiedby) values(6900002,6900002,1);
insert into employee(userid,employeenum,modifiedby) values(6900003,6900003,1);
insert into employee(userid,employeenum,modifiedby) values(6900004,6900004,1);
insert into employee(userid,employeenum,modifiedby) values(6900005,6900005,1);
insert into employee(userid,employeenum,modifiedby) values(6900006,6900006,1);
insert into employee(userid,employeenum,modifiedby) values(6900007,6900007,1);
insert into employee(userid,employeenum,modifiedby) values(6900008,6900008,1);
insert into employee(userid,employeenum,modifiedby) values(6900009,6900009,1);
insert into employee(userid,employeenum,modifiedby) values(6900010,6900010,1);
insert into employee(userid,employeenum,modifiedby) values(6900011,6900011,1);
insert into employee(userid,employeenum,modifiedby) values(6900012,6900012,1);
insert into employee(userid,employeenum,modifiedby) values(6900013,6900013,1);

--添加区公司虚拟送货员
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900001,100122,'桥口虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900002,100123,'汉阳虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900003,100124,'江岸虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900004,100125,'江汉虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900005,100126,'青山虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900006,100127,'洪山虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900007,100128,'武昌虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900008,100129,'江夏虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900009,100130,'新洲虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900010,100131,'东西湖虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900011,100132,'汉南虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900012,100133,'蔡甸虚拟送货员',27,1);
insert into kenoahuser(userid,homebizentityid,fullname,jobpositionid,creatorid) values(5900013,100134,'黄陂虚拟送货员',27,1);

insert into employee(userid,employeenum,modifiedby) values(5900001,5900001,1);
insert into employee(userid,employeenum,modifiedby) values(5900002,5900002,1);
insert into employee(userid,employeenum,modifiedby) values(5900003,5900003,1);
insert into employee(userid,employeenum,modifiedby) values(5900004,5900004,1);
insert into employee(userid,employeenum,modifiedby) values(5900005,5900005,1);
insert into employee(userid,employeenum,modifiedby) values(5900006,5900006,1);
insert into employee(userid,employeenum,modifiedby) values(5900007,5900007,1);
insert into employee(userid,employeenum,modifiedby) values(5900008,5900008,1);
insert into employee(userid,employeenum,modifiedby) values(5900009,5900009,1);
insert into employee(userid,employeenum,modifiedby) values(5900010,5900010,1);
insert into employee(userid,employeenum,modifiedby) values(5900011,5900011,1);
insert into employee(userid,employeenum,modifiedby) values(5900012,5900012,1);
insert into employee(userid,employeenum,modifiedby) values(5900013,5900013,1);

--添加区公司虚拟送货线路
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000001,100005,100122,9000001,5900001,'桥口虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000002,100006,100123,9000002,5900002,'汉阳虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000003,100003,100124,9000003,5900003,'江岸虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000004,100004,100125,9000004,5900004,'江汉虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000005,100008,100126,9000005,5900005,'青山虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000006,100009,100127,9000006,5900006,'洪山虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000007,100007,100128,9000007,5900007,'武昌虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000008,100013,100129,9000008,5900008,'江夏虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000009,100015,100130,9000009,5900009,'新洲虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000010,100010,100131,9000010,5900010,'东西湖虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000011,100011,100132,9000011,5900011,'汉南虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000012,100012,100133,9000012,5900012,'蔡甸虚拟送货线路');
insert into mmsdelivercir(mmsdelivercirid,corpid,orgid,deliverid,employeeid,delivername) values (9000013,100014,100134,9000013,5900013,'黄陂虚拟送货线路');