package com.ynxbd.common.dao;

import com.ynxbd.common.config.db.DataBase;

/**
 * @Author wsq
 * @Date 2021/7/5 14:59
 * @Copyright @ 2020 云南新八达科技有限公司 All rights reserved.
 */
public class SysConfigDao {

    /**
     * [挂号成功] 更新信息
     *
     * @param outTradeNo  订单号
     * @param bankTransNo 樱花交易流水号
     * @param hisTransNo  HIS流水号
     * @param treatNum    门诊号[今日挂号返回门诊号，预约挂号不返回门诊号]
     * @return 是否成功
     */
    public boolean updateHisRegInfo(String outTradeNo, String bankTransNo, String hisTransNo, String treatNum, String invoiceTransNo, String callNum) {
        String sql = "update register set hisStatus=0, bankTransNo=?, hisTransNo=?, treatNum=?, invoiceTransNo=?, callNum=? where outTradeNo=? and hisStatus= -1";
        return DataBase.update(sql, ps -> {
            ps.setString(1, bankTransNo);
            ps.setString(2, hisTransNo);
            ps.setString(3, treatNum);
            ps.setString(4, invoiceTransNo);
            ps.setString(5, callNum);
            ps.setString(6, outTradeNo);
        }) > 0;
    }
}