?? main102-gl.asp
字號:
<% Response.Buffer=true%>
<!--#include file="../inc/admin.inc"-->
<% if request("dels")<>"" then
conn.Execute("delete * from sjnews where id="&request("dels"))
end if %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>樂清資訊-黃頁數據</title>
<meta content="text/html; charset=gb2312" http-equiv="Content-Type">
<meta content="zh-cn" http-equiv="Content-Language">
<style type="text/css">body { margin-left: 0px; margin-top: 20px }
p { font-family: 宋體; font-size: 9pt; line-height: 14pt }
div { font-family: 宋體; font-size: 9pt; line-height: 14pt }
a { color: #000000; text-decoration: none }
a:hover { color: #ff0000; text-decoration: underline }
a:active { color: #ff0000; text-decoration: underline }
a.top { color: #ffffff; font-family: 宋體; font-size: 9pt }
a.top:hover { color: #ffcc00 }
td { font-family: 宋體; font-size: 9pt }
.f1_v { font-family: 宋體; font-size: 9pt }
.f2_v { font-family: 宋體; font-size: 9pt }
.f2_A { font-family: 宋體; font-size: 9pt }
li { color: #ff0000; font-size: 9pt }
li.li1 { color: #ffffff; font-size: 1pt }
</style>
<meta content="Microsoft FrontPage 4.0" name="GENERATOR">
<meta content="FrontPage.Editor.Document" name="ProgId">
</head>
<!--//
function check()
{
if (isNaN(go2to.page.value))
alert("請正確填寫轉到頁數！");
else if (go2to.page.value=="")
{
alert("請輸入轉到頁數！");
}
else
go2to.submit();
}
//-->
<body>
<div align="center">
<table bgcolor="#808080" border="0" cellpadding="18" cellspacing="3" width="670">
<tbody>
<tr>
<td bgcolor="#ffffff" width="100%">
<div align="center">
<table bgcolor="#919793" border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="194"><img border="0" src="../../../images/top1.gif"></td>
<td valign="top">
<table border="0" cellpadding="0" cellspacing="0" width="100%" bgcolor="#FFFFFF" height="80">
<tr>
<td width="100%" bgcolor="#FFFFFF" height="80"> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<center>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td bgcolor="#919793" height="4"><img alt="1pix" border="0" src="../../../images/1px.gif"></td>
</tr>
</tbody>
</table>
</div>
<div align="center">
<table bgcolor="#e7e7e7" border="0" cellpadding="2" cellspacing="0" width="100%">
<tbody>
<tr>
<td width="46%"><img border="0" src="../../../images/circle.gif">
你的位置：<a href="file:///E%7C">樂清資訊</a> >> <font color="#0012C1">系統管理</font></td>
<center></center>
<td width="54%"> </td>
</tr>
</tbody>
</table>
</div>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%">
<table bgcolor="#FFFFFF" border="0" cellpadding="5" cellspacing="0" width="100%">
<tbody>
<tr>
<td width="100%" height="10">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="600">
<tr>
<td width="100%" valign="top" align="center" height="20"></td>
</tr>
<tr>
<td width="100%" valign="top" align="center" height="30"><font size="3"><b>新聞發布管理</b></font></td>
</tr>
<tr>
<td width="100%" valign="bottom" align="center"></td>
</tr>
<tr>
<td>
<div align="center">
<div align="center">
<table border="0" cellpadding="2" cellspacing="0" width="500" height="0" bordercolor="#316594" bordercolordark="#FFFFFF">
<% set rs=server.createobject("adodb.recordset")
if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if
sq2="select * from sjnews order by id desc"
rs.open sq2,conn,1,1
rs.pagesize=20
if pagecount>rs.pagecount or pagecount<=0 then
pagecount=1
end if
rs.AbsolutePage=pagecount %>
<tr> <% if rs.pagecount=1 then %>
<td ?height="19" colspan="2" valign="bottom" height="25"><font color="#000000" size="2">共有[<font color="#ff0000"><%=rs.recordcount%></font>]條<%=jylb%>記錄
以下是[<font color="red">1～<%=rs.recordcount%></font>]條</font></td>
</tr>
<%else%>
<tr>
<td colspan="2" valign="bottom" height="25"><font color="#000000">
<% page_start=(pagecount-1)*rs.pagesize
if pagecount=1 then page_start=1
page_end=rs.pagesize*pagecount
if pagecount*rs.pagesize=>rs.recordcount then page_end=rs.recordcount end if%><font size="2">共有[<font color="#ff0000"><%=rs.recordcount%></font>]條<%=jylb%>記錄
以下是[<font color="red"><%=page_start%>～<%=page_end%></font>]條</font></font></td>
<tr>
<td colspan="2" valign="bottom"></td>
<tr>
<td colspan="9" valign="bottom"><% response.write"<form name=go2to form method=Post action='sjnews.asp?key="+key+"&jylb="+jylb+"'>"
response.write "<font color='#000064'></font>"
if pagecount=1 then
response.write "<font color='#000064'><font size=2>首頁 上一頁</font></font> "
else
response.write "<a href=sjnews.asp?page=1&key="+key+"&jylb="+jylb+"><font color='0000BE'><font size=2>首頁</font></font></a> "
response.write "<a href=sjnews.asp?page="+cstr(pagecount-1)+"&key="+key+"&jylb="+jylb+"><font color='0000BE'><font size=2>上一頁</font></font></a> "
end if
if rs.PageCount-pagecount<1 then
response.write "<font color='#000064'><font size=2>下一頁 尾頁</font></font>"
else
response.write "<a href=sjnews.asp?page="+cstr(pagecount+1)+"&key="+key+"&jylb="+jylb+"><font color='0000BE'><font size=2>下一頁</font></font></a> "
response.write "<a href=sjnews.asp?page="+cstr(rs.PageCount)+"&key="+key+"&jylb="+jylb+"><font color='0000BE'><font size=2>尾頁</font></font></a>"
end if
response.write "<font color='000064'> <font size=2>頁次:<font color=blue>"&pagecount&"</font>/"&rs.pagecount&"頁</font></font>"
response.write "<font color='000064'> <font size=2>轉到第<input type='text' name='page' size=2 maxLength=3 style='font-size: 9pt; color:#00006A; position: relative; height: 18' value="&PageCount&">頁</font></font> "
response.write "<input class=button type='button' value='確 定' onclick=checks() style='font-family: 宋體; font-size: 9pt; color: #000073; position: relative; height: 19'>" %>
</td>
<%end if%> </tr>
<tr align="left" valign="top">
<td height="10" colspan="2"><font size="1">.........................................................................................................................................................
</font></td>
</tr>
<% do while not rs.eof %> <%str1=len(rs("yhmc"))
str2=instr(rs("yhmc"),"(")
str4=mid(rs("yhmc"),str2+1,str1-1-str2)
str5=rs("loginmc")%>
<tr align="left">
<td height="25" valign="center" colspan="2"><font size="2"><a class="sbtxt" href='newsviews.asp?uid=<%=rs("id")%>'>·<%=rs("title")%></a>（<%=rs("idate")%>）<%if rs("idate")=date() then%><img src="../../../yueqing/admin/images/new!.gif" width="28" height="11"><%end if%></font><font size="2"> 發布人：<a class="sbtxt" href='shangwu/gszl.asp?uid=<%=rs("id")%>&uname=<%=str5%>'><%=rs("yhmc")%></a></font> <a class="sbtxt" href="main102-gl.asp?dels=<%=rs("id")%>"><font size="2">刪除</font></a></td>
</tr>
<% c=c+1
rs.movenext
if c>=20 then exit do
loop
rs.close
set rs=nothing %>
</table>
</div>
</div>
</tr>
</table>
</div>
<center>
<table border="0" cellpadding="0" cellspacing="0" width="600">
<tr>
<td width="100%" height="5">...................................................................................................</td>
</tr>
<tr>
<td width="100%" height="20"></td>
</tr>
</table>
<center>
<div align="center">
<table border="0" cellpadding="0" width="100%">
<tbody>
<tr>
<td bgcolor="#f3f3f3" width="87%">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td width="5%">
<p align="center"></p>
</td>
<td width="95%"></td>
</tr>
</tbody>
</table>
</div>
</td>
<td bgcolor="#0012C1" width="13%">
<p align="center"><a class="top" href="javascript:window.close()">關閉窗口</a></p>
</td>
</tr>
</tbody>
</table>
</div>
</center></center></td>
</tr>
</tbody>
</table>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="670">
<tr>
<td align="right" class="sorenge" valign="top" width="178" height="10"></td>
<td class="sbtxt" width="587" height="10"></td>
</tr>
<tr>
<td align="right" class="sorenge" valign="top" width="178"></td>
<td class="sbtxt" width="587"></td>
</tr>
</table>
</center>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</center></td>
</tr>
</table>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -