package com.mandi.fendan.mapper;

import com.mandi.fendan.persist.FdMxWlgs;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

public interface FdMxWlgsMapper {
    @Insert("insert into fd_mx_wlgs(td_tdls,tdmx_tdfl,wlgs_no) values(#{tdTdls},#{tdmxTdfl},#{wlgsNo})")
    public int insert(FdMxWlgs fd);

    @Delete("delete from fd_mx_wlgs where tdmx_tdfl=#{tdmxTdfl}")
    int delete(@Param("tdmxTdfl") String tdmxTdfl);

    @Select("select count(*) from fd_mx_wlgs where td_tdls = #{tdTdls}")
    int selectCountByTdTdls(@Param("tdTdls") String tdTdls);


    @Select("select fd_cq from fd_chg_comp_role where fd_user = #{username}")
    List<Map> selectChangqu(@Param("username") String username);

    @Select("select count(1) from fd_chg_comp_role where fd_user = #{username}")
    int selectFdRoleExists(@Param("username") String username);

}