📄 web_school_editvip.asp
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<!--#include file="Web_Session.asp" -->
<!--#include file="../Include/Class_Pass.asp" -->
<%
Dim Action,Schid,PageNo
Dim TypeId,TypeName,News
'//检测是否跨站
Call Check_url()
'//检测管理员是否有权限操作该页面
If Instr(1,Session("Web_Power"),"131") <= 0 Then
Call CloseDB()
Response.write "对不起!您没有访问该页面的权限..."
Response.End()
End If
Action = Replace_text(request("action"))
Schid = Replace_text(request("Schid"))
PageNo = Replace_text(request("pageno"))
Select Case Action
Case "edit"
Call Edit_Submit() '//跳转到编辑函数
End Select
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新闻类别</title>
<link href="../CSS/css.css" rel="stylesheet" type="text/css">
</head>
<script language="JavaScript" src="../js/jsdate.js"></script>
<body leftmargin="0" topmargin="0">
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="5"></td>
</tr>
<tr>
<td height="25" bgcolor="fb7a03"> <font color="#FFFFFF">::<strong>设置VIP会员</strong></font></td>
</tr>
<tr>
<td height="10"></td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="5"></td>
</tr>
</table>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td align="left"> <table width="50%" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="eff0eb">
<tr>
<td bgcolor="#FFFFFF">
<table width="100%" border="0" cellspacing="1" cellpadding="4">
<%
'查找会员的数据
Set Rs = Conn.Execute("Select Username,SchoolName,Email,VipDate,VipLevel From [pH_School_Base] Where Schid='"&Schid&"'")
If Not Rs.Eof Then
Username = Rs(0)
SchoolName = Rs(1)
Email = Rs(2)
Nc_Vip_Date = Rs(3)
Level = Rs(4)
%>
<form action="?action=edit" method="post">
<tr bgcolor="eff0eb">
<td width="100" height="25" align="right" bgcolor="eff0eb">院校名称：</td>
<td bgcolor="eff0eb"><%= SchoolName %></td>
</tr>
<tr bgcolor="eff0eb">
<td width="100" height="25" align="right" bgcolor="eff0eb">院校帐号：</td>
<td bgcolor="eff0eb"><%= Username %></td>
</tr>
<tr bgcolor="eff0eb">
<td height="25" align="right" bgcolor="eff0eb">收费类型：</td>
<td bgcolor="eff0eb">
<select name="level" id="level">
<option value="1" <% If Level = 1 Then Response.write "Selected" %>>一个月</option>
<option value="2" <% If Level = 2 Then Response.write "Selected" %>>两个月</option>
<option value="3" <% If Level = 3 Then Response.write "Selected" %>>三个月</option>
<option value="4" <% If Level = 4 Then Response.write "Selected" %>>四个月</option>
<option value="5" <% If Level = 5 Then Response.write "Selected" %>>五个月</option>
<option value="6" <% If Level = 6 Then Response.write "Selected" %>>六个月</option>
<option value="9" <% If Level = 9 Then Response.write "Selected" %>>九个月</option>
<option value="12" <% If Level = 12 Then Response.write "Selected" %>>一年</option>
<option value="24" <% If Level = 24 Then Response.write "Selected" %>>两年</option>
<option value="36" <% If Level = 36 Then Response.write "Selected" %>>三年</option>
</select>
</td>
</tr>
<tr bgcolor="eff0eb">
<td width="100" height="25" align="right" bgcolor="eff0eb">开始时间：</td>
<td bgcolor="eff0eb">
<input name="begindate" type="text" id="begindate" size="16" maxlength="30" onclick="SD(this,'document.all.begindate')" value="<%= Nc_Vip_Date %>">
<input name="Schid" type="hidden" id="Schid" value="<%= Schid %>">
<input name="pageno" type="hidden" id="pageno" value="<%= PageNo %>">
<input name="email" type="hidden" id="email" value="<%= Email %>">
<input name="Schoolname" type="hidden" id="Schoolname" value="<%= Schoolname %>">
</td>
</tr>
<tr bgcolor="eff0eb">
<td width="100" height="25" align="right" bgcolor="eff0eb">
</td>
<td bgcolor="eff0eb"><input type="submit" name="Submit" value="设 置"></td>
</tr>
</form>
<%
Else
%>
<tr bgcolor="eff0eb">
<td height="25" colspan="2" bgcolor="eff0eb">没有找到该院校!</td>
</tr>
<%
End if
Rs.Close
Set Rs = Nothing
%>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
<%
Sub Edit_Submit() '修改密码
Schid = Replace_text(request("Schid"))
PageNo = Replace_text(request("PageNo"))
Level = Replace_text(request("Level"))
BeginDate = Replace_text(request("BeginDate"))
Email = Replace_text(request("Email"))
SchoolName = Replace_text(request("SchoolName"))
'判断会员是否被审核过
Set Rs = Conn.Execute("Select VipFlag From [pH_School_Base] Where Schid='"&Trim(Schid)&"'")
If Rs(0) = 0 Then
Response.write "<script language=JavaScript>alert('操作错误！请先通过对该会员的审核');location.href='"&PageNo&"';</script>"
Response.End()
End if
Rs.Close
'设置
SQL = "UPdate [pH_School_Base] Set VipFlag=1,VipLevel="&Level&",VipDate='"&BeginDate&"',VipEndDate=DateAdd(m,"&Level&",'"&BeginDate&"') Where Schid='"&Trim(Schid)&"'"
Conn.Execute(SQL)
'发送邮件
HtmlStr = "您好，您的院校["&SchoolName&"]在"&Cls_WebName&"已经与"&BeginDate&"成功设置成高级VIP会员，截止日期是"&DateAdd("m",Level,BeginDate)&"<br><hr><br>"&Cls_WebName
Call SendEmail(Email,HtmlStr,"您的院校是VIP会员")
Response.write "<script language=JavaScript>alert('设置成功！');location.href='"&PageNo&"';</script>"
End Sub
Call CloseDB()
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -