%
Response.Expires= -1
Response.ExpiresAbsolute = Now() - 1
response.CacheControl="no-cache"
server.ScriptTimeout=5000
%>
<%
PreviousId=checkstr(request("PreviousId"),1)
PostEmail=""
cmd=trim(request("cmd"))
RealName=checkstr(trim(request("RealName")),2)
Sex=checkstr(request("Sex"),1)
Tel=checkstr(trim(request("Tel")),2)
Address=checkstr(trim(request("Address")),2)
Email=checkstr(trim(request("Email")),2)
Remark=checkstr(trim(request("Remark")),2)
lessonid=checkstr(trim(request("lessonid")),2)
city=checkstr(trim(request("city")),2)
if city="" then city="北京"
if city="北京" then
url="/ms/classlist1.asp?uid="&PreviousId
else
url="/ms/classlist1.asp?uid="&PreviousId&"&city="&server.URLEncode(city)
end if
response.redirect url
if cmd="add" and RealName<>"" and Tel<>"" and Address<>"" then
WebName=request.ServerVariables("HTTP_HOST") '获取域名
Set rs=server.CreateObject("ADODB.Recordset")
strSql="Select Top 1 Show_Name From Link_Web Where web_Name='"&WebName&"'" '获取合作网站名称
rs.open strSql,conn,1,3
if not rs.eof then
ShowName=rs("Show_Name")
end if
rs.close
Set rs_lesson=server.CreateObject("ADODB.Recordset")
strSql="Select lesson from Lessonset where lesson_Id in("&lessonid&")"
rs_lesson.Open strSql,conn,1,3
do while not rs_lesson.eof
LessonName=LessonName&rs_lesson("Lesson")&","
rs_lesson.movenext
loop
rs_lesson.close
if Instr(Len(LessonName),LessonName,",")>0 then
LessonName=left(LessonName,Len(LessonName)-1)
end if
strSql="Select Top 1 * from Ms_Order where 1=0"
rs.Open strSql,conn,1,3
rs.addnew
rs("RealName")=RealName
rs("Sex")=Sex
rs("Tel")=Tel
rs("Address")=Address
rs("Email")=Email
rs("Remark")=Remark
rs("LessonId")=LessonId
rs("LessonName")=LessonName
rs("WebName")=WebName
rs("ShowName")=ShowName
rs.update
rs.close
if WebName="passeasy.edu24ol.com" Then
PostEmail="zcpass@126.com"
elseif WebName="exam8.edu24ol.com" or WebName="kc.exam8.com" Then
PostEmail="services@exam8.com"
elseif WebName="examres.edu24ol.com" Then
PostEmail="webmaster@examres.com"
elseif WebName="course.edu24ol.com" Then
PostEmail="edu24ol@qq.com"
elseif WebName="chuntian.edu24ol.com" Then
PostEmail="chuntianorg@yahoo.com.cn"
End If
if PostEmail<>"" Then
SendMail
End If
response.write ""
end if
sub SendMail()
msubject="
以下是 " & RealName & " 在线订购的课程信息:
"
msubject=msubject & "
报名课程:" & LessonName & "
"
msubject=msubject & "
真实姓名:" & RealName & "
"
if Sex=1 then
msubject=msubject & "
性别:男
"
else
msubject=msubject & "
性别:女
"
end if
msubject=msubject & "
联系电话:" & Tel & "
"
msubject=msubject & "
通信地址:" & Address & "
"
msubject=msubject & "
电子邮件:" & Email & "
"
msubject=msubject & "
备注:" & Remark & "
"
Set jMail = Server.CreateObject("JMail.Message")
jMail.Charset="gb2312"
jMail.From="hqwx@edu24o1.com"
jMail.AddRecipient PostEmail
JMail.MailServerUserName = "hqwx@edu24o1.com"
JMail.MailServerPassword = "hqwx_2008"
jMail.Subject=RealName & " 环球面授课程订购信息"
jMail.HTMLBody=msubject
jMail.Priority = 1
jMail.Send("mail.edu24o1.com")
End Sub
%>
课程提交
面授招生信息
<%
sql="select top 15 cast(title as varchar(26)) as showtitle,title,t_color,htmlpath,html,addlink from edu_news where newcataid=299 and isshow=1 order by shownum,addtime desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3
if not(rs.eof or rs.bof) then
do while not rs.eof
if rs("addlink")="" or isnull(rs("addlink")) then
newslink="/ms/web_news/html/"&rs("htmlpath")&"/"&rs("html")
else
newslink=rs("addlink")
end if
response.Write("
")
rs.movenext
loop
end if
rs.close
set rs=nothing
%>
面授资讯
<%
sql="select top 15 cast(title as varchar(26)) as showtitle,title,t_color,htmlpath,html,addlink from edu_news where newcataid=320 and isshow=1 order by shownum,addtime desc"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3
if not(rs.eof or rs.bof) then
do while not rs.eof
if rs("addlink")="" or isnull(rs("addlink")) then
newslink="/ms/web_news/html/"&rs("htmlpath")&"/"&rs("html")
else
newslink=rs("addlink")
end if
response.Write("