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);
|
|
}
|
