savebrand.asp

一个ASP做的购物车

<!--#include file="conn.asp"-->
<!--#include file="session1.asp"-->
<%
dim pingpaiid,pingpaiorder,pingpainame,tuijian,i
if request("action")="update" then
    for i=1 to request.form("pingpaiid").count
	pingpaiid=replace(request.form("pingpaiid")(i),"'","")
	pingpaiorder=replace(request.form("pingpaiorder")(i),"'","")
	tuijian=replace(request.form("tuijian")(i),"'","")
	pingpainame=replace(request.form("pingpainame")(i),"'","")
	if replace(request.form("pingpaiorder")(i),"'","")="" then
%>
<script language=javascript>
history.back()
alert("请填写品牌的显示排序！")
</script>
<%
Response.End
end if
conn.execute("update wq_pingpai set pingpaiorder="&pingpaiorder&",pingpainame='"&pingpainame&"',tuijian="&tuijian&" where id="&pingpaiid)
next
conn.close
set conn=nothing
response.Write "<script language='javascript'>alert('品牌设置成功!！');window.location.href='ManageBrand.asp';</script>"
response.End
end if

if request("action")="add" then
	tuijian=request.form("tuijian")
	pingpainame=trim(request("pingpainame"))
	pingpaiorder=request.form("pingpaiorder")
	If pingpainame="" Then
		response.write "品牌名称不能为空！请<a href=javascript:history.go(-1)>返回重新填写</a>！"
		response.end
	end if
	If pingpaiorder="" Then
		response.write "排序不能为空！请<a href=javascript:history.go(-1)>返回重新填写</a>！"
		response.end
	end if
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "select * from wq_pingpai",conn,1,3
rs.addnew
rs("tuijian")=tuijian
rs("pingpainame")=pingpainame
rs("pingpaiorder")=pingpaiorder
rs.update
rs.close
set rs=nothing

conn.close
set conn=nothing
response.Write "<script language='javascript'>alert('品牌添加成功!！');window.location.href='ManageBrand.asp';</script>"
response.End
end if
%>