<% Call SiteInfo() Dim Products Dim mMemID, mRealName, mSex, mCompany, mAddress, mZipCode, mTelephone, mFax, mMobile, mEmail If session("MemName")<>"" And session("MemLogin") = "Succeed" Then Call MemInfo() Else mSex = "Mr." mMemID = 0 End If %> Inquiry - <% =SiteTitle %>

首页<%=WebLocation()%>

<% call ProductList() %>
标题: *
相关说明:
联系人: *
性别: /> 男士 /> 女士 *
单位名称: *
详细地址: *
联系电话: *
传真号码:
手机号码:
电子信箱: *
验证码: *
 
<% Function WebLocation() WebLocation = " 所有产品 - 询价单 "&vbCrLf End Function Function NoList() If request("UpdateOrder") = "Update choice" Then Session("NoList") = "" End If Dim ProductNo, NoArray, i If Trim(request("ProductNo"))<>"" Then ProductNo = Trim(request("ProductNo"))&"," If session("NoList") = "" And Trim(request("ProductNo")) = "" Then NoList = "" Exit Function End If If InStr(ProductNo, ",")>0 Then NoArray = Split(ProductNo, ",") For i = 0 To UBound(NoArray) If Not InStr(session("NoList"), NoArray(i)&",")>0 Then session("NoList") = session("NoList")&NoArray(i)&"," Next End If For i = 0 To UBound(Split(session("NoList"), ",")) NoList = NoList&"'"&Trim(Split(session("NoList"), ",")(i))&"'," Next NoList = Left(NoList, Len(NoList) -4) End Function Function ProductList() Response.Write ""&vbCrLf Response.Write " "&vbCrLf Response.Write " "&vbCrLf Response.Write " "&vbCrLf Response.Write " "&vbCrLf If Nolist() = "" Then Response.Write " "&vbCrLf Response.Write " "&vbCrLf Response.Write " "&vbCrLf Else Dim rs, sql Set rs = server.CreateObject("adodb.recordset") sql = "select * from Qianbo_Products where ProductNo in ("&NoList()&") order by id" rs.Open sql, conn, 1, 1 While Not rs.EOF If ISHTML = 1 Then AutoLink = ""&rs("ProUrl")&"."&HTMLName&"" Else AutoLink = "ProductView.Asp?ID="&rs("ID")&"" End If Response.Write " "&vbCrLf Response.Write " "&vbCrLf Response.Write " "&vbCrLf Response.Write " "&vbCrLf Products = Products&rs("ProductName")&" Product Numbers:"&rs("ProductNo")&"
" rs.movenext Wend Response.Write " "&vbCrLf Response.Write " "&vbCrLf Response.Write " "&vbCrLf rs.Close Set rs = Nothing End If Response.Write " "&vbCrLf Response.Write "
下面是您要询价的产品:
Not choose any products
"&rs("ProductName")&" ["&rs("ProductNo")&"]
"&vbCrLf End Function Sub MemInfo() Dim rs, sql Set rs = server.CreateObject("adodb.recordset") sql = "select * from Qianbo_Members where MemName='"&session("MemName")&"'" rs.Open sql, conn, 1, 1 If rs.bof And rs.EOF Then response.Write "
No relevant information
" Else mMemID = rs("ID") If Not rs("RealName") = "" Then mRealName = rs("RealName") Else mRealName = rs("MemName") End If mSex = rs("Sex") mCompany = rs("Company") mAddress = rs("Address") mZipCode = rs("ZipCode") mTelephone = rs("Telephone") mFax = rs("Fax") mMobile = rs("Mobile") mEmail = rs("Email") End If rs.Close Set rs = Nothing End Sub %>