car.asp

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

<style type="text/css">
<!--
.STYLE1 {
	font-size: 9pt;
	color: #FFFFFF;
}
-->
</style>
<table width="554" height="60" border="0" align="center" cellpadding="0" cellspacing="0">
  	<tr>
    	<td width="573" height="18"><div align="center"></div></td>
  	</tr>
  	<tr>
    	<td>
			<table width="554" height="40" border="0" cellpadding="0" cellspacing="0">
			<form name="searchs" method="post" action="index.asp?action=back&type=car">
      			<tr bgcolor="#efefef">
					<td width="119"><div align="right">关键字：</div></td>
					<td width="168">
          				<input name="keywords" type="text" class="wenbenkuang">
        			</td>
					<td width="83"><div align="right">关键字类型：</div></td>
					<td width="104">
						<select name="types" class="wenbenkuang">
							  <option value="TradeMark">车牌号码</option>
							  <option value="Brand">车辆品牌</option> 
							  <option value="Style">车辆类型</option>
							  <option value="CarLoad">车辆最大载重</option>
							  <option value="UsedTime">车辆使用时间</option>
							  <option value="DriverName">驾驶员姓名</option>
							  <option value="DriverTime">驾龄</option>
							  <option value="LicenceNumber">驾照号码</option>
							  <option value="LicenceStyle">驾照类型</option>
							  <option value="TranSportStyle">运输类型</option>
							  <option value="LinkPhone">联系电话</option>
							  <option value="UserName">发布人</option>
          				</select>	
		            </td>
        			<td width="99"><div align="center">
          				<input name="Submit" type="submit" class="go-wenbenkuang" value="查询">          
        			</div></td>	
      			</tr>
				<tr>
        			<td height="18" colspan="5"><div align="right"></div></td>
        		</tr>
			</form>
   		  </table> 
		</td>
  	</tr>
</table>
<table width="554" height="408" border="0" align="center" cellpadding="0" cellspacing="0">
  	<tr>
   	  <td width="562" height="17" background="../../images/23.gif"><div align="left" class="STYLE1">车辆信息管理</div></td>
  	</tr>
  	<tr>
    	<td height="371"valign="top">
			<table width="554" border="0" cellspacing="3" cellpadding="0">
 				<tr bgcolor="#ffcc99">
				  <td width="80" height="23" bgcolor="#ffcc99" class="wenbenkuang"><div align="center">车辆号码</div></td>
					<td width="147" bgcolor="#ffcc99" class="wenbenkuang"><div align="center">车辆品牌</div></td>
					<td width="113" bgcolor="#ffcc99" class="wenbenkuang"><div align="center">驾驶员姓名</div></td>
					<td width="122"  class="wenbenkuang"><div align="center">发布时间</div></td>
					<td width="54" class="wenbenkuang"><div align="center">发布人</div></td>
					<td width="51" class="wenbenkuang"><div align="center">管理</div></td>
  				</tr>
<!-- #include file="../../Conn/conn.asp" -->
<% 
	if request.form("keywords")="" then
   		sql="select * from tb_CarMessage "
   		str="暂时没有用户发布空车信息"
   	else
   		sql="select * from tb_CarMessage where "&request.form("types")&" like '%"&request.form("keywords")&"%' order by IssueDate desc"
   		str="没有符合条件的空车信息"
   	end if
   	rs.pagesize=10
   	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
   			i=i+1
   			formname="form"&i
%>
				<form name=<%=formname%> action="" method="post">   
  				<tr>
					<td class="wenbenkuang"><div align="center"><%=rs("TradeMark")%></div></td>
					<td class="wenbenkuang"><div align="center"><%=rs("Brand")%></div></td>
					<td class="wenbenkuang"><div align="center"><%=rs("DriverName")%></div></td>
					<td class="wenbenkuang"><div align="center"><%=rs("IssueDate")%></div></td>
					<td class="wenbenkuang"><div align="center"><%=rs("UserName")%></div></td>
					<td class="wenbenkuang"><div align="center">
						<a href="#" onclick="window.open('manage/Cars/show.asp?id=<%=rs("ID")%>','','width=540,height=450,toolbar=no,location=no,status=no,menubar=no,scrollbars=yes')">
							<img src="../../images/manage.gif" width="51" height="21" border="0">
						</a>
					</div></td>
    			</tr>
				</form> 
<% 
   	rs.movenext()
   	wend 
%>
          		<tr >
            		<td height="12" align=right colspan="6">
<% 
	if page=1 then
      	if page<>rs.pagecount then 
%>
	  					<a href="index.asp?action=back&type=car&pages=<%=page+1%>">下一页</a>
	  					<a href="index.asp?action=back&type=car&pages=<%=rs.pagecount%>">最后一页</a>
	  <%end if %>
<% 	else %>
     <%	if page<rs.pagecount then %>
						  <a href="index.asp?action=back&type=car&pages=1">第一页</a>
						  <a href="index.asp?action=back&type=car&pages=<%=page-1%>">上一页</a>
						  <a href="index.asp?action=back&type=car&pages=<%=page+1%>">下一页</a>
						  <a href="index.asp?action=back&type=car&pages=<%=rs.pagecount%>">最后一页</a>
	  <%else %>
						<a href="index.asp?action=back&type=car&pages=1">第一页</a>
	  					<a href="index.asp?action=back&type=car&pages=<%=page-1%>">上一页</a>
	  <%end if %>
<% end if %>	  
					</td>
  				</tr>
<% else %>
				<tr>
					<td colspan="6" class="wenbenkuang"><div align="center" class="style11"><%=str%></div></td>
				</tr>			
<% end if %>			
   		  </table>
		</td>
  	</tr>
	<tr>
    	<td height="20"></td>
  	</tr>
</table>