ADODB.Recordset (0x800A0E78)
对象关闭时,不允许操作。
/tixian.asp, 第 103 行
<%if session("person")="" then
response.write"<script>alert('对不起,您未登录!');window.navigate('login.asp');</script>"
else
rs.open"select * from person where name='"&session("person")&"'",conn,1,1
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="body">
<tr>
<td> </td>
</tr>
<tr>
<td><table width="770" border="0" align="center" cellpadding="0" cellspacing="8">
<tr>
<td width="134" height="45" align="center" valign="top"><!--#include file="left.asp"--></td>
<td align="center" valign="top"><table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#dedeb8">
<tr>
<td bgcolor="#ffffd9"><img src="/img/notice.gif" width="12" height="13" align="absmiddle"> <span style="color: #92a05a"><%=rs("name")%>,欢迎您来到<%=webname%>!上次您在 <%=rs("logintime")%> 登录本站。</span></td>
</tr>
</table>
<br>
<!--resa-->
<%if request("lei")="" then
rs2.open"select sum(shang) as shangfen from question where sender='"&session("person")&"'",conn,1,1
if rs2.eof then
shangfen="0"
else
shangfen=rs2("shangfen")
end if
rs2.close
rs2.open"select * from question where sender='"&session("person")&"'",conn,1,1
if rs2.eof then
wenti="0"
else
wenti=rs2.recordcount
end if
rs2.close
rs2.open"select * from question where sender='"&session("person")&"' and jie=1",conn,1,1
if rs2.eof then
jiejue="0"
else
jiejue=rs2.recordcount
end if
rs2.close
rs2.open"select * from question where sender='"&session("person")&"' and jie<>1",conn,1,1
if rs2.eof then
weijiejue="0"
else
weijiejue=rs2.recordcount
end if
rs2.close
%>
</table>
<%elseif request("lei")="tixian" then
if request("apply")="提 交" then
if (request.form("nm")="1" ) then
nmfen=mdf
niming=1
else
nmfen=0
niming=0
end if
if request("tixianjin")="" then
tixianjin=0
else
tixianjin=CDbl(request("tixianjin"))
end if
rs3.open"select * from person where name='"& session("person")&"'",conn,1,1
tixianjin1 = CDbl(rs3("qian"))
rs3.close
if tixianjin > tixianjin1 then
response.write"<script>alert('您的金额不足,请查证后继续!');history.back();</script>"
response.end
end if
if tixianjin <0 then
response.write"<script>alert('提现金额不能小于 50元 !');history.back();</script>"
response.end
elseif request("tixianfangshi")="" then
response.write"<script>alert('提现方式不能为空');history.back();</script>"
elseif request("tixian")="" then
response.write"<script>alert('确认提现不能为空!');history.back();</script>"
elseif request("tixianjin")="" then
response.write"<script>alert('提现金额不能为空!');history.back();</script>"
else
rs3.close
rs3.open"select * from person where name='"&name&"'",conn,1,3
rs3.update
rs3.close
response.write"<script>alert('提现成功!');window.navigate('tixian.asp');</script>"
end if
end if
%>