📄 addnewsclass.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="adminset.asp"-->
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登陆！');window.location.href='login.asp';</script>"
response.End
end if
if session("flag")>1 then
response.Write "<div align=center><font size=80 color=red><b>您没有此项目管理权限！</b></font></div>"
response.End
end if
if qx10<>1 then
response.Write "<div align=center><font size=80 color=red><b>您没有此项目管理权限！</b></font></div>"
response.End
end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="../css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style></head>
<%
if request("action")="adda" then
classname=trim(request("classname"))
''检验此一级分类是否唯一
sql="select * from shop_news_class where classname='"&classname&"' order by id desc"
set rs=server.createobject("ADODB.Recordset")
rs.open sql,conn,1,2
if not(rs.eof or rs.bof) then
response.write"<SCRIPT language=JavaScript>alert('对不起，此分类名已经存在,请核实！');"
response.write"javascript:history.go(-1)</SCRIPT>"
response.end
else
rs.addnew
rs("classname")=classname
rs("class")=trim(request("class"))
rs("px")=trim(request("px"))
rs("adddate")=now()
rs.update
end if
rs.close
set rs=nothing
response.redirect "newsclass.asp"
response.end
end if
%>
<%
''开始删除操作
if request("action")="del" then
conn.execute "delete from shop_news_class where classname='"&request("delsort")&"'"
response.redirect "newsclass.asp"
response.end
end if
%>
<%
''开始修改操作
if request("action")="modi" then
if request("mtype")="" then
response.write"<SCRIPT language=JavaScript>alert('对不起，请合适您的分类修改项！');"
response.write"javascript:history.go(-1)</SCRIPT>"
response.end
end if
''检验此一级分类是否唯一
sql="select * from shop_news_class where classname='"&request("mtype")&"' order by id desc"
set rs=server.createobject("ADODB.Recordset")
rs.open sql,conn,1,1
if not(rs.eof or rs.bof) then
response.write"<SCRIPT language=JavaScript>alert('对不起，此分类名]不唯一,请核实！');"
response.write"javascript:history.go(-1)</SCRIPT>"
response.end
end if
rs.close
set rs=nothing
conn.execute "update shop_news_class set classname='"&request("mtype")&"' where classname='"&request("modiclass")&"'"
'conn.execute "update NewsData set news='"&request("mtype")&"' where news='"&request("modiclass")&"'"
response.redirect "newsclass.asp"
response.end
end if
%>
<table width="100%" border="0" cellpadding="0" cellspacing="0" background="images/right_top2.gif">
<tr>
<td width="1%"> </td>
<td width="99%"><table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="30%"> <strong><b>管理导航 </b></strong><a href="newsclass.asp">栏目管理首页</a> <a href="addnewsclass.asp?a=add">添加一个分类</a></td>
<td width="70%" align="right"> </td>
</tr>
</table></td>
</tr>
</table>
<p> </p>
<p><br>
<%if request("a")="add" then%>
</p>
<table border="0" cellspacing="1" cellpadding="3" bgcolor="#9DB2D4" align="center" width="90%" class="border">
<tr bgcolor="#C7D3E6">
<td height="25" colspan="2" class="title">添加新闻分类</td>
</tr>
<form name="addsort" method="post" action="addnewsclass.asp">
<tr bgcolor="#F0F3F8">
<td width="14%" align="right" class="tdbg">分类名：</td>
<td width="86%" class="tdbg"> <input name="classname" type="text" class="wenbenkuang" id="classname">
排序： <input name="px" type="text" class="wenbenkuang" id="px" size="8"></td>
</tr>
<tr bgcolor="#F0F3F8">
<td align="right" bgcolor="#F0F3F8" class="tdbg">说明：</td>
<td class="tdbg"><textarea name="class" cols="80" rows="8" class="wenbenkuang" id="class"></textarea></td>
</tr>
<tr bgcolor="#F0F3F8">
<td colspan="2" align="center" class="tdbg"> <input name="Submit3" type="submit" class="go-wenbenkuang" value="添 加">
<input type="hidden" name="action" value="adda"> </td>
</tr>
</form>
</table>
<%end if%>
<br>
<%if request("a")="del" then%>
<table border="0" cellspacing="1" cellpadding="3" bgcolor="#9DB2D4" align="center" width="90%" class="border">
<tr bgcolor="#C7D3E6">
<td height="25" colspan="2" class="title">删除新闻分类</td>
</tr>
<form name="delclass" method="post" action="addnewsclass.asp">
<tr bgcolor="#F0F3F8">
<td width="25%" align="right" class="tdbg">分类名:</td>
<td bgcolor="#F0F3F8" class="tdbg">
<input type="text" name="delsort" class="wenbenkuang" value=></td>
</tr>
<tr bgcolor="#F0F3F8">
<td colspan="2" align="center" class="tdbg">
<input name="Submit2" type="submit" class="go-wenbenkuang" value="删 除">
<input type="hidden" name="action" value="del"> </td>
</tr>
</form>
</table>
<%end if%>
<br>
<%if request("a")="modi" then%>
<table border="0" cellspacing="1" cellpadding="3" bgcolor="#9DB2D4" align="center" width="90%" class="border">
<tr bgcolor="#C7D3E6">
<td height="25" colspan="2" class="title">修改新闻分类</td>
</tr>
<form name="modisort" method="post" action="addnewsclass.asp">
<tr bgcolor="#F0F3F8">
<td width="25%" align="right" class="tdbg">分类名:</td>
<td class="tdbg">
<input type="text" name="modiclass" class="wenbenkuang" value=> </td>
</tr>
<tr bgcolor="#F0F3F8">
<td align="right" class="tdbg">修改为:</td>
<td class="tdbg">
<input type="text" name="mtype" class="wenbenkuang"> </td>
</tr>
<tr bgcolor="#F0F3F8">
<td colspan="2" align="center" class="tdbg">
<input name="Submit22" type="submit" class="go-wenbenkuang" value="修 改">
<input type="hidden" name="action" value="modi"> </td>
</tr>
</form>
</table>
<%end if%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -