Houjie
2025-06-10 be8a6f171bd41aa50fb7310b2ccbe753dac20b89
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);
}