<!--#include file="../SQLconn.asp"-->
<html>

<head>

<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/style.css">
<title>文件列表</title>



<style type="text/css">
<!--
body {
	background-color: #FFFFFF;
}
-->
</style></head>
<body topmargin="5" leftmargin="5">



<%
  strftype=request("ftype")
  tname=request.cookies("tname")

 
 
 
Set rs=Server.CreateObject("Adodb.Recordset")
'sql="Select * from gonggao  where fDate BETWEEN '"&strdate11&"'  AND   '"&strdate22&"') AND (Title like  '%"&title&"%')  AND (Content like  '%"&guanjianci&"%')   ftype='通知' order by id desc"
sql="SELECT g.*, s.*   FROM gonggao g INNER JOIN  gonggaosee s ON g.id = s.fid  where  (s.标星='是')   and    (tname ='"&tname&"') and  (ftype='"&strftype&"') order by 标星时间 desc"
rs.open sql,conn,1,1

rs.pagesize=15 '每页记录条数
curpage=Request.QueryString("curpage") '将URL参数curpage传给curpage变量
rs.absolutepage=curpage '将本页设为curpage设置的页数
if curpage=0 then
   curpage=1
end if 

%>
<form id="form1" name="form1" method="post" action="filelist.asp?ftype=<%=strftype%>">
<link rel="stylesheet" type="text/css" href="../css/style.css" />

<script>

</script>
<br>
<script><!--打开公告-->
function open_notify(NOTIFY_ID,FORMAT)
{
 URL="openFile.asp?id="+NOTIFY_ID;
 myleft=80;
 mytop=80
 mywidth=(screen.availWidth-160);
 myheight=(screen.availHeight-120);
 if(FORMAT=="1")
 {
    myleft=0;
    mytop=0
    mywidth=screen.availWidth-10;
    myheight=screen.availHeight-40;
 }
 window.open(URL,'_blank',"height="+myheight+",width="+mywidth+",status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top="+mytop+",left="+myleft+",resizable=yes");
}
</script>

<table width="95%" border="1" align="center" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8"  class="mtable">
 <tr style="background-color:#D6E4FF"  class="TableHeader">
  
	  <td height="30" align="center" nowrap class="STYLE1"><span class="STYLE1">标题</span></td>
      <td align="center" nowrap class="STYLE1">发布人</td>
      <td align="center" nowrap class="STYLE1"><span class="STYLE1">日期/点击</span></td>
  </tr>
<%
   for i= 1 to 100
      if rs.eof then
         exit for
      end if
%>
    <tr onMouseOut="this.style.backgroundColor=''" onMouseOver="this.style.backgroundColor='#EFF8FF'">
	<td width="453" height="30">
	
	
	
	&nbsp;
	
	<%if rs("Havesee")="已经查阅"   then  
	 else  %>
				    <img src="../images/<%=request.cookies("imgdir")%>/gonggaoNew.gif" width="22" height="9"> 
        <%end if %>
	<%if trim(rs("ontop"))<>"顶置" then  
				else  %>
                <img src="../images/<%=request.cookies("imgdir")%>/ding.gif" width="15" height="13">
                <%end if  %>
     <span class="STYLE1"> <a href="javascript:open_notify(<%=rs("id")%>,'0');"><%=rs("title")%><a></td>
    <td width="202" class="STYLEname"><div align="center"><%=rs("author")%></div></td>
    <td width="202"><div align="center" class="STYLEDATE"><%=left(rs("fdate"),9)%>&nbsp;&nbsp;<span class="STYLEHIT">(<%=rs("hits")%>)
	
	  <%if rs("标星")="是"   then %>      
            <a href="bianxing.asp?yemian=biaoxinglist&id=<%=rs("id")%>&biaoxing=0&date1=<%=strdate1%>&date2=<%=strdate2%>&title=<%=title%>&guanjianci=<%=guanjianci%>&ftype=<%=strftype%>&curpage=<%=curpage%>">&nbsp;<img src="../images/img/main/biaoxing1.jpg" width="16" height="16"  border="0">&nbsp;</a>
       <%  else %>
           <a href="bianxing.asp?yemian=biaoxinglist&id=<%=rs("id")%>&biaoxing=1&date1=<%=strdate1%>&date2=<%=strdate2%>&title=<%=title%>&guanjianci=<%=guanjianci%>&ftype=<%=strftype%>&curpage=<%=curpage%>">&nbsp;<img src="../images/img/main/biaoxing0.jpg" width="16" height="16"  border="0">&nbsp;</a>
		   <%end if %>	
	
	</span></div>
	
	
	</td> 
	
	
	
	</tr>
<%  rs.movenext
    next%>
</table>
  <br>
  <div>
  <br>
<p align="center"> 
		<input name="button" type="button" class="topanniu" onClick="location='../main.asp';"  value="返回桌面" />
	 
</p>
</form>

</body>  
  
</html>  