| | |
|---|
| | | public List<LtkjTjPat> getTjPat(); |
|---|
| | | |
|---|
| | | @DataSource(value = DataSourceType.SLAVE_PACS) |
|---|
| | | @Select({"<script> select fcard_iD xh,fcard_no pacCode,pat_name pacName,\n" + |
|---|
| | | @Select({"<script> select isnull(fcard_no,'不详') xh,fcard_iD pacCode,pat_name pacName,\n" + |
|---|
| | | " (case when patsex_id='0' then '男' when patsex_id='1' then '女' else '未知' end )+';'+brnl detail,\n" + |
|---|
| | | " pat_id price , mobile pacRemark" + |
|---|
| | | " from histjv_ltkjvtjpat where 1=1 "+ |
|---|
| | |
|---|
| | | " AND fcard_no = #{pacCode}" + |
|---|
| | | "</when>" + |
|---|
| | | " <when test='pacName!=null'>" + |
|---|
| | | " AND pat_name = #{pacName}" + |
|---|
| | | " AND pat_name = #(pacName}" + |
|---|
| | | "</when>" + |
|---|
| | | " <when test='pacRemark!=null'>" + |
|---|
| | | " AND mobile = #{pacRemark}" + |
|---|
