📄 sgxxlrmain_0616.jsp
字号:
throw exception;
}
rs.close();//释放资源
rs=null;
}
//生成修改时的详细表格
detailUpdResulttable=DbBean.getTable( bbbm, contentTemp2, dataDestination, rq, tbh, dh);
//out.println(DbBean.AlertMsg("成功生成查看页面！"));
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]="hidden";
initStatus[10]="hidden";
initStatus[11]="hidden";
initStatus[12]="visible";
initStatus[13]="hidden";
break;
case 8:
//生成详细删除页面,首先设置和定义本模块使用的一些变量
for(i=0;i<15;i++)
{
dataSource[i]="DM"+java.lang.String.valueOf(i+1)+"XH";
dataWarehouse[i]="0";
}
tbh=((java.lang.String)request.getParameter("TBH")).trim();
rq=((java.lang.String)request.getParameter("RQ")).trim();
dh=((java.lang.String)request.getParameter("DH")).trim();
checkNum=0;
i=0;
j=0;
sql="SELECT MAX(XH) AS AA FROM BBLRLXDY WHERE DBO.BBLRLXDY.BBBM='"+bbbm+"'";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
checkNum=Integer.parseInt(((java.lang.String)(rs.getString("AA"))).trim());
rs.close();//释放资源
rs=null;
}
else
{
rs.close();//释放资源
rs=null;
java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系，取当前报表需要手工录入的项数时出错！");
throw exception;
}
java.lang.String[][] contentTemp3=new java.lang.String[checkNum][15];
for(i=0;i<checkNum;i++)
{
for(j=0;j<15;j++) contentTemp3[i][j]="NoData";
}
//取数据
i=0;
//生成删除时的详细表格的内容
for(i=1;i<=checkNum;i++)
{
sql="SELECT DBO.BBLRLXDY.LRBM AS LRBM FROM DBO.BBLRLXDY WHERE DBO.BBLRLXDY.BBBM='"+bbbm+"' AND DBO.BBLRLXDY.XH="+java.lang.String.valueOf(i)+ " ORDER BY LRSX ASC";
rs=DbBean.sqlQuery(sql);
j=0;
if(rs.next())
{
//构造完sql
sql="SELECT ";
do
{
strLrbm=((java.lang.String)(rs.getString("LRBM"))).trim();
if(j==0) sql+= strLrbm + " AS " + strLrbm;
else sql+= ","+strLrbm + " AS " + strLrbm;
j++;
} while(rs.next());
sql+=" FROM DBO.SGLRJK WHERE DBO.SGLRJK.BBBM='"+bbbm+"' AND DBO.SGLRJK.TBH='"+tbh+"' AND DBO.SGLRJK.RQ='"+rq+"' AND DBO.SGLRJK.DH='"+dh+"' AND DBO.SGLRJK.XH="+java.lang.String.valueOf(i);
j=0;
//构造完sql
rs2=DbBean.sqlQuery(sql);
rs.first();
rs2.next();
do
{
strLrbm=((java.lang.String)(rs.getString("LRBM"))).trim();
for(j=0;j<15;j++)
{
if(dataDestination[j].equals(strLrbm))
{
contentTemp3[i-1][j]=((java.lang.String)(rs2.getString(strLrbm))).trim();;
j=15;
}
}
} while(rs.next());
rs2.close();//释放资源
rs2=null;
}
else
{
java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系，读取该表定义信息是出错！");
throw exception;
}
rs.close();//释放资源
rs=null;
}
//生成删除时的表格
detailDelResulttable=DbBean.getTable( bbbm, contentTemp3, dataDestination, rq, tbh, dh);
//out.println(DbBean.AlertMsg("成功生成删除页面！"));
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]="hidden";
initStatus[10]="hidden";
initStatus[11]="hidden";
initStatus[12]="hidden";
initStatus[13]="visible";
break;
case 9:
//修改保存,首先设置和定义本模块使用的一些变量
tbh=((java.lang.String)request.getParameter("TBH")).trim();
dh=((java.lang.String)request.getParameter("DH")).trim();
rq=((java.lang.String)request.getParameter("RQ")).trim();
checkNum=0;
i=0;
j=0;
for(i=0;i<15;i++)
{
dataSource[i]="CM"+java.lang.String.valueOf(i+1)+"XH";
dataWarehouse[i]="0";
}
//生成增加时的表格
sql="SELECT DBO.BBLRLXDY.LRBM AS LRBM, DBO.BBLRLXDY.XH AS XH FROM DBO.BBLRLXDY WHERE DBO.BBLRLXDY.BBBM='"+bbbm+"' ORDER BY XH ASC";
rs=DbBean.sqlQuery(sql);
i=0;
if(rs.next())
{
strLrbm=((java.lang.String)(rs.getString("LRBM"))).trim();
strXh=((java.lang.String)(rs.getString("XH"))).trim();
DbBean.prepare();
do
{
if(i==0)
{
//新一个sql语句的初始化
initXh=strXh;
sql="UPDATE DBO.SGLRJK SET ";
if(checkNum>0)
{
strLrbm=((java.lang.String)(rs.getString("LRBM"))).trim();
strXh=((java.lang.String)(rs.getString("XH"))).trim();
}
}
else
{
strLrbm=((java.lang.String)(rs.getString("LRBM"))).trim();
strXh=((java.lang.String)(rs.getString("XH"))).trim();
}
if(initXh.equals(strXh))
{
for(j=0;j<15;j++)
{
if(dataDestination[j].equals(strLrbm))
{
dataWarehouse[j]=((java.lang.String)request.getParameter(dataSource[j]+initXh)).trim();
j=15;
}
}
checkNum++;
i++;
}
else
{
//构造并执行已经取完所需数据的sql
for(j=0;j<15;j++)
{
if(j==0) sql+=dataDestination[j]+"='"+dataWarehouse[j]+"'";
else sql+=","+dataDestination[j]+"='"+dataWarehouse[j]+"'";
}
sql+=" WHERE ((BBBM='"+bbbm+"') AND (TBH='"+tbh+"') AND (RQ='"+rq+"') AND (DH='"+dh+"') AND (XH="+initXh+"))";
DbBean.insertUpdate(sql);
//恢复默认值
for(j=0;j<15;j++)
{
dataWarehouse[j]="0";
}
//使其能构造下一个sql
i=0;
for(j=0;j<15;j++)
{
if(dataDestination[j].equals(strLrbm))
{
dataWarehouse[j]=((java.lang.String)request.getParameter(dataSource[j]+strXh)).trim();
j=15;
}
}
checkNum++;
}
}
while(rs.next());
//构造并执行已经取完所需数据的sql
for(j=0;j<15;j++)
{
if(j==0) sql+=dataDestination[j]+"='"+dataWarehouse[j]+"'";
else sql+=","+dataDestination[j]+"='"+dataWarehouse[j]+"'";
}
sql+=" WHERE ((BBBM='"+bbbm+"') AND (TBH='"+tbh+"') AND (RQ='"+rq+"') AND (DH='"+dh+"') AND (XH="+initXh+"))";
DbBean.insertUpdate(sql);
DbBean.exeInsert();
}
rs.close();//释放资源
rs=null;
out.println(DbBean.AlertMsg("修改成功！"));
initStatus[0]="";
initStatus[1]="";
initStatus[2]="disabled";
initStatus[3]="";
initStatus[4]="disabled";
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='sgxxlrmain.jsp?isFirst=1&type="+type+"';");
out.println("</SCRIPT>");
break;
case 10:
//删除单条保存,首先设置和定义本模块使用的一些变量
tbh=((java.lang.String)request.getParameter("TBH")).trim();
dh=((java.lang.String)request.getParameter("DH")).trim();
rq=((java.lang.String)request.getParameter("RQ")).trim();
DbBean.prepare();
sql="DELETE FROM DBO.SGLRJK WHERE ((BBBM='"+bbbm+"') AND (TBH='"+tbh+"') AND (RQ='"+rq+"') AND (DH='"+dh+"'))";
DbBean.insertUpdate(sql);
DbBean.exeInsert();
out.println(DbBean.AlertMsg("删除成功！"));
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='sgxxlrmain.jsp?isFirst=1&type="+type+"';");
out.println("</SCRIPT>");
break;
default:
java.sql.SQLException exception = new java.sql.SQLException("调用错误！");
throw exception;
}
}
//取当前报表需要手工录入的项数
sql="SELECT COUNT(*) AS NUM FROM DBO.BBLRLXDY WHERE DBO.BBLRLXDY.BBBM='"+bbbm+"'";
rs=DbBean.sqlQuery(sql);
i=0;
while(rs.next())
{
i++;
itemNum=(rs.getString("NUM")).trim();
}
rs.close();//释放资源
rs=null;
if(i!=1)
{
java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系，取当前报表需要手工录入的项数时出错！");
throw exception;
}
java.lang.String[] strData=new java.lang.String[Integer.parseInt(itemNum)];
//生成表格：schResulttable，chaResulttable，delResulttable，addResulttable
//首先生成增加时的表格
sql="SELECT DBO.BBLRLXDY.LRBM AS LRBM, DBO.BBLRLXDY.LRMC AS LRMC, DBO.BBLRLXDY.CD AS CD, substring(DBO.BBLRLXDY.LRBZ,1,1) AS LRBZ, DBO.BBLRLXDY.XH AS XH FROM DBO.BBLRLXDY WHERE DBO.BBLRLXDY.BBBM='"+bbbm+"' ORDER BY LRSX ASC,XH ASC";
rs=DbBean.sqlQuery(sql);
checkNum=0;
while(rs.next())
{
if(checkNum%2==0) addResulttable+="<TR>";
strLrbm=((java.lang.String)(rs.getString("LRBM"))).trim();
strLrmc=((java.lang.String)(rs.getString("LRMC"))).trim();
strCd =((java.lang.String)(rs.getString("CD"))).trim();
strLrbz=((java.lang.String)(rs.getString("LRBZ"))).trim();
strXh=((java.lang.String)(rs.getString("XH"))).trim();
addResulttable+="<TD>"+strLrmc+"</TD>";
addResulttable+="<TD><INPUT type='text' size='"+strCd+"' maxlength='"+strCd+"' name='N"+strLrbm+"XH"+strXh+"' value='' onkeypress=\"checkdecinput(this)\" onblur=\"checkdec(this,'14')\" ></TD>";
checkNum++;
if(checkNum%2==0) addResulttable+="</TR>";
}
temp=checkNum;
while(temp%2!=0)
{
addResulttable+="<TD></TD><TD></TD>";
temp++;
}
addResulttable+="</TR>";
if(checkNum==0)
{
java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系，读取该表定义信息是出错！");
throw exception;
}
rs.close();//释放资源
rs=null;
if(checkNum!=Integer.parseInt(itemNum))
{
java.sql.SQLException exception = new java.sql.SQLException("读取BBLRLXDY表时出错！");
throw exception;
}
%>
<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%>
</TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<SCRIPT language="JavaScript" src="/resources/check.js"></SCRIPT>
<SCRIPT language="JavaScript">
var JisFirst="<%=isFirst%>";
var Jact="<%=ACT%>";
var actionurl="";
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)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -