%
'如果没有登录客户端,则创建conn
'response.write application("conn")&"****"
'response.end
if isnull(application("conn")) or isempty(application("conn")) then
set application("conn")=Server.CreateObject ("Adodb.connection")
DSN="driver={Microsoft Access Driver (*.mdb)};Pwd=a1s2d3f4;dbq="&Server.MapPath ("/database/websitedata.mdb")
application("conn").open dsn
set application("conn2")=Server.CreateObject ("Adodb.connection")
DSN="driver={Microsoft Access Driver (*.mdb)};dbq="&Server.MapPath ("/database/zs.mdb")
application("conn2").open dsn
end if%>
<%
on error resume next
session("pathinfoczc")=Request.ServerVariables("PATH_INFO")
session("VAR")=request("id")
l=len(request("id"))
t=left(request("id"),4)
iCount = Session("ItemCount")
ARYshoppingcart = Session("MyShoppingCart")
if request("shopbz")<>1 then
If Request.QueryString("id") <> "" Then
id=request.querystring("id")
sql="update "&t&" set hitnumber=hitnumber+1 where sp_ida='" & id & "'"
Application("conn").Execute(SQL)
for i=0 to ubound(ARYshoppingcart,2)
if ARYshoppingcart(cartProductCode,i)=id then
'Response.Write ARYshoppingcart(cartProductCode,i)&" "
'Response.Write id&" "
ARYshoppingcart(cartItemQuantity,i)=ARYshoppingcart(cartItemQuantity,i)+1
'Response.Write ARYshoppingcart(cartProductName,i)
session("bz")=1
end if
next
if session("bz")<>1 then
If iCount < MaxShoppingCartItems Then
iCount = iCount + 1
End if
Session("ItemCount") = iCount
sql="select csjg,sp_ida,sp_name,unitprice,jf_price from "&t&" where sp_ida='" & id & "' and shbz='1' and saler='北京沃芳林保健品' "
Set RS = Application("conn").Execute(SQL)
If Not IsEmpty(RS) Then
ARYshoppingcart(cartCHECKED,iCount) = "CHECKED"
ARYshoppingcart(cartProductCode,iCount) = RS("sp_ida")
ARYshoppingcart(cartProductName,iCount) = RS("sp_name")
ARYshoppingcart(cartProductDescription,iCount) = RS("lb")
ARYshoppingcart(qx,iCount)=rs("lb")
ARYshoppingcart(cartItemQuantity,iCount) = 1
ARYshoppingcart(countbz,iCount) = request("tempcount")
ARYshoppingcart(csjg,iCount)=rs("csjg")
ARYshoppingcart(jf,iCount) = rs("jf_price")
'If RS("OnSale") Then
' ARYshoppingcart(cartUnitPrice,iCount) = csng(RS("UnitPrice")) - (csng(RS("UnitPrice")) * 0.1)
'Else
' ARYshoppingcart(cartUnitPrice,iCount) = RS("UnitPrice")
'End If
ARYshoppingcart(cartUnitPrice,iCount) = RS("UnitPrice")
'ARYshoppingcart(cartProductID,iCount) = RS("Companyname")
ARYshoppingcart(csjg,iCount)=rs("csjg")
Session("MyShoppingCart") = ARYshoppingcart
RS.Close
set rs=nothing
End If
End If
end if
end if
Session("MyShoppingCart") = ARYshoppingcart
session("bz")=0
SELECT CASE Request("Action")
CASE "调整物品"
For i = 1 to iCount
Quantity = Request("Quantity" & CStr(i))
If IsNumeric(Quantity) Then
ARYshoppingcart(cartItemQuantity,i) = abs(CLng(Quantity))
Else
ARYshoppingcart(cartItemQuantity,i) = 1
End If
Next
For i = 1 to iCount
If Request("Confirm" & CStr(i)) = "" Then
iCount = iCount - 1
For x = 1 to UBound(ARYshoppingcart,1)
ARYshoppingcart(x,i) = ""
Next
n = i
while n < UBound(ARYshoppingcart,2)
For x = 1 to UBound(ARYshoppingcart,1)
ARYshoppingcart(x,n) = ARYshoppingcart(x,n + 1)
ARYshoppingcart(x,n + 1) = ""
Next
n = n + 1
wend
End If
Next
Session("MyShoppingCart") = ARYshoppingcart
Session("ItemCount") = iCount
Response.Redirect "/order/order.asp"
CASE "决定购买"
iSubtotal = 0
For i = 1 to iCount
Quantity = Request("Quantity" & CStr(i))
If IsNumeric(Quantity) Then
ARYshoppingcart(cartItemQuantity,i) = abs(CLng(Quantity))
Else
ARYshoppingcart(cartItemQuantity,i) = 1
End If
numtem1=FormatCurrency(ARYshoppingcart(cartUnitPrice,i))
numtem2=clng(ARYshoppingcart(cartItemQuantity,i))
num_tem=numtem1*numtem2
iSubTotal = iSubtotal + num_tem
Next
session("total")=isubtotal
For i = 1 to iCount
If Request("Confirm" & CStr(i)) = "" Then
iCount = iCount - 1
For x = 1 to UBound(ARYshoppingcart,1)
ARYshoppingcart(x,i) = ""
Next
n = i
while n < UBound(ARYshoppingcart,2)
For x = 1 to UBound(ARYshoppingcart,1)
ARYshoppingcart(x,n) = ARYshoppingcart(x,n + 1)
ARYshoppingcart(x,n + 1) = ""
Next
n = n + 1
wend
End If
Next
Session("MyShoppingCart") = ARYshoppingcart
Session("ItemCount") = iCount
Response.Redirect "/order/getcustomer.asp"
END SELECT%>