show.asp

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

<table width="590" height="500" border="0" cellpadding="0" cellspacing="0" class="wenbenkuang">
	<tr>
	 <TD valign="top">
		<table width="590" border="0" cellpadding="0" cellspacing="0">
		 	<tr>
            	<td width="590" height="5" valign=top></td>
          	</tr>
          	<tr>
            	<td width="590" height="12" valign=top align=center> 物 流 知 识 信 息 </td>
          	</tr>
		    <tr>
            	<td width="590" height="12" valign=top><div align="right"></div></td>
          	</tr>
          	<tr>
            	<td valign="top">
					<table width="590" border="0"  class=wenbenkuang>
						<tr bgcolor="#FFCC99">
			    			<td width="15%" align="center" class=wenbenkuang>知识类型</td>
                			<td width="56%" align="center" class=wenbenkuang>知识信息标题</td>
                			<td width="20%" align="center" class=wenbenkuang>发布时间</td> 
							<td width="9%" align="center" class=wenbenkuang>详细</td>            
			  			</tr>  
						<!-- #include file="../Conn/conn.asp" -->
						<% types=request.queryString("action") %>
						<% 
							sql="select * from tb_KnowLedgeMeg where Reside='"&types&"'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
   							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("Reside")%></td>
                			<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('Knowledge/particular.asp?id=<%=rs("ID")%>','','width=540,height=450,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>
			       </table>
	  </td>
     </tr>	
						<% else %>
       </table>
	  </td>
     </tr>
     <tr>
         <td height="12" align＝center><div align="center">暂时没有与<%=types%>相关的信息</div></td>
						<% end if%> 
     </tr>
</table>