/** * Query Hub packing * * @param doPackPartReturnMappingForm DoPackPartReturnMappingForm * @param orgCode Long ASC code * @return ArrayList Packing list */ public ArrayList list(BrokenPartsHubForm form) { List dataList = new ArrayList(); ArrayList alData = new ArrayList(); ReturnPartHubQuery uq = new ReturnPartHubQuery(form); // 实例化queryBean int count = 0; try { dataList = uq.doListQuery(form.getFromPage(), form.getToPage()); // 查询坏件信息 count = uq.doCountQuery(); BrokenPartsHubForm uf = new BrokenPartsHubForm(); for (int i = 0; i < dataList.size(); i++) { String[] data = new String[14]; uf = (BrokenPartsHubForm) dataList.get(i); data[0] = uf.getReturnCode(); data[1] = uf.getServiceSheetNo() == null ? "" : uf.getServiceSheetNo().toString(); // BO_ID data[2] = uf.getModelCode() == null ? "" : uf.getModelCode(); // 机型 data[3] = uf.getSerialNo() == null ? "" : uf.getSerialNo(); // 机身号 data[4] = uf.getPartCode() == null ? "" : uf.getPartCode(); // 零件编号 data[5] = uf.getSnNo() == null ? "" : uf.getSnNo().toString(); // 零件序列号 data[6] = uf.getPartName() == null ? "" : uf.getPartName(); // 零件中文描述 data[7] = uf.getPartDesc() == null ? "" : uf.getPartDesc(); // 零件英文描述 data[8] = uf.getBpNum() == null ? "" : uf.getBpNum().toString(); // 零件数量 data[9] = uf.getReturnLocation() == null ? "" : uf.getReturnLocation(); // ReturnLocation data[10] = uf.getHubId().toString() + CommonSearch.split1 + uf.getVersion(); // 返回的BoId+版本号 data[11] = uf.getReceiveDate() == null ? "" : Operate.formatYMDDate(uf.getReceiveDate()); // 回库日期 alData.add(data); } alData.add(0, count + ""); } catch (Exception e) { e.printStackTrace(); } finally { } return alData; }