📄 classmodifysmall.asp
字号:
<!--#include file="conn.asp"-->
<%
if session("admin_name")="" then
response.redirect "error.asp?error=001"
end if
%>
<%
dim sql, rsBigClass, rsSmallClass, ErrMsg
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"> <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 SmallClassID, Action, BigClassName, SmallClassName, OldSmallClassName, rs, FoundErr
SmallClassID=trim(Request("SmallClassID"))
Action=trim(Request("Action"))
BigClassName=trim(Request.form("BigClassName"))
SmallClassName=trim(Request.form("SmallClassName"))
OldSmallClassName=trim(request.form("OldSmallClassName"))
if SmallClassID="" then
response.Redirect("ClassManage.asp")
end if
Set rs=Server.CreateObject("Adodb.RecordSet")
rs.Open "Select * from SmallClass where SmallClassID="&SmallClassID&"", conn, 1, 3
if rs.Bof or rs.EOF then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>此文章小类不存在！</li>"
else
if Action="Modify" then
if SmallClassName="" then
FoundErr=True
ErrMsg=ErrMsg & "<br><li>文章小类名不能为空！</li>"
end if
if FoundErr<>True then
rs("SmallClassName")=SmallClassName
rs.update
rs.Close
set rs=Nothing
if SmallClassName<>OldSmallClassName then
conn.execute "Update NEWS set SmallClassName='" & SmallClassName & "' where BigClassName='" & BigClassName & "' and SmallClassName='" & OldSmallClassName & "'"
end if
'call CloseConn()
Response.Redirect "ClassManage.asp"
end if
end if
if FoundErr=True then
call WriteErrMsg()
else
%>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top"> <br>
<form name="form1" method="post" action="ClassModifySmall.asp">
<table width="100%" border="1" align="center" cellpadding="0" cellspacing="1" bgcolor="#CBD7F5">
<tr>
<td height="25" colspan="2" align="center">修改小类名称</td>
</tr>
<tr>
<td width="126" height="22" bgcolor="#CBD7F5">所属大类：</td>
<td width="204" bgcolor="#CBD7F5"><%=rs("BigClassName")%> <input name="SmallClassID" type="hidden" id="SmallClassID" value="<%=rs("SmallClassID")%>">
<input name="OldSmallClassName" type="hidden" id="OldSmallClassName" value="<%=rs("SmallClassName")%>">
<input name="BigClassName" type="hidden" id="BigClassName" value="<%=rs("BigClassName")%>"></td>
</tr>
<tr>
<td height="22" bgcolor="#CBD7F5">小类名称：</td>
<td bgcolor="#CBD7F5"> <input name="SmallClassName" type="text" id="SmallClassName" value="<%=rs("SmallClassName")%>" size="20" maxlength="30"></td>
</tr>
<tr>
<td height="22" align="center" bgcolor="#CBD7F5"> </td>
<td align="center" bgcolor="#CBD7F5"> <div align="left">
<input name="Action" type="hidden" id="Action4" value="Modify">
<input name="Save" type="submit" id="Save" value=" 修 改 ">
</div></td>
</tr>
</table>
</form></td>
</tr>
</table>
<%
end if
end if
rs.close
set rs=nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -