修改按钮权限、删除实验室时同时删除存储柜、添加存储柜时条码你不能重复
| | |
| | | String id=getUserId(); |
| | | SysUser sysUser = sysUserService.getSysUser(id); |
| | | // 不是管理员时 |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey()) { |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey() |
| | | && sysUser.getSeeFlag().getKey() != SeeFlag.LEADING.getKey()) { |
| | | this.approvalFlag=false; |
| | | }else { |
| | | this.approvalFlag=true; |
| | |
| | | import com.nanometer.smartlab.entity.BaseMeta; |
| | | import com.nanometer.smartlab.entity.SysReagent; |
| | | import com.nanometer.smartlab.service.BaseMetaService; |
| | | import com.nanometer.smartlab.service.SysLaboratoryContainerService; |
| | | import com.nanometer.smartlab.service.SysProjectService; |
| | | import org.apache.log4j.Logger; |
| | | import org.apache.poi.hssf.usermodel.HSSFWorkbook; |
| | |
| | | |
| | | @Resource |
| | | private SysLaboratoryService sysLaboratoryService; |
| | | @Resource |
| | | private SysLaboratoryContainerService sysLaboratoryContainerService; |
| | | @Resource |
| | | private BaseMetaService baseMetaService; |
| | | @Resource |
| | |
| | | } |
| | | |
| | | this.sysLaboratoryService.deleteSysLaboratory(this.selectedList); |
| | | this.sysLaboratoryContainerService.delBySlcIds(this.selectedList); |
| | | |
| | | FacesUtils.info("删除成功。"); |
| | | } catch (Exception e) { |
| | |
| | | System.out.println(getUser().getSeeFlag().getKey()); |
| | | //SysUser u=sysUserService.getSysUser(getUserId()); |
| | | //System.out.println(u); |
| | | if (getUser().getSeeFlag().getKey() != SeeFlag.MANAGE.getKey()) { |
| | | if (getUser().getSeeFlag().getKey() != SeeFlag.MANAGE.getKey() |
| | | && getUser().getSeeFlag().getKey() != SeeFlag.LEADING.getKey()) { |
| | | editFlag=0; |
| | | }else{ |
| | | editFlag=1; |
| | |
| | | List<Map> exportExcelList(Map params); |
| | | |
| | | List<String> selectProjectsByContainerCode(String containerCode); |
| | | |
| | | int delSlcIds(List<String> ids); |
| | | |
| | | int getSysLaboratoryContainerExist(Map<String, Object> params); |
| | | } |
| | |
| | | <update id="updateInfo" parameterType="java.util.Map"> |
| | | update sys_laboratory_container set temp=#{temp},humidity=#{humidity},voc1=#{voc1},flag=#{flag} where id=#{containerId} |
| | | </update> |
| | | |
| | | <update id="delSlcIds" parameterType="java.util.List"> |
| | | update sys_laboratory_container set valid_flag=0, update_time=now() |
| | | where laboratory_id in |
| | | <foreach collection="list" item="item" index="index" open="(" separator="," close=")"> |
| | | #{item} |
| | | </foreach> |
| | | </update> |
| | | <select id="getSysLaboratoryContainerInfoList" parameterType="java.util.Map" resultMap="SysLaboratoryContainer" > |
| | | select container_code,name,valid_flag,type,character_left,character_right from sys_laboratory_container where update_time >= #{startTime} and #{endTime} > update_time |
| | | </select> |
| | |
| | | AND slc.valid_flag = 1 |
| | | AND sl.valid_flag = 1 |
| | | </select> |
| | | <select id="getSysLaboratoryContainerExist" resultType="java.lang.Integer"> |
| | | select count(1) |
| | | from sys_laboratory_container as su |
| | | where su.valid_flag = 1 |
| | | <if test="containerCode != null and containerCode != ''"> |
| | | and su.container_code = #{containerCode} |
| | | </if> |
| | | <if test="editId != null and editId != ''"> |
| | | and su.id != #{editId} |
| | | </if> |
| | | </select> |
| | | </mapper> |
| | |
| | | if (StringUtils.isNotBlank(applyUserId)) { |
| | | SysUser sysUser = sysUserService.getSysUser(applyUserId); |
| | | // 不是管理员时,加入applyUserId |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey()) { |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey() |
| | | && sysUser.getSeeFlag().getKey() != SeeFlag.LEADING.getKey()) { |
| | | params.put("applyUserId", applyUserId); |
| | | } |
| | | |
| | |
| | | if (StringUtils.isNotBlank(approveUserId)) { |
| | | SysUser sysUser = sysUserService.getSysUser(approveUserId); |
| | | // 不是管理员时,加入applyUserId |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey()) { |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey() |
| | | && sysUser.getSeeFlag().getKey() != SeeFlag.LEADING.getKey()) { |
| | | params.put("approveUserId", approveUserId); |
| | | } |
| | | } |
| | |
| | | if (StringUtils.isNotBlank(approveUserId)) { |
| | | SysUser sysUser = sysUserService.getSysUser(approveUserId); |
| | | // 不是管理员时,加入applyUserId |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey()) { |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey() |
| | | && sysUser.getSeeFlag().getKey() != SeeFlag.LEADING.getKey()) { |
| | | params.put("approveUserId", approveUserId); |
| | | } |
| | | } |
| | |
| | | if (StringUtils.isNotBlank(applyUserId)) { |
| | | SysUser sysUser = sysUserService.getSysUser(applyUserId); |
| | | // 不是管理员时,加入applyUserId |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey()) { |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey() |
| | | && sysUser.getSeeFlag().getKey() != SeeFlag.LEADING.getKey()) { |
| | | params.put("applyUserId", applyUserId); |
| | | } |
| | | |
| | |
| | | |
| | | // 不是管理员时,加入userid |
| | | //if (sysUser.getSeeFlag().getKey() == SeeFlag.MANAGE.getKey()||sysUser.getSeeFlag().getKey() == SeeFlag.LEADING.getKey()) { |
| | | if (sysUser.getSeeFlag().getKey() == SeeFlag.MANAGE.getKey()) { |
| | | if (sysUser.getSeeFlag().getKey() == SeeFlag.MANAGE.getKey() |
| | | && sysUser.getSeeFlag().getKey() != SeeFlag.LEADING.getKey()) { |
| | | |
| | | } else { |
| | | params.put("userId", userId); |
| | |
| | | package com.nanometer.smartlab.service; |
| | | |
| | | import com.nanometer.smartlab.entity.SysLaboratory; |
| | | import com.nanometer.smartlab.entity.SysLaboratoryContainer; |
| | | import com.nanometer.smartlab.entity.SysUser; |
| | | |
| | |
| | | |
| | | List<String> selectProjectsByContainerCode(String containerCode); |
| | | |
| | | boolean delBySlcIds(List<SysLaboratory> selectedList); |
| | | } |
| | |
| | | Map<String, Object> params = new HashMap<String, Object>(); |
| | | params.put("containerCode", containerCode); |
| | | params.put("editId", editId); |
| | | |
| | | int count = this.sysLaboratoryContainerDao.getSysLaboratoryContainerTotalCount(params); |
| | | int count = this.sysLaboratoryContainerDao.getSysLaboratoryContainerExist(params); |
| | | return count > 0; |
| | | } catch (DataAccessException e) { |
| | | logger.error(e.getMessage(), e); |
| | |
| | | return null; |
| | | } |
| | | |
| | | @Override |
| | | public boolean delBySlcIds(List<SysLaboratory> sysLaboratoryList) { |
| | | try { |
| | | if (sysLaboratoryList == null || sysLaboratoryList.size() == 0) { |
| | | return false; |
| | | } |
| | | |
| | | List<String> ids = new ArrayList<String>(); |
| | | for (SysLaboratory sysLaboratory : sysLaboratoryList) { |
| | | ids.add(sysLaboratory.getId()); |
| | | } |
| | | |
| | | int row = this.sysLaboratoryContainerDao.delSlcIds(ids); |
| | | return row != 0; |
| | | } catch (DataIntegrityViolationException ex) { |
| | | logger.warn(ex.getMessage(), ex); |
| | | throw new AlarmException(AlarmCode.DATA_CONFICT, MessageUtil.getMessage(AlarmCode.DATA_CONFICT.getCode())); |
| | | } catch (DataAccessException ex) { |
| | | logger.error(ex.getMessage(), ex); |
| | | throw new BusinessException(ExceptionEnumCode.DB_ERR, |
| | | MessageUtil.getMessageByCode(ExceptionEnumCode.DB_ERR.getCode()), ex); |
| | | } |
| | | } |
| | | |
| | | } |
| | |
| | | if (StringUtils.isNotBlank(createrUser)) { |
| | | SysUser sysUser = sysUserService.getSysUser(createrUser); |
| | | // 不是管理员时,加入applyUserId |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey()) { |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey() |
| | | && sysUser.getSeeFlag().getKey() != SeeFlag.LEADING.getKey()) { |
| | | params.put("createrUser", createrUser); |
| | | } |
| | | } |
| | |
| | | if (StringUtils.isNotBlank(createrUser)) { |
| | | SysUser sysUser = sysUserService.getSysUser(createrUser); |
| | | // 不是管理员时,加入applyUserId |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey()) { |
| | | if (sysUser.getSeeFlag().getKey() != SeeFlag.MANAGE.getKey() |
| | | && sysUser.getSeeFlag().getKey() != SeeFlag.LEADING.getKey()) { |
| | | params.put("createrUser", createrUser); |
| | | } |
| | | } |