-- 添加部门 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='宋立忠';