package cn.iocoder.yudao.module.srm.dal.mysql;

import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
import cn.iocoder.yudao.module.srm.dal.dataobject.SrmSupplierBankDO;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface SrmSupplierBankMapper extends BaseMapperX<SrmSupplierBankDO> {

    default List<SrmSupplierBankDO> selectListBySupplierId(Long supplierId) {
        return selectList(new LambdaQueryWrapperX<SrmSupplierBankDO>()
                .eq(SrmSupplierBankDO::getSupplierId, supplierId)
                .orderByAsc(SrmSupplierBankDO::getSort)
                .orderByAsc(SrmSupplierBankDO::getId));
    }

    default void deleteBySupplierId(Long supplierId) {
        delete(new LambdaQueryWrapperX<SrmSupplierBankDO>()
                .eq(SrmSupplierBankDO::getSupplierId, supplierId));
    }

    default long selectCountBySupplierId(Long supplierId) {
        return selectCount(SrmSupplierBankDO::getSupplierId, supplierId);
    }

}