| | |
|---|
| | | " WHERE a.tj_num=#{tjNum}") |
|---|
| | | boolean updateTbTransitionByTjNum(String tjNum); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM tb_transition WHERE cus_id=#{cusId} AND pac_id=#{pacId}") |
|---|
| | | @Select("SELECT * FROM tb_transition WHERE cus_id=#{cusId} AND pac_id=#{pacId} and isnull(tj_num)") |
|---|
| | | public List<TbTransition> getTbTransitionListByCusIdAndPac(@Param("cusId") String cusId,@Param("pacId") String pacId); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM tb_transition WHERE cus_id=#{cusId} and card_id=#{cardId}") |
|---|
| | |
|---|
| | | "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); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Update("UPDATE tb_transition a SET \n" + |
|---|
| | | " a.now_price=#{jg},\n" + |
|---|
| | | " a.tj_num=#{tjNum},\n" + |
|---|
| | | " a.card_id=#{cardId},\n" + |
|---|
| | | " a.jxbz=#{jxbz}\n" + |
|---|
| | | " WHERE a.id=#{id}") |
|---|
| | | public boolean updateTbTransitionById(@Param("id")String id,@Param("jxbz")String jxbz,@Param("tjNum")String tjNum,@Param("cardId")String cardId,@Param("jg")BigDecimal jg); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Insert("INSERT INTO tb_transition(\n" + |
|---|
| | | " cus_id,\n" + |
|---|
| | | " pac_id,\n" + |
|---|
