📄 runmainlist.jsp
字号:
<%@ page import="com.doone.uurm.UserFactory,
com.doone.data.*,
com.doone.uurm.WebAuth,
com.doone.fj1w.fjmgr.statana.*,
com.doone.uurm.IOrgInfo"%>
<%@ page contentType="text/html; charset=GBK" %>
<%request.setCharacterEncoding("GBK");%>
<%String sPurvICode="NGB004001005";%>
<%
WebAuth auth = WebAuth.getInstance(request);
if ( ! auth.IsAuthed() ) {
out.write("<script language=\"javascript\">self.parent.location.replace(\"" + request.getContextPath() + "/view/login/login.jsp" + "\");</script>");
return;
}
else if ( ! auth.CheckPurv(sPurvICode) ) {
out.write("<script language=javascript src=\"../../common/script/RightForbidden.js\"></script>");
return;
}
String idvalue=request.getParameter("LOGID");
String pageStr=request.getParameter("pageNo");
int pageNo=0;
MonitorBean mb=new MonitorBean();
if(idvalue!=null){mb.delete("TL_RunMain","LOGID",idvalue);}
if(pageStr==null)pageNo=1;
else pageNo=Integer.parseInt(pageStr);
String sqlstr="select rownum num,LOGID,RUNNAME,"+
"STARTTIME,ENDTIME,TOTALRECNUM,UPDATERECNUM,INSERTRECNUM,"+
" SUCCRECNUM,ERRRECNUM,RESULTSTATE,CUSTDEFINEDESC,ERRCODE,"+
"INPARA,OUTPARA from tl_runmain";
DataTable dt=mb.getPageMsg(sqlstr,pageNo);
%>
<html>
<head>
<title>后台执行日志管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="../../common/style/main.css" rel="stylesheet" type="text/css" />
<link href="../../common/style/Sty01.css" rel="stylesheet" type="text/css" />
</head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function changePageNo(no)
{
window.open("RunMainList.jsp?pageNo=" + no,"_self");
}
function fn_onload() {
cltScript_Toolbar();
}
function cltScript_Toolbar() {
if ( self.parent != self ){
var pel = parent.document.all.tags("frame");
for ( i=0; i< pel.length; i++){
if ( pel(i).name == "main") {
divTop.style.width = pel(i).width;
divMain.style.width = pel(i).width;
divMain.style.height = pel(i).height - divTop.clientHeight;
}
}
}
}
//-->
</SCRIPT>
<body onload="fn_onload();">
<div onresize="cltScript_Toolbar();" style="width: 100%">
<div id="divTop" style="overflow: hidden">
<table id="ibtnPanel" style="font-size: 9pt; border-bottom: #efefef 1px outset" cellspacing="0"
cellpadding="0" width="100%" border="0">
<tr bgcolor="#efefef" height="33">
<td> </td>
</tr>
</table>
<jsp:include page="../../common/inc_top.jsp" >
<jsp:param name="purvCode" value="<%=sPurvICode%>"/>
</jsp:include>
</div>
<div id="divMain" style="overflow: auto">
<form method="post" action="../sysmgr/PostDel.jsp" target="_popup" name="frmHeaderList" onsubmit="return openPopup()">
<table style="font-size: 9pt; border-bottom: #efefef 1px outset" cellspacing="0"
cellpadding="0" width="100%" border="0" class="OuterTable">
<tr>
<td height="19" colspan="7" class="OuterHead">
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td nowrap="nowrap" style="text-align:left"> <p><span id="ItemTitle"><font face="webdings">8</font>后台执行日志管理</span></p></td>
<td align="right" nowrap> </td>
</tr>
</table></td>
</tr>
<tr class="OuterHead">
<td class="title_td" align="center" width="6%"><b>日志序号</b></td>
<td class="title_td" align="center" width="6%"><b>过程名称</b></td>
<td class="title_td" align="center" width="6%"><b>开始时间</b></td>
<td class="title_td" align="center" width="6%"><b>结束时间</b></td>
<td class="title_td" align="center" width="6%"><b>合计记录数</b></td>
<td class="title_td" align="center" width="6%"><b>更新记录数</b></td>
<td class="title_td" align="center" width="6%"><b>插入记录数</b></td>
<td class="title_td" align="center" width="6%"><b>成功记录数</b></td>
<td class="title_td" align="center" width="6%"><b>失败记录数</b></td>
<td class="title_td" align="center" width="6%"><b>返回状态</b></td>
<td class="title_td" align="center" width="18%"><b>自定义描述</b></td>
<td class="title_td" align="center" width="6%"><b>Oracle错误描述</b></td>
<td class="title_td" align="center" width="6%"><b>入参信息</b></td>
<td class="title_td" align="center" width="6%"><b>出参信息</b></td>
</tr>
<%
for(int i=0;i<dt.getRows().getCount();i++)
{
%>
<tr class="InnerMain" style="color: black">
<td class="body_td" align="left" width="6" nowrap><%=dt.getRow(i).getString("LOGID")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("RUNNAME")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("STARTTIME").substring(0,10)%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("ENDTIME").substring(0,10)%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("UPDATERECNUM")%></td>
<td class="body_td" align="left" width="6%" nowrap><%= dt.getRow(i).getString("TOTALRECNUM")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("INSERTRECNUM")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("SUCCRECNUM")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("ERRRECNUM")%>
</td>
<td class="body_td" align="left" width="6%" nowrap>
<%if(dt.getRow(i).getString("RESULTSTATE").equals("s")){out.print("成功");}else {out.print("失败");}%>
</td>
<td class="body_td" align="left" width="18%" nowrap><%=dt.getRow(i).getString("CUSTDEFINEDESC")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("ERRCODE")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("INPARA")%></td>
<td class="body_td" align="left" width="6%" nowrap><%=dt.getRow(i).getString("OUTPARA")%></td>
</tr>
<%
}
%>
</table>
<table cellpadding="0" cellspacing="0" border="0" width="100%" class="OuterTable">
<tr class="OuterFoot">
<td align="left" class="foot_td" nowrap width="20%">
<%
out.print("本页共有"+dt.getRows().getCount()+"条记录！");
%>
</td>
<td align="right" class="foot_td" nowrap width="2%">
第 <%if(mb.getPageCount("TL_RunMain")==0 && pageNo==0){out.print("0");}if(pageNo==0){out.print("1");}else{out.print(pageNo);}%>
页/共<%= mb.getPageCount("TL_RunMain") %>页
</td>
</tr>
<tr class="OuterFoot">
<td align="left" class="foot_td" nowrap width="20%">
</td>
<td align="right" class="foot_td" nowrap width="6%">
<select name="pageList" onChange="changePageNo(this.value)">
<%out.print(mb.buildPageOptions(mb.getPageCount("TL_RunMain"),pageNo));%>
</select>
</td>
</tr>
</table>
</form>
</div>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -