📄 usergroupset.asp
字号:
<% Option Explicit %>
<!--#include file="../../../Inc/NosqlHack.asp" -->
<!--#include file="../../../Inc/Const.asp" -->
<!--#include file="../../../Inc/Cls_DB.asp" -->
<%
'==============================================================================
'软件名称:风讯网站信息管理系统
'当前版本:Foosun Content Manager System(FoosunCMS V3.2SP1)
'最新更新:2006.50
'==============================================================================
'Copyright (C) 2002-2004 Foosun.Net All rights reserved.
'商业注册联系:028-85098980-601,项目开发:028-85098980-606、609,客户支持:608
'产品咨询QQ:394226379,159410,125114015
'技术支持QQ:315485710,66252421
'项目开发QQ:415637671,655071
'程序开发:四川风讯科技发展有限公司(Foosun Inc.)
'Email:service@Foosun.cn
'MSN:skoolls@hotmail.com
'论坛支持:风讯在线论坛(http://bbs.foosun.net)
'官方网站:www.Foosun.cn 演示站点:test.cooin.com
'网站通系列(智能快速建站系列):www.ewebs.cn
'==============================================================================
'免费版本请在程序首页保留版权信息,并做上本站LOGO友情连接
'风讯公司保留此程序的法律追究权利
'如需进行2次开发,必须经过风讯公司书面允许。否则将追究法律责任
'==============================================================================
Dim DBC,Conn,UserConn
Set DBC = New DataBaseClass
Set Conn = DBC.OpenConnection()
DBC.ConnStr = "DBQ=" + Server.MapPath(UserDBConnectStr) + ";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
Set UserConn = DBC.OpenConnection()
Set DBC = Nothing
%>
<!--#include file="../../../Inc/Session.asp" -->
<!--#include file="../../../Inc/CheckPopedom.asp" -->
<%
if Not JudgePopedomTF(Session("Name"),"P040404") then Call ReturnError()
Dim UGSetObj,UserIDP
UserIDP = Request("ID")
Set UGSetObj = UserConn.Execute("Select GroupID from FS_Members where ID="&Clng(UserIDP)&"")
If UGSetObj.eof then
Response.Write("<script>alert(""参数传递错误"");window.close();</script>")
Response.End
End If
%>
<html>
<head>
<link href="../../../CSS/ModeWindow.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>设置会员组</title>
</head>
<body leftmargin="0" topmargin="0">
<form action="" method="post" name="UGDellForm">
<table width="100%" border="0" cellspacing="5" cellpadding="0">
<tr>
<td width="9%"> </td>
<td width="14%"> </td>
<td width="77%"> </td>
</tr>
<tr>
<td> </td>
<td>会员组</td>
<td>
<select name="GroupID" style="width:90%">
<option value="0" <%If UGSetObj("GroupID")="0" or UGSetObj("GroupID")="" then Response.Write("selected") end if%>> </option>
<%
Dim ChooseGroupObj
Set ChooseGroupObj = UserConn.Execute("Select Name,GroupID from FS_MemGroup order by AddTime desc")
do while not ChooseGroupObj.eof
%>
<option value="<%=ChooseGroupObj("GroupID")%>" <%If Cstr(UGSetObj("GroupID")) = Cstr(ChooseGroupObj("GroupID")) then Response.Write("selected") end if%>><%=ChooseGroupObj("Name")%></option>
<%
ChooseGroupObj.MoveNext
Loop
ChooseGroupObj.Close
Set ChooseGroupObj = Nothing
%>
</select></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="3"><div align="center">
<input type="submit" name="Submit" value=" 确 定 ">
<input name="action" type="hidden" id="action" value="trues">
<input type="button" name="Submit2" value=" 取 消 " onClick="window.close();">
</div></td>
</tr>
</table>
</form>
</body>
</html>
<%
If Request.Form("action") = "trues" then
UserConn.Execute("Update FS_Members set GroupID='"&Cstr(Request.Form("GroupID"))&"' where ID="&UserIDP&"")
Set Conn = Nothing
'2006-4-27
Response.Write("<script>alert('设置组成功!');window.close();</script>")
'=====================
Response.End
End If
Conn.Close
Set Conn = Nothing
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -