⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 viewdingdan.asp

📁 网上书店是指在网上建立一个在线销售的图书平台,购书者可以实现在线定单提交,达到买书的目的.
💻 ASP
字号:
<!--#include file="conn.asp"-->
<!--#include file="zhuangtai.asp"-->
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登录!');window.location.reload('login.asp')</script>"
response.End
else
if session("flag")>1 then
response.Write "<div align=center><font size=80 color=red><b>您没有此项目管理权限!</b></font></div>"
response.End
end if
end if
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../images/css.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="5" topmargin="5" marginwidth="0" marginheight="0">
<%dim dingdan,username
dingdan=request.QueryString("dan")
username=request.QueryString("username")
set rs=server.CreateObject("adodb.recordset")
rs.open "select shop_books.bookid,shop_books.bookname,shop_books.shichangjia,shop_books.huiyuanjia,shop_action.actiondate,shop_action.shousex,shop_action.userzhenshiname,shop_action.shouhuoname,shop_action.dingdan,shop_action.youbian,shop_action.liuyan,shop_action.zhifufangshi,shop_action.songhuofangshi,shop_action.zhuangtai,shop_action.zonger,shop_action.useremail,shop_action.usertel,shop_action.shouhuodizhi,shop_action.bookcount from shop_books inner join shop_action on shop_books.bookid=shop_action.bookid where shop_action.username='"&username&"' and dingdan='"&dingdan&"' ",conn,1,1
%>

<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF">
  <tr bgcolor="#9966FF"> 
    <td colspan="2"><div align="center">订单号为:<%=dingdan%> ,详细资料如下:</div></td>
  </tr>
  <tr> 
    <td bgcolor="#EFF5FE" STYLE='PADDING-LEFT: 10px'>订单状态:</td>
    <td width="87%" bgcolor="#EFF5FE"><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <form name="form1" method="post" action="savedingdan.asp?dan=<%=dingdan%>&action=save&username=<%=username%>">
            <td > <%
                  zhuang()%> <br> &nbsp;&nbsp; 
              <input type="submit" name="Submit" value="修改订单状态"> </td>
          </form>
        </tr>
      </table></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td width="13%" STYLE='PADDING-LEFT: 10px'>商品列表:</td>
    <td><table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
        <tr bgcolor="#9999FF"> 
          <td><div align="center">商品名称</div></td>
          <td><div align="center">订购数量</div></td>
          <td><div align="center">会员价格</div></td>
          <td><div align="center">金额小计</div></td>
        </tr>
        <%dim iii
		do while not rs.eof%>
        <tr bgcolor="#9999FF"> 
          <td STYLE='PADDING-LEFT: 5px'><a href=../book.asp?id=<%=rs("bookid")%> target=_blank><%=trim(rs("bookname"))%></a></td>
          <td><div align="center"><%=rs("bookcount")%></div></td>
          <td><div align="center"><%=formatnumber(rs("huiyuanjia"),2)&"元"%></div></td>
          <td><div align="center"><%=formatnumber(rs("huiyuanjia")*rs("bookcount"),2)&"元"%></div></td>
        </tr>
        <%iii=rs("zonger")+iii
		rs.movenext
		loop
		rs.movefirst%>
        <tr bgcolor="#9999FF"> 
          <td colspan="4"><div align="right">用户选择的送货方式是: 
              <%dim qita
		  select case rs("songhuofangshi")
		  case "1"
		  qita=6
		  response.write "普通平邮"
		  case "2"
		  qita=20
		  response.write "特快专递(EMS)"
		  end select
		  response.write "&nbsp;+"&formatnumber(qita,2)&"元"
		  response.write "&nbsp;&nbsp;金额总计:"&formatnumber(iii+qita,2)&"元"
		  %>
          &nbsp;&nbsp;&nbsp;&nbsp;</div></td>
        </tr>
    </table></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td STYLE='PADDING-LEFT: 10px'>订货人姓名:</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("userzhenshiname"))%></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td STYLE='PADDING-LEFT: 10px'>收货人姓名:</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("shouhuoname"))%></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td STYLE='PADDING-LEFT: 10px'>收货地址:</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("shouhuodizhi"))%></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td STYLE='PADDING-LEFT: 10px'>邮编:</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("youbian"))%></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td STYLE='PADDING-LEFT: 10px'>联系电话:</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("usertel"))%></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td STYLE='PADDING-LEFT: 10px'>电子邮件:</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("useremail"))%></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td STYLE='PADDING-LEFT: 10px'>送货方式:</td>
    <td STYLE='PADDING-LEFT: 10px'><%select case rs("songhuofangshi")
	case "1"
	response.write "普通平邮"
	case "2"
	response.write "特快专递(EMS)"
	end select%></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td STYLE='PADDING-LEFT: 10px'>支付方式:</td>
    <td STYLE='PADDING-LEFT: 10px'><%select case rs("zhifufangshi")
	case "1"
	response.write "邮局汇款"
	case "2"
	response.write "建设银行汇款"
	case "3"
	response.write "交通银行汇款"
	end select %></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td STYLE='PADDING-LEFT: 10px'>用户留言:</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("liuyan"))%></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td height="20" STYLE='PADDING-LEFT: 10px'>下单日期:</td>
    <td height="20" STYLE='PADDING-LEFT: 10px'><%=rs("actiondate")%></td>
  </tr>
  <tr bgcolor="#9CCFFF"> 
    <td height="32" colspan="2"><div align="center"> 
        <input type="button" name="Submit3" value="删除订单" onClick="if(confirm('您确定要删除吗?')) location.href='savedingdan.asp?action=del&dan=<%=dingdan%>&username=<%=username%>';else return;">
        &nbsp;&nbsp; 
        <input type="button" name="Submit2" value="关闭窗口" onclick=javascript:window.close()>
    </div></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -