?? bblrlxdy.jsp
字號(hào):
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%
/*************************************************************
*調(diào)用時(shí)需要參數(shù)isFirst=1
*************************************************************/
%>
<%
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;
java.lang.String selectedBbbm="";
int checknum=0;
int i=0;//計(jì)數(shù)器
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 strLrsx;
java.lang.String strXh;
java.lang.String strLrbm;
java.lang.String strLrmc;
java.lang.String strCd;
java.lang.String strLrbz;
java.lang.String resulttable="";
java.lang.String delResulttable="";
if(isFirst.equals("1")) //從菜單直接調(diào)用;
{
sql="SELECT TOP 1 DBO.BBZD.BBBM AS BBBM FROM DBO.BBZD ORDER BY BBZD.BBBM";
rs=DbBean.sqlQuery(sql);
if(rs.next())
{
selectedBbbm=((java.lang.String)(rs.getString("BBBM"))).trim();
}
else
{
out.println("<SCRIPT language='JavaScript'>");
out.println("alert('報(bào)表字典中的報(bào)表定義丟失!');");
out.println("window.location='../../blank.html';");
out.println("</SCRIPT>");
}
}
else
{
selectedBbbm=((java.lang.String)request.getParameter("bbbmlist")).trim();
}
i=0;//計(jì)數(shù)器復(fù)位，以備后用
//下面查詢出所選報(bào)表的所有錄入列項(xiàng)定義信息
if(selectedBbbm.length()>0)
{
sql="SELECT DBO.BBLRLXDY.LRSX AS LRSX, DBO.BBLRLXDY.XH AS XH, DBO.BBLRLXDY.LRBM AS LRBM, DBO.BBLRLXDY.LRMC AS LRMC, DBO.BBLRLXDY.CD AS CD, substring(DBO.BBLRLXDY.LRBZ,1,1) AS LRBZ FROM DBO.BBLRLXDY WHERE DBO.BBLRLXDY.BBBM='"+selectedBbbm+"'";
rs=DbBean.sqlQuery(sql);
checknum=0;
while(rs.next())
{
resulttable+="<TR>";
delResulttable+="<TR>";
strLrsx=((java.lang.String)(rs.getString("LRSX"))).trim();
strXh=((java.lang.String)(rs.getString("XH"))).trim();
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();
//////////// 組合查詢列表 ///////////////////////////////////////////////
resulttable+="<TD><INPUT type='hidden' name='OSLRSX' value='"+strLrsx+"'><INPUT size='3' type='text' maxlength='3' name='OLRSX' value='"+strLrsx+"'></TD>";
resulttable+="<TD><INPUT size='3' type='text' maxlength='3' name='OXH' value='"+strXh+"'></TD>";
resulttable+="<TD><INPUT size='5' type='text' maxlength='5' name='OLRBM' value='"+strLrbm+"'></TD>";
resulttable+="<TD><INPUT size='50' type='text' maxlength='50' name='OLRMC' value='"+strLrmc+"'></TD>";
resulttable+="<TD><INPUT size='3' type='text' maxlength='3' name='OCD' value='"+strCd+"'></TD>";
if(strLrbz.equals("0"))
resulttable+="<TD><SELECT name='OLRBZ'><OPTION value='00000000' selected>DECIMAL</OPTION><OPTION value='10000000'>INTEGER</OPTION></SELECT></TD>";
else
resulttable+="<TD><SELECT name='OLRBZ'><OPTION value='00000000'>DECIMAL</OPTION><OPTION value='10000000' selected>INTEGER</OPTION></SELECT></TD>";
//////////// 組合刪除列表 ///////////////////////////////////////////////
delResulttable+="<TD align='right'><input type='checkbox' name='DLRSXCHECK' value='"+strLrsx+"'></TD>";
delResulttable+="<TD><INPUT size='3' type='text' maxlength='3' name='DLRSX' value='"+strLrsx+"'></TD>";
delResulttable+="<TD><INPUT size='3' type='text' maxlength='3' name='DXH' value='"+strXh+"'></TD>";
delResulttable+="<TD><INPUT size='5' type='text' maxlength='5' name='DLRBM' value='"+strLrbm+"'></TD>";
delResulttable+="<TD><INPUT size='50' type='text' maxlength='50' name='DLRMC' value='"+strLrmc+"'></TD>";
delResulttable+="<TD><INPUT size='3' type='text' maxlength='3' name='DCD' value='"+strCd+"'></TD>";
if(strLrbz.equals("0"))
delResulttable+="<TD><SELECT name='DLRBZ'><OPTION value='00000000' selected>DECIMAL</OPTION><OPTION value='10000000'>INTEGER</OPTION></SELECT></TD>";
else
delResulttable+="<TD><SELECT name='DLRBZ'><OPTION value='00000000'>DECIMAL</OPTION><OPTION value='10000000' selected>INTEGER</OPTION></SELECT></TD>";
resulttable+="</TR>";
delResulttable+="</TR>";
checknum++;
}
if(checknum==0)
{
resulttable+="<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><TD></TD></TR>";
}
rs.close();//釋放資源
rs=null;
}
else
{
resulttable+="<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><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>
報(bào)表錄入列項(xiàng)定義
</TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<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)
{
w_str = "document.all.item(\"" + lId + "\").style";ob[lId] = eval(w_str);
ob[lId].visibility = "visible";
}
}
function HideObj(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 = "hide";
}
if (isIE)
{
w_str = "document.all.item(\"" + lId + "\").style";ob[lId] = eval(w_str);
ob[lId].visibility = "hidden";
}
}
function btnClick(i)
{
czform.quebtn.disabled=false;
czform.chabtn.disabled=false;
czform.newbtn.disabled=false;
czform.delbtn.disabled=false;
czform.subbtn.disabled=true;
switch(i)
{
case 1:
czform.ACT.value='1';
czform.quebtn.disabled=true;
HideObj("Lxz");
HideObj("Ldel");
ShowObj("Lcxgx");
break;
case 2:
czform.ACT.value='2';
czform.chabtn.disabled=true;
czform.subbtn.disabled=false;
HideObj("Lxz");
HideObj("Ldel");
ShowObj("Lcxgx");
actionurl="bblrlxdy_save.jsp";
czform.action=actionurl;
break;
case 3:
czform.ACT.value='3';
czform.newbtn.disabled=true;
czform.subbtn.disabled=false;
HideObj("Lcxgx");
HideObj("Ldel");
ShowObj("Lxz");
actionurl="bblrlxdy_save.jsp";
document.czform.NLRSX.focus();
czform.action=actionurl;
break;
case 4:
czform.ACT.value='4';
czform.delbtn.disabled=true;
czform.subbtn.disabled=false;
HideObj("Lxz");
HideObj("Lcxgx");
ShowObj("Ldel");
actionurl="bblrlxdy_save.jsp";
czform.action=actionurl;
break;
}
}
function doChange()
{
czform.action='bblrlxdy.jsp?isFirst=0';
czform.submit();
}
</SCRIPT>
</HEAD>
<BODY>
<FORM action="bblrlxdy.jsp?isFirst=0" method="post" name="czform" >
<DIV style="width : 400px;height : 5px;top : 0px;left : 20px;
position : absolute;
z-index : 1;
visibility : visible;" id="Lcxffdsfgx">
<H2>報(bào)表錄入列項(xiàng)定義</H2>
<INPUT type="button" name="quebtn" value="查詢" onclick="btnClick(1)" disabled>
<INPUT type="button" name="chabtn" value="修改" onclick="btnClick(2)">
<INPUT type="button" name="newbtn" value="增加" onclick="btnClick(3)">
<INPUT type="button" name="delbtn" value="刪除" onclick="btnClick(4)">
<INPUT type="submit" name="subbtn" value="提交" disabled>
<INPUT type="button" name="bangzhu" value="幫助" onClick="window.open('/help/2.7/2.7.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');">
<INPUT TYPE='hidden' NAME='ACT' VALUE='1'><BR>
<BR>
</DIV>
<DIV style="width : 400px;height : 5px;top : 90px;left : 20px;
position : absolute;
z-index : 1;
visibility : visible;" id="Lpublic">
報(bào)表：<SELECT name="bbbmlist" onchange="doChange()"><%=DbBean.selOptionE("DBO.BBZD","BBBM","BBMC",selectedBbbm," ORDER BY BBBM")%></SELECT>
</DIV>
<!-- 顯示 -->
<DIV style="top : 130px;left : 20px;
position : absolute;
z-index : 1;
visibility : visible;" id="Lcxgx">
<TABLE border="0" width="550">
<TR>
<TH>錄入順序</TH>
<TH>序號(hào) </TH>
<TH>錄入編碼</TH>
<TH>錄入名稱</TH>
<TH>長(zhǎng)度 </TH>
<TH>錄入標(biāo)志</TH>
</TR>
<%=resulttable%>
</TABLE>
</DIV>
<!-- 刪除 -->
<DIV style="top : 130px;left : 20px;
position : absolute;
z-index : 1;
visibility : hidden;" id="Ldel">
<TABLE border="0" width="640">
<TR>
<TH>刪除項(xiàng)</TH>
<TH>錄入順序</TH>
<TH>序號(hào) </TH>
<TH>錄入編碼</TH>
<TH>錄入名稱</TH>
<TH>長(zhǎng)度 </TH>
<TH>錄入標(biāo)志</TH>
</TR>
<%=delResulttable%>
</TABLE>
</DIV>
<!-- 增加 -->
<DIV style="top : 130px;left : 20px;
position : absolute;
z-index : 1;
visibility : hidden;" id="Lxz">
<TABLE border="0" width="550">
<TR>
<TH>錄入順序</TH>
<TH>序號(hào) </TH>
<TH>錄入編碼</TH>
<TH>錄入名稱</TH>
<TH>長(zhǎng)度 </TH>
<TH>錄入標(biāo)志</TH>
</TR>
<TR>
<TD><INPUT size="3" type="text" maxlength="3" name="NLRSX"></TD>
<TD><INPUT size="3" type="text" maxlength="3" name="NXH"></TD>
<TD><INPUT size="5" type="text" maxlength="5" name="NLRBM"></TD>
<TD><INPUT size="50" type="text" maxlength="50" name="NLRMC"></TD>
<TD><INPUT size="3" type="text" maxlength="3" name="NCD"></TD>
<TD><SELECT name="NLRBZ">
<OPTION value="0" selected>DECIMAL</OPTION>
<OPTION value="1">INTEGER</OPTION>
</SELECT></TD>
</TR>
</TABLE>
</DIV>
</FORM>
</BODY>
</HTML>
<%
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("服務(wù)已經(jīng)重啟，您閑置的時(shí)間太長(zhǎng)或系統(tǒng)調(diào)用錯(cuò)誤，請(qǐng)重新登入試一下！<br>如果再出現(xiàn)這種情況請(qǐng)與系統(tǒng)維護(hù)員聯(lián)系！");
}
else out.println(e.getMessage());
System.gc();
return;
}
%>?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -