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

📄 jszx.asp

📁 这是一个网上购物物网站,数据库的连接在CONN.ASP中,既有前台网站,也有后台管理
💻 ASP
📖 第 1 页 / 共 3 页
字号:
  if(document.shouhuoxx.useremail.value.length!=0)
  {
    if (document.shouhuoxx.useremail.value.charAt(0)=="." ||        
         document.shouhuoxx.useremail.value.charAt(0)=="@"||       
         document.shouhuoxx.useremail.value.indexOf('@', 0) == -1 || 
         document.shouhuoxx.useremail.value.indexOf('.', 0) == -1 || 
         document.shouhuoxx.useremail.value.lastIndexOf("@")==document.shouhuoxx.useremail.value.length-1 || 
         document.shouhuoxx.useremail.value.lastIndexOf(".")==document.shouhuoxx.useremail.value.length-1)
     {
      alert("Email地址格式不正确!");
      document.shouhuoxx.useremail.focus();
      return false;
      }
   }
 else
  {
   alert("Email不能为空!");
   document.shouhuoxx.useremail.focus();
   return false;
   }
   
}
//-->
</script>
      <%
rs.close
set rs=nothing

case "txxx4"
%>
      <table width="96%" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr> 
          <td> 
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td rowspan="2"> 
                  <table width="100%" border="0" cellspacing="0" cellpadding="0" class="12v">
                    <tr> 
                      <td class="12v" > 
                        <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber3" height="0" width="100%">
                          <tr> 
                            <td> 
                              <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
                                <tr bgcolor="#FFFFFF"> 
                                  <td align="center" valign="top" height=50 colspan=2> 
                                    <%
set rs=server.CreateObject("adodb.recordset")
rs.open "select actionid,goodid,username,name,goodcount,zonger,hyprice from act where username='"&username&"'and zhuangtai=7",conn,1,3
%>
                                    <table width=98% border=0 align=center cellpadding=1 cellspacing=1 bgcolor=#CCCCCC>
                                      <tr bgcolor="#f1f1f1"> 
                                        <td width=21%> 
                                          <div align=center><font color="#666666">商品名称</font></div>
                                        </td>
                                        <td width=27%> 
                                          <div align=center><font color="#666666">单价 
                                           
                                        </font></div></td>
                                        <td width=21%> 
                                          <div align=center><font color="#666666">数量</font></div>
                                        </td>
                                        <td width="31%"> 
                                          <div align=center></div>
                                          <div align=center><font color="#666666">总价</font></div></td>
                                      </tr>
                                      <%shuliang=rs.recordcount
jianshu=0
zongji=0
fudongjia=0
do while not rs.eof%>
                                      <tr bgcolor="#FFFFFF"> 
                                        <td style='PADDING-LEFT: 5px'> 
                                          <div align=left><font color=blue><%=rs("name")%></font> 
                                            <input name=bookid2 type=hidden value="<%=rs("goodid")%>" >
                                            <input name=actionid2 type=hidden value="<%=rs("actionid")%>" >
                                          </div>
                                        </td>
                                        <td align="center"> 
                                          <div align=center> 
                                              
	<%=rs("hyprice")%> 
  
                                        元</div></td>
                                        <td> 
                                          <div align=center><font color=#dd6600> 
                                            <%=rs("goodcount")%> </font></div>
                                        </td>
                                        <td> 
                                          <div align=center><font color=#dd6600> 
                                            
                                            </font></div>
                                          <div align=center><font color=#FF3300><%=rs("zonger")%></font>元</div></td>
                                      </tr>
                                      <%
jianshu=jianshu+rs("goodcount")
zongji=zongji+rs("zonger")
'算每件商品的浮动价
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from shop_fudong where id="&rs("banci"),conn,1,1 
fudongjia=fudongjia+rs("bookcount")*fudongjia_dj
rs_s.close
set rs_s=nothing

