📄 showmember_agent.asp
字号:
<!--#include file="conn.asp"-->
<%
id=session("userid")
username=session("username")
if id="" or username="" then
response.Redirect("adminloginerror.asp")
end if
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from adminuser where username='"& username &"' and id=" & id &""
rs.open sql,conn,1,1
if rs.eof then
response.Redirect("adminloginerror.asp")
else
%>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="style.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#FFFFFF" style="background-color: #D6DFF7">
<div align="center">
<center>
<table width="98%" border="1" cellpadding="5" cellspacing="0" bordercolor="#6687BA" style="border-collapse: collapse">
<tr>
<td background="images/admin/admin_bg_1.gif">
<div align="center">
代 理 加 盟 意 向 管 理</div>
</td>
</tr>
<tr>
<td><table width="100%" border="0" cellpadding="0" bordercolor="#FFFFFF" height="20" style="border-collapse: collapse">
<tr align="center">
<td width="100%" bgcolor="#D6DFFF">
<p align="left">说明：</td>
</tr>
</table>
<div align="center">
<table width="98%" border="1" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#6687BA" height="20">
<tr>
<td width="25%"><div align="center" class="f1">申请号</div></td>
<td width="25%"><div align="center" class="f1">会员名称</div></td>
<td width="25%"><div align="center" class="f1">申请类型</div></td>
<td width="25%"><div align="center" class="f1">是否生效</div></td>
</tr>
</table>
</div>
<%
myself=request.servervariables("path_info")
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from member_agent order by id desc"
rs.open sql,conn,1,1
if rs.eof then
response.write"<div align=center>暂没有信息存在。</div>"
else
salestyp=rs("sales")
rs.Pagesize=20
page=clng(request("page"))
if page<1 or page=empty then page=1
if page>rs.pagecount then page=rs.pagecount
rs.Absolutepage=page
do while not rs.eof
%>
<div align="center">
<table width="98%" bordercolor="#FFFFFF" style="border-collapse: collapse" border="1" height="20" cellspacing="0">
<tr>
<td width="25%"><div align="center"><a href="showmemberagent.asp?id=<%=rs("id")%>">AGENT0<%=rs("id")%></a></div></td>
<td width="25%"><div align="center"><%=rs("user_name")%></div></td>
<td width="25%"><div align="center"><%=rs("sales")%></div></td>
<td width="25%"><div align="center">[<%=rs("open")%>]
<%if rs("open")="未生效" then %>
<a href="showmember_agent.asp?id=<%=rs("id")%>&cmd=del&user_name=<%=rs("user_name")%>&usertyp=<%=rs("usertyp")%>&salestyp=<%=salestyp%>">确订接纳</a></div>
<% end if %>
<%if rs("open")="已生效" then %>
<a href="showmember_agent.asp?id=<%=rs("id")%>&cmd=up&user_name=<%=rs("user_name")%>&usertyp=<%=rs("usertyp")%>&salestyp=直接客户">取消接纳</a></div>
<% end if %>
</td>
</tr>
</table>
</div>
<% i=i+1
if i>20 then exit do
rs.movenext
loop
%>
<table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<form action=<%=myself%> method=get>
<td> <%
if page<>1 then %>
<div align="center"><a href=<%=myself%>?page=1>第一页</a>
<a href=<%=myself%>?page=<%=(page-1)%>>上一页</a>
<%
end if
if page<>rs.pagecount then
%>
<a href=<%=myself%>?page=<%=(page+1)%>>下一页</a>
<a href=<%=myself%>?page=<%=rs.pagecount%>>最后一页</a>
<% end if %>
<font style="font-size:9pt"> 输入页次:</font>
<input type=text name=page22 size=3 class="border">
<font style="font-size:9pt">页次:</font><font color=red style="font-size:9pt"><%=page%>/<%=rs.pagecount%></font> 共有记录<font color=red style="font-size:9pt"><%=rs.recordcount %></font>条</div>
</td>
</form>
</tr>
</table>
<% end if %>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>
<%
Rs.close
set Rs=nothing
if request.QueryString("cmd")="del" then
reside="已生效"
sales=request.QueryString("salestyp")
user_name=request.QueryString("user_name")
usertyp=request.QueryString("usertyp")
salestyp=request.QueryString("salestyp")
'Set rs2 = Server.CreateObject("ADODB.Recordset")
'sql2="select * from savemoney where user_name='"& user_name &"'"
'rs2.open sql2,conn,3,3
'if rs2.eof then
'response.write"<br><br><div align=center class=f2>此 会 员 账 面 金 额为：<font color=#000000>￥</font><span class=f1>0 </span> 不 构 成 代 理 条 件！</div>"
'else
'money=rs2("savemoney")
'if salestyp="普通代理商" then
'needmoney=1000
'end if
'if salestyp="牵手代理商" then
'needmoney=5000
'end if
'if salestyp="伙伴代理商" then
'needmoney=20000
'end if
'if money < needmoney then
'response.write"<br><br><div align=center class=f2>此 会 员 账 面 金 额为：<font color=#000000>￥</font><span class=f1>"& money &" </span> 不 构 成 代 理 条 件！</div>"
'else
Set rs3 = Server.CreateObject("ADODB.Recordset")
sql="Select * from adminuser"
sql="select * from member_agent where id="& request.QueryString("id") &""
rs3.open sql,conn,3,3
rs3("open")=reside
rs3.update
if usertyp="个人" then
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select sales from userpersreg where login_name='"& user_name &"'"
rs.open sql,conn,3,3
rs("sales")=sales
rs.update
end if
if usertyp="企业" then
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from userentreg where login_name='"& user_name &"'"
Response.Write sql
rs.open sql,conn,3,3
rs("sales")=sales
rs.update
end if
response.Redirect("showmember_agent.asp")
end if
'end if
'end if
if request.QueryString("cmd")="up" then
reside="未生效"
sales=request.QueryString("salestyp")
user_name=request.QueryString("user_name")
usertyp=request.QueryString("usertyp")
salestyp=request.QueryString("salestyp")
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from member_agent where id="& request.QueryString("id") &""
rs.open sql,conn,1,3
rs("open")=reside
rs.update
if usertyp="个人" then
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select sales from userpersreg where login_name='"& user_name &"'"
rs.open sql,conn,3,3
rs("sales")=sales
rs.update
end if
if usertyp="企业" then
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select sales from userentreg where login_name='"& user_name &"'"
rs.open sql,conn,3,3
rs("sales")=sales
rs.update
end if
response.Redirect("showmember_agent.asp")
end if
%>
<%
end if
set rs=nothing
set conn=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -