<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<% 
Dim SQL,Rs
Dim JobClass,Area,PublishDate,Key,KeyClass
Dim JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time

SQL = "Select Schid,SchoolName,Properity,Locus_Area,Locus_City,ContactPerson,Phone,LastUpdate_Time From [pH_Educate_Base] Where Len(SchoolName)>0 And VipFlag<>0 Order By VipFlag Asc,LastUpdate_Time Desc"

Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.open SQL,Conn,1,1
Rs.Pagesize = 20
Psize       = Rs.PageSize
PCount      = Rs.PageCount
RCount      = Rs.RecordCount

PageNo = Cint(Request.QueryString("PageNo"))
If PageNo < 1 Then
 PageNo = 1
Elseif PageNo > PCount Then
 PageNo = PCount
End if
If Not Rs.Eof Then Rs.AbsolutePage = PageNo

 %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<script language="JavaScript" src="../js/Company_Basicinfo.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../Css/Style.css" type=text/css rel=stylesheet>
<title><%= Cls_WebName %> -- 培训机构</title>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body>
<table width="950" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td><!--#include file="../Header/Educate_User.asp" --></td>
  </tr>
</table>
<table width="950" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td align="center">
<table width="950" border="0" cellspacing="0" cellpadding="4">
        <tr> 
          <td width="50%" height="25">共<Font color="#FF0000"><%= RCount %></Font>条 分<Font color="#FF0000"><%= PCount %></Font>页 | 当前第<Font color="#FF0000"><%= PageNo %></Font>页</td>
          <td width="50%" align="right">
		  <% 
		  If PageNo > 1 Then
		   Response.write "<a href=""?PageNo=1"">首页</a>&nbsp;"
		   Response.write "<a href=""?PageNo="&PageNo-1&""">上页</a>&nbsp;"    
		  Else
		   Response.write "首页&nbsp;"
		   Response.write "上页&nbsp;" 
		  End if
		   %>
           <select name="menu1" onChange="MM_jumpMenu('parent',this,0)" style="width:40px;">
		    <% For i = 1 to PCount %>
                <option value="?PageNo=<%= i %>" <% If i = PageNo Then Response.write "Selected"%>><%=i%></option>
		    <% Next %>
           </select>
            <% 
		  If PageNo < PCount Then
		   Response.write "<a href=""?PageNo="&PageNo+1&""">下页</a>&nbsp;"
		   Response.write "<a href=""?PageNo="&PCount&""">尾页</a>"   
		  Else
		   Response.write "下页&nbsp;"
		   Response.write "尾页" 
		  End if
		   %>

		  
		  </td>
        </tr>
      </table>
      <table width="950" border="0" cellpadding="2" cellspacing="1" bgcolor="eeeeee">
        <tr> 
          <td valign="top" bgcolor="#FFFFFF">
		 
            <table width="100%" border="0" align="center" cellpadding="2" cellspacing="1">
              <tr align="center"> 
                <td width="25%" height="25" bgcolor="eeeeee">培训机构名称</td>
                <td width="14%" height="25" bgcolor="eeeeee">机构性质</td>
                <td width="10%" height="25" bgcolor="eeeeee">工作地区</td>
                <td width="9%" height="25" bgcolor="eeeeee">课程</td>
                <td width="12%" height="25" bgcolor="eeeeee">联系人</td>
                <td width="17%" height="25" bgcolor="eeeeee">联系电话</td>
                <td width="13%" bgcolor="eeeeee">加入时间</td>
              </tr>
              <% 
For i = 1 to Psize/2
 If Rs.Eof Then Exit For
 Schid               = Rs("Schid")
 SchoolName     	 = Rs("SchoolName")
 Properity			 = Rs("Properity")
 Locus_Area			 = Rs("Locus_Area")
 Locus_City			 = Rs("Locus_City")	
 ContactPerson		 = Rs("ContactPerson")
 Phone    			 = Rs("Phone")
 LastUpdate_Time     = FormatDateTime(Rs("LastUpdate_Time"),2)
 
 SchoolType = Cls_EducateType(Properity)
 '//课程数
 SudCount = 0
 Set Re = Conn.Execute("Select Count(*) From [pH_Educate_Lesson] Where Schid='"&Schid&"'")
 If Not Re.eof Then SudCount = Re(0)
 Re.Close
 %>
              <tr> 
                <td height="25"><a href="Info/Index.asp?param=<%= Schid %>" target="_blank"><u><%= SchoolName %></u></a></td>
                <td height="25" align="center"><%= SchoolType %></td>
                <td height="25" align="center"><%= Locus_Area&Locus_City %></td>
                <td height="25" align="center"><%= SudCount %></td>
                <td height="25" align="center"><%= ContactPerson %></td>
                <td height="25" align="center"><%= Phone %></td>
                <td height="25" align="center"><%= LastUpdate_Time %></td>
              </tr>
              <% 
 Rs.Movenext
 If Rs.Eof Then Exit For
 Schid               = Rs("Schid")
 SchoolName     	 = Rs("SchoolName")
 Properity			 = Rs("Properity")
 Locus_Area			 = Rs("Locus_Area")
 Locus_City			 = Rs("Locus_City")	
 ContactPerson		 = Rs("ContactPerson")
 Phone    			 = Rs("Phone")
 LastUpdate_Time     = FormatDateTime(Rs("LastUpdate_Time"),2)
 
 SchoolType = Cls_EducateType(Properity)
 '//课程数
 SudCount = 0
 Set Re = Conn.Execute("Select Count(*) From [pH_Educate_Lesson] Where Schid='"&Schid&"'")
 If Not Re.eof Then SudCount = Re(0)
 Re.Close
   %>
              <tr bgcolor="f9f9f9"> 
                <td height="25"><a href="Info/Index.asp?param=<%= Schid %>" target="_blank"><u><%= SchoolName %></u></a></td>
                <td height="25" align="center"><%= SchoolType %></td>
                <td height="25" align="center"><%= Locus_Area&Locus_City %></td>
                <td height="25" align="center"><%= SudCount %></td>
                <td height="25" align="center"><%= ContactPerson %></td>
                <td height="25" align="center"><%= Phone %></td>
                <td height="25" align="center"><%= LastUpdate_Time %></td>
              </tr>
              <%
 Rs.Movenext 
Next
 %>
            </table>
		  
			</td>
        </tr>
      </table> 
<table width="950" border="0" cellspacing="0" cellpadding="4">
        <tr> 
          <td width="50%" height="25">共<Font color="#FF0000"><%= RCount %></Font>条 分<Font color="#FF0000"><%= PCount %></Font>页 | 当前第<Font color="#FF0000"><%= PageNo %></Font>页</td>
          <td width="50%" align="right">
		  <% 
		  If PageNo > 1 Then
		   Response.write "<a href=""?PageNo=1"">首页</a>&nbsp;"
		   Response.write "<a href=""?PageNo="&PageNo-1&""">上页</a>&nbsp;"    
		  Else
		   Response.write "首页&nbsp;"
		   Response.write "上页&nbsp;" 
		  End if
		   %>
           <select name="menu1" onChange="MM_jumpMenu('parent',this,0)" style="width:40px;">
		    <% For i = 1 to PCount %>
                <option value="?PageNo=<%= i %>" <% If i = PageNo Then Response.write "Selected"%>><%=i%></option>
		    <% Next %>
           </select>
            <% 
		  If PageNo < PCount Then
		   Response.write "<a href=""?PageNo="&PageNo+1&""">下页</a>&nbsp;"
		   Response.write "<a href=""?PageNo="&PCount&""">尾页</a>"   
		  Else
		   Response.write "下页&nbsp;"
		   Response.write "尾页" 
		  End if
		   %>

		  
		  </td>
        </tr>
      </table>
</td>
  </tr>
</table>
<table width="950" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr> 
    <td>
      <!--#include file="../Include/Footer.asp" -->
    </td>
  </tr>
</table>

</body>
</html>
<% 
Rs.Close
Set Rs = Nothing
Call CloseDB
 %>
