?? class.asp
字號(hào):
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
'/*----------------------------------------------
'項(xiàng)目名: 東區(qū)網(wǎng)上書店(ASP課程設(shè)計(jì))
'開始日期: 2003年12月18日18:00
'完成日期： 2003年12月27日53:00
'最后修改： -
'制作地點(diǎn)： 科干東區(qū)宿舍
'程序制作： 陳文杰
'聯(lián)系方式： QQ:168909
'
'
' Email:Cwj@edu.21cn.com
'
' *未經(jīng)同意本程序不得使用！*
'
' 請尊重他人勞動(dòng)成果，保留上面信息！
'-----------------------------------------------*/
%><!--#include file="inc/config.asp"-->
<!--#include file="inc/conn.asp"-->
<!--#include file="inc/chk.asp"-->
<%
if session("rank")>1 then
call Msgbox("你的權(quán)限不夠！","Back","None")
response.End
end if
%>
<%
dim action,categoryid
categoryid=request.QueryString("id")
action=request.querystring("action")
select case action
case "add"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from category",conn,1,3
rs.AddNew
rs("category")=trim(request("category2"))
rs("categoryorder")=int(request("categoryorder2"))
rs("first")=int(request("first2"))
rs.Update
rs.Close
set rs=nothing
response.Redirect "class.asp"
case "edit"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from category where categoryid="&categoryid,conn,1,3
rs("category")=trim(request("category"))
rs("categoryorder")=int(request("categoryorder"))
rs("first")=int(request("first"))
rs.Update
rs.Close
set rs=nothing
response.Redirect "class.asp"
case "del"
conn.execute ("delete from category where categoryid="&categoryid)
conn.execute ("delete from sorts where categoryid="&categoryid)
conn.execute ("delete from product where categoryid="&categoryid)
response.Redirect "class.asp"
end select
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>東區(qū)網(wǎng)上書店</title>
<link href="../style.css" rel="stylesheet" type="text/css">
</head>
<body>
<!--#include file="head.htm"-->
<table width="780" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="219" align="left" valign="top"><br>
<!--#include file="menu.htm"-->
<br></td><td width="561" align="left" valign="top">
<br> <table border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="../images/w.gif" width="18" height="18"></td>
<td style="color:#415373">商品大類管理</td>
</tr>
</table> <br> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr align="center" bgcolor="#FFFFFF" height="20">
<td width="30%">分類名稱</td>
<td width="20%"> 分類排序</td>
<td width="20%">一級(jí)分類</td>
<td width="30%">確定操作</td>
</tr>
<%set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from category order by categoryorder",conn,1,1
dim follows
if rs.EOF and rs.BOF then
response.Write "<div align=center><font color=red>還沒有分類</font></center>"
follows=0
else
do while not rs.EOF
%>
<form name="form2" method="post" action="class.asp?action=edit&id=<%=int(rs("categoryid"))%>">
<tr bgcolor="#FFFFFF" align="center">
<td><input name="category" type="text" id="category3" size="12" value="<%=trim(rs("category"))%>"></td>
<td><input name="categoryorder" type="text" id="categoryorder" size="4" value="<%=int(rs("categoryorder"))%>"></td>
<td><input name="first" type=checkbox value="1">
<%if rs("first")=1 then
response.Write "<font color=red>一級(jí)</font>"
else
response.Write "二級(jí)"
end if%>
</td>
<td><input type="submit" name="Submit" value="修改">
<a href="class.asp?id=<%=int(rs("categoryid"))%>&action=del" onClick="return confirm('您確定進(jìn)行刪除操作嗎？')"><font color=red>刪除</font></a> </td>
</tr>
</form>
<%rs.MoveNext
loop
follows=rs.RecordCount
end if%>
</table> <br> <table border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="../images/w.gif" width="18" height="18"></td>
<td style="color:#415373">添加商品大類</td>
</tr>
</table> <font color="#FFFFFF">操作注意事項(xiàng)及說明</font><br> <table width="100%" border="0" align="center" cellpadding="2" cellspacing="2">
<tr align="center" bgcolor="#FFFFFF" height="20">
<td width="30%"> 分類名稱</td>
<td width="20%">分類排序</td>
<td width="20%">一級(jí)分類</td>
<td width="30%">確定操作</td>
</tr>
<form name="form1" method="post" action="class.asp?action=add">
<tr align="center" bgcolor="#FFFFFF">
<td><input name="category2" type="text" id="category22" size="12"></td>
<td><input name="categoryorder2" type="text" id="categoryorder22" size="4" value="<%=follows+1%>"></td>
<td><input name="first2" type="checkbox" id="first22" value="1"></td>
<td><input type="submit" name="Submit3" value="添加" onClick="return checkpro()">
<script language="JavaScript">
<!--
function checkpro()
{
if(checkspace(document.form1.category2.value)) {
document.form1.category2.focus();
alert("請輸入分類名！");
return false;
}
if(checkspace(document.form1.categoryorder2.value)) {
document.form1.categoryorder2.focus();
alert("請輸入分類排序！");
return false;
}
}
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
function regInput(obj, reg, inputStr)
{
var docSel = document.selection.createRange()
if (docSel.parentElement().tagName != "INPUT") return false
oSel = docSel.duplicate()
oSel.text = ""
var srcRange = obj.createTextRange()
oSel.setEndPoint("StartToStart", srcRange)
var str = oSel.text + inputStr + srcRange.text.substr(oSel.text.length)
return reg.test(str)
}
//-->
</script></td>
</tr>
</form>
</table> <br> <table border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="../images/w.gif" width="18" height="18"></td>
<td style="color:#415373">操作注意事項(xiàng)及說明</td>
</tr>
</table> <br> <table width="80%" border="0" align="center" cellpadding="5" cellspacing="0">
<tr>
<td height="20"><font color="#FF0000">·請注意分類名稱不要含有非法字符。<br>
·增加一級(jí)分類后，此分類將會(huì)被列出到首頁的欄目導(dǎo)航<br>
·進(jìn)行刪除操作的同時(shí)，會(huì)刪除此大類下包含的所有小分類和商品。</font></td>
</tr>
</table> <br>
</td>
</tr>
</table>
<!--#include file="foot.htm"-->
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -