read_index.htm

来自「全方面的OA管理程序代码」· HTM 代码 · 共 123 行

HTM
123 行
字号 
<%response.expires=-1%>
<!--#include file="../inc/Secure.htm"-->
<!--#include file="../inc/conn.htm"-->
<%
LoginID=trim(session("LoginID"))
if LoginID="" then LoginID=0
UserName=GetTableValue ("tblUser","Name","ID",LoginID)
Department = GetTableValue ("tblUser","Department","ID",LoginID)

maxmessage=20
currentpage=request("page")
if currentpage="" then 
currentpage=1
end if

set rs=Server.CreateObject("ADODB.RecordSet")
sql="select ID,ClassID,Title,KeyWords,FromName,Times,ToID, ToDepartMent,ToAll from tblBulletin where (ToID<>'' or ToAll=1 or toDepartment="& Department &" ) Order by ID desc"

rs.pagesize=maxmessage
rs.open sql,oConn,1,1
totalpage=rs.pagecount
totalmessage=rs.recordcount
if totalmessage<>0 then
	rs.AbsolutePage=currentpage
	msgArr=rs.getrows(maxmessage)
end if

rs.close
%>
<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="90%" border="0" cellspacing="0" cellpadding="0">
  <tr align="center"> 
	<td width="25%"><a href="index.htm"><img src="../images/zxgg.gif" width="110" height="20" border=0></a></td>
	<td width="25%"><img src="../images/lsgg-2.gif" width="110" height="20" border=0></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="95%" cellpadding=0 cellspacing=0><tr>
    <td> 上页　　 下页 </td>
  </tr></table>
<div align=center>
  <table border=0 width="95%" cellspacing="1" cellpadding=3 bgcolor="#005AB5">
    <tr bgcolor=#53A9FF> 
      <td width="50">分类</td>
      <td>标题</td>
      <td nowrap width="15%">主题词</td>
      <td width="10%">发布人</td>
      <td width="120">发布时间</td>
    </tr>
    <%
if isempty(msgArr) then
	response.write "<tr><td colspan=7>暂时没有内容。</td></tr>"
else
n=0
for i = 0 to UBound(msgArr,2)
	toAll=trim(msgArr(8,i))
	toDepartment=trim(msgArr(7,i))

	strToID=trim(msgArr(6,i))
	arrToID=split(strToID,",")
	dim bToID
	bToID=false
	for k=0 to ubound(arrToID)
		if trim(LoginID)=trim(arrToID(k)) then
			bToID=true
			exit for
		end if
	next
if (bToID=true or Toall="1" or toDepartment=trim(Department)) then
	n=n+1
	if n mod 2 =0 then
		strColor="#FFFFFF"
	else
		strColor="#E6F2FF"
	end if
%>
    <%
end if
next
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("确实删除吗？");
}
</script>

read_index.htm - 源码说明

本页面展示了「全方面的OA管理程序代码」中的 read_index.htm 源码文件，采用 HTM 编程语言编写，共 123 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与方面相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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