日期:2014-05-16 浏览次数:20445 次
select a.FAPTime as RTime,a.FAPJobTitle as RTitle,b.RealName as RUser,b.DeptName as RDept,'已处理出国旅游探亲' as RKind ,'../ForeignAffairs/ForeignAffairs_Private_Info.aspx?Type='+cast((case a.FAPState When 0 then 0 when 1 then 1 when 2 then 0 else 2 end) as varchar)+'&FAPID='+cast(a.FAPID as varchar(50))+'&PType=3' as RUrl from
ForeignAffairs_Private a left join UserDeptInfo b on a.UserID=b.UserID
where
1=1 and exists (select * from ForeignAffairs_Private_Process_User_Recorder c where c.SheetID = a.FAPID and c.SPURUserid = 1)
select a.FAPTime as RTime,a.FAPJobTitle as RTitle,c.RealName as RUser,c.DeptName as RDept,'已处理出国旅游探亲' as RKind ,
'../ForeignAffairs/ForeignAffairs_Private_Info.aspx?Type='+cast((case a.FAPState When 0 then 0 when 1 then 1 when 2 then 0 else 2 end) as varchar)+'&FAPID='+cast(a.FAPID as varchar(50))+'&PType=3' as RUrl from ForeignAffairs_Private a left join ForeignAffairs_Private_Process_User_Recorder b on a.FAPID = b.SheetID left join UserDeptInfo c on c.UserID = a.UserID
where b.SPURUserid = 1