member.asp

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

<style type="text/css">
<!--
.STYLE1 {
	font-size: 9pt;
	color: #FFFFFF;
}
-->
</style>
<table width="554" height="35" border="0" align="center" cellpadding="0" cellspacing="0">
  	<tr>
    	<td width="579" height="14"><div align="center"></div></td>
  	</tr>
  	<tr>
    	<td>
			<table width="554" height="21" border="0" align="center" cellpadding="0" cellspacing="0">
        	<form name="searchs" method="post" action="index.asp?action=back&type=member">
          		<tr bgcolor="#efefef">
            		<td width="70" height="21"><div align="right">关键字：</div></td>
            		<td width="180"><input name="keywords" type="text" class="wenbenkuang" size="25"></td>
            		<td width="86"><div align="right">关键字类型：</div></td>
            		<td width="174" bgcolor="#efefef">
              			<select name="types" class="wenbenkuang">
							<option value="UserName">用户名</option>
							<option value="Email">邮件地址</option>
							<option value="EnterpriseName">企业名称</option>
							<option value="EnterpriseStyle">企业类型</option>
							<option value="WorkArea">经营范围</option>
							<option value="Area">所在区域</option>
							<option value="Address">企业地址</option>
							<option value="PostalCode">邮政编码</option>
							<option value="Phone">联系电话</option>
							<option value="Fax">传真</option>
							<option value="HandSet">手机</option>
							<option value="LinkMan">联系人</option>
							<option value="OverPass">是否验证</option>
              			</select>
					</td>
            		<td width="78" bgcolor="#efefef"><input type="submit" name="Submit" value="查询" class=go-wenbenkuang></td>
				</tr>	
        	</form>
   		  </table>
		</td>
  	</tr>
</table>
<table width="554" height="411" border="0" align="center" cellpadding="0" cellspacing="0">
  	<tr>
    	<td height="20">&nbsp;</td>
  	</tr>
  	<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" align="center" cellpadding="0" cellspacing="3">
		 		<tr >
					<td height="12" colspan="6" align=right>&nbsp;</td>
        		</tr>
          		<tr bgcolor="#ffcc99">
            		<td width="80"  height="19" align=right class=wenbenkuang><div align="center">企业类型</div></td>
                   	<td width="51" align=right class=wenbenkuang><div align="center">用户名</div></td>
                   	<td width="81" align=right class=wenbenkuang><div align="center">联系电话</div></td>
                   	<td width="227" align=right bgcolor="#ffcc99" class=wenbenkuang><div align="center">E-mail</div></td>
                   	<td width="42" align=right bgcolor="#ffcc99" class=wenbenkuang><div align="center">验证</div></td>
                   	<td width="52" align=right bgcolor="#ffcc99" class=wenbenkuang><div align="center">管理</div></td>
				</tr>
<!-- #include file="../../Conn/conn.asp" -->
<% 
	if request.form("keywords")="" then
   		sql="select * from tb_UserMeg "
   		str="暂时没有用户注册"
   	else
   		sql="select * from tb_UserMeg where "&request.form("types")&" like '%"&request.form("keywords")&"%' order by OverPass desc"
   		str="没有你所要查找的信息"
   	end if 
   	rs.pagesize=11
   	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  height="19" align=right class=wenbenkuang><div align="center"><%=rs("EnterpriseStyle")%></div></td>
            		<td align=right class=wenbenkuang><div align="center"><%=rs("UserName")%></div></td>
            		<td align=right class=wenbenkuang><div align="center"><%=rs("Phone")%></div></td>
            		<td align=right class=wenbenkuang><div align="center"><%=rs("Email")%></div></td>
            		<td align=right class=wenbenkuang><div align="center"><%=rs("OverPass")%></div></td>
            		<td align=right valign="middle" class=wenbenkuang><div align="center">
						<a href="#" onclick="window.open('manage/Member/show.asp?id=<%=rs("ID")%>','','width=580,height=380,toolbar=no,location=no,status=no,menubar=no,scrollbars=yes')">
							<img src="../../images/manage.gif" width="50" height="19" border="0">
						</a>
				  </div></td>
          		</tr>
		  		</form> 
<% 
   	rs.movenext()
   	wend 
%>
          		<tr >
            		<td  height="19" colspan="6" align=right class=wenbenkuang><div 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 %>	
					</div></td>
          		</tr>
<%else %>
				<tr>
					<td align="center" colspan="6"><%=str%></td>
				</tr>		 
<%end if %>		  
		  </table>
	  </td>
  	</tr>
</table>