📄 add_spok.asp

📁 一套很早的多用户电子商务程序
💻 ASP
字号:
<%@ language="vbscript"%>
<%response.Expires = 0%>
<!--#include file="conn.asp"--><!--#include file="check_user.asp"-->
<%

set rs = server.CreateObject ("Adodb.recordset")
	sql="select Max(ID) from Product"
	rs.open sql,conn,1,1
	if rs.eof and rs.bof then
	IDNum=1
	else
	IDNum=rs(0)+1
	end if
	if isnull(IDNum) then IDNum=1
rs.close	
sp_name=request.cookies("sp_name")

set rs=server.createobject("adodb.recordset")
sqltext="select shop_name2 from shop where shop_name1='"&sp_name&"'"
rs.open sqltext,conn,1,1
shop_name2=rs("shop_name2")
rs.close:set rs=nothing
set rs=server.createobject("adodb.recordset")
sqltext="select * from Product"
rs.open sqltext,conn,1,3
'添加一个商品到数据库
rs.addnew
'rs("Id")=IDNum '自动编号
rs("Product_Id")=IDNum   '商品编号
rs("Classification")=request.form("Classification")  '商家商品分类ID号
rs("Class_2")=request.form("class_2_name")  '本站二级分类
rs("Class_1")=request.form("class_1_name")  '本站一级分类
rs("Product_name")=request.form("p_name")  '产品名称
rs("units")=request.form("units")  '产品单位
rs("guige")=request.form("guige")  '产品规格
rs("P_newprice")=request.form("newprice")  '会员价
rs("P_oldprice")=request.form("oldprice")   '市场价
rs("factory")=request.form("factory")
rs("locus")=request.form("locus")
rs("small_pic")=request.form("small_pic")   '商品小图
rs("big_pic")=request.form("big_pic")   '商品大图
rs("Product_intro")=request("p_intro") '产品简介
rs("Product_show")=request("p_show")  '产品说明
rs("P_shop")=sp_name   '所属商家
rs("shop_name2")=shop_name2
rs.update
rs.close:set rs=nothing

set rs=server.createobject("adodb.recordset")
sql="select top 1 * from Product where P_shop='"&sp_name&"' order by id desc"
rs.open sql,conn,1,1
%>

<html>
<head>
<title>商品添加</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
BODY {	FONT-SIZE: 9pt }
a:link { color: #000000; text-decoration: none}
a:visited { color:#000000; text-decoration: none}
a:hover { color: #CC0000; text-decoration: underline}
td {font-size:9pt;line-height:12pt;}
-->
</style>
</head>

<body background="../pic/user/bg.jpg" leftmargin="0" topmargin="0">
<div align="center"><br>
  <strong>商品添加成功</strong></div>
<br>
<table width="58%" border="1" align="center" cellpadding="4" cellspacing="0" bordercolorlight="#0000FF" bordercolordark="#FFFCF0">
  <tr> 
    <td height="121" colspan="2"> <div align="center"> <br>
        <img src="<%=rs("big_pic")%>"  border="0"  ></div>
      <div align="center"> <font color="red">浏览次数：</font><%=rs("Look_Count")%><br>
      </div></td>
  </tr>
  <tr> 
    <td width="52%"> <p>【<b><font color="#FF0000">商品名称</font></b>】：<%=rs("Product_name")%> 
      </p></td>
    <td width="48%">【<b><font color="#FF0000">市场价格</font></b>】：<span class="main1"><strike><%=rs("P_oldprice")%>元</strike></span> 
    </td>
  </tr>
  <tr> 
    <td> <p>【<b><font color="#FF0000">所属类别</font></b>】：<%=rs("Class_2")%><span class="main1"></span> 
      </p></td>
    <td>【<b><font color="#FF0000">会员价格</font></b>】：<%=rs("p_newprice")%><span class="main1">元&nbsp;</span></td>
  </tr>
  <tr> 
    <td> <p>【<b><font color="#FF0000">商品单位</font></b>】：<span class="main1"></span><%=rs("units")%> 
      </p></td>
    <td>【<b><font color="#FF0000">商品规格</font></b>】：<%=rs("guige")%></td>
  </tr>
  <tr> 
    <td> <p>【<b><font color="#FF0000"><span       
                  class=main1>生产厂家</span></font></b>】：<span class="main1"></span><%=rs("factory")%> 
      </p></td>
    <td>【<b><font color="#FF0000">商品所在地</font></b>】：<%=rs("locus")%></td>
  </tr>
  <tr> 
    <td colspan="2"> <p>【<b><font color="#FF0000">商品简介</font></b>】：<%=replace(replace(rs("Product_intro")," ","&nbsp;&nbsp;"),chr(13)+chr(10),"<br>")%></p></td>
  </tr>
  <tr> 
    <td colspan="2"> <p><b><font color="#0000FF">【备　　注】</font></b>：<%=replace(replace(rs("Product_show")," ","&nbsp;&nbsp;"),chr(13)+chr(10),"<br>")%></p></td>
  </tr>
  <tr> 
    <td colspan="2"> <p align="center"> 
        <input type="button" class=main  size=3 value='添加下一个' name=Submit2 onClick="window.location.href='add_sp1.asp';">
        <input type="button" class=main  size=3 value='　返　回　' name=Submit22 onClick="window.location.href='right.asp';">
      </p></td>
  </tr>
</table>
</body>
</html>
⌨️ 快捷键说明

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