rs.movenext
loop
rs.close
set rs=nothing%>
                                      <tr bgcolor="#FFFFFF"> 
                                        <td height=36 colspan=5> 
                                          <div align=center> 货款总计:<%=zongji%>元</div>
                                        </td>
                                      </tr>
                      
                                      <tr bgcolor="#FFFFFF"> 
                                        <td colspan="4"> 
                                          
                                        </td>
                                      </tr>

                                    </table>
                                    <br>
                                  </td>
                                </tr>
                                <tr bgcolor="#FFFFFF"> 
                                  <td width="594"  align="center" valign="top"> 
                                    <table width="96%" border="0" cellspacing="1" cellpadding="2" bgcolor="#CCCCCC">
                                      <tr align="center" bgcolor="#f1f1f1"> 
                                        <td colspan="2" height="22"><b>您的订单信息</b></td>
                                      </tr>
                                      <tr bgcolor="#FFFFFF"> 
                                        <td width="23%">姓名<br>
                                        </td>
                                        <td width="77%"><%=request("truename")%></td>
                                      </tr>
                                      <tr bgcolor="#FFFFFF"> 
                                        <td width="23%">邮编<br>
                                        </td>
                                        <td width="77%"><%=request("youbian")%></td>
                                      </tr>
                                      <tr bgcolor="#FFFFFF"> 
                                        <td width="23%">地址<br>
                                        </td>
                                        <td width="77%"><%=request("address")%></td>
                                      </tr>
                                      <tr bgcolor="#FFFFFF"> 
                                        <td width="23%">电话<br>
                                        </td>
                                        <td width="77%"><%=request("telphone")%></td>
                                      </tr>
                                      <tr bgcolor="#FFFFFF"> 
                                        <td colspan="2" height=8></td>
                                      </tr>
                                      <tr bgcolor="#FFFFFF"> 
                                        <td width="23%">邮箱<br>
                                        </td>
                                        <td width="77%"><%=request("email")%></td>
                                      </tr>
                                      <tr bgcolor="#FFFFFF"> 
                                        <td colspan="2" height=8></td>
                                      </tr>
                                    </table>
                                  </td>
                                  <td width="356"  align="center" valign="top">&nbsp; 
                                    </td>
                                </tr>
                                <form name="shouhuoxx" method="post" action="jszx.asp?action=ok">
                                  <tr bgcolor="#FFFFFF" align="center"> 
                                    <td colspan="2"> 
                                      <table width="98%" border="0" cellspacing="0" cellpadding="2">
                                        <tr> 
                                          <td width="27%">&nbsp; 
                                          </td>
                                          <td width="42%"><br>                                          </td>
                                          <td width="31%" align="center" height="60"> 
                                            <input type="button" name="Submit22" class="go-wenbenkuang" value="上一步" onClick="javascript:history.go(-1)">
                                            <input type="submit" name="Submit42" class="go-wenbenkuang" value="完成">
                                          </td>
                                        </tr>
                                      </table>
                                    </td>
                                  </tr>
                                </form>
                              </table>
                            </td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
      <%

case "ok"
'/////////////////////////////////////////////////
function HTMLEncode2(fString)
	fString = Replace(fString, CHR(13), "")
	fString = Replace(fString, CHR(10) & CHR(10), "</P><P>")
	fString = Replace(fString, CHR(10), "<BR>")
	HTMLEncode2 = fString
end function

'修改用户的送货信息
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [user] where username='"&request.cookies("snsn")("username")&"'",conn,1,3
rs("userzhenshiname")=trim(request("userzhenshiname"))
rs("sex")=trim(request("shousex"))
rs("useremail")=trim(request("useremail"))
rs("shouhuodizhi")=trim(request("shouhuodizhi"))
rs("youbian")=trim(request("youbian"))
rs("usertel")=trim(request("usertel"))
rs("songhuofangshi")=trim(request("songhuofangshi"))
rs("zhifufangshi")=trim(request("zhifufangshi"))
rs.update
rs.close
set rs=nothing

if session("xiadan")<>minute(now) then
'再判断库存
'未写

dim shijian,dingdan
shijian=now()
'dingdan=year(shijian)&month(shijian)&day(shijian)&hour(shijian)&minute(shijian)&second(shijian)
'response.write bookid
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_action where username='"&request.cookies("snsn")("username")&"' and zhuangtai=7",conn,1,3
dingdan=year(shijian)&month(shijian)&day(shijian)&hour(shijian)&minute(shijian)&second(shijian)
do while not rs.eof
'得到价格,减库存
set rs2=server.CreateObject("adodb.recordset")
rs2.open "select * from shop_books where bookid="&rs("bookid"),conn,1,3
if request.Cookies("snsn")("reglx")=2 then 
	danjia=rs2("vipjia")
else

⌨️ 快捷键说明

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