cuijian
2023-08-29 a81b9fc7dc055874d501becd1862b4ff581c0d4a
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
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.SerialNumberMap;
 
public interface SerialNumberMapMapper extends BaseMapper<SerialNumberMap> {
    @Select("select id," +
            "function_name," +
            "begin_symbol," +
            "enterprise_code," +
            "year_format," +
            "month_format," +
            "day_format," +
            "type," +
            "identity_id" +
            " from mom_serial_number_map t1 where t1.type = #{type}")
    public SerialNumberMap getByType(@Param("type") String type);
 
    @Select("<script> select F_GET_SEQ_ID(#{type}) </script>")
    public String getNum(@Param("type") String type);
 
    boolean  updateBatchByEnterpriseCode(@Param("enterpriseCode") String enterpriseCode);
}