| | |
| | | |
| | | import java.io.InputStream; |
| | | import java.math.BigDecimal; |
| | | import java.util.ArrayList; |
| | | import java.util.Iterator; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | import java.util.*; |
| | | |
| | | import javax.annotation.Resource; |
| | | |
| | | import com.nanometer.smartlab.entity.BaseMeta; |
| | | import com.nanometer.smartlab.entity.SysReagent; |
| | | import com.nanometer.smartlab.service.BaseMetaService; |
| | | import com.nanometer.smartlab.service.SysProjectService; |
| | | import org.apache.log4j.Logger; |
| | | import org.apache.poi.hssf.usermodel.HSSFWorkbook; |
| | | import org.apache.poi.ss.usermodel.Row; |
| | |
| | | private SysLaboratoryService sysLaboratoryService; |
| | | @Resource |
| | | private BaseMetaService baseMetaService; |
| | | @Resource |
| | | private SysProjectService sysProjectService; |
| | | /** |
| | | * 数据源 |
| | | */ |
| | |
| | | laboratory.setLocation1(valuesList.get(4)); |
| | | laboratory.setLocation2(valuesList.get(5)); |
| | | laboratory.setDepartment(returnDepartId(departList,valuesList.get(6))); |
| | | |
| | | if (valuesList.size() > 7 && !valuesList.get(7).replace(" ","").isEmpty()){ |
| | | List<String> projects = Arrays.asList(valuesList.get(7).split(",")); |
| | | for (String project : projects) { |
| | | //不存再就直接推出 |
| | | if (!sysProjectService.isExistProject(project)) { |
| | | throw new Exception("课题组不存在,(" + i + "行)"); |
| | | } |
| | | } |
| | | //都存在就设置 |
| | | laboratory.setProject(valuesList.get(7).replace(" ","")); |
| | | }else{ |
| | | laboratory.setProject(null); |
| | | } |
| | | sysLaboratories.add(laboratory); |
| | | } |
| | | sysLaboratoryService.insertSysReagentList(sysLaboratories); |