36 lines
1.8 KiB
Transact-SQL
36 lines
1.8 KiB
Transact-SQL
--安管人员增加特岗证书
|
|
alter table QualityAudit_SafePersonQuality
|
|
add CertificateId nvarchar(50) null;
|
|
|
|
update sys_menu set MenuName='施工机具和设备' where menuid='28C8EDB9-F1C2-4287-8013-28A976B093E2'
|
|
|
|
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('2556CFA6-63F7-4FC1-9B2B-5E43A84640EC','特种设备','',1,'28C8EDB9-F1C2-4287-8013-28A976B093E2','Menu_HSSE',0,0,1)
|
|
go
|
|
|
|
update sys_menu set menuname='入场验收记录',SuperMenu='2556CFA6-63F7-4FC1-9B2B-5E43A84640EC' ,SortIndex='20'
|
|
where menuid='9703D711-85DA-4A0B-B08B-70F791418696';
|
|
|
|
update sys_menu set menuname='资质报审及检验报告',SuperMenu='2556CFA6-63F7-4FC1-9B2B-5E43A84640EC' ,SortIndex='10'
|
|
where menuid='2DEDD752-8BAF-43CD-933D-932AF9AF2F58';
|
|
go
|
|
|
|
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('8E2FB782-66B3-46C4-8F71-8A5A37585785','普通机具设备','',2,'28C8EDB9-F1C2-4287-8013-28A976B093E2','Menu_HSSE',0,0,1)
|
|
go
|
|
|
|
update sys_menu set menuname='资质报审及检验记录',SuperMenu='8E2FB782-66B3-46C4-8F71-8A5A37585785',SortIndex='10'
|
|
where menuid='BFD62699-47F0-49FA-AD39-FAEE8A6C3313';
|
|
go
|
|
|
|
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
|
values('CE2687BF-7BBB-4FD5-8FFE-B3B26F712D34','入场验收记录','HSSE/License/EquipmentSafetyList.aspx',
|
|
20,'8E2FB782-66B3-46C4-8F71-8A5A37585785','Menu_HSSE',0,1,1)
|
|
go
|
|
|
|
|
|
update sys_menu set IsUsed=0 where menuid='3E167389-4775-4AC3-9D31-2E570682EDA1';
|
|
update sys_menu set IsUsed=0 where menuid='A4832598-E3D4-4906-88E5-A3886A85FC5A';
|
|
update sys_menu set IsUsed=0 where menuid='56F241A9-0AA3-4EDB-8C5C-999C487C06DA';
|
|
update sys_menu set IsUsed=0 where menuid='06EA1483-7397-46DD-818D-56911EA7B679';
|
|
update sys_menu set IsUsed=0 where menuid='42E7E869-67EA-446E-A910-BE7BF95EDC00'; |