package com.logistic.taglib;

import com.logistic.data.DataConnect;
import com.logistic.business.GoodsCateManager;
import com.logistic.model.GoodsCateInfo;
import java.util.Vector;
import javax.servlet.jsp.tagext.TagSupport;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.http.HttpServletRequest;
import java.sql.ResultSet;
import java.sql.Statement;

public class GoodsCateInfoAdmin extends TagSupport{

	private static final long serialVersionUID = 7766184319541530720L;
	
	DataConnect dc=new DataConnect();
	Statement stat=null;
	ResultSet rs=null;
	
	public int doEndTag() throws JspException{
		
		JspWriter out=pageContext.getOut();
	    HttpServletRequest request=(HttpServletRequest)pageContext.getRequest();
	    
	    String str=(String)request.getQueryString();
	    int page;
	    if(str==null||str.equals("")){
	    	page=1;
	    }else{
	    	String[] aa=str.split("=");
	    	page=Integer.parseInt(aa[1]);
	    }
		
	 try{
	    	
	    	String sqls=new String("select * from commcatetable order by ID ASC");
	    	int count=dc.selectdata(sqls);
	    	int totalpages=0;
	    	if(count%5==0){
	    		totalpages=count/5;
	    		}else{
	    			totalpages=count/5+1;
	    		}
	    	
	    	int currentpage=1;
	    	if(page==-4){
	    		currentpage=totalpages;
	    	   }else if(page==-3){
	    		   currentpage=currentpage+1;
	    	   }else if(page==-2){
	    		   if(currentpage==1){
	    		      currentpage=1;
	    		   }else{
	    			   currentpage=currentpage-1; 
	    		   }
	    	   }else{
	    		   currentpage=1;
	    	   }
	    	
	      GoodsCateManager gcm=new GoodsCateManager();
	      Vector items=gcm.GoodsCateSearch(sqls, page);
	      
	      out.println("<table width=\"500\" height=\"22\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
	      out.println("<tr>");
	      out.println("<td width=\"565\" height=\"20\" align=\"center\" class=\"style14\">&nbsp;&nbsp;&nbsp;&nbsp;商品分類信息列表</td>");
	      out.println("</tr>");
	      out.println("</table>");
	      
	       //輸出商品型號信息內容
		  int span=5,j=0;//span標識每頁顯示5條信息，j是一個計數器
		  String path=request.getContextPath();
	      for(int i=0;i<items.size();i++){
	    	  
	    	  GoodsCateInfo gci=(GoodsCateInfo)items.elementAt(i);
	    	  
	    	  out.println("<table width=\"500\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
	    	  out.println("<tr>");
	    	  out.println("<td width=\"61\" height=\"19\" align=\"right\" class=\"style9\">編號：</td>");
	    	  out.println("<td width=\"72\" align=\"center\" class=\"code\">"+gci.getGoodscateid()+"</td>");
	    	  out.println("<td width=\"104\" align=\"center\" class=\"style9\">商品分類名稱：</td>");
	    	  out.println("<td width=\"138\" align=\"center\" class=\"code\">"+gci.getGoodscatename()+"</td>");
	    	  out.println("<td width=\"103\" align=\"center\" class=\"code\"><a href=\""+path+"/viewpage/datamodify/goodscatemodify.jsp?gcid="+gci.getGoodscateid()+"\"><img src=\""+path+"/image/edit.gif\" border=\"0\"></a>&nbsp;&nbsp;&nbsp;&nbsp;" +
	    	   		       "<a href=\"admingoodscateinfo.jsp?goodscateid="+gci.getGoodscateid()+"\" onClick=\"{if(confirm('此操作將刪除當前記錄!刪除后將不能恢復,您確定執行的操作嗎?')){return true;}return false;}\"><img src=\""+path+"/image/delete.gif\" border=\"0\"></a></td>");
	    	  out.println("</tr>");
	    	  out.println("</table>");
	    	  j++;
	    	  if(j==span)break;	    	  
	      }
	      
	          out.println("<table width=\"500\" height=\"22\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
	          out.println("<tr>");
	          out.println("<td width=\"169\" height=\"20\" align=\"left\" class=\"code\">頁次:"+currentpage+"/"+totalpages+"頁;每頁"+span+"條信息共"+count+"</td>");
	          out.println("<td width=\"321\" height=\"20\" align=\"center\"><a href=\"admingoodscateinfo.jsp?arg1=-1\"><img src=\""+path+"/image/begin.jpg\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"admingoodscateinfo.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"admingoodscateinfo.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"admingoodscateinfo.jsp?arg4=-4\"><img src=\""+path+"/image/end.jpg\" border=\"0\"></a></td>");
	          out.println("</tr>");
	          out.println("</table>");
	   }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	return SKIP_BODY;   
	}
	
}