| | |
| | | import org.apache.ibatis.annotations.Select; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * @Company: 西安路泰科技有限公司 |
| | |
| | | @Select("SELECT * FROM histjv_LTKJVTJPAT") |
| | | public List<LtkjTjPat> getTjPat(); |
| | | |
| | | @DataSource(value = DataSourceType.SLAVE_PACS) |
| | | @Select("select fcard_iD xh,fcard_no 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\n" + |
| | | " from histjv_ltkjvtjpat") |
| | | public List<Map<String,Object>> newGetTjPat(); |
| | | |
| | | @DataSource(value = DataSourceType.SLAVE_HIS) |
| | | @Select("SELECT * FROM histjv_LTKJVTJPAT where Ltrim(Rtrim(fcard_no)) = #{id} ") |
| | | @Select("SELECT * FROM histjv_LTKJVTJPAT where Ltrim(Rtrim(fcard_no)) = #{id} or Ltrim(Rtrim(fcard_id))=#{id} ") |
| | | public LtkjTjPat getTjPatByIdCard(String id); |
| | | |
| | | |