登 录
<div align="center" style="height: 2px"><br /> <jsfext:cb4Workflow value="打印入户通知书" accesskey="d"<br /> disabled="#{not SnyjDyModel.allowSh}" action="onCp"<br /> model="#{SnyjDyModel}" /></p> <p> <button id="dyzqz" accesskey="p" tabindex="-1" style="width: 120px"<br /> onclick="window.open('','newWin','top=20,left=20,height=500,width=1024,status=yes,toolbar=no,menubar=no,location=no');document.getElementById('openQrryPage').click()"><br /> 打印准迁证(p)<br /> </button><br /> </div><br /> <t:commandLink value="查看迁入人员信息" tabindex="-1" id="openQrryPage"<br /> target="newWin"<br /> style="font-size: 10pt; color: blue; text-decoration: none; display: none"<br /> action="#{SnyjDyModel.goToQrryPage}" forceId="true"><br /> <f:param value="SnyjDyModel" name="parentModel4Qrryxx" /><br /> </t:commandLink>
/**<br /> *<br /> * @跳转到打印页面<br /> * @return String<br /> */<br /> public String goToQrryPage() {<br /> return QRRY_OUTCOME;<br /> }</p> <p> /**<br /> * @保存准迁证号码，且只保存选中的人<br /> * @return<br /> */</p> <p> public String onSaveDyxx() {<br /> transactionTemplate.execute(new TransactionCallback() {<br /> public Object doInTransaction(TransactionStatus arg0) {<br /> String[] idArr = id.split(",");<br /> for (int j = 0; idArr != null && j < idArr.length; j++) {<br /> for (int i = 0; qrryxxList != null && i < qrryxxList.size(); i++) {<br /> Qrryxx temp = qrryxxList.get(i);<br /> if (temp.getId().equals(idArr[j])) {<br /> temp.setZqzmbh(zqzh);<br /> qrryxxDAO.attachDirty(temp);<br /> break;<br /> }<br /> }<br /> }<br /> return null;<br /> }<br /> });<br /> zqzh = "";// 清空准迁证号码<br /> return SELF_OUTCOME;<br /> }
// ´òÓ¡»§¼®ÉóÅúµÄ׼Ǩ֤<br /> function printHjspZqz(slh, id) {<br /> var zqzh=document.getElementById("zqzhm").value;</p> <p> if (slh != null && id != null) {<br /> window<br /> .open(<br /> "/gdrk/cn/hnisi/gdrk/reportFiles/hjgl/HjspZqz.jsp?slh="<br /> + slh + "&id=" + id+"&zqzh="+zqzh,<br /> "",<br /> "width=1024,height=500,top=100,left=100,toolbar=no,location=no,directories=no,menubar=no,scrollbars=yes,resizable=no,status=no");<br /> }<br /> return false;<br /> }<br />
<%@ page contentType="text/html;charset=GBK"%><br /> <%@ taglib uri="/WEB-INF/runqianReport4.tld" prefix="report"%><br /> <%@ page language="java"%></p> <p><html><br /> <title>准予迁入证明</title><br /> <body onmouseover="self.status='准予迁入证明';return true" topMargin=0<br /> rightMargin=0 bottomMargin=0><br /> <%<br /> String reportName = "hjgl/HjspZqz" + ".raq";<br /> String b = "SLH=" + request.getParameter("slh");<br /> String d="ZQZMBH="+request.getParameter("zqzh");<br /> String arrs[] = new String[4];<br /> arrs = request.getParameter("id").split(",");<br /> int n = arrs.length;<br /> String a = null;<br /> if (n == 0)<br /> a = "";<br /> else if (n == 1)<br /> a = "ID1=" + arrs[0];<br /> else if (n == 2)<br /> a = "ID1=" + arrs[0] + ";" + "ID2=" + arrs[1];<br /> else if (n == 3)<br /> a = "ID1=" + arrs[0] + ";" + "ID2=" + arrs[1] + ";" + "ID3="<br /> + arrs[2];<br /> else if (n == 4)<br /> a = "ID1=" + arrs[0] + ";" + "ID2=" + arrs[1] + ";" + "ID3="<br /> + arrs[2] + ";" + "ID4=" + arrs[3];<br /> String c = "N=" + n;<br /> String e = b + ";" + a + ";" + c+";"+d;<br /> %><br /> <div align="center"<br /> style="border: 0 solid #91A7B4; overflow-x: auto; overflow-y: auto; height: 100%; width: 100%"><br /> <table width="100%" height="800"><br /> <tr><br /> <td valign="top" align="center"><br /> <report:html name="report1" reportFileName="<%=reportName%>"<br /> params="<%=e%>" funcBarLocation="boTh" needPageMark="yes"<br /> functionBarColor="#fff5ee" funcBarFontSize="10pt"<br /> funcBarFontColor="blue" separator=" "<br /> needSaveAsExcel="yes" needSaveAsPdf="yes" needPrint="yes"<br /> pageMarkLabel="页号{currpage}/{totalPage}" printLabel="打印"<br /> displayNoLinkPageMark="yes" saveAsName="准予迁入证明" /><br /> </td><br /> </tr><br /> </table><br /> </div><br /> </body><br /> </html>
数据集DS_PRINT_QRSP_ZQZ
SELECT t1.SLH,<br /> t1.ZQYY,<br /> t1.BZ,<br /> t1.CBR,<br /> t1.DZ,<br /> t1.FWDW,<br /> t1.GMSFHM,<br /> t1.HKDJJG,<br /> t1.PZJG,<br /> t1.QCDXZ,<br /> t1.SQRXM FROM<br /> V_HJSP_PRINT_QRSP_ZQZ t1</p> <p>WHERE ( 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<br /> WHERE t.id=? and t.SLH = ?
数据集DS_QRRYXX2
数据集DS_QRRYXX3
数据集DS_QRRYXX4
参数有：SLH/ID1/ID2/ID3/ID4/N/ZQZMBH
抱歉!评论已关闭.