📄 result.jsp

📁 管理公司合同
💻 JSP
字号:
<%@ page contentType = "text/html;charset=GBK"%>
<%@ taglib uri="/WEB-INF/displaytag-11.tld" prefix="display" %>
<%@ page import="java.util.List,
				java.util.ArrayList,
				java.util.Map,
				java.sql.Timestamp"%>
<%@ page import="cn.com.juneng.system.vo.QueryHeaderVOImpl" %>
<%@ page import="cn.com.juneng.system.common.COMMON" %>
<html>
<head>
<link href="<%=request.getContextPath()%>/css/commonPage.css" rel="stylesheet" type="text/css">
<link rel='stylesheet' href='<%=request.getContextPath()%>/css/tablesort.css' type='text/css'>
<script type='text/javascript' language='JavaScript' src='<%=request.getContextPath()%>/js/tablesort1.js'></script>

<meta http-equiv="Expires" content="-1" />
<meta http-equiv="Pragma" content="no-cache" />
<meta http-equiv="Cache-Control" content="no-cache" />
<meta http-equiv="content-type" content="text/html; charset=GBK" />
<%
String path = "/system/query/QueryAction.jsp";
%>
<script>
	function file(type){
		if(type!=""){
			location.href = "<%=request.getContextPath()%>/downLoad?ClassName="+type;
		}
	}
	
	function toFile(file){
	   window.oldOnError = window.onerror;
	   window.onerror = function (err)
	   {
	   if (err.indexOf('utomation') != -1)
	   {
	      alert('用户禁止了 WScript.Shell 的使用，请进行安全设置'); 
	     return true;
	   }
	     else 
	       return false;
	   };
		
		var range = document.body.createControlRange() 
		range.add(document.getElementById("table1"));	
		range.execCommand('Copy');

		//WshShell
		var wsh = new ActiveXObject('WScript.Shell');
		//wsh.Run("wscript E:\\html-js\\网页特效\\好东西\\html到EXCEL打印\\edit.js",1,true);//同步执行
		wsh.Run(""+file,1,false);//同步执行
		Pause(this,1000);//调用暂停函数
		 this.NextStep=function(){
			wsh.SendKeys("^v");
			//wsh.SendKeys("^s"); 
		 }
	}
function Pause(obj,iMinSecond){
	 if (window.eventList==null) window.eventList=new Array();
	 var ind=-1;
	 for (var i=0;i<window.eventList.length;i++){
	  if (window.eventList[i]==null) {
	   window.eventList[i]=obj;
	   ind=i;
	   break;
	  }
 	}
 
 if (ind==-1){
  ind=window.eventList.length;
  window.eventList[ind]=obj;
 }
 setTimeout("GoOn(" + ind + ")",iMinSecond);
}
/*
该函数把要暂停的函数放到数组window.eventList里，同时通过setTimeout来调用继续函数。

继续函数如下：
*/

