?? index_bak.htm
字號(hào):
<%response.expires=-1%>
<!--#include file="../inc/Secure.htm"-->
<!--#include file="../inc/conn.htm"-->
<%
LoginID=trim(session("LoginID"))
if LoginID="" then LoginID=0
Department = GetTableValue ("tblUser","Department","ID",LoginID)
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from tblBulletin where (ToID="& LoginID &" or ToAll=1 or toDepartment="& Department &" ) Order by ID desc"
%>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="../CSS/main.css">
</HEAD>
<BODY BGCOLOR="#FFFFFF" leftmargin=20 topmargin=5>
<BR>
<div align=center>
<table width="80%" border="0" cellspacing="0" cellpadding="0">
<tr align="center">
<td width="25%"><img src="../images/zxgg-2.gif" width="110" height="20"></td>
<td width="25%"><a href="read_index.htm"><img src="../images/lsgg.gif" width="110" height="20" border=0></a></td>
<td width="25%"><a href="NewBulletin.htm"><img src="../images/wyqfgg.gif" width="110" height="20" border=0></a></td>
<td width="25%"><a href="myBulletin.htm"><img src="../images/wfbdgg.gif" width="110" height="20" border=0></a></td>
</tr>
</table>
</div>
<BR>
<div align=center>
<table border=0 width="90%" cellspacing="1" cellpadding=3 bgcolor="#005AB5">
<tr bgcolor=#53A9FF>
<td>分類</td>
<td>標(biāo)題</td>
<td>主題詞</td>
<td>發(fā)布人</td>
<td>發(fā)布時(shí)間</td>
</tr>
<%
rs.open sql,oConn
nCount=0
while not rs.eof
strHaveRead=trim(rs("HaveRead"))
arrHaveRead=split(strHaveRead,",")
bHave=false
for i=0 to ubound(arrHaveRead)
if trim(LoginID)=trim(arrHaveRead(i)) then
bHave=true
exit for
end if
next
if not bHave then
nCount=nCount+1
if nCount mod 2 =0 then
strColor="#E6F2FF"
else
strColor="#FFFFFF"
end if
%>
<tr bgcolor=<%=strColor%>>
<td nowrap width=50><%=GetTableValue("tblBulletinClass","Name","ID",trim(rs("classID")))%></td>
<td><a href="Detail.htm?ID=<%=trim(rs("ID"))%>"><%=trim(rs("Title"))%></a></td>
<td><a href="Detail.htm?ID=<%=trim(rs("ID"))%>"><%=trim(rs("Keywords"))%></a></td>
<td nowrap width=80><%=trim(rs("fromName"))%></td>
<td nowrap width=120><%=trim(rs("Times"))%></td>
</tr>
<%
end if
rs.movenext
wend
rs.close
set rs=nothing
if nCount="0" then
%>
<tr bgcolor=#ffffff><td colspan=5>暫時(shí)無內(nèi)容!</a></tr>
<%end if%>
</table>
</div>
<BR><BR>
</BODY>
</HTML>
<%
Function GetTableValue(TableName,Field,ValueField,Value)
if TableName<>"" and Value<>"" then
Set RsTmp = Server.Createobject("Adodb.recordset")
strSql = "Select "& Field &" from "& TableName &" where "& ValueField &"='"& Value &"'"
Rstmp.open strSql,oConn,1,1
If not Rstmp.eof then
GetTableValue=trim(Rstmp(Field))
else
GetTableValue=""
end if
Rstmp.close
'set RsTmp = Nothing
else
GetTableValue=""
end if
End Function
%>
<!--#include file="../inc/conn_close.htm"-->
<script language=javascript>
function CheckDelete()
{
return confirm("確實(shí)刪除嗎?");
}
</script>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -