| | |
|---|
| | | public boolean deletedTbTransitionListByCusIdAndPac(String cusId); |
|---|
| | | |
|---|
| | | //根据身份证号和套餐id查询和项目id |
|---|
| | | @Select("SELECT * FROM tb_transition WHERE cus_id=#{cusId} AND ISNULL(pac_id) AND pro_id =#{proId}") |
|---|
| | | // @Select("SELECT * FROM tb_transition WHERE cus_id=#{cusId} AND ISNULL(pac_id) AND pro_id =#{proId}") |
|---|
| | | // public List<TbTransition> getTbTransitionListByCusIdAndPacIdAndProId(@Param("cusId") String cusId,@Param("proId") String proId); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM tb_transition WHERE cus_id=#{cusId} AND pro_id =#{proId}") |
|---|
| | | public List<TbTransition> getTbTransitionListByCusIdAndPacIdAndProId(@Param("cusId") String cusId,@Param("proId") String proId); |
|---|
| | | |
|---|
| | | @Select("SELECT DISTINCT pac_id FROM tb_transition WHERE cus_id=#{cusId} AND !ISNULL(pac_id)") |
|---|
