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

📄 dingdan.asp

📁 BJXSHOP购物管理系统是一个功能完善、展示信息丰富的电子商店销售平台；针对企业与个人的网上销售系统；开放式远程商店管理；完善的订单管理、销售统计、结算系统；强力搜索引擎支持；提供网上多种在线支付方
💻 ASP
字号:
🔍 
<!--#include file="connection.asp"-->
<%if request.cookies("bookshop")("username")="" then
response.write "<script language=javascript>alert('对不起，您还没有登陆！');window.location.reload('javascript:window.close()')</script>"
response.End
end if%>
<!--#include file="webconfig.asp"-->
<html>
<head>
<title><%=webname%>--订单详细资料</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="images/default.css" rel="stylesheet" type="text/css">
</head>
<body leftmargin="5" topmargin="5" marginwidth="0" marginheight="0">
<img src="images/dingdanziliao.gif" width="305" height="43">
<%dim dingdan,userid
dingdan=request.QueryString("dan")
set rs=conn.execute("select shop_books.bookid,shop_books.bookname,shop_books.shichangjia,shop_books.huiyuanjia,shop_books.tuantijia,shop_books.tuantidazhe,shop_action.actiondate,shop_action.shousex,shop_action.userzhenshiname,shop_action.shouhuoname,shop_action.dingdan,shop_action.shengshi,shop_action.youbian,shop_action.liuyan,shop_action.zhifufangshi,shop_action.songhuofangshi,shop_action.querenfangshi,shop_action.dizhileixing,shop_action.zhuangtai,shop_action.zonger,shop_action.useremail,shop_action.usertel,shop_action.userid,shop_action.shouhuodizhi,shop_action.bookcount from shop_books inner join shop_action on shop_books.bookid=shop_action.bookid where shop_action.username='"&request.Cookies("bookshop")("username")&"' and dingdan='"&dingdan&"' ")
if rs.eof and rs.bof then
response.write "<center>此订单或订单中某图书已被管理员删除，无法进行正确计算。<br>订单取消，请通知管理员或重新下订单！</center>"
response.End
end if
userid=rs("userid")
%>

