📄 index.asp
字号:
<!--#include file="../../Include/Class_Conn.asp" -->
<!--#include file="../../Include/Class_Main.asp" -->
<%
Dim Param
Dim Schid,Username,Cmd,Rs,SQL
Param_Str = Split(Request.QueryString,".")
Str = Split(Param_Str(0),"-")
Param = Replace_Text(Str(1))
'//获取会员登陆的标记
Schid = Param
'//调用存储过程
Set Cmd = Server.CreateObject("ADODB.Command")
Cmd.ActiveConnection = Conn
Cmd.CommandText = "Sch_View"
Cmd.CommandType = 4
Cmd.Parameters.Append Cmd.CreateParameter("@Schid",200,1,30)
Cmd.Parameters("@Schid") = Schid
Set Rs = Cmd.Execute
If Rs.Eof Then
CloseRs
Set Cmd = Nothing
CloseDB
Response.write "没有找到会员资料！"
Response.End()
End if
Tmp = Rs.GetRows() '//将数据填充到数组
'//0院校名,1院校性质,2图片文件,3成立年份,4现有资产,5资金类型,6人员数目,7介绍,8联系人,9电话,10传真,11网站,12邮政编码,13邮件地址,14通信地址,15所在省份,16城市
'//关闭数据库对象
Rs.Close
Set Cmd = Nothing
'//更新显示次数
Conn.Execute("Update [pH_School_Base] Set ViewClicks=ViewClicks+1 Where Schid='"&Schid&"'")
SchoolName = Tmp(0,0)
Properity = Tmp(1,0)
BannerFile = Tmp(2,0)
Set_Year = Tmp(3,0)
Reg_Currency = Tmp(4,0)
CurrencyType = Tmp(5,0)
Workers = Tmp(6,0)
School_Memo = Tmp(7,0)
ContactPerson = Tmp(8,0)
Phone = Tmp(9,0)
Fax = Tmp(10,0)
WebHome = Tmp(11,0)
ZipCode = Tmp(12,0)
Email = Tmp(13,0)
Address = Tmp(14,0)
Locus_Area = Tmp(15,0)
Locus_City = Tmp(16,0)
SchoolType = Cls_SchoolType(Properity)
Currency_Str = Reg_Currency&"万元"&Cls_Currency(CurrencyType)
Locus = Locus_Area&Locus_City
%>
<!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/Style.css" type=text/css rel=stylesheet>
<title><%= SchoolName&" -- "&Cls_WebName %></title>
</head>
<body>
<table width="956" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td>
<!--#include file="../../Include/Header.asp" -->
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="4"></td>
</tr>
</table>
<table width="956" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td width="164" 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>
<tr>
<td height="70" align="center"><img src="../../Ad_Imgs/148_60_1(3).gif" width="148" height="60"></td>
</tr>
<tr>
<td height="70" align="center"><img src="../../Ad_Imgs/148_60_1.gif" width="148" height="60"></td>
</tr>
<tr>
<td height="70" align="center"><img src="../../Ad_Imgs/148_60_1(1).gif" width="148" height="60"></td>
</tr>
<tr>
<td height="70" align="center"><img src="../../Ad_Imgs/148_60_1(2).gif" width="148" height="60"></td>
</tr>
<tr>
<td height="70" align="center"><img src="../../Ad_Imgs/148_60_1(5).gif" width="148" height="60"></td>
</tr>
<tr>
<td height="70" align="center"><img src="../../Ad_Imgs/148_60_1(4).gif" width="148" height="60"></td>
</tr>
</table></td>
<td width="1" bgcolor="#eeeeee"></td>
<td width="3"></td>
<td valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="28%" align="left"><img src="../../Images/Company/welcome.gif" width="149" height="43"></td>
<td style="font-size:15px;color:#3333CC;font-weight:bold"><%= Tmp(0,0) %></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="186" height="21"> </td>
<td width="22" rowspan="2"><img src="../../Images/Company/company_left.gif" width="22" height="22"></td>
<td width="117" rowspan="2" align="center" valign="bottom" background="../../Images/Company/company_wbg.gif"><strong>院校简介</strong></td>
<td width="28" rowspan="2"><img src="../../Images/Company/company_middle.gif" width="28" height="22"></td>
<td width="126" rowspan="2" align="center" valign="bottom" background="../../Images/Company/company_ybg.gif"><a href="Student.asp?Param-<%= Schid %>.html">推荐毕业生</a></td>
<td width="10" rowspan="2"><img src="../../Images/Company/company_right.gif" width="24" height="22"></td>
<td width="299"> </td>
</tr>
<tr>
<td height=1 bgcolor=#ddddda width="186"></td>
<td height=1 bgcolor=#ddddda width="299"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="1" bgcolor="#ddddda"></td>
<td width="145" align="center" valign="top" bgcolor="#FBFBFB">
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10"></td>
</tr>
<tr>
<td>正在推荐...</td>
</tr>
<%
SQL = "Select Top 20 S.Perid,I.RealName,I.Speciality From pH_School_Student As S,pH_Person_Info As I Where S.Schid='"&Schid&"' And S.Perid=I.Perid Order By AddDate Desc"
Set Rs = Conn.Execute(SQL)
If Not Rs.Eof Then
While Not Rs.Eof
Perid = Rs(0)
RealName = Rs(1)
Speciality = Rs(2)
Response.write "<tr><td height=25><li><a href=""../../Person/Resume/Resume_2.asp?Param-"&Perid&".html"" target=_blank>"&RealName&"</a> "&Speciality&"</td></tr>"
Rs.Movenext
Wend
End if
Rs.Close
%>
<tr>
<td height="10"></td>
</tr>
</table></td>
<td align="center" valign="top"> <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="6"></td>
</tr>
</table>
<table width="98%" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr bgcolor="f5f5f5">
<td width="70" height="25"><img src="../../Images/icon3.gif" width="12" height="16">
院校信息</td>
<td> </td>
<td width="150"> <img src="../../Images/icon3.gif" width="12" height="16">
图 标</td>
</tr>
</table>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td width="70" height="25" align="right">院校名称：</td>
<td height="25"><%= SchoolName %></td>
</tr>
<tr>
<td width="70" height="25" align="right" bgcolor="f9f9f9">成立日期：</td>
<td height="25" bgcolor="f9f9f9"><%= Set_Year %></td>
</tr>
<tr>
<td width="70" height="25" align="right">院校性质：</td>
<td height="25"><%= SchoolType %></td>
</tr>
<tr>
<td width="70" height="25" align="right">现有资产：</td>
<td height="25"><%= Currency_Str %></td>
</tr>
<tr>
<td width="70" height="25" align="right" bgcolor="f9f9f9">员工人数：</td>
<td height="25" bgcolor="f9f9f9"><%= Workers %></td>
</tr>
<tr>
<td width="70" height="25" align="right">所在地区：</td>
<td height="25"><%= Locus %></td>
</tr>
</table></td>
<td width="150" align="center" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="6"></td>
</tr>
<tr>
<td align="center">
<%
If BannerFile <> Null or BannerFile <> "" Then
Response.write "<img src=""../../UpLoadFiles/SchoolFile/"&BannerFile&""" width=""135"" height=""160"">"
Else
Response.write "<img src=""../../UpLoadFiles/DefaultFile/School.gif"" width=""135"" height=""160"">"
End if
%>
</td>
</tr>
<tr>
<td height="6"></td>
</tr>
</table></td>
</tr>
</table>
<table width="98%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
</table>
<table width="98%" border="0" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<tr>
<td height="25" bgcolor="f6f6f6"> <img src="../../Images/icon3.gif" width="12" height="16">
院校简介</td>
</tr>
</table>
<table width="98%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td height="5"></td>
</tr>
<tr>
<td><table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><%= School_Memo %></td>
</tr>
</table></td>
</tr>
<tr>
<td height="5"></td>
</tr>
</table>
<table width="98%" border="0" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<tr>
<td height="25" bgcolor="f6f6f6"> <img src="../../Images/icon3.gif" width="12" height="16">
联系方式</td>
</tr>
</table>
<table width="98%" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td width="70" height="25" align="right">联系人：</td>
<td height="25"><%= ContactPerson %></td>
</tr>
<tr>
<td width="70" height="25" align="right" bgcolor="f9f9f9">联系电话：</td>
<td height="25" bgcolor="f9f9f9"><%= Phone %></td>
</tr>
<tr>
<td height="25" align="right">传真号码：</td>
<td height="25"><%= Fax %></td>
</tr>
<tr>
<td height="25" align="right" bgcolor="f9f9f9">邮箱地址：</td>
<td height="25" bgcolor="f9f9f9"><%= Email %></td>
</tr>
<tr>
<td height="25" align="right">院校网址：</td>
<td height="25"><%= WebHome %></td>
</tr>
<tr>
<td height="25" align="right" bgcolor="f9f9f9">邮政编码：</td>
<td height="25" bgcolor="f9f9f9"><%= ZipCode %></td>
</tr>
<tr>
<td height="25" align="right">通讯地址：</td>
<td height="25"><%= Address %></td>
</tr>
</table>
</td>
<td width="1" bgcolor="#ddddda"></td>
</tr>
<tr>
<td colspan="4" height="1" bgcolor="#ddddda"></td>
</tr>
</table>
</td>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="1" bgcolor="#eeeeee"></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>
<%
'//关闭数据库连接
Set Rs = Nothing
CloseDB
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -