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);
}