show.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">&nbsp;<table width="100%" height="500" border="0" align="center" cellpadding="0" cellspacing="0">
	<tr>
		<td colspan="2" valign="top">
		 	<table width="97%" border="0" align="center" 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">
							<a href="#" onclick="window.open('Enterprise/add.asp','','width=620,height=580,toolbar=no,location=no,status=no,menubar=no,scrollbars=yes')">发布信息</a>
						</div>
					</td>
          		</tr>
          		<tr>
            		<td height="12">
						<table width="100%" border="0" class=wenbenkuang>
						   							
			  				<tr bgcolor="#FFCC99">
			    				<td width="43%" align="center" class=wenbenkuang>企业名称</td>
                				<td width="14%" align="center" class=wenbenkuang>企业类型</td> 
								<td width="25%" align="center" bgcolor="#FFCC99" class=wenbenkuang>企业网址</td>
                				<td width="11%" align="center" class=wenbenkuang>联系人 </td>   
								<td width="7%" align="center" class=wenbenkuang>详细</td>            
			  				</tr>  
							<!-- #include file="../Conn/conn.asp" -->
							<% 
								sql="select * from tb_EnterPriseMeg 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("EnterpriseName")%></td>
                				<td align="center" class=wenbenkuang><%=rs("EnterpriseSort")%></td> 
								<td align="center" class=wenbenkuang><%=rs("Http")%></td>
                				<td align="center" class=wenbenkuang><%=rs("LinkMan")%></td>   
                				<td align="center" class=wenbenkuang>
									<a href="#" onclick="window.open('Enterprise/particular.asp?id=<%=rs("ID")%>','','width=540,height=600,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>
</td>
</tr>
</table></td>
  </tr>
</table>
  </tr>
</table>