| | |
|---|
| | | "a.ord_price=a.now_price,\n" + |
|---|
| | | "a.now_price=a.ord_price*(#{discount}/10)," + |
|---|
| | | "a.tj_num=#{tjNum}"+ |
|---|
| | | " WHERE a.cus_id=#{cusId} ") |
|---|
| | | " WHERE a.cus_id=#{cusId} AND ISNULL(a.tj_num) ") |
|---|
| | | boolean updateTbTransitionPriceByCusId(@Param("cusId")String cusId,@Param("discount")BigDecimal discount,@Param("tjNum")String tjNum); |
|---|
| | | |
|---|
| | | |
|---|
| | |
|---|
| | | "\tAND a.tj_num = #{tjNumber}") |
|---|
| | | boolean updateCardIdByTjNumAndIdCard(@Param("idCard")String idCard,@Param("cardId")String cardId,@Param("tjNumber") String tjNumber); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Delete("DELETE FROM tb_transition WHERE jxbz=#{bldh}") |
|---|
| | | void deleteTjOrderDetailByjxbz(String bldh); |
|---|
| | | } |
|---|
