用iReport设置pdf模版

来源：互联网发布：java 随机数生成编辑：程序博客网时间：2024/06/06 00:24

public void idleAssetrequest_printPDFTransaction() throws Exception {

//得到前台传来的数据

Assetidlemaster assetidlemaster = (Assetidlemaster) BeanUtil

.createBean(Assetidlemaster.class, request);

//后台查询

assetidlemaster = (Assetidlemaster) sqlDao.getRecord(

"assetidlemaster.getRecord", assetidlemaster);

//将数据存到附表

Assetidledetail assetidledetail = new Assetidledetail();
assetidledetail.setOrgancode(assetidlemaster.getOrgancode());
assetidledetail.setBillcode(assetidlemaster.getBillcode());
model.put("organcode", assetidlemaster.getOrgancode());

model.put("billcode", assetidlemaster.getBillcode());

//的到需要存到报表的数据

List assetidlemasterList = sqlDao.getRecordList(
"assetidledetail.getPrintRecord", model);

DecimalFormat dfs = new DecimalFormat("0.00");

//将数据中需要合计的数值累加

for (int i = 0; i < assetidlemasterList.size(); i++) {
Assetidledetail a = (Assetidledetail) assetidlemasterList
.get(i);
String numvalue = dfs.format(a.getNuminitvalue());
a.setNumvalue(numvalue);
if (a.getEvaluatevalue() != null) {
String evalvalue = dfs.format(a.getEvaluatevalue());
a.setEvalvalue(evalvalue);
}

}

JasperReportPrint reportPrint = new JasperReportPrintImpl(application,
response);
String pathname = (String) sqlDao.getRecord("basSetup.findFilePath");
// 路劲
reportPrint.setpathname(pathname);
// 文件名
reportPrint.setReport("idleAssetrequest_report");
// 数据库数据集合显示表中
reportPrint.setJRBeanDataSource(assetidlemasterList);
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd");
// 申请日期
reportPrint.setParameter("applydate",
df.format(assetidlemaster.getApplydatetime()));
// 的到单位所在市区
String printTitle = ((Bassetup) sqlDao.getRecord("basSetup.getRecord"))
.getPrinttitle();
// 设置标题
reportPrint.setParameter("printTitle", printTitle + "行政事业单位资产处置申请表");
assetidledetail = (Assetidledetail) sqlDao.getRecord(
"assetidledetail.getSumByBillcode", assetidledetail);
// 转换合计数
String sum_numinitvalue = dfs.format(assetidledetail

.getNuminitvalue());

//数据存到报表字段中

reportPrint.setParameter("sum_numinitvalue", sum_numinitvalue);
reportPrint.setParameter("organname",
((Assetidledetail) assetidlemasterList.get(0)).getUnitname());
reportPrint.setParameter("circsexplain",
assetidlemaster.getCircsexplain());

reportPrint.setParameter("billcode", assetidlemaster.getBillcode());

//设置存放路径

reportPrint
.setDescription("js/UseOfAssets/idleAssetrequest_report.pdf");
reportPrint.viewPdfReport();
this.modelAndView = new ModelAndView(
"js/UseOfAssets/idleAssetrequest_report.pdf", model);

}

0 0