local.asp

中国创网同学录1.02

             selected2=""
             if areaid=rs("areaid") then
                selected2="selected"
             end if
              %>
                            <option <%=selected2%> value="<%=rs("areaid")%>"><%=rs("areaname")%></option>
                            <%
               rs.movenext
               wend
               rs.close
              %>
                          </select>
                          <font color="#000000"> &nbsp;&nbsp; </font> </td>
                      </tr>
                    </table>
                    <br>
                    <%
            if Request("Page")<>"" then
               Page = CLng(Request("Page"))
            end if
            If Page < 1 Then
                Page = 1
            end if
            PageSize=20
            sql="select count(*) as a from schoolinfo where schoolid like '"&provinceid&"%' "&temp
            rs.open SQL,schooldb,1,3
            count=rs("a")
            PageCount=CInt(rs("a")/PageSize+0.5)
        rs.Close
       %>
                    <table width="555" border="0" cellspacing="0" cellpadding="0">
                      <form name="form1" method="post" action="local.asp">
                        <tr> 
                          <td height="20" class="topic" width="80">&nbsp;<font color="#000000">学校名称</font></td>
                          <td height="26" class="topic" width="430" align="right" valign="top"> 
                            <font color="#000000">共<%=pagecount%>页 | </font> <a href="local.asp?page=1&provinceid=<%=provinceid%>&schooltypeid=<%=schooltypeid%>&areaid=<%=areaid%>"> 
                            <font color="#000000">第一页</font></a><font color="#000000"> 
                            | </font> <a href="local.asp?page=<%=page-1%>&provinceid=<%=provinceid%>&schooltypeid=<%=schooltypeid%>&areaid=<%=areaid%>"> 
                            <font color="#000000">上一页</font></a><font color="#000000"> 
                            | </font> <a href="local.asp?page=<%=page+1%>&provinceid=<%=provinceid%>&schooltypeid=<%=schooltypeid%>&areaid=<%=areaid%>"> 
                            <font color="#000000">下一页</font></a><font color="#000000"> 
                            | </font> <a href="local.asp?page=<%=pagecount%>&provinceid=<%=provinceid%>&schooltypeid=<%=schooltypeid%>&areaid=<%=areaid%>"> 
                            <font color="#000000">末页</font></a><font color="#000000"> 
                            | 到 </font> 
                            <input type="text" name="page2" size="2">
                            <font color="#000000"> 页 </font> 
                            <input type="hidden" name="provinceid2" value=<%=provinceid%>>
                            <input type="hidden" name="areaid2" value=<%=areaid%>>
                            <input type="hidden" name="schooltypeid22" value=<%=schooltypeid%>>
                            <input type="submit" name="Submit22" value="GO">
                            <font color="#000000"> </font> </td>
                        </tr>
                        <tr> 
                          <td bgcolor="#B4C7D4" height="1" colspan="2"></td>
                        </tr>
                      </form>
                    </table>
                    <br>
                    <table width="555" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <td class="topic"> 
                          <%
            if page=1 then
           SQL="select top 20 * from schoolinfo where schoolid like '"&provinceid&"%' "&temp&" order by schoolid  "
         else
            SQL="select top 20 * from schoolinfo where schoolid like '"&provinceid&"%' "&temp&" and schoolid not in (Select top "&Cstr(PageSize*(page-1))&" schoolid from schoolinfo where schoolid like '"&provinceid&"%' "&temp&" order by schoolid  ) order by schoolid"
            end if

            rs.open SQL,schooldb
            while not rs.eof
            sql1="select count(*) as classcount from classinfo where schoolid='"&rs("schoolid")&"'"
            rss.open SQL1,schooldb,1,3
            classcount=rss("classcount")
            rss.close
          %>
                          <font color="#000000"> </font> &nbsp;<a href="classlist.asp?schoolid=<%=rs("schoolid")%>"><%=rs("schoolname")%><font color="#000000">(已有<%=classcount%>个班)</font></a><font color="#000000"><br>
                          <%rs.movenext
           wend
           rs.close
         %>
                          </font> </td>
                      </tr>
                    </table>
                    <br>
                    <table width="555" border="0" cellspacing="0" cellpadding="0">
                      <form name="form1" method="post" action="local.asp">
                        <tr> 
                          <td bgcolor="#B4C7D4" height="1" colspan="2"></td>
                        </tr>
                        <tr> 
                          <td height="20" class="topic" width="80"></td>
                          <td height="26" class="topic" width="430" align="right" valign="bottom"> 
                            <font color="#000000">共<%=pagecount%>页 | </font> <a href="local.asp?page=1&provinceid=<%=provinceid%>&schooltypeid=<%=schooltypeid%>&areaid=<%=areaid%>"> 
                            <font color="#000000">第一页</font></a><font color="#000000"> 
                            | </font> <a href="local.asp?page=<%=page-1%>&provinceid=<%=provinceid%>&schooltypeid=<%=schooltypeid%>&areaid=<%=areaid%>"> 
                            <font color="#000000">上一页</font></a><font color="#000000"> 
                            | </font> <a href="local.asp?page=<%=page+1%>&provinceid=<%=provinceid%>&schooltypeid=<%=schooltypeid%>&areaid=<%=areaid%>"> 
                            <font color="#000000">下一页</font></a><font color="#000000"> 
                            | </font> <a href="local.asp?page=<%=pagecount%>&provinceid=<%=provinceid%>&schooltypeid=<%=schooltypeid%>&areaid=<%=areaid%>"> 
                            <font color="#000000">末页</font></a><font color="#000000"> 
                            | 到 </font> 
                            <input type="text" name="page2" size="2">
                            <font color="#000000"> 页 </font> 
                            <input type="hidden" name="provinceid2" value=<%=provinceid%>>
                            <input type="hidden" name="areaid2" value=<%=areaid%>>
                            <input type="hidden" name="schooltypeid22" value=<%=schooltypeid%>>
                            <input type="submit" name="Submit22" value="GO">
                            <font color="#000000"> </font> </td>
                        </tr>
                      </form>
                    </table>
                    <br>
                    <br>
                    <br>
                  </td>
                </tr>
              </table>
            </center>
          </div>
</td>
        <td><img src="spacer.gif" width="1" height="23" border="0"></td>
      </tr>
      <tr> 
        <td><img src="spacer.gif" width="1" height="402" border="0"></td>
      </tr>
      <tr> 
        <td colspan="5"> 
          <table width="100%" border="1" cellspacing="0" cellpadding="0" height="63">
            <tr> 
              
            <td bgcolor="EAFBFF" bordercolor="EAFBFF"> <font color="#006699">如果您确认校友录中不存在您的学校，请直接点击<a href="find_class1.asp">创建学校</a><br>
                提示：学校重复建设将会给您的校友使用校友录带来不便！ </font></td>
            </tr>
          </table>
        </td>
        <td><img src="spacer.gif" width="1" height="71" border="0"></td>
      </tr>
      <tr> 
        <td colspan="5">&nbsp;</td>
        <td><img src="spacer.gif" width="1" height="28" border="0"></td>
      </tr>
      <tr> 
        <td><img name="classlist_r9_c1" src="img/classlist_r9_c1.gif" width="7" height="7" border="0"></td>
        <td><img name="classlist_r9_c2" src="img/classlist_r9_c2.gif" width="121" height="7" border="0"></td>
        <td><img name="classlist_r9_c3" src="img/classlist_r9_c3.gif" width="5" height="7" border="0"></td>
        <td colspan="2"><img name="classlist_r9_c4" src="img/classlist_r9_c4.gif" width="24" height="7" border="0"></td>
        <td colspan="5"><img name="classlist_r9_c6" src="img/classlist_r9_c6.gif" width="568" height="7" border="0"></td>
        <td><img name="classlist_r9_c11" src="img/classlist_r9_c11.gif" width="28" height="7" border="0"></td>
        <td><img src="spacer.gif" width="1" height="7" border="0"></td>
      </tr>
    </table>
    <br>
    <CENTER>
    
  </center>
</div>
<p></p>
<!--#include file=end.htm--></body>
</html>