| | |
| | | ",registeredcapital = " + "'" + information.getRegisteredcapital() + "'" + |
| | | ",organizationcode = " + "'" + information.getOrganizationcode() + "'" + |
| | | ",registrationnumber = " + "'" + information.getRegistrationnumber() + "'" + |
| | | ",jurisdiction = " + "'" + information.getJurisdiction() + "'" + |
| | | ",enterprises = " + "'" + information.getEnterprises() + "'" + |
| | | ",address = " + "'" + information.getAddress() + "'" + |
| | | ",business = " + "'" + information.getBusiness() + "'" + |
| | |
| | | <if test="user.examinationType!=null and user.examinationType != ''"> |
| | | and examination_type = #{user.examinationType} |
| | | </if> |
| | | <if test="deptIdList!=null and deptIdList.size>0"> |
| | | and id in ( |
| | | SELECT |
| | | user_id |
| | | FROM |
| | | blade_user_dept |
| | | WHERE |
| | | dept_id IN |
| | | <foreach collection="deptIdList" index="index" item="item" open="(" separator="," close=")"> |
| | | #{item} |
| | | </foreach> |
| | | ) |
| | | </if> |
| | | ORDER BY id |
| | | </select> |
| | | |