/****** Script for SelectTopNRows command from SSMS ******/ SELECT F_DeptId,F_DeptName,F_DeptCode FROM [CallCenter_XinXiangXLX].[dbo].[T_Sys_Department] --update T_Sys_Department set F_DeptCode=F_ParentCode+convert(varchar,ISNULL(f_deptid,''))+'|' --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(677,'|0|339|617|639|677|','通化分公司',1) -- insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(664,'|0|339|616|638|664|','湘南分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(665,'|0|339|616|638|665|','鄂西分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(667,'|0|339|616|638|667|','皖南分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(668,'|0|339|616|638|668|','抚州分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(668,'|0|339|616|638|668|','赣州分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(668,'|0|339|616|638|668|','福建分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(668,'|0|339|616|638|668|','上饶分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(668,'|0|339|616|638|668|','九江分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(674,'|0|339|617|639|674|','佳木斯分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(674,'|0|339|617|639|674|','黑河分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(674,'|0|339|617|639|674|','大庆分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(674,'|0|339|617|639|674|','牡丹江分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(674,'|0|339|617|639|674|','哈绥分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(675,'|0|339|617|639|675|','赤峰分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(675,'|0|339|617|639|675|','唐山分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(675,'|0|339|617|639|675|','蒙中分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(676,'|0|339|617|639|676|','辽西分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(676,'|0|339|617|639|676|','辽北分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(676,'|0|339|617|639|676|','辽南分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(677,'|0|339|617|639|677|','通辽分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(677,'|0|339|617|639|677|','长春分公司',1) --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(677,'|0|339|617|639|677|','吉西分公司',1) -- insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('连宿分公司','681','|0|339|611|630|648|681|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('徐州分公司','681','|0|339|611|630|648|681|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('商丘分公司','681','|0|339|611|630|648|681|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('淮北分公司','681','|0|339|611|630|648|681|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('阜阳分公司','681','|0|339|611|630|648|681|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('亳州分公司','681','|0|339|611|630|648|681|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('信阳分公司','682','|0|339|611|630|648|682|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('漯河分公司','682','|0|339|611|630|648|682|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('周口北分公司','682','|0|339|611|630|648|682|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('周口南分公司','682','|0|339|611|630|648|682|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('驻马店北分公司','682','|0|339|611|630|648|682|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('驻马店南分公司','682','|0|339|611|630|648|682|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('运城分公司','683','|0|339|611|630|648|683|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('许昌分公司','683','|0|339|611|630|648|683|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('南阳分公司','683','|0|339|611|630|648|683|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('洛阳分公司','683','|0|339|611|630|648|683|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('临汾分公司','683','|0|339|611|630|648|683|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('襄阳分公司','683','|0|339|611|630|648|683|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('开封分公司','684','|0|339|611|630|648|684|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('直销分公司','684','|0|339|611|630|648|684|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('新乡分公司','684','|0|339|611|630|648|684|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('濮阳分公司','684','|0|339|611|630|648|684|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('焦作分公司','684','|0|339|611|630|648|684|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('安阳分公司','684','|0|339|611|630|648|684|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('聊泰分公司','685','|0|339|611|630|648|685|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('济宁分公司','685','|0|339|611|630|648|685|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('菏泽分公司','685','|0|339|611|630|648|685|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('德州分公司','685','|0|339|611|630|648|685|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('石家庄分公司','686','|0|339|611|630|648|686|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('邢台分公司','686','|0|339|611|630|648|686|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('邯郸分公司','686','|0|339|611|630|648|686|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('保沧分公司','686','|0|339|611|630|648|686|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('晋北分公司','687','|0|339|611|630|648|687|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('晋南分公司','687','|0|339|611|630|648|687|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('陕北分公司','687','|0|339|611|630|648|687|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('陕南分公司','687','|0|339|611|630|648|687|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('临沂分公司','688','|0|339|611|630|648|688|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('青岛分公司','688','|0|339|611|630|648|688|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('潍坊分公司','688','|0|339|611|630|648|688|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('烟威分公司','688','|0|339|611|630|648|688|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('川北分公司','689','|0|339|611|630|648|689|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('川南分公司','689','|0|339|611|630|648|689|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('重庆分公司','689','|0|339|611|630|648|689|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('滇东分公司','689','|0|339|611|630|648|689|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('滇西分公司','689','|0|339|611|630|648|689|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('桂东分公司','690','|0|339|611|630|648|690|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('桂南分公司','690','|0|339|611|630|648|690|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('桂西分公司','690','|0|339|611|630|648|690|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('桂北分公司','690','|0|339|611|630|648|690|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('广东分公司','690','|0|339|611|630|648|690|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('海南分公司','690','|0|339|611|630|648|690|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃豫东分公司','691','|0|339|611|630|648|691|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃豫南分公司','691','|0|339|611|630|648|691|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃豫西分公司','691','|0|339|611|630|648|691|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃冀南分公司','691','|0|339|611|630|648|691|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃鲁西分公司','691','|0|339|611|630|648|691|',1) --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃豫北分公司','691','|0|339|611|630|648|691|',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|644|',644,'农化服务科',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|644|',644,'大客户科',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|645|',645,'高效尿素科',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'豫东大区',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'豫南大区',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'豫西大区',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'豫北大区',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'鲁西大区',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'冀南大区',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'晋陕大区',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'鲁东大区',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'西南大区',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'两广大区',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'沃利沃品牌业务部',1) -- insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|649|',649,'通化分公司',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|664|',664,'常德分公司',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|664|',664,'湘北分公司',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|664|',664,'湘西分公司',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|665|',665,'鄂东分公司',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|666|',666,'苏中分公司',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|666|',666,'苏南分公司',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|667|',667,'皖中分公司',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|667|',667,'浙北分公司',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|667|',667,'皖西分公司',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|667|',667,'浙南分公司',1) ------ insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'总经理办公室',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|600|',600,'高层',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|600|',600,'办公室',1) -------- 总经理办公室 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'企业管理中心',1) --------企业管理中心 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'财务部',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|602|',602,'销售财务',1) --------财务部 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'技术中心',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|603|',603,'产品研究院',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|603|624|',624,'农技处',1) --------技术中心 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'规划发展与营销策划中心',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|604|',604,'产品规划',1) --------规划发展与营销策划中心 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'采购中心',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|605|',605,'物资采购',1) --------采购中心 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'生产管理中心',1)综合管理 ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|606|',606,'综合管理',1) --------生产管理中心 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'信息化管理部',1) --------信息化管理部 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'证券事务部',1) --------证券事务部 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'化工品销售部',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|609|',609,'车用尿素事业部',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|609|628|',628,'车用尿素销售',1) --------化工品销售部 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'物流公司',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|610|',610,'业务管理',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|610|629|',629,'总调',1) --------物流公司 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'复合肥事业部',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|',611,'销售',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'复合肥销售部',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'尿素销售部',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'销售服务部',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'新业务运营部',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'销售大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'吉林大区',1) --------复合肥事业部 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'吉林公司(过渡)',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|612|',612,'综合部',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|612|',612,'生产部',1) --------吉林公司(过渡) ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'质量管理部',1) --------质量管理部 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'营销大数据中心',1) --------营销大数据中心 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'新疆心连心能源化工有限公司',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|',615,'销售部',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'营销管理处',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'物流管理',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'库尔勒大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'副产品销售',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'乌昌大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'伊犁大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'河西大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'阿喀大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'综合管理',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'宁夏大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'河东大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'东疆大区',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|',615,'产品研发部',1) --------新疆心连心能源化工有限公司 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'九江心连心化肥有限公司',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|',616,'综合管理部',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|',616,'物流部',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|',616,'产品研发部',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|',616,'销售部',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'策划推广',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'业务运营',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'湖南大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'湖北大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'江苏大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'皖浙大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'闽赣大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'直属大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'安徽大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'湘北大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'湘南大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'苏中大区',1) --------九江心连心化肥有限公司 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'心连心化肥（吉林）有限公司',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|617|',617,'销售部',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|617|639|',639,'黑龙江大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|617|639|',639,'冀蒙大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|617|639|',639,'辽宁大区',1) --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|617|639|',639,'吉林大区',1) --------心连心化肥（吉林）有限公司 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'新疆黑色生态科技股份有限公司',1) --------新疆黑色生态科技股份有限公司 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'河南心连心蓝色环保科技有限公司',1) ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|619|',619,'综合管理部',1) --------河南心连心蓝色环保科技有限公司 ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'河南心连心深冷能源股份有限公司',1) --------河南心连心深冷能源股份有限公司