?? 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 + -