duty1.jsp

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

<%
/**********************************************************
Copyright (C),2003-10-15, Beijing  USTB.
All rights reserved.
Filename: duty.jsp
Author: 
Version 1.0
Date:2003-10-15
Description:
Other:
Variable List:

Function List:

History:
***********************************************************/
%>
<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,oa.main.DealString,javax.swing.tree.DefaultMutableTreeNode"%>

<%
oa.bean.DepartmentBean myBean = null;
oa.bean.RightBean rtBean = null;
try{
	myBean = new oa.bean.DepartmentBean();
	rtBean = new oa.bean.RightBean();

	if(myBean.getConn()==null || rtBean.getConn()== null)
	{
		%>		
		数据库无法响应,请<a href="javascript:window.history.back(-1);">返回</a>重试
		<%out.close();
	}

	DealString ds = new DealString();
	//取得菜单类别
	String strType = ds.toString((String)request.getParameter("txt_type"));
	if(strType.equals(""))strType = "1";

	//组织机构编号
	String strOrgNO = ds.toString((String)request.getParameter("txt_orgno"));

	//职务编号
	String strDutyNO = ds.toString((String)request.getParameter("txt_dutyno"));

	//增删改类型
	String strEdit = ds.toString((String)request.getParameter("txt_edit"));
%>

<br>



<div align=center>
<font color="#CC00FF" size=3><b>职务维护<b></font>
</div>
<br>
<TABLE cellSpacing=1 cellPadding=5 width="95%" align=center bgColor=#999999>
  <TBODY>
  <TR bgColor=D0E7FF height=20>
    <TD>
      <CENTER><B>部门名称</B></CENTER></TD>
    <TD>
      <CENTER><B>职务名称</B></CENTER></TD>
    <!--TD>
      <CENTER><B>职务类型</B></CENTER></TD-->
    <TD>
      <CENTER><B>职务状态</B></CENTER></TD>

<%//权限判断
String userid = (String)session.getAttribute("zgbh");
//权限判断
	rtBean.setUID(userid);
	rtBean.setOrgid(strOrgNO);
%>
<%
if(rtBean.isRightModelbh("职务列表","修改") || rtBean.isRightModelbh("职务列表","删除"))
{
%>  
	<TD>
      <CENTER><B>操作</B></CENTER></TD>
<%}%>	  
	  
	</TR>
  <TR bgColor=#ffffff>
    <TD colSpan=7 height=15></TD></TR>
  <%
	myBean.setID(strOrgNO);
	Vector vect = (Vector)myBean.getArr();
	String bgcolor="";

	String bm = (String)request.getParameter("bm");
	if(bm==null || bm.equals("")) bm = "1";
	int cur = Integer.parseInt(bm);
    int recsum = ((Integer)vect.get(vect.size()-1)).intValue();

	vect = (Vector)myBean.getOnePage(cur,10);
	int sum = Integer.parseInt((String)vect.get(0));

	for(int i=1;i<vect.size();i++)
	{
		if ((i%2)!=0) { 
			bgcolor="#d0e7ff";
		}else {
			bgcolor="#ffffff";
		}
		Hashtable hash = (Hashtable)vect.get(i);	
		String strBH = (String)hash.get("BMBH");
		strBH = myBean.toName();
		String strBH1 = (String)hash.get("ZWBH");
		String strMC = (String)hash.get("ZWMC");
		String strZT = (String)hash.get("ZWZT");
		if(strZT.equals("0")) strZT = "正常";
		else strZT = "<font color='#ff0000'>挂起</font>";
		//String strSFJC = (String)hash.get("SFJC");
		//if(strSFJC.equals("1")) strSFJC = "不可继承";
		//else strSFJC = "可以继承";
%>

  <TR bgColor="<%=bgcolor%>">
    <TD align=center><%=strBH%></TD>
    <TD align=center><%=strMC%></TD>
	<!--TD align=center><%//=strSFJC%></TD-->
	<TD align=center><%=strZT%></TD>
<%
if(rtBean.isRightModelbh("职务列表","修改") || rtBean.isRightModelbh("职务列表","删除"))
{
%>  
	<TD align=center>
	<FONT color="#338800">
	<%
	if(rtBean.isRightModelbh("职务列表","修改")){%>  
	  <A onclick="edit('<%=strBH1%>');" style="cursor:hand;">修改</A> 
	<%}
	if(rtBean.isRightModelbh("职务列表","删除")){%>  
	  <A onclick="del('<%=strBH1%>');" style="cursor:hand;">删除</A>
	  <A onclick="srchPersons('<%=strBH1%>');" style="cursor:hand;">查看使用人</A>
	<%}%>	
	</FONT>
	</TD>
<%
}
%>
	</TR>
<%
	}
int t =-1;
int s = -1;
%>
	<tr height=25>
		<TD align=right colspan=8 bgColor=D0E7FF>
		共有记录数：<%=recsum%>&nbsp;&nbsp;&nbsp;&nbsp;
<%if(vect.size()>1){%>
		当前<%=cur%>/<%=sum%>页&nbsp&nbsp&nbsp<a onclick="firsrpg()" style="cursor:hand">第一页&nbsp&nbsp&nbsp </a> <!--href="index.jsp?txt_type=3&bm=1"-->
		<%if(cur>1){ t=cur-1;%>
		<a onclick="lastpg()" style="cursor:hand">上一页&nbsp&nbsp&nbsp </a><%}%><!--href="index.jsp?txt_type=3&bm=<%=t%>"-->
		<%if(cur<sum){ s=cur+1;%>
		<a onclick="nextpg()" style="cursor:hand">下一页&nbsp&nbsp&nbsp</a><%}%>&nbsp&nbsp
		<!--href="index.jsp?txt_type=3&bm=<%=s%>"-->
		<a onclick="finalpg()" style="cursor:hand">最后页&nbsp&nbsp&nbsp </a><!--href="index.jsp?txt_type=3&bm=<%=sum%>"-->  
		直接<input type=image src="../images/hand.gif" name="gotof" onclick="return chkdata()">
		<input type=text size=5 name=bm class=formcolor>页</TD>
<%}%>
	</tr>

  </TBODY></TABLE>
  <script>
	function firsrpg()
	{
		document.all.txt_type.value = "2";
		document.all.form1.action = "index.jsp?bm=1";
		document.all.form1.submit();
	}
	function lastpg()
	{
		document.all.txt_type.value = "2";
		document.all.form1.action = "index.jsp?bm="+<%=t%>;
		document.all.form1.submit();
	}
	function nextpg()
	{
		document.all.txt_type.value = "2";
		document.all.form1.action = "index.jsp?bm="+<%=s%>;
		document.all.form1.submit();
	}
	function finalpg()
	{
		document.all.txt_type.value = "2";
		document.all.form1.action = "index.jsp?bm="+<%=sum%>;
		document.all.form1.submit();
	}
	
	function edit(id)
	{
		document.all.txt_type.value = "2";
		document.all.txt_dutyno.value = id;
		document.all.txt_edit.value = "2";
		document.all.form1.action = "index.jsp";
		document.all.form1.submit();
	}

	function del(id)
	{
		if(!confirm("是否真的要删除？"))
		{
		}
		else
		{
			document.all.txt_type.value = "2";
			document.all.txt_dutyno.value = id;
			document.all.txt_edit.value = "3";
			document.all.form1.action = "../../Org";
			document.all.form1.submit();
		}
	}
	function srchPersons(id)
	{
		var url = "srchPersons.jsp?txt_orgno=<%=strOrgNO%>&txt_dutyno="+id;
		var hwnd = window.open(url,"helpWindow1","width=300,height=235,resizable=yes,scrollbars=yes");
		if((document.window!=null) && (!window.opener))
			window.opener = document.window;
		hwnd.focus();
	}
	function isDigit(str)
	{
		var bool = true;
		for(var i=0;i<str.length;i++)
		{
			if(!(str.charAt(i)>=0&&str.charAt(i)<=9))
			{
				bool = false;
				break;
			}
		}
		return bool;
	}
	function chkdata()
	{
		document.all.txt_type.value = "2";
		if(!isDigit(document.all.bm.value))
        {
			alert("输入的页码不是数字!");
			document.all.bm.value="";
			document.all.bm.focus();
			return false;
		}
		if(document.all.bm.value=="")
		{
			alert("请输入页码!");
			document.all.bm.value="";
			document.all.bm.focus();
			return false;
		}
		else
		{
			var t = document.all.bm.value;
			var cur = <%=cur%>;
			var sum = <%=sum%>;

			while(t.length>cur.length)
            {
				alert("请跳至1和"+sum+"之间!");
				document.all.bm.value="";
				document.all.bm.focus();
				return false;
			}
			if(t==cur){return false;}
            
			
			while(t.length>sum.length)
			{
				alert("请跳至1和"+sum+"之间!");
				document.all.bm.value="";
				document.all.bm.focus();
				return false;
			}
			if(t<1||t>sum)
			{
				alert("请跳至1和"+sum+"之间!");
				document.all.bm.value="";
				document.all.bm.focus();
				return false;
			}
		}
		return true;
	}

</script>
<%}finally{
	if(myBean!=null)myBean.closeConn();
	if(rtBean!=null)rtBean.closeConn();
}%>