?? info_index.htm
字號:
<!--#include file="../inc/Secure.htm"-->
<!--#include file="../inc/conn.htm"-->
<!--#include file="../inc/dbtools.htm"-->
<!--#include file="../inc/SelfRights.htm"-->
<%
ClassID=trim(Request("ClassID"))
if ClassID="" then ClassID=1
select case classID
case "1"
ClassName="公務活動安排"
case "2"
ClassName="公務活動接待"
case "3"
ClassName="事務接洽記錄"
end select
LoginID=trim(session("LoginID"))
if LoginID="" then LoginID=0
UserName=GetTableValue ("tblUser","Name","ID",LoginID)
maxmessage=20
currentpage=request("page")
if currentpage="" then
currentpage=1
end if
Title=replace(trim(request("Title")),"'","''")
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select ID,ClassID,FromName,Title,Times from tblInfo where ClassID="& ClassID
if Title<>"" then
sql=sql& " and Title like '%"& Title &"%'"
end if
sql=sql& " 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
arrMsg=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>
<a href="info_admin.htm">進入""管理維護</a>
<fieldset title="<%=className%>">
<legend align=center><font color=red class="pt14"></font></legend>
<form name="SearchForm" method="post" action="">
<div align=center>
<table border=0>
<tr>
<td>關鍵詞：<input type="text" name="Title" class="input" size=20></td>
<td><input type="submit" name="cmdUp" value="檢 索" class="font9boldwhite"></td>
</table>
</div>
</form>
<div align=center>
<table border=1 cellpadding=3 cellspacing=1 width="95%" bgcolor=#EEEEEE bordercolordark="#FFFFFF" bordercolorlight="#999999">
<tr bgcolor=#CCCCCC>
<td width=80>錄入用戶</td>
<td>標題</td>
<td width="20%">錄入時間</td>
</tr>
<%for i = 0 to UBound(arrMsg,2)
%>
<tr>
<td><%=arrmsg(2,i)%></td>
<td><a href="info_detail.htm?ID=<%=trim(arrmsg(0,i))%>"><%=arrmsg(3,i)%></a></td>
<td><%=arrmsg(4,i)%></td>
</tr>
<%
next%>
</table><BR>
</div>
<BR>
</fieldset>
</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 Function
%>
<!--#include file="../inc/conn_close.htm"-->
<script language=javascript>
function CheckDelete()
{
return confirm("確實刪除嗎？");
}
</script>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -