📄 sgxxlrmain.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.lang.String sql="";
/*************************************************************
*公共参数
*************************************************************/
java.lang.String czydm="";//操作员编码
java.lang.String type="";//报表类型标志
java.lang.String dqgzr="";//当前工作日
java.lang.String title="";//标题
java.lang.String bbbm="";//报表编码
java.lang.String text1="";
java.lang.String bangzhu="";
java.lang.String ACT="";
int iACT=0;
int checkNum=0;
java.lang.String strLrbm="";
java.lang.String strLrmc="";
java.lang.String strCd="";
java.lang.String strLrbz="";
java.lang.String strXh="";
java.lang.String strMc="";
java.lang.String isFirst="";
int iType=0;
int temp=0;
java.lang.String itemNum="";
java.lang.String tbh="";//填报行
java.lang.String rq="";
java.lang.String dh="";//代号
java.lang.String initXh="";
int i=0;//计数器
int j=0;
java.lang.String selectedJgbm="";
java.lang.String baseJgbm="";
java.lang.String czyJgbm="";
java.lang.String isTop="";
java.sql.ResultSet rs=null;
java.sql.ResultSet rs2=null;
java.lang.String schResulttable="";
java.lang.String chaResulttable="";
java.lang.String delResulttable="";
java.lang.String addResulttable="";
java.lang.String detailSchResulttable="";
java.lang.String detailUpdResulttable="";
java.lang.String detailDelResulttable="";
java.lang.String[] initStatus={"","","disabled","","","hidden","hidden","hidden","hidden","visible","hidden","visible","hidden","hidden"};
java.lang.String bDay="1990/12/12";
java.lang.String eDay="2003/12/12";
java.lang.String[] dataDestination={"M1","M2","M3","M4","M5","M6","M7","M8","M9","M10","M11","M12","M13","M14","M15"};
java.lang.String[] dataSource={"CM1XH","CM2XH","CM3XH","CM4XH","CM5XH","CM6XH","CM7XH","CM8XH","CM9XH","CM10XH","CM11XH","CM12XH","CM13XH","CM14XH","CM15XH"};
java.lang.String[] dataWarehouse={"0","0","0","0","0","0","0","0","0","0","0","0","0","0","0"};
try
{
isFirst=((java.lang.String)request.getParameter("isFirst")).trim();
czydm=((java.lang.String)session.getValue("czydm")).trim();
if(isFirst==null)
{
java.sql.SQLException exception = new java.sql.SQLException("错误调用，请与系统维护员联系！");
throw exception;
}
if(czydm==null)
{
java.sql.SQLException exception = new java.sql.SQLException("服务已经重启或您闲置的时间太长，请重新登入！");
throw exception;
}
if(isFirst.equals("1"))
{
//查询出操作员所属的机构
sql="SELECT DBO.CZYZD.JGBM AS JGBM FROM DBO.CZYZD WHERE DBO.CZYZD.CZYBM='"+czydm+"'";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
i=1;
czyJgbm=(rs.getString("JGBM")).trim();
}
else
{
rs.close();
rs=null;
java.sql.SQLException exception = new java.sql.SQLException("您现在不属于任何机构或所属于机构不唯一，请与系统维护员联系！");
throw exception;
}
rs.close();//释放资源
rs=null;
baseJgbm=czyJgbm;
selectedJgbm=baseJgbm;
type=((java.lang.String)request.getParameter("type")).trim();
iType=Integer.parseInt(type);
ACT="3";
iACT=3;
//取当前工作日期
sql="SELECT DBO.CSZD.CSZ AS CSZ FROM DBO.CSZD WHERE DBO.CSZD.CSBM='DQGZR'";
rs=DbBean.sqlQuery(sql);
i=0;
while(rs.next())
{
i++;
dqgzr=(rs.getString("CSZ")).trim();
}
rs.close();//释放资源
rs=null;
if(i!=1)
{
java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系，取当前工作日时出错！");
throw exception;
}
switch(iType)
{
case 1:
//柜员费用录入
title="柜员费用录入";
text1="柜员姓名";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.5.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
bbbm="204";
break;
case 2:
//
//责任中心年度计划
title="责任中心年度计划";
text1="责任中心名称";
bbbm="101";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.6.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
break;
case 3:
//客户投入产出分析
title="客户投入产出分析";
text1="客户名称";
bbbm="206";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.3.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
break;
case 4:
//
//客户经理业务指标
title="客户经理业务指标";
text1="客户经理姓名";
bbbm="402";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.4.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
break;
case 5:
//呆帐准备金支出
title="呆帐准备金支出";
text1="产品名称";
bbbm="300";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.10.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
break;
case 6:
//管理人员费用明细表
title="管理人员费用明细表";
text1="管理人员姓名";
bbbm="601";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.11.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
break;
default:
java.sql.SQLException exception = new java.sql.SQLException("调用错误！");
throw exception;
}
initStatus[0]="";
initStatus[1]="";
initStatus[2]="disabled";
initStatus[3]="";
initStatus[4]="";
initStatus[5]="hidden";
initStatus[6]="hidden";
initStatus[7]="hidden";
initStatus[8]="hidden";
initStatus[9]="visible";
initStatus[10]="hidden";
}
else
{
czyJgbm=((java.lang.String)request.getParameter("czyJgbm")).trim();
if(isFirst==null)
{
java.sql.SQLException exception = new java.sql.SQLException("错误调用，请与系统维护员联系！");
throw exception;
}
baseJgbm=czyJgbm;
selectedJgbm=((java.lang.String)request.getParameter("TBHLIST")).trim();
czydm=((java.lang.String)request.getParameter("czydm")).trim();
type =((java.lang.String)request.getParameter("type")).trim();
dqgzr=((java.lang.String)request.getParameter("dqgzr")).trim();
title=((java.lang.String)request.getParameter("title")).trim();
bbbm =((java.lang.String)request.getParameter("bbbm")).trim();
ACT =((java.lang.String)request.getParameter("ACT")).trim();
if((selectedJgbm==null)||(czydm==null)||(type==null)||(dqgzr==null)||(title==null)||(bbbm==null)||(ACT==null))
{
java.sql.SQLException exception = new java.sql.SQLException("错误调用，请与系统维护员联系！");
throw exception;
}
iACT=Integer.parseInt(ACT);
iType=Integer.parseInt(type);
switch(iType)
{
case 1:
//柜员费用录入
title="柜员费用录入";
text1="柜员姓名";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.5.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
bbbm="204";
break;
case 2:
//
//责任中心年度计划
title="责任中心年度计划";
text1="责任中心名称";
bbbm="101";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.6.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
break;
case 3:
//客户投入产出分析
title="客户投入产出分析";
text1="客户姓名";
bbbm="206";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.3.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
break;
case 4:
//客户经理业务指标
title="客户经理业务指标";
text1="客户经理姓名";
bbbm="402";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.4.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
break;
case 5:
//呆帐准备金支出
title="呆帐准备金支出";
text1="产品名称";
bbbm="300";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.10.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
break;
case 6:
//管理人员费用明细表
title="管理人员费用明细表";
text1="管理人员姓名";
bbbm="601";
bangzhu="<INPUT type='button' name='bangzhu' value='帮助' onClick=\"window.open('/help/2.4/2.4.11.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');\">";
break;
default:
java.sql.SQLException exception = new java.sql.SQLException("调用错误！");
throw exception;
}
switch(iACT)
{
case 1:
//查询列表,首先设置和定义本模块使用的一些变量
bDay=((java.lang.String)request.getParameter("bDay")).trim();
eDay=((java.lang.String)request.getParameter("eDay")).trim();
tbh=((java.lang.String)request.getParameter("TBHLIST")).trim();
//生成查询时的表格
sql=DbBean.getSql( iType, bbbm, bDay, eDay, tbh);
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
do
{
tbh=((java.lang.String)(rs.getString("TBH"))).trim();
rq=((java.lang.String)(rs.getString("RQ"))).trim();
dh=((java.lang.String)(rs.getString("DH"))).trim();
strMc=((java.lang.String)(rs.getString("XM"))).trim();
schResulttable+="<TR ondblclick=\"chakanClick('"+tbh+"','"+rq+"','"+dh+"')\"><TD>"+tbh+"</TD><TD>"+rq+"</TD><TD>"+strMc+"</TD></TR>";
}while(rs.next());
}
else
{
schResulttable+="<TR><TD></TD><TD></TD><TD></TD></TR>";
}
initStatus[0]="disabled";
initStatus[1]="";
initStatus[2]="";
initStatus[3]="";
initStatus[4]="disabled";
initStatus[5]="visible";
initStatus[6]="visible";
initStatus[7]="hidden";
initStatus[8]="hidden";
initStatus[9]="hidden";
break;
case 2:
//修改列表,首先设置和定义本模块使用的一些变量
bDay=((java.lang.String)request.getParameter("bDay")).trim();
eDay=((java.lang.String)request.getParameter("eDay")).trim();
tbh=((java.lang.String)request.getParameter("TBHLIST")).trim();
//生成修改时的表格
sql=DbBean.getSql( iType, bbbm, bDay, eDay, tbh);
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
do
{
tbh=((java.lang.String)(rs.getString("TBH"))).trim();
rq=((java.lang.String)(rs.getString("RQ"))).trim();
dh=((java.lang.String)(rs.getString("DH"))).trim();
strMc=((java.lang.String)(rs.getString("XM"))).trim();
chaResulttable+="<TR ondblclick=\"xiugaiClick('"+tbh+"','"+rq+"','"+dh+"')\"><TD>"+tbh+"</TD><TD>"+rq+"</TD><TD>"+strMc+"</TD></TR>";
}while(rs.next());
}
else
{
chaResulttable+="<TR><TD></TD><TD></TD><TD></TD></TR>";
}
initStatus[0]="";
initStatus[1]="disabled";
initStatus[2]="";
initStatus[3]="";
initStatus[4]="disabled";
initStatus[5]="visible";
initStatus[6]="hidden";
initStatus[7]="visible";
initStatus[8]="hidden";
initStatus[9]="hidden";
break;
case 3:
//新增保存,首先设置和定义本模块使用的一些变量
tbh=((java.lang.String)request.getParameter("NTBH")).trim();
dh=((java.lang.String)request.getParameter("NDH")).trim();
checkNum=0;
i=0;
j=0;
for(i=0;i<15;i++)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -