| | |
| | | public DataTableEntity Addresslist(FieldSetEntity fs) { |
| | | StringBuffer str = new StringBuffer(); |
| | | str.append(" select lu.thumbnail_img thumbnail_img,ls.show_name show_name,lp.job_post_name job_post_name, "); |
| | | str.append(" ls.staff_email staff_email,lu.office_phone office_phone,lu.user_mobile_number user_mobile_number, "); |
| | | str.append(" ls.staff_email staff_email,lu.office_phone office_phone,lu.user_mobile_number user_mobile_number,lu.user_account, "); |
| | | str.append(" d.org_level_all org_level_all,lu.user_id user_id, "); |
| | | str.append(" c.org_level_name org_level_uuid, "); |
| | | str.append(" d.org_level_name dept_uuid,lu.gender gender, "); |
| | |
| | | str.append(" and lu.gender=? "); |
| | | params.add(fs.getString("gender")); |
| | | } |
| | | if(!StringUtils.isEmpty(fs.getString("user_id"))){ |
| | | str.append(" and lu.user_id=? "); |
| | | params.add(fs.getString("user_id")); |
| | | } |
| | | str.append("order by c.sequence,d.sequence,lp.sequence,pg.sequence"); |
| | | DataTableEntity dt = baseDao.listTable(str.toString(),params.toArray()); |
| | | baseDao.loadPromptData(dt); |
| | |
| | | DataTableEntity dt = null; |
| | | StringBuffer str = new StringBuffer(); |
| | | str.append(" select lu.thumbnail_img thumbnail_img,ls.show_name show_name,lp.job_post_name job_post_name, "); |
| | | str.append(" ls.staff_email staff_email,lu.office_phone office_phone,lu.user_mobile_number user_mobile_number, "); |
| | | str.append(" ls.staff_email staff_email,lu.office_phone office_phone,lu.user_mobile_number user_mobile_number,lu.user_account, "); |
| | | str.append(" (select org_level_all FROM product_sys_org_levels where uuid=ls.dept_uuid) org_level_all, "); |
| | | str.append(" (select org_level_name FROM product_sys_org_levels where uuid=ls.org_level_uuid) org_level_uuid,lu.user_id user_id, "); |
| | | str.append(" (select org_level_name FROM product_sys_org_levels where uuid=ls.dept_uuid) dept_uuid,lu.gender gender, "); |