📄 search_user.asp

📁 业务管理系统业务管理系统业务管理系统业务管理系统业务管理系统业务管理系统业务管理系统
💻 ASP
字号:
<%
dim searchname
dq=request.form("dq")
searchname=request.form("search")
%>
<!--#include file="dbconn.asp"-->
<html>
<head>
<title>Untitled Document</title>
<LINK href="css/style.css" type=text/css rel=stylesheet>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<p align="center">&nbsp; </p><FORM NAME="form1" METHOD="post" ACTION="search_user.asp"> 
<DIV ALIGN="center"><FONT COLOR="#808080" STYLE="font-size: 9pt"><FONT COLOR="#000000">搜索：</FONT> 
<INPUT NAME="search" SIZE="30" STYLE="border: 1 solid #808080"> </FONT> <FONT COLOR="#808080" STYLE="font-size: 9pt"><SELECT NAME="dq"><OPTION VALUE="">全部</OPTION><OPTION VALUE="温州鹿城区">温州鹿城区</OPTION><OPTION VALUE="温州龙湾区">温州龙湾区</OPTION><OPTION VALUE="温州瓯海区">温州瓯海区</OPTION><OPTION VALUE="永嘉县">永嘉县</OPTION><OPTION VALUE="瑞安市">瑞安市</OPTION><OPTION VALUE="乐清市">乐清市</OPTION><OPTION VALUE="苍南县">苍南县</OPTION><OPTION VALUE="青田县">青田县</OPTION><OPTION VALUE="台州市">台州市</OPTION><OPTION VALUE="福鼎市">福鼎市</OPTION></SELECT></FONT><INPUT TYPE="submit" NAME="Submit" VALUE="搜索"> 
</DIV></FORM><p align="center">&nbsp;</p><p ALIGN="CENTER"> <%
set rs=server.createobject("ADODB.recordset") 
if dq="" then
sql="select * from contacts where ([企业名称] like '%"&searchname&"%' or ([经办人1] like '%"&searchname&"%') or ([经办人2] like '%"&searchname&"%'))   "
else
sql="select * from contacts where (([企业名称] like '%"&searchname&"%') or ([经办人1] like '%"&searchname&"%') or ([经办人2] like '%"&searchname&"%'))  and ([地区] like '%"&dq&"%') "
end if
rs.open sql,conn,1,1
%>共找到 <%=Rs.RecordCount%>个用户</p>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1">
  <%
dim k
k=1
%>
  <tr bgcolor="#CCCCCC"> <td width="46" height="28"> <div align="center"><b>编号</b></div></td><td width="71" height="28"> 
<div align="center"><b>地区</b></div></td><td width="257" height="28"> <div align="center"><b>企业名称</b></div></td><td width="108" height="28"> 
<div align="center"><b><font color="#000000">电话</font></b></div></td><td width="105" height="28"> 
<div align="center"><b>传真</b></div></td><td width="279" height="28"> <div align="center"><b>网址</b></div></td><td width="63" height="28"> 
<div align="center"><b>邮箱</b></div></td><td width="63" height="28"> <div align="center"><b>代收邮件</b></div></td><td width="64" height="28"> 
<div align="center"><b>经办人</b></div></td><td width="100" height="28"> <div align="center"><b>备注</b></div></td></tr> 
<%do while not rs.eof%> <tr> <td width="46" height="32"> <div align="center"><font color="#0000FF"><b><font face="Arial, Helvetica, sans-serif"><%=k%><%'=rs("id")%></font></b></font></div></td><td width="71" height="32"> 
<div align="center"><%=rs("地区")%></div></td><td width="257" height="32"> <div align="left">　<a href="list.asp?company=<%=rs("企业名称")%>"><%=rs("企业名称")%></a></div></td><td width="108" height="32"> 
<div align="center"><%=rs("电话")%></div></td><td width="105" height="32"> <div align="center"><%=rs("传真")%></div></td><td width="279" height="32"> 
<div align="left">　<%=rs("网址")%></div></td><td width="63" height="32"> <div align="center"><%=rs("邮箱")%></div></td><td width="63" height="32"> 
<div align="center"><%=rs("代收")%></div></td><td width="64" height="32"> <div align="center"><%=rs("经办人1")%>、<%=rs("经办人2")%></div></td><td width="100" height="32"> 
<div align="center"><%=rs("memo")%></div></td></tr> <% k=k+1
	rs.movenext  
	loop 
  %> <%rs.close 
    set rs=nothing
  %> </table>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -