📄 order_info_operate.asp
字号:
<!-- #include file="../inc/conn.asp" -->
<!-- #include file="../inc/function.asp" -->
<%
if session("Sname") = "" then
%>
<SCRIPT language="javascript">
{
window.alert("您还没有登陆系统!");
window.location="default.asp";
}
</SCRIPT>
<%
response.end
end if
%>
<%
fid = request("fid")
if fid = "" then
%>
<SCRIPT language="javascript">
{
window.alert("非法操作!");
window.location="default.asp";
}
</SCRIPT>
<%
session.Abandon()
response.end
end if
%>
<%
status = request("status")
if status <> "" then
sql = "UPDATE orderform SET status = "&status&" WHERE fid = "&fid&""
conn.execute(sql)
response.Redirect("orderdeal.asp?isok=ok&order="&fid&"")
end if
%>
<html>
<head>
<LINK href="../inc/newdef.css" rel=stylesheet>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
</head>
<body bgcolor=#6696bc link=#000000 vlink=#000000 text=#000000 leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- #include file="../inc/head.asp" -->
<hr>
<form name="form1" method="post" action="order_info_operate.asp">
<input type="hidden" name="fid" value="<%=fid%>">
<input type="hidden" name="status" value="">
<table width="200" border="1" align="center">
<tr>
<td height="30"><table width="238" height="30" border="0">
<tr>
<%
sql = "SELECT orderform.fid, status.status, status.sid FROM orderform INNER JOIN status ON orderform.status = status.sid where fid= "&fid&""
rs.open sql,conn
if not rs.eof then
sid = rs("sid")
%>
<td><strong>订单详细</strong></td>
<td>状态:<%=rs("status")%></td>
<td>订单号:yk<%=rs("fid")%></td>
<%
end if
rs.close
%>
</tr>
</table></td>
</tr>
<tr>
<td><table width="565" height="473" border="1" align="center">
<tr>
<td height="35" colspan="4"><strong>商品信息：</strong></td>
</tr>
<%
sql = "SELECT ordersub.pid, ordersub.pname, ordersub.price, ordersub.number, orderform.total, orderform.datetime, orderform.fid, orderform.remark"
sql = sql&" FROM orderform INNER JOIN ordersub ON orderform.fid = ordersub.fid where orderform.fid="&fid&""
rs.open sql,conn
do while not rs.eof
datetime = mid(rs("datetime"),1,10)
total = rs("total")
remark = rs("remark")
%>
<tr>
<td width="88" height="30"><div align="right"> 商品编号：</div></td>
<td width="182" height="30"><div align="left"><%=rs("pid")%></div></td>
<td width="100" height="30">
<div align="right">商品名称： </div></td>
<td width="171" height="30"><div align="left"><%=rs("pname")%></div></td>
</tr>
<tr>
<td height="30"><div align="right">商品单价： <!--电子邮件: --></div></td>
<td height="30"><div align="left"><%=rs("price")%></div></td>
<td height="30"><div align="right">所构数量：</div></td>
<td height="30"><div align="left"><%=rs("number")%></div></td>
</tr>
<tr>
<td height="30"><div align="right"><strong>小计：</strong></div></td>
<td height="30"><%=rs("price")*rs("number")%>元</td>
<td height="30"> </td>
<td height="30"> </td>
</tr>
<%
rs.movenext
loop
rs.close
%>
<tr>
<td height="30"><div align="right">下单日期：</div></td>
<td height="30"><%=datetime%></td>
<td height="30"><div align="right"><strong>总价：</strong></div></td>
<td height="30"><div align="left"><%=total%>元</div></td>
</tr>
<tr>
<td height="35" colspan="4"><strong>用户信息：</strong></td>
</tr>
<%
sql = "SELECT orderform.fid , people.postalcode, people.uname, people.phone, people.email, people.address"
sql = sql&" FROM orderform INNER JOIN people ON orderform.uid = people.uid where fid="&fid&""
rs.open sql,conn
if not rs.eof then
%>
<tr>
<td height="30"><div align="right">联系人：</div></td>
<td height="30"><%=rs("uname")%></td>
<td height="30"><div align="right">电话：</div></td>
<td height="30"><%=rs("phone")%></td>
</tr>
<tr>
<td height="30"><div align="right">email：</div></td>
<td height="30"><%=rs("email")%></td>
<td height="30"><div align="right">邮政编码：</div></td>
<td height="30"><%=rs("postalcode")%></td>
</tr>
<tr>
<td height="30"><div align="right">地址：</div></td>
<td height="30" colspan="3"><div align="left"><%=rs("address")%></div></td>
</tr>
<%
end if
rs.close
conn.close
%>
<tr>
<td height="108" colspan="4">
<table width="559" height="102" border="1">
<tr>
<td width="98" height="96"><div align="right">客人附加要求：</div></td>
<td width="441"><textarea name="guestNeed" cols="50" rows="6" readonly="true"><%=remark%></textarea></td>
</tr>
</table> </td>
</tr>
</table></td>
</tr>
<tr>
<td>
<table width="569" border="1" align="center">
<tr>
<td width="90"><div align="center"><a href="javascript:change('1')">转原始订单</a></div></td>
<td width="90"><div align="center"><a href="javascript:change('2')">转待确认订单</a></div></td>
<td width="101"><div align="center"><a href="javascript:change('3')">转已确认订单</a></div></td>
<td width="94"><div align="center"><a href="javascript:change('4')">已付款订单</a></div></td>
<td width="82"><div align="center"><a href="javascript:change('5')">配送订单</a></div></td>
<td width="78"><div align="center"><a href="javascript:change('6')">无效订单</a></div></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<script language="javascript">
function change(stat){
if(confirm("你确定这次修改吗?")){
document.form1.status.value=stat;
document.form1.submit();
}
}
</script>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -