| | |
|---|
| | | |
|---|
| | | @Select("SELECT SUM(a.now_price) FROM tb_transition a WHERE a.cus_id=#{cusId} AND a.parent_pro_id=#{proId} and a.card_id=#{cardId} and a.pac_id=#{pacId}") |
|---|
| | | BigDecimal getTbTransitionDxPriceByPac(@Param("cusId")String cusId,@Param("proId")Long proId,@Param("cardId")String cardId,@Param("pacId")Long pacId); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Update("UPDATE tb_transition a \n" + |
|---|
| | | "SET \n" + |
|---|
| | | "a.card_id=#{cardId}\n" + |
|---|
| | | "WHERE\n" + |
|---|
| | | "\ta.cus_id =#{idCard}\n" + |
|---|
| | | "\tAND ISNULL(a.tj_num)") |
|---|
| | | boolean updateCardIdByTjNumAndIdCard(@Param("idCard")String idCard,@Param("cardId")String cardId); |
|---|
| | | |
|---|
| | | } |
|---|
