new.asp

基于C#语言的一个物流信息网数据库系统开发案例的源代码 ,很实用

<style type="text/css">
<!--
body {
	margin-top: 0px;
	margin-bottom: 0px;
}
-->
</style><table width="587" height="63" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="587"><table width="587" height="500" border="0" cellpadding="0" cellspacing="0" >
	<tr>
        <td width="587" colspan="2" valign="top">
		 	<table width="100%" border="0" cellpadding="0" cellspacing="0">
		 		<tr>
            		<td width="100%" height="12" valign=top></td>
         		</tr>
         		<tr>
            		<td width="100%" height="12" valign=top align=center>物 流 动 态 信 息 展 示</td>
          		</tr>
		    	<tr>
            		<td width="100%" height="12" valign=top><div align="right"></div></td>
          		</tr>
          		<tr>
            		<td height="12">
						<table width="99%" border="0" align="center" class=wenbenkuang>
							<!-- #include file="../Conn/conn.asp" -->
							<% 
								sql="select * from tb_NewMeg order by IssueDate desc"
   								rs.pagesize=24
   								page=request.QueryString("pages")
   								if page="" then page=1 end if 
   								rs.open sql,conn,1,3
   								if not rs.eof or not rs.bof then 
   								rs.absolutepage=cint(page)
   								i=0
   							%>
			  				<tr bgcolor="#FFCC99">
			    				<td width="78%" align="center" class=wenbenkuang>信息标题</td>
                				<td width="15%" align="center" bgcolor="#FFCC99" class=wenbenkuang>发布时间</td>
                				<td width="7%" align="center" class=wenbenkuang>详细</td>            
			  				</tr>  
   							<%
   								while not rs.eof and i<rs.pagesize
   								i=i+1
   								formname="form"&i
							%>           
						<form name=<%=formname%> action="" method="post">   
			  				<tr>
			    				<td align="center" class=wenbenkuang><%=rs("Title")%></td>
                				<td align="center" class=wenbenkuang><%=rs("IssueDate")%></td>
                				<td align="center" class=wenbenkuang>
									<a href="#" onclick="window.open('New/show.asp?id=<%=rs("ID")%>','','width=540,height=500,toolbar=no,location=no,status=no,menubar=no,scrollbars=yes')">详细</a>
								</td>             
			  				</tr>
			  			</form> 
							<% 
   								rs.movenext()
   								wend 
							%>
           			  </table>
					</td>
          		</tr>
		  		<tr>
            		<td height="12"></td>
         		</tr>
          		<tr>
            		<td height="12" align=right>
						<% 
							if page=1 then
      							if page<>rs.pagecount then 
						%>
	  								<a href="index.asp?action=huowu&pages=<%=page+1%>">下一页</a>
	  								<a href="index.asp?action=huowu&pages=<%=rs.pagecount%>">最后一页</a>
	  						<% end if %>
						<% else %>
       						<% if page<rs.pagecount then %>
   	  								<a href="index.asp?action=huowu&pages=1">第一页</a>
	  								<a href="index.asp?action=huowu&pages=<%=page-1%>">上一页</a>
	  								<a href="index.asp?action=huowu&pages=<%=page+1%>">下一页</a>
	  								<a href="index.asp?action=huowu&pages=<%=rs.pagecount%>">最后一页</a>
	  						<% else %>
	     	  						<a href="index.asp?action=huowu&pages=1">第一页</a>
	  								<a href="index.asp?action=huowu&pages=<%=page-1%>">上一页</a>
	  						<% end if %>
						<% end if %>	  
					</td>
				</tr>
							<% else %>
          	</table>
	  </td>
	</tr>
    <tr>
    	<td height="12" align=center>暂时没有任何的行业动态信息</td>
			<% 
				set rs=nothing
				conn.close
				set conn=nothing
				end if
			%> 
	</tr>
</table>&nbsp;</td>
  </tr>
</table>
</td>
</tr>
</table>