class_t_phonebook.asp

中国创网同学录1.02

        <tr> 
          <td><img src="../school_images/nav_02.gif" width=153 height=3></td>
        </tr>
        <tr> 
          <td><a href="javascript:PopWindowEmailMates();"><img src="../school_images/nav_zhongzhi.gif" width="153" height="22" border="0"></a></td>
        </tr>
        <tr> 
          <td><img src="../school_images/nav_02.gif" width=153 height=3></td>
        </tr>
        <tr> 
          <td><a href="javascript:personallogout();"><img src="../school_images/nav_zhuxiao.gif" width="153" height="22" border=0></a></td>
        </tr>
        <tr> 
          <td><img src="../school_images/nav_02.gif" width=153 height=3></td>
        </tr>
        <tr> 
          <td><a href="../classlogout.asp"><img src="../school_images/nav_09.gif" width=153 height=24 border=0></a></td>
        </tr>
      </table>
    </td>
    <td bgcolor="#C7E4F1" align="center" valign="top" width="22"> <br>
      <table width="22" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td height="80" background="../school_images/bg1.gif" bgcolor="#ECF5FB" align="center"><a href="class_index.asp" class=3>班级信息</a></td>
        </tr>
        <tr> 
          <td height="80" background="../school_images/bg1.gif" align="center"><a href="ClassBBSList.asp" class=3>留言簿</a></td>
        </tr>
        <tr> 
          <td height="80" background="../school_images/bg1.gif" align="center"><a href="ClassPhotoList.asp" class=3>本班相册</a></td>
        </tr>
        <tr> 
          <td height="80" background="../school_images/bg1.gif" align="center"><a href="class_phonebook.asp" class=3>通讯录</a></td>
        </tr>
        <tr> 
          <td height="80" background="../school_images/bg.gif" align="center"><a href="class_t_phonebook.asp" class=3>教师通讯录</a></td>
        </tr>
      </table>
      <br>
      <br>
    </td>
    <td bgcolor="#ECF5FB" align="center" valign="top" width="563"> <br>
      <%
            
            if Request("Page")<>"" then 
       		Page = CLng(Request("Page"))
    	    end if 
            If Page < 1 Then 
                Page = 1
            end if
            PageSize=5
            sql="select count(*) as a from userjoinclassinfo where classid ='"&curclassid&"' and userstatus='教师'"  
            rs.open SQL,schooldb,1,3
            count=rs("a")
            PageCount=CInt(rs("a")/PageSize+0.5)
	    rs.Close
       %>
      <table width="510" border="0" cellspacing="0" cellpadding="0">
          <form name="form3" method="post" action="class_phonebook.asp">
        <tr> 
          <td height="28" class="bt" width="100">教师通讯录|</td>
          <td height="28" class="topic" width="410" align="right" valign="top">共<%=pagecount%>页 
            | <a href="class_phonebook.asp?page=1">第一页</a> 
            | <a href="class_phonebook.asp?page=<%=page-1%>">上一页</a> 
            | <a href="class_phonebook.asp?page=<%=page+1%>">下一页</a> 
            | <a href="class_phonebook.asp?page=<%=pagecount%>">末页</a> | 到 
            <input type="text" name="page" size="2">
            页 
            <input type="submit" name="Submit22" value="GO">
          </td>
        </tr>
        <tr> 
          <td bgcolor="#B4C7D4" height="1" colspan="2"></td>
        </tr>
        </form>
      </table>
      <br>
      <%
            if page=1 then
	       SQL="select top 5 * from userjoinclassinfo where classid ='"&curclassid&"' and userstatus='教师' order by userid  "
 	    else
 	       SQL="select top 5 * from userjoinclassinfo where classid ='"&curclassid&"' and userstatus='教师' and userid not in (Select top "&Cstr(PageSize*(page-1))&" userid from userjoinclassinfo where classid ='"&curclassid&"' and userstatus='教师' order by userid  ) order by userid" 
            end if
            
            rs.open SQL,schooldb
            while not rs.eof 
            sql1="select * from userinfo where userid='"&rs("userid")&"'"
            rss.open SQL1,schooldb
            if not rss.eof then
               realname=rss("realname")
            end if
            rss.close   
            sql1="select * from usercommunicationinfo where userid='"&rs("userid")&"'"
            rss.open SQL1,schooldb
            if not rss.eof then
      %>      
      <table width="510" cellspacing="1" cellpadding="1" align="center">
        <tr> 
          <td colspan="2" height="20" class="topic">用户名：<%=rss("userid")%></td>
          <td height="20" class="topic">校友姓名：<%=realname%></td>
        </tr>
        <tr class="digi"> 
          <%if rss("isqqshow")=true then%>
          <td colspan="3" height="20">OICQ/ICQ号码：<%=rss("qq")%></td>
          <%else%>
          <td colspan="3" height="20">OICQ/ICQ号码：******</td>
          <%end if%>
        </tr>
        <tr class="digi"> 
          <%if rss("istelephoneshow")=true then%>
          <td width="200" height="20">固定电话：<%=rss("telephone")%></td>
          <%else%>
          <td width="200" height="20">固定电话：******</td>
          <%end if%>
          <%if rss("ismobileshow")=true then%>
          <td width="200" height="20">移动电话：<%=rss("mobile")%></td>
          <%else%>
          <td width="200" height="20">移动电话：******</td>
          <%end if%>
          <%if rss("isbpshow")=true then%>
          <td width="200" height="20">传呼：<%=rss("bp")%></td>
          <%else%>
          <td width="200" height="20">传呼：******</td>
          <%end if%>
          
        </tr>
        <tr> 
          <%if rss("iscashow")=true then%>
          <td colspan="3" height="20" class="topic">通信地址：<%=rss("communicationaddr")%></td>
          <%else%>
           <td colspan="3" height="20" class="topic">通信地址：**********</td>
          <%end if%>
        </tr>
        <tr> 
           <%if rss("ishashow")=true then%>
          <td colspan="3" height="20" class="topic">居住地址：<%=rss("homeaddr")%></td>
          <%else%>
           <td colspan="3" height="20" class="topic">居住地址：**********</td>
          <%end if%>
          
        </tr>
        <tr> 
           <%if rss("iswsshow")=true then%>
          <td colspan="3" height="20" class="topic">工作单位：<%=rss("workshop")%></td>
          <%else%>
           <td colspan="3" height="20" class="topic">工作单位：**********</td>
          <%end if%>
          
        </tr>
        <tr> 
          
          <%if rss("isemailshow")=true then%>
          <td colspan="3" height="20" class="digi">电子邮件：<a href="mailto:<%=rss("email")%>" class=4><%=rss("email")%></a></td>
          <%else%>
           <td colspan="3" height="20" class="digi">电子邮件：**********</td>
          <%end if%>
          
        </tr>
      </table>
      <hr width="510" size="1" noshade align="center">
     <%end if
       rss.close
        rs.movenext
           wend
           rs.close
         %>  
      <br>
      <table width="510" border="0" cellspacing="0" cellpadding="0" bgcolor="#C7E4F1">
        <form name="form4" method="post" action="class_phonebook.asp">
        <tr> 
          <td height="28" class="topic" width="410" align="right" valign="top">共<%=pagecount%>页 
            | <a href="class_phonebook.asp?page=1">第一页</a> 
            | <a href="class_phonebook.asp?page=<%=page-1%>">上一页</a> 
            | <a href="class_phonebook.asp?page=<%=page+1%>">下一页</a> 
            | <a href="class_phonebook.asp?page=<%=pagecount%>">末页</a> | 到 
            <input type="text" name="page" size="2">
            页 
            <input type="submit" name="Submit22" value="GO">
          </td>
        </tr>
        </form>
      </table>
      <br>
      <br>
      <br>
    </td>
  </tr>
</table>
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
          <td background="../school_images/hline.gif" height="2"></td>
        </tr>
      </table>
<br>
<br>
<table width="700" border="0" cellspacing="2" cellpadding="2" align="center">
  <tr align="center"> 
    <td height="15" class="topic"><a href="http://www.269.net/us.htm">公司简介</a> 
      | <a href="http://www.269.net/ads.htm">广告服务</a> | <a href="mailto:[e-mail]">联系方式</a> 
      | <a href="http://www.269.net/join.htm">招聘信息</a></td>
  </tr>
</table>
<table width="500" border="0" align="center" cellpadding="1" cellspacing="1">
  <tr align="center"> 
    <td height="20"><span style="FONT-SIZE: 9pt"><font face="arial">Copyright2000 
      <a
 href="http://WWW.269.net"><font face="Arial, Helvetica, sans-serif">www.269.net</font></a></font><br>
      版权所有：家园网络公司 &nbsp;&nbsp;如果有任何意见和建议,请与<a href="mailto:[e-mail]">我们联系</a>!</span> 
    </td>
  </tr>
</table>
      </body>
</html>