news_search.asp
来自「OFFICE办公自动化」· ASP 代码 · 共 225 行
ASP
225 行
<%
'功能：查询新闻
%>
<!--#include file="../inc/Secure.asp"-->
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/Const.asp"-->
<%
'response.buffer=false
'------------------------------------------------设置参数
LoginID=trim(session("LoginID")) : if LoginID="" then LoginID=0 '当前用户ID
'------------------------------------------------
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/main.css" type=text/css>
<title>main</title>
<base target="FrmMain">
<script src="../js/Popup.js"></script>
</head>
<body topmargin="10" leftmargin="10">
<br>
<div align="center">
<table width="450" cellspacing="1" cellpadding="2" class="tab">
<form id="eventfrm" method="post" name="frm_a_search">
<tr>
<td width="100%" class="tdTop" colspan="2">
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="tdTop">
<p align="left"><img border="0" src="../images/icon_title.gif" align="left">搜索新闻</p>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="102" align="right" height="25" class="td1">信息类别： </td>
<td class="td1">
<select name="newsort" >
<%set rs_child=server.CreateObject("adodb.recordset")
rs_child.Open "select * from tbioaInfoStyle order by id",oConn,1,1
if rs_child.RecordCount=0 then
rs_child.Close
set rs_child=nothing
else
do until rs_child.EOF
Response.Write "<option value='" & rs_child("id") & "'>" & rs_child("newsort") & "</option>"
rs_child.MoveNext
loop
rs_child.Close
set rs_child=nothing
end if
%>
<option value="0" selected>所有信息</option>
</select>
</td>
</tr>
<tr>
<td width="102" align="right" height="25" class="td1">发布日期： </td>
<td class="td1">
<input type="text" name="StartDate" maxlength="10" size="10" class="input" readonly> <a href=# title="选择日期" onClick="fPopUpDlg('../js/calendar.htm', document.eventfrm.StartDate, 'winpop', 234, 261);return false"><img src="../images/datetime.gif" border=0></a>
至
<input type="text" size="10" maxlength="10" name="EndDate" value="" class="input" readonly> <a href=# title="选择日期" onClick="fPopUpDlg('../js/calendar.htm', document.eventfrm.EndDate, 'winpop', 234, 261);return false"><img src="../images/datetime.gif" border=0></a>
(如：2001-7-13)
</td>
</tr>
<tr>
<td width="102" align="right" height="25" class="td1">关 键 字： </td>
<td class="td1">
<input type="text" name="keyword" class="input">
</td>
</tr>
<tr>
<td width="102" align="right" height="25" class="td1">搜索范围： </td>
<td class="td1">
<input type="radio" name="passed" value="1" checked>
标题
<input type="radio" name="passed" value="2">
内容
<input type="radio" name="passed" value="0">
全文
<input type="submit" name="Submit2" value="开始搜索" class="button0" onmouseout=className="button0" onmouseover=className="button1">
</td>
</tr>
<tr><td class="tdbottom" colspan="2"></td></tr>
</form>
</table>
<%if Request.ServerVariables("REQUEST_METHOD")="POST" then
'------------------------------------------------设置参数
maxmessage=15 '每页显示记录数
currentpage=request("page") '当前页码
Search=request("Search") '上次查询条件
'------------------------------------------------
'------------------------------------------------取记录
'分页取新闻记录 （返回rs对象）
'rs.recordcount 为记录总数
'rs.PageSize 为本页记录数
'
if Search="" then
newsort=Request.Form("newsort"):if newsort="" then newsort=0
keyword=replace(Request.Form("keyword"),"'","")
passed=Request.Form("passed")
s_date=Request.Form("StartDate"):if not isdate(s_date) then s_date=""
e_date=Request.Form("EndDate"):if not isdate(e_date) then e_date=""
sqlstr="SELECT t.id,t.title,t.newsdate,m.newsort as boardname FROM tbioaInfomation t,tbioaInfoStyle m WHERE t.newsort=m.id AND t.title<>''"
if keyword<>"" then '当有关键字输入时
select case passed
case 0
key_search_str=" AND (t.title like '%" & keyword & "%' or t.content like '%" & keyword & "%')"
case 1
key_search_str=" AND (t.title like '%" & keyword & "%')"
case 2
key_search_str=" AND (t.content like '%" & keyword & "%')"
end select
else
key_search_str=""
end if
sqlstr=sqlstr & key_search_str
if newsort=0 and (not returnqx("0404")) then
set rs1=Server.CreateObject("ADODB.RecordSet")
sql_stmt="select * from tbioaInfoStyle"
rs1.open sql_stmt,oConn,1,1
if not rs1.eof then
do while not rs1.eof
viewAuth=ReturnManage(rs1("viewermod"),rs1("ID"),"viewer","tbioaInfoStyle") '取当级目录查看权限
manageAuth=ReturnManage(rs1("managermod"),rs1("ID"),"manager","tbioaInfoStyle") '取当级目录管理权限
if viewAuth or manageAuth then
search_sort=search_sort&rs1("id")&"," '得到可查看的栏目ID
end if
rs1.movenext
loop
rs1.close
if len(search_sort)>1 then '有可查看的栏目
search_sort=left(search_sort,len(search_sort)-1)
sqlstr=sqlstr & " AND t.newsort in (" & search_sort &") "
else '没有可查看的栏目
sqlstr=sqlstr & " AND 1<>1"
end if
end if
else
set rs1=Server.CreateObject("ADODB.RecordSet")
sql_stmt="select * from tbioaInfoStyle where id=" & newsort
rs1.open sql_stmt,oConn,1,1
if not rs1.eof then
viewAuth=ReturnManage(rs1("viewermod"),rs1("ID"),"viewer","tbioaInfoStyle") '取当级目录查看权限
manageAuth=ReturnManage(rs1("managermod"),rs1("ID"),"manager","tbioaInfoStyle") '取当级目录管理权限
if viewAuth or manageAuth or returnqx("0404") then '判断是否有查看该栏目的权限
sqlstr=sqlstr & " AND t.newsort = " & newsort
else
sqlstr=sqlstr & " AND 1<>1"
end if
end if
end if
' if newsort<>0 then
' if i=true then
' sqlstr=sqlstr & " AND m.parentID=" & newsort
' else
' sqlstr=sqlstr & " AND t.newsort=" & newsort
' end if
' end if
if s_date<>"" then
if e_date<>"" then
date_search_str=" AND (t.newsdate between '" & s_date & " 00:00' and '" & e_date & " 23:59')"
else
date_search_str=" AND (t.newsdate between '" & s_date & " 00:00' and '" & s_date & " 23:59') "
end if
else
if e_date<>"" then
date_search_str=" AND (t.newsdate between '" & e_date & " 00:00' and '" & e_date & " 23:59')"
else
date_search_str=""
end if
end if
sqlstr=sqlstr & date_search_str & " ORDER BY newsdate desc"
else
sqlstr=Search
end if
set rs=Server.CreateObject("ADODB.RecordSet")
sql="SELECT tbioaInfomation.*,tbioaUser.Name from tbioaInfomation join tbioaUser on sender=tbioaUser.ID WHERE newsort=" & Style
' response.write sqlstr
rs.Open sqlstr,oConn,1,1
Showpage=SearchPaging(rs,maxmessage,currentpage,sqlstr)
'------------------------------------------------
%>
<br>
<table width="500" border=0 cellspacing="0" cellpadding="0">
<tr>
<td width=150><img border="0" src="../images/icon_title.gif" align="left">
以下是新闻搜索结果
</td>
<td><%=Showpage%></td>
</tr>
</table>
<%
if rs.RecordCount=0 then
response.write "<BR><BR>暂时为空！"
else
%>
<table border=0 cellspacing=2 cellpadding=2 align="center" width="500">
<%for i = 0 to rs.PageSize-1 '循环
If rs.EOF Then Exit For
if i mod 2 = 0 then td_class="td1" else td_class="td2"
%>
<tr>
<td>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?