| | |
| | | age_unit, |
| | | career, |
| | | dw_phone, |
| | | pym,dict_comp_id,comp_name,his_jzkh |
| | | pym,dict_comp_id,comp_name,his_jzkh,gl,wen_hua |
| | | from tj_customer |
| | | </sql> |
| | | |
| | |
| | | <if test="cusBrithday != null ">and cus_brithday = #{cusBrithday}</if> |
| | | <if test="cusAddr != null and cusAddr != ''">and cus_addr = #{cusAddr}</if> |
| | | <if test="addr != null and addr != ''">and addr = #{addr}</if> |
| | | <if test="cusPhone != null and cusPhone != ''">and cus_phone = #{cusPhone}</if> |
| | | <if test="cusPhone != null and cusPhone != ''">and cus_phone like concat('%',#{cusPhone}, '%') </if> |
| | | <if test="cusPostcode != null and cusPostcode != ''">and cus_postCode = #{cusPostcode}</if> |
| | | <if test="cusEmail != null and cusEmail != ''">and cus_email = #{cusEmail}</if> |
| | | <if test="indexCard != null and indexCard != ''">and index_card = #{indexCard}</if> |
| | | <if test="cusNational != null and cusNational != ''">and cus_national = #{cusNational}</if> |
| | | <if test="cusMarryStatus != null and cusMarryStatus != ''">and cus_marry_status = #{cusMarryStatus}</if> |
| | | <if test="cusIdcard != null and cusIdcard != ''">and cus_idcard = #{cusIdcard}</if> |
| | | <if test="cusIdcard != null and cusIdcard != ''">and cus_idcard like concat('%',#{cusIdcard}, '%') </if> |
| | | <if test="cusIntroduce != null and cusIntroduce != ''">and cus_introduce = #{cusIntroduce}</if> |
| | | <if test="cusNumber != null ">and cus_number = #{cusNumber}</if> |
| | | <if test="cusIsvip != null and cusIsvip != ''">and cus_isvip = #{cusIsvip}</if> |