📄 chkorder.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="nimda/config.asp"-->
<!--#include file="edulcni/conn.asp"-->
<!--#include file="edulcni/chk.asp"--> <%
dim action,goods,UserName
UserName=trim(request.cookies(cookieName)("UserName"))
if NOT isempty(request.QueryString("action")) then
goods=request.QueryString("dan")
action=request.QueryString("action")
select case action
case "save"
if request("state")<>"" then
set rs=server.CreateObject("adodb.recordset")
rs.Open "select state from orders where goods='"&goods&"'",conn,1,3
do while not rs.EOF
rs("state")=request("state")
rs.Update
rs.MoveNext
loop
rs.Close
if request("state")=5 then
'response.write "select productnum,id from orders where state=5 and UserName='"&UserName&"'"
'response.end
rs.open "select productnum,id from orders where state=5 and UserName='"&UserName&"'",conn,1,1
dim rsSeled
set rsSeled=server.CreateObject("adodb.recordset")
do while not rs.eof
rsSeled.open "select solded from product where id="&rs("id"),conn,1,3
rsSeled("solded")=rsSeled("solded")+rs("productnum")
rsSeled.Update
rsSeled.close
rs.movenext
loop
set rsSeled=nothing
rs.close
end if
'rs.close
set rs=nothing
end if
call Msgbox("订单状态修改成功！","GoUrl","myorder.asp")
response.End
case "del"
set rs=server.CreateObject("adodb.recordset")
rs.open "select UserName,goods from orders where goods='"&goods&"' " ,conn,1,1
if request.cookies(cookieName)("UserName")<>trim(rs("UserName")) then
call Msgbox("response.Write ","Back","None")
response.End
end if
conn.execute "delete from orders where goods='"&goods&"' "
Call MsgBox("订单删除成功！","GoUrl","myorder.asp")
response.end
end select
end if%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>E书部落—网上书城</title>
<link href="style.css" rel="stylesheet" type="text/css"></head>
<body>
<!--#include file="head.htm"-->
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="218" align="left" valign="top" style="border-left: 1px dotted #65A8CF; border-top: 1px dotted #65A8CF; border-bottom: 1px dotted #65A8CF"><!--#include file="uleft.asp"--> <br></td><td width="560" align="left" valign="top" style="border-left: 1px dotted #65A8CF; border-right:1px dotted #65A8CF; border-top: 1px dotted #65A8CF; border-bottom: 1px dotted #65A8CF">
<br> <table border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/w.gif" width="18" height="18"></td>
<td style="color:#415373">订单详细资料</td>
</tr>
</table> <%
goods=request.QueryString("dan")
set rs=server.CreateObject("adodb.recordset")
rs.open "select product.id,product.name,product.price1,product.price2,product.vipprice,orders.actiondate,orders.UserSex,orders.realname,orders.recipient,orders.goods,orders.postcode,orders.comments,orders.paymethod,orders.Invoice,orders.delivermethod,orders.state,orders.paid,orders.UserEmail,orders.usertel,orders.address,orders.productnum from product inner join orders on product.id=orders.id where orders.UserName='"&request.cookies(cookieName)("UserName")&"' and goods='"&goods&"' ",conn,1,1
if rs.eof and rs.bof then
response.write "<center>此订单中有商品已被管理员删除，无法进行正确计算。<br>订单取消，请通知管理员或重新下订单！</center>"
response.End
end if
%> <br> <table width="98%" border="0" cellspacing="0" cellpadding="1" align="center">
<tr >
<td colspan="2">
<div align="center">订单号为：<%=goods%> ，详细资料如下：</div></td>
</tr>
<tr >
<td colspan="2" valign="top">订单状态： <br>
<br><form name="form1" method="post" action="chkorder.asp?dan=<%=goods%>&action=save">
<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
<tr>
<td><% grade() %></td>
</tr>
<tr>
<td align="right">
<input type="submit" name="Submit" value="修改订单状态">
</td>
</tr>
</table></form></td>
</tr>
<tr >
<td colspan="2" valign="top">商品列表：<br>
<br> <table width="100%" border="0" align="center" cellpadding="1" cellspacing="1" >
<tr align="center">
<td>商品名称</td>
<td width="12%">订购数量</td>
<td width="12%">市场价</td>
<td width="12%">会员价</td>
<td width="16%">VIP会员价</td>
<td width="16%">金额小计</td>
</tr>
<%dim iii
do while not rs.eof%>
<tr>
<td style='PADDING-LEFT: 5px'><a href=product.asp?id=<%=rs("id")%> target=_blank><%=trim(rs("name"))%></a></td>
<td align="center"><%=rs("productnum")%></td>
<td align="center"><%=rs("price1")%>元</td>
<td align="center"><%=rs("price2")%>元</td>
<td align="center"><%=rs("vipprice")%>元</td>
<td align="center"><%=rs("paid")*rs("productnum")%>元</td>
</tr>
<%iii=rs("paid")+iii
rs.movenext
loop
rs.movefirst%>
<tr bgcolor= #FFFFFF>
<td colspan="6" height="19" align="center"><br>
您选择的送货方式是：
<%dim rs2
set rs2=server.CreateObject("adodb.recordset")
rs2.Open "select * from deliver where deliverid="&rs("delivermethod"),conn,1,1
if rs2.EOF and rs2.BOF then
response.Write "方式已经被删除"
response.write " 附加费用：0元"
response.write " 金额总计："&iii&" 元"
else
response.Write trim(rs2("subject"))
response.write " 附加费用："&rs2("fee")&"元"
response.write " 金额总计：<font color=red>"&iii+rs2("fee")&"</font> 元"
end if
rs2.Close
set rs2=nothing
%>
<br>
<br>
</td>
</tr>
</table></td>
</tr>
<tr >
<td width="17%" style='PADDING-LEFT: 10px'>订货人姓名：</td>
<td width="83%" style='PADDING-LEFT: 10px'><%=trim(rs("realname"))%></td>
</tr>
<tr >
<td style='PADDING-LEFT: 10px'>收货人姓名：</td>
<td style='PADDING-LEFT: 10px'><%=trim(rs("recipient"))%></td>
</tr>
<tr >
<td style='PADDING-LEFT: 10px'>收货地址：</td>
<td style='PADDING-LEFT: 10px'><%=trim(rs("address"))%></td>
</tr>
<tr >
<td style='PADDING-LEFT: 10px'>邮 编：</td>
<td style='PADDING-LEFT: 10px'><%=trim(rs("postcode"))%></td>
</tr>
<tr >
<td style='PADDING-LEFT: 10px'>联系电话：</td>
<td style='PADDING-LEFT: 10px'><%=trim(rs("usertel"))%></td>
</tr>
<tr >
<td style='PADDING-LEFT: 10px'>电子邮件：</td>
<td style='PADDING-LEFT: 10px'><%=trim(rs("UserEmail"))%></td>
</tr>
<tr >
<td style='PADDING-LEFT: 10px'>送货方式：</td>
<td style='PADDING-LEFT: 10px'>
<%
set rs2=server.CreateObject("adodb.recordset")
rs2.Open "select * from deliver where deliverid="&int(rs("delivermethod")),conn,1,1
if rs2.eof and rs2.bof then
response.write "方式已被删除"
else
response.Write trim(rs2("subject"))
end if
rs2.close
set rs2=nothing%>
</td>
</tr>
<tr >
<td style='PADDING-LEFT: 10px'>支付方式：</td>
<td style='PADDING-LEFT: 10px'>
<%
set rs2=server.CreateObject("adodb.recordset")
rs2.open "select * from deliver where deliverid="&int(rs("paymethod")),conn,1,1
if rs2.eof and rs2.bof then
response.write "方式已被删除"
else
response.Write trim(rs2("subject"))
end if
rs2.Close
set rs2=nothing
%>
</td>
</tr>
<tr >
<td style='PADDING-LEFT: 10px'>是否开发票：</td>
<td style='PADDING-LEFT: 10px'><%if rs("Invoice")=1 then %><font color=red>需要发票</font><%else%>不需要发票<%end if%></td>
</tr>
<tr >
<td style='PADDING-LEFT: 10px'>您的留言：</td>
<td style='PADDING-LEFT: 10px'><%=trim(rs("comments"))%></td>
</tr>
<tr >
<td style='PADDING-LEFT: 10px'>下单日期：</td>
<td style='PADDING-LEFT: 10px'><%=rs("actiondate")%></td>
</tr>
<tr >
<td height="32" colspan="2"> <div align="center">
<%if rs("state")=1 then%>
<input type="button" name="Submit3" value="删除订单" onClick="location.href='chkorder.asp?action=del&dan=<%=goods%>'">
<%end if%>
<input type="button" name="Submit2" value="关闭窗口" onclick="window.close()">
</div></td>
</tr>
</table> <%sub grade()
select case rs("state")
case "1"%> <input name="checkbox" type="checkbox" DISABLED id="checkbox" value="checkbox" checked>
未作任何处理<span style='font-family:Wingdings;'>à</span> <input name="state" type="checkbox" id="state" value="2">
用户已经划出款<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox2" value="checkbox" DISABLED>
服务商已经收到款<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox3" value="checkbox" DISABLED>
服务商已经发货<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox4" value="checkbox" DISABLED>
用户已经收到货
<%case "2"%> <input name="checkbox" type="checkbox" DISABLED id="checkbox" value="checkbox" checked>
未作任何处理<span style='font-family:Wingdings;'>à</span> <input name="checkbox" type="checkbox" id="state" value="2" checked DISABLED>
用户已经划出款<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox2" value="checkbox" DISABLED>
服务商已经收到款<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox3" value="checkbox" DISABLED>
服务商已经发货<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox4" value="checkbox" DISABLED>
用户已经收到货
<%case "3"%> <input name="checkbox" type="checkbox" DISABLED id="checkbox" value="checkbox" checked>
未作任何处理<span style='font-family:Wingdings;'>à</span> <input name="checkbox" type="checkbox" id="state" value="2" checked DISABLED>
用户已经划出款<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox2" value="checkbox" checked DISABLED>
服务商已经收到款<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox3" value="checkbox" DISABLED>
服务商已经发货<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox4" value="checkbox" DISABLED>
用户已经收到货
<%case "4"%> <input name="checkbox" type="checkbox" DISABLED id="checkbox" value="checkbox" checked>
未作任何处理<span style='font-family:Wingdings;'>à</span> <input name="checkbox" type="checkbox" id="state" value="2" checked DISABLED>
用户已经划出款<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox2" value="checkbox" checked DISABLED>
服务商已经收到款<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox3" value="checkbox" checked DISABLED>
服务商已经发货<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="state" value="5" >
用户已经收到货
<%case "5"%> <input name="checkbox" type="checkbox" DISABLED id="checkbox" value="checkbox" checked>
未作任何处理<span style='font-family:Wingdings;'>à</span> <input name="checkbox" type="checkbox" id="state" value="2" checked DISABLED>
用户已经划出款<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox2" value="checkbox" checked DISABLED>
服务商已经收到款<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox3" value="checkbox" checked DISABLED>
服务商已经发货<span style='font-family:Wingdings;'>à</span> <input type="checkbox" name="checkbox4" value="checkbox" checked DISABLED>
用户已经收到货
<%end select
end sub%> <br> <br>
</td>
</tr>
</table>
<!--#include file="foot.htm"-->
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -