395 lines
32 KiB
Transact-SQL
395 lines
32 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
|
||
|
||
delete Sys_Menu where MenuId='EE7E37CA-384F-41B3-BAEE-89CBD9954AB3'
|
||
delete Sys_Menu where MenuId='E9EF7C6D-7F0A-4FBA-8A79-474D4E61AF27'
|
||
delete Sys_Menu where MenuId='9ACDF513-BD63-48F5-BFA3-B9B1B7FA19E1'
|
||
delete Sys_Menu where MenuId='3D554109-D95F-4051-8A6C-5616A7A95C94'
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('EE7E37CA-384F-41B3-BAEE-89CBD9954AB3','预试车进度',null,'TestRun/Report/PreRunSchedule.aspx',1,'2BF9C16D-536F-4F89-AA59-49ED1A1A164C','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('E9EF7C6D-7F0A-4FBA-8A79-474D4E61AF27','三查四定进度',null,'TestRun/Report/FourDecisionSchedule.aspx',2,'2BF9C16D-536F-4F89-AA59-49ED1A1A164C','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('9ACDF513-BD63-48F5-BFA3-B9B1B7FA19E1','试车进度',null,'TestRun/Report/TestRunSchedule.aspx',3,'2BF9C16D-536F-4F89-AA59-49ED1A1A164C','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('3D554109-D95F-4051-8A6C-5616A7A95C94','首页进度设置',null,'TestRun/Report/ScheduleSetUp.aspx',4,'2BF9C16D-536F-4F89-AA59-49ED1A1A164C','Menu_TestRun',0,1,1)
|
||
go
|
||
|
||
--==预试车/试车/三查四定参数设置
|
||
if object_id(N'Run_ScheduleSetUp',N'U') is not null
|
||
drop table dbo.Run_ScheduleSetUp
|
||
CREATE TABLE dbo.Run_ScheduleSetUp(
|
||
ScheduleId varchar(50) NOT NULL,--主键
|
||
WorkPackId varchar(50) NULL,--工作包主键
|
||
LevelName varchar(50) NULL,--三查四定类别名称
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
States int null,--类型1:预试车2:试车3:三查四定
|
||
AllNum int null,--全部数量
|
||
ProgressNum int NULL,--进行中数量
|
||
CompleteNum int NULL,--完成数量
|
||
NotStartedNum int NULL,--未开始数量
|
||
CompleteRate decimal(18,2) NULL,--完成率
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_Run_ScheduleSetUp PRIMARY KEY CLUSTERED
|
||
(
|
||
ScheduleId 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
|
||
|
||
|
||
--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
|
||
|
||
delete Sys_Menu where MenuId='B148D864-DA22-43C5-8D52-F38C0D34C7D5'
|
||
delete Sys_Menu where MenuId='AB9AD56B-574E-41DC-8E89-5982A287C358'
|
||
delete Sys_Menu where MenuId='A11DDC01-8F1F-4D09-A85C-1C459741DDB3'
|
||
delete Sys_Menu where MenuId='AC20AFEE-6B0D-45D1-8BA5-80904DA4CFFE'
|
||
delete Sys_Menu where MenuId='7C1E0ED5-518D-4C5B-8910-A25859A9C7EB'
|
||
delete Sys_Menu where MenuId='0AC1D5B3-9E0B-4AC4-BB24-0A9F3953316C'
|
||
delete Sys_Menu where MenuId='81162C96-2E10-4936-A2AD-B221B7966C85'
|
||
delete Sys_Menu where MenuId='0BF6BC64-8F72-47EA-A5B9-60ACC14619AC'
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('B148D864-DA22-43C5-8D52-F38C0D34C7D5','检查表模板',null,'TestRun/Feeding/InspectTemplate.aspx',2,'81CE1758-5BBC-4709-AF4B-DDF6CB345571','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('AB9AD56B-574E-41DC-8E89-5982A287C358','投料试车管理',null,'TestRun/Feeding/SubInspectTerm.aspx',3,'81CE1758-5BBC-4709-AF4B-DDF6CB345571','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('A11DDC01-8F1F-4D09-A85C-1C459741DDB3','投料试车确认',null,'TestRun/Feeding/SubWorkInspect.aspx',4,'81CE1758-5BBC-4709-AF4B-DDF6CB345571','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('AC20AFEE-6B0D-45D1-8BA5-80904DA4CFFE','检查表尾项管理',null,'TestRun/Feeding/InspectTailTermList.aspx',5,'81CE1758-5BBC-4709-AF4B-DDF6CB345571','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('7C1E0ED5-518D-4C5B-8910-A25859A9C7EB','尾项处理',null,'TestRun/Feeding/TailTermHandleList.aspx',6,'81CE1758-5BBC-4709-AF4B-DDF6CB345571','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('0AC1D5B3-9E0B-4AC4-BB24-0A9F3953316C','尾项审核',null,'TestRun/Feeding/TailTermApproveList.aspx',7,'81CE1758-5BBC-4709-AF4B-DDF6CB345571','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('81162C96-2E10-4936-A2AD-B221B7966C85','检查表会签',null,'TestRun/Feeding/InspectWanderAboutList.aspx',8,'81CE1758-5BBC-4709-AF4B-DDF6CB345571','Menu_TestRun',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('0BF6BC64-8F72-47EA-A5B9-60ACC14619AC','检查表流转全部通过',null,'TestRun/Feeding/InspectWanderAboutAllPassList.aspx',9,'81CE1758-5BBC-4709-AF4B-DDF6CB345571','Menu_TestRun',0,1,1)
|
||
--INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('0BF6BC64-8F72-47EA-A5B9-60ACC14619AC','投料试车申请',null,'TestRun/Feeding/FeedingRunApplication.aspx',10,'81CE1758-5BBC-4709-AF4B-DDF6CB345571','Menu_TestRun',0,1,1)
|
||
go
|
||
|
||
--==投料试车工作包检查模板信息表
|
||
if object_id(N'FeedingRun_WorkInspectTemplate',N'U') is not null
|
||
drop table dbo.FeedingRun_WorkInspectTemplate
|
||
CREATE TABLE dbo.FeedingRun_WorkInspectTemplate(
|
||
WorkInspectId varchar(50) NOT 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_FeedingRun_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 FeedingRun_WorkInspectTemplate where WorkInspectId='B92C0CE3-F42E-48E9-90A4-8B949459B24E'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='9B01E80A-E6E8-405B-9D14-DB9A68907899'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='A4FA80D2-D39A-4FB6-A9CA-08116B0AEF36'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='3085EB15-1C91-4371-AC4F-459FE1557146'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='CE222946-EA4F-4DB2-A1E1-D98F7BF59DED'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='3EC36453-D235-49C1-ABD3-9A1BDC3ED24E'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='124F2849-CCCC-4589-BF5A-66EDF3CE8548'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='73AAEBD4-B65E-4BD0-9D45-FCD6018CC483'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='E3F13A3C-E3A4-46F8-A6A8-B56D93EEB5F1'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='A40B8BD5-2C39-4811-ABDA-EFE68548B60A'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='DAABBEC3-E010-4FCB-95CC-E633271C432A'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='0EE9EC41-E468-4E78-9358-0903FD24A2A8'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='BE2C3723-B68F-4B61-BD9F-C0662D08D969'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='077EFE01-8FD0-4596-B56D-34A3F177F14B'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='B94CBA06-9D3E-4C3C-BB43-AC9A5A09C253'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='2A32519C-5B9C-4788-AEAD-48551C183F0C'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='D19D7E82-033F-47F0-B7A2-1A33BC341F3D'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='C0B50D95-8487-401D-9C6B-6054B1F85A4C'
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('B92C0CE3-F42E-48E9-90A4-8B949459B24E','设备、管道安装完成，符合施工验收规范要求。','','设备、管道系统','',GETDATE(),1)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('9B01E80A-E6E8-405B-9D14-DB9A68907899','保温、保冷完成，符合施工验收规范要求。','','设备、管道系统','',GETDATE(),2)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('A4FA80D2-D39A-4FB6-A9CA-08116B0AEF36','“三查四定”的问题整改消缺完毕，无影响投用尾项。','','设备、管道系统','',GETDATE(),3)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('3085EB15-1C91-4371-AC4F-459FE1557146','设备、管道的耐压试验合格。','','设备、管道系统','',GETDATE(),4)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('CE222946-EA4F-4DB2-A1E1-D98F7BF59DED','设备、管道化学清洗合格。','','设备、管道系统','',GETDATE(),5)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('3EC36453-D235-49C1-ABD3-9A1BDC3ED24E','系统冲洗、吹扫合格。','','设备、管道系统','',GETDATE(),6)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('124F2849-CCCC-4589-BF5A-66EDF3CE8548','工业炉烘炉合格。','','设备、管道系统','',GETDATE(),7)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('73AAEBD4-B65E-4BD0-9D45-FCD6018CC483','工业炉煮炉合格。','','设备、管道系统','',GETDATE(),8)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('E3F13A3C-E3A4-46F8-A6A8-B56D93EEB5F1','填料、分子筛、催化剂装填合格。','','设备、管道系统','',GETDATE(),9)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('A40B8BD5-2C39-4811-ABDA-EFE68548B60A','安全阀、呼吸阀整定合格、处于完好投用状态。','','设备、管道系统','',GETDATE(),10)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('DAABBEC3-E010-4FCB-95CC-E633271C432A','爆破板安装正确、处于完好投用状态。','','设备、管道系统','',GETDATE(),11)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('0EE9EC41-E468-4E78-9358-0903FD24A2A8','8字盲板处于正确位置。','','设备、管道系统','',GETDATE(),12)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('BE2C3723-B68F-4B61-BD9F-C0662D08D969','支吊架安装符合要求。','','设备、管道系统','',GETDATE(),13)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('077EFE01-8FD0-4596-B56D-34A3F177F14B','弹簧支吊架调整合格、处于完好投用状态。','','设备、管道系统','',GETDATE(),14)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('B94CBA06-9D3E-4C3C-BB43-AC9A5A09C253','系统严密性试验合格（在操作压力下）。','','设备、管道系统','',GETDATE(),15)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('2A32519C-5B9C-4788-AEAD-48551C183F0C','机器单机试车合格。','','设备、管道系统','',GETDATE(),16)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('D19D7E82-033F-47F0-B7A2-1A33BC341F3D','循环水系统预膜合格，各项指标符合要求。','','设备、管道系统','',GETDATE(),17)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('C0B50D95-8487-401D-9C6B-6054B1F85A4C','系统联动试车已完成，暴露的问题已处理。','','设备、管道系统','',GETDATE(),18)
|
||
go
|
||
--==电仪系统
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='1109473C-D1E4-4E9B-8A66-2A298AA86418'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='022A14CF-2496-4E34-9A81-3DDB8337AC84'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='B68A9BFE-F237-4C32-B99B-366717778F0B'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='5829644C-344D-45D7-9A9F-99F9C8B7F637'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='F9563CAD-D5E2-45A5-BF97-BDF2E97FED17'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='B84388E6-FEB5-4F42-AC1A-9260EB6C110F'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='E1242BD0-92D6-4AF2-98B8-FD8FE4690372'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='8A1A24D3-BEDE-47B3-88E4-7E7354AC6243'
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('1109473C-D1E4-4E9B-8A66-2A298AA86418','电气仪表安装，符合施工验收规范要求。','','电仪系统','',GETDATE(),19)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('022A14CF-2496-4E34-9A81-3DDB8337AC84','电气设备的继电调整和绝缘试验已合格。','','电仪系统','',GETDATE(),20)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('B68A9BFE-F237-4C32-B99B-366717778F0B','防雷防静电设施测试合格、可靠。','','电仪系统','',GETDATE(),21)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('5829644C-344D-45D7-9A9F-99F9C8B7F637','自控仪表调试合格，指示、控制、报警及联锁整定值及静态调试合格。','','电仪系统','',GETDATE(),22)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('F9563CAD-D5E2-45A5-BF97-BDF2E97FED17','集散系统的校线及接地电阻测试符合规定，硬件和软件系统经检查符合要求。','','电仪系统','',GETDATE(),23)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('B84388E6-FEB5-4F42-AC1A-9260EB6C110F','可编程逻辑控制器保护装置的软件检查测试合格，联锁及报警值准确、可靠。','','电仪系统','',GETDATE(),24)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('E1242BD0-92D6-4AF2-98B8-FD8FE4690372','系统联调合格、可靠。','','电仪系统','',GETDATE(),25)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('8A1A24D3-BEDE-47B3-88E4-7E7354AC6243','自动分析仪表调试合格，样气配制合格。','','电仪系统','',GETDATE(),26)
|
||
go
|
||
--==公用系统
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='11FAF5F3-F658-401A-B2DB-62CFF2D1FD69'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='DDB6A90E-699B-4C0D-BBDF-5538EFFE529F'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='AA10911E-24B5-4CD1-8F71-A018D20DF3CA'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='7F8D020F-3C26-4FD9-91CB-39234DBEB08B'
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('11FAF5F3-F658-401A-B2DB-62CFF2D1FD69','水、电、汽、仪表空气、工厂空气等可按设计值保证供应。','','公用系统','',GETDATE(),27)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('DDB6A90E-699B-4C0D-BBDF-5538EFFE529F','氮气可按设计值保证供应。','','公用系统','',GETDATE(),28)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('AA10911E-24B5-4CD1-8F71-A018D20DF3CA','原料、燃料及辅助原料、润滑油脂等备齐，质量符合设计要求，已运至指定地点。','','公用系统','',GETDATE(),29)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('7F8D020F-3C26-4FD9-91CB-39234DBEB08B','贮运系统具备使用条件，计量仪器标定合格。','','公用系统','',GETDATE(),30)
|
||
go
|
||
--==消防、安全、环境保护系统
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='70A152F1-6990-4689-86B9-CB1AB14CB989'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='4EB2C35C-A6D4-4936-987A-C244621BC69F'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='A423531C-2CDB-4314-A45B-6C28129EDC21'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='57E47D49-F0A1-4073-9CF5-B472F83045E7'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='B4FCB05F-5B31-405A-AFA2-87EBFDA79FBE'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='48DC92A0-9CEC-4613-BF43-21E7193C82EB'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='214C5DFD-A5AB-45F7-81E2-981848CDF110'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='466D5F4E-2AA4-4246-A8B9-D9B2335F7AB4'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='F00B0F0D-97DF-449B-94CC-C586CC2CBF91'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='A80AF744-AD43-494F-BDD2-6873A31AE71E'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='F85C5F64-78EB-42A8-9DD9-1EED976880DF'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='E189A48A-D91E-4D8E-AF71-3A731BEF2FC8'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='4A41BCC6-1EAE-4877-A70A-B59E52BD68E5'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='26D81F27-B1D1-4222-A020-615AE561C96B'
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('70A152F1-6990-4689-86B9-CB1AB14CB989','消防水系统调试合格，处于完好投用状态。','','消防、安全、环境保护系统','',GETDATE(),31)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('4EB2C35C-A6D4-4936-987A-C244621BC69F','泡沫、干粉、二氧化碳消防调试合格，处于完好投用状态。','','消防、安全、环境保护系统','',GETDATE(),32)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('A423531C-2CDB-4314-A45B-6C28129EDC21','可燃气体报警、有毒气体报警、火灾报警系统等调试合格，处于完好投用状态。','','消防、安全、环境保护系统','',GETDATE(),33)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('57E47D49-F0A1-4073-9CF5-B472F83045E7','HSE评估完毕，并制定相应的安全措施和（或）事故预案。','','消防、安全、环境保护系统','',GETDATE(),34)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('B4FCB05F-5B31-405A-AFA2-87EBFDA79FBE','动火制度、禁烟制度、车辆管理制度等安全监督管理制度已建立并公布。','','消防、安全、环境保护系统','',GETDATE(),35)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('48DC92A0-9CEC-4613-BF43-21E7193C82EB','道路通行标志、防辐射标志及其它警示标志齐全，试车区域已划定。','','消防、安全、环境保护系统','',GETDATE(),36)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('214C5DFD-A5AB-45F7-81E2-981848CDF110','岗位消防器材、护具已备齐，人人会用。','','消防、安全、环境保护系统','',GETDATE(),37)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('466D5F4E-2AA4-4246-A8B9-D9B2335F7AB4','消防、救护措施已落实，并进行过消防演习。','','消防、安全、环境保护系统','',GETDATE(),38)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('F00B0F0D-97DF-449B-94CC-C586CC2CBF91','现场急救站已建立，并备有救护车等，实行24 小时值班。','','消防、安全、环境保护系统','',GETDATE(),39)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('A80AF744-AD43-494F-BDD2-6873A31AE71E','系统隔离已完成，临时措施符合要求。','','消防、安全、环境保护系统','',GETDATE(),40)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('F85C5F64-78EB-42A8-9DD9-1EED976880DF','盲板管理已有专人负责，进行动态管理，设有台帐，现场挂牌。','','消防、安全、环境保护系统','',GETDATE(),41)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('E189A48A-D91E-4D8E-AF71-3A731BEF2FC8','现场保卫已落实（组织、人员、交通工具等）','','消防、安全、环境保护系统','',GETDATE(),42)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('4A41BCC6-1EAE-4877-A70A-B59E52BD68E5','厂区道路畅通，与生产无关杂物已清除。','','消防、安全、环境保护系统','',GETDATE(),43)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('26D81F27-B1D1-4222-A020-615AE561C96B','“三废处理”装置已具备投用条件。','','消防、安全、环境保护系统','',GETDATE(),44)
|
||
go
|
||
--==分析化验
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='7AFC8355-1216-4179-BCDE-8BD1E7001D58'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='955DD47A-DE0C-46B5-B92E-849688B51EF0'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='5EC53FA6-87D3-4D1A-8212-75D011D1DEFB'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='B2DEC6CE-B3CE-414E-BEED-9DC1CB263837'
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('7AFC8355-1216-4179-BCDE-8BD1E7001D58','中化室、分析室已建立正常分析化验制度，分析方法已确定。','','分析化验','',GETDATE(),45)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('955DD47A-DE0C-46B5-B92E-849688B51EF0','分析化验设施、试剂、标准溶液已备齐待用，满足要求。','','分析化验','',GETDATE(),46)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('5EC53FA6-87D3-4D1A-8212-75D011D1DEFB','采样点已确定，采样器具、采样责任已落实。','','分析化验','',GETDATE(),47)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('B2DEC6CE-B3CE-414E-BEED-9DC1CB263837','模拟采样、模拟分析已演练。','','分析化验','',GETDATE(),48)
|
||
go
|
||
--==组织、人员、通讯、方案、规定
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='9DE2BBE1-E626-4BF6-92F9-A3AF50F8BFEF'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='2EC0EF93-1D55-46EB-9596-F891FD4A7937'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='72B4AF8C-9467-488C-A48D-0D66BD877F1B'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='07DBD283-DD4D-4009-B1CA-CE7514BDA749'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='60AEE8E8-FFEB-4DA6-AFE0-AC273926E47D'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='A326DEF3-8A7F-40A2-B162-156DB80A9B42'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='332E6B45-B972-4A8E-B22C-5213ADA2E4E7'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='A99B4DE2-6647-4AD5-8238-D7E2E6C5ACED'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='F29A52BF-3209-4180-BE6F-1F20508B6AF2'
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('9DE2BBE1-E626-4BF6-92F9-A3AF50F8BFEF','各级试车指挥组织已经建立，操作人员已配齐，已按要求上岗。','','组织、人员、通讯、方案、规定','',GETDATE(),49)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('2EC0EF93-1D55-46EB-9596-F891FD4A7937','试车调度系统已正常运行。','','组织、人员、通讯、方案、规定','',GETDATE(),50)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('72B4AF8C-9467-488C-A48D-0D66BD877F1B','装置人员已经过安全教育。','','组织、人员、通讯、方案、规定','',GETDATE(),51)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('07DBD283-DD4D-4009-B1CA-CE7514BDA749','指挥系统的通讯畅通。','','组织、人员、通讯、方案、规定','',GETDATE(),52)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('60AEE8E8-FFEB-4DA6-AFE0-AC273926E47D','岗位、直通电话已开通好用。','','组织、人员、通讯、方案、规定','',GETDATE(),53)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('A326DEF3-8A7F-40A2-B162-156DB80A9B42','调度、火警、急救电话可靠好用。','','组织、人员、通讯、方案、规定','',GETDATE(),54)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('332E6B45-B972-4A8E-B22C-5213ADA2E4E7','无线电话、报话机呼叫清晰。','','组织、人员、通讯、方案、规定','',GETDATE(),55)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('A99B4DE2-6647-4AD5-8238-D7E2E6C5ACED','试车方案、管理规定、安全规程、分析规程等技术资料已批准、颁发。','','组织、人员、通讯、方案、规定','',GETDATE(),56)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('F29A52BF-3209-4180-BE6F-1F20508B6AF2','岗位操作记录、试车专用表格等准备齐全。','','组织、人员、通讯、方案、规定','',GETDATE(),57)
|
||
go
|
||
--==保运、后勤保障
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='4BC591DA-1188-45FA-884C-AA49D71B9396'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='51F178FB-E61F-4853-B1A4-931345C09335'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='10396FC3-AB9B-4E40-99E1-61D3FD388C2B'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='2CBB0275-90FA-48E9-83DC-4862E8F8E382'
|
||
delete FeedingRun_WorkInspectTemplate where WorkInspectId='BAD731C2-2AC3-40E4-A3AA-69FFD13F8C0B'
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('4BC591DA-1188-45FA-884C-AA49D71B9396','保运队伍已组成，范围、责任已明确。','','保运、后勤保障','',GETDATE(),58)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('51F178FB-E61F-4853-B1A4-931345C09335','机、电、仪修人员已上岗。','','保运、后勤保障','',GETDATE(),59)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('10396FC3-AB9B-4E40-99E1-61D3FD388C2B','保运装备、工器具已落实。','','保运、后勤保障','',GETDATE(),60)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('2CBB0275-90FA-48E9-83DC-4862E8F8E382','各类备品、备件、专用工、器具等已备齐。','','保运、后勤保障','',GETDATE(),61)
|
||
INSERT INTO dbo.FeedingRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,GroupName,AddUser,AddTime,Sort)
|
||
VALUES('BAD731C2-2AC3-40E4-A3AA-69FFD13F8C0B','生活后勤服务已落实。','','保运、后勤保障','',GETDATE(),62)
|
||
go
|
||
|
||
--==工作包检查表
|
||
if object_id(N'FeedingRun_SubInspectTerm',N'U') is not null
|
||
drop table dbo.FeedingRun_SubInspectTerm
|
||
CREATE TABLE dbo.FeedingRun_SubInspectTerm(
|
||
SubInspectId varchar(50) NOT NULL,--主键
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
InstallationId varchar(50) NULL,--装置主键
|
||
DriverCharge varchar(50) null,--装置开车负责人
|
||
DrivingManager varchar(50) null,--开车经理
|
||
ProjectManager varchar(50) null,--项目经理
|
||
DriverChargeIsAllPass int NULL,--装置开车负责人是否通过0/null:未通过 1:通过
|
||
DrivingManagerIsAllPass int NULL,--开车经理是否通过0/null:未通过 1:通过
|
||
ProjectManagerIsAllPass int NULL,--项目经理是否通过0/null:未通过 1:通过
|
||
DriverChargeAllPassData datetime null,--装置开车负责人通过日期
|
||
DrivingManagerAllPassData datetime null,--开车经理通过日期
|
||
ProjectManagerAllPassData datetime null,--项目经理通过日期
|
||
InspectionIsAllPass int NULL,--检查结果0/null:未通过 1:通过
|
||
WanderIsComplete int null,--检查表流转是否全部通过0:未通过1:通过
|
||
WanderCompleteData datetime null,--检查表流转完成日期
|
||
IsUnifyWanderAbout int null,--是否统一流转0:否1:是
|
||
UnifyWanderAboutData datetime null,--统一流转时间
|
||
UnifyWanderAboutOpinion varchar(max) null,--统一流转备注
|
||
InspectIsClose int null,--任务单是否关闭0:未关闭1:已关闭
|
||
InspectCloseData datetime null,--任务单关闭日期
|
||
InspectTime datetime NULL,--检查时间
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
CONSTRAINT PK_FeedingRun_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'FeedingRun_SubInspectTermItem',N'U') is not null
|
||
drop table dbo.FeedingRun_SubInspectTermItem
|
||
CREATE TABLE dbo.FeedingRun_SubInspectTermItem(
|
||
TermItemId varchar(50) NOT NULL,--主键
|
||
ProjectId varchar(50) NULL,--项目主键
|
||
InstallationId varchar(50) NULL,--装置主键
|
||
SubInspectId varchar(50) NULL,--检查表主键
|
||
GroupName varchar(50) NULL,--分组名称
|
||
WorkInspectId varchar(50) NOT NULL,--工作包模板项主键
|
||
WorkInspectName varchar(500) NULL,--检查事项名称
|
||
InspectedUser varchar(50) NULL,--检查人主键
|
||
InspectionResults int NULL,--检查结果0:未通过 1:通过
|
||
InspectionIllustrate varchar(200) NULL,--检查说明
|
||
DriverCharge varchar(50) null,--装置开车负责人
|
||
DrivingManager varchar(50) null,--开车经理
|
||
ProjectManager varchar(50) null,--项目经理
|
||
DriverChargeIsPass int NULL,--装置开车负责人是否通过0/null:未通过 1:通过
|
||
DrivingManagerIsPass int NULL,--开车经理是否通过0/null:未通过 1:通过
|
||
ProjectManagerIsPass int NULL,--项目经理是否通过0/null:未通过 1:通过
|
||
DriverChargeRemark varchar(1000) NULL,--装置开车负责人备注
|
||
DrivingManagerRemark varchar(1000) NULL,--开车经理备注
|
||
ProjectManagerRemark varchar(1000) NULL,--项目经理备注
|
||
Remark varchar(200) NULL,--备注
|
||
AddUser varchar(50) NULL,--添加人
|
||
AddTime datetime NULL,--添加日期
|
||
Sort int NULL,--排序
|
||
CONSTRAINT PK_FeedingRun_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'FeedingRun_InspectTailTerm',N'U') is not null
|
||
drop table dbo.FeedingRun_InspectTailTerm
|
||
CREATE TABLE dbo.FeedingRun_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,--检查项主键
|
||
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_FeedingRun_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'FeedingRun_InspectTermApproveRecords',N'U') is not null
|
||
drop table dbo.FeedingRun_InspectTermApproveRecords
|
||
CREATE TABLE dbo.FeedingRun_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_FeedingRun_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 |