function GoOn(ind){
 var obj=window.eventList[ind];
 window.eventList[ind]=null;
 if (obj.NextStep) obj.NextStep();
 else obj();
}

	function gather(obj,type){
		var table = document.all.table1;
		var tr = document.getElementById("gather");
		if(tr==null||tr=="undefined"){
			//创建
			tr = table.insertRow(table.rows.length);
			tr.style.backgroundColor = "#FFFFCC";
			tr.id = "gather";
			var cellLength = table.rows[0].cells.length;
			for(var i=0;i<cellLength;i++){
				cell=tr.insertCell(i);
				if(i==0){
					cell.innerHTML="汇总";	
				}else{
					cell.innerHTML="<span style='display:none'>.</span>";	
				}
			}
		}
		if(obj.type=="String"){
			tr.cells[obj.id].innerHTML = "--";
		}else{
			//开始汇总
			rows = table.rows;
			var gather = 0.0;
			var average = 0.0;
			for(var i=1;i<rows.length-1;i++){
				gather += 1.0*(rows(i).cells[obj.id].innerHTML);
			}
			gather = Math.round(gather*100.0)/100;
			if(type=="sum"){
				tr.cells[obj.id].innerHTML = "SUM:"+gather;
			}else if(type=="avg"){
				average = gather/(rows.length-2);	
				average = Math.round(average*100.0)/100;
				tr.cells[obj.id].innerHTML = "AVG:"+average;
			}
		}
		window.scrollTo(tr.offsetLeft,tr.offsetTop+tr.offsetParent.offsetTop-22);
	}
	
	var toHref = "";
	function changeContent(paramName,paramValue){
		toHref = "";
		getUrl(paramName,paramValue);
		//set IsQuery
		if(toHref.indexOf("IsQuery")==-1){
			toHref += "&IsQuery=false";
		}
		location.href = toHref;
	}
	function getUrl(paramName,paramValue){
		var url = "<%=request.getContextPath()+path%>";
		var qString = "<%=request.getQueryString()%>";
		if(qString=="null"){
			toHref = url+"?"+paramName+"="+paramValue;
		}else{
			if(qString.indexOf(paramName)==-1){
				toHref = url+"?"+qString+"&"+paramName+"="+paramValue;
			}else{
				var index1 = qString.indexOf(paramName+"=");
				var index2 = qString.indexOf("&",index1)
				qStr = qString.substring(0,index1);
				toHref = url+"?"+qStr+paramName+"="+paramValue;	
				if(index2!=-1){
					toHref += qString.substring(index2); 
				}
			}
		}
	}
</script>

<script>
var isDraging=false;
var ox,oy;
var index;
var target;
function fnDown(){
	isDraging=true;
	ox=event.offsetX;
	oy=event.offsetY;
	document.getElementById(index).setCapture();
}
function fnMove(id){
	index = id;
	target = index-1;
	if(target==-1){
		target = 1;
	}
	if(event.button!=1)
		fnRelease();
	if(isDraging){
		var th = event.x - document.getElementById(target).offsetLeft - ox;
		if(th<1) th=1;
		document.getElementById(target).width=th;
	}
}
function fnUp(){
	fnRelease();
}
function fnRelease(){
	isDraging=false;
	document.getElementById(index).style.cursor="";
	document.getElementById(index).releaseCapture();
}
</script>
</head>
<jsp:include page="menu.jsp" /> 
<%
	String lClass = "its";
	if( request.getParameter( "class" ) != null ) {
		lClass = request.getParameter( "class" );
		if (!("isis".equals(lClass) || "its".equals(lClass) || "mars".equals(lClass) || "simple".equals(lClass) || "report".equals(lClass) || "mark".equals(lClass)))
		{
			lClass="";
		}
	}
	
	int pagesize = 20;
	if(request.getParameter("pagesize")!=null){
		pagesize = Integer.parseInt(request.getParameter("pagesize"));
	}
	
	List list = (List)request.getAttribute("List");
	List header = (List)list.get(0);
	List item = (ArrayList)(((ArrayList)list).clone());
	item.remove(0);
	QueryHeaderVOImpl query = (QueryHeaderVOImpl)request.getAttribute("Query");
	String linkColumn = query.getLinkColumn()==null?"":query.getLinkColumn();
	
	List typeList = (List)request.getAttribute("TypeList");
	
	request.setAttribute( "result",item);
	String pageAtt = "pagesize=\""+pagesize+"\"";
