programs_info/宜兴紫砂拍卖系统/支付用信息/20221201版本/pay/mapper/PayOrderMapper.java

package com.tendbird.bzserver.pay.mapper;

import com.tendbird.bzserver.pay.domain.PayOrder;
import org.apache.ibatis.annotations.*;
import org.springframework.security.core.parameters.P;
import org.springframework.stereotype.Repository;

import java.util.Date;

@Mapper
@Repository
public interface PayOrderMapper {
    @Select("SELECT * FROM payorder WHERE mchorderno = #{orderNo}")
    PayOrder findByorderNo(@Param("orderNo") String orderNo);

    @Select("SELECT * FROM payorder WHERE orderno = #{orderNo} AND status = #{status}")
    PayOrder findByorderNoStatus(@Param("orderNo") String orderNo,
                                 @Param("status") String status);

    @Insert("INSERT INTO payorder" +
            "(mchorderno,mchorderid,ywrq,orderid,waycode,amount,currency,subject,body," +
            "reason,paytime,status,errcode,errmsg,authcode) " +
            "VALUES " +
            "(#{mchOrderNo},#{mchOrderId},#{ywrq},#{orderId},#{wayCode},#{amount},#{currency},#{subject},#{body}," +
            "#{reason},#{payTime},#{status},#{errCode},#{errMsg},#{authCode})")
    int save(PayOrder payOrder) throws Exception;

    @Update("UPDATE payorder SET " +
            "orderid = #{orderId}," +
            "status = #{status}," +
            "errcode = #{errCode}," +
            "errmsg = #{errMsg}")
    int update(PayOrder payOrder) throws Exception;
}