⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 bblrlxdy.jsp

📁 管理会计系统 主要功能在主页面左侧的菜单面中
💻 JSP
字号:
🔍 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<%
/*************************************************************
*调用时需要参数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;//计数器
  	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"))				//从菜单直接调用;
  	{
  		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('报表字典中的报表定义丢失!');");
			out.println("window.location='../../blank.html';");		
			out.println("</SCRIPT>");
		}
  	}
  	else
  	{
  		selectedBbbm=((java.lang.String)request.getParameter("bbbmlist")).trim();
  	}
  	
  	i=0;//计数器复位，以备后用
  	//下面查询出所选报表的所有录入列项定义信息
  	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>
报表录入列项定义
</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>报表录入列项定义</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">
报表：<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>序号    </TH>
		<TH>录入编码</TH>
		<TH>录入名称</TH>
		<TH>长度    </TH>
		<TH>录入标志</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>删除项</TH>
        <TH>录入顺序</TH>
		<TH>序号    </TH>
		<TH>录入编码</TH>
		<TH>录入名称</TH>
		<TH>长度    </TH>
		<TH>录入标志</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>序号    </TH>
		<TH>录入编码</TH>
		<TH>录入名称</TH>
		<TH>长度    </TH>
		<TH>录入标志</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("服务已经重启，您闲置的时间太长或系统调用错误，请重新登入试一下！<br>如果再出现这种情况请与系统维护员联系！"); 
      		 }
      		 else out.println(e.getMessage());
      		 System.gc();
       		 return;
          }
%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -