Lius
2024-07-25 9b015b51b72ba050b4c38a6ba79eb45b7065e67d
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
package org.jeecg.modules.system.mapper;
 
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.system.entity.SysIdentity;
 
public interface SysIdentityMapper extends BaseMapper<SysIdentity> {
 
 
    @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 SysIdentity findIdentityByType(@Param("type") String type, @Param("yearValue") String yearValue, @Param("monthValue") String monthValue);
}