package com.logistic.taglib;

import com.logistic.data.DataConnect;
import com.logistic.business.DepartmentManager;
import com.logistic.model.DepartmentInfo;
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 DepartmentAdmin 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]);
			System.out.println("page="+page);
		}
				
		try{
			
	    	String sqls=new String("select * from departmentinfotable order by Id ASC");
	    	int totalpages=0;
	    	int count=dc.selectdata(sqls);
	    	if(count%5==0){
	    		totalpages=count/5;
	    		}else{
	    		totalpages=count/5+1;
	    		}
	    	int currentpage=1;
	    	if(page==-4){							//如果單擊尾頁鏈接把當(dāng)前頁號為總頁號
	    		currentpage=totalpages;				
	    	   }else if(page==-3){					//如果單擊下一頁鏈接,判斷如果當(dāng)前頁為總頁數(shù)，則當(dāng)前頁號為總頁號
	    		      if(currentpage==totalpages){
	      		    	 currentpage=totalpages; 
	      		         }else{
	      		         currentpage=currentpage+1; //否則當(dāng)前頁號 ＋1
	      		        }
	    	   }else if(page==-2){					
	    		   if(currentpage==1){
	    		      currentpage=1;
	    		   }else{
	    			   currentpage=currentpage-1; 
	    		   }
	    	   }else{
	    		   currentpage=1;
	    	   }
	    	
	    DepartmentManager dm=new DepartmentManager();
	    
	    Vector items=dm.DepartmentSearch(sqls,page);
	    
	    out.println("<table width=\"420\" height=\"20\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
	    out.println("<tr>");
	    out.println("<td height=\"20\" align=\"center\" class=\"style14\">部門信息列表</td>");
	    out.println("</tr>");
	    out.println("</table>");

	    
	    //輸出部門信息內(nèi)容
	    int span=5,j=0;//span標(biāo)識每頁顯示5條信息，j是一個(gè)計(jì)數(shù)器
	 	String path=request.getContextPath();
	    for(int i=0;i<items.size();i++){
	    	
	    	DepartmentInfo di=(DepartmentInfo)items.elementAt(i);
	    	
	    	out.println("<table width=\"420\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
	    	out.println("<tr>");
	    	out.println("<td width=\"35\" height=\"20\" align=\"right\" bgcolor=\"#FFCCCC\" class=\"code\">編號:</td>");
	    	out.println("<td width=\"54\" height=\"20\" align=\"center\">"+di.getDepartmentid()+"</td>");
	    	out.println("<td width=\"73\" height=\"20\" align=\"right\" bgcolor=\"#FFCCCC\" class=\"code\">部門名稱:</td>");
	    	out.println("<td height=\"20\" align=\"center\">"+di.getDepartmentname()+"</td>");
	    	out.println("<td width=\"80\" align=\"left\"><a href=\"#?departmentid="+di.getDepartmentid()+"\"><img src=\""+path+"/image/edit.gif\" border=\"0\"></a>&nbsp;&nbsp;&nbsp;" +
	    	   		    "<a href=\"admindepartmentinfo.jsp?departmentid="+di.getDepartmentid()+"\" onClick=\"{if(confirm('此操作將刪除當(dāng)前記錄!刪除后將不能恢復(fù),您確定執(zhí)行的操作嗎?')){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=\"420\" height=\"22\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
	       out.println("<tr>");
	       out.println("<td width=\"170\" height=\"20\">頁次:"+currentpage+"/"+totalpages+"頁;每頁5條信息共"+count+"條</td>");
	       out.println("<td width=\"232\" height=\"20\"><a href=\"admindepartmentinfo.jsp?arg1=-1\"><img src=\""+path+"/image/begin.jpg\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"admindepartmentinfo.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"admindepartmentinfo.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"admindepartmentinfo.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;	
	}

}