kongzy
2023-11-28 59d9ea33f503e363f2e2941c7c00cc9dd9d9d1c7
src/main/java/com/nanometer/smartlab/service/SysLaboratoryServiceImpl.java
@@ -9,12 +9,12 @@
import com.nanometer.smartlab.exception.AlarmException;
import com.nanometer.smartlab.exception.BusinessException;
import com.nanometer.smartlab.exception.ExceptionEnumCode;
import com.nanometer.smartlab.model.CommonPage;
import com.nanometer.smartlab.util.ExcelUtils;
import com.nanometer.smartlab.util.IDUtils;
import com.nanometer.smartlab.util.MessageUtil;
import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.dao.DataAccessException;
import org.springframework.dao.DataIntegrityViolationException;
import org.springframework.dao.DuplicateKeyException;
@@ -23,11 +23,6 @@
import org.springframework.transaction.annotation.Transactional;
import javax.annotation.Resource;
import javax.faces.context.FacesContext;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.InputStream;
import java.util.*;
/**
@@ -43,7 +38,6 @@
   @Resource
   SysUserDao sysUserDao;
   @Transactional(propagation = Propagation.REQUIRED)
   public List<SysLaboratory> getSysLaboratoryList(String type, String name,String project,Integer first, Integer pageSize) {
      try {
         Map<String, Object> params = new HashMap<String, Object>();
@@ -64,7 +58,35 @@
      }
   }
   @Transactional(propagation = Propagation.REQUIRED)
   @Override
   public CommonPage<SysLaboratory> getSysLaboratoryList(Integer pageNum, Integer pageSize, String name) {
      if(pageNum==null||pageNum<1){
         pageNum=1;
      }
      if(pageSize==null||pageSize<1){
         pageSize=10;
      }
      if(pageSize>50){
         pageSize=50;
      }
      Map<String, Object> params = new HashMap<>();
      if(StringUtils.isNotBlank(name)){
         params.put("name","%"+name+"%");
      }
      params.put("first", (pageNum-1)*pageSize);
      params.put("pageSize", pageSize);
      CommonPage commonPage=new CommonPage();
      commonPage.setPageNum(pageNum);
      commonPage.setPageSize(pageSize);
      Long total=new Long(sysLaboratoryDao.getSysLaboratoryTotalCount(params));
      commonPage.setTotal(total);
      commonPage.setTotalPage(CommonPage.getTotalPage(total,pageSize));
      List<SysLaboratory> sysReagents=sysLaboratoryDao.getSysLaboratorySimpleInfoList(params);
      commonPage.setList(sysReagents);
      return commonPage;
   }
   public int getSysLaboratoryTotalCount(String type, String name,String project) {
      try {
         Map<String, Object> params = new HashMap<String, Object>();
@@ -83,7 +105,6 @@
      }
   }
   @Transactional(propagation = Propagation.REQUIRED)
   public SysLaboratory getSysLaboratory(String id) {
      try {
         return this.sysLaboratoryDao.getSysLaboratory(id);
@@ -94,7 +115,16 @@
      }
   }
   @Transactional(propagation = Propagation.REQUIRED)
   public SysLaboratory getSysLaboratorySimpleInfo(String id) {
      try {
         return this.sysLaboratoryDao.getSysLaboratorySimpleInfo(id);
      } catch (DataAccessException e) {
         logger.error(e.getMessage(), e);
         throw new BusinessException(ExceptionEnumCode.DB_ERR,
               MessageUtil.getMessageByCode(ExceptionEnumCode.DB_ERR.getCode()), e);
      }
   }
   public SysLaboratory insertSysLaboratory(SysLaboratory sysLaboratory) {
      try {
         if (sysLaboratory.getId() == null) {
@@ -116,7 +146,6 @@
      }
   }
   @Transactional(propagation = Propagation.REQUIRED)
   public boolean updateSysLaboratory(SysLaboratory sysLaboratory) {
      try {
         int row = this.sysLaboratoryDao.updateSysLaboratory(sysLaboratory);
@@ -136,7 +165,7 @@
      }
   }
   @Transactional(propagation = Propagation.REQUIRED)
   public boolean deleteSysLaboratory(List<SysLaboratory> sysLaboratoryList) {
      try {
         if (sysLaboratoryList == null || sysLaboratoryList.size() == 0) {
@@ -170,7 +199,7 @@
      }
   }
   @Transactional(propagation = Propagation.REQUIRED)
   public boolean isSysLaboratoryExist(String barCode, String editId) {
      try {
         Map<String, Object> params = new HashMap<String, Object>();
@@ -186,7 +215,7 @@
      }
   }
   @Transactional(propagation = Propagation.REQUIRED)
   public SysLaboratory getSysLaboratoryByBarCode(String barCode) {
      try {
         Map<String, Object> params = new HashMap<String, Object>();
@@ -299,7 +328,6 @@
   }
   @Override
   @Transactional(propagation = Propagation.REQUIRED)
   public List<SysLaboratory> getSysLaboratoryListByDep(String depId) {
      try {
         Map<String, Object> params = new HashMap<String, Object>();