<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#FFFFFF">
  <tr bgcolor="#FDE6A4"> 
    <td colspan="2" bgcolor="#FF8E19"><div align="center">订单号：<%=dingdan%> ，详细资料如下：</div></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>订单状态：</td>
    <td width="87%"><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <form name="form1" method="post" action="savedingdan.asp?dan=<%=dingdan%>&action=save">
            <td > <%
                  zhuang()%> <br> &nbsp;&nbsp; <input type="submit" name="Submit" value="修改订单状态"> 
            </td>
          </form>
        </tr>
    </table></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td width="13%" STYLE='PADDING-LEFT: 10px'>商品列表：</td>
    <td><table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FF8E19">
        <tr bgcolor="#FDFADD"> 
          <td><div align="center">商品名称</div></td>
          <td><div align="center">订购数量</div></td>
          <td><div align="center"> 
              <%
		  if request.cookies("bookshop")("grtt")=1 then
		  response.write "团体价格"
		  else
		  response.write "会员价格"
		  end if%>
          </div></td>
          <td><div align="center">金额小计</div></td>
        </tr>
        <%dim iii
		do while not rs.eof%>
        <tr bgcolor="#FDFADD"> 
          <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"> 
              <%
		  if request.cookies("bookshop")("grtt")=1 then
		  response.write formatnumber(rs("tuantijia"),2)&"元"
		  else
		  response.write formatnumber(rs("huiyuanjia"),2)&"元"
		  end if%>
          </div></td>
          <td><div align="center"> 
              <%
		  if request.cookies("bookshop")("grtt")=1 then
		  response.write formatnumber(rs("tuantijia")*rs("bookcount"),2)&"元"
		  else
		  response.write formatnumber(rs("huiyuanjia")*rs("bookcount"),2)&"元"
		  end if%>
          </div></td>
        </tr>
        <%iii=rs("zonger")+iii
		rs.movenext
		loop
		rs.movefirst%>
        <tr bgcolor="#FDFADD"> 
          <td colspan="4"><div align="right">
		  
		  <%'//判断是否大于100元
			  if iii < 100 then
			  %>您选择的送货方式是： 
              <%dim rs2
              set rs2=conn.execute("select * from shop_songhuo where songid="&rs("songhuofangshi") )
              if rs2.EOF and rs2.BOF then
              response.Write "方式已经被删除"
              response.write "&nbsp;+"&formatnumber(0,2)&"元"
		  response.write "&nbsp;&nbsp;金额总计："&formatnumber(iii,2)&"元"
              else
              response.Write trim(rs2("subject"))
              response.write "&nbsp;+"&formatnumber(rs2("jsmoney"),2)&"元"
		  response.write "&nbsp;&nbsp;金额总计："&formatnumber(iii+rs2("jsmoney"),2)&"元"
		  dim zongjiner
		  zongjiner=formatnumber(iii+rs2("jsmoney"),2)
		  end if
		  rs2.Close
		  set rs2=nothing
		  
		  else 		'//超过100元，不记邮费
		 				
		  response.write "<font color=#ff6600>购书总金额超过100元不记邮费，</font>"
		  response.write "共计："&formatnumber(iii,2)&"元"
		  end if
		  %>
          &nbsp;&nbsp;&nbsp;&nbsp;</div></td>
        </tr>
    </table></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'><%if request.cookies("bookshop")("grtt")=1 then
	response.write "订货公司："
	else
	response.write "订货人姓名："
	end if%></td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("userzhenshiname"))%></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>收货人姓名：</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("shouhuoname"))%></td>
  </tr>
  <tr bgcolor="#FDE6A4">
    <td STYLE='PADDING-LEFT: 10px'>收货人省/市：</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("shengshi"))%></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>收货地址：</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("shouhuodizhi"))%></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>地址类型：</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("dizhileixing"))%></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>邮编：</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("youbian"))%></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>联系电话：</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("usertel"))%></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>电子邮件：</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("useremail"))%></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>配送方式：</td>
    <td STYLE='PADDING-LEFT: 10px'><%set rs2=conn.execute("select * from shop_songhuo where songid="&rs("songhuofangshi") )
    dim songhuoid '记下送货Id
	songhuoid=rs("songhuofangshi")
	response.Write trim(rs2("subject"))
    rs2.Close
    set rs2=nothing%></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>支付方式：</td>
    <td STYLE='PADDING-LEFT: 10px'><%dim yufu
	if int(rs("zhifufangshi"))=9999 then
		yufu="yes"
		response.write "使用预付款"
		else
		yufu="no"
		set rs2=conn.execute("select * from shop_songhuo where songid="&rs("zhifufangshi") )
    response.Write trim(rs2("subject"))
    rs2.close
    set rs2=nothing
	end if%></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>配送说明：</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("querenfangshi"))%></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>您的留言：</td>
    <td STYLE='PADDING-LEFT: 10px'><%=trim(rs("liuyan"))%></td>
  </tr>
  <tr bgcolor="#FDE6A4"> 
    <td STYLE='PADDING-LEFT: 10px'>下单日期：</td>
    <td STYLE='PADDING-LEFT: 10px'><%=rs("actiondate")%></td>
  </tr>
  <tr> 
    <td height="32" colspan="2" bgcolor="#FF8E19"><div align="center"> 
        <form name="form2" method="post" action="savedingdan.asp?action=del&dan=<%=dingdan%>&id=<%=songhuoid%>" >
          <br>
          <%if rs("zhuangtai")=1 then%>
          <input type="hidden" name="zongjiner" value="<%=zongjiner%>">
          <input type="hidden" name="yufu" value="<%=yufu%>">
          <input type="hidden" name=userid value=<%=userid%>>
          <input type="submit" name="Submit3" value="取消订单" onClick="return confirm('您确定要取消吗？')">
          <%end if%>
          &nbsp;&nbsp; 
          <input type="button" name="Submit2" value="关闭窗口" onclick=javascript:window.close()>
        </form>
    </div></td>
  </tr>
</table>
</body>
</html>
<%conn.close
set conn=nothing%>
<%sub zhuang()
select case rs("zhuangtai")
case "1"%>
<input name="checkbox" type="checkbox" DISABLED id="checkbox" value="checkbox" checked>未作任何处理<span style='font-family:Wingdings;'>à</span> 
<input name="zhuangtai" type="checkbox" id="zhuangtai" 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="zhuangtai" 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="zhuangtai" 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="zhuangtai" 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="zhuangtai" 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="zhuangtai" 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>用户已经收到货
<%case "7"%>
<input name="checkbox" type="checkbox" DISABLED id="Checkbox1" value="checkbox" >未作任何处理<span style='font-family:Wingdings;'>à</span> 
<input name="checkbox" type="checkbox" id="Checkbox2" value="2"  DISABLED>用户已经划出款<span style='font-family:Wingdings;'>à</span> 
<input type="checkbox" name="checkbox2" value="checkbox"  DISABLED ID="Checkbox3">服务商已经收到款<span style='font-family:Wingdings;'>à</span> 
<input type="checkbox" name="checkbox3" value="checkbox"  DISABLED ID="Checkbox4">服务商已经发货<span style='font-family:Wingdings;'>à</span> 
<input type="checkbox" name="checkbox4" value="checkbox"  DISABLED ID="Checkbox5">用户已经收到货<span style='font-family:Wingdings;'>à</span>
<input type="checkbox" name="checkbox4" value="7"  checked DISABLED ID="Checkbox6">该订单已被取消
<%end select
end sub%>
</body>
</html>

⌨️ 快捷键说明

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