⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 guest_list.asp

📁 html生成静态页的小程序
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%Const dbdns="../"%>
<!--#include file="chk.asp"-->
<!--#include file="../AppCode/Pager.asp"-->
<!--#include file="../AppCode/fun/function.asp"-->
<!--#include file="../AppCode/fun/CreateHtml.asp"-->
<!--#include file="../AppCode/Class/Ok3w_Guest.asp"-->
<%
IsPass = Request.QueryString("IsPass")
Set Guest = New Ok3w_Guest

If Request.Form("action")="ok" Then
	If Request.Form("IsDel")="1" Then
		ID = Trim(Request.QueryString("ID"))
		Call Guest.Del(ID)
		Set Guest = Nothing
		Call SaveAdminLog("删除留言,ID=" & Request.QueryString("IsPass"))
		Call ActionOk("Guest_List.asp?IsPass=" & IsPass)
		Else
			ID = Trim(Request.QueryString("ID"))
			IsPass = Trim(Request.Form("IsPass"))
			If IsPass="" Then IsPass = 0
			Cask = Trim(Request.Form("ask"))
			Content = Trim(Request.Form("Content"))
			Call Guest.Ask(Cask,Content,IsPass,ID)
			
			TableID = Trim(Request.Form("TableID"))
			If TableID<>0 Then
				Call Article_Page_Html(TableID)
			End If
			
			Set Guest = Nothing
			Call SaveAdminLog("回复/开通/关闭留言,ID=" & ID)
			Call ActionOk("Guest_List.asp?IsPass=" & Request.QueryString("IsPass"))
	End If
End If
%>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>后台管理系统</title>
<link rel="stylesheet" type="text/css" href="images/Style.css">
</head>

<body>
<br />
<table cellspacing="0" cellpadding="0" width="98%" align="center" border="0">
  <tbody>
    <tr>
      <td style="PADDING-LEFT: 2px; HEIGHT: 22px" 
    background="images/tab_top_bg.gif"><table cellspacing="0" cellpadding="0" width="477" border="0">
        <tbody>
          <tr>
            <td width="147"><table height="22" cellspacing="0" cellpadding="0" border="0">
              <tbody>
                <tr>
                  <td width="3"><img id="tabImgLeft__0" height="22" 
                  src="images/tab_active_left.gif" width="3" /></td>
                  <td class="mtitle" 
                background="images/tab_active_bg.gif">留言/评论管理</td>
                  <td width="3"><img id="tabImgRight__0" height="22" 
                  src="images/tab_active_right.gif" 
            width="3" /></td>
                </tr>
              </tbody>
            </table></td>
          </tr>
        </tbody>
      </table></td>
    </tr>
    <tr>
      <td bgcolor="#ffffff"><table cellspacing="0" cellpadding="0" width="100%" border="0">
        <tbody>
          <tr>
            <td width="1" background="images/tab_bg.gif"><img height="1" 
            src="images/tab_bg.gif" width="1" /></td>
            <td 
          style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px" 
          valign="top"><div id="tabContent__0" style="DISPLAY: block; VISIBILITY: visible">
              <table cellspacing="1" cellpadding="1" width="100%" align="center" 
            bgcolor="#8ccebd" border="0">
                <tbody>
                  <tr>
                    <td 
                style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; PADDING-TOP: 10px" 
                valign="top" bgcolor="#fffcf7"><%
stype = Trim(Request.QueryString("stype"))
keyword = Trim(Request.QueryString("keyword"))
Sql = "select * from Ok3w_Guest where 1=1"
If IsPass<>"" Then Sql=Sql & " and IsPass=" & IsPass
If keyword<>"" Then Sql = Sql & " and " & stype & " like '%" & keyword & "%'"
Sql = Sql & " order by Id desc"
Set Page = New TurnPage
Call Page.GetRs(Conn,Rs,Sql,10)
%>
                      <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
                        <form id="form1" name="form1" method="get" action="">
                          <tr>
                            <td height="30" colspan="6" align="left" bgcolor="#EBEBEB">&nbsp;
                              <select name="stype" id="stype">
                                <option value="UserName">按用户</option>
                              <option value="Title">按标题</option>
                              <option value="Content">按内容</option>
                              </select>
                                <input name="keyword" type="text" id="keyword" />
                                <input type="submit" name="Submit2" value="搜索" /></td>
                          </tr>
                        </form>
                        <tr>
                          <td height="25" align="center" bgcolor="#EBEBEB">发布者信息</td>
                          <td align="center" bgcolor="#EBEBEB">内容</td>
                          <td align="center" bgcolor="#EBEBEB">回复</td>
                          <td align="center" bgcolor="#EBEBEB">开通</td>
                          <td height="25" align="center" bgcolor="#EBEBEB">确定</td>
                        </tr>
                        
                          <%
	Do While Not Rs.Eof And Not Page.Eof
	%><form id="form2" name="form2" method="post" action="?ID=<%=Rs("ID")%>&IsPass=<%=IsPass%>">
                          <tr>
                            <td height="25" align="center" bgcolor="#FFFFFF">
                              <textarea name="textarea" cols="30" rows="5">姓名:<%= Rs("UserName")%>
邮箱:<%= Rs("Mail")%>
主页:<%= Rs("Homepage")%>
OICQ:<%= Rs("QQ")%>
时间:<%= Rs("AddTime")%>
IP:<%= Rs("Ip")%></textarea></td>
                            <td align="center" bgcolor="#FFFFFF"><%If Rs("TypeID")=2 Then%>
                              <span style="color:#0000FF">评论:《<%=ExecSqlReturnOneValue("select Title from Ok3w_Article where ID=" & Rs("TableID"))%>》</span><br>
                              <%End If%><textarea name="Content" cols="35" rows="5" id="Content"><%= Rs("Content")%></textarea></td>
                            <td align="center" bgcolor="#FFFFFF"><textarea name="ask" cols="25" rows="5" id="ask"><%=Rs("Ad_ask")%></textarea></td>
                            <td align="center" bgcolor="#FFFFFF"><input name="IsPass" type="checkbox" id="IsPass" value="1" <%If Rs("IsPass") Then%>checked<%End If%>></td>
                            <td height="25" align="center" bgcolor="#FFFFFF"><input name="TableID" type="hidden" id="TableID" value="<%=Rs("TableID")%>">
                            <input name="IsDel" type="hidden" id="IsDel">
                              <input name="action" type="hidden" id="action" value="ok">
                              <input type="submit" name="Submit3" value="确定">
                              <input type="submit" name="Submit4" value="删除" onClick="if(!confirm('真的要删除吗?')) return false;this.form.IsDel.value='1';"></td>
                          </tr> </form>
                          <%
		Rs.MoveNext
		Page.MoveNext
	Loop
	Rs.Close
	%>
                          
                          <tr>
                            <td height="25" colspan="6" align="right" bgcolor="#FFFFFF"><%Call Page.GetPageList()%></td>
                          </tr>
                      </table></td>
                  </tr>
                </tbody>
              </table>
            </div></td>
            <td width="1" background="images/tab_bg.gif"><img height="1" 
            src="images/tab_bg.gif" width="1" /></td>
          </tr>
        </tbody>
      </table></td>
    </tr>
    <tr>
      <td background="images/tab_bg.gif" bgcolor="#ffffff"><img height="1" 
      src="images/tab_bg.gif" width="1" /></td>
    </tr>
  </tbody>
</table>
</body>
</html>
<%
Set Guest = Nothing
Set Rs = Nothing
Call CloseConn()
Set Admin = Nothing
%>

⌨️ 快捷键说明

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