📄 sysusernews.asp
字号:
<% Option Explicit %>
<!--#include file="../../../Inc/Cls_DB.asp" -->
<!--#include file="../../../Inc/Const.asp"-->
<%
'==============================================================================
'软件名称:风讯网站信息管理系统
'当前版本:Foosun Content Manager System(FoosunCMS V3.2SP1)
'最新更新:2006.50
'==============================================================================
'Copyright (C) 2002-2004 Foosun.Net All rights reserved.
'商业注册联系:028-85098980-601,项目开发:028-85098980-606、609,客户支持:608
'产品咨询QQ:394226379,159410,125114015
'技术支持QQ:315485710,66252421
'项目开发QQ:415637671,655071
'程序开发:四川风讯科技发展有限公司(Foosun Inc.)
'Email:service@Foosun.cn
'MSN:skoolls@hotmail.com
'论坛支持:风讯在线论坛(http://bbs.foosun.net)
'官方网站:www.Foosun.cn 演示站点:test.cooin.com
'网站通系列(智能快速建站系列):www.ewebs.cn
'==============================================================================
'免费版本请在程序首页保留版权信息,并做上本站LOGO友情连接
'风讯公司保留此程序的法律追究权利
'如需进行2次开发,必须经过风讯公司书面允许。否则将追究法律责任
'==============================================================================
Dim DBC,Conn,UserConn
Set DBC = New DataBaseClass
Set Conn = DBC.OpenConnection()
DBC.ConnStr = "DBQ=" + Server.MapPath(UserDBConnectStr) + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
Set UserConn = DBC.OpenConnection()
Set DBC = Nothing
%>
<!--#include file="../../../Inc/Session.asp" -->
<!--#include file="../../../Inc/CheckPopedom.asp" -->
<%
'if Not JudgePopedomTF(Session("Name"),"P040400") then Call ReturnError1()
Dim NewsAdminSql,RsUGObj
NewsAdminSql = "Select * from FS_MemberNews order by ID desc"
Set RsUGObj = Server.CreateObject(G_FS_RS)
RsUGObj.open NewsAdminSql,UserConn,1,1
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>会员列表</title>
</head>
<link href="../../../CSS/FS_css.css" rel="stylesheet">
<script src="../../SysJS/PublicJS.js" language="JavaScript"></script>
<script language="JavaScript" src="../../SysJS/ContentMenu.js"></script>
<body topmargin="2" leftmargin="2" onClick="SelectAdmin();" onselectstart="return false;">
<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#999999">
<tr bgcolor="#EEEEEE">
<td height="26" colspan="5" valign="middle">
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width=35 align="center" alt="添加会员公告" onClick="AddUserNews();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">新建</td>
<td width=2 class="Gray">|</td>
<td width=35 align="center" alt="修改会员公告" onClick="EditUserNews();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">修改</td>
<td width=2 class="Gray">|</td>
<td width=35 align="center" alt="删除会员公告" onClick="DelUserNews();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">删除</td>
<td width=2 class="Gray">|</td>
<td width=35 align="center" alt="锁定会员公告" onClick="LockUserNews();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">锁定</td>
<td width=2 class="Gray">|</td>
<td width=35 align="center" alt="解锁会员公告" onClick="UNLockUserNews();" onMouseMove="BtnMouseOver(this);" onMouseOut="BtnMouseOver(this);" class="BtnMouseOut">解锁</td>
<td width=2 class="Gray">|</td>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="5" height="2"></td>
</tr>
<tr>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="33%" height="26" class="ButtonListLeft"> <div align="center">公告名称</div></td>
<td width="13%" height="26" class="ButtonList"> <div align="center">浏览权限</div></td>
<td width="24%" height="26" class="ButtonList"> <div align="center">发布时间</div></td>
<td width="18%" height="26" class="ButtonList"> <div align="center">发布人</div></td>
<td width="12%" height="26" class="ButtonList"> <div align="center">是否锁定</div></td>
</tr>
<%
if Not RsUGObj.eof then
Dim page_size,page_no,page_total,record_all,PageNums
page_size=Request.QueryString("page_size")
if page_size<=0 or page_size="" then page_size=20
If isnumeric(Request.Form("PageNums")) then
if Request.Form("PageNums")<>0 then
page_size = Cint(Request.Form("PageNums"))
end if
End if
page_no=request.querystring("page_no")
if page_no<=1 or page_no="" then page_no=1
If Request.QueryString("page_no")="" then
page_no=1
end if
RsUGObj.PageSize=page_size
page_total=RsUGObj.PageCount
if (cint(page_no)>page_total) then page_no=page_total
RsUGObj.AbsolutePage=page_no
record_all=RsUGObj.RecordCount
Dim i
for i=1 to RsUGObj.PageSize
if RsUGObj.eof then exit for
%>
<tr>
<td height="26"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="16"><img border="0" src="../Images/cmsv31_show.png" width="12" height="12"></td>
<td width="306"><span class="TempletItem" Lock="<% = RsUGObj("isLock") %>" UserID="<% = RsUGObj("ID") %>">
<% = RsUGObj("Title") %>
</span></td>
</tr>
</table></td>
<td><div align="center">
<%
If RsUGObj("PoPid")=0 Then
Response.Write("所有人")
Elseif RsUGObj("PoPid")=1 Then
Response.Write("一般会员")
Elseif RsUGObj("PoPid")=2 Then
Response.Write("中级会员")
Elseif RsUGObj("PoPid") = 3 Then
Response.Write("高级会员")
Elseif RsUGObj("PoPid") = 4 Then
Response.Write("VIP会员")
Else
Response.Write("错误参数")
End if
%>
</div></td>
<td><div align="center">
<% = RsUGObj("AddTime") %>
</div></td>
<td><div align="center">
<% = RsUGObj("Author") %>
</div></td>
<td> <div align="center">
<%
If RsUGObj("isLock")=0 then
Response.Write("未锁定")
Else
Response.Write("<font color=red>已锁定</font>")
End if
%>
</div></td>
</tr>
<%
RsUGObj.MoveNext
Next
end if
%>
</table>
</td>
</tr>
<%if page_total>1 then%>
<tr>
<td height="18">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr height="1">
<td width="42%" height="18"><table width="99%" border="0" cellspacing="0" cellpadding="0">
<tr>
</tr>
</table> </td>
<td width="51%" height="25" valign="middle"> <div align="right">
<% = "NO.<b>"& page_no &"</b>, " %>
<% = "Totel:<b>"& page_total &"</b>, RecordCounts:<b>" & record_all &"</b> "%>
<%
if Page_Total=1 then
response.Write " <img src=../images/First1.gif border=0 alt=首页></img> "
response.Write " <img src=../images/prePage.gif border=0 alt=上一页></img> "
response.Write " <img src=../images/nextPage.gif border=0 alt=下一页></img> "
response.Write " <img src=../images/endPage.gif border=0 alt=尾页></img> "
else
if cint(Page_No)<>1 and cint(Page_No)<>Page_Total then
response.Write " <a href=?page_no=1&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/First1.gif border=0 alt=首页></img></a> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)-1)&"&page_size="&page_size&"&Keywords="&Request("Keywords")&"><img src=../images/prePage.gif border=0 alt=上一页></img></a> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)+1)&"&page_size="&page_size&"&Keywords="&Request("Keywords")&"><img src=../images/nextPage.gif border=0 alt=下一页></img></a> "
response.Write " <a href=?page_no="& Page_Total &"&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/endPage.gif border=0 alt=尾页></img></a> "
elseif cint(Page_No)=1 then
response.Write " <img src=../images/First1.gif border=0 alt=首页></img></a> "
response.Write " <img src=../images/prePage.gif border=0 alt=上一页></img> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)+1)&"&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/nextPage.gif border=0 alt=下一页></img></a> "
response.Write " <a href=?page_no="& Page_Total &"&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/endpage.gif border=0 alt=尾页></img></a> "
else
response.Write " <a href=?page_no=1&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/First1.gif border=0 alt=首页></img> "
response.Write " <a href=?page_no="&cstr(cint(Page_No)-1)&"&page_size="& page_size &"&Keywords="&Request("Keywords")&"><img src=../images/prePage.gif border=0 alt=上一页></img></a> "
response.Write " <img src=../images/nextPage.gif border=0 alt=下一页></img></a> "
response.Write " <img src=../images/endpage.gif border=0 alt=尾页></img> "
end if
end if
%>
</div></td>
<td width="7%" valign="middle"><select onChange="ChangePage(this.value);" style="width:50;" name="select">
<% for i=1 to Page_Total %>
<option <% if cint(Page_No) = i then Response.Write("selected")%> value="<% = i %>">
<% = i %>
</option>
<% next %>
</select></td>
</tr>
</table>
</td>
</tr>
<% end if %>
</table>
</body>
</html>
<%
Set Conn = Nothing
%>
<script>
var DocumentReadyTF=false;
var ListObjArray = new Array();
var ContentMenuArray=new Array();
function document.onreadystatechange()
{
if (DocumentReadyTF) return;
IntialListObjArray();
InitialClassListContentMenu();
DocumentReadyTF=true;
}
function InitialClassListContentMenu()
{
ContentMenuArray[ContentMenuArray.length]=new ContentMenuFunction("parent.AddUserNews();",'新建','disabled');
ContentMenuArray[ContentMenuArray.length]=new ContentMenuFunction("parent.EditUserNews();",'修改','disabled');
ContentMenuArray[ContentMenuArray.length]=new ContentMenuFunction("parent.DelUserNews();",'删除','disabled');
ContentMenuArray[ContentMenuArray.length]=new ContentMenuFunction('seperator','','');
ContentMenuArray[ContentMenuArray.length]=new ContentMenuFunction('top.GetEkMainObject().location.reload();','刷新','');
}
function ContentMenuFunction(ExeFunction,Description,EnabledStr)
{
this.ExeFunction=ExeFunction;
this.Description=Description;
this.EnabledStr=EnabledStr;
}
function ContentMenuShowEvent()
{
ChangeContentMenuStatus();
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -