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

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

电子政务应用

开发平台：

Java

address_list_home.jsp：源码内容
  1. <%@ taglib uri="/vnex.tld" prefix="vnex"%>
  2. <%@ taglib uri="/vnex_addresslist.tld" prefix="addresslist"%>
  3. <%@ page errorPage="/vnex/ErrorPage.jsp" %>
  5. <%@ page import="com.vnex.intranet.util.*"%>
  7. <jsp:useBean id="BusinessName" scope="session" class="com.vnex.intranet.pub.BusinessSession" />
  8. <jsp:useBean id="groupSelect" scope="request" class="com.vnex.intranet.addresslist.handler.GroupSelectHandler" />
  10. <%
  11.      String queryStr = " where emp_id="+BusinessName.getEmpId();
  12.      String pageTo = "/mainctrl/addressbook/home?a";
  13.      String queryCondition = "";
  14.      String start = "1";
  15.      
  16.     CommonDBOperation cdb = new CommonDBOperation();
  17.     String DBProductName = cdb.getDBProduct();
  18.     if(DBProductName.startsWith("Oracle")) 
  19.     {
  20.       if(request.getParameter("search_text") != null)
  21.       {
  22.         String searchText = request.getParameter("search_text");
  23.         pageTo += "&search_text="+searchText;
  24.         queryStr += " and (name like '%"+searchText+"%') ";
  25.         if(!searchText.equals(""))
  26.         {
  27.            queryCondition = "姓名或昵称中包含有"+searchText+"字符的用户";
  28.         }
  29.       }
  30.     }
  31.     else if(DBProductName.startsWith("Microsoft SQL Server"))
  32.     {
  33.       if(request.getParameter("search_text") != null)
  34.       {
  35.         String searchText = request.getParameter("search_text");
  36.         pageTo += "&search_text="+searchText;
  37.         queryStr += " and (name like '%"+cdb.changeCode(searchText)+"%') ";
  38.         if(!searchText.equals(""))
  39.         {
  40.            queryCondition = "姓名或昵称中包含有"+searchText+"字符的用户";
  41.         }
  42.       }
  43.     }
  44.     
  45.      if(request.getParameter("contactGrp") != null)
  46.      {
  47.         String contactGrp = request.getParameter("contactGrp");
  48.         if(!contactGrp.equals("0"))
  49.         {
  50.            pageTo += "&contactGrp="+contactGrp;
  51.            queryStr += " and contact_id in (select contact_id from t_contact_x_group where group_id="+contactGrp+") ";
  52.            if( !queryCondition.equals(""))
  53.        {
  54.            queryCondition += "以及";
  55.        }
  56.        queryCondition += "属于"+contactGrp+"组别的用户";
  57.         }
  58.      }
  59.      if(request.getParameter("start") != null)
  60.         start = request.getParameter("start");
  61. %>
  63. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  64. <HTML>
  65. <jsp:include page="/vnex/page/FORM_HEAD.jsp" />
  67. <BODY text=#000000 vLink=#000000 aLink=#000000 link=#000000 bgColor=#ffffff topMargin=20 leftmargin="0" marginwidth="0" marginheight="0">
  68. <script language="JavaScript1.2" src="/vnex/menu/dockmenu_person.js"></script>
  69. <script language="JavaScript" src="/vnex/menu/dockmenu.js"></script>
  71. <script language="JavaScript" src="/vnex/util/strUtil.js"></script>
  72. <script language="JavaScript">
  73. function SelectAll(form)
  74. {
  75.   for (var i=0;i<form.elements.length;i++)
  76.   {
  77.     var e = form.elements[i];
  78.     if (e.name != 'C1')
  79.        e.checked = form.C1.checked;
  80.   }
  81. }
  83. function searchByName(form)
  84. {
  85.    if(checkChar(form.search_text.value))
  86.    {
  87.       form.action = "/mainctrl/addressbook/home";
  88.       form.submit();
  89.    }
  90.    else
  91.    {
  92.       alert("请不要在查询条件中加入"<>/\'%&这样的字符");
  93.    }
  94. }
  95.  
  96. function checkChar(str)
  97. {
  98.     var i,j,strTemp;
  99.     strTemp=""<>/\'%&";
  100.     for (i=0;i<str.length;i++)
  101.     {
  102.       j=strTemp.indexOf(str.charAt(i));
  103.       if (j!=-1)
  104.       {
  105.         return false;
  106.       }
  107.     }
  108.     return true;
  109. }
  111. function deleteThem(form)
  112. {
  113.    if(form.contactIds == null)
  114.    {
  115.       alert("现在尚未有数据可供删除");
  116.       return;
  117.    }
  118.    if(!isChecked(form.contactIds))
  119.    {
  120.       alert("请选择至少一个人员再进行删除");
  121.       return;
  122.    }
  123.    if(confirm("是否要删除所选人员？"))
  124.    {
  125.       form.action="/mainctrl/addressbook/deleteContacts";
  126.       form.submit();
  127.    }   
  128. }
  129. </script>
  130. <DIV align=center>
  131. <form name="form1" method="post" action="">
  132.   <TABLE class=outter cellSpacing=0 cellPadding=0 width=600 border=0>
  133.     <TBODY>
  134.     <jsp:include page="/vnex/page/TTOA_TABLE_TOP.jsp" />
  135.     <TR> 
  136.         <TD colSpan=3 align="center"><br>
  137.           <table width="600" border="1" cellspacing="1" bordercolor="#666666">
  138.             <tr> 
  139.               <td align="center" colspan="2" bgcolor="#FFFFFF"> 
  140.                 <table width="600" border="0" cellspacing="0" cellpadding="0">
  141.                   <tr bgcolor="#666666"> 
  142.                       <td colspan="2"><font class="strongw"><a href="/mainctrl/home/index"><font color="#ffffff">首页</font></a>&gt;&gt;<a href="/mainctrl/personal/main"><font color="#ffffff">个人办公</font></a>&gt;&gt;个人通讯录</font>
  143.                       </td>
  144.                   </tr>
  145.                 </table>  
  146.                 <table width="600" border="0" cellspacing="0" cellpadding="0">
  147.                   <tr bgcolor="#ffffff" height="30">
  148.                       <td align="left">&nbsp; 
  149.                 <strong>请选择你的用户组：</strong>
  150.                   <select name="contactGrp" size="1">
  151.                      <%=groupSelect.generateGroupCode(""+BusinessName.getEmpId())%>
  152.                   </select>&nbsp;
  153.                    <strong>查找用户姓名：</strong>&nbsp;
  154.                    <input type="text" name="search_text" size="10" class="text">&nbsp;
  155.                    <input type="button" name="button1" value="查找" class="text" onclick="searchByName(this.form)">
  156.                  </td>
  157.                   </tr>
  158.                 </table>
  159.                 <table class=title border="0" cellpadding="2" cellspacing="1" width="600">
  160.                    <tr bgcolor="#fafafa" height="30">
  161.                       <td colspan="7">&nbsp;  
  162.                           <input type="button" name="Button2" value="新增" onClick="location='/mainctrl/addressbook/createContact'" class="text">
  163.                           &nbsp;&nbsp;
  164.                           <input type="button" name="Button2" value="删除" onClick="deleteThem(this.form)" class="text">
  165.                           &nbsp;&nbsp;
  166.                           <input type="button" name="Button3" value="组管理" onclick="location='/mainctrl/addressbook/groupList'" class="text">
  167.                           &nbsp;&nbsp;
  168.                           <input type="button" name="button4" value="导入" class="text" onclick="location='/mainctrl/addressbook/import'">
  169.                           &nbsp;&nbsp;
  170.                           <input type="button" name="button5" value="导出" class="text" onclick="location='/mainctrl/addressbook/export'">
  171.                       </td>
  172.                    </tr>
  173.                    <tr> 
  174.                       <td height="12"  width="7%" align="center"><strong>选择</strong></td>
  175.                       <td height="12" align="center"><strong>姓名</strong></td>
  176.                       <td height="12" align="center"><strong>家庭电话</strong></td>
  177.                       <td height="12" align="center"><strong>EMail</strong></td>
  178.                      <td height="12" align="center"><strong>单位电话</strong></td>
  179.             <td height="12" align="center"><strong>手机</strong></td>
  180.             <td height="12" align="center"><strong>呼机</strong></td>
  181.                    </tr>
  182.                    <addresslist:addressList queryStr="<%=queryStr%>">
  183.                    <vnex:items paging="true">
  184.                    <tr bgcolor="<vnex:itemsColor />">
  185.                       <td height="12"  width="7%" align="center">
  186.                          <input type="checkbox" name="contactIds" value="<addresslist:addressAttribute attribute="contact_id" />">
  187.                       </td>
  188.                       <td height="12" align="center">
  189.                          <a href="/mainctrl/addressbook/contactDetail?contactId=<addresslist:addressAttribute attribute="contact_id" />&start=<%=start%>">
  190.                          <addresslist:addressAttribute attribute="contact_name"/></a>
  191.                       </td>
  192.                       <td height="12" align="center">
  193.                          <addresslist:addressAttribute attribute="home_tele_num"/>
  194.                       </td>
  195.                       <td height="12" align="center">
  196.                          <addresslist:addressAttribute attribute="email_address"/>
  197.                       </td>
  198.             <td height="12" align="center">
  199.                <addresslist:addressAttribute attribute="unit_tele_num"/>
  200.             </td>
  201.           <td height="12" align="center">
  202.              <addresslist:addressAttribute attribute="mobile_num"/>
  203.           </td>
  204.           <td height="12" align="center">
  205.              <addresslist:addressAttribute attribute="pager_num"/>
  206.           </td>
  207.                    </tr>   
  208.                    </vnex:items> 
  209.                    <tr bgcolor="#fafafa">
  210.                       <td width="7%" align="center"><input type="checkbox" name="C1" onclick="SelectAll(this.form)"></td>
  211.                       <td colspan="6">&nbsp;&nbsp;全选</td>
  212.                    </tr>
  213.                    <tr>
  214.                       <td colspan="7" bgcolor="#e0e0e0" align="left">&nbsp;
  215.                         <vnex:pagingTag pageName="<%=pageTo%>" />
  216.                       </td>
  217.                    </tr> 
  218.                    </addresslist:addressList>
  219.                 </table>
  220.                </td>
  221.             </tr>
  222.           </table>
  223.           <jsp:include page="/vnex/page/TTOA_HELP.jsp" />
  224.        </TD>
  225.      </TR>
  226.      <jsp:include page="/vnex/page/TTOA_TABLE_BOTTOM.jsp" />
  227.     </TBODY> 
  228.   </TABLE>
  229.     <BR>
  230.   <jsp:include page="/vnex/page/TTOA_PRODUCER_LOGO.jsp" />
  231. </form>
  232. </DIV>
  233. </BODY>
  234. </HTML>