<% ' =========================================================================== ' 시스템명 : 좋은나무성품학교 ' 프로그램설명 : 공통 게시판 서브페이지 ' 최종수정일 : 2017/05/16 ' 작성자 : 이상영 ' =========================================================================== %> <% page = RequestInt("PAGE", 1) leftMenuNum = Request("leftMenuNum") PageTopTitle = Request("PageTopTitle") bbs = RequestStr("bbs","04") no = Request("NO") schItem = RequestStr("SCHITEM", "") schStr = RequestStr("SCHSTR", "") category_num = Request("CATEGORY_NUM") ' 글 코드번호가 있는 내용은 바로 view 페이지로 이동할 수 있도록 한다. If no <> "" then url = "/board/subBPage_View.asp?leftMenuNum="&leftMenuNum&"&PageTopTitle="&PageTopTitle&"&BBS="&bbs&"&PAGE="&page&"&NO="&no&"&SCHSTR="&schStr GoUrl(url) End if condition = " AND condition = '1' " If schStr <> "" Then condition = condition & " AND " & schItem & " Like '%" & schStr & "%'" if category_num <> "" Then condition = condition & " AND category_num = '" & category_num & "'" ' ==================================================================== ' 데이타베이스 연결 setConnectionDB ' ==================================================================== %> <% ' =============================================================== if view_YN = "N" Then PrintMsgBack("게시판 보기 권한이 없습니다") ' =============================================================== strSQL = "SELECT COUNT(no) as num FROM goodtree.i_board WHERE bbs = ? " & condition Set Comm = Server.CreateObject("ADODB.Command") with Comm .ActiveConnection = oConn .CommandType = adCmdText .CommandText = strSQL .Parameters.Append .CreateParameter("@bbs", adChar, adParamInput, 2) .Parameters("@bbs") = bbs Set oRS = .Execute end with If oRS.BOF or oRS.EOF Then nTotalListSzie = 0 Else nTotalListSize = oRS("num") End If oRS.Close nListSize = listViewNumber nTotalPageSizeMod = nTotalListSize Mod nListSize nRevision = 0 nModSize = nListSize If nTotalPageSizeMod <> 0 Then nRevision = 1 nModSize = nTotalPageSizeMod End If nTotalPageSize = Fix(nTotalListSize / nListSize) + nRevision prnNum = ((nTotalPageSize - page) * nListSize) + nModSize nReadSize = nListSize * page nBlockSize = 10 ' 블록페이지의 크기를 N이라하면 N < nBlockSize < N+1 도록 지정 nowDate = Year(now()) & "-" & addZero(Month(now()), 2) & "-" & addZero(Day(now()), 2) %>
<%If leftMenuNum = "9" then%> <%elseIf leftMenuNum = "10" then%> <%End If%>