Acasă Explorează Ajutor
Înregistrare Autentificare
WEP
/
We_V1.0
2
0
Bifurcare 0
Fisiere Probleme 0 Trageți solicitările 0 Wiki
Ramură: master
Ramuri Etichete
We_V1.0
/
RodChange
/
doc
/
qqq.sql

qqq.sql 70 KB
Permalink Istoric Crud

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224 
  1. /****** Script for SelectTopNRows command from SSMS  ******/
    2. 

  2. 

  3. SELECT *   FROM [dbo].[Rc_TrainingCampProcessInfos]
    4. 

  4. 

  5. SELECT *   FROM [dbo].[Rc_TrainingCampMessageRecords]
    6. 

  6.  
    7. 

  7.   /*
    8. 

  8.   UPDATE [dbo].[Rc_TrainingCampFaultInfos] SET [IsEnd]=0
    9. 

  9.   UPDATE [dbo].[Rc_TrainingCampFaultInfos] SET [IsExecute]=0 WHERE Id=2 
    10. 

  10.   TRUNCATE TABLE [dbo].[Rc_TrainingCampProcessInfos]
    11. 

  11.   TRUNCATE TABLE [dbo].[Rc_TrainingCampMessageRecords]
    12. 

  12.   DELETE [dbo].[Rc_TrainingCampWorkOrderInfos]
    13. 

  13.   TRUNCATE TABLE [dbo].[Rc_CampRoutePathPointRecord]
    14. 

  14.   
    15. 

  15.   --TRUNCATE TABLE [dbo].[Rc_TrainingCampRepairTeamInfos]
    16. 

  16. 

  17. 

  18.   
    19. 

  19.   
    20. 

  20.   */ 
    21. 

  21. 

  22. 

  23. 

  24. 

  25.  /*
    26. 

  26. USE [RodChangeDb]
    27. 

  27. GO
    28. 

  28. INSERT 
    29. 

  29. [dbo].[Rc_FaultProcessInfos] ([Id], [Pid], [Name], [Depth], [Description], [Score], [Tags], [FaultTypeId], [EmergencyType], [LogicType], [Remark], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId]) VALUES  
    30. 

  30.   (N'33145ea66eb1402abd35dab45ec5c626', NULL, N'确认报修信息', 1, N'接到电网故障报修，确认报修信息来源：【如95598、区大联动（根据勾选，可单选或多选）】', CAST(2.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 1, 2, NULL, 0, NULL, NULL, CAST(N'2019-11-23T09:30:34.667' AS DateTime), 3, CAST(N'2019-11-20T15:55:28.890' AS DateTime), 3)
    31. 

  31. , (N'1eb190f0d78d4d5b99c95cf3a341a810', N'33145ea66eb1402abd35dab45ec5c626', N'询问故障信息', 2, N'供电服务指挥员询问供电舆情、特殊用户是否用电、故障地点核对', CAST(6.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 1, 1, NULL, 0, NULL, NULL, CAST(N'2019-11-25T10:26:27.463' AS DateTime), 3, CAST(N'2019-11-20T16:29:41.883' AS DateTime), 3)
    32. 

  32. , (N'62128527e89a4554b35f7828c4612fea', N'1eb190f0d78d4d5b99c95cf3a341a810', N'登记工单', 3, N'指挥员工接单登记收到时间。', CAST(2.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 1, 1, NULL, 0, NULL, NULL, CAST(N'2019-11-25T10:26:50.347' AS DateTime), 3, CAST(N'2019-11-20T16:55:36.980' AS DateTime), 3)
    33. 

  33. , (N'3a3cc6267039472b8309582f38f411e5', N'62128527e89a4554b35f7828c4612fea', N'指派特巡人员', 4, N'指挥员指派故障特巡人员。', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 1, 1, NULL, 0, NULL, NULL, CAST(N'2019-11-25T10:26:59.797' AS DateTime), 3, CAST(N'2019-11-20T16:58:44.223' AS DateTime), 3)
    34. 

  34. , (N'd8ea757fe6bb4b48a2040581b196f139', N'3a3cc6267039472b8309582f38f411e5', N'通知抢修队伍待命', 5, N'指挥员预通知抢修队伍和许可人待命。', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 1, 1, NULL, 0, NULL, NULL, CAST(N'2019-11-25T10:29:31.400' AS DateTime), 3, CAST(N'2019-11-20T17:00:30.783' AS DateTime), 3)
    35. 

  35. , (N'e53c87722e1b4fd3b5a84155ad8287e3', N'd8ea757fe6bb4b48a2040581b196f139', N'接收特巡汇报', 6, N'根据特巡人员手机GPS定位，供电服务指挥员在规划平台地图上精确定位，接收特巡汇报。', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 1, 1, NULL, 0, NULL, NULL, CAST(N'2019-11-25T10:32:41.197' AS DateTime), 3, CAST(N'2019-11-20T17:01:43.283' AS DateTime), 3)
    36. 

  36. , (N'93449fb1f34a4fb4bc55fb1388ab192c', N'e53c87722e1b4fd3b5a84155ad8287e3', N'研判故障原因', 7, N'指挥员结合巡视人员的单兵画面，研判故障原因，并在工单上登记故障原因，形成抢修方案和安全措施。', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 1, 2, NULL, 0, NULL, NULL, CAST(N'2019-11-25T12:02:18.140' AS DateTime), 3, CAST(N'2019-11-20T17:02:43.580' AS DateTime), 3)
    37. 

  37. , (N'cb7b2080cebd480bb1f23c18455d4b80', N'93449fb1f34a4fb4bc55fb1388ab192c', N'通知抢修队伍', 8, N'供电服务指挥员通知抢修队伍、许可人和物资仓库，特别说明吊车是否到位。', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 2, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:02:22.590' AS DateTime), 3)
    38. 

  38. , (N'd617300146f74e45883a4316eec18411', N'cb7b2080cebd480bb1f23c18455d4b80', N'开具抢修工作票', 9, N'供电服务指挥员电话通知抢修队伍负责人，根据抢修方案和安全措施，开具抢修工作票，双方核对一致。', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 2, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:05:39.650' AS DateTime), 3)
    39. 

  39. , (N'6c56594250aa426cb2ce5c4f230309e6', N'd617300146f74e45883a4316eec18411', N'监控抢修队伍', 10, N'监控抢修队伍行车轨迹、路程进度。', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 2, 1, NULL, 0, NULL, NULL, CAST(N'2019-11-25T13:09:31.753' AS DateTime), 3, CAST(N'2019-11-25T13:09:10.227' AS DateTime), 3)
    40. 

  40. , (N'34eceac8b08c45f79e883ccfdf7e4cbb', N'6c56594250aa426cb2ce5c4f230309e6', N'开具抢修操作票', 11, N'供电服务指挥员开具抢修操作票，并和现场许可人核对正确。', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 2, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:12:18.910' AS DateTime), 3)
    41. 

  41. , (N'07ae3ebb45244fd380a7470f440bd86c', N'34eceac8b08c45f79e883ccfdf7e4cbb', N'发布停役操作指令', 12, N'指挥员发布停役操作指令给现场许可人。', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 2, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:14:17.453' AS DateTime), 3)
    42. 

  42. , (N'ecdb4597c3a040308e3cd318176485a1', N'07ae3ebb45244fd380a7470f440bd86c', N'接受停役完成汇报', 13, N'接受停役完成汇报', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 2, 1, NULL, 0, NULL, NULL, CAST(N'2019-11-25T14:23:48.663' AS DateTime), 3, CAST(N'2019-11-25T13:20:15.267' AS DateTime), 3)
    43. 

  43. , (N'25dd15a67ebd4bfdaaefad67fc6c481c', N'ecdb4597c3a040308e3cd318176485a1', N'许可开始抢修工作', 14, N'许可给现场许可人，抢修工作开始', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 2, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:22:31.297' AS DateTime), 3)
    44. 

  44. , (N'98126bf7c1ee410a840a5f8b78e4bfff', N'25dd15a67ebd4bfdaaefad67fc6c481c', N'监控抢修全过程', 15, N'指挥员利用单兵对抢修全过程监控、危险点提示', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 2, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:49:37.510' AS DateTime), 3)
    45. 

  45. , (N'1796f27a4876474787c7a171fd89b583', N'98126bf7c1ee410a840a5f8b78e4bfff', N'接受抢修工作结束汇报', 16, N'抢修工作结束汇报', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 2, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:56:05.670' AS DateTime), 3)
    46. 

  46. , (N'2a00168d3b8f4cb19ea7f6bdad0ec4e3', N'1796f27a4876474787c7a171fd89b583', N'核对复役操作票，发令复役操作', 17, N'核对复役操作票，发令复役操作', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 2, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:57:07.447' AS DateTime), 3)
    47. 

  47. , (N'05279ddf031f4885b89feddfd0515dfa', N'2a00168d3b8f4cb19ea7f6bdad0ec4e3', N'接受现场操作结束汇报', 18, N'指挥员接受现场许可人操作结束汇报，并确认已全部恢复供电。', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 2, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:25:02.320' AS DateTime), 3)
    48. 

  48. , (N'ad0fe0ab6c3b4154991eda86e2172885', N'05279ddf031f4885b89feddfd0515dfa', N'结束抢修回复', 19, N'指挥员结束抢修回复：95598工单闭环、区大联动、110公安、119消防、绿化水务公路、12345热线、其他（根据勾选）', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 3, 2, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:44:12.933' AS DateTime), 3)
    49. 

  49. , (N'37358f7425844ce18c45f8b73bc8d98e', N'ad0fe0ab6c3b4154991eda86e2172885', N'应急处置回复', 20, N'指挥员应急处置回复：舆情方面办公室、营销、区大联动，应急发电方面运检部', CAST(5.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 3, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:47:50.120' AS DateTime), 3)
    50. 

  50. , (N'9e786f90283c483faa2bbb64e29990cb', N'37358f7425844ce18c45f8b73bc8d98e', N'抢修时间确认', 21, N'由系统分阶段统计接报至人员到达时间、接到报修至修复送电时间、各环节时间', CAST(3.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 3, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:51:51.387' AS DateTime), 3)
    51. 

  51. , (N'f2d2b7c2970e49b9b9cb224857ed3c10', N'9e786f90283c483faa2bbb64e29990cb', N'故障原因分析', 22, N'统计故障原因并留档，可以分析一段时间内造成杆变故障的多发原因，运维检修中加以重点关注。', CAST(2.00 AS Decimal(18, 2)), N'', N'bf73d494433d4c18a202275c7ccbcc0a', 3, 1, NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:54:04.150' AS DateTime), 3)
    52. 

  52. GO
    53. 

  53. 

  54. 

  55. INSERT 
    56. 

  56. [dbo].[Rc_FaultProcessActionInfos] ([Id], [Name], [ProcessId], [Description], [Tags], [Remark], [IsDeleted], [DeleterUserId], [DeletionTime], [LastModificationTime], [LastModifierUserId], [CreationTime], [CreatorUserId], [Score], [Type]) VALUES 
    57. 

  57. (N'00a4d374647145bfab11d36132783b7b', N'高压桩头烧坏', N'93449fb1f34a4fb4bc55fb1388ab192c', N'高压桩头烧坏', N'故障原因', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:05:07.440' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    58. 

  58. ,(N'0692c7fa4bae46eaae1d92474170398c', N'发布开始抢修指令', N'25dd15a67ebd4bfdaaefad67fc6c481c', N'发布开始抢修指令', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:46:14.343' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    59. 

  59. ,(N'09aeed8f2c7643e98c74f7d6da3fe90d', N'抢修危险点提示', N'98126bf7c1ee410a840a5f8b78e4bfff', N'危险点提示', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:55:16.557' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    60. 

  60. ,(N'0e6fa30c70e54a359347810a5d66c892', N'核对抢修操作票', N'34eceac8b08c45f79e883ccfdf7e4cbb', N'和现场许可人核对抢修操作票。', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:13:29.760' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 5)
    61. 

  61. ,(N'12a64b3a9cd340af85fe97c9f907f983', N'杆变漏油', N'93449fb1f34a4fb4bc55fb1388ab192c', N'杆变漏油', N'故障原因', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:04:31.220' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    62. 

  62. ,(N'147ebd7c707e43a7b6e4699e79cec7b3', N'回复区大联动部门', N'37358f7425844ce18c45f8b73bc8d98e', N'回复区大联动部门', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:50:17.110' AS DateTime), 3, CAST(1.00 AS Decimal(18, 2)), 1)
    63. 

  63. ,(N'16d1247462b04bcf9996f8e32afdd23b', N'接受操作结束汇报', N'05279ddf031f4885b89feddfd0515dfa', N'接受现场许可人操作结束汇报', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:41:15.500' AS DateTime), 3, CAST(3.00 AS Decimal(18, 2)), 1)
    64. 

  64. ,(N'18e89f3a54c54222880313f5c2962458', N'SCADA', N'33145ea66eb1402abd35dab45ec5c626', N'SCADA', N'信息来源', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:50:29.830' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    65. 

  65. ,(N'1a2531107e6e4df7a4ea54abc361b4d6', N'确认接报至修复送电时间', N'9e786f90283c483faa2bbb64e29990cb', N'确认接报至修复送电时间', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:52:58.450' AS DateTime), 3, CAST(1.00 AS Decimal(18, 2)), 1)
    66. 

  66. ,(N'22f08116cc53483fa6df68e6ef5b05ce', N'其他 ', N'33145ea66eb1402abd35dab45ec5c626', N'其他 ', N'信息来源', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:52:40.057' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    67. 

  67. ,(N'29895c431f31412e84ed50ded02e5589', N'确认已全部恢复供电', N'05279ddf031f4885b89feddfd0515dfa', N'确认已全部恢复供电', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:41:42.773' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    68. 

  68. ,(N'2a90c2f080994d7ca99670737035c37b', N'通知抢修队伍、许可人和物资仓库', N'cb7b2080cebd480bb1f23c18455d4b80', N'供电服务指挥员通知抢修队伍、许可人和物资仓库', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:03:07.157' AS DateTime), 3, CAST(3.00 AS Decimal(18, 2)), 1)
    69. 

  69. ,(N'2d10965550bf4f068525fba57081fd08', N'巡查故障', N'3a3cc6267039472b8309582f38f411e5', N'指派特巡人员巡查故障', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T10:28:16.403' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    70. 

  70. ,(N'34ce265ec67845f7ac19121177c7fc86', N'发布复役操作指令', N'2a00168d3b8f4cb19ea7f6bdad0ec4e3', N'发布复役操作指令', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:40:14.967' AS DateTime), 3, CAST(3.00 AS Decimal(18, 2)), 4)
    71. 

  71. ,(N'3b85fb7fdf48426b8c3a7e15e10c23df', N'接受停役完成汇报', N'ecdb4597c3a040308e3cd318176485a1', N'接受完成汇报', N'', NULL, 0, NULL, NULL, CAST(N'2019-11-25T13:21:27.147' AS DateTime), 3, CAST(N'2019-11-25T13:20:48.740' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    72. 

  72. ,(N'3c194b058bb84d8f87166355213fae46', N'119消防', N'33145ea66eb1402abd35dab45ec5c626', N'119消防', N'信息来源', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:51:38.590' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    73. 

  73. ,(N'3ec086d3e12949c09a506b8cb0e17d09', N'询问抢修队伍路程进度', N'6c56594250aa426cb2ce5c4f230309e6', N'询问抢修队伍路程进度', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:11:14.580' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    74. 

  74. ,(N'3fbe69db2dc54097b4e222de57682530', N'其他原因', N'93449fb1f34a4fb4bc55fb1388ab192c', N'其他原因', N'故障原因', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:10:36.083' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    75. 

  75. ,(N'40a24638513b40c0bce06a19434f3ccf', N'台区总表', N'33145ea66eb1402abd35dab45ec5c626', N'台区总表', N'信息来源', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:50:50.337' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    76. 

  76. ,(N'4b9fd05863a14455a7d9326218ca07bd', N'回复应急发电方面运检部', N'37358f7425844ce18c45f8b73bc8d98e', N'回复应急发电方面运检部', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:50:38.260' AS DateTime), 3, CAST(1.00 AS Decimal(18, 2)), 1)
    77. 

  77. ,(N'4da9c84be4604398b2ce6dbf3404c6c4', N'其他', N'ad0fe0ab6c3b4154991eda86e2172885', N'其他', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:46:45.653' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    78. 

  78. ,(N'51417925e8274177a8f029b8324b9da1', N'分析一段时间内造成杆变故障的多发原因', N'f2d2b7c2970e49b9b9cb224857ed3c10', N'分析一段时间内造成杆变故障的多发原因，运维检修中加以重点关注', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:55:07.357' AS DateTime), 3, CAST(1.00 AS Decimal(18, 2)), 1)
    79. 

  79. ,(N'541f01e7485d4c71a1451ffb856f6fec', N'发布停役操作指令', N'07ae3ebb45244fd380a7470f440bd86c', N'发布停役操作指令', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:19:03.237' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    80. 

  80. ,(N'5585bcad958f4cb4bdb842f2364bd9d2', N'低压断杆', N'93449fb1f34a4fb4bc55fb1388ab192c', N'低压断杆', N'故障原因', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:10:06.020' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    81. 

  81. ,(N'6376d118dcc548ed9124ec39868420db', N'询问特殊用户是否用电', N'1eb190f0d78d4d5b99c95cf3a341a810', N'询问特殊用户是否用电', N'', NULL, 0, NULL, NULL, CAST(N'2019-11-22T11:40:50.203' AS DateTime), 3, CAST(N'2019-11-20T17:17:34.547' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    82. 

  82. ,(N'6acbbc3cbba348009cd3b0124509e1da', N'确认吊车是否到位', N'cb7b2080cebd480bb1f23c18455d4b80', N'吊车是否到位', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:04:09.520' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    83. 

  83. ,(N'721ece0dfb4046718cfb39d9d6aaad4e', N'故障地点核对', N'1eb190f0d78d4d5b99c95cf3a341a810', N'故障地点核对', N'', NULL, 0, NULL, NULL, CAST(N'2019-11-22T11:40:55.910' AS DateTime), 3, CAST(N'2019-11-20T17:18:06.210' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    84. 

  84. ,(N'7a1c7735551b46428e14cb240804ac30', N'回复营销部门', N'37358f7425844ce18c45f8b73bc8d98e', N'回复营销部门', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:49:42.433' AS DateTime), 3, CAST(1.00 AS Decimal(18, 2)), 1)
    85. 

  85. ,(N'7df815ebe171472698265d8d3dea202f', N'回复舆情方面办公室', N'37358f7425844ce18c45f8b73bc8d98e', N'回复舆情方面办公室', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:48:40.223' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    86. 

  86. ,(N'8ddf4c36ac7b4a6eb78bff9163685e0b', N'低压导线缠绕', N'93449fb1f34a4fb4bc55fb1388ab192c', N'低压导线缠绕', N'故障原因', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:09:48.190' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    87. 

  87. ,(N'a0bb4c81b96544e38b5c599143738458', N'监控抢修过程', N'98126bf7c1ee410a840a5f8b78e4bfff', N'监控抢修全过程', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:51:54.350' AS DateTime), 3, CAST(3.00 AS Decimal(18, 2)), 1)
    88. 

  88. ,(N'a24e0646adbd40b6adb3d326cfe21f93', N'95598', N'33145ea66eb1402abd35dab45ec5c626', N'95598', N'信息来源', NULL, 0, NULL, NULL, CAST(N'2019-11-25T12:53:06.223' AS DateTime), 3, CAST(N'2019-11-20T16:39:19.167' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    89. 

  89. ,(N'a75286a98a23488ab5a78dbf1948826f', N'接受抢修工作结束汇报', N'1796f27a4876474787c7a171fd89b583', N'接受抢修工作结束汇报', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:39:14.143' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    90. 

  90. ,(N'abc04cebdd074eed8ea9a56b25c34b4b', N'110公安', N'33145ea66eb1402abd35dab45ec5c626', N'110公安', N'信息来源', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:51:13.927' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    91. 

  91. ,(N'ac982a53dd1c45d9b1dba5da653a000a', N'低压绝缘子坏', N'93449fb1f34a4fb4bc55fb1388ab192c', N'低压绝缘子坏', N'故障原因', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:09:15.427' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 2)
    92. 

  92. ,(N'afd426a59c9d465e9560b600b79534a0', N'抢修队伍待命', N'd8ea757fe6bb4b48a2040581b196f139', N'通知抢险队伍待命', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T10:29:21.253' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    93. 

  93. ,(N'bb11a2f488674982a1d8397b03ba3a8d', N'确认接报至人员到达时间', N'9e786f90283c483faa2bbb64e29990cb', N'接报至人员到达时间', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:52:10.713' AS DateTime), 3, CAST(1.00 AS Decimal(18, 2)), 1)
    94. 

  94. ,(N'be0f9992815547628cefbbb08f80bce1', N'12345热线', N'33145ea66eb1402abd35dab45ec5c626', N'12345热线', N'信息来源', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:52:23.877' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    95. 

  95. ,(N'beb398b337f64bf689c00d6523ced125', N'95598工单闭环', N'ad0fe0ab6c3b4154991eda86e2172885', N'95598工单闭环', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:45:06.310' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    96. 

  96. ,(N'c1bf9ba794ec4df69d9a13015794134f', N'绿化水务公路', N'ad0fe0ab6c3b4154991eda86e2172885', N'绿化水务公路', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:46:17.790' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    97. 

  97. ,(N'c6cf19e89509479da6ca61f233322a0d', N'询问供电舆情', N'1eb190f0d78d4d5b99c95cf3a341a810', N'询问供电舆情', N'', NULL, 0, NULL, NULL, CAST(N'2019-11-22T11:40:43.630' AS DateTime), 3, CAST(N'2019-11-20T17:16:50.470' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    98. 

  98. ,(N'c7e3f4d9178b49e2944538a0817d64c0', N'高压熔丝跌落', N'93449fb1f34a4fb4bc55fb1388ab192c', N'高压熔丝跌落', N'故障原因', NULL, 0, NULL, NULL, CAST(N'2019-11-25T12:03:22.893' AS DateTime), 3, CAST(N'2019-11-25T10:33:47.367' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    99. 

  99. ,(N'c89e2df49cb14970a79373e4de27295a', N'监控抢修队伍行车轨迹', N'6c56594250aa426cb2ce5c4f230309e6', N'监控抢修队伍行车轨迹', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:10:35.170' AS DateTime), 3, CAST(3.00 AS Decimal(18, 2)), 1)
    100. 

  100. ,(N'cbd8ade9f86a4640bb370a707c7c595b', N'接受故障汇报', N'e53c87722e1b4fd3b5a84155ad8287e3', N'接受特巡的故障汇报', N'', NULL, 0, NULL, NULL, CAST(N'2019-11-25T16:44:32.703' AS DateTime), 3, CAST(N'2019-11-25T10:32:30.127' AS DateTime), 3, CAST(2.50 AS Decimal(18, 2)), 1)
    101. 

  101. ,(N'cca232cfc4bb48f8bcc34fe7a579f9e8', N'内部短路', N'93449fb1f34a4fb4bc55fb1388ab192c', N'内部短路', N'故障原因', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:08:07.787' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    102. 

  102. ,(N'd0a5fadeeb134359a2443042b464a39e', N'低压断线', N'93449fb1f34a4fb4bc55fb1388ab192c', N'低压断线', N'故障原因', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:08:55.647' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    103. 

  103. ,(N'd7690364d0a14358aa6d89168263f87b', N'低压桩头烧坏', N'93449fb1f34a4fb4bc55fb1388ab192c', N'低压桩头烧坏', N'故障原因', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:05:28.790' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    104. 

  104. ,(N'd8749e323d9c48f8938c0e2771af9256', N'登记工单时间', N'62128527e89a4554b35f7828c4612fea', N'记录工单时间', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T10:25:27.203' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    105. 

  105. ,(N'dcc95bb16cde4d69bb83acf8c1b71714', N'区大联动', N'33145ea66eb1402abd35dab45ec5c626', N'区大联动', N'信息来源', NULL, 0, NULL, NULL, CAST(N'2019-11-25T12:53:11.943' AS DateTime), 3, CAST(N'2019-11-20T17:15:44.750' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    106. 

  106. ,(N'dd8c532474394fb8a8153a4c63e2ddc1', N'确认复役操作完成', N'2a00168d3b8f4cb19ea7f6bdad0ec4e3', N'确认复役操作完成', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:40:34.797' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    107. 

  107. ,(N'e05c8d764fd04340a8837b279ab8c8fe', N'外观无异常', N'93449fb1f34a4fb4bc55fb1388ab192c', N'外观无异常', N'故障原因', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:08:27.437' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    108. 

  108. ,(N'e38b57cdb4ed4853b1446c18914bc3e1', N'区大联动', N'ad0fe0ab6c3b4154991eda86e2172885', N'区大联动', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:45:22.387' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    109. 

  109. ,(N'e4d840f910b540e9ab5945931ad6b7cf', N'外观碰撞变形', N'93449fb1f34a4fb4bc55fb1388ab192c', N'外观碰撞变形', N'故障原因', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:07:33.887' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    110. 

  110. ,(N'e714c22114394ae688603b0dde04d226', N'绿化水务公路', N'33145ea66eb1402abd35dab45ec5c626', N'绿化水务公路', N'信息来源', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T12:51:59.570' AS DateTime), 3, CAST(2.00 AS Decimal(18, 2)), 1)
    111. 

  111. ,(N'eae41107ff6a4a3c921127d9202bbeef', N'119消防', N'ad0fe0ab6c3b4154991eda86e2172885', N'119消防', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:46:00.807' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    112. 

  112. ,(N'ed77c9837d924f179808684942937cc5', N'110公安', N'ad0fe0ab6c3b4154991eda86e2172885', N'110公安', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:45:42.377' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    113. 

  113. ,(N'efa86ce6bdf24a08a8dd0509687b161d', N'确认各环节时间', N'9e786f90283c483faa2bbb64e29990cb', N'确认各环节时间', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:53:21.600' AS DateTime), 3, CAST(1.00 AS Decimal(18, 2)), 1)
    114. 

  114. ,(N'f8049aa05a51458e84990ebd24697bf0', N'12345热线', N'ad0fe0ab6c3b4154991eda86e2172885', N'12345热线', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:46:33.760' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 1)
    115. 

  115. ,(N'fe047fe235bc45f39bff8a9334a5ece3', N'开具抢修工作票', N'd617300146f74e45883a4316eec18411', N'开具抢修工作票', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T13:07:03.527' AS DateTime), 3, CAST(5.00 AS Decimal(18, 2)), 6)
    116. 

  116. ,(N'febbdabe2e60440096eb4d4c91ae23cb', N'统计故障原因并留档', N'f2d2b7c2970e49b9b9cb224857ed3c10', N'统计故障原因并留档', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T14:54:38.660' AS DateTime), 3, CAST(1.00 AS Decimal(18, 2)), 1)
    117. 

  117. ,(N'ffc80f7cc3c84ae580c40da89cef1478', N'定位故障', N'e53c87722e1b4fd3b5a84155ad8287e3', N'根据特巡人员手机GPS定位，供电服务指挥员在规划平台地图上精确定位', N'', NULL, 0, NULL, NULL, NULL, NULL, CAST(N'2019-11-25T10:31:49.517' AS DateTime), 3, CAST(2.50 AS Decimal(18, 2)), 1)
    118. 

  118. GO
    119. 

  119. 

  120. 

  121. 

  122.   */
    123. 

  123. 

  124. 

  125. 

  126.   SELECT *   FROM [dbo].[Rc_FaultProcessInfos] ORDER BY DEPTH
    127. 

  127. 

  128. 

  129.   /*
    130. 

  130. 

  131.   
    132. 

  132.   INSERT 
    133. 

  133. [dbo].[Rc_FaultProcessInfos] ([Id], [Pid], [Name], [Depth], [Description], [Score], [Tags], [FaultTypeId], [EmergencyType], [LogicType],[IsDeleted], [CreationTime]) VALUES  
    134. 

  134.   (N'33145ea66eb1402abd35dab45ec5c626', NULL, N'确认报修信息', 1, N'接到电网故障报修，确认报修信息来源：【如95598、区大联动（根据勾选，可单选或多选）】', CAST(2.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 1, 2,0, N'{date}')
    135. 

  135. , (N'1eb190f0d78d4d5b99c95cf3a341a810', N'33145ea66eb1402abd35dab45ec5c626', N'询问故障信息', 2, N'供电服务指挥员询问供电舆情、特殊用户是否用电、故障地点核对', CAST(6.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 1, 1,0, N'{date}')
    136. 

  136. , (N'62128527e89a4554b35f7828c4612fea', N'1eb190f0d78d4d5b99c95cf3a341a810', N'登记工单', 3, N'指挥员工接单登记收到时间。', CAST(2.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 1, 1,0, N'{date}')
    137. 

  137. , (N'3a3cc6267039472b8309582f38f411e5', N'62128527e89a4554b35f7828c4612fea', N'指派特巡人员', 4, N'指挥员指派故障特巡人员。', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 1, 1,0, N'{date}')
    138. 

  138. , (N'd8ea757fe6bb4b48a2040581b196f139', N'3a3cc6267039472b8309582f38f411e5', N'通知抢修队伍待命', 5, N'指挥员预通知抢修队伍和许可人待命。', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 1, 1,0, N'{date}')
    139. 

  139. , (N'e53c87722e1b4fd3b5a84155ad8287e3', N'd8ea757fe6bb4b48a2040581b196f139', N'接收特巡汇报', 6, N'根据特巡人员手机GPS定位，供电服务指挥员在规划平台地图上精确定位，接收特巡汇报。', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 1, 1,0, N'{date}')
    140. 

  140. , (N'93449fb1f34a4fb4bc55fb1388ab192c', N'e53c87722e1b4fd3b5a84155ad8287e3', N'研判故障原因', 7, N'指挥员结合巡视人员的单兵画面，研判故障原因，并在工单上登记故障原因，形成抢修方案和安全措施。', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 1, 2,0, N'{date}')
    141. 

  141. , (N'cb7b2080cebd480bb1f23c18455d4b80', N'93449fb1f34a4fb4bc55fb1388ab192c', N'通知抢修队伍', 8, N'供电服务指挥员通知抢修队伍、许可人和物资仓库，特别说明吊车是否到位。', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 2, 1,0, N'{date}')
    142. 

  142. , (N'd617300146f74e45883a4316eec18411', N'cb7b2080cebd480bb1f23c18455d4b80', N'开具抢修工作票', 9, N'供电服务指挥员电话通知抢修队伍负责人，根据抢修方案和安全措施，开具抢修工作票，双方核对一致。', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 2, 1,0, N'{date}')
    143. 

  143. , (N'6c56594250aa426cb2ce5c4f230309e6', N'd617300146f74e45883a4316eec18411', N'监控抢修队伍', 10, N'监控抢修队伍行车轨迹、路程进度。', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 2, 1,0, N'{date}')
    144. 

  144. , (N'34eceac8b08c45f79e883ccfdf7e4cbb', N'6c56594250aa426cb2ce5c4f230309e6', N'开具抢修操作票', 11, N'供电服务指挥员开具抢修操作票，并和现场许可人核对正确。', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 2, 1,0, N'{date}')
    145. 

  145. , (N'07ae3ebb45244fd380a7470f440bd86c', N'34eceac8b08c45f79e883ccfdf7e4cbb', N'发布停役操作指令', 12, N'指挥员发布停役操作指令给现场许可人。', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 2, 1,0, N'{date}')
    146. 

  146. , (N'ecdb4597c3a040308e3cd318176485a1', N'07ae3ebb45244fd380a7470f440bd86c', N'接受停役完成汇报', 13, N'接受停役完成汇报', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 2, 1,0, N'{date}')
    147. 

  147. , (N'25dd15a67ebd4bfdaaefad67fc6c481c', N'ecdb4597c3a040308e3cd318176485a1', N'许可开始抢修工作', 14, N'许可给现场许可人，抢修工作开始', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 2, 1,0, N'{date}')
    148. 

  148. , (N'98126bf7c1ee410a840a5f8b78e4bfff', N'25dd15a67ebd4bfdaaefad67fc6c481c', N'监控抢修全过程', 15, N'指挥员利用单兵对抢修全过程监控、危险点提示', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 2, 1,0, N'{date}')
    149. 

  149. , (N'1796f27a4876474787c7a171fd89b583', N'98126bf7c1ee410a840a5f8b78e4bfff', N'接受抢修工作结束汇报', 16, N'抢修工作结束汇报', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 2, 1,0, N'{date}')
    150. 

  150. , (N'2a00168d3b8f4cb19ea7f6bdad0ec4e3', N'1796f27a4876474787c7a171fd89b583', N'核对复役操作票，发令复役操作', 17, N'核对复役操作票，发令复役操作', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 2, 1,0, N'{date}')
    151. 

  151. , (N'05279ddf031f4885b89feddfd0515dfa', N'2a00168d3b8f4cb19ea7f6bdad0ec4e3', N'接受现场操作结束汇报', 18, N'指挥员接受现场许可人操作结束汇报，并确认已全部恢复供电。', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 2, 1,0, N'{date}')
    152. 

  152. , (N'ad0fe0ab6c3b4154991eda86e2172885', N'05279ddf031f4885b89feddfd0515dfa', N'结束抢修回复', 19, N'指挥员结束抢修回复：95598工单闭环、区大联动、110公安、119消防、绿化水务公路、12345热线、其他（根据勾选）', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 3, 2,0, N'{date}')
    153. 

  153. , (N'37358f7425844ce18c45f8b73bc8d98e', N'ad0fe0ab6c3b4154991eda86e2172885', N'应急处置回复', 20, N'指挥员应急处置回复：舆情方面办公室、营销、区大联动，应急发电方面运检部', CAST(5.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 3, 1,0, N'{date}')
    154. 

  154. , (N'9e786f90283c483faa2bbb64e29990cb', N'37358f7425844ce18c45f8b73bc8d98e', N'抢修时间确认', 21, N'由系统分阶段统计接报至人员到达时间、接到报修至修复送电时间、各环节时间', CAST(3.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 3, 1,0, N'{date}')
    155. 

  155. , (N'f2d2b7c2970e49b9b9cb224857ed3c10', N'9e786f90283c483faa2bbb64e29990cb', N'故障原因分析', 22, N'统计故障原因并留档，可以分析一段时间内造成杆变故障的多发原因，运维检修中加以重点关注。', CAST(2.00 AS Decimal(18, 2)), N'', N'{faultTypeId}', 3, 1,0, N'{date}')
    156. 

  156. 

  157. 

  158. 

  159. INSERT 
    160. 

  160. [dbo].[Rc_FaultProcessActionInfos] ([Id], [Name], [ProcessId], [Description], [Tags],[IsDeleted], [CreationTime],  [Score], [Type]) VALUES 
    161. 

  161. (N'00a4d374647145bfab11d36132783b7b', N'高压桩头烧坏', N'93449fb1f34a4fb4bc55fb1388ab192c', N'高压桩头烧坏', N'故障原因',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    162. 

  162. ,(N'0692c7fa4bae46eaae1d92474170398c', N'发布开始抢修指令', N'25dd15a67ebd4bfdaaefad67fc6c481c', N'发布开始抢修指令', N'',0, N'{date}',  CAST(5.00 AS Decimal(18, 2)), 1)
    163. 

  163. ,(N'09aeed8f2c7643e98c74f7d6da3fe90d', N'抢修危险点提示', N'98126bf7c1ee410a840a5f8b78e4bfff', N'危险点提示', N'',0, N'{date}',  CAST(2.00 AS Decimal(18, 2)), 1)
    164. 

  164. ,(N'0c2e1c047cc54715bffe2f0cfd624c36', N'开具核对抢修操作票', N'34eceac8b08c45f79e883ccfdf7e4cbb', N'开具抢修操作票', N'',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 5)
    165. 

  165. ,(N'12a64b3a9cd340af85fe97c9f907f983', N'杆变漏油', N'93449fb1f34a4fb4bc55fb1388ab192c', N'杆变漏油', N'故障原因',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    166. 

  166. ,(N'147ebd7c707e43a7b6e4699e79cec7b3', N'回复区大联动部门', N'37358f7425844ce18c45f8b73bc8d98e', N'回复区大联动部门', N'',0, N'{date}', CAST(1.00 AS Decimal(18, 2)), 1)
    167. 

  167. ,(N'16d1247462b04bcf9996f8e32afdd23b', N'接受操作结束汇报', N'05279ddf031f4885b89feddfd0515dfa', N'接受现场许可人操作结束汇报', N'',0, N'{date}',  CAST(3.00 AS Decimal(18, 2)), 1)
    168. 

  168. ,(N'18e89f3a54c54222880313f5c2962458', N'SCADA', N'33145ea66eb1402abd35dab45ec5c626', N'SCADA', N'信息来源',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    169. 

  169. ,(N'1a2531107e6e4df7a4ea54abc361b4d6', N'确认接报至修复送电时间', N'9e786f90283c483faa2bbb64e29990cb', N'确认接报至修复送电时间', N'',0, N'{date}', CAST(1.00 AS Decimal(18, 2)), 1)
    170. 

  170. ,(N'22f08116cc53483fa6df68e6ef5b05ce', N'其他 ', N'33145ea66eb1402abd35dab45ec5c626', N'其他 ', N'信息来源',0, N'{date}',CAST(2.00 AS Decimal(18, 2)), 1)
    171. 

  171. ,(N'29895c431f31412e84ed50ded02e5589', N'确认已全部恢复供电', N'05279ddf031f4885b89feddfd0515dfa', N'确认已全部恢复供电', N'',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    172. 

  172. ,(N'2a90c2f080994d7ca99670737035c37b', N'通知抢修队伍、许可人和物资仓库', N'cb7b2080cebd480bb1f23c18455d4b80', N'供电服务指挥员通知抢修队伍、许可人和物资仓库', N'',0, N'{date}', CAST(3.00 AS Decimal(18, 2)), 1)
    173. 

  173. ,(N'2d10965550bf4f068525fba57081fd08', N'巡查故障', N'3a3cc6267039472b8309582f38f411e5', N'指派特巡人员巡查故障', N'',0, N'{date}',  CAST(5.00 AS Decimal(18, 2)), 1)
    174. 

  174. ,(N'34ce265ec67845f7ac19121177c7fc86', N'核对复役操作票', N'2a00168d3b8f4cb19ea7f6bdad0ec4e3', N'核对复役操作票', N'',0, N'{date}', CAST(3.00 AS Decimal(18, 2)), 4)
    175. 

  175. ,(N'3b85fb7fdf48426b8c3a7e15e10c23df', N'接受停役完成汇报', N'ecdb4597c3a040308e3cd318176485a1', N'接受完成汇报', N'',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    176. 

  176. ,(N'3c194b058bb84d8f87166355213fae46', N'119消防', N'33145ea66eb1402abd35dab45ec5c626', N'119消防', N'信息来源',0, N'{date}',  CAST(2.00 AS Decimal(18, 2)), 1)
    177. 

  177. ,(N'3ec086d3e12949c09a506b8cb0e17d09', N'询问抢修队伍路程进度', N'6c56594250aa426cb2ce5c4f230309e6', N'询问抢修队伍路程进度', N'',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    178. 

  178. ,(N'3fbe69db2dc54097b4e222de57682530', N'其他原因', N'93449fb1f34a4fb4bc55fb1388ab192c', N'其他原因', N'故障原因',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    179. 

  179. ,(N'40a24638513b40c0bce06a19434f3ccf', N'台区总表', N'33145ea66eb1402abd35dab45ec5c626', N'台区总表', N'信息来源',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    180. 

  180. ,(N'4b9fd05863a14455a7d9326218ca07bd', N'回复应急发电方面运检部', N'37358f7425844ce18c45f8b73bc8d98e', N'回复应急发电方面运检部', N'',0, N'{date}', CAST(1.00 AS Decimal(18, 2)), 1)
    181. 

  181. ,(N'4da9c84be4604398b2ce6dbf3404c6c4', N'其他', N'ad0fe0ab6c3b4154991eda86e2172885', N'其他', N'',0, N'{date}',CAST(5.00 AS Decimal(18, 2)), 1)
    182. 

  182. ,(N'51417925e8274177a8f029b8324b9da1', N'分析一段时间内造成杆变故障的多发原因', N'f2d2b7c2970e49b9b9cb224857ed3c10', N'分析一段时间内造成杆变故障的多发原因，运维检修中加以重点关注', N'',0, N'{date}', CAST(1.00 AS Decimal(18, 2)), 1)
    183. 

  183. ,(N'541f01e7485d4c71a1451ffb856f6fec', N'发布停役操作指令', N'07ae3ebb45244fd380a7470f440bd86c', N'发布停役操作指令', N'',0, N'{date}',  CAST(5.00 AS Decimal(18, 2)), 1)
    184. 

  184. ,(N'5585bcad958f4cb4bdb842f2364bd9d2', N'低压断杆', N'93449fb1f34a4fb4bc55fb1388ab192c', N'低压断杆', N'故障原因',0, N'{date}',  CAST(5.00 AS Decimal(18, 2)), 1)
    185. 

  185. ,(N'6376d118dcc548ed9124ec39868420db', N'询问特殊用户是否用电', N'1eb190f0d78d4d5b99c95cf3a341a810', N'询问特殊用户是否用电', N'',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    186. 

  186. ,(N'6acbbc3cbba348009cd3b0124509e1da', N'确认吊车是否到位', N'cb7b2080cebd480bb1f23c18455d4b80', N'吊车是否到位', N'',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    187. 

  187. ,(N'721ece0dfb4046718cfb39d9d6aaad4e', N'故障地点核对', N'1eb190f0d78d4d5b99c95cf3a341a810', N'故障地点核对', N'',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    188. 

  188. ,(N'7a1c7735551b46428e14cb240804ac30', N'回复营销部门', N'37358f7425844ce18c45f8b73bc8d98e', N'回复营销部门', N'',0, N'{date}',  CAST(1.00 AS Decimal(18, 2)), 1)
    189. 

  189. ,(N'7df815ebe171472698265d8d3dea202f', N'回复舆情方面办公室', N'37358f7425844ce18c45f8b73bc8d98e', N'回复舆情方面办公室', N'',0, N'{date}',  CAST(2.00 AS Decimal(18, 2)), 1)
    190. 

  190. ,(N'8ddf4c36ac7b4a6eb78bff9163685e0b', N'低压导线缠绕', N'93449fb1f34a4fb4bc55fb1388ab192c', N'低压导线缠绕', N'故障原因',0, N'{date}',  CAST(5.00 AS Decimal(18, 2)), 1)
    191. 

  191. ,(N'a0bb4c81b96544e38b5c599143738458', N'监控抢修过程', N'98126bf7c1ee410a840a5f8b78e4bfff', N'监控抢修全过程', N'',0, N'{date}', CAST(3.00 AS Decimal(18, 2)), 1)
    192. 

  192. ,(N'a24e0646adbd40b6adb3d326cfe21f93', N'95598', N'33145ea66eb1402abd35dab45ec5c626', N'95598', N'信息来源' ,0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    193. 

  193. ,(N'a75286a98a23488ab5a78dbf1948826f', N'接受抢修工作结束汇报', N'1796f27a4876474787c7a171fd89b583', N'接受抢修工作结束汇报', N'', 0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    194. 

  194. ,(N'abc04cebdd074eed8ea9a56b25c34b4b', N'110公安', N'33145ea66eb1402abd35dab45ec5c626', N'110公安', N'信息来源',0, N'{date}',CAST(2.00 AS Decimal(18, 2)), 1)
    195. 

  195. ,(N'ac982a53dd1c45d9b1dba5da653a000a', N'低压绝缘子坏', N'93449fb1f34a4fb4bc55fb1388ab192c', N'低压绝缘子坏', N'故障原因',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    196. 

  196. ,(N'afd426a59c9d465e9560b600b79534a0', N'抢修队伍待命', N'd8ea757fe6bb4b48a2040581b196f139', N'通知抢险队伍待命', N'',0, N'{date}',  CAST(5.00 AS Decimal(18, 2)), 2)
    197. 

  197. ,(N'bb11a2f488674982a1d8397b03ba3a8d', N'确认接报至人员到达时间', N'9e786f90283c483faa2bbb64e29990cb', N'接报至人员到达时间', N'',0, N'{date}',  CAST(1.00 AS Decimal(18, 2)), 1)
    198. 

  198. ,(N'be0f9992815547628cefbbb08f80bce1', N'12345热线', N'33145ea66eb1402abd35dab45ec5c626', N'12345热线', N'信息来源',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    199. 

  199. ,(N'beb398b337f64bf689c00d6523ced125', N'95598工单闭环', N'ad0fe0ab6c3b4154991eda86e2172885', N'95598工单闭环', N'',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    200. 

  200. ,(N'c1bf9ba794ec4df69d9a13015794134f', N'绿化水务公路', N'ad0fe0ab6c3b4154991eda86e2172885', N'绿化水务公路', N'',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    201. 

  201. ,(N'c6cf19e89509479da6ca61f233322a0d', N'询问供电舆情', N'1eb190f0d78d4d5b99c95cf3a341a810', N'询问供电舆情', N'',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    202. 

  202. ,(N'c7e3f4d9178b49e2944538a0817d64c0', N'高压熔丝跌落', N'93449fb1f34a4fb4bc55fb1388ab192c', N'高压熔丝跌落', N'故障原因',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    203. 

  203. ,(N'c89e2df49cb14970a79373e4de27295a', N'监控抢修队伍行车轨迹', N'6c56594250aa426cb2ce5c4f230309e6', N'监控抢修队伍行车轨迹', N'',0, N'{date}', CAST(3.00 AS Decimal(18, 2)), 1)
    204. 

  204. ,(N'cbd8ade9f86a4640bb370a707c7c595b', N'接受故障汇报', N'e53c87722e1b4fd3b5a84155ad8287e3', N'接受特巡的故障汇报', N'',0, N'{date}', CAST(2.50 AS Decimal(18, 2)), 1)
    205. 

  205. ,(N'cca232cfc4bb48f8bcc34fe7a579f9e8', N'内部短路', N'93449fb1f34a4fb4bc55fb1388ab192c', N'内部短路', N'故障原因',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    206. 

  206. ,(N'd0a5fadeeb134359a2443042b464a39e', N'低压断线', N'93449fb1f34a4fb4bc55fb1388ab192c', N'低压断线', N'故障原因',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    207. 

  207. ,(N'd7690364d0a14358aa6d89168263f87b', N'低压桩头烧坏', N'93449fb1f34a4fb4bc55fb1388ab192c', N'低压桩头烧坏', N'故障原因',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    208. 

  208. ,(N'd8749e323d9c48f8938c0e2771af9256', N'登记工单时间', N'62128527e89a4554b35f7828c4612fea', N'记录工单时间', N'',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    209. 

  209. ,(N'dcc95bb16cde4d69bb83acf8c1b71714', N'区大联动', N'33145ea66eb1402abd35dab45ec5c626', N'区大联动', N'信息来源',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    210. 

  210. ,(N'dd8c532474394fb8a8153a4c63e2ddc1', N'确认复役操作完成', N'2a00168d3b8f4cb19ea7f6bdad0ec4e3', N'确认复役操作完成', N'',0, N'{date}', CAST(2.00 AS Decimal(18, 2)), 1)
    211. 

  211. ,(N'e05c8d764fd04340a8837b279ab8c8fe', N'外观无异常', N'93449fb1f34a4fb4bc55fb1388ab192c', N'外观无异常', N'故障原因',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    212. 

  212. ,(N'e38b57cdb4ed4853b1446c18914bc3e1', N'区大联动', N'ad0fe0ab6c3b4154991eda86e2172885', N'区大联动', N'',0, N'{date}',  CAST(5.00 AS Decimal(18, 2)), 1)
    213. 

  213. ,(N'e4d840f910b540e9ab5945931ad6b7cf', N'外观碰撞变形', N'93449fb1f34a4fb4bc55fb1388ab192c', N'外观碰撞变形', N'故障原因',0, N'{date}',  CAST(5.00 AS Decimal(18, 2)), 1)
    214. 

  214. ,(N'e714c22114394ae688603b0dde04d226', N'绿化水务公路', N'33145ea66eb1402abd35dab45ec5c626', N'绿化水务公路', N'信息来源',0, N'{date}',  CAST(2.00 AS Decimal(18, 2)), 1)
    215. 

  215. ,(N'eae41107ff6a4a3c921127d9202bbeef', N'119消防', N'ad0fe0ab6c3b4154991eda86e2172885', N'119消防', N'',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 1)
    216. 

  216. ,(N'ed77c9837d924f179808684942937cc5', N'110公安', N'ad0fe0ab6c3b4154991eda86e2172885', N'110公安', N'',0, N'{date}',  CAST(5.00 AS Decimal(18, 2)), 1)
    217. 

  217. ,(N'efa86ce6bdf24a08a8dd0509687b161d', N'确认各环节时间', N'9e786f90283c483faa2bbb64e29990cb', N'确认各环节时间', N'',0, N'{date}', CAST(1.00 AS Decimal(18, 2)), 1)
    218. 

  218. ,(N'f8049aa05a51458e84990ebd24697bf0', N'12345热线', N'ad0fe0ab6c3b4154991eda86e2172885', N'12345热线', N'',0, N'{date}',  CAST(5.00 AS Decimal(18, 2)), 1)
    219. 

  219. ,(N'fe047fe235bc45f39bff8a9334a5ece3', N'开具抢修工作票', N'd617300146f74e45883a4316eec18411', N'开具抢修工作票', N'',0, N'{date}', CAST(5.00 AS Decimal(18, 2)), 6)
    220. 

  220. ,(N'febbdabe2e60440096eb4d4c91ae23cb', N'统计故障原因并留档', N'f2d2b7c2970e49b9b9cb224857ed3c10', N'统计故障原因并留档', N'',0, N'{date}', CAST(1.00 AS Decimal(18, 2)), 1)
    221. 

  221. ,(N'ffc80f7cc3c84ae580c40da89cef1478', N'定位故障', N'e53c87722e1b4fd3b5a84155ad8287e3', N'根据特巡人员手机GPS定位，供电服务指挥员在规划平台地图上精确定位', N'',0, N'{date}', CAST(2.50 AS Decimal(18, 2)), 1)
    222. 

  222. 

  223. 

  224.   */
    225.