📄 showmailsearchcontent.asp

📁 直接解压即可都是asp源码超经典的啊
💻 ASP
字号:


<!--#include file="conn.asp"-->
<!--#include file="top.asp"-->
<% 
id=session("userid")
username=session("username")
if id="" or username="" and session("login")<>"login" then
response.Redirect("adminloginerror.asp")
end if
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from sysuser where sysuser='"& username &"' and id=" & id &""
rs.open sql,conn,3,3
if rs.eof then
response.Redirect("adminloginerror.asp")
else
%>
<html>

<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">


<body bgcolor="#FFFFFF">
<div align="center">
  <center>
<table width="90%" border="1" cellpadding="3" cellspacing="0" bordercolor="#6687BA" style="border-collapse: collapse">
  <tr>
    <td bgcolor="#EAF1FB">　</td>
  </tr>
  <tr>
    <td bordercolor="#FFFFFF"><form name="form1" method="post" action="showmailsearchcontent.asp">
        <table width="100%" border="0" align="center" cellpadding="5" cellspacing="0" bgcolor="#f1f1f1">
          <tr> 
            <td bgcolor="#EAF1FB">邮局查询： 
              <input name="mailname" type="text" id="mailname" size="15"> </td>
            <td bgcolor="#EAF1FB">按： 
              <select name="keyword" id="keyword">
                <option value="domainname">域名</option>
                <option value="member" selected>会员名</option>
                <option value="id">订单号</option>
              </select> </td>
            <td bgcolor="#EAF1FB"><input type="submit" name="Submit" value="搜索"></td>
          </tr>
        </table>
      </form>
      <% 
	  Set rs = Server.CreateObject("ADODB.Recordset")
	  if request.form("keyword")="domainname" then
sql="select * from mailshopping where domainname like '%"& request.form("mailname") &"%'"
end if
if request.form("keyword")="member" then
sql="select * from mailshopping where user_name like '%"& request.form("mailname") &"%'"
end if
if request.form("keyword")="id" then
mailname=request.form("mailname")
mailid=right(mailname,2)
sql="select * from mailshopping where id like '%"& mailid &"%'"
end if
rs.open sql,conn,3,3
if rs.eof then
response.write"<div align=center>没 有 找 到 您 要 找 的 邮 局</div>"
else
do while not rs.eof
%>
      <table width="100%" border="1" cellpadding="3" cellspacing="0" bordercolor="#6687BA" style="border-collapse: collapse">
        <% if session("admintyp")="业务管理员" then %>
        <form name="form2" method="post" action="sys_apgentisok.asp?typ=mail&id=<%=rs("id")%>">
          <% else
				response.write""
				end if
				%>
          <tr> 
            <td width="20%">订单编号：</td>
            <td class="f1"><%=rs("id")%>　</td>
          </tr>
          <tr> 
            <td>会员名称：</td>
            <td class="f1"><%=rs("user_name")%> 　</td>
          </tr>
          <tr> 
            <td>会员类型：</td>
            <td class="f1"><%=rs("usertyp")%> 　</td>
          </tr>
          <tr> 
            <td>邮局名称：</td>
            <td> <%=rs("mailname")%>　</td>
          </tr>
          <tr> 
            <td>产品编号：</td>
            <td><%=rs("mailcount")%>　</td>
          </tr>
          <tr> 
            <td>租用年限：</td>
            <td><%=rs("years")%>　</td>
          </tr>
          <tr> 
            <td>主机单价：</td>
            <td>￥ <%=rs("onemoney")%> /年</td>
          </tr>
          <tr> 
            <td>总计价格：</td>
            <td>￥ <%=rs("money")%></td>
          </tr>
          <tr> 
            <td>绑定域名：</td>
            <td><%=rs("domainname")%>　</td>
          </tr>
          <tr> 
            <td>是否已结算：</td>
            <td class="f1"><%=rs("bolo")%>　</td>
          </tr>
          <tr> 
            <td>是否已开通：</td>
            <td class="f1"><%=rs("mailaction")%>　</td>
          </tr>
          <tr> 
            <td>　</td>
            <td class="f1"><p>　</p>
              <% if session("admintyp")="业务管理员" then %>
              <input type="submit" name="Submit2" value="业务确认"> 
              <% else
				response.write""
				end if
				%>
              <p></p></td>
          </tr>
          <% if session("admintyp")="业务管理员" then %>
        </form>
        <% else
				response.write""
				end if
				%>
      </table>
      <br>
      <% rs.movenext
	        loop
			%>
    </td>
  </tr>
</table>
  </center>
</div>
</body>
</html>
<% end if %>
<% 
end if
rs.close
set rs=nothing
set conn=nothing
%>
⌨️ 快捷键说明

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