📄 popup_o618.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%
/*************************************************************
*类型说明：手工信息录入主页面
*************************************************************/
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<%@page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<%
if((session.getValueNames()).length==0)
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/sysmang/loginagain.html';");
out.println("</SCRIPT>");
return;
}
java.sql.ResultSet sqlRst;//结果集对象
String ErrStr,sqlStr="";
String strBm,strXm;
java.lang.String type="";//报表类型标志
java.lang.String title="";//标题
java.lang.String text1="";
java.lang.String text2="";
java.lang.String bbbm="";
java.lang.String jgbm="";
java.lang.String zrzxmc="";
java.lang.String zrzxmc_bak="";
int iType=0;
try
{
jgbm=request.getParameter("NTBH").trim();
type=((java.lang.String)request.getParameter("type")).trim();
iType=Integer.parseInt(type);
switch(iType)
{
case 1:
//柜员费用录入
title="柜员查询";
text1="所属机构";
text2="柜员姓名";
sqlStr="SELECT DBO.RYZD.RYBM AS BM,DBO.RYZD.RYXM AS XM, DBO.JGZD.JGMC AS MC FROM DBO.RYZD,DBO.JGZD WHERE (DBO.RYZD.JGBM=DBO.JGZD.JGBM) AND (DBO.RYZD.RYBZ LIKE '4%') AND (DBO.JGZD.JGBM='"+jgbm+"' OR DBO.JGZD.SJJGBM='"+jgbm+"') ORDER BY DBO.JGZD.JGBM";
bbbm="204";
break;
case 2:
//责任中心年度计划
title="责任中心查询";
text1="责任中心编码";
text2="责任中心名称";
sqlStr="SELECT DBO.ZRZXZD.ZRZXBM AS BM,DBO.ZRZXZD.ZRZXMC AS XM FROM DBO.ZRZXZD";
bbbm="101";
break;
case 3:
//客户投入产出分析
title="客户查询";
text1="客户编码";
text2="客户名称";
sqlStr="SELECT DBO.KHXXZD.KHBM AS BM,DBO.KHXXZD.KHMC AS XM FROM DBO.KHXXZD WHERE DBO.KHXXZD.JGBM='"+jgbm+"'";
bbbm="206";
break;
case 4:
//客户经理业务指标
title="客户经理查询";
text1="客户经理编码";
text2="客户经理姓名";
sqlStr="SELECT DBO.RYZD.RYBM AS BM,DBO.RYZD.RYXM AS XM FROM DBO.RYZD WHERE DBO.RYZD.JGBM='"+jgbm+"' AND DBO.RYZD.RYBZ LIKE '3%'";
bbbm="402";
break;
case 5:
//呆帐准备金支出
title="产品查询";
text1="所属责任中心";
text2="产品名称";
sqlStr="SELECT DBO.CPZD.CPBM AS BM,DBO.CPZD.CPMC AS XM,DBO.ZRZXZD.ZRZXMC AS MC FROM DBO.CPZD,DBO.ZRZXZD WHERE (DBO.ZRZXZD.ZRZXBM=DBO.CPZD.ZRZXBM)";
bbbm="402";
break;
case 6:
//管理人员费用明细表
title="管理人员查询";
text1="管理人员编码";
text2="管理人员姓名";
sqlStr="SELECT DBO.RYZD.RYBM AS BM,DBO.RYZD.RYXM AS XM FROM DBO.RYZD WHERE DBO.RYZD.JGBM='"+jgbm+"' AND DBO.RYZD.RYBZ LIKE '1%'";
bbbm="601";
break;
default:
java.sql.SQLException exception = new java.sql.SQLException("调用错误！");
throw exception;
}
sqlRst =DbBean.sqlQuery(sqlStr);
%>
<HTML>
<HEAD>
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<META http-equiv="Content-Style-Type" content="text/css">
<TITLE><%=title%></TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<SCRIPT language="JavaScript">
function setSelect(strdh,strdhmc)
{
with(opener.document.czform)
{
NDH.value = strdh;
NDHMC.value = strdhmc;
subbtn.disabled=false;
}
window.close();
}
</SCRIPT>
</HEAD>
<BODY bgcolor="#FFFFFF" >
<TABLE border="0" width="504">
<TBODY >
<%
if(iType==1)
{//如果是查询柜员
%>
<TR>
<TH width="81"><%=text1%></TH>
<TH width="217"><%=text2%></TH>
</TR>
<%
while(sqlRst.next())
{
strBm = sqlRst.getString("BM").trim();
strXm = sqlRst.getString("XM").trim();
zrzxmc = sqlRst.getString("MC").trim();
%>
<TR onclick="setSelect('<%=strBm %>','<%=strXm %>')">
<%
if(zrzxmc.equals(zrzxmc_bak))
{
%>
<TD style="cursor : pointer;" ></TD>
<%
}
else
{
%>
<TD style="cursor : pointer;" ><%=zrzxmc%></TD>
<%
}
%>
<TD style="cursor : pointer;"><%=strXm%></TD>
</TR>
<%
zrzxmc_bak=zrzxmc;
}
}
else if(iType==5)
{//如果是查询产品
%>
<TR>
<TH width="81"><%=text1%></TH>
<TH width="217"><%=text2%></TH>
</TR>
<%
while(sqlRst.next())
{
strBm = sqlRst.getString("BM").trim();
strXm = sqlRst.getString("XM").trim();
zrzxmc = sqlRst.getString("MC").trim();
%>
<TR onclick="setSelect('<%=strBm %>','<%=strXm %>')">
<%
if(zrzxmc.equals(zrzxmc_bak))
{
%>
<TD style="cursor : pointer;" ></TD>
<%
}
else
{
%>
<TD style="cursor : pointer;" ><%=zrzxmc%></TD>
<%
}
%>
<TD style="cursor : pointer;"><%=strXm%></TD>
</TR>
<%
zrzxmc_bak=zrzxmc;
}
}
else
{
%>
<TR>
<TH width="81"><%=text1%></TH>
<TH width="117"><%=text2%></TH>
</TR>
<%
while(sqlRst.next())
{
strBm = sqlRst.getString("BM").trim();
strXm = sqlRst.getString("XM").trim();
%>
<TR onclick="setSelect('<%=strBm %>','<%=strXm %>')">
<TD style="cursor : pointer;"><%=strBm%></TD>
<TD style="cursor : pointer;"><%=strXm%></TD>
</TR>
<%
}
}
%>
</TBODY>
</TABLE>
</BODY>
</HTML>
<%
sqlRst.close();
sqlRst=null;
%>
<%
System.gc();
} catch( Throwable e) {
DbBean.clear();
if(((e.getMessage())).equals("ResultSet is closed"))
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/blank.html';");
out.println("</SCRIPT>");
}
else if(e.getMessage()==null)
{
out.println("服务已经重启，您闲置的时间太长或系统调用错误，请重新登入试一下！<br>如果再出现这种情况请与系统维护员联系！");
}
else out.println(e.getMessage());
System.gc();
return;
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -