98 lines
5.1 KiB
MySQL
98 lines
5.1 KiB
MySQL
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
CREATE PROCEDURE [dbo].[Sp_APP_GetHSSEToDoItems]
|
|||
|
|
@projectId NVARCHAR(50) = NULL,
|
|||
|
|
@userId NVARCHAR(200)=NULL
|
|||
|
|
AS
|
|||
|
|
/*<EFBFBD><EFBFBD>ȡ<EFBFBD><EFBFBD>ǰ<EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>*/
|
|||
|
|
BEGIN
|
|||
|
|
|
|||
|
|
select a.DataId, 'ְҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȫΣ<EFBFBD><EFBFBD>Դ<EFBFBD><EFBFBD>ʶ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as MenuName, '<EFBFBD><EFBFBD><EFBFBD>ţ<EFBFBD> '+b.HazardListCode+' <20><>λ<EFBFBD><CEBB><EFBFBD>̣<EFBFBD>'+b.WorkAreaName+' <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as Content, b.CompileDate as DataTime,users.UserId
|
|||
|
|
,users.UserName, '../HSSE/Hazard/HazardListEdit.aspx?HazardListId='+b.HazardListId+'' as PCUrl
|
|||
|
|
,'/pagesQ/file_manage/detail?id='+b.HazardListId+'' as UrlStr
|
|||
|
|
from Hazard_HazardList b left join Sys_FlowOperate a on a.DataId = b.HazardListId
|
|||
|
|
left join Sys_User users on users.UserId = b.CompileMan
|
|||
|
|
where a.IsClosed = 0
|
|||
|
|
and b.ProjectId=@projectId
|
|||
|
|
and a.OperaterId=@userId
|
|||
|
|
union ALL
|
|||
|
|
select a.LawRegulationIdentifyId, '<EFBFBD><EFBFBD><EFBFBD>ɷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʶ' as MenuName, '<EFBFBD><EFBFBD><EFBFBD>ţ<EFBFBD> '+a.LawRegulationIdentifyCode+' <20>汾<EFBFBD>ţ<EFBFBD>'+a.VersionNumber+' <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as Content, a.UpdateDate as DataTime,users.UserId
|
|||
|
|
,users.UserName, '../HSSE/InformationProject/LawRegulationIdentifyEdit.aspx?LawRegulationIdentifyId='+a.LawRegulationIdentifyId+'' as PCUrl
|
|||
|
|
,'/pagesQ/file_manage/detail?id='+a.LawRegulationIdentifyId+'' as UrlStr
|
|||
|
|
from Law_LawRegulationIdentify a left join Sys_FlowOperate b on a.LawRegulationIdentifyId = b.DataId
|
|||
|
|
left join Sys_User users on users.UserId = a.IdentifyPerson
|
|||
|
|
where b.IsClosed = 0 and a.ProjectId=@projectId
|
|||
|
|
and b.OperaterId=@userId
|
|||
|
|
union ALL
|
|||
|
|
|
|||
|
|
select a.ConstructionStandardIdentifyId, '<EFBFBD><EFBFBD><EFBFBD>淶<EFBFBD>嵥' as MenuName, '<EFBFBD><EFBFBD><EFBFBD>ţ<EFBFBD> '+a.ConstructionStandardIdentifyCode+' <20>汾<EFBFBD>ţ<EFBFBD>'+a.VersionNumber+' <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as Content, a.UpdateDate as DataTime,users.UserId
|
|||
|
|
,users.UserName, '../HSSE/InformationProject/ConstructionStandardIdentifyEdit.aspx?ConstructionStandardIdentifyId='+a.ConstructionStandardIdentifyId+'' as PCUrl
|
|||
|
|
,'/pagesQ/file_manage/detail?id='+a.ConstructionStandardIdentifyId+'' as UrlStr
|
|||
|
|
from InformationProject_ConstructionStandardIdentify a left join Sys_FlowOperate b on a.ConstructionStandardIdentifyId = b.DataId
|
|||
|
|
left join Sys_User users on users.UserId = a.IdentifyPerson
|
|||
|
|
where b.IsClosed = 0 and a.ProjectId=@projectId
|
|||
|
|
and b.OperaterId=@userId
|
|||
|
|
|
|||
|
|
|
|||
|
|
union ALL
|
|||
|
|
|
|||
|
|
select a.ActionPlanListId, 'HSEʵʩ<EFBFBD>ƻ<EFBFBD>' as MenuName, '<EFBFBD><EFBFBD><EFBFBD>ţ<EFBFBD> '+a.ActionPlanListCode+' <20><><EFBFBD>ƣ<EFBFBD>'+a.ActionPlanListName+' <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as Content, a.CompileDate as DataTime,users.UserId
|
|||
|
|
,users.UserName, '../HSSE/ActionPlan/ActionPlanListId.aspx?ActionPlanListId='+a.ActionPlanListId+'' as PCUrl
|
|||
|
|
,'/pagesQ/file_manage/detail?id='+a.ActionPlanListId+'' as UrlStr
|
|||
|
|
from ActionPlan_ActionPlanList a left join Sys_FlowOperate b on a.ActionPlanListId = b.DataId
|
|||
|
|
left join Sys_User users on users.UserId = a.CompileMan
|
|||
|
|
where b.IsClosed = 0 and a.ProjectId=@projectId
|
|||
|
|
and b.OperaterId=@userId
|
|||
|
|
|
|||
|
|
union ALL
|
|||
|
|
|
|||
|
|
select a.EnvironmentalRiskListId, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʶ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as MenuName, '<EFBFBD><EFBFBD><EFBFBD>ţ<EFBFBD> '+CodeRecords.Code+' <20><>λ<EFBFBD><CEBB><EFBFBD>̣<EFBFBD>'+a.WorkAreaName+' <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as Content, a.CompileDate as DataTime,users.UserId
|
|||
|
|
,users.UserName, '../HSSE/Hazard/EnvironmentalRiskListEdit.aspx?EnvironmentalRiskListId='+a.EnvironmentalRiskListId+'' as PCUrl
|
|||
|
|
,'/pagesQ/file_manage/detail?id='+a.EnvironmentalRiskListId+'' as UrlStr
|
|||
|
|
from Hazard_EnvironmentalRiskList a left join Sys_FlowOperate b on a.EnvironmentalRiskListId = b.DataId
|
|||
|
|
left join Sys_User users on users.UserId = a.CompileMan
|
|||
|
|
LEFT JOIN Sys_CodeRecords AS CodeRecords ON a.EnvironmentalRiskListId=CodeRecords.DataId
|
|||
|
|
where b.IsClosed = 0 and a.ProjectId=@projectId
|
|||
|
|
and b.OperaterId=@userId
|
|||
|
|
|
|||
|
|
|
|||
|
|
union ALL
|
|||
|
|
|
|||
|
|
select a.OtherHazardId, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD>Դ<EFBFBD><EFBFBD>ʶ<EFBFBD>ļ<EFBFBD>' as MenuName, '<EFBFBD><EFBFBD><EFBFBD>ţ<EFBFBD> '+CodeRecords.Code+' <20>ļ<EFBFBD><C4BC><EFBFBD><EFBFBD>ƣ<EFBFBD>'+a.OtherHazardName+' <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as Content, a.CompileDate as DataTime,users.UserId
|
|||
|
|
,users.UserName, '../HSSE/Hazard/OtherHazardEdit.aspx?OtherHazardId='+a.OtherHazardId+'' as PCUrl
|
|||
|
|
,'/pagesQ/file_manage/detail?id='+a.OtherHazardId+'' as UrlStr
|
|||
|
|
from Hazard_OtherHazard a left join Sys_FlowOperate b on a.OtherHazardId = b.DataId
|
|||
|
|
left join Sys_User users on users.UserId = a.CompileMan
|
|||
|
|
LEFT JOIN Sys_CodeRecords AS CodeRecords ON a.OtherHazardId=CodeRecords.DataId
|
|||
|
|
where b.IsClosed = 0 and a.ProjectId=@projectId
|
|||
|
|
and b.OperaterId=@userId
|
|||
|
|
union ALL
|
|||
|
|
select a.TrainingId, '<EFBFBD><EFBFBD>ѵ<EFBFBD><EFBFBD>¼' as MenuName, '<EFBFBD><EFBFBD><EFBFBD>ţ<EFBFBD> '+a.TrainingCode+' <20><><EFBFBD>⣺'+a.TrainTitle+' <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as Content, a.TrainStartDate as DataTime,users.UserId
|
|||
|
|
,users.UserName, '../HSSE/EduTrain/TrainRecordEdit.aspx?TrainingId='+a.TrainingId+'' as PCUrl
|
|||
|
|
,'/pagesQ/file_manage/detail?id='+a.TrainingId+'' as UrlStr
|
|||
|
|
from EduTrain_TrainRecord a left join Sys_FlowOperate b on a.TrainingId = b.DataId
|
|||
|
|
left join Sys_User users on users.UserId = a.CompileMan
|
|||
|
|
where b.IsClosed = 0 and a.ProjectId=@projectId
|
|||
|
|
and b.OperaterId=@userId
|
|||
|
|
union ALL
|
|||
|
|
select a.PersonId, '<EFBFBD><EFBFBD>Ա<EFBFBD><EFBFBD>Ϣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as MenuName, '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> '+a.PersonName+' <20><><EFBFBD><EFBFBD>֤<EFBFBD><D6A4>'+a.IdentityCard+' <20><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' as Content, a.InTime as DataTime,''
|
|||
|
|
,'', '../HSSE/SitePerson/PersonListEdit.aspx?PersonId='+a.PersonId+'' as PCUrl
|
|||
|
|
,'/pagesQ/file_manage/detail?id='+a.PersonId+'' as UrlStr
|
|||
|
|
from SitePerson_Person a left join Sys_FlowOperate b on a.PersonId = b.DataId
|
|||
|
|
|
|||
|
|
where b.IsClosed = 0 and a.ProjectId=@projectId
|
|||
|
|
and b.OperaterId=@userId
|
|||
|
|
END
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
|