404 lines
42 KiB
Transact-SQL
404 lines
42 KiB
Transact-SQL
--cd C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.8 Tools
|
||
--SqlMetal /views /server:WQ /database:SGGLDB_WH /code:C:\Model.cs /namespace:Model
|
||
|
||
--老数据清理
|
||
--truncate table PreRun_SubInspectTerm
|
||
--truncate table PreRun_SubInspectTermItem
|
||
--truncate table PreRun_InspectTailTerm
|
||
--truncate table PreRun_InspectTermApproveRecords
|
||
|
||
--预试车菜单名称调整
|
||
delete Sys_Menu where MenuId='5C07E135-C3AB-4CE4-97A2-C79970640272'
|
||
delete Sys_Menu where MenuId='B4702BFB-8CEB-46AD-BDC0-751D146FE228'
|
||
delete Sys_Menu where MenuId='34719347-E5EE-4491-9E92-B1270C187C7F'
|
||
delete Sys_Menu where MenuId='F0E06491-B1DA-4510-ABCA-D09F4B24EE50'
|
||
delete Sys_Menu where MenuId='3B60BB5F-A000-40FC-9C7F-D4AE28EB2EB3'
|
||
delete Sys_Menu where MenuId='D9D90BA4-BF34-4045-977F-DCE9D507F40F'
|
||
delete Sys_Menu where MenuId='150A6D3D-CAA2-4246-947C-6730A18BCC83'
|
||
delete Sys_Menu where MenuId='B6A6EA7D-EDAB-40C8-920D-A106731D0E08'
|
||
delete Sys_Menu where MenuId='F7A324D0-2410-4B37-858C-10F0A3059C90'
|
||
delete Sys_Menu where MenuId='8542644D-BD9B-4188-9FDE-AE5D6D6D9A40'
|
||
delete Sys_Menu where MenuId='2254D22A-94EF-435F-9916-F07BD7082689'
|
||
delete Sys_Menu where MenuId='F184E0FC-96E3-48A5-9515-21EAD37053B3'
|
||
delete Sys_Menu where MenuId='19865B64-E0AA-4D32-9712-05C14FE6288F'
|
||
delete Sys_Menu where MenuId='AF88737F-D665-4C81-99D5-A07A8910C1E0'
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('5C07E135-C3AB-4CE4-97A2-C79970640272','系统划分',null,'TestRun/BeforeTestRun/DeviceRun.aspx',1,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('B4702BFB-8CEB-46AD-BDC0-751D146FE228','工作包设置',null,'TestRun/BeforeTestRun/SetWorkPackage.aspx',2,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('34719347-E5EE-4491-9E92-B1270C187C7F','工作包裁剪',null,'TestRun/BeforeTestRun/SubSysWorkPackage.aspx',3,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('F0E06491-B1DA-4510-ABCA-D09F4B24EE50','管道和设备导入',null,'TestRun/BeforeTestRun/SysPipingDeviceImport.aspx',4,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('3B60BB5F-A000-40FC-9C7F-D4AE28EB2EB3','检查表模板',null,'TestRun/BeforeTestRun/InspectTemplate.aspx',5,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('D9D90BA4-BF34-4045-977F-DCE9D507F40F','生成工作包检查表',null,'TestRun/BeforeTestRun/SubInspectTerm.aspx',6,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('150A6D3D-CAA2-4246-947C-6730A18BCC83','检查表条件确认',null,'TestRun/BeforeTestRun/SubWorkInspect.aspx',7,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('B6A6EA7D-EDAB-40C8-920D-A106731D0E08','检查表尾项管理',null,'TestRun/BeforeTestRun/InspectTailTermList.aspx',8,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('F7A324D0-2410-4B37-858C-10F0A3059C90','尾项处理',null,'TestRun/BeforeTestRun/TailTermHandleList.aspx',9,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('8542644D-BD9B-4188-9FDE-AE5D6D6D9A40','尾项审核',null,'TestRun/BeforeTestRun/TailTermApproveList.aspx',10,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('2254D22A-94EF-435F-9916-F07BD7082689','检查表会签',null,'TestRun/BeforeTestRun/InspectWanderAboutList.aspx',11,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('AF88737F-D665-4C81-99D5-A07A8910C1E0','检查表流转全部通过',null,'TestRun/BeforeTestRun/InspectWanderAboutAllPassList.aspx',12,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('F184E0FC-96E3-48A5-9515-21EAD37053B3','现场实施',null,'TestRun/BeforeTestRun/SiteImplementationList.aspx',13,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('19865B64-E0AA-4D32-9712-05C14FE6288F','试车记录上传',null,'TestRun/BeforeTestRun/TestRunRecordUploadList.aspx',14,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
go
|
||
|
||
--试车新增菜单
|
||
delete Sys_Menu where MenuId in ('E3E38073-1DF4-4C02-AFC0-5C93EE7C23A8','4B964B32-D5CC-48A2-8750-48BC4460C264','B6EE8E3B-77E2-416E-8985-3C78A2169B89','AF2B0CAD-DE15-4F15-A5EE-C8FB558D00C8','545AACE6-34BE-4BAA-A495-B73198F1BDE2','086DBD12-5649-4330-807A-44ABB257495F','A593B611-82C1-40D8-BB6A-DD025DB62F8C')
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('E3E38073-1DF4-4C02-AFC0-5C93EE7C23A8','系统划分',null,'TestRun/TestRunManage/DeviceRun.aspx',1,'0217CE50-3ABB-44F8-A38A-C9792C436639','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('4B964B32-D5CC-48A2-8750-48BC4460C264','工作包设置',null,'TestRun/TestRunManage/SetWorkPackage.aspx',2,'0217CE50-3ABB-44F8-A38A-C9792C436639','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('B6EE8E3B-77E2-416E-8985-3C78A2169B89','工作包裁剪',null,'TestRun/TestRunManage/SubSysWorkPackage.aspx',3,'0217CE50-3ABB-44F8-A38A-C9792C436639','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('AF2B0CAD-DE15-4F15-A5EE-C8FB558D00C8','检查项分组信息',null,'TestRun/TestRunManage/TemplateItemGroup.aspx',4,'0217CE50-3ABB-44F8-A38A-C9792C436639','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('545AACE6-34BE-4BAA-A495-B73198F1BDE2','检查表模板',null,'TestRun/TestRunManage/InspectTemplate.aspx',5,'0217CE50-3ABB-44F8-A38A-C9792C436639','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('086DBD12-5649-4330-807A-44ABB257495F','联动试车管理',null,'TestRun/TestRunManage/SubInspectTerm.aspx',6,'0217CE50-3ABB-44F8-A38A-C9792C436639','Menu_TestRun',0,1,1)
|
||
go
|
||
|
||
--==试车工作包设置
|
||
if object_id(N'TestRun_WorkPackage',N'U') is not null
|
||
drop table dbo.TestRun_WorkPackage
|
||
CREATE TABLE dbo.TestRun_WorkPackage(
|
||
WorkPackId varchar(50) NOT NULL,--主键
|
||
WorkPackName varchar(50) NULL,--名称
|
||
Remark nvarchar(150) NULL,--备注
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_TestRun_WorkPackage PRIMARY KEY CLUSTERED
|
||
(
|
||
WorkPackId ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
--试车默认数据添加
|
||
delete TestRun_WorkPackage where WorkPackId='1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6'
|
||
delete TestRun_WorkPackage where WorkPackId='939C7A82-78ED-4479-963A-D38C9D719C99'
|
||
delete TestRun_WorkPackage where WorkPackId='F658371C-CF99-4774-B1AC-EAD737AD8074'
|
||
delete TestRun_WorkPackage where WorkPackId='FF3C10D2-822E-4CF4-BE50-AB69181075B5'
|
||
delete TestRun_WorkPackage where WorkPackId='82ED8240-AA40-4CEB-80E0-B3DF14FFC284'
|
||
INSERT INTO dbo.TestRun_WorkPackage(WorkPackId,WorkPackName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','蒸汽发生器煮炉','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkPackage(WorkPackId,WorkPackName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('939C7A82-78ED-4479-963A-D38C9D719C99','设备、管道系统钝化','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkPackage(WorkPackId,WorkPackName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('F658371C-CF99-4774-B1AC-EAD737AD8074','单元或系统模拟运行','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkPackage(WorkPackId,WorkPackName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('FF3C10D2-822E-4CF4-BE50-AB69181075B5','联动试车','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkPackage(WorkPackId,WorkPackName,Remark,AddUser,AddTime,Sort)
|
||
VALUES('82ED8240-AA40-4CEB-80E0-B3DF14FFC284','氮气干燥置换','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),5)
|
||
go
|
||
|
||
--==试车系统工作包管理
|
||
if object_id(N'TestRun_SubSysWorkPackage',N'U') is not null
|
||
drop table dbo.TestRun_SubSysWorkPackage
|
||
CREATE TABLE dbo.TestRun_SubSysWorkPackage(
|
||
SubSysId varchar(50) NOT NULL,--主键
|
||
SystemId varchar(50) NULL,--系统主键
|
||
WorkPackId varchar(50) NULL,--工作包主键
|
||
WorkPackCode varchar(50) NULL,--工作包Code
|
||
Remark nvarchar(150) NULL,--备注
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_TestRun_SubSysWorkPackage PRIMARY KEY CLUSTERED
|
||
(
|
||
SubSysId ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
--==试车检查模板项分组信息
|
||
if object_id(N'TestRun_TemplateItemGroup',N'U') is not null
|
||
drop table dbo.TestRun_TemplateItemGroup
|
||
CREATE TABLE dbo.TestRun_TemplateItemGroup(
|
||
GroupId varchar(50) NOT NULL,--主键
|
||
GroupName varchar(500) NULL,--名称
|
||
Remark nvarchar(150) NULL,--备注
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_TestRun_TemplateItemGroup PRIMARY KEY CLUSTERED
|
||
(
|
||
GroupId ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
--默认数据添加
|
||
delete TestRun_TemplateItemGroup where GroupId in ('D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','962116EB-E367-42D9-ACD5-4590D5E623A0','EEE07FFC-EB58-43C0-AFD6-DCF5B0B0AE7E','816C8571-A275-4064-8165-B13FA459F5E1','CA8AC7B3-F6F9-47EB-A82F-827A07FE63DE','32641418-4622-4D48-B5CD-88B4FAAF1A5E','C391B309-74A5-415A-940C-A41014631F12','5390ECFB-64FF-4332-9B9D-21777CF7BD3C','76B784BB-6415-4A5B-81CF-08ABDB4A5152')
|
||
INSERT INTO dbo.TestRun_TemplateItemGroup(GroupId,GroupName,Remark,AddUser,AddTime,Sort)VALUES('D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','蒸汽发生器煮炉','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_TemplateItemGroup(GroupId,GroupName,Remark,AddUser,AddTime,Sort)VALUES('962116EB-E367-42D9-ACD5-4590D5E623A0','设备、管道系统','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_TemplateItemGroup(GroupId,GroupName,Remark,AddUser,AddTime,Sort)VALUES('EEE07FFC-EB58-43C0-AFD6-DCF5B0B0AE7E','电仪系统','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_TemplateItemGroup(GroupId,GroupName,Remark,AddUser,AddTime,Sort)VALUES('816C8571-A275-4064-8165-B13FA459F5E1','公用系统','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_TemplateItemGroup(GroupId,GroupName,Remark,AddUser,AddTime,Sort)VALUES('CA8AC7B3-F6F9-47EB-A82F-827A07FE63DE','消防、安全、环境保护系统','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),5)
|
||
INSERT INTO dbo.TestRun_TemplateItemGroup(GroupId,GroupName,Remark,AddUser,AddTime,Sort)VALUES('32641418-4622-4D48-B5CD-88B4FAAF1A5E','分析化验','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),6)
|
||
INSERT INTO dbo.TestRun_TemplateItemGroup(GroupId,GroupName,Remark,AddUser,AddTime,Sort)VALUES('C391B309-74A5-415A-940C-A41014631F12','组织、人员、通讯、方案、规定','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),7)
|
||
INSERT INTO dbo.TestRun_TemplateItemGroup(GroupId,GroupName,Remark,AddUser,AddTime,Sort)VALUES('5390ECFB-64FF-4332-9B9D-21777CF7BD3C','保运、后勤保障','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),8)
|
||
INSERT INTO dbo.TestRun_TemplateItemGroup(GroupId,GroupName,Remark,AddUser,AddTime,Sort)VALUES('76B784BB-6415-4A5B-81CF-08ABDB4A5152','氮气干燥置换','','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),9)
|
||
GO
|
||
|
||
--==试车工作包检查模板信息表
|
||
if object_id(N'TestRun_WorkInspectTemplate',N'U') is not null
|
||
drop table dbo.TestRun_WorkInspectTemplate
|
||
CREATE TABLE dbo.TestRun_WorkInspectTemplate(
|
||
WorkInspectId varchar(50) NOT NULL,--主键
|
||
WorkPackId varchar(50) NULL,--工作包主键
|
||
WorkInspectName varchar(500) NULL,--检查事项名称
|
||
Remark nvarchar(150) NULL,--备注
|
||
GroupId varchar(50) NULL,--默认分组主键
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_TestRun_WorkInspectTemplate PRIMARY KEY CLUSTERED
|
||
(
|
||
WorkInspectId ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
--==模板数据添加
|
||
--蒸汽发生器煮炉
|
||
delete TestRun_WorkInspectTemplate where WorkInspectId in ('7E6772DF-F6EB-40C2-9ADE-812261DA8FDA','983A255D-9566-41B8-A7E3-A6410CA7CE80','809B9BAD-DC27-4A10-A5D3-11E8E0FC2D03','6C512E87-4926-410E-91E9-64260841975C','BCFB2C79-8408-4D6B-818F-637AC09D5928','8089080E-194C-40EC-853A-6C54B7216640','915CFF7D-D674-4CCA-B714-039946A21F1A','4C31349D-73C8-46C0-BDFF-451FDD1B1A14','3DD4DA02-429C-484E-8B11-9DD9F4FF14F7','476504F5-0D98-4153-ADDC-07B92F1F8131','41F50C0D-7946-4476-A8CE-7873CDE9A895','8ACB5F52-CD6C-43D0-BAA6-38A45DC17E17')
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('7E6772DF-F6EB-40C2-9ADE-812261DA8FDA','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','水汽系统内外循环冲洗合格。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('983A255D-9566-41B8-A7E3-A6410CA7CE80','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','加药系统具备条件。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('809B9BAD-DC27-4A10-A5D3-11E8E0FC2D03','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','药品Helamin准备到位。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('6C512E87-4926-410E-91E9-64260841975C','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','锅炉给水系统具备条件。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('BCFB2C79-8408-4D6B-818F-637AC09D5928','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','P-1301A/B/C试车合格，能够投运。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),5)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('8089080E-194C-40EC-853A-6C54B7216640','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','煮炉需要DCS仪表清单调试完毕，DCS可用。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),6)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('915CFF7D-D674-4CCA-B714-039946A21F1A','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','开工蒸汽管道蒸汽吹扫完毕，具备投用条件。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),7)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('4C31349D-73C8-46C0-BDFF-451FDD1B1A14','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','开工蒸汽、循环水、脱盐水、仪表空气、电等能够正常供给。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),8)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('3DD4DA02-429C-484E-8B11-9DD9F4FF14F7','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','参与煮炉的人员已经培训完毕，人员安排到位。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),9)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('476504F5-0D98-4153-ADDC-07B92F1F8131','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','煮炉需要的工器具准备到位。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),10)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('41F50C0D-7946-4476-A8CE-7873CDE9A895','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','中心化验室做好分析准备。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),11)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('8ACB5F52-CD6C-43D0-BAA6-38A45DC17E17','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','气化炉水汽系统升压查漏完成。','','D4ABFB2C-3F1E-4AD6-B5C2-24D0C18E43D1','',GETDATE(),12)
|
||
go
|
||
--联动试车(设备、管道系统)
|
||
delete TestRun_WorkInspectTemplate where WorkInspectId in ('BAF6A855-626E-47AE-8392-66A728883DDC','7981FE42-A498-4033-873B-300F2C30CEDD','D50EE94D-072F-4321-A5A9-DCC418793328','C74E21AA-897D-41C9-913B-885080AC4F7B','DEAE38D1-5F93-465D-911D-A573500D87D1','3E207B29-41AE-4175-9BF8-E4A17025BAF0','6543BA5F-9414-4EEC-B9BB-3B5C4BD69C3F','525DA974-7C9D-4DEF-986E-B45C5A8C684A','2FF1A3AC-27C5-436E-857A-E16F48C41281','976BE907-6B1A-4D63-B9EC-D02FAE7F5841','5B6F8D9A-B327-4F4E-AE7A-1923C9987C31','62FFC392-13BA-4871-AA8F-F930D53D2729')
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('BAF6A855-626E-47AE-8392-66A728883DDC','FF3C10D2-822E-4CF4-BE50-AB69181075B5','设备、管道安装完成，符合施工验收规范要求。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('7981FE42-A498-4033-873B-300F2C30CEDD','FF3C10D2-822E-4CF4-BE50-AB69181075B5','“三查四定”的问题整改消缺完毕，无影响联动试车尾项。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('D50EE94D-072F-4321-A5A9-DCC418793328','FF3C10D2-822E-4CF4-BE50-AB69181075B5','管道压力试验合格。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('C74E21AA-897D-41C9-913B-885080AC4F7B','FF3C10D2-822E-4CF4-BE50-AB69181075B5','系统冲洗、吹扫合格。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('DEAE38D1-5F93-465D-911D-A573500D87D1','FF3C10D2-822E-4CF4-BE50-AB69181075B5','设备、管道化学清洗合格。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),5)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('3E207B29-41AE-4175-9BF8-E4A17025BAF0','FF3C10D2-822E-4CF4-BE50-AB69181075B5','设备单机试车合格。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),6)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('6543BA5F-9414-4EEC-B9BB-3B5C4BD69C3F','FF3C10D2-822E-4CF4-BE50-AB69181075B5','填料装填合格。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),7)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('525DA974-7C9D-4DEF-986E-B45C5A8C684A','FF3C10D2-822E-4CF4-BE50-AB69181075B5','设备、管道的严密性试验合格。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),8)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('2FF1A3AC-27C5-436E-857A-E16F48C41281','FF3C10D2-822E-4CF4-BE50-AB69181075B5','安全阀、呼吸阀整定合格、处于完好投用状态。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),9)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('976BE907-6B1A-4D63-B9EC-D02FAE7F5841','FF3C10D2-822E-4CF4-BE50-AB69181075B5','8字盲板或系统隔离盲板处于正确位置。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),10)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('5B6F8D9A-B327-4F4E-AE7A-1923C9987C31','FF3C10D2-822E-4CF4-BE50-AB69181075B5','支吊架安装符合要求。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),11)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('62FFC392-13BA-4871-AA8F-F930D53D2729','FF3C10D2-822E-4CF4-BE50-AB69181075B5','弹簧支吊架调整合格、处于完好投用状态。','','962116EB-E367-42D9-ACD5-4590D5E623A0','',GETDATE(),12)
|
||
go
|
||
--联动试车(电仪系统)
|
||
delete TestRun_WorkInspectTemplate where WorkInspectId in ('00290712-4366-46DF-88C5-6C86BF66FFCC','A7178577-245E-4926-BC95-7276CF745874','82460343-3189-46B3-A283-6D1A02700933','29251A33-5106-4660-B9E6-D43E35D44C4D','1FE206C9-A989-41AF-B6C3-94B2859FE1C1')
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('00290712-4366-46DF-88C5-6C86BF66FFCC','FF3C10D2-822E-4CF4-BE50-AB69181075B5','电气仪表安装，符合施工验收规范要求。','','EEE07FFC-EB58-43C0-AFD6-DCF5B0B0AE7E','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('A7178577-245E-4926-BC95-7276CF745874','FF3C10D2-822E-4CF4-BE50-AB69181075B5','电气设备的继电调整和绝缘试验已合格。','','EEE07FFC-EB58-43C0-AFD6-DCF5B0B0AE7E','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('82460343-3189-46B3-A283-6D1A02700933','FF3C10D2-822E-4CF4-BE50-AB69181075B5','防雷防静电设施测试合格、可靠。','','EEE07FFC-EB58-43C0-AFD6-DCF5B0B0AE7E','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('29251A33-5106-4660-B9E6-D43E35D44C4D','FF3C10D2-822E-4CF4-BE50-AB69181075B5','电气和仪表的检测系统、自动控制系统、联锁和报警系统调试合格。','','EEE07FFC-EB58-43C0-AFD6-DCF5B0B0AE7E','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('1FE206C9-A989-41AF-B6C3-94B2859FE1C1','FF3C10D2-822E-4CF4-BE50-AB69181075B5','自动分析仪表调试合格，样气已配制合格。','','EEE07FFC-EB58-43C0-AFD6-DCF5B0B0AE7E','',GETDATE(),5)
|
||
go
|
||
--联动试车(公用系统)
|
||
delete TestRun_WorkInspectTemplate where WorkInspectId in ('E764654E-2974-4DDE-B09D-5118BC13FADE','1955A53C-5E28-4621-A2FB-2878CB47B7F7')
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('E764654E-2974-4DDE-B09D-5118BC13FADE','FF3C10D2-822E-4CF4-BE50-AB69181075B5','水、电、蒸汽、仪表气、工厂气、氮气等能保证稳定供应。','','816C8571-A275-4064-8165-B13FA459F5E1','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('1955A53C-5E28-4621-A2FB-2878CB47B7F7','FF3C10D2-822E-4CF4-BE50-AB69181075B5','原料、燃料及辅助原料、润滑油脂、化学品等齐备，能确保稳定供应。','','816C8571-A275-4064-8165-B13FA459F5E1','',GETDATE(),2)
|
||
go
|
||
--联动试车(消防、安全、环境保护系统)
|
||
delete TestRun_WorkInspectTemplate where WorkInspectId in ('7EABB4DC-2759-4744-8E14-A2B1174A7269','8BD5374C-78D8-4D3A-A215-0B937819A6B2','C4E82F10-83C2-406D-BEAE-AA324850FAE6','3B59B32D-12E4-47AD-AAFE-AEFC48CA86C9')
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('7EABB4DC-2759-4744-8E14-A2B1174A7269','FF3C10D2-822E-4CF4-BE50-AB69181075B5','消防水系统调试合格，处于完好投用状态。','','CA8AC7B3-F6F9-47EB-A82F-827A07FE63DE','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('8BD5374C-78D8-4D3A-A215-0B937819A6B2','FF3C10D2-822E-4CF4-BE50-AB69181075B5','泡沫、干粉、二氧化碳等消防设施调试合格，处于完好投用状态。','','CA8AC7B3-F6F9-47EB-A82F-827A07FE63DE','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('C4E82F10-83C2-406D-BEAE-AA324850FAE6','FF3C10D2-822E-4CF4-BE50-AB69181075B5','系统隔离已完成，临时措施符合要求。','','CA8AC7B3-F6F9-47EB-A82F-827A07FE63DE','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('3B59B32D-12E4-47AD-AAFE-AEFC48CA86C9','FF3C10D2-822E-4CF4-BE50-AB69181075B5','盲板管理已有专人负责，进行动态管理，记录台帐，现场挂牌。','','CA8AC7B3-F6F9-47EB-A82F-827A07FE63DE','',GETDATE(),4)
|
||
go
|
||
--联动试车(分析化验)
|
||
delete TestRun_WorkInspectTemplate where WorkInspectId in ('07D87903-F0F7-4E1E-AC68-4140749DCBB6','1013759E-4947-48CE-A725-904A023F7939','2C24530F-5421-47C8-984B-B763031E1D24')
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('07D87903-F0F7-4E1E-AC68-4140749DCBB6','FF3C10D2-822E-4CF4-BE50-AB69181075B5','中化室、分析室已建立正常分析化验制度，分析方法已确定。','','32641418-4622-4D48-B5CD-88B4FAAF1A5E','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('1013759E-4947-48CE-A725-904A023F7939','FF3C10D2-822E-4CF4-BE50-AB69181075B5','分析化验设施、试剂、标准溶液已备齐待用，满足要求。','','32641418-4622-4D48-B5CD-88B4FAAF1A5E','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('2C24530F-5421-47C8-984B-B763031E1D24','FF3C10D2-822E-4CF4-BE50-AB69181075B5','模拟采样、模拟分析已演练。','','32641418-4622-4D48-B5CD-88B4FAAF1A5E','',GETDATE(),3)
|
||
go
|
||
--联动试车(组织、人员、通讯、方案、规定)
|
||
delete TestRun_WorkInspectTemplate where WorkInspectId in ('5CCC100F-A337-4097-B5E5-926D6D4BEBE1','5DC1B9BA-85E0-4FF2-B295-7C554D557489','63D0886F-2A2D-4381-A19D-36BC7EBE3A48','9C2EEE58-B009-4822-9000-40A8F5C43429','779B6E9D-857B-43B5-92C3-8376AF2C23EC','714F447E-793D-4B74-853B-3B751D54FCB8','70073618-055E-4E2A-91FE-65E8175203B7','12413C80-BC95-4C31-9E96-E8D61D73E50A','9C685E13-6740-47AF-A5DD-4CAF8F25047D')
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('5CCC100F-A337-4097-B5E5-926D6D4BEBE1','FF3C10D2-822E-4CF4-BE50-AB69181075B5','各级试车指挥组织已经建立，岗位责任制已颁布执行，操作人员已配齐，已按要求上岗。','','C391B309-74A5-415A-940C-A41014631F12','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('5DC1B9BA-85E0-4FF2-B295-7C554D557489','FF3C10D2-822E-4CF4-BE50-AB69181075B5','试车调度系统已正常运行。','','C391B309-74A5-415A-940C-A41014631F12','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('63D0886F-2A2D-4381-A19D-36BC7EBE3A48','FF3C10D2-822E-4CF4-BE50-AB69181075B5','装置人员已经过安全教育。','','C391B309-74A5-415A-940C-A41014631F12','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('9C2EEE58-B009-4822-9000-40A8F5C43429','FF3C10D2-822E-4CF4-BE50-AB69181075B5','指挥系统的通讯畅通。','','C391B309-74A5-415A-940C-A41014631F12','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('779B6E9D-857B-43B5-92C3-8376AF2C23EC','FF3C10D2-822E-4CF4-BE50-AB69181075B5','岗位、直通电话已开通好用。','','C391B309-74A5-415A-940C-A41014631F12','',GETDATE(),5)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('714F447E-793D-4B74-853B-3B751D54FCB8','FF3C10D2-822E-4CF4-BE50-AB69181075B5','火警、急救电话、无线电话、扩音对讲系统可靠好用。','','C391B309-74A5-415A-940C-A41014631F12','',GETDATE(),6)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('70073618-055E-4E2A-91FE-65E8175203B7','FF3C10D2-822E-4CF4-BE50-AB69181075B5','岗位标准操作程序已被批准。','','C391B309-74A5-415A-940C-A41014631F12','',GETDATE(),7)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('12413C80-BC95-4C31-9E96-E8D61D73E50A','FF3C10D2-822E-4CF4-BE50-AB69181075B5','参加联动试车的业主操作人员已经相应岗位培训合格。','','C391B309-74A5-415A-940C-A41014631F12','',GETDATE(),8)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('9C685E13-6740-47AF-A5DD-4CAF8F25047D','FF3C10D2-822E-4CF4-BE50-AB69181075B5','各种物资和测试仪表、工具和记录表格均已齐备。','','C391B309-74A5-415A-940C-A41014631F12','',GETDATE(),9)
|
||
go
|
||
--联动试车(保运、后勤保障)
|
||
delete TestRun_WorkInspectTemplate where WorkInspectId in ('509BE136-72B5-462D-BCD5-367719461CF6','D4BA9DD7-A2AC-49F9-87C0-F9255A3DCF81','952DDAC1-8886-4AA5-8057-C6676D92E94C','66732649-05C5-4A93-9B09-F87F51AAD1D3','DF8297EF-0D4F-470B-BFB2-64DB9F3D4428')
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('509BE136-72B5-462D-BCD5-367719461CF6','FF3C10D2-822E-4CF4-BE50-AB69181075B5','保运队伍已组成，范围、责任、值班制度已明确。','','5390ECFB-64FF-4332-9B9D-21777CF7BD3C','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('D4BA9DD7-A2AC-49F9-87C0-F9255A3DCF81','FF3C10D2-822E-4CF4-BE50-AB69181075B5','机、电、仪修人员已上岗。','','5390ECFB-64FF-4332-9B9D-21777CF7BD3C','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('952DDAC1-8886-4AA5-8057-C6676D92E94C','FF3C10D2-822E-4CF4-BE50-AB69181075B5','保运装备、工机具已落实。','','5390ECFB-64FF-4332-9B9D-21777CF7BD3C','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('66732649-05C5-4A93-9B09-F87F51AAD1D3','FF3C10D2-822E-4CF4-BE50-AB69181075B5','各类备品、备件、专用工器具等已备齐。','','5390ECFB-64FF-4332-9B9D-21777CF7BD3C','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('DF8297EF-0D4F-470B-BFB2-64DB9F3D4428','FF3C10D2-822E-4CF4-BE50-AB69181075B5','生活后勤服务已落实。','','5390ECFB-64FF-4332-9B9D-21777CF7BD3C','',GETDATE(),5)
|
||
go
|
||
--氮气干燥置换
|
||
delete TestRun_WorkInspectTemplate where WorkInspectId in ('9C3D91DD-A844-4C07-B764-5636181C0BCE','62721C3A-5153-4423-B0A1-D9E60E82B412','E84A7DA5-F174-42E4-9A8F-6F1C567670C8','180837E6-54AF-491A-81D1-C6D7545698DF','580A8E9F-B0FC-40D0-8CE6-5315529ED188','051EC46F-C2DC-4348-A0DA-2CE225D62512','AEAA541A-BC10-49AF-AB79-3C7C117BC563','9F052148-0326-432D-8C19-013C35CD743B','1C126F56-B360-4ECD-B2BE-BE499DFB23F2','F936036B-B03E-4782-A199-529F47BA5A72','9B9B479F-CD25-4E47-B274-F9D65C5EE11B')
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('9C3D91DD-A844-4C07-B764-5636181C0BCE','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','仪表调试合格，调节阀能正常投运。','','76B784BB-6415-4A5B-81CF-08ABDB4A5152','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('62721C3A-5153-4423-B0A1-D9E60E82B412','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','管道试压、冲洗、吹扫合格。','','76B784BB-6415-4A5B-81CF-08ABDB4A5152','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('E84A7DA5-F174-42E4-9A8F-6F1C567670C8','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','动设备单机试车合格。','','76B784BB-6415-4A5B-81CF-08ABDB4A5152','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('180837E6-54AF-491A-81D1-C6D7545698DF','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','系统单元联动试车完毕。','','76B784BB-6415-4A5B-81CF-08ABDB4A5152','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('580A8E9F-B0FC-40D0-8CE6-5315529ED188','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','系统气密试验合格。','','76B784BB-6415-4A5B-81CF-08ABDB4A5152','',GETDATE(),5)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('051EC46F-C2DC-4348-A0DA-2CE225D62512','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','置换所需临时措施已准备完毕。','','76B784BB-6415-4A5B-81CF-08ABDB4A5152','',GETDATE(),6)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('AEAA541A-BC10-49AF-AB79-3C7C117BC563','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','阀门的开关位置已按回路图检查完成。','','76B784BB-6415-4A5B-81CF-08ABDB4A5152','',GETDATE(),7)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('9F052148-0326-432D-8C19-013C35CD743B','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','分析仪器已就位。','','76B784BB-6415-4A5B-81CF-08ABDB4A5152','',GETDATE(),8)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('1C126F56-B360-4ECD-B2BE-BE499DFB23F2','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','氮气满足系统置换的需要。','','76B784BB-6415-4A5B-81CF-08ABDB4A5152','',GETDATE(),9)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('F936036B-B03E-4782-A199-529F47BA5A72','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','安全措施已到位。','','76B784BB-6415-4A5B-81CF-08ABDB4A5152','',GETDATE(),10)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupId,AddUser,AddTime,Sort) VALUES('9B9B479F-CD25-4E47-B274-F9D65C5EE11B','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','操作人员已进行安全技术交底。','','76B784BB-6415-4A5B-81CF-08ABDB4A5152','',GETDATE(),11)
|
||
go
|
||
|
||
--==系统工作包检查表
|
||
if object_id(N'TestRun_SubInspectTerm',N'U') is not null
|
||
drop table dbo.TestRun_SubInspectTerm
|
||
CREATE TABLE dbo.TestRun_SubInspectTerm(
|
||
SubInspectId varchar(50) NOT NULL,--主键
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
InstallationId varchar(50) NULL,--装置主键(冗余字段，方便后期关联适用)
|
||
ProcessesId varchar(50) NULL,--工序主键(冗余字段，方便后期关联适用)
|
||
SystemId varchar(50) NULL,--系统主键(冗余字段，方便后期关联适用)
|
||
WorkPackId varchar(50) NULL,--工作包主键
|
||
InspectResult varchar(500) NULL,--检查结论
|
||
Subcontractor varchar(50) null,--分包商
|
||
Contractor varchar(50) null,--承包商
|
||
Supervision varchar(50) null,--监理
|
||
Owner varchar(50) null,--业主
|
||
InspectionIsAllPass int NULL,--检查结果0/null:未通过 1:通过
|
||
SubcontractorIsAllPass int NULL,--分包商是否通过0/null:未通过 1:通过
|
||
ContractorIsAllPass int NULL,--承包商是否通过0/null:未通过 1:通过
|
||
SupervisionIsAllPass int NULL,--监理是否通过0/null:未通过 1:通过
|
||
OwnerIsAllPass int NULL,--业主是否通过0/null:未通过 1:通过
|
||
PropertyTechnologyId varchar(max) null,--管道或工艺设备主键
|
||
SubcontractorAllPassData datetime null,--分包商通过日期
|
||
ContractorAllPassData datetime null,--承包商通过日期
|
||
SupervisionAllPassData datetime null,--监理通过日期
|
||
OwnerAllPassData datetime null,--业主通过日期
|
||
WanderIsComplete int null,--检查表流转是否全部通过0:未通过1:通过
|
||
WanderCompleteData datetime null,--检查表流转完成日期
|
||
IsSiteImplement int null,--现场实施是否完成0:未完成1:已完成
|
||
SiteImplementUser varchar(50) null,--现场实施确认人
|
||
SiteImplementConfirmData datetime null,--现场实施记录确认时间
|
||
RecordUploadData datetime null,--现场实施记录上传日期
|
||
InspectIsClose int null,--任务单是否关闭0:未关闭1:已关闭
|
||
InspectIsCloseUser varchar(50) null,--任务单关闭人
|
||
InspectCloseData datetime null,--任务单关闭日期
|
||
IsUnifyWanderAbout int null,--是否统一流转0:否1:是
|
||
UnifyWanderAboutData datetime null,--统一流转时间
|
||
UnifyWanderAboutOpinion varchar(max) null,--统一流转备注
|
||
InspectTime datetime NULL,--检查时间
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
CONSTRAINT PK_TestRun_SubInspectTerm PRIMARY KEY CLUSTERED
|
||
(
|
||
SubInspectId ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
--==系统工作包检查项表
|
||
if object_id(N'TestRun_SubInspectTermItem',N'U') is not null
|
||
drop table dbo.TestRun_SubInspectTermItem
|
||
CREATE TABLE dbo.TestRun_SubInspectTermItem(
|
||
TermItemId varchar(50) NOT NULL,--主键
|
||
SubInspectId varchar(50) NULL,--检查表主键
|
||
WorkPackId varchar(50) NULL,--工作包主键
|
||
GroupId varchar(50) NULL,--默认分组主键
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
WorkInspectId varchar(50) NOT NULL,--工作包模板项主键
|
||
WorkInspectName varchar(500) NULL,--检查事项名称
|
||
InstallationId varchar(50) NULL,--装置主键(冗余字段，方便后期关联适用)
|
||
ProcessesId varchar(50) NULL,--工序主键(冗余字段，方便后期关联适用)
|
||
SystemId varchar(50) NULL,--系统主键(冗余字段，方便后期关联适用)
|
||
InspectedUser varchar(max) NULL,--检查人主键(仅生成检查表展示用)
|
||
AllUserInspectionPass int NULL,--检查人是否全部通过0:未通过 1:通过
|
||
Subcontractor varchar(50) null,--分包商
|
||
Contractor varchar(50) null,--承包商
|
||
Supervision varchar(50) null,--监理
|
||
Owner varchar(50) null,--业主
|
||
SubcontractorIsPass int NULL,--分包商是否通过0/null:未通过 1:通过
|
||
ContractorIsPass int NULL,--承包商是否通过0/null:未通过 1:通过
|
||
SupervisionIsPass int NULL,--监理是否通过0/null:未通过 1:通过
|
||
OwnerIsPass int NULL,--业主是否通过0/null:未通过 1:通过
|
||
SubcontractorRemark varchar(1000) NULL,--分包商备注
|
||
ContractorRemark varchar(1000) NULL,--承包商备注
|
||
SupervisionRemark varchar(1000) NULL,--监理备注
|
||
OwnerRemark varchar(1000) NULL,--业主备注
|
||
Remark varchar(200) NULL,--备注
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_TestRun_SubInspectTermItem PRIMARY KEY CLUSTERED
|
||
(
|
||
TermItemId ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
--==检查项检查人表
|
||
if object_id(N'TestRun_TermItemInspectedUser',N'U') is not null
|
||
drop table dbo.TestRun_TermItemInspectedUser
|
||
CREATE TABLE dbo.TestRun_TermItemInspectedUser(
|
||
ItemUserId varchar(50) NOT NULL,--主键
|
||
TermItemId varchar(50) NULL,--检查项主键
|
||
SubInspectId varchar(50) NULL,--检查表主键
|
||
WorkPackId varchar(50) NULL,--工作包主键
|
||
GroupId varchar(50) NULL,--默认分组主键
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
InspectedUser varchar(50) NULL,--检查人主键
|
||
InspectionResults int NULL,--检查结果0:未通过 1:通过
|
||
InspectionIllustrate varchar(200) NULL,--检查说明
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_TestRun_TermItemInspectedUser PRIMARY KEY CLUSTERED
|
||
(
|
||
ItemUserId ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
--==检查表尾项管理
|
||
if object_id(N'TestRun_InspectTailTerm',N'U') is not null
|
||
drop table dbo.TestRun_InspectTailTerm
|
||
CREATE TABLE dbo.TestRun_InspectTailTerm(
|
||
TailTermId varchar(50) NOT NULL,--主键
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
ProjectName varchar(50) NULL,--项目名称
|
||
TailTermCode varchar(50) NULL,--巡检编号
|
||
ConstructionUnit varchar(50) NULL,--施工单位
|
||
SubInspectId varchar(50) NULL,--工作包检查表主键
|
||
TermItemId varchar(50) NULL,--检查项主键
|
||
WorkPackId varchar(50) NULL,--工作包主键
|
||
QuestionDesc varchar(max) NULL,--问题描述
|
||
RectifyOpinion varchar(max) NULL,--整改意见
|
||
RectifyTime datetime NULL,--尾项提出时间
|
||
InspectUser varchar(50) NULL,--检查人
|
||
HandleUser varchar(50) NULL,--处理人
|
||
ApproveUser varchar(50) NULL,--审核人
|
||
AdjustCompleteTime datetime NULL,--要求整改完成时间
|
||
ApproveState int NULL,--0:待提交处理1:待处理2:处理退回3:审核退回4:待审核5:审核通过
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
CONSTRAINT PK_TestRun_InspectTailTerm PRIMARY KEY CLUSTERED
|
||
(
|
||
TailTermId ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
--==检查项处理/审核记录
|
||
if object_id(N'TestRun_InspectTermApproveRecords',N'U') is not null
|
||
drop table dbo.TestRun_InspectTermApproveRecords
|
||
CREATE TABLE dbo.TestRun_InspectTermApproveRecords(
|
||
InspectTermId varchar(50) NOT NULL,--主键
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
TermItemId varchar(50) NULL,--检查项主键
|
||
TailTermId varchar(50) NULL,--尾项主键
|
||
ApproveOpinion varchar(max) NULL,--审核意见
|
||
ApproveTime datetime NULL,--操作时间
|
||
ApproveUser varchar(50) NULL,--操作人
|
||
ApproveType int NULL,--记录类型0:处理记录1:审核记录
|
||
ApproveState int NULL,--0:退回1:通过
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
CONSTRAINT PK_TestRun_InspectTermApproveRecords PRIMARY KEY CLUSTERED
|
||
(
|
||
InspectTermId ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO |