📄 sgxxlrmain.jsp
字号:
dataSource[i]="NM"+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);
if(rs.next())
{
strLrbm=((java.lang.String)(rs.getString("LRBM"))).trim();
strXh=((java.lang.String)(rs.getString("XH"))).trim();
DbBean.prepare();
i=0;
do
{
if(i==0)
{
//新一个sql语句的初始化
initXh=strXh;
sql="INSERT INTO DBO.SGLRJK (BBBM,TBH,RQ,DH,XH,M1,M2,M3,M4,M5,M6,M7,M8,M9,M10,M11,M12,M13,M14,M15) VALUES('"+bbbm+"','"+tbh+"','"+dqgzr+"','"+dh+"',"+strXh;
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();
if(dataWarehouse[j].equals("")) dataWarehouse[j]="0";
j=15;
}
}
checkNum++;
i++;
}
else
{
//构造并执行已经取完所需数据的sql
for(j=0;j<15;j++)
{
sql+=","+dataWarehouse[j];
}
sql+=")";
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();
if(dataWarehouse[j].equals("")) dataWarehouse[j]="0";
j=15;
}
}
checkNum++;
}
}
while(rs.next());
//构造并执行已经取完所需数据的sql
for(j=0;j<15;j++)
{
sql+=","+dataWarehouse[j];
}
sql+=")";
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";
break;
case 4:
//删除列表,首先设置和定义本模块使用的一些变量
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);
i=0;
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();
delResulttable+="<TR ondblclick=\"shanchuClick('"+tbh+"','"+rq+"','"+dh+"')\"><TD align='right'><input type='checkbox' name='DCHECK' value='"+i+"'></TD><TD><INPUT TYPE='hidden' NAME='DTBH' VALUE='"+tbh+"'>"+tbh+"</TD><TD><INPUT TYPE='hidden' NAME='DRQ' VALUE='"+rq+"'>"+rq+"</TD><TD><INPUT TYPE='hidden' NAME='DDH' VALUE='"+dh+"'>"+strMc+"</TD></TR>";
i++;
}while(rs.next());
}
else
{
delResulttable+="<TR><TD></TD><TD></TD><TD></TD><TD></TD></TR>";
}
initStatus[0]="";
initStatus[1]="";
initStatus[2]="";
initStatus[3]="disabled";
initStatus[4]="";
initStatus[5]="visible";
initStatus[6]="hidden";
initStatus[7]="hidden";
initStatus[8]="visible";
initStatus[9]="hidden";
break;
case 5:
//批量删除保存,首先设置和定义本模块使用的一些变量
java.lang.String[] cheList=request.getParameterValues("DCHECK");
java.lang.String[] tbhList=request.getParameterValues("DTBH");
java.lang.String[] dhList= request.getParameterValues("DDH");
java.lang.String[] rqList= request.getParameterValues("DRQ");
if(cheList!=null)
{
DbBean.prepare();
for(i=0;i<cheList.length;i++)
{
j=Integer.parseInt(cheList[i]);
sql="DELETE FROM DBO.SGLRJK WHERE ((BBBM='"+bbbm+"') AND (TBH='"+tbhList[j]+"') AND (DH='"+dhList[j]+"') AND (RQ='"+rqList[j]+"'))";
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;
case 6:
//生成详细查看页面,首先设置和定义本模块使用的一些变量
for(i=0;i<15;i++)
{
dataSource[i]="SM"+java.lang.String.valueOf(i)+"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[][] contentTemp=new java.lang.String[checkNum][15];
for(i=0;i<checkNum;i++)
{
for(j=0;j<15;j++) contentTemp[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))
{
contentTemp[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;
}
//生成查看时的详细表格
detailSchResulttable=DbBean.getTable( bbbm, contentTemp, 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]="visible";
initStatus[11]="hidden";
break;
case 7:
//生成详细修改页面,首先设置和定义本模块使用的一些变量
for(i=0;i<15;i++)
{
dataSource[i]="CM"+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[][] contentTemp2=new java.lang.String[checkNum][15];
for(i=0;i<checkNum;i++)
{
for(j=0;j<15;j++) contentTemp2[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))
{
contentTemp2[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("请与系统维护员联系，读取该表定义信息是出错！");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -