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.StockRegionManager;
import java.sql.Statement;
import java.sql.ResultSet;

public class StockRegionSave extends HttpServlet {

	private static final long serialVersionUID=-2305260907601477327L;
	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
	HttpSession session=null;
	RequestDispatcher requestdispatcher;
	int        id=0;
	String      srname;
	String      srid;
	int         flag=0;

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html; charset=gb2312");
		session=request.getSession();

/*------------取得stockregioninfotable表的StockRegionId并轉換成整型，進行計算并生成下條記錄的StockRegionId---------*/		
		String sql="select * from stockregioninfotable order by ID desc limit 1";
		try{
			stat=dc.getStmtread();
			rs  =stat.executeQuery(sql);
			rs.previous();
			while(rs.next()){
				id=Integer.valueOf(rs.getInt("StockRegionId"));
			}
			if(id>0){
				id+=1;
			     }else{
				    id=10000+1;
			         }
			
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{dc.close();}
		
/*---------------取得stockregionsave.jsp頁面提交的數據進行判斷，如果合法則提交到數據庫---------------*/		
	   srid=String.valueOf(id);
	   srname=(String)request.getParameter("location")+"--"+(String)request.getParameter("rows")+"--"+(String)request.getParameter("seats");
	   if(srid==null||srname==null){
		   session.setAttribute("errors", "商品在庫位置信息添加失敗!");
		   requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
		   requestdispatcher.forward(request, response);
	   }else{
		  
		   try{
			   flag=-10;
			   StockRegionManager srm=new StockRegionManager();
			   flag=srm.AddStockRegion(srid,srname);
			   if(flag>0){
				    session.setAttribute("success","商品在庫位置信息添加成功!"); 
			    	requestdispatcher=request.getRequestDispatcher("/viewpage/datainput/stockregionsave.jsp");
					requestdispatcher.forward(request, response);
			     }else{
			    	session.setAttribute("errors","商品在庫位置信息添加失敗!"); 
			    	requestdispatcher=request.getRequestDispatcher("/viewpage/datainput/stockregionsave.jsp");
					requestdispatcher.forward(request, response);
			     }
			   
		     }catch(Exception ex){
			      ex.printStackTrace();
		         }
	      }
	   
	
	}
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {

		doPost(request,response);
   }

}