63 lines
4.7 KiB
Transact-SQL
63 lines
4.7 KiB
Transact-SQL
--==系统工作包检查表
|
|
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:通过
|
|
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
|
|
|
|
update Sys_Menu set SortIndex=20 where MenuId='29F80818-17A5-4BC0-8C38-A17415B0AC83'
|
|
delete Sys_Menu where MenuId in ('4041089F-5CC2-4070-9556-7DAB83CF6292','2232ED9A-EA3C-4CB5-A53C-D96D3F5E0527','9489BD6A-1A95-43BC-85C0-A65751C2C85E','26F8468D-4358-4E2A-895D-8720A6F1FA89','7081E94C-6A73-40A7-A72A-A13CDB7B5420','6ED76128-1E03-4B65-B474-BF84C536D027','2A441F42-57EF-4480-911A-1E17815C1B6B')
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('4041089F-5CC2-4070-9556-7DAB83CF6292','检查表尾项管理',null,'TestRun/TestRunManage/InspectTailTermList.aspx',7,'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('2232ED9A-EA3C-4CB5-A53C-D96D3F5E0527','尾项处理',null,'TestRun/TestRunManage/TailTermHandleList.aspx',8,'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('9489BD6A-1A95-43BC-85C0-A65751C2C85E','尾项审核',null,'TestRun/TestRunManage/TailTermApproveList.aspx',9,'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('26F8468D-4358-4E2A-895D-8720A6F1FA89','检查表会签',null,'TestRun/TestRunManage/InspectWanderAboutList.aspx',10,'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('7081E94C-6A73-40A7-A72A-A13CDB7B5420','检查表流转全部通过',null,'TestRun/TestRunManage/InspectWanderAboutAllPassList.aspx',11,'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('6ED76128-1E03-4B65-B474-BF84C536D027','现场实施',null,'TestRun/TestRunManage/SiteImplementationList.aspx',12,'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('2A441F42-57EF-4480-911A-1E17815C1B6B','试车记录上传',null,'TestRun/TestRunManage/TestRunRecordUploadList.aspx',13,'0217CE50-3ABB-44F8-A38A-C9792C436639','Menu_TestRun',0,1,1)
|
|
go
|
|
|
|
truncate table TestRun_SubInspectTerm
|
|
truncate table TestRun_SubInspectTermItem
|
|
truncate table TestRun_TermItemInspectedUser
|
|
truncate table TestRun_InspectTailTerm
|
|
truncate table TestRun_InspectTermApproveRecords
|