打印报表版本2.0

来源：互联网发布：恩施有没有淘宝网编辑：程序博客网时间：2024/05/17 04:00

<div align="center" style="height: 2px"><jsfext:cb4Workflow value="打印入户通知书" accesskey="d"disabled="#{not SnyjDyModel.allowSh}" action="onCp"model="#{SnyjDyModel}" /><button id="dyzqz" accesskey="p" tabindex="-1" style="width: 120px"onclick="window.open('','newWin','top=20,left=20,height=500,width=1024,status=yes,toolbar=no,menubar=no,location=no');document.getElementById('openQrryPage').click()">打印准迁证(p)</button></div><t:commandLink value="查看迁入人员信息" tabindex="-1" id="openQrryPage"target="newWin"style="font-size: 10pt; color: blue; text-decoration: none; display: none"action="#{SnyjDyModel.goToQrryPage}" forceId="true"><f:param value="SnyjDyModel" name="parentModel4Qrryxx" /></t:commandLink>

/** * * @跳转到打印页面 * @return String */public String goToQrryPage() {return QRRY_OUTCOME;}/** * @保存准迁证号码，且只保存选中的人 * @return */public String onSaveDyxx() {transactionTemplate.execute(new TransactionCallback() {public Object doInTransaction(TransactionStatus arg0) {String[] idArr = id.split(",");for (int j = 0; idArr != null && j < idArr.length; j++) {for (int i = 0; qrryxxList != null && i < qrryxxList.size(); i++) {Qrryxx temp = qrryxxList.get(i);if (temp.getId().equals(idArr[j])) {temp.setZqzmbh(zqzh);qrryxxDAO.attachDirty(temp);break;}}}return null;}});zqzh = "";// 清空准迁证号码return SELF_OUTCOME;}

// ´òÓ¡»§¼®ÉóÅúµÄ×¼Ç¨Ö¤function printHjspZqz(slh, id) {var zqzh=document.getElementById("zqzhm").value;if (slh != null && id != null) {window.open("/gdrk/cn/hnisi/gdrk/reportFiles/hjgl/HjspZqz.jsp?slh="+ slh + "&id=" + id+"&zqzh="+zqzh,"","width=1024,height=500,top=100,left=100,toolbar=no,location=no,directories=no,menubar=no,scrollbars=yes,resizable=no,status=no");}return false;}

<%@ page contentType="text/html;charset=GBK"%><%@ taglib uri="/WEB-INF/runqianReport4.tld" prefix="report"%><%@ page language="java"%><html><title>准予迁入证明</title><body onmouseover="self.status='准予迁入证明';return true" topMargin=0rightMargin=0 bottomMargin=0><%String reportName = "hjgl/HjspZqz" + ".raq";String b = "SLH=" + request.getParameter("slh");String d="ZQZMBH="+request.getParameter("zqzh");String arrs[] = new String[4];arrs = request.getParameter("id").split(",");int n = arrs.length;String a = null;if (n == 0)a = "";else if (n == 1)a = "ID1=" + arrs[0];else if (n == 2)a = "ID1=" + arrs[0] + ";" + "ID2=" + arrs[1];else if (n == 3)a = "ID1=" + arrs[0] + ";" + "ID2=" + arrs[1] + ";" + "ID3="+ arrs[2];else if (n == 4)a = "ID1=" + arrs[0] + ";" + "ID2=" + arrs[1] + ";" + "ID3="+ arrs[2] + ";" + "ID4=" + arrs[3];String c = "N=" + n;String e = b + ";" + a + ";" + c+";"+d;%><div align="center"style="border: 0 solid #91A7B4; overflow-x: auto; overflow-y: auto; height: 100%; width: 100%"><table width="100%" height="800"><tr><td valign="top" align="center"><report:html name="report1" reportFileName="<%=reportName%>"params="<%=e%>" funcBarLocation="boTh" needPageMark="yes"functionBarColor="#fff5ee" funcBarFontSize="10pt"funcBarFontColor="blue" separator=" "needSaveAsExcel="yes" needSaveAsPdf="yes" needPrint="yes"pageMarkLabel="页号{currpage}/{totalPage}" printLabel="打印"displayNoLinkPageMark="yes" saveAsName="准予迁入证明" /></td></tr></table></div></body></html>

数据集DS_PRINT_QRSP_ZQZ

SELECT t1.SLH,t1.ZQYY,t1.BZ,t1.CBR,t1.DZ,t1.FWDW,t1.GMSFHM,t1.HKDJJG,t1.PZJG,t1.QCDXZ,t1.SQRXM FROM V_HJSP_PRINT_QRSP_ZQZ t1WHERE ( t1.SLH = ?)

数据集DS_QRRYXX1

SELECT t.YZQRGXMC,t.XM,t.XBMC,t.SLH ,t.ZJHM,t.ID,t.ZQZMBH,rownum rid,to_char(t.CSRQ,'YYYYMMDD') CSRQ FROM V_HJSP_QRRYXX t WHERE t.id=? and t.SLH = ?

数据集DS_QRRYXX2

SELECT t.YZQRGXMC,t.XM,t.XBMC,t.SLH ,t.ZJHM,t.ID,t.ZQZMBH,rownum rid,to_char(t.CSRQ,'YYYYMMDD') CSRQ FROM V_HJSP_QRRYXX t WHERE t.id=? and t.SLH = ?

数据集DS_QRRYXX3

SELECT t.YZQRGXMC,t.XM,t.XBMC,t.SLH ,t.ZJHM,t.ID,t.ZQZMBH,rownum rid,to_char(t.CSRQ,'YYYYMMDD') CSRQ FROM V_HJSP_QRRYXX t WHERE t.id=? and t.SLH = ?

数据集DS_QRRYXX4

SELECT t.YZQRGXMC,t.XM,t.XBMC,t.SLH ,t.ZJHM,t.ID,t.ZQZMBH,rownum rid,to_char(t.CSRQ,'YYYYMMDD') CSRQ FROM V_HJSP_QRRYXX t WHERE t.id=? and t.SLH = ?

参数有：SLH/ID1/ID2/ID3/ID4/N/ZQZMBH