<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%> 以斯帖-統計顧問股份有限公司
 
 
<% SQL="SELECT * FROM Class_data order by id asc" set rs=Server.CreateObject("Adodb.Recordset") rs.open sql,conn,3,1 IF NOT RS.EOF THEN %> <%else%> <%end if %>
 
<% While Not RS.EOF Count = Count + 1 RS.MoveNext Wend NowPage= 0 if Request.QueryString("Page")<>"" then NowPage = cint(Request.QueryString("Page")) if Request.Form("ToPage")<>"" then NowPage = cint(Request.Form("ToPage")) if NowPage <=0 then NowPage = 1 if Count/20 > (Count\20) then TotalPage=(Count\20)+1 else TotalPage=(Count\20) If RS.EOF AND Count > 0 Then RS.MoveFirst End IF if NowPage > TotalPage then NowPage = TotalPage IF not RS.EOF Then RS.Move (NowPage-1) * 20 End IF I=0 Do while not RS.EOF AND I<20 I=I+1 if i mod 2 >0 then bg="#DEE0CB" else bg="#FFFFFF" END IF page="" if request("page")="" then page=1 else page=request("page") end if typenamea="" tds="" msds="" %> <% rs.movenext loop %>
課程名稱 上課日期 時數 上課時間 會員價格 上課費用
" title="<%=rs("Class_title")%>" alt="<%=rs("Class_title")%>"><%=rs("Class_title")%> <% if IsNull(rs("Class_date")) then response.write "----" else response.write RS("Class_date") end if %>  <%=RS("Class_hour")%>小時  <% if IsNull(rs("Class_times")) then response.write "----" else response.write RS("Class_times") end if %>  <% if rs("Class_price_member")=0 then response.write "--/--" else response.write "$"&RS("Class_price_member") end if %>   <% if rs("Class_price")=0 then response.write "--/--" else response.write "$"&RS("Class_price") end if %>
<% PageSize =request("PageSize") If Trim(PageSize)="" Then PageSize=20 PageGroup =request("PageGroup") If Trim(PageGroup)="" Then PageGroup=8 RsCount=rs.recordcount PageCount=((RsCount-1)\PageSize)+1 Page=request("page") If (cdbl(page)>cdbl(PageCount) And cdbl(page)<1) Or page="" Then page=1 End If firstPage=((Page-1)\PageGroup)*PageGroup+1 If ((Page-1)\PageGroup)*PageGroup+PageGroup第一頁    " elseif cdbl(page)=1 Then pageshow=pageshow & "第一頁    " end if if cdbl(page)>CDbl(PageGroup) then pageshow=pageshow & "往前一頁 " & PageGroup & "" end If For p=firstPage to lastPage if cdbl(p) = cdbl(Page) then pageshow=pageshow & " " & p &"    " else pageshow=pageshow & ""& p & "   " end if Next Response.write "
" if PageCount > ((cdbl(page)-1)\CDbl(PageGroup)+1) * CDbl(PageGroup) then pageshow=pageshow & " 下一頁" & PageGroup & "    
" end if if cdbl(page)>=1 and cdbl(page) < CDbl(PageCount) then pageshow=pageshow & "下一頁   " ElseIf cdbl(page) = CDbl(PageCount) Then pageshow=pageshow & "下一頁
" end if '紀錄快速跳頁==>pagescriptshow pagescriptshow=" 快速跳至 :   /共:" & PageCount &"頁" pageinfshow="  |  共 : " & RsCount & " 課程  |  " & PageSize & "筆/每頁     " response.write pageshow response.write pagescriptshow response.write pageinfshow set rs=nothing %>
  目前此沒有課程....