1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
| package org.jeecg.modules.eam.mapper;
|
| import com.baomidou.mybatisplus.core.mapper.BaseMapper;
| import org.apache.ibatis.annotations.Param;
| import org.apache.ibatis.annotations.Select;
| import org.jeecg.modules.eam.entity.Identity;
|
| public interface IdentityMapper extends BaseMapper<Identity> {
| // @Select("select id," +
| // "num," +
| // "month_value," +
| // "year_value," +
| // "type," +
| // "remark " +
| // " from mes_sys_identity t1 where t1.type = #{type}")
| // public MesSysIdentity findIdentityByType(@Param("type")String type);
|
|
| @Select("select id," +
| "num," +
| "month_value," +
| "year_value," +
| "type," +
| "remark " +
| " from mom_sys_identity t1 where t1.type = #{type} and t1.year_value = #{yearValue} and t1.month_value =#{monthValue}")
| public Identity findIdentityByType(@Param("type") String type, @Param("yearValue") String yearValue, @Param("monthValue") String monthValue);
| }
|
|