TalentsList.asp
上传用户:mtjhgs
上传日期:2021-12-08
资源大小:3755k
文件大小:9k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

HTML/CSS

  1. <HTML xmlns="http://www.w3.org/1999/xhtml">
  2. <HEAD>
  3. <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312" />
  4. <TITLE>人才信息列表</TITLE>
  5. <link rel="stylesheet" href="Images/Admin.css">
  6. <script language="javascript" src="../Script/Admin.js"></script>
  7. </HEAD>
  8. <!--#include file="../Include/Const.asp" -->
  9. <!--#include file="../Include/ConnSiteData.asp" -->
  10. <!--#include file="CheckAdmin.asp"-->
  11. <BODY>
  12. <%
  13. if Instr(session("AdminPurview"),"|26,")=0 then
  14.   response.write ("<br><br><div align=""center""><font style=""color:red; font-size:9pt; "")>您没有管理该模块的权限!</font></div>")
  15.   response.end
  16. end if
  17. %>
  18. <br>
  19. <table class="tableborder" width="95%" border="0" align="center" cellpadding="3" cellspacing="1">
  20.   <tr>
  21.     <th>招聘信息:添加,修改招聘信相关的内容</th>
  22.   </tr>
  23.   <tr>
  24.     <td height="24" align="center" nowrap="nowrap"  class="forumrow"><a href="JobsEdit.asp?Result=Add" onclick='changeAdminFlag(&quot;添加招聘信息&quot;)'>添加招聘信息</a><font color="#0000FF">&nbsp;|&nbsp;</font><a href="JobsList.asp" onclick='changeAdminFlag(&quot;招聘信息列表&quot;)'>查看招聘信息 </a>&nbsp;|&nbsp;<a href="TalentsList.asp" onclick='changeAdminFlag(&quot;人才信息列表&quot;)'>查看人才信息</a></td>
  25.   </tr>
  26. </table>
  27. <%
  28. dim Result,Keyword
  29. Result=request.QueryString("Result")
  30. Keyword=request.QueryString("Keyword")
  31. function PlaceFlag()
  32.   if Result="Search" then
  33. If Keyword<>"" Then
  34. Response.Write "人才:列表 -> 检索 -> 关键字:<font color='red'>"&Keyword&"</font>"
  35. Else
  36. Response.Write "人才:列表 -> 检索 -> 关键字为空(显示全部人才)"
  37. End If
  38.   else
  39.     if SortPath<>"" then
  40.       Response.Write "人才:列表 -> <a href='TalentsList.asp'>全部</a>"
  41.   TextPath(SortID)
  42. else
  43.       Response.Write "人才:列表 -> 全部"
  44. end if
  45.   end if
  46. end function
  47. %>
  48. <br>
  49. <table class="tableborder" width="95%" border="0" align="center" cellpadding="3" cellspacing="1">
  50. <form name="formSearch" method="post" action="Search.asp?Result=Talents">
  51.   <tr>
  52.     <th height="22">【人才检索、查看】</th>
  53.   </tr>
  54.   <tr>
  55.     <td class="forumRow">关键字:<input name="Keyword" type="text" value="<%=Keyword%>" size="20"> <input name="submitSearch" type="submit" value="搜索人才"></td>
  56.   </tr>
  57.   <tr>
  58.     <td class="forumRow"><%PlaceFlag()%></td>
  59.   </tr>
  60.   </form>
  61. </table>
  62. <br>
  63. <table class="tableborder" width="95%" border="0" align="center" cellpadding="3" cellspacing="1">
  64. <form action="DelContent.asp?Result=Talents" method="post" name="formDel">
  65.   <tr>
  66.     <td class="title" width="20">ID</td>
  67. <td class="title" width="80">姓名</td>
  68. <td class="title" width="200">职位名称</td>
  69. <td class="title" >电子信箱</td>
  70. <td class="title" width="120">提交时间</td>
  71. <td class="title" width="120">回复时间</td>
  72. <td class="title" width="80">操作</td>
  73. <td width="80" align="center" class="title"><input onClick="CheckAll(this.form)" name="buttonAllSelect" type="button" id="submitAllSearch" value="全选"> <input onClick="CheckOthers(this.form)" name="buttonOtherSelect" type="button" id="submitOtherSelect" value="反选"> </td>  </tr>
  74.   <% TalentsList() %>
  75.   </form>
  76. </table>
  77. </BODY>
  78. </HTML>
  79. <%
  80. function TalentsList()
  81.   dim idCount
  82.   dim pages
  83.       pages=20
  84.   dim pagec
  85.   dim page
  86.       page=clng(request("Page"))
  87.   dim pagenc
  88.       pagenc=2
  89.   dim pagenmax
  90.   dim pagenmin
  91.   dim datafrom
  92.       datafrom="Wygkcnflash_Talents"
  93.   dim datawhere
  94.       if Result="Search" then
  95.      datawhere="where TalentsName like '%" & Keyword &_
  96.            "%' "
  97.   else
  98.     if SortPath<>"" then
  99.   datawhere="where Instr(SortPath,'"&SortPath&"')>0 "
  100.         else
  101.   datawhere=""
  102. end if
  103.   end if
  104.   dim sqlid
  105.   dim Myself,PATH_INFO,QUERY_STRING
  106.       PATH_INFO = request.servervariables("PATH_INFO")
  107.   QUERY_STRING = request.ServerVariables("QUERY_STRING")'
  108.       if QUERY_STRING = "" or Instr(PATH_INFO & "?" & QUERY_STRING,"Page=")=0 then
  109.     Myself = PATH_INFO & "?"
  110.   else
  111.     Myself = Left(PATH_INFO & "?" & QUERY_STRING,Instr(PATH_INFO & "?" & QUERY_STRING,"Page=")-1)
  112.   end if
  113.   dim taxis
  114.       taxis="order by id desc"
  115.   dim i
  116.   dim rs,sql
  117.   sql="select count(ID) as idCount from ["& datafrom &"]" & datawhere
  118.   set rs=server.createobject("adodb.recordset")
  119.   rs.open sql,conn,0,1
  120.   idCount=rs("idCount")
  121.   if(idcount>0) then
  122.     if(idcount mod pages=0)then
  123.   pagec=int(idcount/pages)
  124.     else
  125.       pagec=int(idcount/pages)+1
  126.     end if
  127.     sql="select id from ["& datafrom &"] " & datawhere & taxis
  128.     set rs=server.createobject("adodb.recordset")
  129.     rs.open sql,conn,1,1
  130.     rs.pagesize = pages
  131.     if page < 1 then page = 1
  132.     if page > pagec then page = pagec
  133.     if pagec > 0 then rs.absolutepage = page  
  134.     for i=1 to rs.pagesize
  135.   if rs.eof then exit for  
  136.   if(i=1)then
  137.     sqlid=rs("id")
  138.   else
  139.     sqlid=sqlid &","&rs("id")
  140.   end if
  141.   rs.movenext
  142.     next
  143.   end if
  144.   if(idcount>0 and sqlid<>"") then
  145.     sql="select * from ["& datafrom &"] where id in("& sqlid &") "&taxis
  146.     set rs=server.createobject("adodb.recordset")
  147.     rs.open sql,conn,0,1
  148.     while(not rs.eof)
  149.   Response.Write "<tr>" & vbCrLf
  150.       Response.Write "<td nowrap class=""forumRow"">"&rs("ID")&"</td>" & vbCrLf
  151.       Response.Write "<td nowrap class=""forumRow"">"&Guest(rs("MemID"),rs("Linkman"))&"</td>" & vbCrLf
  152.   if StrLen(rs("TalentsName"))>33 then
  153.         Response.Write "<td title="&rs("TalentsName")&" nowrap class=""forumRow"">"&StrLeft(rs("TalentsName"),30)&"</td>" & vbCrLf
  154.       else
  155.         Response.Write "<td title="&rs("TalentsName")&" nowrap class=""forumRow"">"&rs("TalentsName")&"</td>" & vbCrLf
  156.       end if 
  157.   if StrLen(rs("Email"))>21 then
  158.         Response.Write "<td title="&rs("Email")&" nowrap class=""forumRow"">"&StrLeft(rs("Email"),18)&"</td>" & vbCrLf
  159.       else
  160.         Response.Write "<td title="&rs("Email")&" nowrap class=""forumRow"">"&rs("Email")&"</td>" & vbCrLf
  161.       end If
  162.       If rs("ReplyTime") <> "" Then
  163.       ReplyTime = rs("ReplyTime")
  164.   Else
  165.   ReplyTime = "<font color=""#CC0000"">暂无回复</font>"
  166.   End If
  167.       Response.Write "<td nowrap class=""forumRow"">"&rs("AddTime")&"</td>" & vbCrLf
  168.       Response.Write "<td nowrap class=""forumRow"">"&ReplyTime&"</td>" & vbCrLf
  169.       Response.Write "<td align=""center""nowrap class=""forumRow""><a href='TalentsEdit.asp?Result=Modify&ID="&rs("ID")&"'>查看、回复</a></td>" & vbCrLf
  170.     Response.Write "<td nowrap align='center' class=""forumRow""><input name='selectID' type='checkbox' value='"&rs("ID")&"'></td>" & vbCrLf
  171.       Response.Write "</tr>" & vbCrLf
  172.   rs.movenext
  173.     wend
  174.     Response.Write "<tr>" & vbCrLf
  175.     Response.Write "<td colspan='8' nowrap align=""right"" class=""forumRow""><input name='submitDelSelect' type='button' id='submitDelSelect' value='删除所选' onClick='ConfirmDel(""是否确定删除?删除后不能恢复!"");'></td>" & vbCrLf
  176.     Response.Write "</tr>" & vbCrLf
  177.   else
  178.     response.write "<tr><td nowrap align='center' colspan='8' class=""forumRow"">暂无人才信息</td></tr>"
  179.   end if
  180.   Response.Write "<tr>" & vbCrLf
  181.   Response.Write "<td colspan='8' nowrap class=""forumRow"">" & vbCrLf
  182.   Response.Write "<table width='100%' border='0' align='center' cellpadding='0' cellspacing='0'>" & vbCrLf
  183.   Response.Write "<tr>" & vbCrLf
  184.   Response.Write "<td class=""forumRow"">共计:<font color='red'>"&idcount&"</font>条记录 页次:<font color='red'>"&page&"</font></strong>/"&pagec&" 每页:<font color='red'>"&pages&"</font>条</td>" & vbCrLf
  185.   Response.Write "<td align='right'>" & vbCrLf
  186.   pagenmin=page-pagenc
  187.   pagenmax=page+pagenc
  188.   if(pagenmin<1) then pagenmin=1
  189.   if(page>1) then response.write ("<a href='"& myself &"Page=1'><font style='font-size: 14px; font-family: Webdings'>9</font></a> ")
  190.   if(pagenmin>1) then response.write ("<a href='"& myself &"Page="& page-(pagenc*2+1) &"'><font style='font-size: 14px; font-family: Webdings'>7</font></a> ")
  191.   if(pagenmax>pagec) then pagenmax=pagec
  192.   for i = pagenmin to pagenmax
  193. if(i=page) then
  194.   response.write (" <font color='red'>"& i &"</font> ")
  195. else
  196.   response.write ("[<a href="& myself &"Page="& i &">"& i &"</a>]")
  197. end if
  198.   next
  199.   if(pagenmax<pagec) then response.write (" <a href='"& myself &"Page="& page+(pagenc*2+1) &"'><font style='font-size: 14px; font-family: Webdings'>8</font></a> ")
  200.   if(page<pagec) then response.write ("<a href='"& myself &"Page="& pagec &"'><font style='font-size: 14px; font-family: Webdings'>:</font></a> ")
  201.   Response.Write "第<input name='SkipPage' onKeyDown='if(event.keyCode==13)event.returnValue=false' onchange=""if(/D/.test(this.value)){alert('请输入需要跳转到的页数并且必须为整数!');this.value='"&Page&"';}"" style='width: 28px;' type='text' value='"&Page&"'>页" & vbCrLf
  202.   Response.Write "<input name='submitSkip' type='button' onClick='GoPage("""&Myself&""")' value='转到'>" & vbCrLf
  203.   Response.Write "</td>" & vbCrLf
  204.   Response.Write "</tr>" & vbCrLf
  205.   Response.Write "</table>" & vbCrLf
  206.   rs.close
  207.   set rs=nothing
  208.   Response.Write "</td>" & vbCrLf
  209.   Response.Write "</tr>" & vbCrLf
  210. end Function
  211. function Guest(ID,Linkman)
  212.   Dim rs,sql
  213.   Set rs=server.CreateObject("adodb.recordset")
  214.   sql="Select * From Wygkcnflash_Members where ID="&ID
  215.   rs.open sql,conn,1,1
  216.   if rs.bof and rs.eof then
  217.     Guest=Linkman
  218.   else
  219.     Guest="<font color='green'>会员:</font><a href='MemEdit.asp?Result=Modify&ID="&ID&"'>"&Linkman&"</a>"
  220.   end if
  221.   rs.close
  222.   set rs=nothing
  223. end function
  224. %>