📄 dwldljg.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 selectedJgbm="";
  java.lang.String baseJgbm="";
  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 strJgbm="";
  java.lang.String strJgmc="";
  java.lang.String strDwldljg="";

  java.lang.String resulttable="";
  java.lang.String delResulttable="";
  java.lang.String czyJgbm="";
  java.lang.String isTop="1";
  java.lang.String baseJgjb="";
  
  sql="SELECT  DBO.CZYZD.JGBM AS JGBM FROM  DBO.CZYZD WHERE DBO.CZYZD.CZYBM='"+czydm+"'";        
  rs=DbBean.sqlQuery(sql);
  
  i=0;
  while(rs.next())
   {
  	  i++;
          czyJgbm=(rs.getString("JGBM")).trim();
   } 
  rs.close();//释放资源
  rs=null;
  if(i!=1)
    {
    	java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系，您现在不属于任何机构或属于多个机构，所以您在本系统中没有任何权限！");
    	throw exception;
    }
  if(isFirst.equals("1"))
  {
        baseJgbm=czyJgbm;
  	selectedJgbm=czyJgbm;
  }
  else if(isFirst.equals("0"))
  {
        baseJgbm=(( java.lang.String)request.getParameter("baseJgbm")).trim();
 	selectedJgbm=(( java.lang.String)request.getParameter("jgbmlist")).trim();
  }
  else if(isFirst.equals("2"))
  {
          selectedJgbm=(( java.lang.String)request.getParameter("jgbmlist")).trim();
          if(czyJgbm.equals(selectedJgbm))
          {
      		baseJgbm=czyJgbm;
  		selectedJgbm=czyJgbm;
	  } 
	  else 
	  {
	        i=0;
	 	 sql="SELECT  DBO.JGZD.SJJGBM AS SJJGBM FROM  DBO.JGZD WHERE DBO.JGZD.JGBM='"+selectedJgbm+"'";        
	 	 rs=DbBean.sqlQuery(sql);
	 	
	 	 while(rs.next())
	 	  {
	 	 	  i++;
	 	         baseJgbm=(rs.getString("SJJGBM")).trim();
	 	         selectedJgbm=baseJgbm;
	 	  } 
	 	 rs.close();//释放资源
	 	 rs=null;
	 	 if(i!=1)
	 	   {
	 	           java.sql.SQLException exception = new java.sql.SQLException("当前机构已经没有上级机构了！");
			   throw exception;
	 	   } 
	  }       
  }
  
  if(baseJgbm.equals(czyJgbm)) isTop="1";
  else isTop="0";
  
  i=0;//计数器复位，以备后用
  //下面查询出所选机构的所有操作员信息
  //sql="SELECT  DBO.DWLDLJG.JGBM  AS JGBM, DBO.DWLDLJG.DWLDLJG  AS DWLDLJG  FROM  DBO.JGZD, DBO.DWLDLJG WHERE ((DBO.DWLDLJG.JGBM=DBO.JGZD.JGBM) AND ((DBO.JGZD.JGBM='"+selectedJgbm+"') OR (DBO.JGZD.SJJGBM='"+selectedJgbm+"')))";
  sql="SELECT  DBO.DWLDLJG.JGBM  AS JGBM, DBO.DWLDLJG.DWLDLJG  AS DWLDLJG,DBO.JGZD.JGMC AS JGMC  FROM  DBO.JGZD, DBO.DWLDLJG WHERE ((DBO.DWLDLJG.JGBM=DBO.JGZD.JGBM) AND ((DBO.JGZD.JGBM='"+selectedJgbm+"') OR (DBO.JGZD.SJJGBM='"+selectedJgbm+"')))";
  rs=DbBean.sqlQuery(sql);
  while(rs.next())
   {
		checknum++;
     	        resulttable+="<TR>";
  		delResulttable+="<TR>";	      
		
		strJgbm=((java.lang.String)(rs.getString("JGBM"))).trim();   
		strDwldljg=((java.lang.String)(rs.getString("DWLDLJG"))).trim();  
		strJgmc=((java.lang.String)(rs.getString("JGMC"))).trim();
			
		//组合显示、修改列表
		resulttable+="<TD align='center'><INPUT type='hidden' name='OSJGBM' value='"+strJgbm+"'><INPUT size='25' type='text' maxlength='50' name='OJGMC' value='"+strJgmc+"' readonly></TD>";
		resulttable+="<TD align='center'><INPUT size='16' type='text' maxlength='16' name='ODWLDLJG' value='"+strDwldljg+"'   onkeypress=\"checkdecinput(this)\" onblur=\"checkdec(this,'14')\" ></TD>";
			
		//组合删除列表
                delResulttable+="<TD align='center'><input type='checkbox' name='DSJGBM'  value='"+strJgbm+"'></TD>";
		delResulttable+="<TD align='center'><INPUT size='25' type='text' maxlength='50' name='DJGMC' value='"+strJgmc+"' readonly></TD>";
		delResulttable+="<TD align='center'><INPUT size='16' type='text' maxlength='16' name='DWLDLJG' value='"+strDwldljg+"'></TD>";

		resulttable+="</TR>";
  		delResulttable+="</TR>";	      
   }
   if(checknum==0)
   {
		resulttable+="<TR><TD></TD><TD></TD></TR>";
		delResulttable+="<TR><TD></TD><TD></TD><TD></TD></TR>";
   }
  
  
  rs.close();//释放资源
  rs=null;
