<%@ page contentType="text/html; charset=GB2312" import="java.util.*,cn.wy.Pet.News,cn.wy.factory.NewsBuy" %>
<%
    NewsBuy pb = new NewsBuy();
    List lPetAll = new ArrayList();    
    String goPage = "" ;
    String downPage = "" ;
    String keyword = "";
    if (request.getParameter("key") != null)
    {
        keyword = String.valueOf(request.getParameter("key"));
        if (keyword.indexOf("\'") >= 0 | keyword.indexOf("-") >= 0)
        {
            out.print("<script>alert('請不要亂注！');history.go(-1)</script>");
            return ;            
        }
    }
    //總的頁數(shù)
    int pageCount = 0;
    int petCount = cn.wy.factory.ThingsBuy.queryCount("select count(*) from News  where ntitle like '%"+ keyword+"%' or ntext like '%"+keyword+"%'");
    int managerPetPageNo = 12;
    if (petCount % managerPetPageNo > 0)
        pageCount = petCount / managerPetPageNo + 1;
    else
        pageCount = petCount / managerPetPageNo ;

    int pageNo = 1; //顯示分頁的第幾頁
    try{
        pageNo = Integer.valueOf(request.getParameter("pageNo")).intValue();
    }catch(Exception e)
    {pageNo = 1;}
    //如果有這個頁，就把記錄查詢出來

    if (pageNo > 1)
    {
        int pageAdd = pageNo - 1;
        goPage = "<a href=\"ctrladmin?page=news.jsp?pageNo=" + pageAdd +"\">上頁</a>";
    }else
    {
        goPage = "";
        pageNo = 1 ; 
    }
    if(pageNo < pageCount)
    {
        int pageMinus = pageNo + 1 ;
        downPage ="<a href=\"ctrladmin?page=news.jsp?pageNo=" + pageMinus + "\">下頁</a>";
    }else
    {
        downPage = "";
        if (pageNo > pageCount)
            pageNo = 1 ; 
    }
    if (pageNo <= pageCount)
    {
        lPetAll = pb.queryNewsAll(pageNo,managerPetPageNo,keyword,"");
    }
    Iterator iter = lPetAll.iterator();
%> 

<script language="javascript" type="text/javascript">
function affirm()
{
	if (window.confirm("警告：確定要刪除該新聞和評論信息嗎？刪除以后不可以恢復(fù)。"))
            return true;
        else
            return false;
}
</script>


<table width="800" height="152" border="1" align="center" cellspacing="0" bordercolor="#000000">
  <tr height="18" >
    <td height="25" colspan="9" align="center" bordercolor="#E3E4EF"><strong><font size="+2">寵物新聞</font></strong> </td>
  </tr>
  
  <tr>
    <td width="55"  height="21" align="center" bgcolor="#00CC99"><div align="center">編號</div></td>
    <td width="302"  align="center" bgcolor="#00CC99"><div align="center">新聞標(biāo)題</div></td>
    <td width="132"   align="center" bgcolor="#00CC99"><div align="center">發(fā)布時間</div></td>
    <td width="85"  align="center" bgcolor="#00CC99"><div align="center">操作員</div></td>
    <td width="62"   align="center" bgcolor="#00CC99"><div align="center">點擊次</div></td>
    <td width="56"  align="center" bgcolor="#00CC99">評論</td>
    <td width="69"   align="center" bgcolor="#00CC99"><div align="center">編輯</div></td>
    <td width="42"  align="center" bgcolor="#00CC99"><div align="center">刪除</div></td>
  </tr>
  <%       
      String id = "";
      String isShopping = "出售";      
      boolean isPet = false;
      while(iter.hasNext())
      {
          News p = (News)iter.next();
          //SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日");
          id = String.valueOf(p.getNewsID());
   %>

  <tr>
    <td height="24" align="center" valign="center" bordercolor="#009900">&nbsp;<%=p.getNewsID()%></td>
    <td align="left" valign="center" bordercolor="#009900"><%=p.getNTitle().replaceAll(keyword,"<font color=\"red\">"+keyword+"</font>")%></td>
    <td align="left" valign="center" bordercolor="#009900">&nbsp;<%=p.getNDateTime()%></td>
    <td align="center" valign="center" bordercolor="#009900">&nbsp;<%=p.getUName()%></td>
    <td align="left" valign="center" bordercolor="#009900">&nbsp; <%=p.getNCount()%> </td>
    <td align="left" valign="center" bordercolor="#009900"><a  title="點擊即可管理該新聞的評論信息" href="ctrladmin?page=newsCommeet.jsp?newsid=<%=id%>">評論<%=p.getCommentCount()%></a></td>
    <td align="center" valign="center" bordercolor="#009900"><a href="ctrladmin?editNewsID=<%=id + "&pNo=" + pageNo %>" >編輯</a></td>
    <td align="center" valign="center" bordercolor="#009900"><a href="ctrladmin?delNews=<%=id + "&pNo=" + pageNo %>" onclick="return affirm()" >刪除</a></td>
  </tr><font color="FF0000"></font>
  <%       
       }
        if (lPetAll.size() < 1){
  %>
  <tr> 
      <td height="43" colspan="8" > 
          <br>還沒有寵物信息! <br>
        <a href="ctrladmin?page=adnews.jsp">點這里添加寵物</a> <br><br>
  <td width="1">  </tr>
  <%
        System.out.println("沒有啊 1");
        }
  %>
  <tr align="top">
    <td height="31" colspan="8"  align="left" valign="top" bordercolor="#000000"><table width="828" height="27" border="0">
      <tr>
        <td width="516" height="23"><form action="ctrladmin?page=news.jsp" name="form1" id="form1">
          當(dāng)前頁:<%=lPetAll.size()%>條&nbsp;&nbsp;共：<%=petCount%>條&nbsp;&nbsp;<%=pageNo%>/<%=pageCount%>&nbsp;&nbsp; <a href="ctrladmin?page=news.jsp?pageNo=1">第一頁</a>&nbsp; <%=goPage%>&nbsp; <%=downPage%>&nbsp; <a href="ctrladmin?page=news.jsp?pageNo=<%=pageCount%>">尾頁</a> &nbsp;&nbsp;轉(zhuǎn)到：
          <select name="page" onchange="document.form1.submit()">
            <%
                  for (int i=1;i<=pageCount; i++){
                  %>
            <option value="<%="news.jsp?pageNo=" + String.valueOf(i)%>" <%=(pageNo == i)? "selected":""%> >第<%=i%>頁
              <%
                  }
                  %>
              </option>
          </select>
        </form></td>
        <td width="302"><form action="ctrladmin?page=news.jsp" method="post" name="find" id="find">
            <div align="right">搜索新聞：
              <input type="text" maxlength="20" value="<%=keyword%>" size="10" name="key" />
                <input type="submit" value="查找" name="butt" />
            </div>
        </form></td>
      </tr>
    </table></td>
  </tr>
</table>