📄 classaddsmall.asp

📁 本实例为一个完整的网上购物商城的完整例子程序,里面有所以的源代码.希望对大家学习有用.
💻 ASP
字号:
<!--#include file="conn.asp"-->
<%
if session("admin_name")="" then
        response.redirect "error.asp?error=001"
end if
%>
<%
dim sql, rsSmallClass
set rsBigClass=server.CreateObject("adodb.recordset")
rsBigClass.open "Select * From BigClass", conn, 1, 3
%>
<script language="JavaScript" type="text/JavaScript">
function checkBig()
{ 
        if(document.form1.BigClassName.value == "")
        {
                alert("大类名称不能为空！");
                document.form1.BigClassName.focus();
                return false;
        }
}
function checkSmall()
{
        if(document.form2.BigClassName.value == "")
        {
                alert("请先添加大类名称！");
                document.form1.BigClassName.focus();
                return false;
        }
        if(document.form2.SmallClassName.value == "")
        {
                alert("小类名称不能为空！");
                document.form2.SmallClassName.focus();
                return false;
        }
}
function ConfirmDelBig()
{
        if(confirm("确定要删除此大类吗？删除此大类同时将删除所包含的小类和该类下的所有专题，并且不能恢复！"))
                return true;
        else
                return false;
        
}
function ConfirmDelSmall()
{
        if(confirm("确定要删除此小类吗？删除此小类同时将删除该类下的所有专题，并且不能恢复！"))
                return true;
        else
                return false;
        
}
</script>
<body bgcolor="#FFFFCC" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="#FFFFFF" vspace="0" hspace="0">
<tr>
<td height="27" background="images/admin_bg_1.gif">.:: 您可以在这里进行用商品类别关操作</td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top">
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr>
<td width="50%" height="30" align="center" background="images/admin_bg_1.gif" ><strong>栏目名称</strong>
<a href="ClassAddBig.asp" ><strong><font color="#FF0000"><u>添加一级分类</u></font></strong></a></td>
<td height="30" align="center" background="images/admin_bg_1.gif" ><strong>操作选项</strong></td>
</tr>
<%
do while not rsBigClass.eof
%>
<tr bgcolor="#FFFFFF" class="tdbg">
<td width="233" height="22" bgcolor="#CBD7F5"><img src="../images/%2B.gif" width="15" height="15"><%=rsBigClass("BigClassName")%></td>
<td align="right" bgcolor="#CBD7F5" style="padding-right:10"><a href="ClassAddSmall.asp?BigClassName=<%=rsBigClass("BigClassName")%>" ><font color="#FF0000">添加二级分类</font></a>
| <a href="ClassModifyBig.asp?BigClassID=<%=rsBigClass("BigClassID")%>">修改</a>
| <a href="ClassDelBig.asp?BigClassName=<%=rsBigClass("BigClassName")%>" onClick="return ConfirmDelBig();">删除</a></td>
</tr>
<%
set rsSmallClass=server.CreateObject("adodb.recordset")
rsSmallClass.open "Select * From SmallClass Where BigClassName='" & rsBigClass("BigClassName") & "'", conn, 1, 1
if not(rsSmallClass.bof and rsSmallClass.eof)then
        do while not rsSmallClass.eof
%>
<tr bgcolor="#EAEAEA" class="tdbg">
<td width="233" height="22" bgcolor="#E8F1FF">&nbsp; &nbsp; <img src="../images/-.gif" width="15" height="15"><%=rsSmallClass("SmallClassName")%></td>
<td align="right" style="padding-right:10" bgcolor="#E8F1FF"><a href="ClassModifySmall.asp?SmallClassID=<%=rsSmallClass("SmallClassID")%>">修改</a>
| <a href="ClassDelSmall.asp?SmallClassID=<%=rsSmallClass("SmallClassID")%>&SmallClassName=<%=rsSmallClass("SmallClassName")%>" onClick="return ConfirmDelSmall();">删除</a></td>
</tr>
<%
rsSmallClass.movenext
loop
end if
rsSmallClass.close
set rsSmallClass=nothing
rsBigClass.movenext
loop
%>
</table>
<br>
</td>
</tr>
</table>
<%
rsBigClass.close
set rsBigClass=nothing
%>
<%
dim Action, BigClassName, SmallClassName, rs, FoundErr, ErrMsg
Action=trim(Request("Action"))
BigClassName=trim(request("BigClassName"))
SmallClassName=trim(request("SmallClassName"))
if Action="Add" then
        if BigClassName="" then
        FoundErr=True
ErrMsg=ErrMsg & "<br><li>文章大类名不能为空！</li>"
end if
if SmallClassName="" then
        FoundErr=True
ErrMsg=ErrMsg & "<br><li>文章小类名不能为空！</li>"
end if
if FoundErr<>True then
        Set rs=Server.CreateObject("Adodb.RecordSet")
rs.open "Select * From SmallClass Where BigClassName='" & BigClassName & "' AND SmallClassName='" & SmallClassName & "'", conn, 1, 3
if not rs.EOF then
        FoundErr=True
ErrMsg=ErrMsg & "<br><li>“" & BigClassName & "”中已经存在文章小类“" & SmallClassName & "”！</li>"
else
        rs.addnew
rs("BigClassName")=BigClassName
rs("SmallClassName")=SmallClassName
rs.update
rs.Close
set rs=Nothing
'call CloseConn()
Response.Redirect "ClassManage.asp"
end if
end if
end if
if FoundErr=True then
        call WriteErrMsg()
else
        %>
<script language="JavaScript" type="text/JavaScript">
function checkSmall()
{
        if(document.form2.BigClassName.value == "")
        {
                alert("请先添加大类名称！");
                document.form1.BigClassName.focus();
                return false;
        }
        if(document.form2.SmallClassName.value == "")
        {
                alert("小类名称不能为空！");
                document.form2.SmallClassName.focus();
                return false;
        }
}
</script>
<table width="100%" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td align="center" valign="top"><form name="form2" method="post" action="ClassAddSmall.asp" onsubmit="return checkSmall()">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="2">
<tr bgcolor="#CBD7F5">
<td height="25" colspan="2" align="center"><strong>添加小类</strong></td>
</tr>
<tr class="tdbg">
<td width="126" height="22" bgcolor="#CBD7F5"><strong>所属大类：</strong></td>
<td width="218" bgcolor="#CBD7F5"> <select name="BigClassName">
<%
dim rsBigClass
set rsBigClass=server.CreateObject("adodb.recordset")
rsBigClass.open "Select * From BigClass", conn, 1, 1
if rsBigClass.bof and rsBigClass.bof then
        response.write "<option>请先添加文章大类</option>"
else
        do while not rsBigClass.eof
if rsBigClass("BigClassName")=BigClassName then
        response.write "<option value='"& rsBigClass("BigClassName") & "' selected>" & rsBigClass("BigClassName") & "</option>"
else
        response.write "<option value='"& rsBigClass("BigClassName") & "'>" & rsBigClass("BigClassName") & "</option>"
end if
rsBigClass.movenext
loop
end if
rsBigClass.close
set rsBigClass=nothing
%>
</select></td>
</tr>
<tr>
<td width="126" height="22" bgcolor="#CBD7F5"><strong>小类名称：</strong></td>
<td bgcolor="#CBD7F5"> <input name="SmallClassName" type="text" size="20" maxlength="30"></td>
</tr>
<tr>
<td height="22" align="center" bgcolor="#CBD7F5">&nbsp; </td>
<td height="22" align="center" bgcolor="#CBD7F5"> <div align="left">
<input name="Action" type="hidden" id="Action3" value="Add">
<input name="Add" type="submit" value=" 添 加 ">
</div></td>
</tr>
</table>
</form></td>
</tr>
</table>
<%
end if
%>
⌨️ 快捷键说明

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