方式一:直接拼接法(concat)
<if test="outsourcingNum !=null">
and sdoh.outsourcing_num like concat('%',#{outsourcingNum,jdbcType=INTEGER},'%')
</if>
方式2:利用bind绑定字段
<if test="poNum !=null">
<bind name="poNum" value="'%'+poNum+'%'"/>
AND sdopd.po_num LIKE #{poNum}
</if>