admin_select.asp

来自「旅游管理系统 用ASP+SQL 2」· ASP 代码 · 共 127 行

ASP
127 行
字号 
<html>
<head>
<meta name=vs_targetSchema content="HTML 4.0">
<title>按特定条件查询客户及其预订资料</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css/css1.css" type="text/css">
<script id=clientEventHandlersVBS language=vbscript>
<!--
Sub ssss_onclick
  if form1.text.value="" then
  window.alert ("请输入要查找的内容！")
  form1.text.focus
  else
  form1.submit
  end if
End Sub

-->
</script>
</head>
<body bgcolor="#FFFFFF" style="background-color: #999999" text="#000000" topmargin="5">
<!--#include file="includefile/shoubu.asp" -->
<!--#include file="includefile/conn.asp" -->
<%
if session("administrator")<>"administrator" then
Response.Redirect "admin_login.asp"
end if
dim action,text,tttt,lxs
action=request("action")
text=request("text")
tttt=request("radiobutton")
%>
<br>
<form name="form1" method="post" action="admin_select.asp?action=select">
  <table width="543" border="0" cellspacing="1" cellpadding="0" align="center" bgcolor="#CCCCCC">
    <tr> 
      <td height="27" bgcolor="#EFEFEF" align="center">输入内容： 
        <input type="text" name="text" size="50" class="input">
        <input type="button" name="ssss" value="查找" class="button">
      </td>
    </tr>
  </table>
  <br>
  <table width="755" border="0" cellspacing="1" cellpadding="0" align="center" bgcolor="#CCCCCC">
    <tr> 
      <td height="22" bgcolor="#EFEFEF" width="99"> 
        <input type="radio" name="radiobutton" value="m_name" checked>
        客户名称</td>
      <td height="22" bgcolor="#EFEFEF" width="99"> 
        <input type="radio" name="radiobutton" value="m_address">
        客户地址</td>
      <td height="22" bgcolor="#EFEFEF" width="87"> 
        <input type="radio" name="radiobutton" value="m_email">
        电子邮件</td>
      <td height="22" bgcolor="#EFEFEF" width="78"> 
        <input type="radio" name="radiobutton" value="m_oicq">
        OICQ</td>
      <td height="22" bgcolor="#EFEFEF" width="66"> 
        <input type="radio" name="radiobutton" value="m_age">
        年龄</td>
      <td height="22" bgcolor="#EFEFEF" width="66"> 
        <input type="radio" name="radiobutton" value="m_phone">
        电话</td>
      <td height="22" bgcolor="#EFEFEF" width="82"> 
        <input type="radio" name="radiobutton" value="m_zhengjian">
        身份证</td>
      <td height="22" bgcolor="#EFEFEF" width="66"> 
        <input type="radio" name="radiobutton" value="m_youbian">
        邮编</td>
      <td height="22" bgcolor="#EFEFEF" width="102"> 
        <input type="radio" name="radiobutton" value="m_renshuo">
        旅游人数</td>
    </tr>
  </table>
</form>
<%if action="select" then%>
<%
lxs=session("longname")
if lxs="系统管理员" then 
  sql="select * from giveme where "&tttt&" like '%"&text&"%'"
else
   sql="select * from giveme where m_lxs='"&lxs& "' and "&tttt&" like '%"&text&"%'"
end if
rs.open sql,,1,1
%>
<br>
<table width="755" border="0" cellspacing="1" cellpadding="0" align="center" bgcolor="#CCCCCC">
  <tr> 
    <td height="25" width="38" bgcolor="#EFEFEF" align="center">线路ID</td>
    <td height="25" width="375" bgcolor="#EFEFEF" align="center">线路名称</td>
    <td height="25" width="73" bgcolor="#EFEFEF" align="center">客户名称</td>
    <td height="25" width="122" bgcolor="#EFEFEF" align="center">联系电话</td>
    <td height="25" width="71" bgcolor="#EFEFEF" align="center">OICQ</td>
    <td height="25" width="29" bgcolor="#EFEFEF" align="center">状态</td>
    <td height="25" width="39" align="center" bgcolor="#EFEFEF">人数</td>
  </tr>
  <tr> 
    <%
	while not Rs.eof
%>
    <td height="20" width="38" bgcolor="#FFFFFF" align="center"><%=rs("m_id")%></td>
    <td height="20" width="375"  bgcolor="#FFFFFF"><a href ="admin_seenew_all.asp?id=<%=rs("id")%>" target="_blank" title="点击这里查看此客户预订的祥细情况">　<%=rs("m_xianlu_name")%></a></td>
    <td height="20" width="73" bgcolor="#FFFFFF" align="center"><%=rs("m_name")%></td>
    <td height="20" width="122" bgcolor="#FFFFFF" align="center"><%=rs("m_phone")%></td>
    <td height="20" width="71" bgcolor="#FFFFFF" align="center"><%=rs("m_oicq")%></td>
    <td height="20" width="29" bgcolor="#FFFFFF" align="center">
      <%if rs("m_show")="1" then%>
      <font color ="#ff0000">新</font>
      <%else%>
      旧
      <%end if%>
    </td>
    <td height="20" width="39" align="center" bgcolor="#FFFFFF"><%=rs("m_renshuo")%></td>
  </tr>
  <%
Rs.MoveNext
		wend
		rs.close
conn.close
%>
</table>
<%end if
%>
<br>
<!--#include file="includefile/weibu.asp" -->
</body>
</html>

admin_select.asp - 源码说明

本页面展示了「旅游管理系统 用ASP+SQL 2」中的 admin_select.asp 源码文件，采用 ASP 编程语言编写，共 127 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与ASP相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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