?? membermgr.asp
字號(hào):
<!--#Include file="../Common/Inc_DatConn.asp"-->
<!--#Include file="Common/Inc_Config.asp"-->
<!--#Include file="Common/Inc_Function.asp"-->
<%
'┌─ 風(fēng)云ASP在線 ────────────────────────┐
'│ │
'│ 作者：趙振波. http://www.fyasp.com │
'│ │
'│ Q Q：176189168 │
'│ │
'│ Email：fy96@163.com │
'│ │
'│ 程序定做，系統(tǒng)開發(fā)，網(wǎng)站制作，提供高質(zhì)量的網(wǎng)絡(luò)產(chǎn)品、技術(shù)和服務(wù)！│
'│ │
'│【版權(quán)聲明】 │
'│ │
'│ 本程序版權(quán)歸坐看風(fēng)云所有，未經(jīng)授權(quán)擅自修改、復(fù)制或散布本程序│
'│ │
'│的部分或全部，將承受嚴(yán)厲的民事和刑事處罰，對(duì)已知的違反者將給予法 │
'│ │
'│律范圍內(nèi)的全面制裁。對(duì)非法使用此程序所造成的一切后果本人概不負(fù)責(zé)!│
'│ │
'└─────────────────── http://www.fyasp.com ──┘
%>
<%if IsTimeOut(Session("strAccount"),Session("strPassWord")) then Response.Redirect "index.asp"%>
<html>
<head>
<title><% = strSiteName%> - 網(wǎng)站后臺(tái)管理系統(tǒng)</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="Common/Site.css" type="text/css">
<script language="javascript">
function Member(ID) {
popupWin = window.open('Member.asp?Id='+ ID,'','width=482,height=350,scrollbars=yes')
}
function AddCount(ID) {
popupWin = window.open('Oper.asp?Oper=AddCount&ID='+ ID,'','width=300,height=178,scrollbars=no')
}
function MemberCount(ID) {
popupWin = window.open('MemberCount.asp?Id='+ ID,'','width=600,height=330,scrollbars=yes')
}
function LockMember(ID) {
popupWin = window.open('Oper.asp?Oper=LockMember&ID='+ ID,'','width=300,height=150,scrollbars=no')
}
function UnLockMember(ID) {
popupWin = window.open('Oper.asp?Oper=UnLockMember&ID='+ ID,'','width=300,height=150,scrollbars=no')
}
function DelMember(ID) {
popupWin = window.open('Oper.asp?Oper=DelMember&ID='+ ID,'','width=300,height=150,scrollbars=no')
}
function setjb(ID) {
popupWin = window.open('Oper.asp?Oper=setjb&ID='+ ID,'','width=300,height=150,scrollbars=no')
}
</script>
</head>
<body leftMargin="0" topMargin="2">
<!--#Include file="Common/inc_Top.asp"-->
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="105" valign="top" style="border-left: 1px solid rgb(0,0,0); border-right: 1px solid rgb(0,0,0)" class="bottom"><br>
<!--#Include file="Common/Inc_Button.asp"-->
</td>
<td valign="top" style="border-right: 1px solid rgb(0,0,0)" align="center">
<table width="96%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="50">當(dāng)前位置：<a href="Main.asp">管理首頁</a> -> 會(huì)員管理</td>
</tr>
</table>
<table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="50%" height="25">
<img border="0" src="../images/dot_02.gif" width="14" height="14"><a href="?lx=1">個(gè)人會(huì)員</a>
<img border="0" src="../images/dot_01.gif" width="14" height="14"><a href="?lx=2">企業(yè)會(huì)員</a></td>
<form method="post" action="MemberMgr.asp" name="Form1">
<td width="50%" align="right">會(huì)員帳號(hào)：<input type="text" name="KeyWord" size="15" value="<% = Request("KeyWord")%>" class="face"> <input type="submit" name="Submit" value="搜" class="button"></td>
</form>
</tr>
</table>
<table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="100%" class="booktable">
<table border="0" width="100%" cellspacing="1" cellpadding="0">
<tr>
<td width="10%" height="30" class="bottom" align="center">編 號(hào)</td>
<td width="15%" height="30" class="bottom" align="center">會(huì)員帳號(hào)</td>
<td width="13%" height="30" class="bottom" align="center">會(huì)員類型</td>
<td width="10%" height="30" class="bottom" align="center">狀 態(tài)</td>
<td width="16%" height="30" class="bottom" align="center">會(huì)員級(jí)別</td>
<td width="8%" height="30" class="bottom" align="center">點(diǎn)數(shù)</td>
<td width="22%" height="30" class="bottom" align="center">操 作</td>
</tr>
<%
Dim rdsMember '/通告的數(shù)據(jù)庫對(duì)象及SQL語句/
Dim sqlMember
Dim rdsTotalRec
Dim strKeyWord '/關(guān)鍵字/
Dim intPage '/當(dāng)前頁/
Dim intTotalRec '/所有記錄/
Dim intMemberCot '/通告條數(shù)/
Dim intMemberCount '/通告條數(shù)/
Dim n,p,ii,strsql '/定義一些臨時(shí)變量/
Dim strMemberType
'Dim strMemberLevel
'Dim strOperHot
strKeyWord = Request("KeyWord")
lx = Request("lx")
intPage = Trim(Request("Page"))
if intPage = "" then
intPage = 1
else
intPage = Clng(intPage)
end if
intMemberCot = 20
strsql=""
if lx<>"" then
strsql=strsql&" and MemberType="&lx&" "
end if
if strKeyWord<>"" then
strsql=strsql&" and Member like '%"& strKeyWord &"%' "
end if
set rdsMember = Server.CreateObject("ADODB.Recordset")
if strKeyWord <> "" then
set rdsTotalRec = Conn.Execute("Select Count(MemberKey) From Dat_Member Where Member<>'' "&strsql&"")
intTotalRec = rdsTotalRec(0)
sqlMember = "Select * From Dat_Member Where Member<>'' "&strsql&" Order By MemberKey Desc"
else
set rdsTotalRec = Conn.Execute("Select Count(MemberKey) From Dat_Member Where Member<>'' "&strsql&"")
intTotalRec = rdsTotalRec(0)
sqlMember = "Select * From Dat_Member Where Member<>'' "&strsql&" Order By MemberKey Desc"
end if
rdsMember.Open sqlMember,Conn,1,1
if not rdsMember.EOF then
if intTotalRec mod intMemberCot = 0 then
n = intTotalRec \ intMemberCot
else
n = intTotalRec \ intMemberCot + 1
end if
rdsMember.MoveFirst
if intPage > n then intPage = n
if intPage < 1 then intPage = 1
rdsMember.Move (intPage - 1) * intMemberCot
do while not rdsMember.EOF and intMemberCount < Clng(intMemberCot)
intMemberCount = intMemberCount + 1
if rdsMember("State") = 0 then
strState = "開啟"
strOperState = "<a href=""javascript:LockMember("& rdsMember("MemberKey") &")""><img border=""0"" src="""& strImageUrl &"Lock.gif"" alt=""關(guān)閉"" align=""absmiddle""></a>"
else
strState = "<font color=""#FF0000"">鎖定</font>"
strOperState = "<a href=""javascript:UnLockMember("& rdsMember("MemberKey") &")""><img border=""0"" src="""& strImageUrl &"UnLock.gif"" alt=""開啟"" align=""absmiddle""></a>"
end if
'if rdsMember("Point") > 0 then
' strMemberLevel = "付費(fèi)會(huì)員"
'else
' strMemberLevel = "普通會(huì)員"
'end if
if rdsMember("MemberType") = "1" then
strMemberType = "個(gè)人會(huì)員"
else
strMemberType = "企業(yè)會(huì)員"
end if
%>
<tr>
<td height="25" align="center" class="banma1"><% = rdsMember("MemberKey")%></td>
<td height="25" align="center" class="banma2"><a href="javascript:Member(<% = rdsMember("MemberKey")%>)"><% = rdsMember("Member")%></a></td>
<td height="25" align="center" class="banma1"><% = strMemberType%></td>
<td height="25" align="center" class="banma2"><% = strState%></td>
<td height="25" align="center" class="banma1"><%
Select case rdsMember("jb")
Case 0
Response.Write("<font color=#FF00FF> 普通會(huì)員</font>")
Case 1
Response.Write("<font color=#Ff0000> 高級(jí)會(huì)員</font>")
Case -1
Response.Write("<font color=#0000ff> 申請(qǐng)高級(jí)</font>")
case else
Response.Write(" 非法會(huì)員")
End Select
%></td>
<td height="25" align="center" class="banma1"><% = rdsMember("point")%></td>
<td height="25" align="center" class="banma2"><a href="javascript:AddCount(<% = rdsMember("MemberKey")%>)"><img border="0" src="<% = strImageUrl%>/add.gif" alt="增加點(diǎn)數(shù)" align="absmiddle"></a> <a href="javascript:setjb(<% = rdsMember("MemberKey")%>)"><img border="0" src="<% = strImageUrl%>/jb.gif" alt="設(shè)置會(huì)員級(jí)別" align="absmiddle"></a> <% = strOperState%> <a href="javascript:DelMember(<% = rdsMember("MemberKey")%>)"><img border="0" src="<% = strImageUrl%>Del.gif" alt="刪除" align="absmiddle"></a></td>
</tr>
<%
rdsMember.MoveNext
loop
else
Response.Write "<tr><td width=""100%"" height=""25"" colspan=""7"" class=""banma1""> <font color=""#FF0000"">沒有會(huì)員信息...</font></td></tr>"
end if
rdsMember.Close
set rdsMember = nothing
if intPage - 1 mod 10 = 0 then
p = (intPage - 1) \ 10
else
p = (intPage - 1) \ 10
end if
%>
</table>
</td>
</tr>
</table>
<table border="0" width="96%" cellspacing="0" cellpadding="0" align="center">
<form method="post" action="MemberMgr.asp" id="form2" name="form2">
<input type="hidden" name="KeyWord" value="<% = strKeyWord%>">
<tr>
<td width="30%" height="30" valign="middle">頁次：<b><%= intPage %></b>/<b><%= n %></b>頁 每頁<b><%= intMemberCot %></b>條 共<b><%= intTotalRec %></b>條</td>
<td width="70%" height="30" valign="middle"><div align="right">分頁：
<%
if intPage = 1 then
Response.Write "<font face=webdings>9</font> "
else
Response.Write "<a href='?Page=1&KeyWord="& strKeyWord &"' title=首頁><font face=webdings>9</font></a> "
end if
if p * 10 > 0 then Response.Write "<a href='?Page="&Cstr(p*10)&"&KeyWord="& strKeyWord &"' title=上十頁><font face=webdings>7</font></a> "
Response.Write "<b>"
for ii = p * 10 + 1 to P * 10 + 10
if ii = intPage then
Response.Write "<font color=""#FF0000"">"+Cstr(ii)+"</font> "
else
Response.Write "<a href='?Page="&Cstr(ii)&"&KeyWord="& strKeyWord &"'>"+Cstr(ii)+"</a> "
end if
if ii = n then exit for
next
Response.Write "</b>"
if ii < n then Response.Write "<a href='?Page="&Cstr(ii)&"&KeyWord="& strKeyWord &"' title=下十頁><font face=webdings>8</font></a> "
if intPage=n then
Response.Write "<font face=webdings>:</font> "
else
Response.Write "<a href='?Page="&Cstr(n)&"&KeyWord="& strKeyWord &"' title=尾頁><font face=webdings>:</font></a> "
end if
%>
轉(zhuǎn)到：<input type="text" name="Page" size="2" maxlength="10" value="<%= intPage %>" class="face"> <input type="submit" value="Go" name="submit" class="button">
</div></td>
</tr>
</form>
</table>
<br>
</td>
</tr>
</table>
<!--#Include file="Common/Inc_Bottom.asp"-->
</body>
</html>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -