Inicio Explorar Ayuda
Registro Iniciar sesión
zhoufan
/
XYX12345_Api
Seguir 1
Destacar 0
Fork 0
Código Incidencias 0 Pull Requests 0 Commits 58 Releases 0 Wiki

新野县12345_后端

Rama: master
Ramas Etiquetas
XYX12345_Api
/
sql
/
sql_20180911...

sql_20180911_部门.sql 11KB
Permalink Histórico Raw

1234567891011121314151617181920212223 
  1. SET IDENTITY_INSERT [dbo].[T_Sys_Department] ON
    2. 

  2. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (63, N'乡镇', N'', N'', N'', N'', N'', 1, 0, 0, 0, N'', N'', N'', N'', N'', N'', N'', N'', 0, N'8000', CAST(0x0000A957011A6174 AS DateTime), 0, 1)
    3. 

  3. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (64, N'城郊乡', NULL, NULL, N'', NULL, NULL, 63, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A957011ADBDF AS DateTime), 1, 1)
    4. 

  4. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (65, N'五星镇', NULL, NULL, N'', NULL, NULL, 63, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A957011B0807 AS DateTime), 1, 1)
    5. 

  5. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (66, N'王庄镇', NULL, NULL, N'', NULL, NULL, 63, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A957011B126A AS DateTime), 1, 1)
    6. 

  6. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (67, N'前高庙乡', NULL, NULL, N'', NULL, NULL, 63, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A957011B1E0F AS DateTime), 1, 1)
    7. 

  7. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (68, N'新甸铺镇', NULL, NULL, N'', NULL, NULL, 63, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A957011B295D AS DateTime), 1, 1)
    8. 

  8. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (69, N'溧河铺镇', NULL, NULL, N'', NULL, NULL, 63, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A957011B35EA AS DateTime), 1, 1)
    9. 

  9. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (70, N'施庵镇', NULL, NULL, N'', NULL, NULL, 63, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A957011B405C AS DateTime), 1, 1)
    10. 

  10. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (71, N'沙堰镇', NULL, NULL, N'', NULL, NULL, 63, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A957011B4C51 AS DateTime), 1, 1)
    11. 

  11. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (72, N'樊集乡', NULL, NULL, N'', NULL, NULL, 63, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A957011B5837 AS DateTime), 1, 1)
    12. 

  12. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (73, N'王集镇', NULL, NULL, N'', NULL, NULL, 63, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A957011B6B57 AS DateTime), 1, 1)
    13. 

  13. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (74, N'上港乡', NULL, NULL, N'', NULL, NULL, 63, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A957011B7706 AS DateTime), 1, 1)
    14. 

  14. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (75, N'税务局', N'', N'', N'', N'', N'', 4, 1, 0, 0, N'', N'', N'', N'', N'', N'', N'', N'', 0, N'8000', CAST(0x0000A95800A06680 AS DateTime), 1, 1)
    15. 

  15. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (76, N'移动公司', NULL, NULL, N'', NULL, NULL, 4, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A95800A090CB AS DateTime), 1, 1)
    16. 

  16. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (77, N'司法局', NULL, NULL, N'', NULL, NULL, 4, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A95800A0A63A AS DateTime), 1, 1)
    17. 

  17. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (78, N'工信委', NULL, NULL, N'', NULL, NULL, 4, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A95800A0B725 AS DateTime), 1, 1)
    18. 

  18. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (79, N'金融办', NULL, NULL, N'', NULL, NULL, 4, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A95800A177ED AS DateTime), 1, 1)
    19. 

  19. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (80, N'汉城街道', NULL, NULL, N'', NULL, NULL, 2, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A95800F6517A AS DateTime), 1, 1)
    20. 

  20. INSERT [dbo].[T_Sys_Department] ([F_DeptId], [F_DeptName], [F_DeptNameSpell], [F_DeptNameSpells], [F_DeptPhone], [F_DeptPhone2], [F_DeptTelphone], [F_PartentId], [F_layer], [F_Sort], [F_Type], [F_Address], [F_Remark], [F_LeaderUser], [F_LeaderUserName], [F_TopSplitUser], [F_TopSplitUserName], [F_TopLeaderUser], [F_TopLeaderUserName], [F_State], [F_CreateUser], [F_CreateDate], [F_IsDept], [F_IsDealDept]) VALUES (81, N'汉华街道', NULL, NULL, N'', NULL, NULL, 2, 1, 0, 0, NULL, NULL, N'', NULL, N'', NULL, N'', NULL, 0, N'8000', CAST(0x0000A95800F6648E AS DateTime), 1, 1)
    21. 

  21. 

  22. SET IDENTITY_INSERT [dbo].[T_Sys_Department] OFF
    23. 

  23.