98 lines
5.1 KiB
Transact-SQL
98 lines
5.1 KiB
Transact-SQL
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CREATE PROCEDURE [dbo].[Sp_APP_GetHSSEToDoItems]
|
|
@projectId NVARCHAR(50) = NULL,
|
|
@userId NVARCHAR(200)=NULL
|
|
AS
|
|
/*获取当前人待办事项*/
|
|
BEGIN
|
|
|
|
select a.DataId, '职业健康安全危险源辨识与评价' as MenuName, '编号： '+b.HazardListCode+' 单位工程：'+b.WorkAreaName+' 待处理' 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, '法律法规辨识' as MenuName, '编号： '+a.LawRegulationIdentifyCode+' 版本号：'+a.VersionNumber+' 待处理' 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, '标准规范清单' as MenuName, '编号： '+a.ConstructionStandardIdentifyCode+' 版本号：'+a.VersionNumber+' 待处理' 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实施计划' as MenuName, '编号： '+a.ActionPlanListCode+' 名称：'+a.ActionPlanListName+' 待处理' 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, '环境因素识别与评价' as MenuName, '编号： '+CodeRecords.Code+' 单位工程：'+a.WorkAreaName+' 待处理' 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, '其他危险源辨识文件' as MenuName, '编号： '+CodeRecords.Code+' 文件名称：'+a.OtherHazardName+' 待处理' 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, '培训记录' as MenuName, '编号： '+a.TrainingCode+' 标题：'+a.TrainTitle+' 待处理' 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, '人员信息档案' as MenuName, '姓名： '+a.PersonName+' 身份证：'+a.IdentityCard+' 待处理' 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
|
|
|
|
|