orderexeservlet.java

该源代码实现了系统的进货

package EnterServlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.*;
import java.util.Date;
import java.io.*;

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 operation.OrderExeOperation;
import operation.SaleOperation;
import dataBase.DataBase;

public class OrderExeServlet extends HttpServlet {
	public final static String jdkDateFormat="yyyy-MM-dd";

	/**
	 * Constructor of the object.
	 */
	public OrderExeServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		response.setContentType("text/html");
		
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
        
		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html;charset=gb2312");
		PrintWriter out=response.getWriter();
		SaleOperation so=new SaleOperation();
		OrderExeOperation oeo=new OrderExeOperation();
		
		//得到系统时间
		Date date=new Date();
		java.sql.Date sqldate = null;
		SimpleDateFormat dateFormat=new SimpleDateFormat(jdkDateFormat);
		try
		{
			 sqldate=new java.sql.Date(date.getTime());
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
		String SaleID=so.getSaleID();
		String OrderID=request.getParameter("OrderID");
		String  CustomerName=request.getParameter("CustomerName");
		int ProductID=oeo.getAttribute(OrderID, "ProductID");
		int CustomerID=oeo.getAttribute(OrderID, "CustomerID");
		int OrderQuantity=oeo.getAttribute(OrderID, "OrderQuantity");                     //得到订货数量
	    int    SaleQuantity = OrderQuantity;                                              //得到销售数量
		float  SalePrice = Float.parseFloat(request.getParameter("SalePrice"));           //得到销售单价
		String SaleNotice=request.getParameter("SaleNotice");                             //得到销售单备注
		/*
		HttpSession session=request.getSession();
		String Chargeman=(String)session.getAttribute("userID");        
		*/                 
		String Chargeman=request.getParameter("chargeman");                               //得到经手人 
		String Transportor=request.getParameter("transportor");                           //得到送货人
		float  SaleSum=SaleQuantity*SalePrice;                                            //得到销售总金额
		java.sql.Date SaleDate=sqldate;                                                   //得到销售日期
		
        //应得单据相关信息
		String PartSale=SaleID.substring(1,12);
		String ShouldGetID="SG"+PartSale;                                                 //得到应付编号
		float ShouldGetSum=SaleSum;                                                       //得到应付金额
		float LeaveSum=SaleSum;                                                           //得到剩余金额
		String ShouldGetNotice="";                                                        //得到应付备注
		java.sql.Date ShouldGetDate=sqldate;                                              //得到应付日期
		

		
		if(so.checkStock(ProductID, SaleQuantity))
		{
	        int ProductQuantity=so.getProductQuantity(ProductID);                             //得到库存
	        ArrayList list=so.getEnterList(ProductQuantity, ProductID, SaleQuantity);         //得到销售对应的进货单编号
			 so.EnterInfoInsert(SaleID, ProductID,CustomerID, SaleQuantity, SalePrice, SaleSum, SaleDate, 
					 Chargeman,Transportor, SaleNotice,ShouldGetID, ShouldGetSum, LeaveSum, ShouldGetDate, ShouldGetNotice,list);
			 oeo.OrderChange(OrderID);
			 out.println("<script> alert('执行订单成功！');window.location.href='orderlist.jsp';</script>");
			
		}
		else
		{
			out.println("<script> alert('库存不足量！');window.location.href='orderlist.jsp';</script>");
		}
		
		so.Close();
		oeo.close();
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}