📄 disppaydb.asp
字号:
<!--#include file ="../profile/checksec.asp"-->
<%
cheque=request.form("chequenum")
userid=request.form("userid")
'开始数据库操作
Set Con=Server.CreateObject("ADODB.Connection")
Con.Open "driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("../database/yino.mdb")
set rs=server.createobject("adodb.recordset")
sql="select * from [main] where id=" & userid
rs.open sql,Con,1,3
if rs.eof and rs.bof then
response.redirect "../profile/errorpage.asp?id=unknow"
else
premoney=rs("premoney")
totalmoney=rs("totalmoney")
username=rs("username")
rs("premoney")=0
rs("totalmoney")=totalmoney+premoney
rs.update
rs.close
end if
sql="select * from [premoney] where (ID=null)"
rs.open sql,Con,1,3
rs.addnew
rs("prevalue")=premoney
rs("userID")=userid
rs("cheque")=cheque
rs("adddate")=now
rs.update
rs.close
con.close
%>
<HTML><HEAD><TITLE>处理预付款</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<STYLE type=text/css>TD {
FONT-FAMILY: "宋体"; FONT-SIZE: 9pt
}
.e_8 {
FONT-FAMILY: "Verdana"; FONT-SIZE: 8pt
}
.select {
BACKGROUND-COLOR: #ffffcc; COLOR: #000000
}
.input {
BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; COLOR: #ff0000
}
.x18 {
LINE-HEIGHT: 14pt
}
</STYLE>
<META content="MSHTML 5.00.3315.2870" name=GENERATOR></HEAD>
<BODY aLink=#990099 bgColor=#ffffff leftMargin=0 link=#0066ff text=#000000
topMargin=0 vLink=#cc0000>
<TABLE align=center bgColor=#000000 border=0 cellPadding=1 cellSpacing=0
width=640>
<TBODY>
<TR>
<TD>
<TABLE bgColor=#ffffff border=0 cellPadding=0 cellSpacing=0>
<TBODY>
<TR bgColor=#ffb41d>
<TD colSpan=3 height=12>
<div align="center"><img src="../images/enuologo.gif" width="468" height="60"></div>
</TD>
</TR>
<TR>
<TD colSpan=3><IMG height=1
src="../images/paycenter_02.gif"
width=640></TD></TR>
<TR>
<TD bgColor=#ffffff vAlign=top><IMG height=35
src="../images/paycenter_03.gif" width=475> <BR>
<form name=agentform action="udpassDB.asp" metod=post>
<TABLE align=center border=0 cellPadding=1 cellSpacing=0 width="60%">
<TBODY>
<tr>
<td><b>处理预付款!</b></td>
</tr>
<TR bgColor=#993300>
<TD align="center">
<table border=0 cellpadding=3 cellspacing=1 width="100%">
<tbody>
<tr>
<td bgcolor="#FFCC33" height="22" width="29%">用户预付款</td>
<td bgcolor="#FFFFFF" width="71%">
<%=premoney%>元
</td>
</tr>
<tr>
<td bgcolor="#FFCC33" height="22" width="29%">预付款支票号</td>
<td bgcolor="#FFFFFF" width="71%">
<%=cheque%>
</td>
</tr>
<tr>
<td bgcolor="#FFCC33" height="22" width="29%">用户现总金额</td>
<td bgcolor="#FFFFFF" width="71%">
<%=totalmoney+premoney%>元
</td>
</tr>
</tbody>
</table>
</TD>
</TR></TBODY></TABLE>
<P align=center> <a href="../index.asp"><返回></a>
</P>
</form></TD>
<TD bgColor=#000000 rowSpan=2 width=1><IMG height=407
src="../images/paycenter_04.gif" width=1></TD>
<TD align=middle bgColor=#ffb41d rowSpan=2 vAlign=top width=164>
<P><IMG height=7
src="../images/paycenter_05_01.gif"
width=164></P>
<table border="1" cellpadding="0" cellspacing="0" width="100%" bordercolordark="#CCCCCC" bordercolorlight="#000000" height="235">
<tr>
<td width="236" class="font" height="27" bgcolor="#FFFFCC"> <img border="0" src="../images/hand.gif" width="20" height="15"><img border="0" src="../images/link1.jpg" width="88" height="21"></td>
</tr>
<tr>
<td class="font" height="204" width="236"> <span style="background-color: #FF0000"><font color="#FFFFCC">总部电话：</font></span><br>
010-68133624(3线)<br>
<span style="background-color: #FF0000"><font color="#FFFFCC">总部传真：</font></span><br>
010-68253386<br>
<span style="background-color: #FF0000"><font color="#FFFFCC">昼夜值班：</font></span><br>
13911056652<br>
<span style="background-color: #0000FF"><font color="#FFFFFF">业务部：</font></span><br>
<a href="mailto:info@e-icann.com?subject=来自网站的反馈">info@e-icann.com</a><br>
<span style="background-color: #0000FF"><font color="#FFFFFF">技术部：</font></span><br>
<a href="mailto:master@e-icann.com?subject=来自网站的技术咨询">master@e-icann.com</a><br>
<span style="background-color: #0000FF"><font color="#FFFFFF">客户投诉：</font></span><br>
<a href="mailto:gao@e-icann.com?subject=来自网站的投诉">gao@e-icann.com</a>
</td>
</tr>
</table></TD></TR>
<TR>
<TD colSpan=3 height=1><IMG height=1
src="../images/paycenter_07.gif"
width=640></TD></TR>
<TR>
<TD><IMG height=18
src="../images/paycenter_08.gif" width=475></TD>
<TD width=1><IMG height=18
src="../images/paycenter_09.gif" width=1></TD>
<TD><IMG height=18
src="../images/paycenter_10.gif"
width=164></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -