382 lines
35 KiB
Transact-SQL
382 lines
35 KiB
Transact-SQL
--1:删除页面/TestRun/TestRunManage/TemplateItemGroup.aspx
|
||
|
||
delete Sys_Menu where MenuId='AF2B0CAD-DE15-4F15-A5EE-C8FB558D00C8'
|
||
--==试车检查模板项分组信息
|
||
if object_id(N'TestRun_TemplateItemGroup',N'U') is not null
|
||
drop table dbo.TestRun_TemplateItemGroup
|
||
|
||
|
||
--==试车工作包检查模板信息表
|
||
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,--备注
|
||
GroupName 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,GroupName,AddUser,AddTime,Sort) VALUES('7E6772DF-F6EB-40C2-9ADE-812261DA8FDA','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','水汽系统内外循环冲洗合格。','','蒸汽发生器煮炉','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('983A255D-9566-41B8-A7E3-A6410CA7CE80','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','加药系统具备条件。','','蒸汽发生器煮炉','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('809B9BAD-DC27-4A10-A5D3-11E8E0FC2D03','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','药品Helamin准备到位。','','蒸汽发生器煮炉','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('6C512E87-4926-410E-91E9-64260841975C','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','锅炉给水系统具备条件。','','蒸汽发生器煮炉','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('BCFB2C79-8408-4D6B-818F-637AC09D5928','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','P-1301A/B/C试车合格，能够投运。','','蒸汽发生器煮炉','',GETDATE(),5)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('8089080E-194C-40EC-853A-6C54B7216640','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','煮炉需要DCS仪表清单调试完毕，DCS可用。','','蒸汽发生器煮炉','',GETDATE(),6)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('915CFF7D-D674-4CCA-B714-039946A21F1A','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','开工蒸汽管道蒸汽吹扫完毕，具备投用条件。','','蒸汽发生器煮炉','',GETDATE(),7)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('4C31349D-73C8-46C0-BDFF-451FDD1B1A14','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','开工蒸汽、循环水、脱盐水、仪表空气、电等能够正常供给。','','蒸汽发生器煮炉','',GETDATE(),8)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('3DD4DA02-429C-484E-8B11-9DD9F4FF14F7','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','参与煮炉的人员已经培训完毕，人员安排到位。','','蒸汽发生器煮炉','',GETDATE(),9)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('476504F5-0D98-4153-ADDC-07B92F1F8131','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','煮炉需要的工器具准备到位。','','蒸汽发生器煮炉','',GETDATE(),10)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('41F50C0D-7946-4476-A8CE-7873CDE9A895','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','中心化验室做好分析准备。','','蒸汽发生器煮炉','',GETDATE(),11)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('8ACB5F52-CD6C-43D0-BAA6-38A45DC17E17','1D6C3FD1-6462-4E2C-9828-5D1E718A5EB6','气化炉水汽系统升压查漏完成。','','蒸汽发生器煮炉','',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,GroupName,AddUser,AddTime,Sort) VALUES('BAF6A855-626E-47AE-8392-66A728883DDC','FF3C10D2-822E-4CF4-BE50-AB69181075B5','设备、管道安装完成，符合施工验收规范要求。','','设备、管道系统','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('7981FE42-A498-4033-873B-300F2C30CEDD','FF3C10D2-822E-4CF4-BE50-AB69181075B5','“三查四定”的问题整改消缺完毕，无影响联动试车尾项。','','设备、管道系统','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('D50EE94D-072F-4321-A5A9-DCC418793328','FF3C10D2-822E-4CF4-BE50-AB69181075B5','管道压力试验合格。','','设备、管道系统','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('C74E21AA-897D-41C9-913B-885080AC4F7B','FF3C10D2-822E-4CF4-BE50-AB69181075B5','系统冲洗、吹扫合格。','','设备、管道系统','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('DEAE38D1-5F93-465D-911D-A573500D87D1','FF3C10D2-822E-4CF4-BE50-AB69181075B5','设备、管道化学清洗合格。','','设备、管道系统','',GETDATE(),5)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('3E207B29-41AE-4175-9BF8-E4A17025BAF0','FF3C10D2-822E-4CF4-BE50-AB69181075B5','设备单机试车合格。','','设备、管道系统','',GETDATE(),6)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('6543BA5F-9414-4EEC-B9BB-3B5C4BD69C3F','FF3C10D2-822E-4CF4-BE50-AB69181075B5','填料装填合格。','','设备、管道系统','',GETDATE(),7)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('525DA974-7C9D-4DEF-986E-B45C5A8C684A','FF3C10D2-822E-4CF4-BE50-AB69181075B5','设备、管道的严密性试验合格。','','设备、管道系统','',GETDATE(),8)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('2FF1A3AC-27C5-436E-857A-E16F48C41281','FF3C10D2-822E-4CF4-BE50-AB69181075B5','安全阀、呼吸阀整定合格、处于完好投用状态。','','设备、管道系统','',GETDATE(),9)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('976BE907-6B1A-4D63-B9EC-D02FAE7F5841','FF3C10D2-822E-4CF4-BE50-AB69181075B5','8字盲板或系统隔离盲板处于正确位置。','','设备、管道系统','',GETDATE(),10)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('5B6F8D9A-B327-4F4E-AE7A-1923C9987C31','FF3C10D2-822E-4CF4-BE50-AB69181075B5','支吊架安装符合要求。','','设备、管道系统','',GETDATE(),11)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('62FFC392-13BA-4871-AA8F-F930D53D2729','FF3C10D2-822E-4CF4-BE50-AB69181075B5','弹簧支吊架调整合格、处于完好投用状态。','','设备、管道系统','',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,GroupName,AddUser,AddTime,Sort) VALUES('00290712-4366-46DF-88C5-6C86BF66FFCC','FF3C10D2-822E-4CF4-BE50-AB69181075B5','电气仪表安装，符合施工验收规范要求。','','电仪系统','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('A7178577-245E-4926-BC95-7276CF745874','FF3C10D2-822E-4CF4-BE50-AB69181075B5','电气设备的继电调整和绝缘试验已合格。','','电仪系统','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('82460343-3189-46B3-A283-6D1A02700933','FF3C10D2-822E-4CF4-BE50-AB69181075B5','防雷防静电设施测试合格、可靠。','','电仪系统','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('29251A33-5106-4660-B9E6-D43E35D44C4D','FF3C10D2-822E-4CF4-BE50-AB69181075B5','电气和仪表的检测系统、自动控制系统、联锁和报警系统调试合格。','','电仪系统','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('1FE206C9-A989-41AF-B6C3-94B2859FE1C1','FF3C10D2-822E-4CF4-BE50-AB69181075B5','自动分析仪表调试合格，样气已配制合格。','','电仪系统','',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,GroupName,AddUser,AddTime,Sort) VALUES('E764654E-2974-4DDE-B09D-5118BC13FADE','FF3C10D2-822E-4CF4-BE50-AB69181075B5','水、电、蒸汽、仪表气、工厂气、氮气等能保证稳定供应。','','公用系统','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('1955A53C-5E28-4621-A2FB-2878CB47B7F7','FF3C10D2-822E-4CF4-BE50-AB69181075B5','原料、燃料及辅助原料、润滑油脂、化学品等齐备，能确保稳定供应。','','公用系统','',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,GroupName,AddUser,AddTime,Sort) VALUES('7EABB4DC-2759-4744-8E14-A2B1174A7269','FF3C10D2-822E-4CF4-BE50-AB69181075B5','消防水系统调试合格，处于完好投用状态。','','消防、安全、环境保护系统','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('8BD5374C-78D8-4D3A-A215-0B937819A6B2','FF3C10D2-822E-4CF4-BE50-AB69181075B5','泡沫、干粉、二氧化碳等消防设施调试合格，处于完好投用状态。','','消防、安全、环境保护系统','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('C4E82F10-83C2-406D-BEAE-AA324850FAE6','FF3C10D2-822E-4CF4-BE50-AB69181075B5','系统隔离已完成，临时措施符合要求。','','消防、安全、环境保护系统','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('3B59B32D-12E4-47AD-AAFE-AEFC48CA86C9','FF3C10D2-822E-4CF4-BE50-AB69181075B5','盲板管理已有专人负责，进行动态管理，记录台帐，现场挂牌。','','消防、安全、环境保护系统','',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,GroupName,AddUser,AddTime,Sort) VALUES('07D87903-F0F7-4E1E-AC68-4140749DCBB6','FF3C10D2-822E-4CF4-BE50-AB69181075B5','中化室、分析室已建立正常分析化验制度，分析方法已确定。','','分析化验','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('1013759E-4947-48CE-A725-904A023F7939','FF3C10D2-822E-4CF4-BE50-AB69181075B5','分析化验设施、试剂、标准溶液已备齐待用，满足要求。','','分析化验','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('2C24530F-5421-47C8-984B-B763031E1D24','FF3C10D2-822E-4CF4-BE50-AB69181075B5','模拟采样、模拟分析已演练。','','分析化验','',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,GroupName,AddUser,AddTime,Sort) VALUES('5CCC100F-A337-4097-B5E5-926D6D4BEBE1','FF3C10D2-822E-4CF4-BE50-AB69181075B5','各级试车指挥组织已经建立，岗位责任制已颁布执行，操作人员已配齐，已按要求上岗。','','组织、人员、通讯、方案、规定','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('5DC1B9BA-85E0-4FF2-B295-7C554D557489','FF3C10D2-822E-4CF4-BE50-AB69181075B5','试车调度系统已正常运行。','','组织、人员、通讯、方案、规定','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('63D0886F-2A2D-4381-A19D-36BC7EBE3A48','FF3C10D2-822E-4CF4-BE50-AB69181075B5','装置人员已经过安全教育。','','组织、人员、通讯、方案、规定','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('9C2EEE58-B009-4822-9000-40A8F5C43429','FF3C10D2-822E-4CF4-BE50-AB69181075B5','指挥系统的通讯畅通。','','组织、人员、通讯、方案、规定','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('779B6E9D-857B-43B5-92C3-8376AF2C23EC','FF3C10D2-822E-4CF4-BE50-AB69181075B5','岗位、直通电话已开通好用。','','组织、人员、通讯、方案、规定','',GETDATE(),5)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('714F447E-793D-4B74-853B-3B751D54FCB8','FF3C10D2-822E-4CF4-BE50-AB69181075B5','火警、急救电话、无线电话、扩音对讲系统可靠好用。','','组织、人员、通讯、方案、规定','',GETDATE(),6)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('70073618-055E-4E2A-91FE-65E8175203B7','FF3C10D2-822E-4CF4-BE50-AB69181075B5','岗位标准操作程序已被批准。','','组织、人员、通讯、方案、规定','',GETDATE(),7)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('12413C80-BC95-4C31-9E96-E8D61D73E50A','FF3C10D2-822E-4CF4-BE50-AB69181075B5','参加联动试车的业主操作人员已经相应岗位培训合格。','','组织、人员、通讯、方案、规定','',GETDATE(),8)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('9C685E13-6740-47AF-A5DD-4CAF8F25047D','FF3C10D2-822E-4CF4-BE50-AB69181075B5','各种物资和测试仪表、工具和记录表格均已齐备。','','组织、人员、通讯、方案、规定','',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,GroupName,AddUser,AddTime,Sort) VALUES('509BE136-72B5-462D-BCD5-367719461CF6','FF3C10D2-822E-4CF4-BE50-AB69181075B5','保运队伍已组成，范围、责任、值班制度已明确。','','保运、后勤保障','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('D4BA9DD7-A2AC-49F9-87C0-F9255A3DCF81','FF3C10D2-822E-4CF4-BE50-AB69181075B5','机、电、仪修人员已上岗。','','保运、后勤保障','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('952DDAC1-8886-4AA5-8057-C6676D92E94C','FF3C10D2-822E-4CF4-BE50-AB69181075B5','保运装备、工机具已落实。','','保运、后勤保障','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('66732649-05C5-4A93-9B09-F87F51AAD1D3','FF3C10D2-822E-4CF4-BE50-AB69181075B5','各类备品、备件、专用工器具等已备齐。','','保运、后勤保障','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('DF8297EF-0D4F-470B-BFB2-64DB9F3D4428','FF3C10D2-822E-4CF4-BE50-AB69181075B5','生活后勤服务已落实。','','保运、后勤保障','',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,GroupName,AddUser,AddTime,Sort) VALUES('9C3D91DD-A844-4C07-B764-5636181C0BCE','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','仪表调试合格，调节阀能正常投运。','','氮气干燥置换','',GETDATE(),1)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('62721C3A-5153-4423-B0A1-D9E60E82B412','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','管道试压、冲洗、吹扫合格。','','氮气干燥置换','',GETDATE(),2)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('E84A7DA5-F174-42E4-9A8F-6F1C567670C8','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','动设备单机试车合格。','','氮气干燥置换','',GETDATE(),3)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('180837E6-54AF-491A-81D1-C6D7545698DF','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','系统单元联动试车完毕。','','氮气干燥置换','',GETDATE(),4)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('580A8E9F-B0FC-40D0-8CE6-5315529ED188','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','系统气密试验合格。','','氮气干燥置换','',GETDATE(),5)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('051EC46F-C2DC-4348-A0DA-2CE225D62512','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','置换所需临时措施已准备完毕。','','氮气干燥置换','',GETDATE(),6)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('AEAA541A-BC10-49AF-AB79-3C7C117BC563','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','阀门的开关位置已按回路图检查完成。','','氮气干燥置换','',GETDATE(),7)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('9F052148-0326-432D-8C19-013C35CD743B','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','分析仪器已就位。','','氮气干燥置换','',GETDATE(),8)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('1C126F56-B360-4ECD-B2BE-BE499DFB23F2','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','氮气满足系统置换的需要。','','氮气干燥置换','',GETDATE(),9)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('F936036B-B03E-4782-A199-529F47BA5A72','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','安全措施已到位。','','氮气干燥置换','',GETDATE(),10)
|
||
INSERT INTO dbo.TestRun_WorkInspectTemplate(WorkInspectId,WorkPackId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort) VALUES('9B9B479F-CD25-4E47-B274-F9D65C5EE11B','82ED8240-AA40-4CEB-80E0-B3DF14FFC284','操作人员已进行安全技术交底。','','氮气干燥置换','',GETDATE(),11)
|
||
go
|
||
|
||
--预试车新增菜单
|
||
delete Sys_Menu where MenuId='FCC050F0-0F13-4CE5-BE33-623377562965'
|
||
delete Sys_Menu where MenuId='E673FC27-74F1-479C-8DE1-950183566725'
|
||
delete Sys_Menu where MenuId='FAD7BF9B-B08A-473B-BEB9-CCAC3E5EA130'
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('FCC050F0-0F13-4CE5-BE33-623377562965','三查四定尾项清单',null,'TestRun/BeforeTestRun/SubThreeChecksFourDecisionList.aspx',15,'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('E673FC27-74F1-479C-8DE1-950183566725','三查四定责任人确认',null,'TestRun/BeforeTestRun/FourDecisionResponsibilityConfirm.aspx',16,'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('FAD7BF9B-B08A-473B-BEB9-CCAC3E5EA130','三查四定确认',null,'TestRun/BeforeTestRun/FourDecisionOtherConfirm.aspx',17,'AD6E08B6-5571-4FFB-BDBE-9E6811770BD6','Menu_TestRun',0,1,1)
|
||
|
||
|
||
--==系统工作包检查项表
|
||
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,--工作包主键
|
||
GroupName 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,--工作包主键
|
||
GroupName varchar(50) NULL,--分组名称
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
InspectedUser varchar(50) NULL,--检查人主键
|
||
InspectionResults int NULL,--检查结果0:未通过 1:通过
|
||
InspectionIllustrate varchar(200) NULL,--检查说明
|
||
InstallationId varchar(50) NULL,--装置主键(冗余字段，方便后期关联适用)
|
||
ProcessesId varchar(50) NULL,--工序主键(冗余字段，方便后期关联适用)
|
||
SystemId varchar(50) 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'PreRun_SubThreeChecksFourDecision',N'U') is not null
|
||
drop table dbo.PreRun_SubThreeChecksFourDecision
|
||
CREATE TABLE dbo.PreRun_SubThreeChecksFourDecision(
|
||
DecisionId varchar(50) NOT NULL,--主键
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
SubSystemId varchar(50) NULL,--子系统主键
|
||
ResponsibilityUser varchar(50) NULL,--责任人
|
||
ProposeUser varchar(50) NULL,--提出人
|
||
GeneraUser varchar(50) NULL,--总包
|
||
SupervisionUser varchar(50) NULL,--监理
|
||
OwnerUser varchar(50) NULL,--业主
|
||
ResponsibilityUnit varchar(50) NULL,--责任单位
|
||
QuestionDesc varchar(max) NULL,--整改问题描述（三查四定项）
|
||
Level varchar(50) NULL,--级别
|
||
Speciality varchar(50) NULL,--专业
|
||
AskDestructionTime datetime NULL,--要求销项时间
|
||
RealityDestructionTime datetime NULL,--实际销项时间
|
||
RestrictCondition varchar(max) NULL,--整改方法/制约条件
|
||
ResponsibilityConfirm int NULL,--责任人确认(0:待提交1:未确认2:确认退回3:确认通过)
|
||
ProposeConfirm int NULL,--提出人确认(1:未确认2:确认通过)
|
||
GeneraConfirm int NULL,--总包确认(1:未确认2:确认通过)
|
||
SupervisionConfirm int NULL,--监理确认(1:未确认2:确认通过)
|
||
OwnerConfirm int NULL,--业主确认(1:未确认2:确认通过)
|
||
ResponsibilityConfirmData datetime NULL,--责任人确认时间
|
||
ProposeConfirmData datetime NULL,--提出人确认时间
|
||
GeneraConfirmData datetime NULL,--总包确认时间
|
||
SupervisionConfirmData datetime NULL,--监理确认时间
|
||
OwnerConfirmData datetime NULL,--业主确认时间
|
||
DecisionIsClose int NULL,--尾项是否关闭0:否1:是
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_PreRun_SubThreeChecksFourDecision PRIMARY KEY CLUSTERED
|
||
(
|
||
DecisionId 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'PreRun_DecisionConfirmRecords',N'U') is not null
|
||
drop table dbo.PreRun_DecisionConfirmRecords
|
||
CREATE TABLE dbo.PreRun_DecisionConfirmRecords(
|
||
ConfirmId varchar(50) NOT NULL,--主键
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
DecisionId varchar(50) NULL,--检查项主键
|
||
ConfirmDesc varchar(max) NULL,--确认意见
|
||
ConfirmTime datetime NULL,--确认时间
|
||
ConfirmUser varchar(50) NULL,--确认人
|
||
ConfirmType int NULL,--记录类型1:责任人确认2:提出人确认3:总包确认4:监理确认5:业主确认
|
||
ConfirmState int NULL,--1:确认通过2:确认退回
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
CONSTRAINT PK_PreRun_DecisionConfirmRecords PRIMARY KEY CLUSTERED
|
||
(
|
||
ConfirmId 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'PreRun_InstrumentSysPiping',N'U') is not null
|
||
drop table dbo.PreRun_InstrumentSysPiping
|
||
CREATE TABLE dbo.PreRun_InstrumentSysPiping(
|
||
InstrumentId varchar(50) NOT NULL,--主键
|
||
SystemId varchar(50) NULL,--系统主键
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
InstrumentTag varchar(100) NULL,--仪表位号
|
||
UseTo varchar(200) NULL,--用途
|
||
InstrumentName varchar(100) NULL,--仪表名称
|
||
Supplier varchar(100) NULL,--供货方
|
||
InstallationPosition varchar(50) NULL,--安装位置
|
||
SignalType varchar(50) NULL,--信号类型
|
||
AssociatedSystem varchar(50) NULL,--关联系统
|
||
Cp25 varchar(50) NULL,--CP25
|
||
In11 varchar(50) NULL,--IN11
|
||
In40 varchar(50) NULL,--IN40
|
||
Remark nvarchar(150) NULL,--备注
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_PreRun_InstrumentSysPiping PRIMARY KEY CLUSTERED
|
||
(
|
||
InstrumentId 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'PreRun_SubInstrumentSelect',N'U') is not null
|
||
drop table dbo.PreRun_SubInstrumentSelect
|
||
CREATE TABLE dbo.PreRun_SubInstrumentSelect(
|
||
SubInstrumentId varchar(50) NOT NULL,--主键
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
SubSystemId varchar(50) NULL,--子系统主键
|
||
InstrumentId varchar(50) NULL,--仪表索引主键
|
||
Remark nvarchar(150) NULL,--备注
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_PreRun_SubInstrumentSelect PRIMARY KEY CLUSTERED
|
||
(
|
||
SubInstrumentId 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'PreRun_WorkPackage',N'U') is not null
|
||
drop table dbo.PreRun_WorkPackage
|
||
CREATE TABLE dbo.PreRun_WorkPackage(
|
||
WorkPackId varchar(50) NOT NULL,--主键
|
||
WorkPackName varchar(50) NULL,--名称
|
||
WorkPackType int null,--工作包类型0=全部1=管道2=设备3=仪表索引
|
||
SpecialWorkPack int null,--是否特殊工作包0:否1:是
|
||
Remark nvarchar(150) NULL,--备注
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_PreRun_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 PreRun_WorkPackage where WorkPackId='1C01150C-977E-499A-9173-95F319BEEF87'
|
||
delete PreRun_WorkPackage where WorkPackId='641DA0F4-42A7-4DE3-9A57-95A606016655'
|
||
delete PreRun_WorkPackage where WorkPackId='BEB24AE8-F66D-458B-ADFD-3810405B5EB8'
|
||
delete PreRun_WorkPackage where WorkPackId='02BC1E1E-E531-4738-B6EC-5CE5BDC47B43'
|
||
delete PreRun_WorkPackage where WorkPackId='474F94B6-E927-4E9A-A544-F8E1AE63F6FF'
|
||
delete PreRun_WorkPackage where WorkPackId='3289A3D2-0691-4AD1-BDF3-1FD784564E71'
|
||
delete PreRun_WorkPackage where WorkPackId='445B915B-3E6D-47BE-BFF4-8762695ADB20'
|
||
delete PreRun_WorkPackage where WorkPackId='73C7D1D7-6DA3-44DD-A88B-7DF0FF15AA4F'
|
||
delete PreRun_WorkPackage where WorkPackId='84C6DAD6-3ED8-4869-ADB4-2EDA3512DB16'
|
||
delete PreRun_WorkPackage where WorkPackId='963E658B-CB53-4FEA-BA7D-723C538B2BD5'
|
||
delete PreRun_WorkPackage where WorkPackId='598A028A-5812-40E3-9D9D-5180A36F4453'
|
||
delete PreRun_WorkPackage where WorkPackId='6D827784-6ABD-4327-ABB7-FDABAC99853F'
|
||
delete PreRun_WorkPackage where WorkPackId='4338606F-74BC-4134-8F2B-F7F826BA1E9D'
|
||
delete PreRun_WorkPackage where WorkPackId='61A8B95B-F7A3-4F0D-8358-EF2030D321B4'
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('1C01150C-977E-499A-9173-95F319BEEF87','单机试车',2,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),1)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('641DA0F4-42A7-4DE3-9A57-95A606016655','管道冲洗',1,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),2)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('BEB24AE8-F66D-458B-ADFD-3810405B5EB8','管道吹扫',1,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),3)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('02BC1E1E-E531-4738-B6EC-5CE5BDC47B43','蒸汽吹扫',1,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),4)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('474F94B6-E927-4E9A-A544-F8E1AE63F6FF','化学清洗',1,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),5)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('3289A3D2-0691-4AD1-BDF3-1FD784564E71','烘炉',2,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),6)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('445B915B-3E6D-47BE-BFF4-8762695ADB20','催化剂装填',2,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),7)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('73C7D1D7-6DA3-44DD-A88B-7DF0FF15AA4F','分子筛装填',2,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),8)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('84C6DAD6-3ED8-4869-ADB4-2EDA3512DB16','汽轮机试车',2,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),11)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('963E658B-CB53-4FEA-BA7D-723C538B2BD5','大机组试车',2,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),12)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('598A028A-5812-40E3-9D9D-5180A36F4453','气密',1,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),13)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('6D827784-6ABD-4327-ABB7-FDABAC99853F','清洁度检查',0,0,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),14)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('4338606F-74BC-4134-8F2B-F7F826BA1E9D','电机单试',2,1,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),15)
|
||
INSERT INTO dbo.PreRun_WorkPackage(WorkPackId,WorkPackName,WorkPackType,SpecialWorkPack,Remark,AddUser,AddTime,Sort)
|
||
VALUES('61A8B95B-F7A3-4F0D-8358-EF2030D321B4','仪表回路测试',3,1,'','C4A62EC0-E5D3-4EBF-A5FA-E56AA89633C0',GETDATE(),16)
|
||
go
|
||
|
||
--调整字段长度
|
||
ALTER TABLE PreRun_PropertySysPiping ALTER Column Remark varchar(max) null;
|
||
ALTER TABLE PreRun_TechnologySysPiping ALTER Column Remark varchar(max) null;
|
||
ALTER TABLE PreRun_TechnologySysPiping ALTER Column DrawingNo varchar(max) null;
|
||
|
||
|
||
--老数据清理
|
||
truncate table PreRun_PropertySysPiping
|
||
truncate table PreRun_TechnologySysPiping
|
||
truncate table PreRun_SubPropertySelect
|
||
truncate table PreRun_SubTechnologySelect
|
||
truncate table PreRun_SubInspectTerm
|
||
truncate table PreRun_SubInspectTermItem
|
||
truncate table PreRun_InspectTailTerm
|
||
truncate table PreRun_InspectTermApproveRecords
|
||
truncate table PreRun_InstrumentSysPiping
|
||
truncate table PreRun_SubInstrumentSelect
|
||
go |