Startseite Erkunden Hilfe
Registrieren Anmelden
zhengbingbing
/
XinXiangXLX_API
Beobachten 1
Favorit hinzufügen 0
Fork 0
Code Issues 0 Pull-Requests 0 Commits 90 Releases 0 Wiki

Keine Beschreibung

Struktur: ce1f0faea0
Branches Tags
XinXiangXLX_API
/
文档
/
Sql
/
sql_20190603...

sql_20190603_dept.sql 45KB
Verlauf Originalformat

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217 
  1. /****** Script for SelectTopNRows command from SSMS  ******/

    2. 

  2. SELECT F_DeptId,F_DeptName,F_DeptCode

    3. 

  3.   FROM [CallCenter_XinXiangXLX].[dbo].[T_Sys_Department]

    4. 

  4.   

    5. 

  5.   --update T_Sys_Department set F_DeptCode=F_ParentCode+convert(varchar,ISNULL(f_deptid,''))+'|'

    6. 

  6.   

    7. 

  7.   

    8. 

  8.   --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(677,'|0|339|617|639|677|','通化分公司',1)

    9. 

  9.   

    10. 

  10. --  insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(664,'|0|339|616|638|664|','湘南分公司',1)

    11. 

  11. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(665,'|0|339|616|638|665|','鄂西分公司',1)

    12. 

  12. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(667,'|0|339|616|638|667|','皖南分公司',1)

    13. 

  13. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(668,'|0|339|616|638|668|','抚州分公司',1)

    14. 

  14. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(668,'|0|339|616|638|668|','赣州分公司',1)

    15. 

  15. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(668,'|0|339|616|638|668|','福建分公司',1)

    16. 

  16. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(668,'|0|339|616|638|668|','上饶分公司',1)

    17. 

  17. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(668,'|0|339|616|638|668|','九江分公司',1)

    18. 

  18. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(674,'|0|339|617|639|674|','佳木斯分公司',1)

    19. 

  19. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(674,'|0|339|617|639|674|','黑河分公司',1)

    20. 

  20. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(674,'|0|339|617|639|674|','大庆分公司',1)

    21. 

  21. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(674,'|0|339|617|639|674|','牡丹江分公司',1)

    22. 

  22. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(674,'|0|339|617|639|674|','哈绥分公司',1)

    23. 

  23. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(675,'|0|339|617|639|675|','赤峰分公司',1)

    24. 

  24. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(675,'|0|339|617|639|675|','唐山分公司',1)

    25. 

  25. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(675,'|0|339|617|639|675|','蒙中分公司',1)

    26. 

  26. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(676,'|0|339|617|639|676|','辽西分公司',1)

    27. 

  27. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(676,'|0|339|617|639|676|','辽北分公司',1)

    28. 

  28. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(676,'|0|339|617|639|676|','辽南分公司',1)

    29. 

  29. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(677,'|0|339|617|639|677|','通辽分公司',1)

    30. 

  30. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(677,'|0|339|617|639|677|','长春分公司',1)

    31. 

  31. --insert into T_Sys_Department (F_ParentId,F_ParentCode,F_DeptName,F_State) values(677,'|0|339|617|639|677|','吉西分公司',1)

    32. 

  32. --  insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('连宿分公司','681','|0|339|611|630|648|681|',1)

    33. 

  33. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('徐州分公司','681','|0|339|611|630|648|681|',1)

    34. 

  34. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('商丘分公司','681','|0|339|611|630|648|681|',1)

    35. 

  35. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('淮北分公司','681','|0|339|611|630|648|681|',1)

    36. 

  36. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('阜阳分公司','681','|0|339|611|630|648|681|',1)

    37. 

  37. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('亳州分公司','681','|0|339|611|630|648|681|',1)

    38. 

  38. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('信阳分公司','682','|0|339|611|630|648|682|',1)

    39. 

  39. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('漯河分公司','682','|0|339|611|630|648|682|',1)

    40. 

  40. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('周口北分公司','682','|0|339|611|630|648|682|',1)

    41. 

  41. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('周口南分公司','682','|0|339|611|630|648|682|',1)

    42. 

  42. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('驻马店北分公司','682','|0|339|611|630|648|682|',1)

    43. 

  43. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('驻马店南分公司','682','|0|339|611|630|648|682|',1)

    44. 

  44. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('运城分公司','683','|0|339|611|630|648|683|',1)

    45. 

  45. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('许昌分公司','683','|0|339|611|630|648|683|',1)

    46. 

  46. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('南阳分公司','683','|0|339|611|630|648|683|',1)

    47. 

  47. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('洛阳分公司','683','|0|339|611|630|648|683|',1)

    48. 

  48. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('临汾分公司','683','|0|339|611|630|648|683|',1)

    49. 

  49. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('襄阳分公司','683','|0|339|611|630|648|683|',1)

    50. 

  50. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('开封分公司','684','|0|339|611|630|648|684|',1)

    51. 

  51. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('直销分公司','684','|0|339|611|630|648|684|',1)

    52. 

  52. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('新乡分公司','684','|0|339|611|630|648|684|',1)

    53. 

  53. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('濮阳分公司','684','|0|339|611|630|648|684|',1)

    54. 

  54. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('焦作分公司','684','|0|339|611|630|648|684|',1)

    55. 

  55. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('安阳分公司','684','|0|339|611|630|648|684|',1)

    56. 

  56. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('聊泰分公司','685','|0|339|611|630|648|685|',1)

    57. 

  57. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('济宁分公司','685','|0|339|611|630|648|685|',1)

    58. 

  58. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('菏泽分公司','685','|0|339|611|630|648|685|',1)

    59. 

  59. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('德州分公司','685','|0|339|611|630|648|685|',1)

    60. 

  60. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('石家庄分公司','686','|0|339|611|630|648|686|',1)

    61. 

  61. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('邢台分公司','686','|0|339|611|630|648|686|',1)

    62. 

  62. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('邯郸分公司','686','|0|339|611|630|648|686|',1)

    63. 

  63. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('保沧分公司','686','|0|339|611|630|648|686|',1)

    64. 

  64. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('晋北分公司','687','|0|339|611|630|648|687|',1)

    65. 

  65. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('晋南分公司','687','|0|339|611|630|648|687|',1)

    66. 

  66. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('陕北分公司','687','|0|339|611|630|648|687|',1)

    67. 

  67. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('陕南分公司','687','|0|339|611|630|648|687|',1)

    68. 

  68. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('临沂分公司','688','|0|339|611|630|648|688|',1)

    69. 

  69. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('青岛分公司','688','|0|339|611|630|648|688|',1)

    70. 

  70. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('潍坊分公司','688','|0|339|611|630|648|688|',1)

    71. 

  71. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('烟威分公司','688','|0|339|611|630|648|688|',1)

    72. 

  72. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('川北分公司','689','|0|339|611|630|648|689|',1)

    73. 

  73. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('川南分公司','689','|0|339|611|630|648|689|',1)

    74. 

  74. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('重庆分公司','689','|0|339|611|630|648|689|',1)

    75. 

  75. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('滇东分公司','689','|0|339|611|630|648|689|',1)

    76. 

  76. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('滇西分公司','689','|0|339|611|630|648|689|',1)

    77. 

  77. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('桂东分公司','690','|0|339|611|630|648|690|',1)

    78. 

  78. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('桂南分公司','690','|0|339|611|630|648|690|',1)

    79. 

  79. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('桂西分公司','690','|0|339|611|630|648|690|',1)

    80. 

  80. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('桂北分公司','690','|0|339|611|630|648|690|',1)

    81. 

  81. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('广东分公司','690','|0|339|611|630|648|690|',1)

    82. 

  82. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('海南分公司','690','|0|339|611|630|648|690|',1)

    83. 

  83. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃豫东分公司','691','|0|339|611|630|648|691|',1)

    84. 

  84. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃豫南分公司','691','|0|339|611|630|648|691|',1)

    85. 

  85. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃豫西分公司','691','|0|339|611|630|648|691|',1)

    86. 

  86. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃冀南分公司','691','|0|339|611|630|648|691|',1)

    87. 

  87. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃鲁西分公司','691','|0|339|611|630|648|691|',1)

    88. 

  88. --insert into T_Sys_Department (F_DeptName,F_ParentId,F_ParentCode,F_State) values('沃利沃豫北分公司','691','|0|339|611|630|648|691|',1)

    89. 

  89.   

    90. 

  90. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|644|',644,'农化服务科',1)

    91. 

  91. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|644|',644,'大客户科',1)	

    92. 

  92. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|645|',645,'高效尿素科',1)  

    93. 

  93. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'豫东大区',1)

    94. 

  94. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'豫南大区',1)

    95. 

  95. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'豫西大区',1)

    96. 

  96. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'豫北大区',1)

    97. 

  97. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'鲁西大区',1)

    98. 

  98. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'冀南大区',1)

    99. 

  99. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'晋陕大区',1)

    100. 

  100. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'鲁东大区',1)

    101. 

  101. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'西南大区',1)

    102. 

  102. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'两广大区',1)

    103. 

  103. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|648|',648,'沃利沃品牌业务部',1)

    104. 

  104. --  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|649|',649,'通化分公司',1)

    105. 

  105. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|664|',664,'常德分公司',1)

    106. 

  106. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|664|',664,'湘北分公司',1)

    107. 

  107. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|664|',664,'湘西分公司',1)

    108. 

  108. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|665|',665,'鄂东分公司',1)

    109. 

  109. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|666|',666,'苏中分公司',1)

    110. 

  110. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|666|',666,'苏南分公司',1)

    111. 

  111. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|667|',667,'皖中分公司',1)

    112. 

  112. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|667|',667,'浙北分公司',1)

    113. 

  113. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|667|',667,'皖西分公司',1)

    114. 

  114. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|667|',667,'浙南分公司',1)

    115. 

  115. 

    116. 

  116.   

    117. 

  117. ------  insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'总经理办公室',1)

    118. 

  118. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|600|',600,'高层',1)

    119. 

  119. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|600|',600,'办公室',1)

    120. 

  120. --------  总经理办公室

    121. 

  121. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'企业管理中心',1)

    122. 

  122. --------企业管理中心

    123. 

  123. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'财务部',1)

    124. 

  124. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|602|',602,'销售财务',1)

    125. 

  125. --------财务部

    126. 

  126. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'技术中心',1)

    127. 

  127. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|603|',603,'产品研究院',1)

    128. 

  128. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|603|624|',624,'农技处',1)

    129. 

  129. 

    130. 

  130. --------技术中心

    131. 

  131. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'规划发展与营销策划中心',1)

    132. 

  132. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|604|',604,'产品规划',1)

    133. 

  133. --------规划发展与营销策划中心

    134. 

  134. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'采购中心',1)

    135. 

  135. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|605|',605,'物资采购',1)

    136. 

  136. --------采购中心

    137. 

  137. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'生产管理中心',1)综合管理

    138. 

  138. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|606|',606,'综合管理',1)

    139. 

  139. --------生产管理中心

    140. 

  140. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'信息化管理部',1)

    141. 

  141. --------信息化管理部

    142. 

  142. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'证券事务部',1)

    143. 

  143. --------证券事务部

    144. 

  144. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'化工品销售部',1)

    145. 

  145. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|609|',609,'车用尿素事业部',1)

    146. 

  146. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|609|628|',628,'车用尿素销售',1)

    147. 

  147. --------化工品销售部

    148. 

  148. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'物流公司',1)

    149. 

  149. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|610|',610,'业务管理',1)

    150. 

  150. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|610|629|',629,'总调',1)

    151. 

  151. --------物流公司

    152. 

  152. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'复合肥事业部',1)

    153. 

  153. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|',611,'销售',1)

    154. 

  154. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'复合肥销售部',1)

    155. 

  155. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'尿素销售部',1)

    156. 

  156. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'销售服务部',1)

    157. 

  157. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'新业务运营部',1)

    158. 

  158. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'销售大区',1)

    159. 

  159. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|611|630|',630,'吉林大区',1)

    160. 

  160. --------复合肥事业部

    161. 

  161. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'吉林公司(过渡)',1)

    162. 

  162. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|612|',612,'综合部',1)

    163. 

  163. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|612|',612,'生产部',1)

    164. 

  164. --------吉林公司(过渡)

    165. 

  165. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'质量管理部',1)

    166. 

  166. --------质量管理部

    167. 

  167. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'营销大数据中心',1)

    168. 

  168. --------营销大数据中心

    169. 

  169. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'新疆心连心能源化工有限公司',1)

    170. 

  170. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|',615,'销售部',1)

    171. 

  171. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'营销管理处',1)

    172. 

  172. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'物流管理',1)

    173. 

  173. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'库尔勒大区',1)

    174. 

  174. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'副产品销售',1)

    175. 

  175. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'乌昌大区',1)

    176. 

  176. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'伊犁大区',1)

    177. 

  177. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'河西大区',1)

    178. 

  178. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'阿喀大区',1)

    179. 

  179. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'综合管理',1)

    180. 

  180. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'宁夏大区',1)

    181. 

  181. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'河东大区',1)

    182. 

  182. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|633|',633,'东疆大区',1)

    183. 

  183. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|615|',615,'产品研发部',1)

    184. 

  184. --------新疆心连心能源化工有限公司

    185. 

  185. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'九江心连心化肥有限公司',1)

    186. 

  186. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|',616,'综合管理部',1)

    187. 

  187. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|',616,'物流部',1)

    188. 

  188. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|',616,'产品研发部',1)

    189. 

  189. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|',616,'销售部',1)

    190. 

  190. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'策划推广',1)

    191. 

  191. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'业务运营',1)

    192. 

  192. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'湖南大区',1)

    193. 

  193. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'湖北大区',1)

    194. 

  194. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'江苏大区',1)

    195. 

  195. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'皖浙大区',1)

    196. 

  196. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'闽赣大区',1)

    197. 

  197. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'直属大区',1)

    198. 

  198. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'安徽大区',1)

    199. 

  199. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'湘北大区',1)

    200. 

  200. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'湘南大区',1)

    201. 

  201. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|616|638|',638,'苏中大区',1)

    202. 

  202. --------九江心连心化肥有限公司

    203. 

  203. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'心连心化肥（吉林）有限公司',1)

    204. 

  204. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|617|',617,'销售部',1)

    205. 

  205. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|617|639|',639,'黑龙江大区',1)

    206. 

  206. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|617|639|',639,'冀蒙大区',1)

    207. 

  207. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|617|639|',639,'辽宁大区',1)

    208. 

  208. --insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|617|639|',639,'吉林大区',1)

    209. 

  209. --------心连心化肥（吉林）有限公司

    210. 

  210. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'新疆黑色生态科技股份有限公司',1)

    211. 

  211. --------新疆黑色生态科技股份有限公司

    212. 

  212. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'河南心连心蓝色环保科技有限公司',1)

    213. 

  213. ----insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|619|',619,'综合管理部',1)

    214. 

  214. 

    215. 

  215. --------河南心连心蓝色环保科技有限公司

    216. 

  216. ------insert into T_Sys_Department (F_ParentCode,F_ParentId,F_DeptName,F_State) values('|0|339|',339,'河南心连心深冷能源股份有限公司',1)

    217. 

  217. --------河南心连心深冷能源股份有限公司
    218.