www.gusucode.com > ASP+ACCESS在线人才招聘网(源代码+论文) > ASP+ACCESS在线人才招聘网(源代码+论文)\company_searchperson.asp
<!--#include file="inc/conn.asp"-->
<%Set Rs=Server.CreateObject("Adodb.RecordSet")%>
<HTML><!-- #BeginTemplate "/Templates/company.dwt" --><HEAD>
<!-- #BeginEditable "doctitle" -->
<TITLE>在线人才网站</TITLE>
<!-- #EndEditable -->
<META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
href="inc/cssset.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff text=#000000 leftmargin="0" topmargin="0">
<center><!--#include file="inc/head.asp"--><TABLE height=503 cellSpacing=0 cellPadding=0 width="770" border=0>
<TBODY>
<TR>
<TD vAlign=top width="22%" background="images/11.gif">
<TABLE height=251 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD background=images/arrowbg.jpg height=5>
<SCRIPT language=JavaScript>
<!--
var enabled = 0; today = new Date();
var day; var date;
if(today.getDay()==0) day = "星期日"
if(today.getDay()==1) day = "星期一"
if(today.getDay()==2) day = "星期二"
if(today.getDay()==3) day = "星期三"
if(today.getDay()==4) day = "星期四"
if(today.getDay()==5) day = "星期五"
if(today.getDay()==6) day = "星期六"
date = "<font color='##FF0000' > " + (today.getYear()) + "年" + (today.getMonth() + 1 ) + "月" + today.getDate() + "日 " + " " + day + "</font>";
document.write(date);
//----->
</SCRIPT>
<SCRIPT language=javascript src="inc/Keane_Common.js"></SCRIPT> </TD>
</TR>
<TR>
<TD vAlign=top background=images/arrowbg.jpg height=356>
<table class=a10px height=114 cellspacing=2 cellpadding=0 width="88%"
background=images/11.gif border=0>
<tbody>
<tr bgcolor=#ffffff background="images/11.gif">
<td colspan=2 height=21><img height=16 src="images/10.gif"
width=169></td>
</tr>
<tr>
<td valign=bottom align=right width=160 background=images/11.gif
height=5></td>
<td height=5></td>
</tr>
<tr>
<td valign=top align=center width=160 background=images/11.gif
height=75><!--#include file="sysinfo.asp"--></td>
<td height=75></td>
</tr>
</tbody>
</table>
<table class=a10px height=114 cellspacing=2 cellpadding=0 width="88%"
background=images/11.gif border=0>
<tbody>
<tr bgcolor=#ffffff background="images/11.gif">
<td colspan=2 height=21><img height=16 src="images/mycompany.gif"
width=169></td>
</tr>
<tr>
<td valign=bottom align=right width=160 background=images/11.gif
height=5></td>
<td height=5></td>
</tr>
<tr>
<td valign=top align=center width=160 background=images/11.gif
height=31>
<!--#include file="company_left.asp"--></td>
<td height=31></td>
</tr>
</tbody>
</table>
</TD>
</TR>
</TABLE>
<TABLE class=a10px height=114 cellSpacing=2 cellPadding=0 width="88%"
background=images/11.gif border=0>
<TBODY>
<TR bgColor=#ffffff background="images/11.gif">
<TD colSpan=2 height=21><IMG height=16 src="images/10.gif"
width=169></TD>
</TR>
<TR>
<TD vAlign=bottom align=right width=160 background=images/11.gif
height=5></TD>
<TD height=5></TD>
</TR>
<TR>
<TD vAlign=top align=right width=160 background=images/11.gif
height=264>
<SELECT
onchange=window.open(this.options[this.selectedIndex].value); size=10
name=select2>
<OPTION value=http://www.newjobs.com.cn/
selected>中国国家人才网</OPTION>
<OPTION
value=http://www.bjrc.com.cn/>北京人才网</OPTION>
<OPTION
value=http://www.91student.com>中国就业网</OPTION>
<OPTION
value=http://www.tjrc.com.cn/>中国北方人才市场</OPTION>
<OPTION
value=http://www.hr.net.cn/>中国上海人才市场</OPTION>
<OPTION
value=http://www.aphr.org/>亚太人力资源网</OPTION>
<OPTION
value=http://www.54stu.com/2002/login.php>中国学生社区</OPTION>
<OPTION
value=http://www.china-training.com/>中华培训网</OPTION>
<OPTION
value=http://www.fescochina.com/>外企在线</OPTION>
<OPTION
value=http://www.gzscse.gov.cn/>广州留学人员信息网</OPTION>
<OPTION
value=http://www.syrc.com.cn/>沈阳人才网</OPTION>
<OPTION
value=http://www.chinahrd.net/>中国人力资源开发网</OPTION>
<OPTION
value=http://www.cccen.com/>中国谦龙网</OPTION>
<OPTION
value=http://www.gzpi.gov.cn/>中国广州人事信息网</OPTION>
<OPTION
value=http://www.rc114.com/>中国成都人才市场</OPTION>
<OPTION
value=http://www.strc.com.cn/>汕头人才网</OPTION>
<OPTION
value=http://www.wzjob.gov.cn/>温州人才网</OPTION>
<OPTION
value=http://www.job168.com/service/navigation.asp>更多链接……</OPTION>
</SELECT>
</TD>
<TD height=264></TD>
</TR>
</TBODY>
</TABLE>
</TD>
<TD vAlign=top>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height=6></td>
</tr>
</table>
<!-- #BeginEditable "a1" -->
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="544">
<tr>
<td valign="top" align="center"><script language=javascript>
function showpersondetail(id)
{
window.open("person_detail.asp?per_id="+id,"_blank","height=350,width=790,top=0,left=0,menubar=yes,location=yes,scrollbars=yes,resizeble=yes,toolbar=yes")
}
</script>
<%jobfunction=Request("jobfunction")
gender=request("gender")
jobtype=Request("jobtype")
workseat=Request("workseat")
study=Request("study")
membertype=Request("membertype")
filego="company_searchperson.asp?jobfunction="&jobfunction&"&gender="&gender&"&jobtype="&jobtype&"&workseat="&workseat&"&study="&study&"&membertype="&membertype
sql="select per_id,name,gender,main_name1,sub_name1,jobtype,study,regtime from job_person_detail where 1=1 "
if jobfunction<>"0" then
if instrrev(jobfunction,"ss")>0 then
main_id=mid(jobfunction,3)
sql=sql&" and (main_id1="&main_id&" or main_id2="&main_id&" or main_id3="&main_id&") "
else
sub_id=jobfunction
sql=sql&" and (sub_id1="&sub_id&" or sub_id2="&sub_id&" or sub_id3="&sub_id&") "
end if
end if
if gender<>"0" then
sql=sql&" and gender='"&gender&"'"
end if
if jobtype<>"0" then
sql=sql&" and jobtype='"&jobtype&"'"
end if
if workseat<>"0" then
sql=sql&" and (worksite1='"&workseat&"' or worksite2='"&workseat&"' or worksite3='"&workseat&"') "
end if
if study<>"0" then
sql=sql&" and study='"&study&"'"
end if
if membertype<>0 then
sql=sql&" and membertype="&membertype
end if
sql=sql&" order by per_id desc"
Rs.Open sql,conn,1,1
If Not rs.Eof Then
Rs.PageSize=50
If Request("page")<>"" and IsNumeric(Request("page")) Then
page=cint(Request("page"))
End If
if page<=0 then
page=1
end if
if page>Rs.PageCount then
page=Rs.PageCount
end if
Rs.AbsolutePage=page
currentpage=page
RowCount =rs.pagesize
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="middle" align="center" height="37">人才查找</td>
</tr>
</table>
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="right"><b>共<%=Rs.RecordCount%>条符合条件的记录 </b></td>
<td align="right">第<%=currentpage%>页/共<%=Rs.pageCount%>页
<%if currentpage>1 then%>
<a href="<%=filego%>&page=<%=currentpage-1%>">上一页</a>
<%else Response.Write"上一页" end if%>
<%if currentpage<Rs.PageCount then%>
<a href="<%=filego%>&page=<%=currentpage+1%>">下一页</a>
<%else Response.Write"下一页" end if%>
<a href="<%=filego%>&page=1"> 首页</a> <a href="<%=filego%>&page=<%=Rs.PageCount%>">
尾页</a></td>
</tr>
</table>
<table width="94%" border="0" cellspacing="1" cellpadding="0">
<tr align="center" bgcolor="#ABC7E2">
<td width="12%" height="20">姓名</td>
<td width="6%" height="20">性别</td>
<td width="42%" height="20">所求职位</td>
<td width="9%" height="20">求职</td>
<td width="14%" height="20">学历</td>
<td width="17%" height="20">注册时间</td>
</tr>
<%
while not rs.eof and rowcount>0
%>
<tr align="center" bgcolor="#F1F5FA">
<td width="12%" height="20"> <a href=javascript:showpersondetail('<%=Rs("per_id")%>')><%=Rs("name")%></a></td>
<td width="6%" height="20"><%=Rs("gender")%></td>
<td width="42%" height="20"><%=Rs("sub_name1")%></td>
<td width="9%" height="20"><%=Rs("jobtype")%></td>
<td width="14%" height="20"><%=Rs("study")%></td>
<td width="17%" height="20">[<%=year(Rs("regtime"))%>-<%=month(Rs("regtime"))%>-<%=day(Rs("regtime"))%>]</td>
</tr>
<%
Rs.MoveNext
rowcount=rowcount-1
Wend%>
</table>
<%else%>没有符合条件的记录
<%end if%></td>
</tr>
</table>
<!-- #EndEditable --> </TD>
</TR>
</TABLE>
<!--#include file="inc/bottom.asp"-->
</center></BODY><!-- #EndTemplate --></HTML>