?? user_teacher_list.asp
字號:
If (MM_rsCount = -1) Then
' walk to the end of the display range for this page
MM_index = MM_offset
While (Not MM_rs.EOF And (MM_size < 0 Or MM_index < MM_offset + MM_size))
MM_rs.MoveNext
MM_index = MM_index + 1
Wend
' if we walked off the end of the recordset, set MM_rsCount and MM_size
If (MM_rs.EOF) Then
MM_rsCount = MM_index
If (MM_size < 0 Or MM_size > MM_rsCount) Then
MM_size = MM_rsCount
End If
End If
' if we walked off the end, set the offset based on page size
If (MM_rs.EOF And Not MM_paramIsDefined) Then
If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then
If ((MM_rsCount Mod MM_size) > 0) Then
MM_offset = MM_rsCount - (MM_rsCount Mod MM_size)
Else
MM_offset = MM_rsCount - MM_size
End If
End If
End If
' reset the cursor to the beginning
If (MM_rs.CursorType > 0) Then
MM_rs.MoveFirst
Else
MM_rs.Requery
End If
' move the cursor to the selected record
MM_index = 0
While (Not MM_rs.EOF And MM_index < MM_offset)
MM_rs.MoveNext
MM_index = MM_index + 1
Wend
End If
%>
<%
' *** Move To Record: update recordset stats
' set the first and last displayed record
Recordset1_first = MM_offset + 1
Recordset1_last = MM_offset + MM_size
If (MM_rsCount <> -1) Then
If (Recordset1_first > MM_rsCount) Then
Recordset1_first = MM_rsCount
End If
If (Recordset1_last > MM_rsCount) Then
Recordset1_last = MM_rsCount
End If
End If
' set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount)
%>
<%
' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
Dim MM_keepNone
Dim MM_keepURL
Dim MM_keepForm
Dim MM_keepBoth
Dim MM_removeList
Dim MM_item
Dim MM_nextItem
' create the list of parameters which should not be maintained
MM_removeList = "&index="
If (MM_paramName <> "") Then
MM_removeList = MM_removeList & "&" & MM_paramName & "="
End If
MM_keepURL=""
MM_keepForm=""
MM_keepBoth=""
MM_keepNone=""
' add the URL parameters to the MM_keepURL string
For Each MM_item In Request.QueryString
MM_nextItem = "&" & MM_item & "="
If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item))
End If
Next
' add the Form variables to the MM_keepForm string
For Each MM_item In Request.Form
MM_nextItem = "&" & MM_item & "="
If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then
MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item))
End If
Next
' create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL & MM_keepForm
If (MM_keepBoth <> "") Then
MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1)
End If
If (MM_keepURL <> "") Then
MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1)
End If
If (MM_keepForm <> "") Then
MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)
End If
' a utility function used for adding additional parameters to these strings
Function MM_joinChar(firstItem)
If (firstItem <> "") Then
MM_joinChar = "&"
Else
MM_joinChar = ""
End If
End Function
%>
<%
' *** Move To Record: set the strings for the first, last, next, and previous links
Dim MM_keepMove
Dim MM_moveParam
Dim MM_moveFirst
Dim MM_moveLast
Dim MM_moveNext
Dim MM_movePrev
Dim MM_urlStr
Dim MM_paramList
Dim MM_paramIndex
Dim MM_nextParam
MM_keepMove = MM_keepBoth
MM_moveParam = "index"
' if the page has a repeated region, remove 'offset' from the maintained parameters
If (MM_size > 1) Then
MM_moveParam = "offset"
If (MM_keepMove <> "") Then
MM_paramList = Split(MM_keepMove, "&")
MM_keepMove = ""
For MM_paramIndex = 0 To UBound(MM_paramList)
MM_nextParam = Left(MM_paramList(MM_paramIndex), InStr(MM_paramList(MM_paramIndex),"=") - 1)
If (StrComp(MM_nextParam,MM_moveParam,1) <> 0) Then
MM_keepMove = MM_keepMove & "&" & MM_paramList(MM_paramIndex)
End If
Next
If (MM_keepMove <> "") Then
MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1)
End If
End If
End If
' set the strings for the move to links
If (MM_keepMove <> "") Then
MM_keepMove = Server.HTMLEncode(MM_keepMove) & "&"
End If
MM_urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "="
MM_moveFirst = MM_urlStr & "0"
MM_moveLast = MM_urlStr & "-1"
MM_moveNext = MM_urlStr & CStr(MM_offset + MM_size)
If (MM_offset - MM_size < 0) Then
MM_movePrev = MM_urlStr & "0"
Else
MM_movePrev = MM_urlStr & CStr(MM_offset - MM_size)
End If
%>
<%
' *** Redirect if userName exists
MM_flag="MM_insert"
If (CStr(Request(MM_flag)) <> "") Then
MM_dupKeyRedirect="../UserModify.asp"
MM_rsKeyConnection=MM_StudentConn_STRING
MM_dupKeyUserNameValue = CStr(Request.Form("UserName"))
MM_dupKeySQL="SELECT UserName FROM User WHERE UserName='" & MM_dupKeyUserNameValue & "'"
MM_adodbRecordset="ADODB.Recordset"
set MM_rsKey=Server.CreateObject(MM_adodbRecordset)
MM_rsKey.ActiveConnection=MM_rsKeyConnection
MM_rsKey.Source=MM_dupKeySQL
MM_rsKey.CursorType=0
MM_rsKey.CursorLocation=2
MM_rsKey.LockType=3
MM_rsKey.Open
If Not MM_rsKey.EOF Or Not MM_rsKey.BOF Then
' the userName was found - can not add the requested userName
MM_qsChar = "?"
If (InStr(1,MM_dupKeyRedirect,"?") >= 1) Then MM_qsChar = "&"
MM_dupKeyRedirect = MM_dupKeyRedirect & MM_qsChar & "UserName=" & MM_dupKeyUserNameValue
Response.Redirect(MM_dupKeyRedirect)
End If
MM_rsKey.Close
End If
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE>查看教師列表-<%=WebName%></title>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.2600.0" Name=GENERATOR>
<link href="../inc/STYLE.CSS" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
-->
</style>
<link rel="SHORTCUT ICON" href="favicon.ico"/>
<link href="<%= SysCss %>" rel="stylesheet" type="text/css">
</HEAD>
<BODY text=#000000 bgColor=#F2FBF2 leftMargin=0 topMargin=0>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="16%" valign="top"><table width="97%" border="0" align="center" cellpadding="5" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td> </td>
</tr>
<tr>
<td align="center"><a href="user_search.asp">查找用戶</a><a href="sms_index.asp"></a><a href="admin_exercise_subject_add.asp"></a><a href="admin_news_index.asp"></a></td>
</tr>
<tr>
<td align="center"><a href="user_student_list.asp">學生列表</a><a href="sms_mysend_list.asp"></a><a href="admin_exercise_subject_mylist.asp"></a><a href="admin_news_index.asp"></a></td>
</tr>
<tr>
<td align="center"><a href="user_teacher_list.asp">教師列表</a><a href="sms_write.asp"></a><a href="admin_exercise_content_add.asp"></a><a href="admin_news_add.asp"></a></td>
</tr>
<tr>
<td align="center"><a href="user_sort_list.asp"><font color="#FF0000">按類列表</font></a></td>
</tr>
<tr>
<td align="center"><a href="admin_exercise_content_mylist.asp"></a><a href="user_our_class.asp" target="_self">查看本班同學信息</a><a href="admin_news_add.asp"></a></td>
</tr>
<tr>
<td align="center"><a href="user_all_list.asp" target="_self">查看系統全部用戶</a></td>
</tr>
<tr>
<td align="center"><a href="admin_news_add.asp"></a></td>
</tr>
</table></td>
<td width="84%" align="center" valign="middle">
<TABLE width="100%" border=0 align="center" cellPadding=0 cellSpacing=0>
<TBODY>
<TR>
<TD bgcolor="#F2FBF2"><strong>教師信息登記總體報告：</strong> <br>
<table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#42df31">
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF" onmouseout="javascript:this.bgColor='#ffffff'" onMouseOver="javascript:this.bgColor='#E1FADE'" width=647>已有<span class="style1"><%=(Recordset1_total)%></span>位教師在本系統登記；其中有
<%
While ((Repeat2__numRows <> 0) AND (NOT Recordset2.EOF))
%>
<span class="style1"><a href="user_class_sort.asp?aclass=<%=(Recordset2.Fields.Item("MasterClass").Value)%>" target="_self"><%=(Recordset2.Fields.Item("MasterClass").Value)%></a></span>，
<%
Repeat2__index=Repeat2__index+1
Repeat2__numRows=Repeat2__numRows-1
Recordset2.MoveNext()
Wend
%>
共<span class="style1"><%=(Recordset2_total)%></span>個組的教師。</td>
<td bgcolor="#E1FADE" width=70> </td>
</tr>
</table>
<br>
<b>已登記的同學信息列表：</b><br>
<table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#42df31">
<tr align="center">
<td width="6%" height="20">胸卡編號</td>
<td width="11%" height="20">姓名</td>
<td width="9%">專業</td>
<td width="16%">注冊IP</td>
<td width="21%">注冊時間</td>
<td width="15%">查看詳情</td>
<td width="15%">短信</td>
<td width="8%" height="20">等級</td>
</tr>
<%
While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF))
%>
<tr align="center" bgcolor="#FFFFFF" onmouseout="javascript:this.bgColor='#ffffff'" onMouseOver="javascript:this.bgColor='#E1FADE'" width=*>
<td height="28"><%=(Recordset1.Fields.Item("studentnum").Value)%></td>
<td height="28"><%=(Recordset1.Fields.Item("studentname").Value)%></td>
<td><%=(Recordset1.Fields.Item("Specia").Value)%></td>
<td><%=(Recordset1.Fields.Item("RegIp").Value)%></td>
<td><%=(Recordset1.Fields.Item("Regdate").Value)%></td>
<td><a href="user_info_show.asp?userid=<%=(Recordset1.Fields.Item("userid").Value)%>" target="_blank">查看詳細資料</a></td>
<td><a href="sms_write.asp?SmsSubject=&userid=<%=(Recordset1.Fields.Item("userid").Value)%>">發信給他/她</a></td>
<td height="28">
<%
select case Recordset1.Fields.Item("Authority").Value
case "0"
Response.Write("<font color='red'>待審</font>")
case "1"
Response.Write("學生")
case "2"
Response.Write("鎖定")
case "5"
Response.Write("教師")
case "6"
Response.Write("管理員")
case "7"
Response.Write("系統員")
case else
Response.Write("<font color='red'>未知</font>")
end select %> </td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
Recordset1.MoveNext()
Wend
%>
</table>
<div align="center">
<table width="100%" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td height="20" align="right"><% If MM_offset <> 0 Then %>
<A HREF="<%=MM_moveFirst%>"><img src="images/First.gif" width="43" height="15" alt="首頁" border="0" align="absbottom"></A> <A HREF="<%=MM_movePrev%>"><img src="images/Prev.gif" width="56" height="15" alt="前一頁" border="0" align="absbottom"></A>
<% else %>
<img src="images/First.gif" width="43" height="15" alt="首頁" align="absbottom" border="0"> <img src="images/Prev.gif" width="56" height="15" alt="上一頁" align="absbottom" border="0">
<% End If ' end MM_offset <> 0 %>
<% If Not MM_atTotal Then %>
<A HREF="<%=MM_moveNext%>"><img src="images/Next.gif" width="56" height="15" alt="下一頁" border="0" align="absbottom"></A> <A HREF="<%=MM_moveLast%>"><img src="images/Last.gif" width="43" height="15" alt="尾頁" align="absbottom" border="0"></A>
<% else %>
<img src="images/next.gif" width="56" height="15" alt="下一頁" align="absbottom" border="0"> <img src="images/Last.gif" width="43" height="15" align="absbottom" border="0" alt="尾頁">
<% End If ' end Not MM_atTotal %></td>
</tr>
<tr>
<td><div align="right"> </div></td>
</tr>
</table>
<br>
<br>
<% If Recordset1.EOF And Recordset1.BOF Then %>
還沒有任何學生登記！
<% End If ' end Recordset1.EOF And Recordset1.BOF %>
</div></td>
<TD width=1></TD>
</TR>
<tr>
<TD height="1" colspan="7"></TD>
</tr>
</TBODY>
</TABLE></td>
</tr>
</table>
<!--#include file="inc/bot.asp" -->
</BODY>
</HTML>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
<%
Recordset2.Close()
Set Recordset2 = Nothing
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -