CreditExchangeRateMapper.java 1.87 KB
package com.lhcredit.project.business.creditExchangeRate.mapper;

import com.lhcredit.project.business.creditExchangeRate.domain.CreditExchangeRate;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 汇率 数据层
 *
 * @author lhcredit
 * @date 2022-06-30
 */
public interface CreditExchangeRateMapper {
    /**
     * 查询汇率信息
     *
     * @param id 汇率ID
     * @return 汇率信息
     */
    public CreditExchangeRate selectCreditExchangeRateById(Integer id);

    public CreditExchangeRate selectCreditExchangeRateByStatus(@Param("status") String status,@Param("currency") String currency);
    /**
     * 查询汇率列表
     *
     * @param creditExchangeRate 汇率信息
     * @return 汇率集合
     */
    public List<CreditExchangeRate> selectCreditExchangeRateList(CreditExchangeRate creditExchangeRate);

    /**
     * 新增汇率
     *
     * @param creditExchangeRate 汇率信息
     * @return 结果
     */
    public int insertCreditExchangeRate(CreditExchangeRate creditExchangeRate);

    /**
     * 修改汇率
     *
     * @param creditExchangeRate 汇率信息
     * @return 结果
     */
    public int updateCreditExchangeRate(CreditExchangeRate creditExchangeRate);

    /**
     *
     * @param
     * @return
     */
    public int updateByCurrency(String currency);

    /**
     * 删除汇率
     *
     * @param id 汇率ID
     * @return 结果
     */
    public int deleteCreditExchangeRateById(Integer id);

    /**
     * 批量删除汇率
     *
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    public int deleteCreditExchangeRateByIds(String[] ids);

    @Select("select name from billcompanylist where name=#{orgName} limit 1")
    String selectBillList(@Param("orgName") String orgName);

}