📄 per_search_base_.asp
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<%
Dim SQL,Rs
Dim JobClass,Area,PublishDate,Key,KeyClass
Dim JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time
'//获取参数
JobClass = Replace_Text(Request("slt_subcategory"))
Area = Replace_Text(Request("slt_workplacecity"))
PublishDate = Replace_Text(Request("PublishDate"))
Key = Replace_Text(Request("Key"))
KeyClass = Replace_Text(Request("KeyClass"))
Work = Split(Area,"-")
'//组织查询参数
SQL = "Select I.Perid,I.RealName,I.Sex,I.Edus,I.Age,I.LastSchool,I.Speciality,I.ResumeMode,I.WorkWill1,B.LastUpdate_Time From pH_Person_Base As B,pH_Person_Info As I Where B.Perid=I.Perid And Len(I.RealName)>0 And I.ResumeKeep<>1 And DateDiff(d,B.LastUpdate_Time,Getdate())<"&PublishDate
'//判断搜索职位还是姓名
If KeyClass = 1 Then
SQL = SQL&" And (I.WorkWill1 Like '%"&Key&"%' or I.WorkWill2 Like '%"&Key&"%' or I.WorkWill3 Like '%"&Key&"%')"
Else
SQL = SQL&" And I.RealName Like '%"&Key&"%'"
End if
'//职位类别
If JobClass <> "0-0" Then
SQL = SQL&" And (I.WorkWillClass1 Like '%"&JobClass&"%' or I.WorkWillClass2 Like '%"&JobClass&"%' or I.WorkWillClass3 Like '%"&JobClass&"%')"
End if
'//意向工作地区
If Area <> "不限-不限" Then
SQL = SQL&" And (I.AreaWill1 Like '%"&Work(0)&Work(1)&"%' or I.AreaWill2 Like '%"&Work(0)&Work(1)&"%' or I.AreaWill3 Like '%"&Work(0)&Work(1)&"%')"
End if
'//设置排序的方式
SQL = SQL&" Order By B.LastUpdate_Time Desc"
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.open SQL,Conn,1,1
Rs.Pagesize = 20
Psize = Rs.PageSize
PCount = Rs.PageCount
RCount = Rs.RecordCount
PageNo = Cint(Request.QueryString("PageNo"))
If PageNo < 1 Then
PageNo = 1
Elseif PageNo > PCount Then
PageNo = PCount
End if
If Not Rs.Eof Then Rs.AbsolutePage = PageNo
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<script language="JavaScript" src="../js/Company_Basicinfo.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../Css/Style.css" type=text/css rel=stylesheet>
<title><%= Cls_WebName %> -- 职位搜索</title>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td><!--#include file="../Include/Header.asp" --></td>
</tr>
</table>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td align="center">
<table width="760" border="0" cellspacing="0" cellpadding="4">
<tr>
<td width="50%" height="25">共<Font color="#FF0000"><%= RCount %></Font>条 分<Font color="#FF0000"><%= PCount %></Font>页 | 当前第<Font color="#FF0000"><%= PageNo %></Font>页</td>
<td width="50%" align="right">
<%
If PageNo > 1 Then
Response.write "<a href=""?PageNo=1&slt_subcategory="&JobClass&"&slt_workplacecity="&Area&"&PublishDate="&PublishDate&"&Key="&Key&"&KeyClass="&KeyClass&""">首页</a> "
Response.write "<a href=""?PageNo="&PageNo-1&"&slt_subcategory="&JobClass&"&slt_workplacecity="&Area&"&PublishDate="&PublishDate&"&Key="&Key&"&KeyClass="&KeyClass&""">上页</a> "
Else
Response.write "首页 "
Response.write "上页 "
End if
%>
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)" style="width:40px;">
<% For i = 1 to PCount %>
<option value="?PageNo=<%= i %>&slt_subcategory=<%= JobClass %>&slt_workplacecity=<%= Area %>&PublishDate=<%= PublishDate %>&Key=<%= Key %>&KeyClass=<%= KeyClass %>" <% If i = PageNo Then Response.write "Selected"%>><%=i%></option>
<% Next %>
</select>
<%
If PageNo < PCount Then
Response.write "<a href=""?PageNo="&PageNo+1&"&slt_subcategory="&JobClass&"&slt_workplacecity="&Area&"&PublishDate="&PublishDate&"&Key="&Key&"&KeyClass="&KeyClass&""">下页</a> "
Response.write "<a href=""?PageNo="&PCount&"&slt_subcategory="&JobClass&"&slt_workplacecity="&Area&"&PublishDate="&PublishDate&"&Key="&Key&"&KeyClass="&KeyClass&""">尾页</a>"
Else
Response.write "下页 "
Response.write "尾页"
End if
%>
</td>
</tr>
</table>
<table width="760" border="0" cellpadding="2" cellspacing="1" bgcolor="eeeeee">
<tr>
<td valign="top" bgcolor="#FFFFFF">
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1">
<tr align="center">
<td width="10%" height="25" bgcolor="eeeeee">姓 名</td>
<td width="7%" height="25" bgcolor="eeeeee">性 别</td>
<td width="7%" bgcolor="eeeeee">年 龄</td>
<td width="8%" bgcolor="eeeeee">学 历</td>
<td width="20%" height="25" bgcolor="eeeeee">毕业学校</td>
<td width="19%" height="25" bgcolor="eeeeee">所学专业</td>
<td width="19%" height="25" bgcolor="eeeeee">求职意向</td>
<td height="25" bgcolor="eeeeee">发布日期</td>
</tr>
<%
'------------------------------------------设置固顶-------------------------------
SQL = "Select Top "&Cls_PersonTopNumber&" I.Perid,I.RealName,I.Sex,I.Edus,I.Age,I.LastSchool,I.Speciality,I.ResumeMode,I.WorkWill1,B.LastUpdate_Time From pH_Person_Base As B,pH_Person_Info As I Where B.Perid=I.Perid And Len(I.RealName)>0 And I.ResumeKeep<>1 And I.TopAll=1 And DateDiff(d,TopDate,GetDate())>=0 And DateDiff(d,TopEndDate,GetDate())<=0 Order By B.LastUpdate_Time Desc"
Set Rs1 = Server.CreateObject("ADODB.Recordset")
Rs1.open SQL,Conn,1,1
For i = 1 to Psize/2
If Rs1.Eof Then Exit For
Perid = Rs1(0)
RealName = Rs1(1)
Sex = Rs1(2)
Edus = Rs1(3)
Age = Rs1(4)
LastSchool = Rs1(5)
Speciality = Rs1(6)
ResumeMode = Rs1(7)
WorkWill1 = Rs1(8)
LastUpdate_Time = FormatDateTime(Rs1(9),2)
If Len(ResumeMode) < 1 Then ResumeMode = 1
%>
<tr>
<td height="25" align="center"><a href="../Person/Resume/Resume_<%= ResumeMode %>.asp?Param-<%= Perid %>.html" target="_blank"><font color="#FF0000"><%= RealName %></font></a></td>
<td height="25" align="center"><font color="#FF0000"><%= Cls_Sex(Sex) %></font></td>
<td height="25" align="center"><font color="#FF0000"><%= Age %></font></td>
<td height="25" align="center"><font color="#FF0000"><%= Cls_Edus(Edus) %></font></td>
<td height="25" align="left"><font color="#FF0000"><%= LastSchool %></font></td>
<td height="25" align="left"><font color="#FF0000"><%= Speciality %></font></td>
<td height="25" align="left"><font color="#FF0000"><%= WorkWill1 %></font></td>
<td height="25" align="center"><font color="#FF0000"><%= LastUpdate_Time %></font></td>
</tr>
<%
Rs1.Movenext
If Rs1.Eof Then Exit For
Perid = Rs1(0)
RealName = Rs1(1)
Sex = Rs1(2)
Edus = Rs1(3)
Age = Rs1(4)
LastSchool = Rs1(5)
Speciality = Rs1(6)
ResumeMode = Rs1(7)
WorkWill1 = Rs1(8)
LastUpdate_Time = FormatDateTime(Rs1(9),2)
If ResumeMode = null Then ResumeMode = 1
%>
<tr bgcolor="f9f9f9">
<td height="25" align="center"><a href="../Person/Resume/Resume_<%= ResumeMode %>.asp?Param-<%= Perid %>.html" target="_blank"><font color="#FF0000"><%= RealName %></font></a></td>
<td height="25" align="center"><font color="#FF0000"><%= Cls_Sex(Sex) %></font></td>
<td height="25" align="center"><font color="#FF0000"><%= Age %></font></td>
<td height="25" align="center"><font color="#FF0000"><%= Cls_Edus(Edus) %></font></td>
<td height="25" align="left"><font color="#FF0000"><%= LastSchool %></font></td>
<td height="25" align="left"><font color="#FF0000"><%= Speciality %></font></td>
<td height="25" align="left"><font color="#FF0000"><%= WorkWill1 %></font></td>
<td height="25" align="center"><font color="#FF0000"><%= LastUpdate_Time %></font></td>
</tr>
<%
Rs1.Movenext
Next
Rs1.Close
Set Rs1= Nothing
'------------------------------------------固顶结束-------------------------------
For i = 1 to Psize/2
If Rs.Eof Then Exit For
Perid = Rs(0)
RealName = Rs(1)
Sex = Rs(2)
Edus = Rs(3)
Age = Rs(4)
LastSchool = Rs(5)
Speciality = Rs(6)
ResumeMode = Rs(7)
WorkWill1 = Rs(8)
LastUpdate_Time = FormatDateTime(Rs(9),2)
If Len(ResumeMode) < 1 Then ResumeMode = 1
%>
<tr>
<td height="25" align="center"><a href="../Person/Resume/Resume_<%= ResumeMode %>.asp?Param-<%= Perid %>.html" target="_blank"><%= RealName %></a></td>
<td height="25" align="center"><%= Cls_Sex(Sex) %></td>
<td height="25" align="center"><%= Age %></td>
<td height="25" align="center"><%= Cls_Edus(Edus) %></td>
<td height="25" align="left"><%= LastSchool %></td>
<td height="25" align="left"><%= Speciality %></td>
<td height="25" align="left"><%= WorkWill1 %></td>
<td height="25" align="center"><%= LastUpdate_Time %></td>
</tr>
<%
Rs.Movenext
If Rs.Eof Then Exit For
Perid = Rs(0)
RealName = Rs(1)
Sex = Rs(2)
Edus = Rs(3)
Age = Rs(4)
LastSchool = Rs(5)
Speciality = Rs(6)
ResumeMode = Rs(7)
WorkWill1 = Rs(8)
LastUpdate_Time = FormatDateTime(Rs(9),2)
If ResumeMode = null Then ResumeMode = 1
%>
<tr bgcolor="f9f9f9">
<td height="25" align="center"><a href="../Person/Resume/Resume_<%= ResumeMode %>.asp?Param-<%= Perid %>.html" target="_blank"><%= RealName %></a></td>
<td height="25" align="center"><%= Cls_Sex(Sex) %></td>
<td height="25" align="center"><%= Age %></td>
<td height="25" align="center"><%= Cls_Edus(Edus) %></td>
<td height="25" align="left"><%= LastSchool %></td>
<td height="25" align="left"><%= Speciality %></td>
<td height="25" align="left"><%= WorkWill1 %></td>
<td height="25" align="center"><%= LastUpdate_Time %></td>
</tr>
<%
Rs.Movenext
Next
%>
</table>
</td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="4">
<tr>
<td width="50%" height="25">共<Font color="#FF0000"><%= RCount %></Font>条 分<Font color="#FF0000"><%= PCount %></Font>页 | 当前第<Font color="#FF0000"><%= PageNo %></Font>页</td>
<td width="50%" align="right">
<%
If PageNo > 1 Then
Response.write "<a href=""?PageNo=1&slt_subcategory="&JobClass&"&slt_workplacecity="&Area&"&PublishDate="&PublishDate&"&Key="&Key&"&KeyClass="&KeyClass&""">首页</a> "
Response.write "<a href=""?PageNo="&PageNo-1&"&slt_subcategory="&JobClass&"&slt_workplacecity="&Area&"&PublishDate="&PublishDate&"&Key="&Key&"&KeyClass="&KeyClass&""">上页</a> "
Else
Response.write "首页 "
Response.write "上页 "
End if
%>
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)" style="width:40px;">
<% For i = 1 to PCount %>
<option value="?PageNo=<%= i %>&slt_subcategory=<%= JobClass %>&slt_workplacecity=<%= Area %>&PublishDate=<%= PublishDate %>&Key=<%= Key %>&KeyClass=<%= KeyClass %>" <% If i = PageNo Then Response.write "Selected"%>><%=i%></option>
<% Next %>
</select>
<%
If PageNo < PCount Then
Response.write "<a href=""?PageNo="&PageNo+1&"&slt_subcategory="&JobClass&"&slt_workplacecity="&Area&"&PublishDate="&PublishDate&"&Key="&Key&"&KeyClass="&KeyClass&""">下页</a> "
Response.write "<a href=""?PageNo="&PCount&"&slt_subcategory="&JobClass&"&slt_workplacecity="&Area&"&PublishDate="&PublishDate&"&Key="&Key&"&KeyClass="&KeyClass&""">尾页</a>"
Else
Response.write "下页 "
Response.write "尾页"
End if
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td>
<!--#include file="../Include/Footer.asp" -->
</td>
</tr>
</table>
</body>
</html>
<%
Rs.Close
Set Rs = Nothing
Call CloseDB
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -