save_product.asp

后台管理系统

<!--#include file="cookies.asp"-->
<!--#include file="conn.asp"-->
<%
'判断动作为添加 
if request.querystring("action")="add" then
if trim(request.form("product_name"))="" then
response.Write "<script language=javascript>alert('产品名称不能为空！');window.location.href='add_product.asp';</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from product_info "
rs.open sql,conn,1,3
rs.addnew
rs("big_sortid")=trim(request.form("big_sortid"))
rs("sort_id")=trim(request.form("sort_id"))
if trim(request.form("product_name"))<>"" then rs("product_name")=server.HTMLEncode(trim(request.form("product_name")))
if trim(request.form("product_sort"))<>"" then rs("product_sort")=server.HTMLEncode(trim(request.form("product_sort")))
rs("small_img")=trim(request.form("small_img"))
rs("big_img")=trim(request.form("big_img"))
if trim(request.form("tuijian"))<>"" then rs("tuijian")=trim(request.form("tuijian"))
if trim(request.form("pass"))<>"" then rs("pass")=trim(request.form("pass"))
rs("sub_person")=trim(request.form("sub_person"))
if trim(request.form("sx"))<>"" then rs("sx")=trim(request.form("sx"))
rs("product_info")=trim(request.form("product_info"))
rs("sort_width")=trim(request.form("sort_width"))
rs("sort_height")=trim(request.form("sort_height"))
rs.update
response.Write "<script language=javascript>alert('添加产品成功！');window.location.href='add_product.asp';</script>"
rs.close
set rs=nothing
conn.close
set conn=nothing
end if
%>
<% 
'判断动作为修改
if request.querystring("action")="edit" then
set rs=server.createobject("adodb.recordset")
sql="select * from product_info where id="&cint(request.form("editid"))
rs.open sql,conn,1,3
rs("big_sortid")=trim(request.form("big_sortid"))
rs("sort_id")=trim(request.form("sort_id"))
if trim(request.form("product_name"))<>"" then rs("product_name")=server.HTMLEncode(trim(request.form("product_name")))
if trim(request.form("product_sort"))<>"" then rs("product_sort")=server.HTMLEncode(trim(request.form("product_sort")))
rs("small_img")=trim(request.form("small_img"))
rs("big_img")=trim(request.form("big_img"))
if trim(request.form("tuijian"))<>"" then rs("tuijian")=trim(request.form("tuijian"))
if trim(request.form("pass"))<>"" then rs("pass")=trim(request.form("pass"))
rs("sub_person")=trim(request.form("sub_person"))
if trim(request.form("sx"))<>"" then rs("sx")=trim(request.form("sx"))
rs("product_info")=trim(request.form("product_info"))
rs("sort_width")=trim(request.form("sort_width"))
rs("sort_height")=trim(request.form("sort_height"))
rs.update
response.Write "<script language=javascript>alert('产品信息修改成功！');window.location.href='mod_product.asp?id="&rs("id")&"';</script>"
rs.close
set rs=nothing
conn.close
set conn=nothing
end if
%>
<%
if request.QueryString("action")="utuijian" then
updatetxt="update product_info set tuijian=0 where id="&request.QueryString("id")
conn.execute updatetxt
response.write("<script>window.alert('已将产品设置为不推荐');window.location.href='manage_product.asp';</script>")
conn.close
set conn=nothing
end if
if request.QueryString("action")="tuijian" then
updatetxt="update product_info set tuijian=1 where id="&request.QueryString("id")
conn.execute updatetxt
response.write("<script>window.alert('已将产品设置为推荐');window.location.href='manage_product.asp';</script>")
conn.close
set conn=nothing
end if
if request.QueryString("action")="upass" then
updatetxt="update product_info set pass=0 where id="&request.QueryString("id")
conn.execute updatetxt
response.write("<script>window.alert('已将产品设置为不显示');window.location.href='manage_product.asp';</script>")
conn.close
set conn=nothing
end if
if request.QueryString("action")="pass" then
updatetxt="update product_info set pass=1 where id="&request.QueryString("id")
conn.execute updatetxt
response.write("<script>window.alert('已将产品设置为显示');window.location.href='manage_product.asp';</script>")
conn.close
set conn=nothing
end if
if request.QueryString("action")="delete" then
deltxt="delete from product_info where id="&request.querystring("id")
conn.execute deltxt
response.write("<script>window.alert('删除产品成功!');window.location.href='manage_product.asp';</script>")
conn.close
set conn=nothing
end if
%>