product_class.asp

主要销售电脑和it 具有 购物车 和 留言版 和服务器销售 等具体功能

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="admin_style.css" rel="stylesheet" type="text/css">
<!--#include file="inc/conn.inc"-->
<%
if request("product_class_id")<>"" or request("product_class_z")<>"" then
'------------------------------------类别管理--------------------------------------------------
	 select case request.form("options")
     case "del"
		   sql="delete * from product_class where product_class_id="&request("product_class_id")&""    '删除总类
		   conn.execute sql
		   sql="delete * from product where product_class_id="&request("product_class_id")&""     '删除所属类货物
		   conn.execute sql
		   response.write "<script language=javascript>alert('成功删除ID为"&request("product_class_id")&"的总类及相关产品!');location='product_class.asp';</script>"
	 case "rename"
	       sql="update product_class set product_class_z='"&request("product_class_z")&"' where product_class_id="&request("product_class_id")&""
		   conn.execute sql
		   response.write "<script language=javascript>alert('成功将ID为"&request("product_class_id")&"更名为"&request("product_class_z")&"!');location='product_class.asp';</script>"
	 case "new"
	       sql="insert into product_class(product_class_z) values('"&request("product_class_z")&"')"
		   conn.execute sql
		   response.write "<script language=javascript>alert('成功添加总类 "&request("product_class_z")&"!');location='product_class.asp';</script>"
     end select
'------------------------------------管理结束---------------------------------------------------
end if
    sql="select * from product_class"
    set res=server.createobject("adodb.recordset")
    res.open sql,conn,1,1
%>
<table width="100%" height="100%"  border="0" cellpadding="0" cellspacing="1">
  <tr>
    <td align="center"><table width="40%" border="1" align="center" cellpadding="3" cellspacing="0"  bordercolorlight="#326598" bordercolordark="#ffffff">
<form method="POST" action="product_class.asp">
<input type="hidden" name="options" value><tr>
        <td height="25" colspan="3" background="image/tile_sub.gif">　新闻分类管理</td>
        </tr>
      <tr>
        <td width="33%">　新闻分类</td>
        <td colspan="2"><select name="product_class_id" id="product_class_id" style="font-size: 9pt">
             <%
	         if res.eof and res.bof then
	            response.write "<option value=>请增加类别</option>"
	         else
             Do while not res.eof
                response.write "<option value='" +  Cstr(res("product_class_id")) + "'>" + res("product_class_z") + "</option>"
                res.MoveNext
             Loop
	         end if
             %>
             </select></td>
        </tr>
      <tr>
        <td>　修改添加</td>
        <td colspan="2"><input name="product_class_z" type="text" id="product_class_z" size="15" class="input"></td>
      </tr>
      <tr align="center">
        <td colspan="3"><input type="submit" name="submit3" value=" 删 除 " align=absMiddle class="input" onClick="form.options.value='del'">　
          <input type="submit" name="Submit" value=" 修 改 " align=absMiddle class="input" onClick="form.options.value='rename'">　
          <input type="submit" name="Submit" value=" 添 加 " align=absMiddle class="input" onClick="form.options.value='new'"></td>
        </tr>
      </form>
    </table></td>
  </tr>
</table>
<%
res.close
set res=nothing
conn.close
set con=nothing
%>