?? memedit.asp
字號:
?<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
'┌┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┐
'┊ ┊
'┊ 互連在線企業(yè)網(wǎng)站管理系統(tǒng)（W2006） ┊
'┊ ┊
' 版權(quán)所有 csys.com.cn
'
' 程序制作 互連在線工作室
'
' 相關(guān)網(wǎng)址 [產(chǎn)品介紹]http://www.csys.com.cn
'
' 演示網(wǎng)址 http://www.webchina.com.cn
'┊ ┊
'└┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┄┘
%>
<% Option Explicit %>
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8" />
<META NAME="copyright" CONTENT="Copyright 2004-2008 - csys.com.cn-STUDIO" />
<META NAME="Author" CONTENT="互連在線網(wǎng)絡(luò)技術(shù)工作室,www.csys.com.cn" />
<META NAME="Keywords" CONTENT="" />
<META NAME="Description" CONTENT="" />
<TITLE>編輯會(huì)員</TITLE>
<link rel="stylesheet" href="Images/CssAdmin.css">
<script language="javascript" src="../Script/Admin.js"></script>
</HEAD>
<!--#include file="../Include/Const.asp" -->
<!--#include file="../Include/ConnSiteData.asp" -->
<!--#include file="../Include/Md5.asp"-->
<!--#include file="CheckAdmin.asp"-->
<%
if Instr(session("AdminPurview"),"|103,")=0 then
response.write ("<font color='red')>你不具有該管理模塊的操作權(quán)限，請返回！</font>")
response.end
end if
'========判斷是否具有管理權(quán)限
%>
<BODY>
<%
dim Result
Result=request.QueryString("Result")
dim ID,MemName,RealName,Password,vPassword,Sex,GroupID,GroupName,GroupIdName
dim Company,Address,ZipCode,Telephone,Fax,Mobile,Email,Homepage,Working
ID=request.QueryString("ID")
call MemEdit()
%>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#6298E1">
<tr>
<td height="24" nowrap><font color="#FFFFFF"><img src="Images/Explain.gif" width="18" height="18" border="0" align="absmiddle"> <strong>網(wǎng)站會(huì)員：添加，修改會(huì)員信息</strong></font></td>
</tr>
<tr>
<td height="24" align="center" nowrap bgcolor="#EBF2F9"><a href="MemEdit.asp?Result=Add" onClick='changeAdminFlag("添加新會(huì)員")'>添加新會(huì)員</a><font color="#0000FF"> | </font><a href="MemList.asp" onClick='changeAdminFlag("查看所有會(huì)員")'>查看所有會(huì)員</a></td>
</tr>
</table>
<br>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#6298E1">
<form name="editMemForm" method="post" action="MemEdit.asp?Action=SaveEdit&Result=<%=Result%>&ID=<%=ID%>" onSubmit="return CheckMemEdit()">
<tr>
<td height="24" nowrap bgcolor="#EBF2F9"><table width="100%" border="0" cellpadding="0" cellspacing="0" id=editProduct idth="100%">
<tr>
<td width="160" height="20" align="right"> </td>
<td> </td>
</tr>
<tr>
<td height="20" align="right">登 錄 名：</td>
<td><input name="MemName" type="text" class="textfield" id="MemName" style="WIDTH: 120;" value="<%=MemName%>" maxlength="16" <%if Result="Modify" then response.write ("readonly")%>> * 3-16位字符，不可修改</td>
</tr>
<tr>
<td height="20" align="right">真實(shí)姓名：</td>
<td><input name="RealName" type="text" class="textfield" id="RealName" style="WIDTH: 120;" value="<%=RealName%>" maxlength="16"></td>
</tr>
<tr>
<td height="20" align="right">密 碼：</td>
<td><input name="Password" type="password" class="textfield" id="Password" maxlength="20" style="WIDTH: 120;"> * 6-16位字符，不填表未修改密碼</td>
</tr>
<tr>
<td height="20" align="right">確認(rèn)密碼：</td>
<td><input name="vPassword" type="password" class="textfield" id="vPassword" maxlength="20" style="WIDTH: 120;"> *</td>
</tr>
<tr>
<td height="20" align="right">性 別：</td>
<td><input type="radio" name="sex" value="先生" <%if Sex="先生" then response.write ("checked")%>> 先生 <input type="radio" name="sex" value="女士" <%if Sex="女士" then response.write ("checked")%>> 女士</td>
</tr>
<tr>
<td height="20" align="right">會(huì)員組別：</td>
<td>
<select name="GroupID" class="textfield"><% call SelectGroup() %>
</select></td>
</tr>
<tr>
<td height="20" align="right">單位名稱：</td>
<td><input name="Company" type="text" class="textfield" id="Company" style="WIDTH: 240;" value="<%=Company%>" maxlength="100"></td>
</tr>
<tr>
<td height="20" align="right">地 址：</td>
<td><input name="Address" type="text" class="textfield" id="Address" style="WIDTH: 240;" value="<%=Address%>" maxlength="100"></td>
</tr>
<tr>
<td height="20" align="right">郵 編：</td>
<td><input name="ZipCode" type="text" class="textfield" id="ZipCode" style="WIDTH: 120;" value="<%=ZipCode%>" maxlength="16"></td>
</tr>
<tr>
<td height="20" align="right">電 話：</td>
<td><input name="Telephone" type="text" class="textfield" id="Telephone" style="WIDTH: 240;" value="<%=Telephone%>" maxlength="50"></td>
</tr>
<tr>
<td height="20" align="right">傳 真：</td>
<td><input name="Fax" type="text" class="textfield" id="Fax" style="WIDTH: 120;" value="<%=Fax%>" maxlength="16"></td>
</tr>
<tr>
<td height="20" align="right">移動(dòng)電話：</td>
<td><input name="Mobile" type="text" class="textfield" id="Mobile" style="WIDTH: 120;" value="<%=Mobile%>" maxlength="16"></td>
</tr>
<tr>
<td height="20" align="right">電子郵箱：</td>
<td><input name="Email" type="text" class="textfield" id="Email" style="WIDTH: 240;" value="<%=Email%>" maxlength="50"></td>
</tr>
<tr>
<td height="20" align="right">網(wǎng) 址：</td>
<td><input name="HomePage" type="text" class="textfield" id="HomePage" style="WIDTH: 240;" value="<%=HomePage%>" maxlength="50"></td>
</tr>
<tr>
<td height="20" align="right">生 效：</td>
<td><input name="Working" type="checkbox" value="1" style="HEIGHT: 13px;WIDTH: 13px;" <%if Working then response.write ("checked")%>></td>
</tr>
<tr>
<td height="30" align="right"> </td>
<td valign="bottom"><input name="submitSaveEdit" type="submit" class="button" id="submitSaveEdit" value="保存" style="WIDTH: 80;" ></td>
</tr>
<tr>
<td height="20" align="right"> </td>
<td valign="bottom"> </td>
</tr>
</table></td>
</tr>
</form>
</table>
</BODY>
</HTML>
<%
sub MemEdit()
dim Action,rsRepeat,rs,sql
Action=request.QueryString("Action")
if Action="SaveEdit" then '保存編輯管理員信息
set rs = server.createobject("adodb.recordset")
if Result="Add" then '創(chuàng)建網(wǎng)站管理員
set rsRepeat = conn.execute("select MemName from Csys_Members where MemName='" & trim(Request.Form("MemName")) & "'")
if not (rsRepeat.bof and rsRepeat.eof) then '判斷此管理員名是否存在
response.write "<script language=javascript> alert('" & trim(Request.Form("MemName")) & "此會(huì)員名已經(jīng)存在，請換一個(gè)登錄名再試試！');history.back(-1);</script>"
response.end
end if
sql="select * from Csys_Members"
rs.open sql,conn,1,3
rs.addnew
rs("MemName")=trim(Request.Form("MemName"))
rs("RealName")=StrReplace(trim(Request.Form("RealName")))
if len(trim(Request.Form("Password")))<6 or len(trim(Request.Form("Password")))>16 then
response.write "<script language=javascript> alert('會(huì)員密碼必填，且字符數(shù)為6-16位！');history.back(-1);</script>"
response.end
end if
if Request.Form("Password")<>Request.Form("vPassword") then
response.write "<script language=javascript> alert('兩次輸入的密碼不一樣！');history.back(-1);</script>"
response.end
end if
rs("Password")=Md5(Request.Form("Password"))
rs("Sex")=Request.Form("Sex")
GroupIdName=split(Request.Form("GroupID"),"┎╂┚")
rs("GroupID")=GroupIdName(0)
rs("GroupName")=GroupIdName(1)
rs("Company")=StrReplace(trim(Request.Form("Company")))
rs("Address")=StrReplace(trim(Request.Form("Address")))
rs("ZipCode")=StrReplace(trim(Request.Form("ZipCode")))
rs("Telephone")=StrReplace(trim(Request.Form("Telephone")))
rs("Fax")=StrReplace(trim(Request.Form("Fax")))
rs("Mobile")=StrReplace(trim(Request.Form("Mobile")))
rs("Email")=trim(Request.Form("Email"))
rs("HomePage")=StrReplace(trim(Request.Form("HomePage")))
if Request.Form("Working")=1 then
rs("Working")=Request.Form("Working")
else
rs("Working")=0
end if
rs("AddTime")=now()
end if
if Result="Modify" then '修改網(wǎng)站管理員
sql="select * from Csys_Members where ID="&ID
rs.open sql,conn,1,3
rs("MemName")=trim(Request.Form("MemName"))
rs("RealName")=StrReplace(trim(Request.Form("RealName")))
if trim(Request.Form("Password"))<>"" then
if len(trim(Request.Form("Password")))<6 or len(trim(Request.Form("Password")))>16 then
response.write "<script language=javascript> alert('會(huì)員密碼必填，且字符數(shù)為6-16位！');history.back(-1);</script>"
response.end
end if
if Request.Form("Password")<>Request.Form("vPassword") then
response.write "<script language=javascript> alert('兩次輸入的密碼不一樣！');history.back(-1);</script>"
response.end
end if
rs("Password")=Md5(Request.Form("Password"))
end if
rs("Sex")=Request.Form("Sex")
GroupIdName=split(Request.Form("GroupID"),"┎╂┚")
rs("GroupID")=GroupIdName(0)
rs("GroupName")=GroupIdName(1)
rs("Company")=StrReplace(trim(Request.Form("Company")))
rs("Address")=StrReplace(trim(Request.Form("Address")))
rs("ZipCode")=StrReplace(trim(Request.Form("ZipCode")))
rs("Telephone")=StrReplace(trim(Request.Form("Telephone")))
rs("Fax")=StrReplace(trim(Request.Form("Fax")))
rs("Mobile")=StrReplace(trim(Request.Form("Mobile")))
rs("Email")=StrReplace(trim(Request.Form("Email")))
rs("HomePage")=StrReplace(trim(Request.Form("HomePage")))
if Request.Form("Working")=1 then
rs("Working")=Request.Form("Working")
else
rs("Working")=0
end if
end if
rs.update
rs.close
set rs=nothing
response.write "<script language=javascript> alert('成功編輯網(wǎng)站會(huì)員！');changeAdminFlag('所有會(huì)員');location.replace('MemList.asp');</script>"
else '提取管理員信息
if Result="Modify" then
set rs = server.createobject("adodb.recordset")
sql="select * from Csys_Members where ID="& ID
rs.open sql,conn,1,1
MemName=rs("MemName")
RealName=rs("RealName")
Sex=rs("Sex")
GroupID=rs("GroupID")
GroupName=rs("GroupName")
Company=rs("Company")
Address=rs("Address")
ZipCode=rs("ZipCode")
Telephone=rs("Telephone")
Fax=rs("Fax")
Mobile=rs("Mobile")
Email=rs("Email")
Homepage=rs("Homepage")
Working=rs("Working")
rs.close
set rs=nothing
end if
end if
end sub
%>
<%
sub SelectGroup()
dim rs,sql
set rs = server.createobject("adodb.recordset")
sql="select GroupID,GroupName from Csys_MemGroup"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
response.write("未設(shè)組別")
end if
while not rs.eof
response.write("<option value='"&rs("GroupID")&"┎╂┚"&rs("GroupName")&"'")
if GroupID=rs("GroupID") then response.write ("selected")
response.write(">"&rs("GroupName")&"</option>")
rs.movenext
wend
rs.close
set rs=nothing
end sub
%>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -