huowu.asp

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

<style type="text/css">
<!--
body {
	margin-top: 0px;
	margin-bottom: 0px;
}
-->
</style><table width="587" height="466" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="587" height="466"><table width="550" height="453" border="0" cellpadding="0" cellspacing="0">
	<tr>
        <td width="587" height="453" colspan="2" valign="top"><table width="587" height="472" border="0" cellpadding="0" cellspacing="0">
	<tr>
		<td width="587" height="441" 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('Goods/add.asp','','width=550,height=440,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 align="center" class=wenbenkuang>货物名称</td>
               							<td align="center" class=wenbenkuang>货物类型</td> 
										<td align="center" class=wenbenkuang>货物数量</td>
                						<td align="center" class=wenbenkuang>起始地点</td>   
			    						<td align="center" class=wenbenkuang>到达地点</td>
                						<td align="center" class=wenbenkuang>运输类型</td> 
										<td align="center" class=wenbenkuang>车辆要求</td>
										<td align="center" class=wenbenkuang>详细</td>            
			  						</tr>  
							<!-- #include file="../Conn/conn.asp" -->
							<% 
								sql="select * from tb_GoodsMeg 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("GoodsName")%></td>
													<td align="center" class=wenbenkuang><%=rs("GoodsStyle")%></td> 
													<td align="center" class=wenbenkuang><%=rs("GoodsNumber")%><%=rs("GoodUnit")%></td>
                									<td align="center" class=wenbenkuang><%=rs("StartOmit")%><%=rs("StartCity")%></td>   
			    									<td align="center" class=wenbenkuang><%=rs("EndOmit")%><%=rs("EndCity")%></td>
                									<td align="center" class=wenbenkuang><%=rs("Style")%></td>  
			    									<td align="center" class=wenbenkuang><%=rs("Request")%></td>
                									<td align="center" class=wenbenkuang><a href="#" onclick="window.open('Goods/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>
						<% else %>
       	  </table>
	  </td>
  </tr>
          <tr>
            <td height="31"></td>
					<% end if%> 
					<%								
						set rs=nothing
						conn.close
						set conn=nothing
					%>
         </tr>
</table>
    </td>
  </tr>
</table>
&nbsp;</td>
  </tr>
</table>&nbsp;</td>
 </tr>
</table>