📄 carfp.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="xshjyy.asp"-->
<%'---------程序编写说明-------%>
<%
'本程序由junping96编写
'程序名称：新世纪影院VOD播放系统（商业版）
'FileName: Carfp.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.id.value=empty or isnumeric(login.id.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 login.endcar.value=empty or isnumeric(login.endcar.value)=false 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<>"save" 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>
<table border="0" cellpadding="0" cellspacing="1" width="486">
<form name="login" method="post" action=carfp.asp?act=save>
<tr>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="21" colspan="2" width="484">冲值卡分配</td>
</tr>
<tr>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="21" width="74">代理编号：</td>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="22" width="410"><input name=id size=25 class="inputs"></td>
</tr>
<tr>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="21" width="74">开始卡号：</td>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="22" width="402"><input name=startcar size=25 class="inputs"></td>
</tr>
<tr>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="21" width="74">终止卡号：</td>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="22" width="420"><input name=endcar size=25 class="inputs"></td>
</tr>
<tr>
<td valign="middle" align="left" bgcolor="#FFFFFF" height="21" width="494" colspan="2"><input type=button onclick="check" name=b3 value="提交">
<input type=reset name=b4 value="重置">(以上内容是必填)</td>
</tr>
</form>
</table>
<table border="0" cellpadding="0" cellspacing="1" width="486">
<tr>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="22" width="486" colspan="5" >冲值卡分配情况一览表
</td>
</tr>
<tr>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="22" width="60" >代理编号
</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="22" width="102" >会员卡
</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="22" width="113" >类型
</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="22" width="134" >分配日期
</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="22" width="78" >收回会员卡
</td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
sql="select id,carid,yesorno,dates,cartime from chzhk where yesorno<>0 order by id desc"
rs.open sql,conn,1,1
if rs.eof or bof then
response.write""
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="22" width="60" ><a href=dllook.asp?id=<%=rs("yesorno")%>><%=rs("yesorno")%></a>
</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="22" width="102" ><%=rs("carid")%>
</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="22" width="113" ><%
cartime=rs("cartime")
if cartime=74 then
cartime="两个月"
else
cartime="全年"
end if
response.write cartime
%>
</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="22" width="134" ><%=rs("dates")%>
</td>
<td valign="middle" align="center" bgcolor="#FFFFFF" height="22" width="78" ><a href=carshh.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="left" bgcolor="#FFFFFF" height="22" width="486" colspan="5">
<%
response.write"目前共有("&rs.recordcount&")个记录, "
response.write"共分为("&numpages&")页,当前为第"&curpage&"页 "
for m=1 to numpages
response.write"<a href=carfp.asp?page="&m&">["&m&"]</a> "
next
response.write"<a href=carfp.asp?page=1>首页</a> "
if curpage>1 then
response.write"<a href=""carfp.asp?page="&(curpage-1)&""">上一页</a> "
end if
if curpage<numpages then
response.write"<a href=""carfp.asp?page="&(curpage+1)&""">下一页</a> "
end if
response.write"<a href=carfp.asp?page="&numpages&">尾页</a> "
rs.close
set rs=nothing
%>
</td>
</tr>
</table>
</center>
</div>
<%
else
id=request.form("id")
startcar=request.form("startcar")
endcar=request.form("endcar")
if startcar>endcar then
response.write"<script language=javascript>alert('错误，请正确数据开始、终止卡号');history.back(-1);</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select yesorno,dates from chzhk where carid>="&startcar&"and carid<="&endcar&"and carlx=3"
rs.open sql,conn,1,3
if rs.eof or bof then
response.redirect"../error.htm"
else
do while not rs.eof or bof
rs("yesorno")=id
rs("dates")=now()
rs.update
rs.movenext
loop
end if
rs.close
set rs=nothing
response.redirect request.servervariables("HTTP_REFERER")
end if
%>
</body>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -