📄 com_search_best.asp
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<%
Dim SQL,Rs
Dim Ncid,Bestid,CompanyName,JobName,InviteDate,Place
SQL = "Select J.Ncid,J.Bestid,J.CompanyName,J.JobName,B.InviteDate,J.Id From pH_BestCompany_Jobs As J Inner Join pH_BestCompany_Base As B On J.Bestid=B.Ncid Where Len(J.JobName)>0 Order By J.Ncid 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="0">
<tr>
<td width="150" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="../Images/Company/toplogo.gif" width="164" height="34"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<%
SQL = "Select Top 15 * From [pH_Web_Ad] Where WebName=3 And ad_Width=148 And ad_Height=60 And DateDiff(d,BeginDate,GetDate())>=0 And DateDiff(d,EndDate,GetDate())<=0 And Websub='"&Cls_Websub&"' Order By ad_Sort Asc"
Set Rs_s = Conn.Execute(SQL)
While Not Rs_s.Eof
If Rs_s("AdClass") = 1 Then
%>
<tr>
<td height="68" align="center"> <a href="<%= "http://"&Rs_s("AdUrl") %>" target="_blank"><img src="../Uploadfiles/AdFile/<%= Rs_s("AdFile") %>" width="<%= Rs_s("ad_Width") %>" height="<%= Rs_s("ad_Height") %>" border="0"></a>
</td>
</tr>
<% Else %>
<tr>
<td height="68" align="center"> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="<%= Rs_s("ad_Width") %>" height="<%= Rs_s("ad_Height") %>">
<param name="movie" value="../Uploadfiles/AdFile/<%= Rs_s("AdFile") %>">
<param name=quality value=high>
<embed src="../Uploadfiles/AdFile/<%= Rs_s("AdFile") %>" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="435" height="75"></embed>
</object> </td>
</tr>
<%
End if
Rs_s.Movenext
Wend
Rs_s.Close
%>
</table>
</td>
<td width="5"></td>
<td valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="25" background="../Images/Person/newqy01.gif">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="23"> </td>
<td><strong>现场信息</strong></td>
<td width="80" align="right"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="4"></td>
</tr>
</table>
<table width="100%" 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="35%" height="25" bgcolor="eeeeee">职位名称</td>
<td width="35%" height="25" bgcolor="eeeeee">企业名称</td>
<td width="12%" height="25" bgcolor="eeeeee">职位序位</td>
<td height="25" bgcolor="eeeeee">时间</td>
</tr>
<%
For i = 1 to Psize/2
If Rs.Eof Then Exit For
Ncid = Rs("Ncid")
Bestid = Rs("Bestid")
CompanyName = Rs("CompanyName")
JobName = Rs("JobName")
InviteDate = Rs("InviteDate")
Place = Rs("Id")
%>
<tr>
<td height="25"><a href="Info/BestJob.asp?Comid=<%= Bestid %>&Param=<%= Ncid %>" target="_blank"><%= JobName %></a></td>
<td height="25"><a href="Info/BestCompany.asp?Param=<%= Bestid %>" target="_blank"><%= CompanyName %></a></td>
<td height="25" align="center"><%= Place %></td>
<td height="25" align="center"><%= InviteDate %></td>
</tr>
<%
Rs.Movenext
If Rs.Eof Then Exit For
Ncid = Rs("Ncid")
Locid = Rs("Locid")
CompanyName = Rs("CompanyName")
JobName = Rs("JobName")
InviteDate = Rs("InviteDate")
Place = Rs("Place")
%>
<tr bgcolor="f9f9f9">
<td height="25"><a href="Info/BestJob.asp?Comid=<%= Locid %>&Param=<%= Ncid %>" target="_blank"><%= JobName %></a></td>
<td height="25"><a href="Info/BestCompany.asp?Param=<%= Locid %>" target="_blank"><%= CompanyName %></a></td>
<td height="25" align="center"><%= Place %></td>
<td height="25" align="center"><%= InviteDate %></td>
</tr>
<%
Rs.Movenext
Next
%>
</table>
</td>
</tr>
</table>
<table width="100%" 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"">首页</a> "
Response.write "<a href=""?PageNo="&PageNo-1&""">上页</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 %>" <% If i = PageNo Then Response.write "Selected"%>><%=i%></option>
<% Next %>
</select>
<%
If PageNo < PCount Then
Response.write "<a href=""?PageNo="&PageNo+1&""">下页</a> "
Response.write "<a href=""?PageNo="&PCount&""">尾页</a>"
Else
Response.write "下页 "
Response.write "尾页"
End if
%>
</td>
</tr>
</table>
</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 + -