/** * 功能说明:将EAM系统发生的公司内资产调拨同步到MIS系统 * * @throws com.sino.base.exception.DataHandleException 将EAM系统发生的公司内资产调拨同步到MIS系统出错时抛数据处理异常 */ public void writeAssetsAllocations() throws DataHandleException { Connection conn = null; try { conn = getDBConnection(); RowSet rows = getCompanyList(conn); if (rows != null && !rows.isEmpty()) { int dataCount = rows.getSize(); SrvDAO srvDAO = new SrvDAO(); for (int i = 0; i < dataCount; i++) { Row row = rows.getRow(i); String orgId = row.getStrValue("ORGANIZATION_ID"); int organizationId = Integer.parseInt(orgId); taskExecutor = getOUTaskExecutor(conn, organizationId); if (taskExecutor == null) { continue; } srvDAO.synTransInCompany(conn, taskExecutor); } } } catch (Throwable ex) { Logger.logError(ex); throw new DataHandleException(ex.getMessage()); } finally { closeDBConnection(conn); } }
private void writeData2Excel(HSSFSheet sheet, HSSFCellStyle dataStyle, HSSFCellStyle headerStyle) throws ContainerException { RowSet searchResult = executeFrm.getSearchResult(); if (searchResult != null && !searchResult.isEmpty()) { List<ReportViewFrm> definedViews = executeFrm.getDefinedViews(); int fieldCount = definedViews.size(); int dataCount = searchResult.getSize(); int xlsRowNum = 0; for (int i = 0; i < dataCount; i++) { Row row = searchResult.getRow(i); xlsRowNum = i; if (isFirstFile) { xlsRowNum++; } HSSFRow xlsRow = sheet.createRow(xlsRowNum); xlsRow.setHeightInPoints(18); for (short j = 0; j < fieldCount; j++) { ReportViewFrm viewFrm = definedViews.get(j); String fieldName = viewFrm.getFieldName(); HSSFCell xlsCell = xlsRow.createCell(j); xlsCell.setCellStyle(dataStyle); HSSFRichTextString richText = new HSSFRichTextString(row.getStrValue(fieldName)); xlsCell.setCellValue(richText); } } } }