📄 applylist.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>文章添加</title>
<link href="../images/css.css" rel="stylesheet" type="text/css">
<!--#include file="../conn.asp" -->
</head>
<body>
<div class="div1">
<table width="100%" border="0" cellspacing="1">
<tr class="tb_title">
<td colspan="8">免费网站申请列表</td>
</tr>
<tr class="tr_list1">
<td colspan="8" align="center">网站类型：
<select name="webType" id="webType">
<option value="0">选择网站类型</option>
<option value="免费型网站套餐">免费型网站套餐</option>
<option value="简约型套餐">简约型套餐</option>
<option value="经济型套餐">经济型套餐</option>
<option value="标准型套餐">标准型套餐</option>
<option value="智强型套餐">智强型套餐</option>
<option value="综合型套餐">综合型套餐</option>
<option value="行业/门户套餐">行业/门户套餐</option>
</select>
用户姓名：
<input name="proposer" type="text" id="proposer" size="10">
公司名称：
<input name="company" type="text" id="company" size="15">
<input name="Submit" onClick="location.href='ApplyList.asp?webType='+document.all.webType.options[document.all.webType.selectedIndex].value+'&proposer='+document.all.proposer.value+'&company='+document.all.proposer.value" type="submit" class="tbb" value="提交"></td>
</tr>
<tr class="tb_head">
<td width="40" align="right"> </td>
<td width="113" align="center">用户姓名</td>
<td width="113" align="center">联系电话</td>
<td width="191" align="center">用户域名</td>
<td width="117" align="center">网站类型</td>
<td width="132" align="center">公司名称</td>
<td width="133" align="center">是否查看过</td>
<td width="99" align="center">操作</td>
</tr>
<%
webType=request.QueryString("webType")
proposer=request.QueryString("proposer")
company=request.QueryString("company")
if webType<>"" and webType<>"0" then
wherestr=wherestr&" and webType = '"&webType&"'"
end if
if proposer<>"" then
wherestr=wherestr&" and proposer like '%"&proposer&"%'"
end if
if company<>"" then
wherestr=wherestr&" and company like '%"&company&"%'"
end if
sql="select * from applyWeb where 1=1 "&wherestr&" order by id desc"
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
currentPage=Request.QueryString("page")
if not isnumeric(currentPage) then
currentPage=1
end if
currentPage=cint(currentPage)
if currentPage<1 then
currentPage=1
end if
if currentPage>rs.pagecount then
currentPage=rs.pagecount
end if
PageCounts=rs.pagecount
recordCounts=Rs.RecordCount
if not rs.eof then
rs.absolutepage=currentPage
for i=1 to rs.recordcount
if rs.eof then exit for
%>
<tr class="tr_list1">
<td align="right"> </td>
<td><%=rs("proposer")%></td>
<td><%=rs("phone")%></td>
<td align="center"><%=rs("domainName")%></td>
<td><%=rs("webType")%></td>
<td><%=rs("company")%></td>
<td align="center"><%if rs("isview")=1 then%>是<%else%>否<%end if%></td>
<td align="center"><a href="applyView.asp?id=<%=rs("id")%>">查看</a> <a href="ApplyDel.asp?id=<%=rs("ID")%>">删除</a></td>
</tr>
<%
rs.movenext
next
rs.close
%>
<tr class="tr_list1">
<td colspan="8" align="right"><!--#include file="../turnpage.asp" --></td>
</tr>
<%else%>
<tr class="tr_list1">
<td colspan="8" align="center">没有检索到数据</td>
</tr>
<%end if%>
</table>
</div></body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -