| | |
| | | " 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}" + |
| | |
| | | @Param("orderId")String orderId, |
| | | @Param("tjnum")String tjnum, |
| | | @Param("dockerId")String dockerId); |
| | | |
| | | @DataSource(value = DataSourceType.MASTER) |
| | | @Select("call tj_jc_update_detatil(#{cardId,mode=IN},#{orderId,mode=IN},#{tjnum,mode=IN},#{dockerId,mode=IN})") |
| | | public void updateDetailByTjJcCall(@Param("cardId") String cardId, |
| | | @Param("orderId")String orderId, |
| | | @Param("tjnum")String tjnum, |
| | | @Param("dockerId")String dockerId); |
| | | |
| | | |
| | | |
| | | |
| | | @DataSource(value = DataSourceType.SLAVE_HIS) |
| | | @Select("SELECT * FROM histjv_exam_jcbgd") |
| | |
| | | @Select({"<script> select *"+ |
| | | " from histjv_Ltkj_hyxm where 1=1 "+ |
| | | " <when test='pacCode!=null'>" + |
| | | " AND fcard_no = #{pacCode}" + |
| | | " AND pacCode like '%'+#{pacCode}+'%'" + |
| | | "</when>" + |
| | | " <when test='pacName!=null'>" + |
| | | " AND pat_name = #{pacName}" + |
| | | " AND pacName like '%'+#{pacName}+'%' " + |
| | | "</when>" + |
| | | " <when test='pacRemark!=null'>" + |
| | | " AND mobile = #{pacRemark}" + |
| | | " AND pacRemark = #{pacRemark}" + |
| | | "</when>" + |
| | | "</script>"}) |
| | | public List<Map<String,Object>> getTjHyBgList(@Param("pacCode")String pacCode, |