%>
<!-- 
<body ondblclick="document.getElementById('download').disabled=false;this.style.cursor=''">	
-->
<body >	
<div>
    <table class="tableClass" >
        <tr>
            <td> <strong>当前页面：查询统计 &gt;&gt;<%=query.getQueryName()%></strong>
			<select name="class" onchange="changeContent('class',this.value)">
			<option value="its" <%=lClass.equals("its")?"selected":""%>>its</option>
			<option value="isis" <%=lClass.equals("isis")?"selected":""%>>isis</option>
			<option value="mars" <%=lClass.equals("mars")?"selected":""%>>mars</option>
			<option value="simple" <%=lClass.equals("simple")?"selected":""%>>simple</option>
			<option value="report" <%=lClass.equals("report")?"selected":""%>>report</option>
			<option value="mark" <%=lClass.equals("mark")?"selected":""%>>mark</option>
			</select>
			<select name="pagesize" onchange="changeContent('pagesize',this.value)">
			
			<option value="10" <%=pagesize==10?"selected":""%>>10</option>			 
			<option value="20" <%=pagesize==20?"selected":""%>>20</option>
			<option value="50" <%=pagesize==50?"selected":""%>>50</option>
			<option value="100" <%=pagesize==100?"selected":""%>>100</option>		
			<option value="0" <%=pagesize==0?"selected":""%>>所有</option>
			</select>总数/页
			</td>
			 
			<td align=right><div align='right'>			
			&nbsp;&nbsp;<input type="button" id="download" value="导出Excel" onclick="toFile('excel')">
			&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
			</div>
			</td>  
			<!-- 
			<input type="button" value="返回" onclick="location.href='<%=request.getContextPath()+path%>?Type=view&QueryIndex=<%=query.getQueryIndex()%>'">
			<input type="button" id="download" value="导出Word" onclick="toFile('winword')">
			&nbsp;<input type="button" value="打印" onclick="window.print();">
			-->
			
        </tr>
    </table>
</div>
<display:table name="result" pagesize="<%=pagesize%>" requestURI="<%=path+"?IsQuery=false"%>" attribute="onclick='sortColumn(event)'" class="<%=lClass%>" id="table1" export="false"> 
	<display:column title="序号" attribute="type='Number'"><%=table1_rowNum%></display:column>
<%
	String typeClass = "";
	String[] numberType = {"java.math.BigDecimal","java.lang.Integer","java.lang.Double","java.lang.Float"};
	String headerName = "";
	boolean link = false;
	String columnName = "";
	String columnValue = "";
	String temp;
	int startPos = 0;
	int endPos = 0;
	boolean check = false;
	String linkSrc = query.getLinkSrc()==null?"":query.getLinkSrc();
	while(linkSrc.indexOf("[")!=-1){
		startPos = linkSrc.indexOf("[");
		endPos = linkSrc.indexOf("]");
		temp = linkSrc.substring(startPos+1,endPos);
		
		check = false;
		for(int i=0;i<header.size();i++){
		
			headerName = (String)header.get(i);
			if(headerName.equals(temp)&&table1!=null){
				linkSrc = linkSrc.substring(0,startPos)+((List)table1).get(i)+linkSrc.substring(endPos+1);			
				check = true;
				break;
			}
		}
		if(!check){
			break;
		}
	}
	//header.clear();
	//header.add("姓名");
	for(int i=0;i<header.size();i++){
		typeClass = (String)typeList.get(i);
		columnName = (String)header.get(i);
		if(linkColumn.length()!=0&&columnName.equals("rid"))
		  continue;  
		if(linkColumn.length()!=0&&columnName.equals(linkColumn)){
			link = true;
%>
		<display:column title="<%=(String)header.get(i)%>" attribute="<%="type='"+(COMMON.arrayIndexOf(numberType,typeClass)!=-1?"Number":"String")+"' id='"+(i+1)+"' oncontextmenu='showObjects(this);return false;'"%>" nowrap="true" ><a onclick="javascript:window.open('<%=request.getContextPath()+"/"+linkSrc%>')"><%=((List)table1).get(i)%></a></display:column>
<%
		}else{
%>
		<display:column title="<%=(String)header.get(i)%>"
		attribute="<%="type='"+(COMMON.arrayIndexOf(numberType,typeClass)!=-1?"Number":"String")+"'  id='"+(i+1)+"' oncontextmenu='showObjects(this);return false;'"%>" nowrap="true"><%=((List)table1).get(i)%></display:column>		

<%		
		}
	}
	if(linkColumn.length()!=0&&!link){
%>
	<display:column title="链接" attribute="type='String'"><a href="<%=request.getContextPath()+"/"+linkSrc%>"><%=query.getLinkColumn()%></></display:column>
<%
	}	
%>
</display:table>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -