润乾API操作实例

package nbpt.ts.report.test.helper; import java.io.File; import java.io.FileNotFoundException; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.util.ArrayList; import java.util.List;

import com.runqian.report4.model.ReportDefine; import com.runqian.report4.usermodel.DataSetConfig; import com.runqian.report4.usermodel.DataSetMetaData; import com.runqian.report4.usermodel.IByteMap; import com.runqian.report4.usermodel.IColCell; import com.runqian.report4.usermodel.INormalCell; import com.runqian.report4.usermodel.IReport; import com.runqian.report4.usermodel.IRowCell; import com.runqian.report4.usermodel.MacroMetaData; import com.runqian.report4.usermodel.Param; import com.runqian.report4.usermodel.ParamMetaData; import com.runqian.report4.usermodel.ProcDataSetConfig; import com.runqian.report4.usermodel.SQLDataSetConfig; import com.runqian.report4.usermodel.Types; import com.runqian.report4.util.ReportUtils;

public class RunQianHelper { private String raqFilesPath = "WebContent/report/zh/"; List reportRaqFileNames = new ArrayList();

public RunQianHelper(){ //File dir = new File(raqFilesPath); //loadFiles(dir); }

public List loadFilesa(File dir) { File[] files = dir.listFiles(); for (int i = 0; i < files.length; i++) { if (files[i].isFile()) { if (files[i].getAbsolutePath().endsWith(".raq")) { reportRaqFileNames.add(files[i].getAbsolutePath()); } } else { loadFiles(files[i]); } } return reportRaqFileNames; }

/** * 统一把行高设置成8 */ @SuppressWarnings("unused") public void setRowHeight(List arrList) { int flag=0; int index=0; for(String item : arrList) { String fileName = item; if(!fileName.contains("error")) { continue; } try { ReportDefine rd = (ReportDefine)ReportUtils.read(fileName); int colCount = rd.getColCount(); int rowCount = rd.getRowCount(); for(int i=1; i<=3; i++) { IRowCell iRowCell = rd.getRowCell(i); iRowCell.setRowHeight(8); for(int j=1; j<=colCount; j++) { INormalCell cell = rd.getCell(i, (short)j); cell.setFontSize((short)12); } } ReportUtils.write(fileName, rd); } catch (Exception e) { System.out.println(fileName + "-" + e.toString()); } System.out.println(fileName + "-" + "已经处理!"); } System.out.println("处理完成！"); } /** * 处理报表javascript链接在新窗口弹出 */ @SuppressWarnings("unused") public void adjustJavaScriptWindows(List arrList) { int flag=0; int index=0; for(String item : arrList) { String fileName = item; try { ReportDefine rd = (ReportDefine)ReportUtils.read(fileName); for(short i=1; i<=rd.getColCount(); i++) { IColCell colCell = rd.getColCell((short)i); INormalCell cell = rd.getCell(1, (short)i); if(cell.getValue() == null) { continue; } INormalCell cell2 = rd.getCell(2, (short)i); if(cell2 != null) { IByteMap iByteMap = cell2.getExpMap(); if(iByteMap != null && iByteMap.get(INormalCell.LINK) != null) { cell2.setHyperlinkWindow("_blank"); System.out.println(fileName + "-" + "已经处理!"); } } } ReportUtils.write(fileName, rd); } catch (Exception e) { System.out.println(fileName + "-" + e.toString()); } } System.out.println("处理完成！"); }

/** * 隔行换色的处理 */ @SuppressWarnings("unused") public void setRowColor(List arrList) { int flag=0; int index=0; for(String item : arrList) { String fileName = item; try { ReportDefine rd = (ReportDefine)ReportUtils.read(fileName); int colCount = rd.getColCount(); int rowCount = rd.getRowCount(); for(int i=1; i<=rowCount; i++) { IRowCell iRowCell = rd.getRowCell(i); if(IRowCell.TYPE_NORMAL == iRowCell.getRowType()) { for(int j=1; j<=colCount; j++) { INormalCell cell = rd.getCell(i, (short)j); IByteMap iByteMap = cell.getExpMap(); iByteMap.put(INormalCell.BCOLOR, "if(row()%2==0,-3342337,-1)"); cell.setExpMap(iByteMap); } System.out.println(fileName + "-" + "已经处理!"); } } ReportUtils.write(fileName, rd); } catch (Exception e) { System.out.println(fileName + "-" + e.toString()); } } System.out.println("处理完成！"); }

/** * 处理报表的javascript函数，改成超链接 */ @SuppressWarnings("unused") public void adjustJavaScriptColumn(List arrList) { int flag=0;