package com.logistic.servlet;

import java.io.IOException;
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;
import com.logistic.business.WareHouseManager;
import java.sql.Statement;
import java.sql.ResultSet;

public class WareHouseInfoSave extends HttpServlet {


	private static final long serialVersionUID = -2305260907601477327L;
	
	HttpSession session=null;
	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
	int         id=0;
	int         flag=0;
	String      warehouseid;
	String      warehousename;
	String      chargeid;
	String      warehouseadd;
	RequestDispatcher requestdispatcher;
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html; charset=gb2312");
		session=request.getSession();
		
/*---------------------取得倉庫信息表中的最有一條記錄的WareHouseId值，并生成下條記錄的WareHouseId-------------------*/		
		String sql="select * from warehouseinfotable order by ID desc limit 1";
		try{
			stat=dc.getStmtread();
			rs  =stat.executeQuery(sql);
			rs.previous();
			while(rs.next()){
				id=Integer.valueOf(rs.getInt("WareHouseId"));
			}
			if(id>0){
				id+=1;
			     }else{
				    id=10000+1;
			         }
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
				
/*-------------------獲得WareHouseInfoSave.jsp頁面提交數據進行判斷，合法后添加到數據庫-----------------*/		
	
		warehouseid=String.valueOf(id);
		warehousename=(String)request.getParameter("whname");
	    chargeid=(String)request.getParameter("cid");
	    warehouseadd=(String)request.getParameter("whaddress");
	    
	    if(warehouseid==null||warehousename==null||chargeid==null||warehouseadd==null){
	    	session.setAttribute("errors", "倉庫信息添加失敗!");
			requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
			requestdispatcher.forward(request, response);
	    }else{
	    	try{
	    	flag=-10;
	    	WareHouseManager whm=new WareHouseManager();
	    	flag=whm.AddWareHouseInfo(warehouseid, warehousename, chargeid, warehouseadd);
	    	//如果倉庫信息添加成功跳轉到adminwarehouseinfo頁面
	    		if(flag>0){
	    			requestdispatcher=request.getRequestDispatcher("/viewpage/showpage/adminwarehouseinfo.jsp");
	    			requestdispatcher.forward(request, response);
	    		   }else{
	    			   session.setAttribute("errors", "倉庫信息添加失敗!");
				   	   requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
				   	   requestdispatcher.forward(request, response);
	    		   }
	    	}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	    }
	    
		
	}

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

		doPost(request,response);
}
}