car.asp

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

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body {
	margin-top: 0px;
	margin-bottom: 0px;
}
-->
</style>
&nbsp;<table width="92%" height="411" border="0" align="center" cellpadding="0" cellspacing="0">
	<tr>
		<td height="399" colspan="2" valign="top">
		 	<table width="99%" 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('Cars/add.asp','','width=550,height=420,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>
							<!-- #include file="../Conn/conn.asp" -->
								<% 
									sql="select * from tb_CarMessage 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="18%" align="center" class=wenbenkuang>车牌号码</td>
                				<td width="8%" align="center" class=wenbenkuang>类型</td> 
								<td width="19%" align="center" bgcolor="#FFCC99" class=wenbenkuang>车辆品牌</td>
                				<td width="13%" align="center" class=wenbenkuang>车辆限重</td>   
			    				<td width="11%" align="center" class=wenbenkuang>已使用</td>
                				<td width="13%" align="center" class=wenbenkuang>驾驶员驾龄</td> 
								<td width="10%" align="center" class=wenbenkuang>运输类型</td>
								<td width="8%" 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("TradeMark")%></td>
                				<td align="center" class=wenbenkuang><%=rs("Style")%></td> 
								<td align="center" class=wenbenkuang><%=rs("Brand")%></td>
                				<td align="center" class=wenbenkuang><%=rs("CarLoad")%>吨</td>   
			    				<td align="center" class=wenbenkuang><%=rs("UsedTime")%>年</td>
                				<td align="center" class=wenbenkuang><%=rs("DriverTime")%>年</td>  
			    				<td align="center" class=wenbenkuang><%=rs("TranSportStyle")%></td>
                				<td align="center" class=wenbenkuang>
									<a href="#" onclick="window.open('Cars/show.asp?id=<%=rs("ID")%>','','width=580,height=400,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>
				<% else %>
       	  </table>
	  </td>
  </tr>
          <tr>
            <td height="12"></td>
				<% 
					set rs=nothing
					conn.close
					set conn=nothing
					end if
				%> 
         </tr>
</table>
</tr>
</table>