📄 admin_messages.asp
字号:
<!-- #include file="conn.asp" -->
<!-- #include file="inc/const.asp" -->
<!-- #include file="inc/function.asp" -->
<HTML><HEAD><TITLE>后台管理 </TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="admin.css" type=text/css rel=stylesheet>
</HEAD>
<BODY leftMargin=0 topMargin=0>
<!-- #include file="admin_header.asp" -->
<table width="100%" border="0" cellspacing="2">
<tr>
<td width="20%" align="center" valign="top" class="tdbgleft"><!-- #include file="Admin_Left.asp" --></td>
<td class="b1" valign="top">
<%
if (not isnull(cUserName)) or cUserName<>"" then
if chkMaster(cUserName) then
dim isedit
select case request("action")
case "saveadd"
call SaveAdd()
case "modify"
call SaveModify()
case "edit"
isEdit=True
call myform()
case "add"
isEdit=False
call myform()
case "del"
call del()
case else
call Viewlist()
end select
else
msgtitle="用户管理"
msginfo="<li>操作错误，你不是系统管理员，没有权限进行此项操作！</li>"
call Sysmsg(msgtitle,msginfo)
end if
else
msgtitle="用户管理"
msginfo="<li>操作错误，你没有登录系统！<li><a href=""User.Asp"">点此登录系统</a><li>"
call Sysmsg(msgtitle,msginfo)
end if
sub SaveModify()
set rs=server.createobject("adodb.recordset")
sql="select * from Messages where ID="&request.form("ID")
rs.open sql,conn,1,3
rs("Title")=checkstr(Trim(request.form("Title")))
rs("Content")=Request.Form("content")
rs("DateTime")=Now()
rs("isType")=Request.Form("isType")
rs.update
rs.close
set rs=nothing
msgtitle="保存修改"
msginfo="<li>修改公告成功!<li><a href=""Admin_Messages.asp"">返回公告列表</a></li>"
call Sysmsg(msgtitle,msginfo)
end sub
sub SaveAdd()
set rs=server.createobject("adodb.recordset")
sql="select * from Messages where (ID is null)"
rs.open sql,conn,1,3
rs.addnew
rs("Title")=checkstr(Trim(request.form("Title")))
rs("Content")=Request.Form("content")
rs("DateTime")=Now()
rs("isType")=Request.Form("isType")
rs("UserName")=cUserName
rs.update
rs.close
set rs=nothing
msgtitle="添加公告"
msginfo="<li>添加公告成功!<li><a href=""Admin_Messages.asp"">返回公告列表</a></li>"
call Sysmsg(msgtitle,msginfo)
end sub
sub del()
selID=Trim(Request.Form("selID"))
msgtitle="批量删除"
if selID<>"" then
conn.execute("delete from Messages where ID in ("&selID&")")
msginfo="操作成功！"
else
msginfo="没有选择任何文章，本次操作取消！"
end if
call Sysmsg(msgtitle,msginfo)
end sub
'=================================
sub ViewList()
%>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableBorder">
<tr class="tdbg1">
<th width="30">选择</th>
<th width="350">标题</th>
<th>频道类型</th>
<th>发布时间</th>
<th>编辑</th>
</tr>
<form action="" method="post" name="viewlist">
<% Set Rs=server.createobject("adodb.recordset")
sql="select * from Messages order By DateTime Desc"
rs.open sql,conn,1,1
if not(rs.eof and rs.bof) then
do while not rs.eof
%>
<tr class="tdbg2">
<td align="center"> <input type="checkbox" name="selID" value="<%= rs("ID") %>">
</td>
<td><%= rs("Title") %></td>
<td align="center"><% if rs("isType")=1 then
Response.Write("软件频道")
else
Response.Write("资讯频道")
end if %>
</td>
<td align="center"><%= rs("DateTime") %></td>
<td align="center"><a href="?action=edit&ID=<%= rs("ID") %>">修改</a>
</td>
</tr>
<% rs.movenext
loop
else
Response.Write("<tr><td colspan=""2"" bgcolor=""#FFFFFF"">目前还没有内容</td></tr>")
end if
rs.close
Set Rs=nothing %>
<tr class="tdbg2">
<td align="right"> </td>
<td colspan="4"><input type="submit" name="Submit3" value="删除公告">
<input type="Hidden" name="action" value="del"></td>
</tr>
</form>
</table>
<%
end sub
'================================
sub myform
if isedit then
set rs=server.createobject("adodb.recordset")
sql = "select * from Messages where id="&Trim(Request.QueryString("id"))
rs.open sql,conn,1,1
msgTitle="修改公告"
else
msgTitle="添加公告"
end if
%>
<table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableBorder">
<form action="Admin_Messages.asp" method="post" name="myform">
<tr>
<th colspan="2" class="tdbg1">
<% if isedit then
Response.Write("<input type=""Hidden"" name=""action"" value=""modify"">")
Response.Write("<input type=""Hidden"" name=""ID"" value="""&Trim(Request.QueryString("id"))&""">")
else
Response.Write("<input type=""Hidden"" name=""action"" value=""saveadd"">")
end if
Response.Write(msgTitle)
%>
</th>
</tr>
<tr class="tdbg2">
<td>公告标题</td>
<td > <input name="Title" type="text" class="bian1" id="Title" value="<% if isedit then response.write trim(rs("Title")) %>" size="45" maxlength="100">
</td>
</tr>
<tr class="tdbg2">
<td> </td>
<td> <textarea name="content" cols="70" rows="7" class="bian1" id="content"><% if isedit then Response.Write(rs("content")) %></textarea>
</td>
</tr>
<tr class="tdbg2">
<td align="center">公告类型</td>
<td><label>
<input type="radio" name="isType" value="1" <%if isedit then
if rs("isType")=1 then Response.Write "checked"
else
Response.Write "checked"
end if%>>
软件频道公告
<input type="radio" name="isType" value="2" <%if isedit then
if rs("isType")=2 then Response.Write "checked"
end if%>>
资讯频道公告</label></td>
</tr>
<tr class="tdbg2">
<td align="center"> </td>
<td> <input type="submit" name="Submit" value="提交"> <input type="reset" name="Submit2" value="重置"></td>
</tr>
</form>
</table>
<% if edit then rs.close:set rs=nothing
end sub %>
</td>
</tr>
</table>
<!-- #include file="admin_footer.asp" -->
</BODY></HTML>
<% CloseDatabase %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -