| | |
| | | " pat_id price , mobile pacRemark" + |
| | | " from histjv_ltkjvtjpat where 1=1 "+ |
| | | " <when test='pacCode!=null'>" + |
| | | " AND fcard_no = #{pacCode}" + |
| | | " AND fcard_no like '%'+#{pacCode}+'%'" + |
| | | "</when>" + |
| | | " <when test='pacName!=null'>" + |
| | | " AND pat_name = #{pacName}" + |
| | | " AND pat_name like '%'+#{pacName}+'%' " + |
| | | "</when>" + |
| | | " <when test='pacRemark!=null'>" + |
| | | " AND mobile = #{pacRemark}" + |
| | |
| | | @Select({"<script> select *"+ |
| | | " from histjv_Ltkj_hyxm where 1=1 "+ |
| | | " <when test='pacCode!=null'>" + |
| | | " AND pacCode = #{pacCode}" + |
| | | " AND pacCode like '%'+#{pacCode}+'%'" + |
| | | "</when>" + |
| | | " <when test='pacName!=null'>" + |
| | | " AND pacName = #{pacName}" + |
| | | " AND pacName like '%'+#{pacName}+'%' " + |
| | | "</when>" + |
| | | " <when test='pacRemark!=null'>" + |
| | | " AND pacRemark = #{pacRemark}" + |