| 订单编号：<%=rs("goodsid")%> |
订单用户：<%=rs("username")%> |
订购日期：<%=rs("dcreatedate")%> |
| 支付方式：<%=rs("payfs")%> |
发货方式：<%=rs("sendfs")%> |
发货区域：<%=rs("area")%> |
货品毛量：<%=rs("totalmz")%>kg |
|
收货人信息：........................................................................................................................................................................... |
| 姓名：<%=rs("name")%> |
性别：
<%if rs("sex")=0 then%>
男
<%else%>
女
<%end if%> |
邮箱：<%=rs("email")%> |
| 电话：
<%if rs("mob")<> "" then %>
<%=rs("mob")%>,
<%end if%>
<%=rs("tel")%> |
|
|
| 地址： <%if rs("checkadd")="checkadd1" then%><% =rs("city")%> <% =rs("address")%> <% if rs("postcode")<>"" then%>,邮编:<%=rs("postcode")%><%end if%> <%elseif rs("checkadd")="checkadd2" then%><% =rs("city2")%> <% =rs("address2")%> <% if rs("postcode2")<>"" then%>,邮编:<%=rs("postcode2")%><%end if%> <%end if%> |
|
商品信息：............................................................................................................................................................................... |
| 产品编号 |
名称 |
数量 |
单价 |
总价 |
<%
set rs1=server.CreateObject("adodb.recordset")
rs1.open "select tproduct.id,tproduct.tproduct_bh,tproduct.tproduct,orders.productnum,tproduct.tpricenet,tproduct.tprice1,tproduct.tprice2,tproduct.tprice3,tproduct.tprice4,orders.jiage,orders.actionid from orders, tproduct where orders.goods='"& igoodsid &"' and orders.id=tproduct.id order by orders.actionid ",conn,1,1
intTotalNum = rs1.RecordCount
sum1=0
sum=0
sums1=0
sumcount=0
do while not rs1.eof
%>
| <%=rs1(1)%> |
<%if rs1(9)=0 then
response.write "（赠品）"& rs1(2)
else
response.write rs1(2)
end if%> |
<%productnum=rs1(3)
sumcount=productnum+sumcount
response.write productnum%> |
<% iprice=rs1(9)%>￥<%=iprice%>
|
￥<% = iprice*productnum%>
<%sum1=iprice*productnum+sum1%>
|
<%
rs1.movenext
loop
rs1.close
set rs1=nothing%>
总价：<%=sum1%>元,<%=sumcount%>件，此订单内共有<%=intTotalNum%>品种商品 |
|
|