⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 per_search_all.asp

📁 直接附加数据库! 修改 Include/ Class_Main.asp 为自己信息 后台admin admin 绍兴人才网程序
💻 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)
UserName         = Session("Person")(0)
'//获取参数
 Save1           = Replace_Text(Request("Save"))     
 Searcher_Name   = Replace_Text(Request("Name"))
 JobClass        = Replace_Text(Request("slt_subcategory"))
 Work            = Replace_Text(Request("slt_workplacecity"))
 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"))
 Locus_Area      = Replace_Text(Request("x_suozaidi"))
 Locus_City      = Replace_Text(Request("x_suozaidi1"))
 Work1           = Work
 Work            = Split(Work,"-")
'Response.Write Request("slt_workplacecity")
'Response.End()
'//判断是否保存到搜索器
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_Person_Searcher] Where Perid='"&Perid&"'"
 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_Person_Searcher]  (Perid,UserName,Searcher_Name,WorkWillClass,Area,City,PublishDate,Edus,Works,Sex,MinAge,MaxAge,Locus_Area,Locus_City) Values ('"&Perid&"','"&Username&"','"&Searcher_Name&"','"&JobClass&"','"&Work(0)&"','"&Work(1)&"',"&PublishDate&","&Edus&","&Works&","&Sex&","&MinAge&","&MaxAge&",'"&Locus_Area&"','"&Locus_City&"')"
 Conn.Execute(SQL)
End if

'//组织查询语句
SQL = "Select JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time,Require,Number From [pH_Job_Base] Where JobFlag=1 And DateDiff(d,End_Date,GetDate())<=0"
'的工作岗位
If JobClass <> "0-0" Then
 SQL = SQL&" And JobClass Like '%"&JobClass&"%'"
End if
'的工作省份
If Work(0) <> "不限" Then
 SQL = SQL&" And Work_Area  Like '%"&Work(0)&"%'"
End if
'的工作城市
If Work(1) <> "不限" Then
 SQL = SQL&" And Work_City Like '%"&Work(1)&"%'"
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>&nbsp;</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")
 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(Rs("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&slt_subcategory="&JobClass&"&slt_workplacecity="&Work1&"&PublishDate="&PublishDate&"&Edus="&Edus&"&Works="&Works&"&Sex="&Sex&"&Min_Age="&MinAge&"&Max_Age="&MaxAge&"&x_suozaidi="&Locus_Area&"&x_suozaidi1="&Locus_City&""">首页</a>&nbsp;"
		   Response.write "<a href=""?PageNo="&PageNo-1&"&slt_subcategory="&JobClass&"&slt_workplacecity="&Work1&"&PublishDate="&PublishDate&"&Edus="&Edus&"&Works="&Works&"&Sex="&Sex&"&Min_Age="&MinAge&"&Max_Age="&MaxAge&"&x_suozaidi="&Locus_Area&"&x_suozaidi1="&Locus_City&""">上页</a>&nbsp;"    
		  Else
		   Response.write "首页&nbsp;"
		   Response.write "上页&nbsp;" 
		  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=<%= Work1 %>&PublishDate=<%= PublishDate %>&Edus=<%= Edus %>&Works=<%= Works %>&Sex=<%= Sex %>&Min_Age=<%= MinAge %>&Max_Age=<%= MaxAge %>&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&"&slt_subcategory="&JobClass&"&slt_workplacecity="&Work1&"&PublishDate="&PublishDate&"&Edus="&Edus&"&Works="&Works&"&Sex="&Sex&"&Min_Age="&MinAge&"&Max_Age="&MaxAge&"&x_suozaidi="&Locus_Area&"&x_suozaidi1="&Locus_City&""">下页</a>&nbsp;"
		   Response.write "<a href=""?PageNo="&PCount&"&slt_subcategory="&JobClass&"&slt_workplacecity="&Work1&"&PublishDate="&PublishDate&"&Edus="&Edus&"&Works="&Works&"&Sex="&Sex&"&Min_Age="&MinAge&"&Max_Age="&MaxAge&"&x_suozaidi="&Locus_Area&"&x_suozaidi1="&Locus_City&""">尾页</a>"   
		  Else
		   Response.write "下页&nbsp;"
		   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 + -