📄 per_searcher_base.asp
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<%
Dim SQL,Rs
Dim Perid,Param
Dim JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time
'//获取参数
Perid = Session("Person")(2)
Param = Replace_Text(Request("Param"))
'//查询搜索器的数据 作为搜索条件
SQL = "Select * From [pH_Person_Searcher] Where Perid='"&Perid&"' And Ncid="&Cstr(Param)
Set Rs = Conn.Execute(SQL)
If Rs.Eof Then
Response.write "没有找到该搜索条件..."
Response.End()
Else
JobClass = Rs("WorkWillClass")
Work_Area = Rs("Area")
Work_City = Rs("City")
PublishDate = Rs("PublishDate")
Edus = Rs("Edus")
Works = Rs("Works")
Sex = Rs("Sex")
MinAge = Rs("MinAge")
MaxAge = Rs("MaxAge")
Locus_Area = Rs("Locus_Area")
Locus_City = Rs("Locus_City")
End if
Rs.Close
'//组织查询语句
SQL = "Select JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time,Require,Number From [pH_Job_Base] Where JobFlag=1"
'的工作岗位
If JobClass <> "0-0" Then
SQL = SQL&" And JobClass Like '%"&JobClass&"%'"
End if
'的工作省份
If Work_Area <> "不限" Then
SQL = SQL&" And Work_Area='"&Work_Area&"'"
End if
'的工作城市
If Work_City <> "不限" Then
SQL = SQL&" And Work_City='"&Work_City&"'"
End if
'更新日期
If PublishDate <> 0 Then
SQL = SQL&" And DateDiff(d,LastUpdate_Time,Getdate())<"&PublishDate
End if
'学历要求
If Edus <> 0 Then
SQL = SQL&" And Edus>="&Cstr(Edus)
End if
'工作年限
If Works <> 0 Then
SQL = SQL&" And Works>="&Cstr(Works)
End if
'性别
If Sex <> 2 Then
SQL = SQL&" And Sex="&Cstr(Sex)
End if
'年龄
If MinAge <> 0 And MaxAge <> 0 Then
SQL = SQL&" And Min_Age<="&Cstr(MinAge)&" And Max_Age>="&Cstr(MaxAge)
Elseif MinAge <> 0 And MaxAge = 0 Then
SQL = SQL&" And Min_Age<="&Cstr(MinAge)
Elseif MinAge = 0 And MaxAge <> 0 Then
SQL = SQL&" And Max_Age>="&Cstr(MaxAge)
End if
'现所在省份
If Locus_Area <> "不限" Then
SQL = SQL&" And Area='"&Locus_Area&"'"
End if
'现所在城市
If Locus_City <> "不限" Then
SQL = SQL&" And City='"&Locus_City&"'"
End if
SQL = SQL&" Order By 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>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../Css/Css.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>
<SCRIPT language=JavaScript src="../js/funlib.js"></SCRIPT>
<SCRIPT language=JavaScript src="../js/ua.js"></SCRIPT>
<SCRIPT language=JavaScript src="../js/ftiens4.js"></SCRIPT>
<SCRIPT language=JavaScript src="../js/persontreeviewnodes.js"></SCRIPT>
<SCRIPT language=JavaScript src="../js/areacityselector.js"></SCRIPT>
<SCRIPT language=JavaScript src="../js/joball.js"></SCRIPT>
<script language="JavaScript">
function openwin()
{
disp=window.open("","rslt","width=500,height=320,resizable=yes");
disp.focus();
}
</script>
<body>
<!--#include file="../Include/Header_New.asp" -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<form action="../Company/Com_Search_Base.asp" method="post" target="_blank" name="theForm">
<tr>
<td height="10"></td>
</tr>
<tr>
<td height="25" align="center" bgcolor="f5f5f5"><strong>职位搜索</strong>
<select style="width:100px;" id=select2
name=slt_category>
</select>
<select style="width:100px;" id=select3
name=slt_subcategory>
</select>
<select style="width:100px;" id=slt_workplacearea
name=slt_workplacearea>
</select>
<select style="width:100px;" id=select
name=slt_workplacecity>
</select>
<select style="width:60px;" name=publishdate>
<option value=1>近一天</option>
<option value=2>近二天</option>
<option value=3>近三天</option>
<option value=7>近一周</option>
<option value=14>近两周</option>
<option value=30>近一月</option>
<option value=60>近两月</option>
<option value=90>近三月</option>
</select>
<input name=key style="width:100px;" id=txt_keyword2 size="16" maxlength=50 >
<SCRIPT language=JavaScript>
var objJobCPSelector, objJobCCSelector, objAreaSelector, objCitySelector
objAreaSelector = new PlaceAssociateList(document.theForm.slt_workplacearea, null, document.theForm.slt_workplacecity, ALOptions);
objAreaSelector.addedOptions = new Array("不限-|工作地区不限");
objAreaSelector.init();
objCitySelector = new PlaceAssociateList(document.theForm.slt_workplacecity, document.theForm.slt_workplacearea, null, CLOptions);
objCitySelector.incPValue = true;
objCitySelector.incPValueFormat = "%PText%－不限"
objCitySelector.addedOptions = new Array("不限-不限|不限");
objCitySelector.init();
objJobCPSelector = new JobCategoryAssociateList(document.theForm.slt_category, null, document.theForm.slt_subcategory, PCLOptions);
objJobCPSelector.addedOptions = new Array("0-|职位类别不限");
objJobCPSelector.init();
objJobCCSelector = new JobCategoryAssociateList(document.theForm.slt_subcategory, document.theForm.slt_category, null, CCLOptions);
objJobCCSelector.incPValue = true;
objJobCCSelector.incPValueFormat = "%PText%－不限"
objJobCCSelector.addedOptions = new Array("0-0|不限");
objJobCCSelector.init();
</SCRIPT>
<input type="submit" name="Submit3" value=" 搜 索 ">
<input name="keyclass" type="hidden" id="keyclass" value="1"></td>
</tr>
</form>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<Form action="" method="post" name="theForm">
<%
For i = 1 to Psize
If Rs.Eof Then Exit For
JobId = Rs("JobId")
Comid = Rs("Comid")
JobName = Rs("JobName")
Work_Area = Rs("Work_Area")
Work_City = Rs("Work_City")
Edus = Rs("Edus")
Deal = Rs("Deal")
LastUpdate_Time = Rs("LastUpdate_Time")
Require = Left(Rs("Require"),100)&"..."
Number1 = Rs("Number")
'//企业名称
Vip = 0
Set Re = Conn.Execute("Select CompanyName,Nc_Vip_Flag From [pH_Company_Base] Where Comid='"&Comid&"'")
If Not Re.Eof Then
CompanyName = Re("CompanyName")
Vip = Re("Nc_Vip_Flag")
End if
Re.Close
'//学历要求
If Edus = 0 Then
Edus_Str = "不限"
Else
Edus_Str = Cls_Edus(Edus)
End if
'//待遇
If Deal = 0 Then
Deal_Str = "面议"
Else
Deal_Str = Deal&"元"
End if
If Number1 = 0 Then Number1 = "若干"
Vip_Str = ""
If Vip = True Then Vip_Str = "<img src=""../Images/Company/Vip.gif"" align=""absmiddle"">"
%>
<tr>
<td height="30"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><DIV id=1><img src="../Images/Company.gif" width="20" height="20" align="absmiddle">
<a href="../Company/Info/Com_Job.asp?Comid-<%= Comid %>-Param-<%= Jobid %>.html" target="_blank" class="font-14"><b><font color="#ff3300"><%= JobName %></font></b></a></DIV></td>
<td width="30%" align="right">更新日期：<%= LastUpdate_Time %></td>
</tr>
</table></td>
</tr>
<tr>
<td height="2" bgcolor="#cccccc"></td>
</tr>
<tr>
<td height="25"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25">
<DIV id=1><font color="#0000cc">[企业]</font><%= Vip_Str %><a href="../Company/Info/Com_View.asp?Param-<%= Comid %>.html" target="_blank"><%= CompanyName %></a> <font color="#0000cc">[人数]</font><%= Number1 %>人</DIV></td>
<td width="30%" align="right">
<a href="javascript:" onclick="window.open('Per_SendApplication.asp?ncid=<%= Jobid %>','rslt','width=500,height=320,resizable=yes');"><u>发送求职意向</u></a>
<a href="javascript:" onclick="javascript:window.open('Per_Option.asp?param=fav&ncid=<%= Jobid %>','rslt','width=500,height=320,resizable=yes');"><u>收藏该职位</u></a>
<a href="javascript:" onclick="window.open('Per_Friend.asp?ncid=<%= Jobid %>','rslt','width=500,height=320,resizable=yes');" ><u>推荐给好友</u></a></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25"><font color="0000cc">[工作地区]</font><%= Work_Area&Work_City %> <font color="0000cc">[学历要求]</font><%= Edus_Str %> <font color="0000cc">[薪资待遇]</font><%= Deal_Str %></td>
</tr>
<tr>
<td height="25"><DIV id=1><a href="../Company/Info/Com_Job.asp?Comid-<%= Comid %>-Param-<%= Jobid %>.html" target="_blank"><%= Require %></a></DIV></td>
</tr>
<tr>
<td height="1" bgcolor="#f5f5f5"></td>
</tr>
<tr>
<td height="10"></td>
</tr>
<input name="ncid" type="hidden" id="ncid" value="<%= JobId %>">
<%
Rs.Movenext
Next
%>
</Form>
</table>
<table width="99%" border="0" align="center" cellpadding="4" cellspacing="0">
<tr>
<td height="25" align="right">共<Font color="#FF0000"><%= RCount %></Font>条 分<Font color="#FF0000"><%= PCount %></Font>页 | 当前第<Font color="#FF0000"><%= PageNo %></Font>页
<%
If PageNo > 1 Then
Response.write "<a href=""?PageNo=1&Param="&Param&""">首页</a> "
Response.write "<a href=""?PageNo="&PageNo-1&"&Param="&Param&""">上页</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 %>&Param=<%= Param %>" <% If i = PageNo Then Response.write "Selected"%>><%=i%></option>
<% Next %>
</select>
<%
If PageNo < PCount Then
Response.write "<a href=""?PageNo="&PageNo+1&"&Param="&Param&""">下页</a> "
Response.write "<a href=""?PageNo="&PCount&"&Param="&Param&""">尾页</a>"
Else
Response.write "下页 "
Response.write "尾页"
End if
%> </td>
</tr>
</table>
<SCRIPT language=javascript>
window.onload = function(){HigheLine("<%= Key %>");}
</SCRIPT>
<!--#include file="../Include/Footer_New.asp" --></td>
</body>
</html>
<%
Rs.Close
Set Rs = Nothing
Call CloseDB
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -