instr:
<select id="selectedPresonid" parameterType="java.lang.String" resultType="gds.common.employee.dto.EmployeeDTO">
SELECT DEPID,DEPNAME,EMPLOYEEID,EMPLOYEENAME FROM
FW_EMPLOYEE,FW_DEPARTMENT
WHERE FW_EMPLOYEE.WORKDEPID=FW_DEPARTMENT.DEPID
AND INSTR(#{viewPersonID},EMPLOYEEID)>0
resultType="gds.common.employee.dto.EmployeeDTO">
SELECT DEPID,DEPNAME,EMPLOYEEID,EMPLOYEENAME FROM FW_EMPLOYEE
A,FW_DEPARTMENT B
WHERE A.WORKDEPID=B.DEPID
AND B.DEPID=#{depID}
<if test="workDepID!=null and ''!=workDepID">
AND NOT INSTR(#{workDepID},EMPLOYEEID)>0
</if>
</select>
<select id="selectedPresonid" parameterType="java.lang.String" resultType="gds.common.employee.dto.EmployeeDTO">
SELECT DEPID,DEPNAME,EMPLOYEEID,EMPLOYEENAME FROM
FW_EMPLOYEE,FW_DEPARTMENT
WHERE FW_EMPLOYEE.WORKDEPID=FW_DEPARTMENT.DEPID
AND INSTR(#{viewPersonID},EMPLOYEEID)>0
</select>
not instr:
<select id="selectedAllDepid" parameterType="gds.common.employee.dto.EmployeeDTO"resultType="gds.common.employee.dto.EmployeeDTO">
SELECT DEPID,DEPNAME,EMPLOYEEID,EMPLOYEENAME FROM FW_EMPLOYEE
A,FW_DEPARTMENT B
WHERE A.WORKDEPID=B.DEPID
AND B.DEPID=#{depID}
<if test="workDepID!=null and ''!=workDepID">
AND NOT INSTR(#{workDepID},EMPLOYEEID)>0
</if>
</select>