423 lines
22 KiB
Transact-SQL
423 lines
22 KiB
Transact-SQL
|
||
|
||
update InApproveManager_EquipmentInItem set IsUsed=1
|
||
update InApproveManager_GeneralEquipmentInItem set IsUsed=1
|
||
GO
|
||
|
||
|
||
ALTER VIEW [dbo].[View_License_LicenseManager]
|
||
AS
|
||
/*现场安全许可证*/
|
||
SELECT LicenseManager.LicenseManagerId,
|
||
LicenseManager.ProjectId,
|
||
LicenseManager.LicenseTypeId,
|
||
LicenseManager.LicenseManagerCode,
|
||
LicenseManager.LicenseManageName,
|
||
LicenseManager.UnitId,
|
||
LicenseManager.LicenseManageContents,
|
||
LicenseManager.CompileMan,
|
||
LicenseManager.CompileDate,
|
||
LicenseManager.States,
|
||
Project.ProjectCode,
|
||
Project.ProjectName,
|
||
LicenseType.LicenseTypeName,
|
||
Unit.UnitName,
|
||
UnitType.UnitTypeId,
|
||
UnitType.UnitTypeName,
|
||
Users.UserName,
|
||
LicenseManager.WorkAreaId,
|
||
--WorkArea.WorkAreaName,
|
||
LicenseManager.StartDate,
|
||
LicenseManager.EndDate,
|
||
LicenseManager.ApplicantMan,
|
||
LicenseManager.IsHighRisk,
|
||
LicenseManager.WorkStates,
|
||
case LicenseManager.WorkStates when '1' then '待开工'
|
||
when '2' then '作业中'
|
||
when '3' then '已关闭'
|
||
when '-1' then '已取消'
|
||
else '' end as WorkStatesStr,
|
||
WorkAreaName = STUFF(( SELECT ',' + UnitWorkName FROM WBS_UnitWork
|
||
where PATINDEX('%,' + RTRIM(WBS_UnitWork.UnitWorkId) + ',%',',' + LicenseManager.WorkAreaId + ',')>0
|
||
ORDER BY PATINDEX('%,' + RTRIM(LicenseManager.WorkAreaId) + ',%',',' + LicenseManager.WorkAreaId + ',')
|
||
FOR XML PATH('')), 1, 1,'')
|
||
FROM dbo.License_LicenseManager AS LicenseManager
|
||
LEFT JOIN dbo.Base_Project AS Project ON Project.ProjectId = LicenseManager.ProjectId
|
||
LEFT JOIN dbo.Base_LicenseType AS LicenseType ON LicenseType.LicenseTypeId = LicenseManager.LicenseTypeId
|
||
LEFT JOIN dbo.Base_Unit AS Unit ON Unit.UnitId = LicenseManager.UnitId
|
||
LEFT JOIN dbo.Sys_User AS Users ON Users.UserId = LicenseManager.CompileMan
|
||
LEFT JOIN dbo.WBS_UnitWork AS WorkArea ON WorkArea.UnitWorkId = LicenseManager.WorkAreaId
|
||
LEFT JOIN dbo.Base_UnitType as UnitType ON UnitType.UnitTypeId=Unit.UnitTypeId
|
||
|
||
|
||
|
||
GO
|
||
|
||
|
||
update License_LicenseManager set WorkStates='3'
|
||
GO
|
||
|
||
update HSSE_Hazard_HazardRegister set Risk_Level='一般'
|
||
GO
|
||
|
||
|
||
/**********隐患巡检（手机端）视图*************/
|
||
ALTER VIEW [dbo].[View_Hazard_HazardRegister]
|
||
AS
|
||
SELECT Registration.HazardRegisterId,
|
||
Registration.HazardCode,
|
||
Registration.RegisterDate,
|
||
Registration.RegisterDef,
|
||
Registration.Rectification,
|
||
Registration.Place,
|
||
Registration.ResponsibleUnit,
|
||
Registration.Observer,
|
||
Registration.Risk_Level,
|
||
Registration.RectifiedDate,
|
||
Registration.ProjectId,
|
||
Project.UnitId AS PUnitId,
|
||
ProjectUnit.UnitName AS PUnitName,
|
||
Registration.states,
|
||
Registration.IsEffective,
|
||
Registration.ResponsibleMan,
|
||
Registration.CheckManId,
|
||
Registration.CheckTime,
|
||
Registration.RectificationPeriod,
|
||
Registration.ImageUrl,
|
||
Registration.RectificationImageUrl,
|
||
Registration.RectificationTime,
|
||
Registration.ConfirmMan,
|
||
Registration.ConfirmDate,
|
||
Registration.HandleIdea,
|
||
Registration.CutPayment,
|
||
Registration.ProblemTypes,
|
||
Registration.CheckSpecialId,
|
||
Registration.CheckItemDetailId,
|
||
Registration.SupCheckItemSetId,
|
||
Registration.CheckItemSetId,
|
||
Registration.SafeSupervisionId,
|
||
Registration.SafeSupervisionIsOK,
|
||
Project.ProjectName,
|
||
Registration.CheckCycle,
|
||
ISNULL(WorkArea.UnitWorkName,'') AS WorkAreaName,
|
||
Unit.UnitName as ResponsibilityUnitName,
|
||
User1.UserName AS ResponsibilityManName,
|
||
ISNULL(User1.Telephone,'') AS ResponsibilityManTel,
|
||
User2.UserName AS CheckManName,
|
||
ISNULL(User2.Telephone,'') AS CheckManTel,
|
||
User2.UnitId AS SendUnitId,
|
||
User3.UserName AS ConfirmManName,
|
||
ISNULL(User3.Telephone,'') AS ConfirmManTel,
|
||
User4.UserName AS ResponsibilityManName2,
|
||
ISNULL(User4.Telephone,'') AS ResponsibilityMan2Tel,
|
||
(CASE WHEN Registration.states='1' and (Registration.SafeSupervisionIsOK is null OR Registration.SafeSupervisionIsOK=0) THEN '待整改'
|
||
WHEN Registration.states='1' and Registration.SafeSupervisionIsOK=1 THEN '合格'
|
||
WHEN Registration.states='2' THEN '已整改-待复查验收'
|
||
WHEN Registration.states='3' THEN '已闭环'
|
||
ELSE '已作废' END ) AS StatesStr,
|
||
RegisterTypes.RegisterTypesId,
|
||
RegisterTypes.RegisterTypesName,
|
||
Registration.DIC_ID,
|
||
Registration.CCManIds,
|
||
CCManNames = STUFF(( SELECT ',' + UserName FROM Sys_User
|
||
where PATINDEX('%,' + RTRIM(Sys_User.UserId) + ',%',',' + Registration.CCManIds + ',')>0
|
||
ORDER BY PATINDEX('%,' + RTRIM(Registration.CCManIds) + ',%',',' + Registration.CCManIds + ',')
|
||
FOR XML PATH('')), 1, 1,''),
|
||
Registration.Requirements
|
||
FROM dbo.HSSE_Hazard_HazardRegister AS Registration
|
||
LEFT JOIN dbo.Base_Project AS Project ON Project.ProjectId = Registration.ProjectId
|
||
LEFT JOIN dbo.Base_Unit AS ProjectUnit ON Project.UnitId = ProjectUnit.UnitId
|
||
LEFT JOIN dbo.WBS_UnitWork AS WorkArea ON WorkArea.UnitWorkId = Registration.Place
|
||
LEFT JOIN dbo.HSSE_Hazard_HazardRegisterTypes AS RegisterTypes ON RegisterTypes.RegisterTypesId = Registration.RegisterTypesId
|
||
LEFT JOIN dbo.Base_Unit AS Unit ON Unit.UnitId = Registration.ResponsibleUnit
|
||
LEFT JOIN dbo.Sys_User AS User1 ON User1.UserId = Registration.ResponsibleMan
|
||
LEFT JOIN dbo.Sys_User AS User2 ON User2.UserId = Registration.CheckManId
|
||
LEFT JOIN dbo.Sys_User AS User3 ON User3.UserId = Registration.ConfirmMan
|
||
LEFT JOIN dbo.Sys_User AS User4 ON User4.UserId = Registration.ResponsibleMan2
|
||
|
||
GO
|
||
|
||
|
||
|
||
|
||
delete from Sys_Menu where MenuId='9A3212F8-2392-4F21-A8C7-FF5EE3B191F1'
|
||
delete from Sys_ButtonToMenu where MenuId='762F0BF9-471B-4115-B35E-03A26C573877'
|
||
delete from Sys_Menu where MenuId='762F0BF9-471B-4115-B35E-03A26C573877'
|
||
delete from Sys_ButtonToMenu where MenuId='EDC50857-7762-4498-83C6-5BDE85036BAB'
|
||
delete from Sys_Menu where MenuId='EDC50857-7762-4498-83C6-5BDE85036BAB'
|
||
delete from Sys_ButtonToMenu where MenuId='74A6B343-5837-416B-AE9C-D2BBCA08E41F'
|
||
delete from Sys_Menu where MenuId='74A6B343-5837-416B-AE9C-D2BBCA08E41F'
|
||
delete from Sys_ButtonToMenu where MenuId='F6A6D53A-150E-43DB-A3C4-6FA18E9401E9'
|
||
delete from Sys_Menu where MenuId='F6A6D53A-150E-43DB-A3C4-6FA18E9401E9'
|
||
delete from Sys_ButtonToMenu where MenuId='D256E5C8-DC76-4F4D-BABE-A253418823F4'
|
||
delete from Sys_Menu where MenuId='D256E5C8-DC76-4F4D-BABE-A253418823F4'
|
||
delete from Sys_ButtonToMenu where MenuId='94C36333-C22A-499F-B9DB-53EEF77922AE'
|
||
delete from Sys_Menu where MenuId='94C36333-C22A-499F-B9DB-53EEF77922AE'
|
||
delete from Sys_ButtonToMenu where MenuId='E22F555A-D41C-4F5F-9734-39B578957732'
|
||
delete from Sys_Menu where MenuId='E22F555A-D41C-4F5F-9734-39B578957732'
|
||
GO
|
||
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('9A3212F8-2392-4F21-A8C7-FF5EE3B191F1' ,'风险分级动态管控',null,'',50,'467A0CB9-737D-4451-965E-869EBC3A4BD6', 'Menu_HSSE',0,0,1)
|
||
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('762F0BF9-471B-4115-B35E-03A26C573877' ,'环境因素识别与评价',null,'HSSE/Hazard/EnvironmentalRiskList.aspx',10,'9A3212F8-2392-4F21-A8C7-FF5EE3B191F1', 'Menu_HSSE',0,1,1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('25E47331-0E20-47B0-AAC3-926C0444D9C9', '762F0BF9-471B-4115-B35E-03A26C573877' ,'增加' ,1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('25705A8C-A734-4D56-8C30-4D08578B37F3', '762F0BF9-471B-4115-B35E-03A26C573877' ,'修改' ,2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8485EACC-BEE1-4BED-95CE-A10AA53372D1', '762F0BF9-471B-4115-B35E-03A26C573877' ,'删除' ,3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4DEF4A6D-77BD-4192-896D-6AB88BFA8F91', '762F0BF9-471B-4115-B35E-03A26C573877' ,'保存' ,4)
|
||
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('EDC50857-7762-4498-83C6-5BDE85036BAB' ,'风险评价',null,'HSSE/Hazard/HazardList.aspx',20,'9A3212F8-2392-4F21-A8C7-FF5EE3B191F1', 'Menu_HSSE',0,1,1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('C90FA764-F303-43F6-AC24-2F9E9351C637', 'EDC50857-7762-4498-83C6-5BDE85036BAB' ,'增加' ,1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('16D438F4-72C7-4765-84DE-4C34867F7760', 'EDC50857-7762-4498-83C6-5BDE85036BAB' ,'修改' ,2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('51ED8EA2-133F-4277-90C5-6C1F6EB50F8B', 'EDC50857-7762-4498-83C6-5BDE85036BAB' ,'删除' ,3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0BF51430-3A6D-483B-9516-89711266E2F5', 'EDC50857-7762-4498-83C6-5BDE85036BAB' ,'保存' ,4)
|
||
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('74A6B343-5837-416B-AE9C-D2BBCA08E41F' ,'风险信息库',null,'HSSE/Hazard/HazardInfo.aspx',25,'9A3212F8-2392-4F21-A8C7-FF5EE3B191F1', 'Menu_HSSE',0,1,1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('D4A583C2-5505-4FBD-BE1C-1A168FA0F352', '74A6B343-5837-416B-AE9C-D2BBCA08E41F' ,'保存' ,1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('693767D0-37E7-4FA1-8C21-C02C543AF811', '74A6B343-5837-416B-AE9C-D2BBCA08E41F' ,'审核' ,2)
|
||
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('F6A6D53A-150E-43DB-A3C4-6FA18E9401E9' ,'风险分级管控',null,'HSSE/Hazard/RiskControl.aspx',30,'9A3212F8-2392-4F21-A8C7-FF5EE3B191F1', 'Menu_HSSE',0,1,1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('7608EEE7-4102-449C-8F61-272E3952C8A8', 'F6A6D53A-150E-43DB-A3C4-6FA18E9401E9' ,'保存' ,1)
|
||
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('D256E5C8-DC76-4F4D-BABE-A253418823F4' ,'风险巡检记录',null,'HSSE/Hazard/RoutingInspection.aspx',32,'9A3212F8-2392-4F21-A8C7-FF5EE3B191F1', 'Menu_HSSE',0,1,1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('1D00171C-17EB-46EB-8892-86FCC495CF9B', 'D256E5C8-DC76-4F4D-BABE-A253418823F4' ,'删除' ,1)
|
||
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('94C36333-C22A-499F-B9DB-53EEF77922AE' ,'项目现场重大HSE因素控制措施一览表',null,'HSSE/Hazard/MajorHazardList.aspx',40,'9A3212F8-2392-4F21-A8C7-FF5EE3B191F1', 'Menu_HSSE',0,1,1)
|
||
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('E22F555A-D41C-4F5F-9734-39B578957732' ,'其他危险源辨识文件',null,'HSSE/Hazard/OtherHazard.aspx',50,'9A3212F8-2392-4F21-A8C7-FF5EE3B191F1', 'Menu_HSSE',0,1,1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('EACFD7D1-93F9-4BD3-AB9B-E4BD4FA0147C', 'E22F555A-D41C-4F5F-9734-39B578957732' ,'增加' ,1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('296031BC-B143-48F3-B903-B7697ED6B704', 'E22F555A-D41C-4F5F-9734-39B578957732' ,'修改' ,2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B21B1B8A-E2F5-4A68-AC0A-9666B051BBE2', 'E22F555A-D41C-4F5F-9734-39B578957732' ,'删除' ,3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AB49F853-52D5-4CFC-9CE0-BC3504C7D90A', 'E22F555A-D41C-4F5F-9734-39B578957732' ,'保存' ,4)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A83A0227-09D1-4D93-940C-E9BC6066EE6C', 'E22F555A-D41C-4F5F-9734-39B578957732' ,'提交' ,5)
|
||
GO
|
||
|
||
|
||
|
||
drop table [dbo].[Hazard_HazardSelectedItem]
|
||
GO
|
||
|
||
|
||
CREATE TABLE [dbo].[Hazard_HazardSelectedItem](
|
||
[HazardSelectedItemId] [nvarchar](50) NOT NULL,
|
||
[HazardId] [nvarchar](50) NOT NULL,
|
||
[HazardListTypeId] [nvarchar](50) NULL,
|
||
[HazardListId] [nvarchar](50) NOT NULL,
|
||
[HazardItems] [nvarchar](100) NULL,
|
||
[DefectsType] [nvarchar](50) NULL,
|
||
[MayLeadAccidents] [nvarchar](100) NULL,
|
||
[HelperMethod] [nvarchar](50) NULL,
|
||
[HazardJudge_L] [numeric](6, 1) NULL,
|
||
[HazardJudge_E] [numeric](6, 1) NULL,
|
||
[HazardJudge_C] [numeric](6, 1) NULL,
|
||
[HazardJudge_D] [numeric](6, 1) NULL,
|
||
[HazardLevel] [nvarchar](50) NULL,
|
||
[ControlMeasures] [nvarchar](200) NULL,
|
||
[IsResponse] [bit] NULL,
|
||
[ResponseRecode] [nvarchar](100) NULL,
|
||
[PromptTime] [int] NULL,
|
||
[Remark] [nvarchar](100) NULL,
|
||
[WorkStage] [nvarchar](2000) NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[DutyPerson] [nvarchar](50) NULL,
|
||
[CheckStartDate] [datetime] NULL,
|
||
[IsStart] [bit] NULL,
|
||
[State] [char](1) NULL,
|
||
[PlanExistDate] [datetime] NULL,
|
||
[QRCodeAttachUrl] [nvarchar](200) NULL,
|
||
CONSTRAINT [PK_Hazard_HazardSelectedItem_1] PRIMARY KEY CLUSTERED
|
||
(
|
||
[HazardSelectedItemId] 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
|
||
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'危险源代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'HazardId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'危险源类别编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'HazardListTypeId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属清单' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'HazardListId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'危险因素明细' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'HazardItems'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'缺陷类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'DefectsType'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'可能导致的事故' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'MayLeadAccidents'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'辅助方法(分为:I,Ⅱ,Ⅲ,Ⅳ,Ⅴ)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'HelperMethod'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业条件危险性评价(L)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'HazardJudge_L'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业条件危险性评价(E)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'HazardJudge_E'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业条件危险性评价(C)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'HazardJudge_C'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'作业条件危险性评价(D)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'HazardJudge_D'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'危险级别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'HazardLevel'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'控制措施' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'ControlMeasures'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否响应' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'IsResponse'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'响应记录' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'ResponseRecode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提示时间（1-1周，2-2周，以此类推）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'PromptTime'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem', @level2type=N'COLUMN',@level2name=N'Remark'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'危害辩识与危险评价结果表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_HazardSelectedItem'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[Hazard_PatrolPlan](
|
||
[PatrolPlanId] [nvarchar](50) NOT NULL,
|
||
[HazardSelectedItemId] [nvarchar](50) NULL,
|
||
[HazardLevel] [nvarchar](50) NULL,
|
||
[DutyPerson] [nvarchar](50) NULL,
|
||
[Days] [int] NULL,
|
||
[CheckStartDate] [datetime] NULL,
|
||
[LimitCheckDate] [datetime] NULL,
|
||
[CheckDate] [datetime] NULL,
|
||
[State] [char](1) NULL,
|
||
CONSTRAINT [PK_Hazard_PatrolPlan] PRIMARY KEY CLUSTERED
|
||
(
|
||
[PatrolPlanId] 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
|
||
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[Hazard_PatrolPlan] WITH CHECK ADD CONSTRAINT [FK_Hazard_PatrolPlan_Hazard_HazardSelectedItem] FOREIGN KEY([HazardSelectedItemId])
|
||
REFERENCES [dbo].[Hazard_HazardSelectedItem] ([HazardSelectedItemId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[Hazard_PatrolPlan] CHECK CONSTRAINT [FK_Hazard_PatrolPlan_Hazard_HazardSelectedItem]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'巡检计划表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_PatrolPlan'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[Hazard_RiskEvaluationRecord](
|
||
[LECItemRecordId] [nvarchar](50) NOT NULL,
|
||
[DataId] [nvarchar](50) NULL,
|
||
[DataType] [nvarchar](50) NULL,
|
||
[Evaluatorld] [nvarchar](50) NULL,
|
||
[EvaluatorDate] [date] NULL,
|
||
[L] [numeric](6, 1) NULL,
|
||
[E] [numeric](6, 1) NULL,
|
||
[C] [numeric](6, 1) NULL,
|
||
[D] [numeric](6, 1) NULL,
|
||
[RiskLevel] [nvarchar](50) NULL,
|
||
[ControlMeasures] [nvarchar](800) NULL,
|
||
[Remark] [nvarchar](500) NULL,
|
||
CONSTRAINT [PK_Hazard_RiskEvaluationRecord] PRIMARY KEY CLUSTERED
|
||
(
|
||
[LECItemRecordId] 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
|
||
|
||
|
||
CREATE TABLE [dbo].[Hazard_RoutingInspection](
|
||
[RoutingInspectionId] [nvarchar](50) NOT NULL,
|
||
[HazardSelectedItemId] [nvarchar](50) NULL,
|
||
[PatrolManId] [nvarchar](50) NULL,
|
||
[PatrolTime] [datetime] NULL,
|
||
[PatrolResult] [int] NULL,
|
||
[OldRiskLevel] [nvarchar](50) NULL,
|
||
[PohotoUrl] [nvarchar](200) NULL,
|
||
[ControlMeasures] [nvarchar](200) NULL,
|
||
[DealReason] [nvarchar](200) NULL,
|
||
[RiskManId] [nvarchar](50) NULL,
|
||
[PatrolPlanId] [nvarchar](50) NULL,
|
||
CONSTRAINT [PK_Hazard_RoutingInspection] PRIMARY KEY CLUSTERED
|
||
(
|
||
[RoutingInspectionId] 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
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'风险巡检记录表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hazard_RoutingInspection'
|
||
GO
|
||
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('E4B526CC-805E-4131-8E18-2FFA6871507E','风险等级','BaseInfo/RiskLevel.aspx',140,'8A2CEE72-2793-49C6-9E2E-E83B2676E2DD','Menu_SysSet',1,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('97A0EF27-78C7-4D6D-AE41-BCB28C3A0CA5','E4B526CC-805E-4131-8E18-2FFA6871507E','增加',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('2ACA14F6-93FD-458E-830F-BEBDC364829D','E4B526CC-805E-4131-8E18-2FFA6871507E','修改',2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('2C201030-1DC1-4D0D-B97A-C85BBFAF7C22','E4B526CC-805E-4131-8E18-2FFA6871507E','删除',3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('B36F59BD-1471-45EE-BF56-525673103B4B','E4B526CC-805E-4131-8E18-2FFA6871507E','保存',4)
|
||
GO
|
||
|
||
INSERT INTO dbo.Base_RiskLevel
|
||
VALUES('01537cc5-e8d2-497c-ba53-1faca1faf495',2,'二级/一般风险',121,170,'显著危险，重点控制',7,'')
|
||
GO
|
||
INSERT INTO dbo.Base_RiskLevel
|
||
VALUES('6baaf2bb-ee7c-410c-9a32-13208626c467',3,'三级/较大风险',170,320,'高度危险，需立即整改',3,'')
|
||
GO
|
||
INSERT INTO dbo.Base_RiskLevel
|
||
VALUES('84e1d680-5bfe-48d2-a255-59f43aa3615a',1,'一级/低风险',NULL,120,'一般危险，需要控制',21,'')
|
||
GO
|
||
INSERT INTO dbo.Base_RiskLevel
|
||
VALUES('c9e6285c-2da3-4997-8dc9-fb6ab404346e',4,'四级/重大风险',321,NULL,'极其危险，不能作业',1,'')
|
||
GO
|
||
|
||
update Comprehensive_InspectionPerson set IsTrain=1
|
||
GO
|
||
update Comprehensive_DesignDetails set JoinPersonNum=6
|
||
GO
|
||
update Comprehensive_InspectionMachine set IsCheckOK=1
|
||
GO
|
||
|
||
alter table [dbo].[Accident_AccidentReport] add AccidentDegree char(1) null
|
||
GO
|
||
|
||
alter table [dbo].[Hazard_HazardSelectedItem] add Position nvarchar(500) null
|
||
GO
|
||
|
||
INSERT INTO dbo.Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES('aa55fad1-6c51-43f5-8c99-3c6aaae79118','机具报验','CQMS/Comprehensive/InspectionMachine.aspx',30,'4a0e62cb-ee50-4a14-80b7-377602e9902c','Menu_CQMS',0,1,1)
|
||
GO
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('63b69c8f-93ac-494a-a02a-5417c99d067e','aa55fad1-6c51-43f5-8c99-3c6aaae79118','增加',1)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('1a8efd13-f072-4cc4-8dca-7229752c63ae','aa55fad1-6c51-43f5-8c99-3c6aaae79118','修改',2)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('de27884b-cccf-478d-8abd-045f19ef3e06','aa55fad1-6c51-43f5-8c99-3c6aaae79118','删除',3)
|
||
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
||
VALUES('148c8ae4-b43e-4883-9222-a896fed0e52e','aa55fad1-6c51-43f5-8c99-3c6aaae79118','保存',4)
|
||
GO |