📄 com_search_all_.asp
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<!--#include file="../Public/Company_Cookies.asp" -->
<%
Dim SQL,Rs
Dim JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time
'//获取参数
Comid = Session("Company")(2)
UserName = Session("Company")(0)
Save1 = Replace_Text(Request("Save")) '是否保存
Searcher_Name = Replace_Text(Request("Name")) '搜索器名称
Skill = Replace_Text(Request("Skill")) '技能关键字
WorkWillClass = Replace_Text(Request("slt_selectedjobs")) '意向职位类别
AreaWill = Replace_Text(Request("slt_selectedplaces")) '意向工作地区
PublishDate = Replace_Text(Request("PublishDate"))
Edus = Replace_Text(Request("Edus"))
Works = Replace_Text(Request("Works"))
Sex = Replace_Text(Request("Sex"))
MinAge = Replace_Text(Request("Min_Age"))
MaxAge = Replace_Text(Request("Max_Age"))
Door_Area = Replace_Text(Request("door"))
Door_City = Replace_Text(Request("door1"))
Locus_Area = Replace_Text(Request("x_suozaidi"))
Locus_City = Replace_Text(Request("x_suozaidi1"))
AreaWill = Replace(AreaWill,"-","")
'//判断是否保存到搜索器
If Save1 = "1" Then
If Searcher_Name = "" Then
Response.Write "<script>alert('请输入搜索器名称...');window.close();</script>"
Response.End()
End if
'//检测该用户的搜索器是否达到3个
SQL = "Select Count(Ncid) From [pH_Company_Searcher] Where Comid='"&Comid&"'"
Set Rs = Conn.Execute(SQL)
If Rs(0) >= 3 Then
Response.Write "<script>alert('对不起！您已经创建了3个搜索器...');window.close();</script>"
Response.End()
End if
Rs.Close
'//将数据插入到数据库
SQL = "Insert Into [pH_Company_Searcher] (Comid,UserName,Searcher_Name,Skill_Key,PublishDate,AreaWill,Door_Area,Door_City,Locus_Area,Locus_City,Edus,Sex,MinAge,MaxAge,Works,WorkWillClass) Values ('"&Comid&"','"&Username&"','"&Searcher_Name&"','"&Skill&"',"&PublishDate&",'"&AreaWill&"','"&Door_Area&"','"&Door_City&"','"&Locus_Area&"','"&Locus_City&"',"&Edus&","&Sex&","&MinAge&","&MaxAge&","&Works&",'"&WorkWillClass&"')"
Conn.Execute(SQL)
End if
'//组织查询参数
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"
'//技能关键字
If Skill <> "" Then
SQL = SQL&" And I.Skill_Key Like '%"&Skill&"%'"
End if
'//意向职位类别
If WorkWillClass <> "0-0" Then
SQL = SQL&" And (I.WorkWillClass1 Like '%"&WorkWillClass&"%' or I.WorkWillClass2 Like '%"&WorkWillClass&"%' or I.WorkWillClass3 Like '%"&WorkWillClass&"%')"
End if
'//意向工作地区
If AreaWill <> "不限不限" Then
SQL = SQL&" And (I.AreaWill1 Like '%"&AreaWill&"%' or I.AreaWill2 Like '%"&AreaWill&"%' or I.AreaWill3 Like '%"&AreaWill&"%')"
End if
'//户口省份
If Door_Area <> "不限" Then
SQL = SQL&" And I.Door_Area='"&Door_Area&"'"
End if
'//户口城市
If Door_City <> "不限" Then
SQL = SQL&" And I.Door_City='"&Door_City&"'"
End if
'//更新日期
If PublishDate <> 0 Then
SQL = SQL&" And DateDiff(d,B.LastUpdate_Time,Getdate())<"&PublishDate
End if
'//学历
If Edus <> 0 Then
SQL = SQL&" And I.Edus>="&Cstr(Edus)
End if
'//工作经验
If Works <> 0 Then
SQL = SQL&" And I.Works>="&Cstr(Works)
End if
'//性别
If Sex <> 2 Then
SQL = SQL&" And I.Sex="&Cstr(Sex)
End if
'//年龄
If MinAge <> 0 And MaxAge <> 0 Then
SQL = SQL&" And I.Age<="&Cstr(MinAge)&" And I.Age>="&Cstr(MaxAge)
Elseif MinAge <> 0 And MaxAge = 0 Then
SQL = SQL&" And I.Age<="&Cstr(MinAge)
Elseif MinAge = 0 And MaxAge <> 0 Then
SQL = SQL&" And I.Age>="&Cstr(MaxAge)
End if
'//现所在省份
If Locus_Area <> "不限" Then
SQL = SQL&" And I.Locus_Area='"&Locus_Area&"'"
End if
'//现所在城市
If Locus_City <> "不限" Then
SQL = SQL&" And I.Locus_City='"&Locus_City&"'"
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&Skill="&Skill&"&slt_selectedjobs="&WorkWillClass&"&slt_selectedplaces="&AreaWill&"&PublishDate="&PublishDate&"&Edus="&Edus&"&Works="&Works&"&Sex="&Sex&"&Min_Age="&MinAge&"&Max_Age="&MaxAge&"&door="&Door_Area&"&door1="&Door_City&"&x_suozaidi="&Locus_Area&"&x_suozaidi1="&Locus_City&""">首页</a> "
Response.write "<a href=""?PageNo="&PageNo-1&"&Skill="&Skill&"&slt_selectedjobs="&WorkWillClass&"&slt_selectedplaces="&AreaWill&"&PublishDate="&PublishDate&"&Edus="&Edus&"&Works="&Works&"&Sex="&Sex&"&Min_Age="&MinAge&"&Max_Age="&MaxAge&"&door="&Door_Area&"&door1="&Door_City&"&x_suozaidi="&Locus_Area&"&x_suozaidi1="&Locus_City&""">上页</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 %>&Skill=<%= Skill %>&slt_selectedjobs=<%= WorkWillClass %>&slt_selectedplaces=<%= AreaWill %>&PublishDate=<%= PublishDate %>&Edus=<%= Edus %>&Works=<%= Works %>&Sex=<%= Sex %>&Min_Age=<%= MinAge %>&Max_Age=<%= MaxAge %>&door=<%= Door_Area %>&door1=<%= Door_City %>&x_suozaidi=<%= Locus_Area %>&x_suozaidi1=<%= Locus_City %>" <% If i = PageNo Then Response.write "Selected"%>><%=i%></option>
<% Next %>
</select>
<%
If PageNo < PCount Then
Response.write "<a href=""?PageNo="&PageNo+1&"&Skill="&Skill&"&slt_selectedjobs="&WorkWillClass&"&slt_selectedplaces="&AreaWill&"&PublishDate="&PublishDate&"&Edus="&Edus&"&Works="&Works&"&Sex="&Sex&"&Min_Age="&MinAge&"&Max_Age="&MaxAge&"&door="&Door_Area&"&door1="&Door_City&"&x_suozaidi="&Locus_Area&"&x_suozaidi1="&Locus_City&""">下页</a> "
Response.write "<a href=""?PageNo="&PCount&"&Skill="&Skill&"&slt_selectedjobs="&WorkWillClass&"&slt_selectedplaces="&AreaWill&"&PublishDate="&PublishDate&"&Edus="&Edus&"&Works="&Works&"&Sex="&Sex&"&Min_Age="&MinAge&"&Max_Age="&MaxAge&"&door="&Door_Area&"&door1="&Door_City&"&x_suozaidi="&Locus_Area&"&x_suozaidi1="&Locus_City&""">尾页</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">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -