package com.logistic.servlet;

import java.io.IOException;
import java.sql.ResultSet;
import java.sql.Statement;
import com.logistic.business.DepartmentManager;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.logistic.data.DataConnect;

public class DepartmentInfoSave extends HttpServlet {


	private static final long serialVersionUID = -2305260907601477327L;
	HttpSession session=null;
	DataConnect dc=new DataConnect();
	Statement stat=null;
	ResultSet rs=null;
	RequestDispatcher requestdispatcher;
	int      id=0;
	int      flag=0;
	String    departmentid=null;
	String    departmentname=null;
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html; charset=gb2312");
		session=request.getSession();
		
/*
* 獲取departmnetinfotable表的DepartmentId字段的最后插入的值，生成下一條記錄的DepartmentId
* 字段的值！
* */
		String sql="select * from departmentinfotable order by ID desc limit 1";
		try{
			stat=dc.getStmtread();				 
			rs=stat.executeQuery(sql);
			rs.previous();
			   while(rs.next()){
				      id=Integer.valueOf(rs.getString("DepartmentId"));
				     }
				     if(id>0){
				        id+=1;
				        }else{
				         id=1000+1;
				        }

		    }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
						  
//從頁面獲取參數(shù)進行添加操作
		departmentid=String.valueOf(id);
		departmentname=(String)request.getParameter("departmetname");
		
		if(departmentname==null){
		   session.setAttribute("errors", "部門名稱必須填寫!");
		   requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
		   requestdispatcher.forward(request, response);
		}else{
			
			try{				
				DepartmentManager dm=new DepartmentManager();
				flag=dm.AddDepartment(departmentid, departmentname);				
				if(flag>0){
					session.setAttribute("success", "部門信息添加成功!");
		  			requestdispatcher=request.getRequestDispatcher("/viewpage/datainput/departmentinfosave.jsp");
		  			requestdispatcher.forward(request, response);					
				}else{					
		  			session.setAttribute("errors", " 部門信息添加失敗!");
		  			requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
		  			requestdispatcher.forward(request, response);										
				}				
			}catch(Exception ex){ex.printStackTrace();}			
		}		
	}
	

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request,response);
		
	}

}