?? systemmanager.asp
字號:
<%@ Language=VBScript %>
<%
'判斷用戶是否登錄以及是否是系統管理員
if isempty(Session("ID")) or Session("IsSystemManager")=false then
Response.Redirect "../Login.asp"
end if
'連接系統數據庫
set conn = server.createobject ("adodb.connection")
conn.open "ASPData", "sa", "yourpassword"
set EmployeeInformation = conn.Execute(" select * from PSLogins order by " & Session("SystemOrder"))
'添加新用戶信息
if not IsEmpty(Request.Form("Add")) then
Response.Redirect "AddNewUser.asp"
end if
'刪除某個用戶信息
if not IsEmpty(Request.Form("Delete")) then
if not IsEmpty(Request.Form("SelectWho")) then
conn.Execute "delete from PSLogins where LoginID = '" & Request.Form("SelectWho") & "' "
TheMessage="記錄已被刪除"
set EmployeeInformation = conn.Execute(" select * from PSLogins order by Name ")
'修改某個用戶信息
else
TheMessage = "請在下面修改員工信息"
end if
'修改某個用戶信息
elseif not IsEmpty(Request.Form("Modify")) then
if not IsEmpty(Request.Form("SelectWho")) then
Session("temp")= Request.Form("SelectWho")
Response.Redirect "ModifyUserInformation.asp"
else
TheMessage = "請在下面修改員工信息"
end if
else
TheMessage = "請在下面修改員工信息"
end if
%>
<HTML>
<HEAD>
<TITLE>系統管理員頁面</TITLE>
<META NAME="Generator" CONTENT="NetObjects Fusion 2.0.2 for Windows">
</HEAD>
<BODY BGCOLOR="">
<table width=800 border=0 align=center cellpadding=2 cellspacing=1 bordercolor="#996633" bgcolor=#164DA8>
<tr bgcolor=white>
<td valign=center bgcolor="#0066CC" > <div align="center"><font color="#CCCCCC" size="7" face="華文隸書"><strong>公司內部辦公信息管理系統</strong></font></div></td>
</tr>
</table>
<table width="800" border="0" bordercolor="#164DA8" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="13"> </td>
</tr>
</table>
<font size="2"><br>
</font>
<table WIDTH=100% border=0 bgcolor=#164DA8 cellspacing=1 cellpadding=2 align=center>
<tr>
<td colspan=3><font color=white>
<P ALIGN="CENTER"><font size="2">公司內部辦公信息管理系統->員工信息查詢->系統管理員選項 [當前用戶-
<% response.write Session("Name") %>
]</font></FONT><font size="2"></font></font></td>
</tr>
<tr bgcolor=white >
<td><font size="2"><a href="../.././html/home.asp"><font color="#164DA8">返回內網主頁</font></a></font></td>
<td align=center> <font color="#164DA8" size="2" >
<% response.write TheMessage %>
</FONT></td>
<td align=right><font size="2"><a href="EmployeeInformation.asp"><font color="#164DA8">返回上一級網頁</font></a></font></td>
</tr>
</table>
<table width="100%" border="0" bordercolor="#164DA8" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="13"> </td>
</tr>
</table>
<font size="2"><br>
</font>
<FORM ACTION="SystemManager.asp" METHOD=POST>
<TABLE WIDTH=100% border=0 bgcolor=#164DA8 cellspacing=1 cellpadding=2 align=center>
<TR >
<TD COLSPAN=14 align=center><font color=white size="2">全部員工信息如下</font></TD>
</TR>
<TR VALIGN="center" ALIGN="center" bgcolor=white>
<td width=2%><font size="2">選中</font></td>
<td width=5%><font size="2">登錄名</font></td>
<td width=5%><font size="2">姓名</font></td>
<td><font size="2">電子郵件地址</font></td>
<td width=5%><font size="2">部門</font></td>
<td><font size="2">位置</font></td>
<td><font size="2">內部分機</font></td>
<td><font size="2">家庭電話</font></td>
<td><font size="2">手機</font></td>
<td><font size="2">QQ號</font></td>
<td><font size="2">家庭住址</font></td>
<td width=8%><font size="2">生日</font></td>
<td width=5%><font size="2">是否系統管理員</font></td>
<td width=5%><font size="2">是否財務主管</font></td>
</TR>
<%
Do until EmployeeInformation.Eof
Response.write "<tr bgcolor=white>" _
& "<td align=center><input type=radio name=SelectWho value=" & EmployeeInformation("LoginID") & "> </td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("LoginID") & "</font></td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("Name") & "</font></td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("EmailAddress") & "</font></td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("Department") & "</font></td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("Position") & "</font></td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("InternalPhone") & "</font></td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("HomePhone") & "</font></td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("MobilePhone") & "</font></td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("QQ") & "</font></td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("HomeAddress") & "</font></td>" _
& "<td align=left><font face=arial>"& EmployeeInformation("Birthday") & "</font></td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("IsSystemManager") & "</font></td>" _
& "<td align=center><font face=arial>"& EmployeeInformation("IsFinancialManager") & "</font></td></tr>"
EmployeeInformation.MoveNext
loop
%>
</TABLE>
<TABLE CELLPADDING=0 CELLSPACING=0 BORDER=1 WIDTH=100% align=center>
<TR VALIGN="top" ALIGN="center">
<TD WIDTH=100% align=center > <font size="2">
<INPUT TYPE="submit" NAME="Modify" VALUE="修改此用戶信息" style="border: 1px solid #3466BB; background-color: #B6CAEB; color: #3466BB">
<INPUT TYPE="submit" NAME="Delete" VALUE="刪除此用戶信息" style="border: 1px solid #3466BB; background-color: #B6CAEB; color: #3466BB">
<INPUT TYPE="submit" NAME="Add" VALUE="添加新用戶信息" style="border: 1px solid #3466BB; background-color: #B6CAEB; color: #3466BB">
</font></TD>
<font size="2"></TD></font></TR>
</table>
<font size="2"><br>
</font>
</FORM>
</body>
</html> ?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -