📄 per_search_areaclass_.asp
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<!--#include file="../Public/Person_Cookies.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)
Param = Replace_Text(Request("Param"))
'//组织查询语句
SQL = "Select JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time From [pH_Job_Base] Where JobFlag=1 And DateDiff(d,End_Date,GetDate())<=0 And (Work_Area='"&Param&"' or Work_Area Like '%不限%')"
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>
<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&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>
<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="22%" height="25" bgcolor="eeeeee">职位名称</td>
<td width="30%" height="25" bgcolor="eeeeee">企业名称</td>
<td width="13%" height="25" bgcolor="eeeeee">工作地区</td>
<td width="10%" height="25" bgcolor="eeeeee">最低学历</td>
<td width="12%" height="25" bgcolor="eeeeee">薪资待遇</td>
<td height="25" bgcolor="eeeeee">发布日期</td>
</tr>
<%
'固顶职位开始
SQL1 = "Select Top 10 JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time From [pH_Job_Base] Where Len(JobName)>0 And JobFlag=1 And DateDiff(d,End_Date,GetDate())<=0 And TopAll=1 And DateDiff(d,TopDate,GetDate())>=0 And DateDiff(d,TopEndDate,GetDate())<=0 Order By LastUpdate_Time Desc"
Set Rs1 = Server.CreateObject("ADODB.Recordset")
Rs1.open SQL1,Conn,1,1
RCount1 = Rs1.RecordCount
For i = 1 to (RCount1/2)+1
If Rs1.Eof Then Exit For
JobId = Rs1("JobId")
Comid = Rs1("Comid")
JobName = Rs1("JobName")
Work_Area = Rs1("Work_Area")
Work_City = Rs1("Work_City")
Edus = Rs1("Edus")
Deal = Rs1("Deal")
LastUpdate_Time = FormatDateTime(Rs1("LastUpdate_Time"),2)
'//企业名称
Set Re = Conn.Execute("Select CompanyName From [pH_Company_Base] Where Comid='"&Comid&"'")
If Not Re.Eof Then
CompanyName = Re("CompanyName")
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
%>
<tr>
<td height="25"><a href="../Company/Info/Com_Job.asp?Comid-<%= Comid %>-Param-<%= Jobid %>.html" target="_blank"><font color=#ff0000><%= JobName %></font></a></td>
<td height="25"><a href="../Company/Info/Com_View.asp?Param-<%= Comid %>.html" target="_blank"><font color=#ff0000><%= CompanyName %></font></a></td>
<td height="25" align="center"><font color=#ff0000><%= Work_Area&Work_City %></font></td>
<td height="25" align="center"><font color=#ff0000><%= Edus_Str %></font></td>
<td height="25" align="center"><font color=#ff0000><%= Deal_Str %></font></td>
<td height="25" align="center"><font color=#ff0000><%= LastUpdate_Time %></font></td>
</tr>
<%
Rs1.Movenext
If Rs1.Eof Then Exit For
JobId = Rs1("JobId")
Comid = Rs1("Comid")
JobName = Rs1("JobName")
Work_Area = Rs1("Work_Area")
Work_City = Rs1("Work_City")
Edus = Rs1("Edus")
Deal = Rs1("Deal")
LastUpdate_Time = FormatDateTime(Rs1("LastUpdate_Time"),2)
'//企业名称
Set Re = Conn.Execute("Select CompanyName From [pH_Company_Base] Where Comid='"&Comid&"'")
If Not Re.Eof Then
CompanyName = Re("CompanyName")
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
%>
<tr>
<td height="25" bgcolor="f9f9f9"><a href="../Company/Info/Com_Job.asp?Comid-<%= Comid %>-Param-<%= Jobid %>.html" target="_blank"><font color=#ff0000><%= JobName %></font></a></td>
<td height="25" bgcolor="f9f9f9"><a href="../Company/Info/Com_View.asp?Param-<%= Comid %>.html" target="_blank"><font color=#ff0000><%= CompanyName %></font></a></td>
<td height="25" align="center" bgcolor="f9f9f9"><font color=#ff0000><%= Work_Area&Work_City %></font></td>
<td height="25" align="center" bgcolor="f9f9f9"><font color=#ff0000><%= Edus_Str %></font></td>
<td height="25" align="center" bgcolor="f9f9f9"><font color=#ff0000><%= Deal_Str %></font></td>
<td height="25" align="center" bgcolor="f9f9f9"><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
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 = FormatDateTime(Rs("LastUpdate_Time"),2)
'//企业名称
Set Re = Conn.Execute("Select CompanyName From [pH_Company_Base] Where Comid='"&Comid&"'")
If Not Re.Eof Then
CompanyName = Re("CompanyName")
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
%>
<tr>
<td height="25"><a href="../Company/Info/Com_Job.asp?Comid-<%= Comid %>-Param-<%= Jobid %>.html" target="_blank"><%= JobName %></a></td>
<td height="25"><a href="../Company/Info/Com_View.asp?Param-<%= Comid %>.html" target="_blank"><%= CompanyName %></a></td>
<td height="25" align="center"><%= Work_Area&Work_City %></td>
<td height="25" align="center"><%= Edus_Str %></td>
<td height="25" align="center"><%= Deal_Str %></td>
<td height="25" align="center"><%= LastUpdate_Time %></td>
</tr>
<%
Rs.Movenext
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 = FormatDateTime(Rs("LastUpdate_Time"),2)
'//企业名称
Set Re = Conn.Execute("Select CompanyName From [pH_Company_Base] Where Comid='"&Comid&"'")
If Not Re.Eof Then
CompanyName = Re("CompanyName")
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
%>
<tr>
<td height="25" bgcolor="f9f9f9"><a href="../Company/Info/Com_Job.asp?Comid-<%= Comid %>-Param-<%= Jobid %>.html" target="_blank"><%= JobName %></a></td>
<td height="25" bgcolor="f9f9f9"><a href="../Company/Info/Com_View.asp?Param-<%= Comid %>.html" target="_blank"><%= CompanyName %></a></td>
<td height="25" align="center" bgcolor="f9f9f9"><%= Work_Area&Work_City %></td>
<td height="25" align="center" bgcolor="f9f9f9"><%= Edus_Str %></td>
<td height="25" align="center" bgcolor="f9f9f9"><%= Deal_Str %></td>
<td height="25" align="center" bgcolor="f9f9f9"><%= 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&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>
</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 + -