package com.dy.pipIrrGlobal.daoSe;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.pojoSe.SeVirtualCard;
import com.dy.pipIrrGlobal.voSe.VoVirtualCard;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author ZhuBaoMin
 * @date 2024-05-23 16:44
 * @LastEditTime 2024-05-23 16:44
 * @Description
 */

@Mapper
public interface SeVirtualCardMapper extends BaseMapper<SeVirtualCard> {
    int deleteByPrimaryKey(Long id);

    int insert(SeVirtualCard record);

    int insertSelective(SeVirtualCard record);

    SeVirtualCard selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(SeVirtualCard record);

    int updateByPrimaryKey(SeVirtualCard record);

    /**
     * 验证农户是否拥有指定名称的虚拟卡
     * @param clientId 农户编号
     * @param vcName 虚拟卡名称
     * @return 符合条件记录数
     */
    int getRecordCountByName(@Param("clientId") Long clientId, @Param("vcName") String vcName);

    /**
     * 获取全部虚拟卡
     * @return
     */
    List<VoVirtualCard> getVCs();

    /**
     * 根据虚拟卡ID获取虚拟卡对象
     * @param vcId
     * @return
     */
    VoVirtualCard getVcById(@Param("vcId") Long vcId);

    /**
     * 根据虚拟卡编号获取虚拟卡ID
     * @param vcNum
     * @return
     */
    Long getVcIdByNum(@Param("vcNum") String vcNum);
}