📄 rstj.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%
/*************************************************************
*调用时需要参数isFirst：
1__从菜单直接调用;
0__页面中调用，查询数据，数据列表为只读；
2__查询数据为空时，刷新页面；
*针对修改状态,增加'updResulttable' 和 DIV 'Lupdate'；
*修改状态：只允许修改’利润调整‘ ， ’审批人员‘两个字段;
*需要传递的参数：机构编码
*调用保存页面时，传递是否基层营业机构的参数：NAME='ISJCYYJG'（类似于ACT）；
*/
%>
<%
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;
}
try
{
java.lang.String sql="";
java.sql.ResultSet rs=null;
int checknum=0;
int i=0; //计数器
int iorder=0; //修改、删除列表中的序号列;
java.lang.String czydm=((java.lang.String)session.getValue("czydm")).trim();
java.lang.String isFirst=((java.lang.String)request.getParameter("isFirst")).trim();
java.lang.String baseJgbm=""; //操作员机构
java.lang.String strJgjb="";
java.lang.String czyJgbm=""; //操作员机构;
java.lang.String selectedJgbm=""; //选择的填报行
java.lang.String baseGzrq=""; //系统的工作日期
java.lang.String JcyyjgMc=""; //基层营业机构的名称
java.lang.String isTop="";
java.lang.String isJcyyjg="0"; //是否基层营业机构
java.lang.String strRqStart=""; //起始日期;
java.lang.String strRqEnd=""; //终止日期;
java.lang.String strZrzxbm=""; //责任中心编码；
java.lang.String strZrzxmc=""; //责任中心名称；
java.lang.String strCpbm=""; //产品编码；
java.lang.String strCpmc=""; //产品名称；
java.lang.String strRs=""; //人数;
java.lang.String resulttable=""; //显示结果集；
java.lang.String delResulttable=""; //删除结果集；
java.lang.String updResulttable=""; //更新结果集；
//查询出操作员所属的机构
sql="SELECT DBO.CZYZD.JGBM AS JGBM, DBO.JGZD.JGJB FROM DBO.CZYZD, DBO.JGZD WHERE DBO.CZYZD.CZYBM='"+czydm+"' AND JGZD.JGBM = CZYZD.JGBM";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
czyJgbm=(rs.getString("JGBM")).trim();
baseJgbm=czyJgbm;
}
else
{
rs.close();
rs=null;
java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系，您现在不属于任何机构或所属机构不唯一！");
throw exception;
}
rs.close();//释放资源
rs=null;
//********************************* 确定选择的机构 ****************************************
if(isFirst.equals("1")) //从菜单直接调用;
{
selectedJgbm=baseJgbm;
}
else if(isFirst.equals("0")) //选择下属机构;
{
//经过修改后，刷新页面时，要用到的机构参数;
selectedJgbm=((java.lang.String)request.getParameter("jgbmlist")).trim();
}
else //isFirst=='2'：回到上级机构;
{
selectedJgbm=((java.lang.String)request.getParameter("jgbmlist")).trim();
sql="SELECT DBO.JGZD.SJJGBM AS SJJGBM FROM DBO.JGZD WHERE DBO.JGZD.JGBM='" + selectedJgbm + "'";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
selectedJgbm=(rs.getString("SJJGBM")).trim();
}
else
{
java.sql.SQLException exception = new java.sql.SQLException("当前机构已经没有上级机构了！");
throw exception;
}
rs.close();//释放资源
rs=null;
}
//判断是否到了顶级;
if(baseJgbm.equals(selectedJgbm))
isTop="1"; //已经到了顶级;
else
isTop="0";
//****************根据所选择的机构， 从机构字典中获取基层营业机构的名称 **********************
sql="SELECT JGZD.JGMC AS JCYYJGMC FROM JGZD WHERE JGZD.JGBM = '" + selectedJgbm + "' AND substring(JGZD.JGJB,1,1) = '3'";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
JcyyjgMc=(rs.getString("JCYYJGMC")).trim();
isJcyyjg = "1"; //是基层营业机构
}
else
{
//不是基层营业机构
}
rs.close();//释放资源
rs=null;
//********************************* 从参数字典中获取参数 **********************************
sql="SELECT CSZD.CSZ AS GZRQ FROM CSZD WHERE CSZD.CSBM = 'DQGZR'";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
baseGzrq=(rs.getString("GZRQ")).trim();
}
else
{
rs.close();
rs=null;
java.sql.SQLException exception = new java.sql.SQLException("参数字典中的工作日期丢失！");
throw exception;
}
rs.close();//释放资源
rs=null;
//*********************************** 构造显示结果集 **********************************************
if(!isFirst.equals("9")) //暂时都执行结果查询;
{
if(isJcyyjg.equals("1")) //如果是基层营业机构
{
//下面查询出所选机构责任中心、产品对应的人数
sql="SELECT RSTJB.RQ, RSTJB.RS FROM RSTJB WHERE RSTJB.JGBM LIKE '" + selectedJgbm +"'";
rs=DbBean.sqlQuery(sql);
while(rs.next())
{
resulttable+="<TR>";
updResulttable+="<TR>";
delResulttable+="<TR>";
strRqStart=((java.lang.String)(rs.getString("RQ"))).trim(); //目前无用
strRs=((java.lang.String)(rs.getString("RS"))).trim();
//***************** 显示列表 *********************** JCYYJG(基层营业机构)
resulttable+="<TD align='center'><INPUT size='30' type='text' maxlength='50' name='OJCYYJGMC' value='" + JcyyjgMc + "' readonly></TD>";
resulttable+="<TD align='center'><INPUT size='8' type='text' maxlength='16' name='OJCYYJGRS' value='"+strRs+"' readonly></TD>";
//************************** 修改情况下的显示列表 ***********************
updResulttable+="<TD align='center'><INPUT type='checkbox' name='UJCYYJGCHECK' value='" + selectedJgbm + "'></TD>";
updResulttable+="<TD align='center'><INPUT size='30' type='text' maxlength='50' name='UJCYYJGJGMC' value='" + JcyyjgMc + "' readonly></TD>";
updResulttable+="<TD align='center'><INPUT size='8' type='text' maxlength='16' name='UJCYYJGRS' value='"+strRs+"' onkeypress=\"checkdecinput(this)\" onblur=\"checkdec(this,'14')\" ></TD>";
//删除情况下的显示列表////////////////////////////////////////////////////////
delResulttable+="<TD align='center'><INPUT type='checkbox' name='DJCYYJGCHECK' value='" + selectedJgbm + "'></TD>";
delResulttable+="<TD align='center'><INPUT size='30' type='text' maxlength='50' name='DJCYYJGJGMC' value='" + JcyyjgMc + "' readonly></TD>";
delResulttable+="<TD align='center'><INPUT size='8' type='text' maxlength='16' name='DJCYYJGRS' value='"+strRs+"' onkeypress=\"checkdecinput(this)\" onblur=\"checkdec(this,'14')\" ></TD>";
resulttable+="</TR>";
updResulttable+="</TR>";
delResulttable+="</TR>";
iorder++; //序号，供选择
checknum++; //选择的修改、删除个数;
}
}
else //基层行、二级和省行;
{
//下面查询出所选机构责任中心、产品对应的人数
//sql="SELECT RSTJB.ZRZXBM, ZRZXZD.ZRZXMC, RSTJB.CPBM, CPZD.CPMC, RSTJB.RQ, RSTJB.RS FROM RSTJB, ZRZXZD, CPZD WHERE RSTJB.JGBM LIKE '" + selectedJgbm +"' AND ZRZXZD.ZRZXBM = RSTJB.ZRZXBM AND CPZD.CPBM = RSTJB.CPBM ORDER BY RSTJB.ZRZXBM";
sql="SELECT RSTJB.ZRZXBM, ZRZXZD.ZRZXMC, RSTJB.CPBM, CPZD.CPMC, RSTJB.RQ, RSTJB.RS FROM RSTJB, ZRZXZD, CPZD WHERE (RSTJB.JGBM LIKE '" + selectedJgbm +"') AND (ZRZXZD.ZRZXBM = RSTJB.ZRZXBM) AND (CPZD.CPBM = RSTJB.CPBM) ORDER BY RSTJB.ZRZXBM";
rs=DbBean.sqlQuery(sql);
while(rs.next())
{
resulttable+="<TR>";
updResulttable+="<TR>";
delResulttable+="<TR>";
strZrzxbm=((java.lang.String)(rs.getString("ZRZXBM"))).trim();
strZrzxmc=((java.lang.String)(rs.getString("ZRZXMC"))).trim();
strCpbm=((java.lang.String)(rs.getString("CPBM"))).trim();
strCpmc=((java.lang.String)(rs.getString("CPMC"))).trim();
strRqStart=((java.lang.String)(rs.getString("RQ"))).trim(); //目前无用
strRs=((java.lang.String)(rs.getString("RS"))).trim();
//***************** 显示列表 ***********************
resulttable+="<TD><INPUT size='20' type='text' maxlength='50' name='OZRZXMC' value='"+strZrzxmc+"' readonly></TD>";
resulttable+="<TD><INPUT size='20' type='text' maxlength='50' name='OCPMC' value='"+strCpmc+"' readonly></TD>";
resulttable+="<TD><INPUT size='12' type='text' maxlength='16' name='ORS' value='"+strRs+"' readonly></TD>";
//************************** 修改情况下的显示列表 ***********************
updResulttable+="<TD align='right'><INPUT type='checkbox' name='UZRZXBMCHECK' value='" + iorder + "'></TD>";
updResulttable+="<TD><INPUT type='hidden' name='UZRZXBM' value='" + strZrzxbm + "'>";
updResulttable+="<INPUT size='20' type='text' maxlength='50' name='UZRZXMC' value='" + strZrzxmc + "' readonly></TD>";
updResulttable+="<TD><INPUT size='5' type='hidden' name='UCPBM' value='" + strCpbm + "'>";
updResulttable+="<INPUT size='20' type='text' maxlength='50' name='UCPMC' value='"+strCpmc+"' readonly></TD>";
updResulttable+="<TD><INPUT size='8' type='text' maxlength='16' name='URS' value='" + strRs + "' onkeypress=\"checkdecinput(this)\" onblur=\"checkdec(this,'14')\"></TD>";
//删除情况下的显示列表////////////////////////////////////////////////////////
delResulttable+="<TD align='right'><INPUT type='checkbox' name='DZRZXBMCHECK' value='" + iorder + "'></TD>";
delResulttable+="<TD><INPUT type='hidden' name='DZRZXBM' value='" + strZrzxbm + "'>";
delResulttable+="<INPUT size='20' type='text' maxlength='50' name='DZRZXMC' value='" + strZrzxmc + "' readonly></TD>";
delResulttable+="<TD><INPUT size='5' type='hidden' name='DCPBM' value='" + strCpbm + "'>";
delResulttable+="<INPUT size='20' type='text' maxlength='50' name='DCPMC' value='"+strCpmc+"' readonly></TD>";
delResulttable+="<TD><INPUT size='8' type='text' maxlength='16' name='DRS' value='" + strRs + "'></TD>";
resulttable+="</TR>";
updResulttable+="</TR>";
delResulttable+="</TR>";
iorder++; //序号，供选择
checknum++; //选择的修改、删除个数;
}
}
rs.close();//释放资源
rs=null;
}
else
{
resulttable+="<TR><TD></TD><TD></TD><TD></TD></TR>";
updResulttable+="<TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>"; delResulttable+="<TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>";
}
%>
<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<TITLE>人数统计</TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<SCRIPT language="JavaScript" src="/resources/check.js"></SCRIPT>
<SCRIPT language="JavaScript">
var actionurl="";
var checknum=<%=checknum%>;
function FindObj(doc, lId)
{
for (var i=0; i < doc.layers.length; i++)
{
var w_str = "doc.layers[i].document." + lId;
var obj;obj=new Array;
obj[lId] = eval(w_str);
if (!obj[lId]) obj[lId] = FindObj(doc.layers[i], lId);
if (obj[lId]) return obj[lId];
}
return null;
}
function ShowObj(lId)
{
var ob;ob=new Array;
var appVer=parseInt(navigator.appVersion);
var isNC=(document.layers && (appVer >= 4));
var isIE=(document.all && (appVer >= 4));
if (isNC)
{
w_str = "document." + lId;ob[lId] = eval(w_str);
if (!ob[lId]) ob[lId] = FindObj(document, lId);
if (ob[lId]) ob[lId].visibility = "show";
}
if (isIE)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -