/** * 查询所有的物质档案信息 * * @return */ public ArrayList FindAllMaterialRecordInfromation() { ArrayList list = new ArrayList(); // 创建list Query q = em.createQuery("select p from wzMaterialRecord p order by p.id desc"); // 建立带有参数的查询 List result = q.getResultList(); // 返回结果 if (!result.isEmpty()) { Iterator ite = result.iterator(); // 建立迭代器 // 遍历结果并将数据存入list中 while (ite.hasNext()) { wzMaterialRecord mate = (wzMaterialRecord) ite.next(); if (mate != null) { if (mate.getDeptSysCode().getSysCode() != 0) { list.add(mate.getDeptSysCode().getSysCode()); } else { list.add(""); } if (mate.getDeptSysCode().getSysName() != null) { list.add(mate.getDeptSysCode().getSysName()); } else { list.add(""); } if (mate.getMaterialCode() != null) { list.add(mate.getMaterialCode()); } else { list.add(""); } if (mate.getMaterialConfig() != null) { list.add(mate.getMaterialConfig()); } else { list.add(""); } if (mate.getMaterialName() != null) { list.add(mate.getMaterialName()); } else { list.add(""); } if (mate.getMaterialUnit() != null && mate.getMaterialUnit().getUnitNo() != 0) { list.add(mate.getMaterialUnit().getUnitNo()); } else { list.add(""); } if (mate.getMaterialUnit() != null && mate.getMaterialUnit().getUnitName() != null) { list.add(mate.getMaterialUnit().getUnitName()); } else { list.add(""); } if (mate.getMaterialTwoType() != null && mate.getMaterialTwoType().getTwoType() != 0) { list.add(mate.getMaterialTwoType().getTwoType()); } else if (mate.getMaterialOneType() != null && mate.getMaterialOneType().getOneType() != 0) { list.add(mate.getMaterialOneType().getOneType()); } else { list.add(""); } if (mate.getMaterialTwoType() != null && mate.getMaterialTwoType().getTwoTypeName() != null) { list.add(mate.getMaterialTwoType().getTwoTypeName()); } else if (mate.getMaterialOneType() != null && mate.getMaterialOneType().getOneTypeName() != null) { list.add(mate.getMaterialOneType().getOneTypeName()); } else { list.add(""); } if (mate.getMaterialProp() != 0) { list.add(mate.getMaterialProp()); } else { list.add(""); } if (mate.getAbcType() != 0) { list.add(mate.getAbcType()); } else { list.add(""); } if (mate.getPriceAddRate() != 0.0f) { list.add(mate.getPriceAddRate()); } else { list.add(""); } if (mate.getVelocity() != 0.0f) { list.add(mate.getVelocity()); } else { list.add(""); } if (mate.getChargeCode() != 0L) { list.add(mate.getChargeCode()); } else { list.add(""); } if (mate.getStopMark() != -1) { list.add(mate.getStopMark()); } else { list.add(""); } if (mate.getPyCode() != null) { list.add(mate.getPyCode()); } else { list.add(""); } if (mate.getDCode() != null) { list.add(mate.getDCode()); } else { list.add(""); } } } return list; // 返回list } else { return null; } }