开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 电子政务应用 > 查看源码
Address_View.jsp
资源名称：NetOffice.rar　[点击查看]
上传用户：guhaomin
上传日期：2007-06-10
资源大小：23203k
文件大小：15k
源码类别：

电子政务应用

开发平台：

Java

Address_View.jsp：源码内容
  1. <%@ page errorPage="/vnex/ErrorPage.jsp" %>
  2. <%@ page import="com.vnex.intranet.commoninfo.addresslist.value.*"%>
  3. <%@ page import="com.vnex.intranet.commoninfo.addresslist.proxy.*"%>
  4. <%@ page import="com.vnex.intranet.util.*"%>
  5. <%@ page import="java.util.*" %>
  6. <%@ page import="java.sql.*" %>
  7. <jsp:useBean id="addressListProxy" class="com.vnex.intranet.commoninfo.addresslist.proxy.AddressListProxyBean" scope="application" />
  9. <%
  10.   int companyId = 0;
  11.   if(request.getParameter("companyId")!=null && !request.getParameter("companyId").equals(""))
  12.     companyId = Integer.parseInt(request.getParameter("companyId"));
  13.   
  14.   String con = "";
  15.   String sDepartment = "";
  16.   String sEmployeName = "";
  17.   
  18.     CommonDBOperation cdb = new CommonDBOperation();
  19.     String DBProductName = cdb.getDBProduct();
  20.     if(DBProductName.startsWith("Oracle")) 
  21.     {
  22.       if(request.getParameter("back")!=null && request.getParameter("back").equals("ok"))
  23.       {
  24.         if(request.getParameter("ssDepartment")!=null && !request.getParameter("ssDepartment").equals(""))
  25.         {
  26.           sDepartment = request.getParameter("ssDepartment");
  27.           con = " and employe_department='"+sDepartment+"'";
  28.         }
  29.         if(request.getParameter("ssEmployeName")!=null && !request.getParameter("ssEmployeName").equals(""))
  30.         {
  31.           sEmployeName = request.getParameter("ssEmployeName");
  32.           con = con + " and employe_name like '%"+sEmployeName+"%'";
  33.         }
  34.       }
  35.       
  36.       if(request.getParameter("sDepartment")!=null && !request.getParameter("sDepartment").equals(""))
  37.       {
  38.         sDepartment = request.getParameter("sDepartment");
  39.         con = " and employe_department='"+sDepartment+"'";
  40.       }
  41.       if(request.getParameter("sEmployeName")!=null && !request.getParameter("sEmployeName").equals(""))
  42.       {
  43.         sEmployeName = request.getParameter("sEmployeName");
  44.         con = con + " and employe_name like '%"+sEmployeName+"%'";
  45.       }
  46.     }
  47.     else if(DBProductName.startsWith("Microsoft SQL Server"))
  48.     {
  49.       if(request.getParameter("back")!=null && request.getParameter("back").equals("ok"))
  50.       {
  51.         if(request.getParameter("ssDepartment")!=null && !request.getParameter("ssDepartment").equals(""))
  52.         {
  53.           sDepartment = request.getParameter("ssDepartment");
  54.           con = " and employe_department='"+cdb.changeCode(sDepartment)+"'";
  55.         }
  56.         if(request.getParameter("ssEmployeName")!=null && !request.getParameter("ssEmployeName").equals(""))
  57.         {
  58.           sEmployeName = request.getParameter("ssEmployeName");
  59.           con = con + " and employe_name like '%"+cdb.changeCode(sEmployeName)+"%'";
  60.         }
  61.       }
  62.       
  63.       if(request.getParameter("sDepartment")!=null && !request.getParameter("sDepartment").equals(""))
  64.       {
  65.         sDepartment = request.getParameter("sDepartment");
  66.         con = " and employe_department='"+cdb.changeCode(sDepartment)+"'";
  67.       }
  68.       if(request.getParameter("sEmployeName")!=null && !request.getParameter("sEmployeName").equals(""))
  69.       {
  70.         sEmployeName = request.getParameter("sEmployeName");
  71.         con = con + " and employe_name like '%"+cdb.changeCode(sEmployeName)+"%'";
  72.       }
  73.     }
  74.   
  75.   AddressListValueBean companyBeanD = new AddressListValueBean();
  76.   AddressListValueBean companyBean = new AddressListValueBean();
  77.   companyBeanD = addressListProxy.getAddressListDetail(companyId);
  78.   companyBean = addressListProxy.getAddressListDetail(companyId, con);
  79.   session.setAttribute("companyBean", companyBean);
  80.   if(request.getParameter("sstart")!=null)
  81.   {
  82.     session.setAttribute("start", request.getParameter("sstart"));
  83.   }
  84. %>
  85. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  86. <HTML>
  87. <jsp:include page="/vnex/page/FORM_HEAD.jsp" />
  89. <BODY text=#000000 vLink=#000000 aLink=#000000 link=#000000 bgColor=#ffffff topMargin=20 leftmargin="0" marginwidth="0" marginheight="0">
  90. <script language="javascript" src="/vnex/validate.js" ></script>
  91. <script language=JavaScript>
  92. function isValidChar(str)
  93. {
  94.   var i,j,strTemp;
  95.   strTemp=""'<>/\";
  96.   for (i=0;i<str.length;i++)
  97.   {
  98.     j=strTemp.indexOf(str.charAt(i));
  99.     if (j!=-1)
  100.     {
  101.       return false;
  102.     }
  103.   }
  104.   return true;
  105. }
  107. function linkEmploye(employeId)
  108. {
  109.   document.myform.action = "/mainctrl/commoninfo/addresslist/modifyAddressEmploye?employeIds="+employeId;
  110.   document.myform.submit();
  111. }
  113. function removeCompanys()
  114. {
  115.  myform.action= "/mainctrl/commoninfo/addresslist/removeAddressListSuccess";
  116.   myform.submit();
  117. }
  119. function modifyCompany()
  120. {
  121.  myform.action= "/mainctrl/commoninfo/addresslist/modifyAddressList";
  122.   myform.submit();
  123. }
  125. function removeEmployes()
  126. {
  127.   if(document.myform.employeIds==null)
  128.   {
  129.     alert("没有要删除的职工。");
  130.     return false;
  131.   }
  132.   if( !isChecked(document.myform.employeIds) )
  133.   {
  134.     alert("请选择要删除的职工。");
  135.     return false;
  136.   }
  137.   if(!confirm("是否确定删除？"))
  138.   {
  139.     return false;
  140.   }
  141.  myform.action= "/mainctrl/commoninfo/addresslist/removeAddressEmployeSuccess";
  142.   myform.submit();
  143. }
  145. function searchEmploye()
  146. {
  147.   if(!isValidChar(myform.sEmployeName.value))
  148.   {
  149.     alert("查询职员姓名不能包括 " ' < > / \ 这些特殊字符。");
  150.     myform.sEmployeName.focus();
  151.     return false;
  152.   }
  153.  myform.action= "/mainctrl/commoninfo/addresslist/detailAddressList?start=1";
  154.   myform.submit();
  155. }
  157. function CheckAll(form)
  158. {
  159.   for (var i=0;i<form.elements.length;i++)
  160.   {
  161.     var e = form.elements[i];
  162.     if (e.name != 'chkall')
  163.        e.checked = form.chkall.checked;
  164.   }
  165. }
  167. </script>
  168. <script language="JavaScript1.2" src="/vnex/menu/dockmenu_office.js"></script>
  169. <script language="JavaScript1.2" src="/vnex/menu/dockmenu.js"></script>
  170. <DIV align=center>
  171.   <form name="myform" method="post" action="">
  172.     <TABLE class=outter cellSpacing=0 cellPadding=0 width=600 border=0>
  173.     <TBODY> 
  174.     <jsp:include page="/vnex/page/TTOA_TABLE_TOP.jsp" />
  175.     <TR> 
  176.         <TD colSpan=3 align="center"> 
  177.           <!--个人信息开始 --><br>
  178.           <table width="600" border="1" cellspacing="1" bordercolor="#666666">
  179.             <tr> 
  180.               <td> 
  181.                 <table width="600" border="0" cellspacing="0" cellpadding="2">
  182.                   <tr bgcolor="#666666">
  183.                     <td colspan="4" height="15"><font class="strongw"><a href="/mainctrl/home/index"><font color="#FFFFFF">首页</font></a>&gt;&gt;<a href="/mainctrl/office/main"><font color="#FFFFFF">办公室管理</font></a>&gt;&gt;<a href="/mainctrl/commoninfo/addresslist/getAddressList"><font color="#FFFFFF">外部通讯录</font></a>&gt;&gt;显示通讯录详细信息</font></td>
  184.                   </tr>
  185.                 </table>
  186.                 <table border="0" cellpadding="0" cellspacing="0" width="600" class=title>
  187.                   <tr bgcolor="#e0e0e0" align="center"> 
  188.                     <td> 
  189.                       <table border="0" cellpadding="0" cellspacing="1" width="100%" class=title>
  190.                         <tr bgcolor="#e0e0e0"> 
  191.                           <td width="17%"><font class="strong">&nbsp;&nbsp;公司名称：</font></td>
  192.                           <td width="83%" colspan="5"><%= companyBean.getCompanyName()%></td>
  193.                         </tr>
  194.                         <tr bgcolor="#fafafa">
  195.                           <td width="17%"><font class="strong">&nbsp;&nbsp;地址：</font></td>
  196.                           <td width="83%" colspan="5"><%= companyBean.getCompanyAddress()%></td>
  197.                         </tr>
  198.                         <tr bgcolor="#e0e0e0">
  199.                           <td width="17%"><font class="strong">&nbsp;&nbsp;邮编：</font></td>
  200.                           <td width="16%"><% if(companyBean.getCompanyZip()!=0) out.println(companyBean.getCompanyZip()); %></td>
  201.                           <td width="17%"><font class="strong">&nbsp;&nbsp;电话：</font></td>
  202.                           <td width="16%"><%= companyBean.getCompanyTelephone()%></td>
  203.                           <td width="17%"><font class="strong">&nbsp;&nbsp;传真：</font></td>
  204.                           <td width="16%"><%= companyBean.getCompanyFax()%></td>
  205.                         </tr>
  206.                       </table>
  207.                     </td>
  208.                   </tr>
  209.                 </table>
  210.                 <table width="100%" border="0" cellspacing="1" cellpadding="2" class=title>
  211.                   <tr bgcolor="#fafafa"> 
  212.                     <td height="30" colspan="9"> 
  213.                       &nbsp;<font class="strong">选择部门：</font>
  214.                       <select name="sDepartment" style="width=100">
  215.                         <option value="">全部</option>
  216. <%
  217.   Collection col = companyBeanD.getEmployes();
  218.   AddressEmployeValueBean evb = null;
  219.   Vector vec = new Vector();
  220.   if(col != null && col.size() != 0)
  221.   {
  222.   Iterator it = col.iterator();
  224.   while( it.hasNext() )
  225.   {
  226.       evb = (AddressEmployeValueBean)it.next();
  227.       if( !vec.contains(evb.getEmployeDepartment()) )
  228.       {
  229.         vec.add(evb.getEmployeDepartment());
  230.       }
  231.     }
  232.   }
  233.   for(int i=0; i<vec.size(); i++)
  234.   {
  235.     if( vec.get(i)!=null )
  236.     {
  237.       if(sDepartment.equals( (String)vec.get(i) ))
  238.       {
  239.         out.println("<option value=""+FieldUtil.filterQuotTag((String)vec.get(i))+"" selected>" + (String)vec.get(i) + "</option>");
  240.       }
  241.       else
  242.       {
  243.         out.println("<option value=""+FieldUtil.filterQuotTag((String)vec.get(i))+"">" + (String)vec.get(i) + "</option>");
  244.       }
  245.     }
  246.   }
  247. %>
  248.                       </select>
  249.                         &nbsp;<font class="strong" >职员姓名：</font>
  250.                       <input type="text" name="sEmployeName" class="file" value="<%= sEmployeName%>">
  251.                       &nbsp;<input type="button" name="Button" value="查询" class="text" onClick="return searchEmploye()">
  252.                     </td>
  253.                   </tr>
  254.                   <tr bgcolor="#fafafa"> 
  255.                     <td colspan="9" height="30">
  256.                       &nbsp;<input type="button" name="Button2" value="新增员工" class="text" onClick="location='/mainctrl/commoninfo/addresslist/createAddressEmploye?companyId=<%= companyId%>'" style="width:60px">
  257.                       &nbsp;&nbsp;<input type="button" name="Button3" value="删除员工" class="text" onClick="return removeEmployes()" style="width:60px">
  258.                       &nbsp;&nbsp;<input type="button" name="Button522" value="返回" class="file" onClick="location='/mainctrl/commoninfo/addresslist/getAddressList?start=<%= (String)session.getAttribute("start")%>'">
  259.                     </td>
  260.                   </tr>
  261.                   <tr align="center"> 
  262.                     <td width="7%"><font class="strong">选择</font></td>
  263.                     <td width="10%"><font class="strong">姓名</font></td>
  264.                     <td width="9%"><font class="strong">部门</font></td>
  265.                     <td width="9%"><font class="strong">职务</font></td>
  266.                     <td width="9%"><font class="strong">分机</font></td>
  267.                     <td width="9%"><font class="strong">呼机</font></td>
  268.                     <td width="9%"><font class="strong">手机</font></td>
  269.                     <td width="12%"><font class="strong">办公室</font></td>
  270.                     <td width="26%"><font class="strong">Email</font></td>
  271.                   </tr>
  272. <%
  273.   Collection coll = companyBean.getEmployes();
  274.   AddressEmployeValueBean aevb = null;
  275.   
  276.   int start = 1;
  277.   if ( request.getParameter("start") !=null )
  278.   {
  279.     start = Integer.parseInt( request.getParameter("start") );
  280.   }
  281.   int rowPerPage = com.vnex.intranet.system.loader.ConfigParaLoader.getParameterByInt("rowNum");
  282.   int size = coll.size();
  283.   String action = "/mainctrl/commoninfo/addresslist/detailAddressList?companyId=" + companyId;
  284.   if(!sDepartment.equals(""))
  285.   {
  286.     action += "&sDepartment=" + sDepartment;
  287.   }
  288.   if(!sEmployeName.equals(""))
  289.   {
  290.     action += "&sEmployeName=" + sEmployeName;
  291.   }
  292.   String nav = NavBar.makeNavbar(start, size, rowPerPage, action);
  294.   int i = 0;
  295.      if(coll != null && coll.size() != 0)
  296.      {
  297.        Iterator it = coll.iterator();
  298.        int flag = 0;
  299.        String bgcolor = null;
  300.        while( it.hasNext() && i < size && i < ( start+rowPerPage-1) )
  301.        {
  302.            i++;
  303.            aevb = (AddressEmployeValueBean)it.next();
  304.            if ( i < start ) continue;
  305.            if( flag%2==0 )
  306.            {
  307.              bgcolor = "#e0e0e0";
  308.            }
  309.            else
  310.            {
  311.              bgcolor = "#fafafa";
  312.            }
  313. %>
  314.             <tr bgcolor="<%= bgcolor%>" align="center"> 
  315.               <td> 
  316.                 <input type="checkbox" name="employeIds" value="<%= aevb.getEmployeId()%>">
  317.               </td>
  318.               <td><a href="JavaScript:linkEmploye(<%= aevb.getEmployeId()%>)"><%= aevb.getEmployeName()%></a></td>
  319.               <td><%= aevb.getEmployeDepartment()%></td>
  320.               <td><%= aevb.getEmployeDuty()%></td>
  321.               <td><% if(aevb.getEmployeExtension()!=0) out.println(aevb.getEmployeExtension()); %></td>
  322.               <td><%= aevb.getEmployePager()%></td>
  323.               <td><%= aevb.getEmployeHandset()%></td>
  324.               <td><%= aevb.getEmployeOffice()%></td>
  325.               <td><a href="mailto:<%= aevb.getEmployeEmail()%>"><%= aevb.getEmployeEmail()%></a></td>
  326.             </tr>
  327. <%
  328.            flag++;
  329.          }
  330.        }
  331. %>            
  333. <%
  334.   if(size!=0)
  335.   {
  336. %>
  337.             <tr bgcolor="#fafafa"> 
  338.               <td align="center">
  339.                 <input type="checkbox" name="chkall" value="on" onclick="CheckAll(this.form)">
  340.               </td>
  341.               <td colspan="8"> 
  342.                  &nbsp;&nbsp;全选
  343.               </td>
  344.             </tr>
  345. <%
  346.   }
  347. %>
  348.             <tr bgcolor="#e0e0e0"> 
  349.               <td colspan="9">
  350.                 &nbsp;&nbsp;<%= nav %>
  351.               </td>
  352.             <input type="hidden" name="companyId" value="<%= companyId%>">
  353.             <input type="hidden" name="companyIds" value="<%= companyId%>">
  354. <%
  355.   out.println("<input type=hidden name=ssDepartment value=""+sDepartment+"">");
  356.   out.println("<input type=hidden name=ssEmployeName value=""+sEmployeName+"">");
  357.   out.println("<input type=hidden name=start value=""+start+"">");
  358. %>
  359.             </tr>
  360.                 </table>
  361.               </td>
  362.             </tr>
  363.           </table>
  364.           <br>
  365.           <br>
  366.           <jsp:include page="/vnex/page/TTOA_HELP.jsp" />
  367.        </TD>
  368.     </TR>
  369.     <jsp:include page="/vnex/page/TTOA_TABLE_BOTTOM.jsp" />
  370.     </TBODY> 
  371.   </TABLE>
  372.   <BR>
  373.   <jsp:include page="/vnex/page/TTOA_PRODUCER_LOGO.jsp" />
  374. </form></DIV>
  375. </BODY></HTML>