📄 performance_list.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.ijipin.tool.*" %>
<%@ page import="com.ijipin.database.*" %>
<%@ page import="com.ijipin.property.*" %>
<%@ include file="/userinfor.jsp" %>
<%@ include file="/share/page/page_request.jsp"%>
<%@ page import="com.ijipin.oa.document.*" %>
<%@ page import="com.ijipin.flow.*" %>
<%
String strSWLB = "38";
////////////////////////////列表页面所必须有的公共变量
final String strSkin = "../../" + userInfor_session.getPFLJ(); //皮肤路径
final String strLevel = Draft.strLevel; //本页所在的层次
final String strLink = "performance_list.jsp" ; //本页的地址
int iModuleID = Draft.iModuleID;
//查询条件,在包含页面中使用
String str_search[][] = {
{"WZBT","公文标题"},
{"BLKS","办理开始时间"},
{"BLJS","办理结束时间"},
{"BLRYXM","办理人员"}
};
int i_search = 4;
int iCurrentPage = 1;
int iRecordCount = 0;
int iPageCount = 0;
int i=0;
PageInfor pageInfor = null;
//设置查询参数
String sTable = "";
String sField = "";
String sCond = "";
String sSortField = "" ;
int iOrder = 0;
//新建一个连接
DataConn dataConn = new DataConn();
Statement stmt = null;
ResultSet rs = null;
DataList dataList = null;
DataConn dataConn_read = null; //需要判断是否有“新”标志才需要
if (dataConn_read == null) {
dataConn_read = new DataConn();
}
Transact transact = new Transact(dataConn_read);
iModuleID = 71;
%>
<head>
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
<META HTTP-EQUIV="Expires" CONTENT="0">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=Message.COMPANY_NAME%></title>
<link href="<%=strSkin%>css.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<%@ include file="/share/page/bar_top.jsp"%>
<%
try {
stmt = dataConn.getConnection().createStatement();
dataList = new DataList(stmt);
//获取本模块信息
Module module = new Module(dataConn);
moduleInfor_session = (ModuleInfor)module.getInfor(iModuleID);
//如果需要管理员可以看，而又不是管理人员
if (1 == moduleInfor_session.getSXGLBJ() && !isManager) {
out.println("<Script language='JavaScript'>");
out.println("alert('您不是管理人员，不能访问本页面');");
out.println("document.location.href='" + strLevel + "logout.jsp'");
out.println("</Script>");
return ;
}
//关联表及其他关联信息
String relateTable = "";
String relateField = "";
String relateValue = "0";
String relateName = "";
String relateCond = " and 1=1 ";
iModuleID = Draft.iModuleID;
%>
<%
/////////本页数据获取
//查询条件
sCond = " 1= 1";
if (!searchKey.equalsIgnoreCase("")){
sCond = searchField + " like '%" + searchKey + "%'";
}
//分页
try {
iCurrentPage = Integer.parseInt(strPage);
}
catch(Exception e) {}
//排序条件
sSortField = "BLID";
if (!sortField.equals("")) {
sSortField = sortField;
}
if (sortOrder.equals("")) {
iOrder = 1;
}
else {
iOrder = 1 - Integer.parseInt(sortOrder);
}
//组合查询条件
////////////必须和办理表关联查询
sTable = "OA_FWWZ,LC_BL";
sField = "WZID,WZBT,BLID,BLKS,BLJS,BLZT,BLSM,BLRYXM";
sCond += " and 1=1 AND BLXXID=WZID AND SWLB='" + strSWLB + "' AND BLGRZT>0";
int iBLID = 0;
String sBLKS = "";
String sBLJS = "";
int iBLZT = 0;
String sBLSM = "";
ConvertDate convertDate = new ConvertDate();
int iDays = 0;
String sDays = "";
String strState = "";
String sBLRYXM = "";
rs = dataList.getResultSet(sTable, sField, sCond, sSortField, iOrder, iCurrentPage);
//分页信息
pageInfor = dataList.getPageInfor();
iRecordCount = pageInfor.getRecordCount();
iPageCount = pageInfor.getPageCount();
iCurrentPage = pageInfor.getCurrentPage();
String selectField = "";
String selectValue = "";
String str_value = "";
%>
<!-- 列表工具条上 2004-04-28 -->
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr class="toptr2">
<td>
<table width="100%" border=0 cellpadding=3 cellspacing=0 class="msglistcntrl" id="msglistcntrl">
<form name="form1" action="<%=strLink%>" method="post">
<tr>
<td nowrap><%@ include file="/share/page/page_search.jsp"%></td>
<td align="right" nowrap><%@ include file="/share/page/page_top.jsp"%></td>
</tr>
</form>
</table>
</td>
</tr>
</table>
<!-- 列表数据区 2004-04-28 -->
<!-- 列表数据区 2004-04-28
/share/page/page_hidden.jsp 放分页，查询等hidden
selectField，selectValue 放列表查询的值，主要是针对按栏目分类
-->
<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor="#D4D0C8">
<form name="formList" method="post" action="<%=strLink%>">
<tr class="toptr">
<%@include file="/share/page/page_hidden.jsp"%>
<input type="hidden" value="<%=selectField%>" name="<%=selectValue%>">
<td width="120">
<a href="javaScript:goFormUrl(formList,'<%=strLink%>?sortOrder=<%=iOrder%>&sortField=WZBT')">公文标题
<% if (iOrder ==1 && sSortField.equals("WZBT")) {%><img src="<%=strSkin%>common/order_down.gif" border="0">
<%} else if (iOrder ==0 && sSortField.equals("WZBT")) { %><img src="<%=strSkin%>common/order_up.gif" border="0"><%}%>
</a>
</td>
<td width="120">
<a href="javaScript:goFormUrl(formList,'<%=strLink%>?sortOrder=<%=iOrder%>&sortField=BLRYXM')">办理人员
<% if (iOrder ==1 && sSortField.equals("BLRYXM")) {%><img src="<%=strSkin%>common/order_down.gif" border="0">
<%} else if (iOrder ==0 && sSortField.equals("BLRYXM")) { %><img src="<%=strSkin%>common/order_up.gif" border="0"><%}%>
</a>
</td>
<td width="120">
<a href="javaScript:goFormUrl(formList,'<%=strLink%>?sortOrder=<%=iOrder%>&sortField=BLKS')">接收日期
<% if (iOrder ==1 && sSortField.equals("BLKS")) {%><img src="<%=strSkin%>common/order_down.gif" border="0">
<%} else if (iOrder ==0 && sSortField.equals("BLKS")) { %><img src="<%=strSkin%>common/order_up.gif" border="0"><%}%>
</a>
</td>
<td width="120">
<a href="javaScript:goFormUrl(formList,'<%=strLink%>?sortOrder=<%=iOrder%>&sortField=BLJS')">办理日期
<% if (iOrder ==1 && sSortField.equals("BLJS")) {%><img src="<%=strSkin%>common/order_down.gif" border="0">
<%} else if (iOrder ==0 && sSortField.equals("BLJS")) { %><img src="<%=strSkin%>common/order_up.gif" border="0"><%}%>
</a>
</td>
<td width="60">时间计算</td>
<td width="45">状态</td>
<td width="30"><p align="center">操作</td>
</tr>
<!--值-->
<%
i = 0;
String key_value = "";
String sWZBT = "";
while (rs != null && rs.next()) {
%>
<tr class="toptr3" onMouseOver="javascript:this.style.background= '#ECF2FC'" onMouseOut="javascript:this.style.background = '#FFFFFF'">
<%
//WZID,WZBT,BLID,BLKS,BLJS,BLZT,BLSM,BLRYXM
key_value = String.valueOf(rs.getInt("WZID"));
sWZBT = Convert.uploadUnicode(rs.getString("WZBT"));
iBLID = rs.getInt("BLID");
sBLKS = Convert.uploadUnicode(rs.getString("BLKS"));
sBLJS = Convert.uploadUnicode(rs.getString("BLJS"));
iBLZT = rs.getInt("BLZT");
sBLSM = Convert.uploadUnicode(rs.getString("BLSM"));
sBLRYXM = Convert.uploadUnicode(rs.getString("BLRYXM"));
strState = transact.getStateName(iBLZT);
//天数
sDays = "----";
if (!sBLJS.equals("")) {
sDays = String.valueOf(convertDate.interval(convertDate.stringToDate(sBLKS),convertDate.stringToDate(sBLJS))) + "天";
}
%>
<td><%=sWZBT%> </td>
<td><%=sBLRYXM%> </td>
<td><%=sBLKS%> </td>
<td><%=sBLJS%> </td>
<td><%=sDays%> </td>
<td width="45"><%=strState%> </td>
<!--按纽-->
<td width="30"><a href="javascript:FunView(<%=iBLID%>,<%=key_value%>);">查看</a>
</td>
</tr>
<%
i++;
}
%>
<% if (0==i) { %>
<tr class="toptr3"><td colspan="20" align="center">没有任何数据！ </td></tr>
<% } %>
</form>
</table>
<!-- 列表工具条下 2004-04-28 -->
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr class="toptr2">
<td>
<table width="100%" border=0 cellpadding=3 cellspacing=0 class="msglistcntrl" id="msglistcntrl">
<form name="form2" action="<%=strLink%>" method="post">
<tr>
<td nowrap><%@ include file="/share/page/page_search.jsp"%></td>
<td align="right" nowrap><%@ include file="/share/page/page_bottom.jsp"%></td>
</tr>
</form>
</table>
</td>
</tr>
</table>
<script language="javascript">
//查看窗口
function FunView(BLID, WZID) {
var ww=window.screen.availwidth-120;
var hh=window.screen.availheight-120;
var url = "http://<%=strServer_session%>:<%=strPort_session%><%=rootPath_session%>/oa/document/transact/transact_detail.jsp?WZID="+WZID+"&BLID="+BLID;
viewWin = window.open(url ,"","left=50,top=50,scrollbars=yes,resizable=yes,status=no,full=yes,width="+ww+",height="+hh);
}
</script>
<%
}
catch(Exception e) {
System.out.println("异常="+e);
}
finally {
if (stmt != null) {
stmt.close();
}
if (dataConn != null) {
dataConn.close();
}
if (dataConn_read != null) {
dataConn_read.close();
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -