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

📄 per_search_areawillclass.asp

📁 直接附加数据库! 修改 Include/ Class_Main.asp 为自己信息 后台admin admin 绍兴人才网程序
💻 ASP
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Include/Class_Main.asp" -->

<% 
Dim SQL,Rs
Dim JobClass
Dim JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time
'//获取参数
JobClass           = Replace_Text(Request("Param"))

'//组织查询参数
SQL = "Select I.Perid,I.RealName,I.Sex,I.Edus,I.Age,I.LastSchool,I.Speciality,I.ResumeMode,I.WorkWill1,B.LastUpdate_Time,I.Appraise,I.PersonPhone From pH_Person_Base As B,pH_Person_Info As I  Where B.Perid=I.Perid And Len(I.RealName)>0"
'//职位类别
If JobClass <> "" Then
 SQL = SQL&" And (I.AreaWill1 Like '%"&JobClass&"%' or I.AreaWill2 Like '%"&JobClass&"%' or I.AreaWill3 Like '%"&JobClass&"%')"
End if
'//设置排序的方式
SQL = SQL&" Order By B.LastUpdate_Time Desc"

Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.open SQL,Conn,1,1
Rs.Pagesize = 28
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>
</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.asp" -->
<table width="956" border="0" cellspacing="0" cellpadding="0" align="center" height="5">
  <tr> 
    <td></td>
  </tr>
</table>
<table width="956" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td width="270" valign="top">
	<table width="270" border="0" cellspacing="0" cellpadding="0" class="table2">
              <tr class="td_4"> 
                <td height="29"><font class="td_4a">会员登陆</font></td>
              </tr>
              <tr> 
                <td valign="top"> 
                  <!--#include file="../Public/MemberSession.asp" -->
                </td>
              </tr>
            </table>
			            <table width="100%" border="0" cellspacing="0" cellpadding="0" height="4">
              <tr> 
                <td></td>
              </tr>
            </table>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
<form action="../Person/Per_Search_Base.asp" method="post" target="_blank" name="theForm" >
  <tr>
            <td align="center"> 
              <table width="100%" border="0" cellspacing="0" cellpadding="0" class="table2">
                <tr>
                  <td height="25"> 
                    <div align="center">
                      <select style="width:150px;"  id=select2 
                  name=slt_category>
                      </select>
                    </div>
                  </td>
                </tr>
                <tr>
                  <td height="25"> 
                    <div align="center">
                      <select style="width:150px;"  id=select3 
                  name=slt_subcategory>
                      </select>
                    </div>
                  </td>
                </tr>
                <tr>
                  <td height="25"> 
                    <div align="center">
                      <select  style="width:150px;" id=slt_workplacearea 
                  name=slt_workplacearea>
                      </select>
                    </div>
                  </td>
                </tr>
                <tr>
                  <td height="25"> 
                    <div align="center">
                      <select style="width:150px;" id=select 
                  name=slt_workplacecity>
                      </select>
                    </div>
                  </td>
                </tr>
                <tr>
                  <td height="25"> 
                    <div align="center">
                      <select style="width:150px;"  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>
                    </div>
                  </td>
                </tr>
                <tr>
                  <td height="25"> 
                    <div align="center">
                      <input name=key style="width:150px;"  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>
                    </div>
                  </td>
                </tr>
                <tr>
                  <td height="25"> 
                    <div align="center">
                      <input type="submit" name="Submit3" value=" 开 始 搜 索 ">
                      <input name="keyclass" type="hidden" id="keyclass" value="1">
                    </div>
                  </td>
                </tr>
              </table>
              
            </td>
  </tr>
 </form>
</table>
	<table width="100%" border="0" cellspacing="0" cellpadding="0" height="4">
              <tr> 
                <td></td>
              </tr>
            </table>
			<table width="100%" border="0" cellpadding="0" cellspacing="0" class="table2">
              <tr class="td_4"> 
                <td height="29"><font class="td_4a">面试指导</font></td>
              </tr>
              <tr> 
                <td> <%= Cls_News_List(8,8,18) %></td>
              </tr>
            </table>
            	<table width="100%" border="0" cellspacing="0" cellpadding="0" height="4">
              <tr> 
                <td></td>
              </tr>
            </table>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="table2">
              <tr class="td_4"> 
                <td height="29"><font class="td_4a">网站调查</font></td>
              </tr>
              <tr> 
                <td> 
                  <%
'****---------投票--------
	SQL="SELECT ID,TITLE,VOTETEXT,TYPE FROM pH_Vote WHERE Lock=0"
	Set Rs1=Conn.Execute(SQL)
	If Not Rs1.Eof And Not Rs1.Bof Then ds4=Rs1.getrows()
	Rs1.Close()			
	for i=0 to ubound(ds4,2)
	Response.Write CreateVote(ds4(0,i),ds4(1,i),ds4(2,i),ds4(3,i))
	next
	%>
                </td>
              </tr>
            </table>
		</td>
    <td width="5">&nbsp;</td>
    <td valign="top"> 
      <table width="100%" border="0" cellpadding="0" cellspacing="0" class="table2">
  <tr class="td_4"> 
    <td height="29"><font class="td_4a">人才搜索结果</font></td>
  </tr>
  <tr> 
          <td>
            <table border="0" align="center" cellpadding="2" cellspacing="1" width="670">
              <tr align="center"> 
                <td width="75" height="25" bgcolor="eeeeee">姓名</td>
                <td width="200" height="25" bgcolor="eeeeee">应聘岗位</td>
                <td width="37" bgcolor="eeeeee">性别</td>
                <td width="27" bgcolor="eeeeee">年龄</td>
                <td width="42" height="25" bgcolor="eeeeee">学历</td>
                <td width="131" height="25" bgcolor="eeeeee">所学专业</td>
                <td width="122" height="25" bgcolor="eeeeee">更新日期</td>
              </tr>
            </table>
            <table border="0" align="center" cellpadding="2" cellspacing="1" width="670">
			  <Form action="" method="post" name="theForm">
    <% 
For i = 1 to Psize
 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 = Rs(9)
 Appraise		 = Left(Rs(10),100)&"..."
 PersonPhone	 = Rs(11)
 If Len(ResumeMode) < 1 Then ResumeMode = 1
 %>
                <tr> 
                  <td width="76" height="25" align="center"><a href="../Person/Resume/Resume_<%= ResumeMode %>.asp?Param-<%= Perid %>.html" target="_blank"><%= RealName %></a></td>
                  <td width="200" height="25"><span class="font-14"><a href="../Person/Resume/Resume_<%= ResumeMode %>.asp?Param-<%= Perid %>.html" target="_blank"><b><font color="0000cc"><b><%= WorkWill1 %></b></font></b></a></span></td>
                  <td width="37" align="center"><%= Cls_Sex(Sex) %></td>
                  <td width="27" align="center"><%= Age %></td>
                  <td width="42" height="25" align="center"><%= Cls_Edus(Edus) %></td>
                  <td width="131" height="25"><%= Speciality %></td>
                  <td width="121" height="25"><%= LastUpdate_Time %></td>
              </tr>
			      <%
 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"">首页</a>&nbsp;"
		   Response.write "<a href=""?PageNo="&PageNo-1&""">上页</a>&nbsp;"    
		  Else
		   Response.write "首页&nbsp;"
		   Response.write "上页&nbsp;" 
		  End if
		   %>
        <select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
           <% For i = 1 to PCount %>
                <option value="?PageNo=<%= i %>" <% If i = PageNo Then Response.write "Selected"%>><%=i%></option>
		    <% Next %>
        </select>
      
      <% 
		  If PageNo < PCount Then
		   Response.write "<a href=""?PageNo="&PageNo+1&""">下页</a>&nbsp;"
		   Response.write "<a href=""?PageNo="&PCount&""">尾页</a>"   
		  Else
		   Response.write "下页&nbsp;"
		   Response.write "尾页" 
		  End if
		   %>
    </td>
  </tr>
</table>
		  </td>
  </tr>
</table>
	</td>
  </tr>
</table>
<SCRIPT language=javascript>
window.onload	=	function(){HigheLine("<%= Key %>");}
</SCRIPT>
<!--#include file="../Include/Footer.asp" -->
</body>
</html>
<% 
Call CloseDB
 %>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -