📄 addcar.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="xshjyy.asp"-->
<!--#include file="../md5.asp"-->
<%'---------程序编写说明-------%>
<%
'本程序由junping96编写
'程序名称：新世纪影院VOD播放系统（商业版）
'FileName: Addcar.asp
'EditDate:2003-12-07
'Editer:junping96
'Email:junping96@163.com
'QQ: 249112913 249114058
'请尊重本人劳动，禁止修改版权，有任何问题请和我联系。
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta name="”keywords”" content="”新世纪影院VOD影视播放程序出售”">
<meta name="”description”" content="”新世纪影院VOD影视(商业版)出售”">
<title>新世纪影院</title>
<link rel="stylesheet" type="text/css" href="../css/css.css">
<script language="vbscript">
sub check()
if login.shl.value=empty or isnumeric(login.shl.value)=false then
alert "错误，请输入增加冲值卡的数量!"
exit sub
end if
if login.startcar.value=empty or isnumeric(login.startcar.value)=false then
alert "错误，请输入冲值卡的开始号码!"
exit sub
end if
if len(login.startcar.value)<6 then
alert "错误，冲值卡的开始号码必须是6位以上数字!"
exit sub
end if
if login.carlx.value=empty then
alert "错误，请输入冲值卡的类型!"
exit sub
end if
if login.yesorno.value=empty then
alert "错误，请说明冲值卡是否加密!"
exit sub
end if
login.submit
end sub
</script>
</head>
<body topmargin="1" leftmargin="0" bgcolor="#FF9900">
<%
act=trim(request.querystring("act"))
if act<>"add" then
%>
<%
dim pagesize,curpage,numpages
pagesize=20 '每页显示的数据条数.
if request.querystring("page")<>"" then
curpage=cint(request.querystring("page"))
else
curpage=1
end if
%>
<div align="center">
<center>
<form name="login" method="post" action="addcar.asp?act=add">
<table border="0" cellpadding="0" cellspacing="1" width="474">
<tr>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" colspan="4" width="472">增加冲值卡</td>
</tr>
<tr>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="138">数量：</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="138"><input name=shl size=15 class="inputs"></td>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="21" width="192" colspan="2"><select size="1" name="carlx">
<option selected>影卡类型</option>
<%
set rs=server.createobject("adodb.recordset")
sql="select carlx,cartime from car order by id"
rs.open sql,conn,1,1
if rs.eof or bof then
response.write"<option>没有任何类型</option>"
else
do while not rs.eof or bof
%><option value=<%=rs("cartime")%>><%=rs("carlx")%></option>
<%
rs.movenext
loop
end if
rs.close
set rs=nothing
%>
</select></td>
</tr>
<tr>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="138">开始卡号：</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="138"><input name=startcar size=15 class="inputs"></td>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="21" width="192" colspan="2"><select size="1" name="yesorno">
<option value="2" selected>不加密</option>
<option value="1">加密</option>
</select></td>
</tr>
<tr>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="470" colspan="4"><input type=button onclick="check" name=b3 value="增加">
<input type=reset name=b4 value="重置"> </td>
</tr>
<tr>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="21" width="470" colspan="4">说明：</td>
</tr>
<tr>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="21" width="470" colspan="4">1、必须保证卡号不相同，开始卡号必须是合法数字。</td>
</tr>
<tr>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="21" width="470" colspan="4">2、自行选择是否加密。</td>
</tr>
<tr>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="21" width="470" colspan="4">3、新世纪影院目前电影卡列表如下：</td>
</tr>
<tr>
<td valign="middle" align="left" bgcolor="#f0f0f0" height="21" width="470" colspan="4">
<div align="center">
<table border="0" cellpadding="0" cellspacing="1" width="100%" height="40">
<tr>
<td width="30%" valign="middle" align="center" height="22" bgcolor="#FFFFFF">名称</td>
<td width="20%" valign="middle" align="center" height="22" bgcolor="#FFFFFF">种类</td>
<td width="10%" valign="middle" align="center" height="22" bgcolor="#FFFFFF">价格</td>
<td width="10%" valign="middle" align="center" height="22" bgcolor="#FFFFFF">时间</td>
<td width="30%" valign="middle" align="center" height="22" bgcolor="#FFFFFF">优惠</td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from car order by id"
rs.open sql,conn,1,1
if rs.eof or bof then
response.write"<option>没有任何类型</option>"
else
do while not rs.eof or bof
%>
<tr>
<td width="30%" height="22" valign="middle" bgcolor="#FFFFFF"> <%=rs("carlx")%></td>
<td width="20%" height="22" valign="middle" bgcolor="#FFFFFF" align="center"><%=rs("carname")%></td>
<td width="10%" height="22" valign="middle" bgcolor="#FFFFFF" align="center"><%=rs("price")%>元</td>
<td width="10%" height="22" valign="middle" bgcolor="#FFFFFF" align="center"><%=rs("cartime")%>天</td>
<td width="30%" height="22" valign="middle" bgcolor="#FFFFFF"> <%=rs("bz")%></td>
</tr>
<%
rs.movenext
loop
end if
rs.close
set rs=nothing
%>
</table>
</div>
</td>
</tr>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="21" width="470" colspan="4">目前现有冲值卡
<a href=cardel.asp>删除全部冲值卡</a></td>
<tr>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="138">类型</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="138">卡号</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="139">密码</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="54">删除</td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from chzhk order by id desc"
rs.open sql,conn,1,1
if rs.eof or bof then
response.write"<option>没有任何冲值卡</option>"
else
rs.pagesize=pagesize
numpages=rs.pagecount
if curpage>numpages then
curpage=numpages
end if
rs.absolutepage=curpage
a=1
do while not rs.eof or bof
%>
<tr>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="138"><%=rs("carname")%></td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="138"><%=rs("carid")%></td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="139"><%=rs("carpassword")%></td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="54"><a href=cardel.asp?id=<%=rs("id")%>>删除</a></td>
</tr>
<%
rs.movenext
a=a+1
if a>pagesize then exit do
loop
end if
%>
<tr>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" width="470" colspan="4">
<%
response.write"目前共有("&rs.recordcount&")张冲值卡, "
response.write"共分为("&numpages&")页,当前为第"&curpage&"页 "
for m=1 to numpages
response.write"<a href=addcar.asp?page="&m&">["&m&"]</a> "
next
response.write"<a href=addcar.asp?page=1>首页</a> "
if curpage>1 then
response.write"<a href=""addcar.asp?page="&(curpage-1)&""">上一页</a> "
end if
if curpage<numpages then
response.write"<a href=""addcar.asp?page="&(curpage+1)&""">下一页</a> "
end if
response.write"<a href=addcar.asp?page="&numpages&">尾页</a> "
rs.close
set rs=nothing
%>
</td>
</tr>
</table>
</form>
</center>
</div>
<%
else
shl=trim(request.form("shl"))
startcar=int(trim(request.form("startcar")))
yesorno=trim(request.form("yesorno"))
carlx=int(trim(request.form("carlx")))
if carlx=37 then
carlxs=1
carname="一个月普通会员卡"
elseif carlx=74 then
carlxs=3
carname="两个月高级会员卡"
elseif carlx=200 then
carlxs=2
carname="半年中级会员卡"
else
carlxs=3
carname="全年高级会员卡"
end if
set rs=server.createobject("adodb.connection")
rs.open conn
for i=1 to shl
carid=startcar
startcar=startcar+1
randomize
carpassword=Int((6243951646*rnd))
if yesorno=1 then
carpassword=md5(carpassword)
end if
sql="insert into chzhk(carid,carpassword,carlx,cartime,carname) values('"&carid&"','"&carpassword&"','"&carlxs&"','"&carlx&"','"&carname&"')"
rs.execute(sql)
next
rs.close
set rs=nothing
response.redirect request.servervariables("HTTP_REFERER")
end if
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -