ZBlog学习笔记

工号：

doFieldSQL(" select a.workcode,a.id from HrmResource a where a.id = '$6637$' ")

部门：

doFieldSQL(" select b.departmentname,b.id from HrmResource a left join HrmDepartment bon a.departmentid=b.id where a.id='$6637$' ")

上级部门：

doFieldSQL(" select b.departmentname,b.id from HrmResource a left join HrmDepartment b

on a.supdepid=b.id where a.id='$6637$' ")

岗位：

1、doFieldSQL(" select b.jobtitlename,b.id from HrmResource a left join HrmJobTitles b

on a.jobtitle=b.id where a.id='$6637$' ")

2、select jobtitlename from HrmJobTitles where id in(select jobtitle from HrmResource where id='XXX')

性别

doFieldSQL(" select b.sexname,b.id from HrmResource a left join hrmsex b on a.sex=b.id where a.id='$6637$' ")