update

liujie

2026-09-21 20051550f01227ecebbe0bf064e188dd242f58f2

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
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
package com.ruoyi.system.mapper;
 
import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.domain.SysEmployee;
import com.ruoyi.system.dto.SysEmployeePageRequest;
import com.ruoyi.system.vo.SysEmployeeVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
 
import java.util.List;
 
/**
 * 员工管理数据层
 *
 * @author ruoyi
 */
@Mapper
public interface SysEmployeeMapper
{
    public List<SysEmployeeVO> pageList(@Param("query") SysEmployeePageRequest query,
                                        @Param("contactPhoneHash") String contactPhoneHash,
                                        @Param("pageInfo") PageInfo<SysEmployeeVO> pageInfo);
 
    public SysEmployeeVO selectVoById(Long employeeId);
 
    public List<SysEmployeeVO> selectVoByName(@Param("employeeName") String employeeName);
 
    public SysEmployee selectById(Long employeeId);
 
    public SysEmployee checkEmployeeNoUnique(@Param("employeeNo") String employeeNo,
                                             @Param("excludeEmployeeId") Long excludeEmployeeId);
 
    public SysEmployee checkPhoneUnique(@Param("contactPhoneHash") String contactPhoneHash,
                                        @Param("excludeEmployeeId") Long excludeEmployeeId);
 
    public SysEmployee checkCardNoUnique(@Param("cardNo") String cardNo,
                                         @Param("excludeEmployeeId") Long excludeEmployeeId);
 
    public int insertEmployee(SysEmployee employee);
 
    public int updateEmployee(SysEmployee employee);
 
    public int updateEnabled(@Param("employeeIds") List<Long> employeeIds, @Param("enabled") Boolean enabled,
                             @Param("updateBy") String updateBy);
 
    public int clearCard(@Param("employeeIds") List<Long> employeeIds, @Param("updateBy") String updateBy);
 
    public int updateCardNo(@Param("employeeId") Long employeeId, @Param("cardNo") String cardNo,
                            @Param("updateBy") String updateBy);
 
    public int clearFace(@Param("employeeIds") List<Long> employeeIds, @Param("updateBy") String updateBy);
 
    public int deleteByIds(@Param("employeeIds") List<Long> employeeIds, @Param("updateBy") String updateBy);
}