| | |
| | | </otherwise> |
| | | </choose> |
| | | <if test="cas != null and cas != ''"> |
| | | and sr.cas = #{cas} |
| | | and sr.cas like concat("%",#{cas},"%") |
| | | </if> |
| | | <if test="supplierId != null and supplierId != ''"> |
| | | and sr.supplier_id = #{supplierId} |
| | |
| | | and sr.name like concat("%", #{name} ,"%") |
| | | </if> |
| | | <if test="productSn != null and productSn != ''"> |
| | | and sr.product_sn = #{productSn} |
| | | and sr.product_sn like concat("%",#{productSn},"%") |
| | | </if> |
| | | <choose> |
| | | <when test="favorFlag != ''"> |
| | |
| | | </otherwise> |
| | | </choose> |
| | | <if test="cas != null and cas != ''"> |
| | | and sr.cas = #{cas} |
| | | and sr.cas like concat("%",#{cas},"%") |
| | | </if> |
| | | <if test="supplierId != null and supplierId != ''"> |
| | | and sr.supplier_id = #{supplierId} |
| | |
| | | and sr.name like concat("%", #{name} ,"%") |
| | | </if> |
| | | <if test="productSn != null and productSn != ''"> |
| | | and sr.product_sn = #{productSn} |
| | | and sr.product_sn like concat("%",#{productSn},"%") |
| | | </if> |
| | | </select> |
| | | |