📄 dispoperdb.asp
字号:
<!--#include file ="../profile/checksec.asp"-->
<!--#include file ="../profile/checksub.asp"-->
<%
operid=request.form("operid")
isopen=request.form("isopen")
dealworth=request.form("dealworth")
opendate=request.form("opendate")
'开始数据库操作
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 [deal] where id=" & operid
rs.open sql,Con,1,3
if rs.eof and rs.bof then
response.redirect "../profile/errorpage.asp?id=unknow"
else
rs("isdispose")=1
rs("inuredate")=opendate
rs("isdredge")=isopen
rs("dealworth")=dealworth
rs("disposer")=user
rs("disposedate")=now
rs.update
rs.close
end if
sql="select * from [main] where username='"&user&"'"
rs.open sql,Con,1,3
if rs.eof and rs.bof then
response.redirect "../profile/errorpage.asp?id=unknow"
else
usedmoney=rs("usedmoney")
rs("usedmoney")=usedmoney+dealworth
rs.update
rs.close
con.close
end if
%>
<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="98%">
<TBODY>
<tr>
<td><b>处理业务完毕！</b></td>
</tr>
<TR bgColor=#993300>
<TD align="center">
<table border=0 cellpadding=3 cellspacing=1 width="99%">
<tbody>
<tr>
<td bgcolor="#FFCC33" height="22" width="29%">生效日期</td>
<td bgcolor="#FFFFFF" width="71%">
<%=opendate%>
</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 + -