www.gusucode.com > 528人才招聘网整站源代码-蓝色经典 精简版 2.0源码程序 > psearchp_vip.asp
<!--#include file="info.asp"--> <!--#include file="conn.asp"--> <% sql="select id,name,job1,gzdd,gzcs,edu,sex,rdate,zhuanyen1 from in_user where name<>'' and lock=false" if request("gzdd")<>"0" and request("gzdd")<>"" then sql=sql+" and gzdd='"&request("gzdd")&"'" if request("job")<>"0" and request("job")<>"" then sql=sql+" and job='"&request("job")&"'" if Trim(request("cs"))<>"" then sql=sql+" and gzcs like '%"&request("cs")&"%'" if Trim(request("zy"))<>"" then sql=sql+" and zhuanyen1 like '%"&request("zy")&"%'" if Trim(request("sex"))<>"" then sql=sql+" and sex='"&request("sex")&"'" if Trim(request("what"))<>"" then sql=sql+" and job1 like '%"&Trim(request("what"))&"%'" if request("date")<>"不限" and request("date")<>"" then sql=sql+" and datediff('d',rdate,Now())<"&request("date") sql=sql+" order by vip asc,id desc" rs.open sql,conn,1,1 %> <html> <head> <meta http-equiv="Content-Language" content="zh-cn"> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <link rel="stylesheet" href="css.css" type="text/css"> <title>人才普通搜索 - <%=webname%></title> <style type="text/css"> <!-- .STYLE1 {font-weight: bold} --> </style></head> <body> <!--#include file="top.asp"--> <div align="center"> <table border="0" width="760" cellspacing="0" cellpadding="0" id="table1" height="106"> <tr> <td style="border-left: 1px solid #0086DF; border-right: 1px solid #0086DF" width="760" valign="top"> <div align="center"> <table border="0" width="98%" cellspacing="0" cellpadding="0" id="table2" height="164"> <tr> <td style="border: 1px solid #C0C0C0" valign="top"> <div align="center"> <table border="0" width="100%" cellspacing="0" cellpadding="0" id="table3" height="147"> <tr> <td height="40" width="740" background="images/bg20.gif"> <table border="0" width="740" cellspacing="0" cellpadding="0" id="table4" height="31"> <tr> <td width="127"> </td> <td width="587"> <p align="center">地区:<b><% if request("gzdd")="0" then response.write "所有地区" else response.write request("gzdd") end if %> </b> 具体城市:<% if request("cs")="" then response.write "不限" else response.write request("cs") end if %> 职位类别:<b> <% if request("job")="0" then response.write "所有类别" else response.write request("job") end if %> </b> 职位关键字:<b> <% if request("what")="" then response.write "所有" else response.write request("what") end if %></b> 专业:<b> <% if request("zy")="" then response.write "不限专业" else response.write request("zy") end if %> </b>性别:<b> <% if request("sex")="" then response.write "不限" else response.write request("sex") end if %> </b> 找到记录:<b><font color=#ff0000><%=rs.recordcount%></font></b></td> </tr> </table> </td> </tr> <tr> <td valign="top" align="center"> <% if rs.recordcount=0 then rs.close response.write "<br>暂时没有相关人才信息!可能有以下原因:<br>1)人才库中没有相应的人才;<br>2)你指定的条件间相互矛盾;<br><br><font color=#ff0000>建议你放宽查询条件再试!!</font>" else rs.pagesize=20 if request("action")="n" then session("page")=session("page")+1 else if request("action")="p" then session("page")=session("page")-1 else if request("action")="f" then session("page")=1 else if request("action")="l" then session("page")=rs.pagecount else if isnumeric(request("page1"))=true then session("page")=clng(request("page1")) else session("page")=1 end if end if end if end if end if if session("page")>rs.pagecount then session("page")=rs.pagecount if session("page")<1 then session("page")=1 rs.absolutepage=session("page") %> <table border="0" width="100%" cellspacing="0" cellpadding="0" id="table5" height="92"> <tr> <td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="77" align="center"> <b>姓 名</b></td> <td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="176" align="center"> <b>应 聘 职 位</b></td> <td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="173" align="center"> <b>应 聘 者 专 业</b></td> <td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="102" align="center"><strong>希望工作地区</strong></td> <td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="60" align="center"> <b>性别</b></td> <td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="52" align="center"> <b>学历</b></td> <td height="30" bgcolor="#A5DDED" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="106" align="center"> <b>日 期</b></td> </tr> <% for ii=1 to 20 %> <tr> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="77" height="30" align="center" background="images/bg9.gif"><a target =_blank href="person.asp?id=<%=rs("id")%>"><%=rs("name")%></a></td> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="176" height="30" align="center" background="images/bg9.gif"><% if isnull(rs("job1"))then response.write rs("zhuanyen1")+"类职位" else response.write rs("job1") end if %></td> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="173" height="30" align="center" background="images/bg9.gif"><%=rs("zhuanyen1")%></td> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="102" height="30" align="center" background="images/bg9.gif"><%=rs("gzdd")%>. <%=rs("gzcs")%></td> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="60" height="30" align="center" background="images/bg9.gif">[<%=rs("sex")%>]</td> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="52" height="30" align="center" background="images/bg9.gif">[<%=rs("edu")%>]</td> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="106" height="30" align="center" background="images/bg9.gif"><% a=instr(rs("rdate"),chr(32))-1 response.write Mid(rs("rdate"),1,a) %> </td> </tr> <% rs.movenext if rs.eof then exit for next %> <tr> <td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; " width="734" height="42" align="center" colspan="7"><table border="0" width="504" cellspacing="0" cellpadding="0" height="31"> <tr> <td width="120"> <p align="center">当前页码:<font color="#FF0000"><%=session("page")%></font>/<%=rs.pagecount%></td> <td width="225"> <p align="center">< <a href="psearchp.asp?action=f&gzdd=<%=request("gzdd")%>&job=<%=request("job")%>&date=<%=request("date")%>&what=<%=request("what")%>">首页</a> <a href="psearchp.asp?action=p&gzdd=<%=request("gzdd")%>&job=<%=request("job")%>&date=<%=request("date")%>&what=<%=request("what")%>">上一页</a> <a href="psearchp.asp?action=n&gzdd=<%=request("gzdd")%>&job=<%=request("job")%>&date=<%=request("date")%>&what=<%=request("what")%>">下一页</a> <a href="psearchp.asp?action=l&gzdd=<%=request("gzdd")%>&job=<%=request("job")%>&date=<%=request("date")%>&what=<%=request("what")%>">尾页</a> ></td> <form method="POST" action="psearchp.asp?gzdd=<%=request("gzdd")%>&job=<%=request("job")%>&date=<%=request("date")%>&what=<%=request("what")%>"> <td width="159"> <p>跳转到 <input type="text" name="page1" size="4" style="border: 1px solid #000000"> 页 <input type="submit" value="提交" name="B1"></p> </td> </form> </tr> </table> </td> </tr> </table> <% rs.close end if %> </td> </tr> </table> </div> </td> </tr> </table> </div> </td> </tr> </table> </div> <% set rs=nothing set conn=nothing %> <!--#include file="base.asp"--> </body> </html>