superdesk_superservice/sql/longmeizhen/修改部门.sql

-- 添加部门
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('人力资源部', '人事部', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('商务发展部', '', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('市场拓展部', '市场部', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('战略与投资管理部', '战略部', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('财务部航都4楼', '财务部(航都)', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('运营管理部', '运营部', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('专家委员会', '专家委', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('纪检审计监察部', '审计部', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('公司总经理助理、专务', '', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('公司领导', '', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('党群工作部、行政管理部', '行政部', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('协同地产事业部', '协同', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('中航智泊', '', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('总经办', '', '1',SYSDATE(),'615','1012','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('品牌部', '', '1',SYSDATE(),'615','1012','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('运营部', '', '1',SYSDATE(),'615','1012','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('大客户服务部', '', '1',SYSDATE(),'615','1012','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('IT部', '', '1',SYSDATE(),'615','1012','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('行政/人事', '', '1',SYSDATE(),'615','1012','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('1214', '', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('商务发展部飞亚达8楼', '商务部(飞亚达)', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('商务发展部航都4楼', '商务部(航都)', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('高校事业部', '', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('保安公司', '', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('财务部飞亚达9楼', '财务部(飞亚达)', '1',SYSDATE(),'626','1509','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('客服部', '', '1',SYSDATE(),'645','2039','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('会务部', '', '1',SYSDATE(),'645','2039','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('安管部', '', '1',SYSDATE(),'645','2039','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('工程部', '', '1',SYSDATE(),'645','2039','1');
INSERT INTO tb_department (name, shortName, creator, createTime,orgId, virId,isEnabled) VALUES ('保洁部', '', '1',SYSDATE(),'645','2039','1');

-- 南昌
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('环境部', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('财务部', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('总经办', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('商务发展部', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('运营部', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('其他项目', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('人力资源部', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('工程部', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('公司领导', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('保安公司', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('安管部', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('市场拓展部', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('IT部', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('行政/人事', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('餐饮公司', '1',SYSDATE(),'649','1511','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('工程部', '1',SYSDATE(),'649','2000','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('财务部', '1',SYSDATE(),'649','2000','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('行政/人事', '1',SYSDATE(),'649','2000','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('运营部', '1',SYSDATE(),'649','2000','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','2001','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','2002','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','2003','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('品牌部', '1',SYSDATE(),'649','2004','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('市场拓展部', '1',SYSDATE(),'649','2004','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('运营管理部', '1',SYSDATE(),'649','2004','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('财务部', '1',SYSDATE(),'649','2004','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('行政/人事', '1',SYSDATE(),'649','2004','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('公司领导', '1',SYSDATE(),'649','2005','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('市场拓展部', '1',SYSDATE(),'649','2005','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','2006','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2007','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','2008','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','2009','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('总经办', '1',SYSDATE(),'649','2010','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('运营部', '1',SYSDATE(),'649','2010','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('工程部', '1',SYSDATE(),'649','2010','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('财务部', '1',SYSDATE(),'649','2010','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('品牌部', '1',SYSDATE(),'649','2010','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('行政/人事', '1',SYSDATE(),'649','2010','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','2011','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','2012','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2012','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','2013','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','2014','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('南昌中航国际广场', '1',SYSDATE(),'649','2015','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('财务部', '1',SYSDATE(),'649','2016','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2016','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('工程部', '1',SYSDATE(),'649','2016','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('市场拓展部', '1',SYSDATE(),'649','2017','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2018','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2019','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2020','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2021','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2022','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('行政/人事', '1',SYSDATE(),'649','2022','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('财务部', '1',SYSDATE(),'649','2022','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2023','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('运营部', '1',SYSDATE(),'649','2024','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2025','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('行政/人事', '1',SYSDATE(),'649','2025','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('市场拓展部', '1',SYSDATE(),'649','2025','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2026','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2027','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('市场拓展部', '1',SYSDATE(),'649','2027','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('行政/人事', '1',SYSDATE(),'649','2027','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('总经办', '1',SYSDATE(),'649','2027','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2028','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2029','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2030','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2031','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2032','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2033','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('工程部', '1',SYSDATE(),'649','2034','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('财务部', '1',SYSDATE(),'649','2034','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('总经办', '1',SYSDATE(),'649','2034','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('运营部', '1',SYSDATE(),'649','2034','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2034','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2035','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2036','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2037','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('总经办', '1',SYSDATE(),'649','2040','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('行政/人事', '1',SYSDATE(),'649','2040','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2040','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('财务部', '1',SYSDATE(),'649','2040','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2041','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2042','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2043','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2044','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('行政/人事', '1',SYSDATE(),'649','2044','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('总经办', '1',SYSDATE(),'649','2044','1');
INSERT INTO tb_department (name,creator, createTime,orgId, virId,isEnabled) VALUES ('综合部', '1',SYSDATE(),'649','2045','1');

-- 修改部门
update tb_user set departmentId=31 where departmentId=398 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=32 where departmentId=408 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=33 where departmentId=432 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=34 where departmentId=380 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=35 where departmentId=337 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=36 where departmentId=382 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=37 where departmentId=433 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=38 where departmentId=336 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=39 where departmentId=406 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=40 where departmentId=374 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=41 where departmentId=423 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=42 where departmentId=407 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=43 where departmentId=338 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=44 where departmentId=384 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=45 where departmentId=409 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=46 where departmentId=385 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=47 where departmentId=425 and organizationId=649 and virtualArchId=1511;
update tb_user set departmentId=48 where departmentId=406 and organizationId=649 and virtualArchId=2000;
update tb_user set departmentId=49 where departmentId=432 and organizationId=649 and virtualArchId=2000;
update tb_user set departmentId=50 where departmentId=385 and organizationId=649 and virtualArchId=2000;
update tb_user set departmentId=51 where departmentId=382 and organizationId=649 and virtualArchId=2000;
update tb_user set departmentId=52 where departmentId=398 and organizationId=649 and virtualArchId=2001;
update tb_user set departmentId=53 where departmentId=398 and organizationId=649 and virtualArchId=2002;
update tb_user set departmentId=54 where departmentId=398 and organizationId=649 and virtualArchId=2003;
update tb_user set departmentId=55 where departmentId=381 and organizationId=649 and virtualArchId=2004;
update tb_user set departmentId=56 where departmentId=338 and organizationId=649 and virtualArchId=2004;
update tb_user set departmentId=57 where departmentId=341 and organizationId=649 and virtualArchId=2004;
update tb_user set departmentId=58 where departmentId=432 and organizationId=649 and virtualArchId=2004;
update tb_user set departmentId=59 where departmentId=385 and organizationId=649 and virtualArchId=2004;
update tb_user set departmentId=60 where departmentId=374 and organizationId=649 and virtualArchId=2005;
update tb_user set departmentId=61 where departmentId=338 and organizationId=649 and virtualArchId=2005;
update tb_user set departmentId=62 where departmentId=398 and organizationId=649 and virtualArchId=2006;
update tb_user set departmentId=63 where departmentId=409 and organizationId=649 and virtualArchId=2007;
update tb_user set departmentId=64 where departmentId=398 and organizationId=649 and virtualArchId=2008;
update tb_user set departmentId=65 where departmentId=398 and organizationId=649 and virtualArchId=2009;
update tb_user set departmentId=66 where departmentId=380 and organizationId=649 and virtualArchId=2010;
update tb_user set departmentId=67 where departmentId=382 and organizationId=649 and virtualArchId=2010;
update tb_user set departmentId=68 where departmentId=406 and organizationId=649 and virtualArchId=2010;
update tb_user set departmentId=69 where departmentId=432 and organizationId=649 and virtualArchId=2010;
update tb_user set departmentId=70 where departmentId=381 and organizationId=649 and virtualArchId=2010;
update tb_user set departmentId=71 where departmentId=385 and organizationId=649 and virtualArchId=2010;
update tb_user set departmentId=72 where departmentId=398 and organizationId=649 and virtualArchId=2011;
update tb_user set departmentId=73 where departmentId=398 and organizationId=649 and virtualArchId=2012;
update tb_user set departmentId=74 where departmentId=409 and organizationId=649 and virtualArchId=2012;
update tb_user set departmentId=75 where departmentId=398 and organizationId=649 and virtualArchId=2013;
update tb_user set departmentId=76 where departmentId=398 and organizationId=649 and virtualArchId=2014;
update tb_user set departmentId=77 where departmentId=398 and organizationId=649 and virtualArchId=2015;
update tb_user set departmentId=78 where departmentId=432 and organizationId=649 and virtualArchId=2016;
update tb_user set departmentId=79 where departmentId=409 and organizationId=649 and virtualArchId=2016;
update tb_user set departmentId=80 where departmentId=406 and organizationId=649 and virtualArchId=2016;
update tb_user set departmentId=81 where departmentId=338 and organizationId=649 and virtualArchId=2017;
update tb_user set departmentId=82 where departmentId=409 and organizationId=649 and virtualArchId=2018;
update tb_user set departmentId=83 where departmentId=409 and organizationId=649 and virtualArchId=2019;
update tb_user set departmentId=84 where departmentId=409 and organizationId=649 and virtualArchId=2020;
update tb_user set departmentId=85 where departmentId=409 and organizationId=649 and virtualArchId=2021;
update tb_user set departmentId=86 where departmentId=409 and organizationId=649 and virtualArchId=2022;
update tb_user set departmentId=87 where departmentId=385 and organizationId=649 and virtualArchId=2022;
update tb_user set departmentId=88 where departmentId=432 and organizationId=649 and virtualArchId=2022;
update tb_user set departmentId=89 where departmentId=409 and organizationId=649 and virtualArchId=2023;
update tb_user set departmentId=90 where departmentId=382 and organizationId=649 and virtualArchId=2024;
update tb_user set departmentId=91 where departmentId=409 and organizationId=649 and virtualArchId=2025;
update tb_user set departmentId=92 where departmentId=385 and organizationId=649 and virtualArchId=2025;
update tb_user set departmentId=93 where departmentId=338 and organizationId=649 and virtualArchId=2025;
update tb_user set departmentId=94 where departmentId=409 and organizationId=649 and virtualArchId=2026;
update tb_user set departmentId=95 where departmentId=409 and organizationId=649 and virtualArchId=2027;
update tb_user set departmentId=96 where departmentId=338 and organizationId=649 and virtualArchId=2027;
update tb_user set departmentId=97 where departmentId=385 and organizationId=649 and virtualArchId=2027;
update tb_user set departmentId=98 where departmentId=380 and organizationId=649 and virtualArchId=2027;
update tb_user set departmentId=99 where departmentId=409 and organizationId=649 and virtualArchId=2028;
update tb_user set departmentId=100 where departmentId=409 and organizationId=649 and virtualArchId=2029;
update tb_user set departmentId=101 where departmentId=409 and organizationId=649 and virtualArchId=2030;
update tb_user set departmentId=102 where departmentId=409 and organizationId=649 and virtualArchId=2031;
update tb_user set departmentId=103 where departmentId=409 and organizationId=649 and virtualArchId=2032;
update tb_user set departmentId=104 where departmentId=409 and organizationId=649 and virtualArchId=2033;
update tb_user set departmentId=105 where departmentId=406 and organizationId=649 and virtualArchId=2034;
update tb_user set departmentId=106 where departmentId=432 and organizationId=649 and virtualArchId=2034;
update tb_user set departmentId=107 where departmentId=380 and organizationId=649 and virtualArchId=2034;
update tb_user set departmentId=108 where departmentId=382 and organizationId=649 and virtualArchId=2034;
update tb_user set departmentId=109 where departmentId=409 and organizationId=649 and virtualArchId=2034;
update tb_user set departmentId=110 where departmentId=409 and organizationId=649 and virtualArchId=2035;
update tb_user set departmentId=111 where departmentId=409 and organizationId=649 and virtualArchId=2036;
update tb_user set departmentId=112 where departmentId=409 and organizationId=649 and virtualArchId=2037;
update tb_user set departmentId=113 where departmentId=380 and organizationId=649 and virtualArchId=2040;
update tb_user set departmentId=114 where departmentId=385 and organizationId=649 and virtualArchId=2040;
update tb_user set departmentId=115 where departmentId=409 and organizationId=649 and virtualArchId=2040;
update tb_user set departmentId=116 where departmentId=432 and organizationId=649 and virtualArchId=2040;
update tb_user set departmentId=117 where departmentId=409 and organizationId=649 and virtualArchId=2041;
update tb_user set departmentId=118 where departmentId=409 and organizationId=649 and virtualArchId=2042;
update tb_user set departmentId=119 where departmentId=409 and organizationId=649 and virtualArchId=2043;
update tb_user set departmentId=120 where departmentId=409 and organizationId=649 and virtualArchId=2044;
update tb_user set departmentId=121 where departmentId=385 and organizationId=649 and virtualArchId=2044;
update tb_user set departmentId=122 where departmentId=380 and organizationId=649 and virtualArchId=2044;
update tb_user set departmentId=123 where departmentId=409 and organizationId=649 and virtualArchId=2045;

update tb_user set departmentId=30    where departmentId=439;
update tb_user set departmentId=29    where departmentId=438;
update tb_user set departmentId=28    where departmentId=437;
update tb_user set departmentId=27    where departmentId=436;
update tb_user set departmentId=26    where departmentId=435;
update tb_user set departmentId=25    where departmentId=430;
update tb_user set departmentId=24    where departmentId=423;
update tb_user set departmentId=23    where departmentId=422;
update tb_user set departmentId=22    where departmentId=394;
update tb_user set departmentId=21    where departmentId=393;
update tb_user set departmentId=20    where departmentId=386;
update tb_user set departmentId=19    where departmentId=385;
update tb_user set departmentId=18    where departmentId=384;
update tb_user set departmentId=17    where departmentId=383;
update tb_user set departmentId=16    where departmentId=382;
update tb_user set departmentId=15    where departmentId=381;
update tb_user set departmentId=14    where departmentId=380;
update tb_user set departmentId=13    where departmentId=377;
update tb_user set departmentId=12    where departmentId=376;
update tb_user set departmentId=11    where departmentId=375;
update tb_user set departmentId=10    where departmentId=374;
update tb_user set departmentId=9    where departmentId=373;
update tb_user set departmentId=8    where departmentId=372;
update tb_user set departmentId=7    where departmentId=342;
update tb_user set departmentId=6    where departmentId=341;
update tb_user set departmentId=5    where departmentId=340;
update tb_user set departmentId=4    where departmentId=339;
update tb_user set departmentId=3    where departmentId=338;
update tb_user set departmentId=2    where departmentId=337;
update tb_user set departmentId=1    where departmentId=336;




-- 修改用户排序
update tb_user set isLeader=1,orderNum=1 where userName='刘文波';
update tb_user set isLeader=1,orderNum=2 where userName='张力';
update tb_user set isLeader=1,orderNum=3 where userName='邹民';
update tb_user set isLeader=1,orderNum=4 where userName='赵肖';
update tb_user set isLeader=1,orderNum=5 where userName='许志平';
update tb_user set isLeader=1,orderNum=6 where userName='王新里';
update tb_user set isLeader=1,orderNum=7 where userName='陈传宇';
update tb_user set isLeader=1,orderNum=8 where userName='高文田';
update tb_user set isLeader=1,orderNum=1 where userName='宋立忠';