<%@ page contentType="text/html; charset=GB2312" import="java.util.*,cn.wy.factory.NewsBuy,cn.wy.Pet.NewsComment" %>
<jsp:useBean id="str" scope="page" class="cn.wy.StrFormat"/>
<jsp:useBean id="pb" scope="page" class="cn.wy.factory.NewsBuy"/>
<jsp:useBean id="petc" scope="page" class="cn.wy.Pet.NewsComment"/>
<%
int newsID =0 ;
List lComment = null ;
Iterator iterComment = null ;

//如果有寵物的編號
if (request.getParameter("newsid") != null)
{
    try
    {
    newsID = Integer.parseInt(request.getParameter("newsid"));
        //查詢出該寵物的所有評論
        lComment = pb.QueryNewsComment(newsID);
        iterComment = lComment.iterator();
    }catch(Exception e)
    {
        out.print("<script>alert('數據查詢錯誤！');history.go(-1)</script>");
        return ; 
    }
    
}else
{
    request.getRequestDispatcher("ctrladmin?page=news.jsp").forward(request,response);
    return ;
}
    
%>

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

<table width="858" height="126" border="1" align="center" cellspacing="0" bordercolor="#000000">
  <tr height="18" >
    <td height="25" colspan="7" align="center" bordercolor="#E3E4EF">
	  <strong><font size="+2">下列是 編號：<%=newsID%> 的評論管理</font></strong> </td>
  </tr>

  <tr>
    <td width="80" height="21" align="center" bgcolor="#00CC99">記錄編號編號</td>
    <td width="88" align="center" bgcolor="#00CC99">發帖人名稱</td>
    <td width="79" align="center" bgcolor="#00CC99">電子郵件</td>
    <td width="446" align="center" bgcolor="#00CC99">發表內容</td>
    <td width="102" align="center" bgcolor="#00CC99">發表時間</td>
    <td width="37" align="center" bgcolor="#00CC99">刪除</td>
  </tr>

 <%
 //開始提取該寵物的評論
 while(iterComment.hasNext())
{
   petc = (NewsComment)iterComment.next(); 
   
 %>

  <tr align="left" >
	<td height="22" valign="center" bordercolor="#009900">&nbsp;<%=petc.getId()%></td>
	<td valign="center" bordercolor="#009900">&nbsp;<%=petc.getNCName()%></td>
	<td valign="center" bordercolor="#009900">&nbsp;<%=petc.getNCEmail()%></td>
	<td valign="center" bordercolor="#009900">&nbsp;<%=petc.getNCText()%></td>
	<td valign="center" bordercolor="#009900">&nbsp;<%=petc.getNCTime()%></td>
	<td valign="center" bordercolor="#009900"><a href="ctrladmin?pid=<%=petc.getNewsID()%>&delNewsComment=<%=petc.getId()%>" onclick="return affirm()" >刪除</a></td>	
  </tr>
<%
}
if (lComment.size() ==0 )
    {
%>
<tr><td colspan="6">
    <br>
    該新聞沒有評論信息！
</td></tr>
<%
    }
%>
</table>