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 java.text.SimpleDateFormat;
import java.util.Calendar;
import com.logistic.business.MessageManager;
import java.sql.Statement;
import java.sql.ResultSet;

public class MessageInSave extends HttpServlet {
	
	
	private static final long serialVersionUID = -2305260907601477327L;
	HttpSession session=null;
	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
	int         id=0;
	String      mid=null;
	String      eid=null;
	String      mtitle=null;
	String      mtime=null;
	String      mcontent=null;
	int         flag=0;
	RequestDispatcher requestdispatcher;
	
	

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

		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html; charset=gb2312");
		session=request.getSession();
		
/*--------取得messageinfotable表的MessageId并轉換成整型，并生成下條記錄的GoodsId-------*/		
		String sql="select * from messageinfotable order by ID desc limit 1";
		try{
			stat=dc.getStmtread();
			rs  =stat.executeQuery(sql);
			rs.previous();
			while(rs.next()){
				id=Integer.valueOf(rs.getInt("MessageId"));
			}
			if(id>0){
				id+=1;
			     }else{
				    id=10000+1;
			         }
			
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{dc.close();}

/*-----------------------------獲取提交信息把數據插入數據庫-------------------------*/
		mid=String.valueOf(id);
		eid=(String)session.getAttribute("employeeid");
		mtitle=(String)request.getParameter("messagetitle");
		mtime=(String)new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
		mcontent=(String)request.getParameter("messagecontent");
/*---------------判斷登陸用戶的loginid是否存在，公告標題是否為null,公告內容是否為空-------*/
		if(eid==null||mtitle==null||mcontent==null){
			session.setAttribute("errors", "公告信息添加失敗!");
			requestdispatcher=request.getRequestDispatcher("/errors/errorpage.jsp");
			requestdispatcher.forward(request, response);
		}else{
			try{
			flag=-10;
			MessageManager mm=new MessageManager();
		    flag=mm.AddMessage(mid, eid, mtitle, mtime, mcontent);
		    if(flag>0){
		    	   session.setAttribute("success", "公告信息添加成功!");
				   requestdispatcher=request.getRequestDispatcher("/viewpage/datainput/addmessageinfo.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);
	}



}