zhanghj
/
ChengDa_English
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
ChengDa_English/DataBase/版本日志/SGGLDB_CD_V2023-06-17-001.sql

423 lines
22 KiB
MySQL
Raw Permalink Normal View History

提交集团数据穿透修改
2023-06-19 09:04:34 +08:00
update InApproveManager_EquipmentInItem set IsUsed=1
update InApproveManager_GeneralEquipmentInItem set IsUsed=1
GO
ALTER VIEW [dbo].[View_License_LicenseManager]
AS
/*<EFBFBD>ֳ<EFBFBD><EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>֤*/
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 '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>'
when '2' then '<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>'
when '3' then '<EFBFBD>ѹر<EFBFBD>'
when '-1' then '<EFBFBD><EFBFBD>ȡ<EFBFBD><EFBFBD>'
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='һ<EFBFBD><EFBFBD>'
GO
/**********<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ѳ<EFBFBD>죨<EFBFBD>ֻ<EFBFBD><EFBFBD>ˣ<EFBFBD><EFBFBD><EFBFBD>ͼ*************/
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 '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>'
WHEN Registration.states='1' and Registration.SafeSupervisionIsOK=1 THEN '<EFBFBD>ϸ<EFBFBD>'
WHEN Registration.states='2' THEN '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>-<2D><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>'
WHEN Registration.states='3' THEN '<EFBFBD>ѱջ<EFBFBD>'
ELSE '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' 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' ,'<EFBFBD><EFBFBD><EFBFBD>շּ<EFBFBD><EFBFBD><EFBFBD>̬<EFBFBD>ܿ<EFBFBD>',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' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʶ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>',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' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' ,1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('25705A8C-A734-4D56-8C30-4D08578B37F3', '762F0BF9-471B-4115-B35E-03A26C573877' ,'<EFBFBD>޸<EFBFBD>' ,2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('8485EACC-BEE1-4BED-95CE-A10AA53372D1', '762F0BF9-471B-4115-B35E-03A26C573877' ,'ɾ<EFBFBD><EFBFBD>' ,3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('4DEF4A6D-77BD-4192-896D-6AB88BFA8F91', '762F0BF9-471B-4115-B35E-03A26C573877' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' ,4)
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('EDC50857-7762-4498-83C6-5BDE85036BAB' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>',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' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' ,1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('16D438F4-72C7-4765-84DE-4C34867F7760', 'EDC50857-7762-4498-83C6-5BDE85036BAB' ,'<EFBFBD>޸<EFBFBD>' ,2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('51ED8EA2-133F-4277-90C5-6C1F6EB50F8B', 'EDC50857-7762-4498-83C6-5BDE85036BAB' ,'ɾ<EFBFBD><EFBFBD>' ,3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('0BF51430-3A6D-483B-9516-89711266E2F5', 'EDC50857-7762-4498-83C6-5BDE85036BAB' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' ,4)
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('74A6B343-5837-416B-AE9C-D2BBCA08E41F' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ϣ<EFBFBD><EFBFBD>',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' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' ,1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('693767D0-37E7-4FA1-8C21-C02C543AF811', '74A6B343-5837-416B-AE9C-D2BBCA08E41F' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' ,2)
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('F6A6D53A-150E-43DB-A3C4-6FA18E9401E9' ,'<EFBFBD><EFBFBD><EFBFBD>շּ<EFBFBD><EFBFBD>ܿ<EFBFBD>',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' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' ,1)
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('D256E5C8-DC76-4F4D-BABE-A253418823F4' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ѳ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼',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' ,'ɾ<EFBFBD><EFBFBD>' ,1)
INSERT INTO dbo.Sys_Menu (MenuId,MenuName,Icon,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
VALUES('94C36333-C22A-499F-B9DB-53EEF77922AE' ,'<EFBFBD><EFBFBD>Ŀ<EFBFBD>ֳ<EFBFBD><EFBFBD>ش<EFBFBD>HSE<EFBFBD><EFBFBD><EFBFBD>ؿ<EFBFBD><EFBFBD>ƴ<EFBFBD>ʩһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',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' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD>Դ<EFBFBD><EFBFBD>ʶ<EFBFBD>ļ<EFBFBD>',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' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' ,1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('296031BC-B143-48F3-B903-B7697ED6B704', 'E22F555A-D41C-4F5F-9734-39B578957732' ,'<EFBFBD>޸<EFBFBD>' ,2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('B21B1B8A-E2F5-4A68-AC0A-9666B051BBE2', 'E22F555A-D41C-4F5F-9734-39B578957732' ,'ɾ<EFBFBD><EFBFBD>' ,3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('AB49F853-52D5-4CFC-9CE0-BC3504C7D90A', 'E22F555A-D41C-4F5F-9734-39B578957732' ,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' ,4)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES('A83A0227-09D1-4D93-940C-E9BC6066EE6C', 'E22F555A-D41C-4F5F-9734-39B578957732' ,'<EFBFBD>ύ' ,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'Σ<EFBFBD><EFBFBD>Դ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'Σ<EFBFBD><EFBFBD>Դ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>嵥' , @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'Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϸ' , @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'ȱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD>ܵ<EFBFBD><EFBFBD>µ<EFBFBD><EFBFBD>¹<EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>(<28><>Ϊ:I,<2C><>,<2C><>,<2C><>,<2C><>)' , @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'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>(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'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>(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'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>(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'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>(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'Σ<EFBFBD>ռ<EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD>ƴ<EFBFBD>ʩ' , @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'<EFBFBD>Ƿ<EFBFBD><EFBFBD><EFBFBD>Ӧ' , @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'<EFBFBD><EFBFBD>Ӧ<EFBFBD><EFBFBD>¼' , @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'<EFBFBD><EFBFBD>ʾʱ<EFBFBD>䣨1-1<>ܣ<EFBFBD>2-2<>ܣ<EFBFBD><DCA3>Դ<EFBFBD><D4B4><EFBFBD><EFBFBD>ƣ<EFBFBD>' , @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'<EFBFBD><EFBFBD>ע' , @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'Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʶ<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>۽<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @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'Ѳ<EFBFBD><EFBFBD><EFBFBD>ƻ<EFBFBD><EFBFBD><EFBFBD>' , @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'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ѳ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼<EFBFBD><EFBFBD>' , @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','<EFBFBD><EFBFBD><EFBFBD>յȼ<EFBFBD>','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','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2ACA14F6-93FD-458E-830F-BEBDC364829D','E4B526CC-805E-4131-8E18-2FFA6871507E','<EFBFBD>޸<EFBFBD>',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('2C201030-1DC1-4D0D-B97A-C85BBFAF7C22','E4B526CC-805E-4131-8E18-2FFA6871507E','ɾ<EFBFBD><EFBFBD>',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('B36F59BD-1471-45EE-BF56-525673103B4B','E4B526CC-805E-4131-8E18-2FFA6871507E','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
GO
INSERT INTO dbo.Base_RiskLevel
VALUES('01537cc5-e8d2-497c-ba53-1faca1faf495',2,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>/һ<><D2BB><EFBFBD><EFBFBD><EFBFBD><EFBFBD>',121,170,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Σ<EFBFBD>գ<EFBFBD><EFBFBD>ص<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>',7,'')
GO
INSERT INTO dbo.Base_RiskLevel
VALUES('6baaf2bb-ee7c-410c-9a32-13208626c467',3,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>/<2F>ϴ<EFBFBD><CFB4><EFBFBD><EFBFBD><EFBFBD>',170,320,'<EFBFBD>߶<EFBFBD>Σ<EFBFBD>գ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>',3,'')
GO
INSERT INTO dbo.Base_RiskLevel
VALUES('84e1d680-5bfe-48d2-a255-59f43aa3615a',1,'һ<EFBFBD><EFBFBD>/<2F>ͷ<EFBFBD><CDB7><EFBFBD>',NULL,120,'һ<EFBFBD><EFBFBD>Σ<EFBFBD>գ<EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',21,'')
GO
INSERT INTO dbo.Base_RiskLevel
VALUES('c9e6285c-2da3-4997-8dc9-fb6ab404346e',4,'<EFBFBD>ļ<EFBFBD>/<2F>ش<EFBFBD><D8B4><EFBFBD><EFBFBD><EFBFBD>',321,NULL,'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Σ<EFBFBD>գ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ',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','<EFBFBD><EFBFBD><EFBFBD>߱<EFBFBD><EFBFBD><EFBFBD>','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','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('1a8efd13-f072-4cc4-8dca-7229752c63ae','aa55fad1-6c51-43f5-8c99-3c6aaae79118','<EFBFBD>޸<EFBFBD>',2)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('de27884b-cccf-478d-8abd-045f19ef3e06','aa55fad1-6c51-43f5-8c99-3c6aaae79118','ɾ<EFBFBD><EFBFBD>',3)
INSERT INTO dbo.Sys_ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
VALUES('148c8ae4-b43e-4883-9222-a896fed0e52e','aa55fad1-6c51-43f5-8c99-3c6aaae79118','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
GO