select a.PK_ID ,
( case when a.iSex = '1'
then '<img src="../../../images/qman.gif" border="0" align="absbottom" style=" border-radius: 14px;"/>'
else '<img src="../../../images/qwoman.gif" border="0" align="absbottom" style=" border-radius: 14px;"/>'
end ) + a.sName as Sex ,
a.sLoginName ,
a.sEmp_ID ,
UserHoldPost = dbo.GetUserOrgDeptPost(a.PK_ID) ,
( case a.iSuspend
when 0 then '在职'
when 1 then '离职'
else '退休'
end
( case when a.iSex = '1'
then '<img src="../../../images/qman.gif" border="0" align="absbottom" style=" border-radius: 14px;"/>'
else '<img src="../../../images/qwoman.gif" border="0" align="absbottom" style=" border-radius: 14px;"/>'
end ) + a.sName as Sex ,
a.sLoginName ,
a.sEmp_ID ,
UserHoldPost = dbo.GetUserOrgDeptPost(a.PK_ID) ,
( case a.iSuspend
when 0 then '在职'
when 1 then '离职'
else '退休'
end