新增试剂供应商变更需求

kongzy

2023-10-11 374fb9d9369271b9b858e11a8612850ad3560936

 src/main/java/com/nanometer/smartlab/controller/ReagentMngController.java

@@ -7,6 +7,7 @@
import com.nanometer.smartlab.util.Constants;
import com.nanometer.smartlab.util.FacesUtils;
import com.nanometer.smartlab.util.IDUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.log4j.Logger;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
@@ -128,7 +129,6 @@


    public void query(){
        System.out.println("start====================");
        List<SysReagent> list=this.sysReagentService.query();
        Map<String,SysReagent> map=new HashMap<>();
        List<SysReagent> list2 =new ArrayList<>();
@@ -621,7 +621,6 @@
                sysReagentsList.add(sysReagent);
            }
            sysReagentService.insertSysReagentList2(sysReagentsList);
            System.out.println("=========导入结束=====");
            FacesUtils.info("导入成功。");
        } catch (Exception ex) {
            ex.printStackTrace();
@@ -630,7 +629,6 @@
    }
    //导入
    public void uploadFile(FileUploadEvent event) {
        System.out.println("=========导入开始=====");
        this.codeList=baseMetaService.getAllBaseMeta();
        this.sysSupplierList=sysSupplierService.getSysSupplierList();
        try{
@@ -752,14 +750,14 @@
                    }/*else if(t == 9){
                        valuesList.add(sysSupplierService.getSysSupplierIdByname(cellInfo));
                    }*/else{
                        valuesList.add(cellInfo);
                       if(cellInfo!=null)
                          valuesList.add(cellInfo);
                    }
                }
                if (valuesList.size() != 13){
/*                if (valuesList.size() != 13){
                    break;
                }
                }*/

                System.out.println("value :     "+valuesList);
                sysReagent.setProductSn(valuesList.get(0));//产品编号
                sysReagent.setName(valuesList.get(1));//试剂名称
                sysReagent.setControlProducts(valuesList.get(2));//管制品
@@ -790,7 +788,6 @@
                sysReagentsList.add(sysReagent);
            }
            sysReagentService.insertSysReagentList(sysReagentsList);
            System.out.println("=========导入结束=====");
            FacesUtils.info("导入成功。");
        } catch (Exception ex) {
            ex.printStackTrace();
@@ -811,6 +808,7 @@
                        if (count > 0) {
                            list = sysReagentService.getSysReagentListNew(name, cas, supplierId,getType(), first, pageSize,productSn);
                        }
                        selectedList = new ArrayList<> ();
                    } catch (Exception e) {
                        logger.error(e);
                    }
@@ -819,17 +817,18 @@

                @Override
                public SysReagent getRowData(String rowKey) {
                    Iterator<SysReagent> iterator = this.iterator();
                    if (iterator != null) {
                        SysReagent sr = null;
                        while (iterator.hasNext()) {
                            sr = iterator.next();
                            if (rowKey.equals(sr.getId())) {
                                return sr;
                            }
                        }
                    }
                    return null;
//                    Iterator<SysReagent> iterator = this.iterator();
//                    if (iterator != null) {
//                        SysReagent sr = null;
//                        while (iterator.hasNext()) {
//                            sr = iterator.next();
//                            if (rowKey.equals(sr.getId())) {
//                                return sr;
//                            }
//                        }
//                    }

                    return sysReagentService.getSysReagent(rowKey);
                }
            };
        }
@@ -837,6 +836,20 @@
        return dataModel;
    }

    public void export2Excel() {

        List<Map> list = sysReagentService.selectAll(name, cas, supplierId,getType(), productSn);
        try{
            boolean isexport = sysReagentService.export2Excel(list,getType());
            if (isexport){

            }
        }catch (Exception e){
            e.printStackTrace();
            FacesUtils.warn("导出失败");
        }
    }

    public SysReagent getSysReagent() {
        return sysReagent;
    }