| | |
| | | import com.nanometer.smartlab.dao.SysUserDao; |
| | | import com.nanometer.smartlab.entity.SysReagent; |
| | | import com.nanometer.smartlab.entity.SysUser; |
| | | import com.nanometer.smartlab.entity.dto.HazardousWasteUser; |
| | | import com.nanometer.smartlab.entity.dto.LaboratoryVo; |
| | | import com.nanometer.smartlab.entity.dto.SysUserDto; |
| | | import com.nanometer.smartlab.entity.enumtype.ApproverFlag; |
| | | import com.nanometer.smartlab.entity.enumtype.SeeFlag; |
| | |
| | | SysUserDao sysUserDao; |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public List<SysUser> getSysUserList(String arp, String name,String departmentName, Integer first, Integer pageSize) { |
| | | public List<SysUser> getSysUserList(String arp, String name,String departmentName,String project,String company, Integer first, Integer pageSize) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | if (StringUtils.isNotBlank(arp)) { |
| | |
| | | if (StringUtils.isNotBlank(departmentName)) { |
| | | params.put("departmentNameLike", "%" + departmentName + "%"); |
| | | } |
| | | params.put("project", project); |
| | | params.put("company", company); |
| | | params.put("first", first); |
| | | params.put("pageSize", pageSize); |
| | | return this.sysUserDao.getSysUserList(params); |
| | |
| | | } |
| | | } |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | | public int getSysUserTotalCount(String arp, String name,String departmentName) { |
| | | public int getSysUserTotalCount(String arp, String name,String departmentName,String project,String company) { |
| | | try { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | if (StringUtils.isNotBlank(arp)) { |
| | |
| | | if (StringUtils.isNotBlank(departmentName)) { |
| | | params.put("departmentNameLike", "%" + departmentName + "%"); |
| | | } |
| | | params.put("project", project); |
| | | params.put("company", company); |
| | | return this.sysUserDao.getSysUserTotalCount(params); |
| | | } catch (DataAccessException e) { |
| | | logger.error(e.getMessage(), e); |
| | | throw new BusinessException(ExceptionEnumCode.DB_ERR, MessageUtil.getMessageByCode(ExceptionEnumCode.DB_ERR.getCode()), e); |
| | | } |
| | | } |
| | | |
| | | @Override |
| | | public int getUserCountInProject(String arp, String name, String departmentName, String project, String company) { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | params.put("arp", arp); |
| | | params.put("name", name); |
| | | params.put("departmentNameLike", departmentName); |
| | | params.put("project", project); |
| | | params.put("company", company); |
| | | return sysUserDao.getUserCountInProject(params); |
| | | } |
| | | |
| | | @Override |
| | | public List<SysUser> getUserInProject(String arp, String name, String departmentName, String project, String company, Integer first, Integer pageSize) { |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | params.put("arp", arp); |
| | | params.put("name", name); |
| | | params.put("departmentNameLike", departmentName); |
| | | params.put("project", project); |
| | | params.put("company", company); |
| | | return sysUserDao.getUserInProject(params); |
| | | } |
| | | |
| | | @Transactional(propagation = Propagation.REQUIRED) |
| | |
| | | } |
| | | |
| | | @Override |
| | | public SysUser getUserByAccount(String account) { |
| | | public HazardousWasteUser getUserByAccount(String account,String name) { |
| | | Map<String, String> params = new HashMap<>(); |
| | | params.put("account", account); |
| | | params.put("name", name); |
| | | return sysUserDao.getUserByAccount(params); |
| | | } |
| | | |
| | | @Override |
| | | public List<LaboratoryVo.LaboratoryUser> getUserByProject(String project) { |
| | | return sysUserDao.getUserByProject(project); |
| | | } |
| | | |
| | | @Override |
| | | public List<SysUser> getUserByArp(String arp) { |
| | | return sysUserDao.getUserByArp(arp); |
| | | } |
| | | |
| | | |
| | | } |