📄 sch_search_new.asp
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<%
Dim SQL,Rs
Dim JobClass,Area,PublishDate,Key,KeyClass
Dim JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time
SQL = "Select Schid,SchoolName,Properity,Locus_Area,Locus_City,ContactPerson,Phone,LastUpdate_Time From [pH_School_Base] Where Len(SchoolName)>0 And VipFlag<>0 Order By VipFlag Asc,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>
<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>
<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>
<script language="JavaScript">
function login_check()
{
if (document.login.username.value==""){
alert("-请输入用户名-");
document.login.username.focus();
return false;
}
if (document.login.password.value==""){
alert("-请输入登陆密码-");
document.login.password.focus();
return false;
}
}
function search_check(){
if (document.theForm.key.value=="请输入职位/企业关键字"){
alert("-请输入职位/企业关键字-");
document.theForm.key.focus();
return false;
}
}
</script>
<body>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td><!--#include file="../Include/Header.asp" -->
<table width="956" border="0" cellspacing="0" cellpadding="0" align="center" height="5">
<tr>
<td></td>
</tr>
</table>
</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="../Company/Com_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(4,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"> </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 width="670" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td align="center">
<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="25%" height="25" bgcolor="eeeeee">院校名称</td>
<td width="11%" height="25" bgcolor="eeeeee">院校性质</td>
<td width="13%" height="25" bgcolor="eeeeee">工作地区</td>
<td width="9%" height="25" bgcolor="eeeeee">毕业生</td>
<td width="12%" height="25" bgcolor="eeeeee">联系人</td>
<td width="17%" height="25" bgcolor="eeeeee">联系电话</td>
<td bgcolor="eeeeee">发布日期</td>
</tr>
<%
For i = 1 to Psize/2
If Rs.Eof Then Exit For
Schid = Rs("Schid")
SchoolName = Rs("SchoolName")
Properity = Rs("Properity")
Locus_Area = Rs("Locus_Area")
Locus_City = Rs("Locus_City")
ContactPerson = Rs("ContactPerson")
Phone = Rs("Phone")
LastUpdate_Time = FormatDateTime(Rs("LastUpdate_Time"),2)
SchoolType = Cls_SchoolType(Properity)
'//毕业生数目
SudCount = 0
Set Re = Conn.Execute("Select Count(*) From [pH_School_Student] Where Schid='"&Schid&"'")
If Not Re.eof Then SudCount = Re(0)
Re.Close
%>
<tr>
<td height="25"><a href="Info/Index.asp?param-<%= Schid %>.html" target="_blank"><u><%= SchoolName %></u></a></td>
<td height="25" align="center"><%= SchoolType %></td>
<td height="25" align="center"><%= Locus_Area&Locus_City %></td>
<td height="25" align="center"><%= SudCount %></td>
<td height="25" align="center"><%= ContactPerson %></td>
<td height="25" align="center"><%= Phone %></td>
<td height="25" align="center"><%= LastUpdate_Time %></td>
</tr>
<%
Rs.Movenext
If Rs.Eof Then Exit For
Schid = Rs("Schid")
SchoolName = Rs("SchoolName")
Properity = Rs("Properity")
Locus_Area = Rs("Locus_Area")
Locus_City = Rs("Locus_City")
ContactPerson = Rs("ContactPerson")
Phone = Rs("Phone")
LastUpdate_Time = FormatDateTime(Rs("LastUpdate_Time"),2)
SchoolType = Cls_SchoolType(Properity)
'//毕业生数目
SudCount = 0
Set Re = Conn.Execute("Select Count(*) From [pH_School_Student] Where Schid='"&Schid&"'")
If Not Re.eof Then SudCount = Re(0)
Re.Close
%>
<tr bgcolor="f9f9f9">
<td height="25"><a href="Info/Index.asp?param-<%= Schid %>.html" target="_blank"><u><%= SchoolName %></u></a></td>
<td height="25" align="center"><%= SchoolType %></td>
<td height="25" align="center"><%= Locus_Area&Locus_City %></td>
<td height="25" align="center"><%= SudCount %></td>
<td height="25" align="center"><%= ContactPerson %></td>
<td height="25" align="center"><%= Phone %></td>
<td height="25" align="center"><%= LastUpdate_Time %></td>
</tr>
<%
Rs.Movenext
Next
%>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="4" bgcolor="#EEF7FF" height="30">
<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>
</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 + -