package com.newfiber.api.pc.dao.RiverManage;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.newfiber.api.pc.model.River.PatrolManageUserRelation;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * patrolManageUserRelation model层
 *
 * @author luzhan
 */
@Repository
public interface PatrolManageUserRelationMapper extends BaseMapper<PatrolManageUserRelation> {

    /**
     * 查询绑定信息
     * @param bindNo
     * @return
     */
    PatrolManageUserRelation selectByBindNo(@Param("bindNo") Long bindNo,@Param("patrolType") Integer patrolType);

    List<PatrolManageUserRelation> selectByUsername(@Param("userName") String userName,@Param("patrolType") Integer patrolType);

    void deleteByData(@Param("patrolType")Integer patrolType, @Param("oldUserNo")String oldUserNo, @Param("id")Long id);

    /**
     * 批量修改绑定的用户名
     * @param userNo
     * @param name
     */
    void updatebatchName(@Param("userNo") String userNo, @Param("name")String name);
}