%>
<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" src="/resources/check.js"></SCRIPT>
<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='dwldljg_save.jsp?isFirst=0&baseJgbm=<%=baseJgbm%>';
			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='dwldljg_save.jsp?isFirst=0&baseJgbm=<%=baseJgbm%>';
			document.czform.NDWLDLJG.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='dwldljg_save.jsp?isFirst=0&baseJgbm=<%=baseJgbm%>';
			czform.action=actionurl;			
			break;		  	 		 
	}
}

function doChange()
{
	czform.action='dwldljg.jsp?isFirst=0&baseJgbm='+czform.jgbmlist.value;
	czform.submit();
}
function doChange2()
{
	czform.action='dwldljg.jsp?isFirst=2';
	czform.submit();
}
</SCRIPT>
</HEAD>

<BODY>

<FORM 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.8/2.8.9.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 : 398px;height : 25px;top : 90px;left : 20px;
  position : absolute;
  z-index : 1;
  visibility : visible;" id="Lpublic">
所属机构：<SELECT name="jgbmlist" onchange="doChange()"><%=DbBean.selOptionE("DBO.JGZD","JGBM","JGMC",selectedJgbm,"WHERE ((JGBM='"+baseJgbm+"' OR SJJGBM='"+baseJgbm+"') AND (JGBZ LIKE '0%')  AND (JGJB LIKE '00%' OR JGJB LIKE '10%') )")%></SELECT>

<%                                                         
if(isTop.equals("0"))
{
	out.println("<IMG src='/resources/images/function/goback.gif' width='16' height='18'   border='0' onclick='doChange2()'>");
}
%>
</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>
      </TR>
		<%=resulttable%>
  </TABLE>
</DIV>

<!-- 删除部分 -->
<DIV style="top : 130px;left : 20px;
  position : absolute;
  z-index : 1;
  visibility : hidden;" id="Ldel">
    <TABLE border="0"  width="550">
       <TR>
      	 <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>
      </TR>

      <TR>
      <TD align='center'><SELECT name="NJGBM"><%=DbBean.selOptionE("DBO.JGZD","JGBM","JGMC",selectedJgbm,"WHERE ((JGBM='"+baseJgbm+"' OR SJJGBM='"+baseJgbm+"') AND (JGBZ LIKE '0%')  AND (JGJB LIKE '00%' OR JGJB LIKE '10%') )")%></SELECT></TD>
      <TD align='center'><INPUT size='16' type='text' maxlength='16' name='NDWLDLJG'   onkeypress="checkdecinput(this)" onblur="checkdec(this,'14')" ></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 + -