📄 student.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 = "Edu_Account"
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院校性质
'//关闭数据库对象
Rs.Close
Set Cmd = Nothing
SchoolName = Tmp(0,0)
Properity = Tmp(1,0)
SchoolType = Cls_EducateType(Properity)
'//查找课程
SQL = "Select Ncid,LessonName,Begindate,Currcy From [pH_Educate_Lesson] Where Schid='"&Schid&"' Order By AddDate Desc"
Rs.open SQL,Conn,1,1
Rs.Pagesize = 15
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
TheRecord = (PageNo-1)*Psize '//计算记录编号的基数
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/Style.css" type=text/css rel=stylesheet>
<title><%= SchoolName&" -- 培训课程" %></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="190" height="21"> </td>
<td width="21" rowspan="2"><img src="../../Images/Company/yleft.gif" width="21" height="22"></td>
<td width="110" rowspan="2" align="center" valign="bottom" background="../../Images/Company/company_ybg.gif"><a href="Index.asp?Param-<%= Schid %>.html">机构简介</a></td>
<td width="28" rowspan="2"><img src="../../Images/Company/middle.gif" width="28" height="22"></td>
<td width="119" rowspan="2" align="center" valign="bottom" background="../../Images/Company/company_wbg.gif"><strong>培训课程</strong></td>
<td width="10" rowspan="2"><img src="../../Images/Company/person_wright.gif" width="24" height="22"></td>
<td width="310"> </td>
</tr>
<tr>
<td height=1 bgcolor=#ddddda width="190"></td>
<td height=1 bgcolor=#ddddda width="310"></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 Ncid,LessonName From pH_Educate_Lesson Where Schid='"&Schid&"' Order By AddDate Desc"
Set Rs1 = Conn.Execute(SQL)
If Not Rs1.Eof Then
While Not Rs1.Eof
Ncid = Rs1(0)
LessonName = Rs1(1)
Response.write "<tr><td height=25><li><a href=""Lesson_Info.asp?Schid-"&Schid&"-Param-"&Ncid&".html"">"&LessonName&"</a></td></tr>"
Rs1.Movenext
Wend
End if
Rs1.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="2"></td>
</tr>
</table>
<table width="99%" border="0" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
<tr>
<td bgcolor="#FFFFFF"><table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="2"></td>
</tr>
</table>
<table width="99%" border="0" align="center" cellpadding="4" cellspacing="1" bgcolor="dddddd">
<tr align="center" bgcolor="f5f5f5">
<td width="56%" height="25">课程名称</td>
<td width="23%" bgcolor="f5f5f5">开课时间</td>
<td width="21%" height="25" bgcolor="f5f5f5">费 用</td>
</tr>
<%
For i = 1 to Psize
If Rs.Eof Then Exit For
Ncid = Rs("Ncid")
LessonName = Rs("LessonName")
Begindate = Rs("Begindate")
Currcy = Rs("Currcy")
%>
<tr align="center">
<td height="25" align="left" bgcolor="#FFFFFF"><a href="Lesson_Info.asp?Schid-<%= Schid %>-Param-<%= Ncid %>.html"><%= LessonName %></a></td>
<td height="25" align="center" valign="baseline" bgcolor="#FFFFFF">
<%= Begindate %></td>
<td height="25" align="left" bgcolor="#FFFFFF"><%= Currcy %></td>
</tr>
<%
Rs.Movenext
Next
Rs.Close
%>
</table>
<table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="right"><%= Cls_Page2("Student.asp?param="&Schid,PageNo,PCount,RCount) %></td>
</tr>
</table>
</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="956" 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 + -