member_del.asp
来自「房地产管理系统 vb写的,很不错!!!!!!!!!!!」· ASP 代码 · 共 274 行
ASP
274 行
<!--#include file="../inc/conn.asp"-->
<%
'┌─ 风云ASP在线 ────────────────────────┐
'│ │
'│ 作者：赵振波. http://www.fyasp.com │
'│ │
'│ Q Q：176189168 │
'│ │
'│ Email：fy96@163.com │
'│ │
'│ 程序定做，系统开发，网站制作，提供高质量的网络产品、技术和服务！│
'│ │
'│ │
'└─────────────────── http://www.fyasp.com ──┘
%>
<%
if instr(session("manager"),"manager")=0 then
response.redirect "manage.asp"
response.end
end if
%>
<html>
<!-- DW6 -->
<head>
<title>后台管理系统</title>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../ht.css" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body bgcolor="#666666" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<!-- ImageReady Slices (index.psd) -->
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><img src="../images/ht_01.gif" width=778 height=62 usemap="#Map" border="0"></td>
</tr>
</table>
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0" background="../images/htbj.gif">
<tr>
<td valign="top" align="left" width="145" height="395">
<!--#include file="List.asp" -->
</td>
<td height="395" align="center" valign="top"> <br> <table width="621" border="0" cellspacing="0" cellpadding="0" height="98">
<tr>
<td align="center" valign="top"> <table width="606" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><img src="../images/httable_01.gif" width=606 height=17></td>
</tr>
<tr>
<td background="../images/httable_02.gif" height="15" align="center" valign="top"><br>
<font color="#FFCC00">会员信息查看、删除</font></td>
</tr>
<tr>
<td background="../images/httable_02.gif" height="268" align="center" valign="top"><form method="post" action="member_del_ok.asp" name="form1">
<div align="center">
<center>
<script language="javascript">
<!--
function openwin(url)
{
window.open(url,"_blank","height=320,width=500,resizable=no,scrollbars=yes,statue=no,toolbar=no,menubar=no,location=no,left=150,top=80");
}
//-->
</script>
<select name="kei" onChange="MM_jumpMenu('parent',this,0)">
<option selected>选择会员类别</option>
<option value="member_del.asp?stype=0">个人</option>
<option value="member_del.asp?stype=1">中介</option>
<option value="member_del.asp?stype=-1">未审中介</option>
</select>
<font color="#FF9933"><strong>当前会员类型：
<%
stype=trim(request("stype"))
if stype="" then
response.write "所有类别"
elseif stype="0" then
response.write "个人会员"
elseif stype="1" then
response.write "中介会员"
elseif stype="-1" then
response.write "未审中介会员"
end if
%>
</strong> </font><br>
<div align="center">
<center>
<table border="0" width="96%" cellspacing="1" cellpadding="0">
<tr bgcolor="#666666">
<td width="32" height="20" align="center"> </td>
<td width="49" align="center"> </td>
<td width="133" align="center"><font color="#CCCCCC">用户名</font></td>
<td width="82" align="center"><font color="#CCCCCC">联系人</font></td>
<td width="77" align="center"><font color="#CCCCCC">联系电话</font></td>
<td width="137" align="center">E-mail</td>
</tr>
<%
dim curpage
if request.querystring("curpage")="" then
curpage=1
else
curpage=request.querystring("curpage")
end if
const numperpage=15
opendataconn
set rs=server.createobject("adodb.recordset")
stype=trim(request("stype"))
skey=trim(request("skey"))
if stype="" then
sql="select * from company "
if skey<>"" then
sql=sql & " where userid like '%"&skey&"%' or name like '%"&skey&"%' or phone like '%"&skey&"%' or email like '%"&skey&"%' "
end if
sql=sql & "order by dnt desc"
else
if stype="0" then
sql="select * from company where reg_type='0' order by dnt desc"
elseif stype="1" then
sql="select * from company where reg_type='1' order by place desc,dnt desc"
elseif stype="-1" then
sql="select * from company where reg_type='1' and zj='-1' order by place desc,dnt desc"
end if
end if
rs.open sql,conn,1,1
if rs.eof then
response.write "<table><tr><td><br></br><center>现在还没有记录！</center><br></br></td></tr></table>"
response.end
end if
if not rs.eof then
rs.pagesize=numperpage
dim totalpages
totalpages=rs.pagecount
rs.absolutepage=curpage
end if
dim count
count=0
do while not rs.eof and count<numperpage
%>
<tr bgcolor="#868686">
<td width="32" align="center"> <input type="checkbox" name="id" value="<%=rs("id")%>" class="mul">
</td>
<td width="49" align="center"> <%if trim(rs("ismember"))="0" then response.write "非会员" else if trim(rs("ismember"))="1" then response.write "<font color=#FFCC00>会员</font>" end if%> </td>
<td width="133" align="center"><a href="javascript:openwin("member_list.asp?id=<%=trim(rs("id"))%>")"><%=rs("userid")%></a> </td>
<td width="82" align="center"><a href="javascript:openwin("member_list.asp?id=<%=trim(rs("id"))%>")"><%=rs("name")%></a></td>
<td width="77" align="center"><a href="javascript:openwin("member_list.asp?id=<%=trim(rs("id"))%>")"><%=rs("phone")%></a></td>
<td width="137" align="center"><a href=mailto:<%=trim(rs("email"))%>><%=trim(rs("email"))%></a></td>
</tr>
<%
rs.movenext
count=count+1
loop
rs.close
set rs=nothing
closedataconn
%>
<tr bgcolor="#868686">
<td colspan="6"> </td>
</tr>
<tr>
<td colspan="6" align="center" height="50"><br>
<input type="submit" value="删除所选会员信息" name="B1">
<input type="reset" value="全部重写" name="B2">
<div align="center">
<% if cint(curpage)<>1 then %>
<a href="member_del.asp?curpage=1&stype=<%=stype%>">首页 </a>
<% else %>
首页
<% end if %>
<% if cint(curpage)>1 then %>
<a href="member_del.asp?curpage=<%=curpage-1%>&stype=<%=stype%>">上一页 </a>
<% else %>
上一页
<% end if %>
<% if cint(curpage)<>cint(totalpages) then %>
<a href="member_del.asp?curpage=<%=curpage+1%>&stype=<%=stype%>"> 下一页
<% else %>
下一页
<% end if %>
<% if cint(curpage)<>cint(totalpages) then %>
</a><a href="member_del.asp?curpage=<%=totalpages%>&stype=<%=stype%>"> 末页
<% else %>
末页
<% end if %>
</a> 第<font color="#FFCC00"><%=curpage%></font>页/共<%=totalpages%>页
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)">
<option value="#" selected>请选择</option>
<option>
<%
k=1
do while k<=totalpages
%>
</option>
<option>
<%
k=1
do while k<=totalpages
%>
</option>
<option>
<%
k=1
do while k<=totalpages
%>
</option>
<option value="member_del.asp?curpage=<%=k%>">第<%=k%>页</option>
<option>
<%
k=k+1
loop
%>
</option>
<option>
<%
k=k+1
loop
%>
</option>
<option>
<%
k=k+1
loop
%>
</option>
</select>
</div></td>
</tr>
</table>
</center>
</div>
</center>
</div>
</form>
<form name="form2" method="post" action="member_del.asp">
<table width="79%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="36%"><input name="skey" type="text" id="skey" value="请输入要查询的关键字" onFocus="this.value='';"></td>
<td width="64%"><input type="submit" name="Submit" value="查询">
<font color="#FF9966">(只查询用户名、联系人、联系电话、E-mail)</font></td>
</tr>
</table>
</form></td>
</tr>
<tr>
<td><form method="post" action="gbook_del_ok.asp" name="form1">
<div align="center">
<center>
</center>
</div>
</form>
<img src="../images/httable_04.gif" width=606 height=19></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<!-- End ImageReady Slices -->
</body>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?