183 lines
11 KiB
Transact-SQL
183 lines
11 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='AC5BC922-FA5E-4141-8458-7DE89434A8E7'
|
|
delete Sys_Menu where MenuId='BEAE1E66-5783-489B-A268-F46491AE1257'
|
|
delete Sys_Menu where MenuId='D8DF6DDB-3CDD-41C0-B374-1AAE40802B68'
|
|
delete Sys_Menu where MenuId='C2E827C4-6E04-4EB6-8E51-B43FCBD3753F'
|
|
delete Sys_Menu where MenuId='AF4EEC31-73E9-4F36-BEA7-2A92468F324E'
|
|
delete Sys_Menu where MenuId='7400F47B-3F45-4142-B21F-3BECCABBB202'
|
|
delete Sys_Menu where MenuId='F2D170C3-6CA5-439D-8CC7-81E4FB906B1F'
|
|
delete Sys_Menu where MenuId='A7BBF5F1-F145-43D1-9227-7EC24099BBEC'
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('AC5BC922-FA5E-4141-8458-7DE89434A8E7','检查表模板',null,'TestRun/Produce/InspectTemplate.aspx',2,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('BEAE1E66-5783-489B-A268-F46491AE1257','性能考核管理',null,'TestRun/Produce/SubInspectTerm.aspx',3,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('D8DF6DDB-3CDD-41C0-B374-1AAE40802B68','性能考核确认',null,'TestRun/Produce/SubWorkInspect.aspx',4,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('C2E827C4-6E04-4EB6-8E51-B43FCBD3753F','检查表尾项管理',null,'TestRun/Produce/InspectTailTermList.aspx',5,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('AF4EEC31-73E9-4F36-BEA7-2A92468F324E','尾项处理',null,'TestRun/Produce/TailTermHandleList.aspx',6,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('7400F47B-3F45-4142-B21F-3BECCABBB202','尾项审核',null,'TestRun/Produce/TailTermApproveList.aspx',7,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('F2D170C3-6CA5-439D-8CC7-81E4FB906B1F','检查表会签',null,'TestRun/Produce/InspectWanderAboutList.aspx',8,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
|
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)VALUES('A7BBF5F1-F145-43D1-9227-7EC24099BBEC','检查表流转全部通过',null,'TestRun/Produce/InspectWanderAboutAllPassList.aspx',9,'F4827DE7-FDA6-42B6-A495-616EEFC4C8A5','Menu_TestRun',0,1,1)
|
|
go
|
|
|
|
--==生产性能考核条件检查模板信息表
|
|
if object_id(N'ProduceRun_WorkInspectTemplate',N'U') is not null
|
|
drop table dbo.ProduceRun_WorkInspectTemplate
|
|
CREATE TABLE dbo.ProduceRun_WorkInspectTemplate(
|
|
WorkInspectId varchar(50) NOT NULL,--主键
|
|
WorkInspectName varchar(500) NULL,--检查事项名称
|
|
Remark nvarchar(150) NULL,--备注
|
|
AddUser varchar(50) NULL,--添加人
|
|
AddTime datetime NULL,--添加日期
|
|
Sort int NULL,--排序
|
|
CONSTRAINT PK_ProduceRun_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 ProduceRun_WorkInspectTemplate where WorkInspectId='A95825BD-709E-46DB-AEFD-1E7C9C1BF524'
|
|
delete ProduceRun_WorkInspectTemplate where WorkInspectId='55CB964B-A82A-4BBC-BC2D-040E31C7CC36'
|
|
delete ProduceRun_WorkInspectTemplate where WorkInspectId='EE35FF88-6E30-4797-AE46-0623B9BD3E81'
|
|
delete ProduceRun_WorkInspectTemplate where WorkInspectId='C679A7B8-4244-42E5-96C8-B5A941FF5130'
|
|
delete ProduceRun_WorkInspectTemplate where WorkInspectId='30470FF1-0BA2-4DE0-8CDB-DF812C0AC4B8'
|
|
delete ProduceRun_WorkInspectTemplate where WorkInspectId='E369582C-25FB-49EF-B3ED-4A7EDF8CA61C'
|
|
delete ProduceRun_WorkInspectTemplate where WorkInspectId='2255D8C6-B12D-4035-B56A-11A5815B7C4F'
|
|
delete ProduceRun_WorkInspectTemplate where WorkInspectId='015D647D-ECB4-4252-BA9E-C60190D63F0A'
|
|
delete ProduceRun_WorkInspectTemplate where WorkInspectId='6CDFE6DD-E113-4A07-B5F4-083343672A9E'
|
|
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
|
VALUES('A95825BD-709E-46DB-AEFD-1E7C9C1BF524','在规定的负荷条件下暴露出的问题已经解决，各项工艺指标已处于稳定状态。','','',GETDATE(),1)
|
|
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
|
VALUES('55CB964B-A82A-4BBC-BC2D-040E31C7CC36','全厂相关装置处于稳定运行状态。','','',GETDATE(),2)
|
|
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
|
VALUES('EE35FF88-6E30-4797-AE46-0623B9BD3E81','生产考核方案已制定，并经审核批准。','','',GETDATE(),3)
|
|
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
|
VALUES('C679A7B8-4244-42E5-96C8-B5A941FF5130','测试专用工具和仪表齐备，调校合格，处于有效期内。','','',GETDATE(),4)
|
|
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
|
VALUES('30470FF1-0BA2-4DE0-8CDB-DF812C0AC4B8','测试人员的组织、任务已明确、落实。','','',GETDATE(),5)
|
|
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
|
VALUES('E369582C-25FB-49EF-B3ED-4A7EDF8CA61C','测试项目、分析项目、分析方法已确定。','','',GETDATE(),6)
|
|
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
|
VALUES('2255D8C6-B12D-4035-B56A-11A5815B7C4F','原料、燃料、化学药品等物质数量、规格、质量符合设计文件的要求。','','',GETDATE(),7)
|
|
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
|
VALUES('015D647D-ECB4-4252-BA9E-C60190D63F0A','水、电、气（汽）、原料、燃料、化学药品等确保连续稳定供应。','','',GETDATE(),8)
|
|
INSERT INTO dbo.ProduceRun_WorkInspectTemplate(WorkInspectId,WorkInspectName,Remark,AddUser,AddTime,Sort)
|
|
VALUES('6CDFE6DD-E113-4A07-B5F4-083343672A9E','自控仪表、报警和联锁装置已投入稳定运行。','','',GETDATE(),9)
|
|
go
|
|
|
|
--==工作包检查表
|
|
if object_id(N'ProduceRun_SubInspectTerm',N'U') is not null
|
|
drop table dbo.ProduceRun_SubInspectTerm
|
|
CREATE TABLE dbo.ProduceRun_SubInspectTerm(
|
|
SubInspectId varchar(50) NOT NULL,--主键
|
|
ProjectId varchar(50) NULL,--项目主键
|
|
Contractor varchar(50) null,--承包商
|
|
Owner varchar(50) null,--业主
|
|
ProcessPatent varchar(50) null,--工艺专利商
|
|
ContractorIsAllPass int NULL,--承包商是否通过0/null:未通过 1:通过
|
|
OwnerIsAllPass int NULL,--业主是否通过0/null:未通过 1:通过
|
|
ProcessPatentIsAllPass int NULL,--工艺专利商是否通过0/null:未通过 1:通过
|
|
ContractorAllPassData datetime null,--承包商通过日期
|
|
OwnerAllPassData datetime null,--业主通过日期
|
|
ProcessPatentAllPassData 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_ProduceRun_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'ProduceRun_SubInspectTermItem',N'U') is not null
|
|
drop table dbo.ProduceRun_SubInspectTermItem
|
|
CREATE TABLE dbo.ProduceRun_SubInspectTermItem(
|
|
TermItemId varchar(50) NOT NULL,--主键
|
|
ProjectId 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,--检查说明
|
|
Contractor varchar(50) null,--承包商
|
|
Owner varchar(50) null,--业主
|
|
ProcessPatent varchar(50) null,--工艺专利商
|
|
ContractorIsPass int NULL,--承包商是否通过0/null:未通过 1:通过
|
|
OwnerIsPass int NULL,--业主是否通过0/null:未通过 1:通过
|
|
ProcessPatentIsPass int NULL,--工艺专利商是否通过0/null:未通过 1:通过
|
|
ContractorRemark varchar(1000) NULL,--承包商备注
|
|
OwnerRemark varchar(1000) NULL,--业主备注
|
|
ProcessPatentRemark varchar(1000) NULL,--工艺专利商备注
|
|
Remark varchar(200) NULL,--备注
|
|
AddUser varchar(50) NULL,--添加人
|
|
AddTime datetime NULL,--添加日期
|
|
Sort int NULL,--排序
|
|
CONSTRAINT PK_ProduceRun_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'ProduceRun_InspectTailTerm',N'U') is not null
|
|
drop table dbo.ProduceRun_InspectTailTerm
|
|
CREATE TABLE dbo.ProduceRun_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_ProduceRun_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'ProduceRun_InspectTermApproveRecords',N'U') is not null
|
|
drop table dbo.ProduceRun_InspectTermApproveRecords
|
|
CREATE TABLE dbo.ProduceRun_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_ProduceRun_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 |