% @ Language=JScript CodePage=65001 %>
<%
var _1dpethMenu = 5;
var _2dpethMenu = 5;
var _3dpethMenu = 0;
%>
<%
var target=getStr(Request("target"));
var keyword=getStr(Request("keyword"));
var page=getNumber(Request("page"));
var pageSize=10;
var cmd=Server.CreateObject("ADODB.Command");
with(cmd){
ActiveConnection=dbCon;
CommandType=adCmdStoredProc;
CommandText="newsletter_main_count";
Parameters.Append(CreateParameter("@target",adVarWChar,adParamInput,13,target));
Parameters.Append(CreateParameter("@keyword",adVarWChar,adParamInput,50,keyword));
Parameters.Append(CreateParameter("@recordCount",adInteger,adParamOutput,4));
Execute();
var recordCount=Parameters("@recordCount").Value;
var pageCount=Math.ceil(recordCount/pageSize);
if(page>pageCount){
page=pageCount;
}
Parameters("@recordCount").Direction=adParamInput;
CommandText="newsletter_main_list";
Parameters.Append(CreateParameter("@page",adInteger,adParamInput,4,page));
Parameters.Append(CreateParameter("@pageSize",adInteger,adParamInput,4,pageSize));
var rs=Execute();
}
%>
<%=siteTitle%>
|
|
청심마당 : 뉴스레터 |
|
|
|
|
<%=(target)?"검색":"전체"%> 게시물수 : <%=recordCount%>건 |
<%=page%>/<%=pageCount%> 페이지 |
<%
var listParam=((target)?"target="+target+"&keyword="+Server.URLEncode(keyword)+"&":"")+"page=";
var viewParam=listParam+page;
while(!rs.EOF){
%>
[공지] |
&<%=viewParam%>"><%=Server.HTMLEncode(rs("nMain_title"))%>
|
<%=rs("nMain_regDate").Value.substr(0,10)%> |
<%=rs("nMain_viewCount")%> |
<%
rs.MoveNext();
}
rs=rs.NextRecordset();
if(rs.EOF){
%>
<%=(target)?"검색":"등록"%>된 게시물이 없습니다. |
<%
}
else{
var objNowDate=new Date();
var no=recordCount-(page-1)*pageSize;
while(!rs.EOF){
var nMainRegDate=rs("nMain_regDate").Value;
var objRegDate=new Date(nMainRegDate);
%>
<%=no%> |
&<%=viewParam%>"><%=Server.HTMLEncode(rs("nMain_title"))%>
<%=(objNowDate.valueOf()-objRegDate.valueOf()<86400000)?"":""%>
|
<%=nMainRegDate.substr(0,10)%> |
<%=rs("nMain_viewCount")%> |
<%
rs.MoveNext();
no--;
}
}
%>
<% if(loginMemGrade=="S" || loginMemGrade=="A" || loginMemGrade=="G" || loginMemGrade=="H" && loginMemPermit.indexOf("pds")!=-1){ %>
<% } %>
|
<% if(page>0){ %>
<%
var startPage=Math.ceil(page/10)*10-9;
if(startPage>1){
Response.Write("[이전...]");
}
for(i=startPage;i<=pageCount;i++){
Response.Write((i==page)?"["+i+"]":"["+i+"]");
if(i%10==0 && i[다음...]");
break;
}
}
%>
|
<% } %>
|
|
|
|
|
|
|
<% dbCon.Close(); %> |