| 提交 | 用户 | 时间 | ||
| 58d006 | 1 | package com.mandi.fendan.mapper; |
| A | 2 | |
| 3 | import com.mandi.fendan.persist.FdMxWlgs; | |
| 4 | import org.apache.ibatis.annotations.Delete; | |
| 5 | import org.apache.ibatis.annotations.Insert; | |
| 6 | import org.apache.ibatis.annotations.Param; | |
| 7 | import org.apache.ibatis.annotations.Select; | |
| 8 | ||
| 9 | import java.util.List; | |
| 10 | import java.util.Map; | |
| 11 | ||
| 12 | public interface FdMxWlgsMapper { | |
| 13 | @Insert("insert into fd_mx_wlgs(td_tdls,tdmx_tdfl,wlgs_no) values(#{tdTdls},#{tdmxTdfl},#{wlgsNo})") | |
| 14 | public int insert(FdMxWlgs fd); | |
| 15 | ||
| 16 | @Delete("delete from fd_mx_wlgs where tdmx_tdfl=#{tdmxTdfl}") | |
| 17 | int delete(@Param("tdmxTdfl") String tdmxTdfl); | |
| 18 | ||
| 19 | @Select("select count(*) from fd_mx_wlgs where td_tdls = #{tdTdls}") | |
| 20 | int selectCountByTdTdls(@Param("tdTdls") String tdTdls); | |
| 21 | ||
| 22 | ||
| 23 | @Select("select fd_cq from fd_chg_comp_role where fd_user = #{username}") | |
| 24 | List<Map> selectChangqu(@Param("username") String username); | |
| 25 | ||
| 26 | @Select("select count(1) from fd_chg_comp_role where fd_user = #{username}") | |
| 27 | int selectFdRoleExists(@Param("username") String username); | |
| 28 | ||
| 29 | } | |
