refundaddaction.java

仓库管理系统,适合各种行业的仓库管理系统

package com.caigou.action;

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.bean.DAO.RefundDAO;
import com.bean.DAO.StockDAO;
import com.bean.DTO.RefundDTO;
import com.bean.DTO.StockDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;

public class RefundaddAction extends AbstractAction {

	private String forward="";
	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		RefundDTO dto = new RefundDTO();
		String projectID = request.getParameter("projectID");
		String totalfee = request.getParameter("totalfee");
		String checkerID = request.getParameter("checkerID");
		String directorID = request.getParameter("directorID");
		dto.setProjectID(Integer.parseInt(projectID));
		dto.setTotalfee(Float.parseFloat(totalfee));
		dto.setCheckerID(Integer.parseInt(checkerID));
		dto.setDirectorID(Integer.parseInt(directorID));
		try {
			Connection con = DataSourceFactory.getDataSource().getConnection();
			StockDAO stock = new StockDAO(con);
			String rs1=stock.getByID3(Integer.parseInt(projectID));
			RefundDAO dao = new RefundDAO(con);
			String rs = dao.getByID2(Integer.parseInt(projectID));
			if(rs1.equals("hdj")){
				request.setAttribute("err", "无此采购项目");
				forward = "caigouxitong/refundadd.jsp";
			}
			if(rs.equals("hdj")){
				request.setAttribute("err", "该项目已经报销");
				forward = "caigouxitong/refundadd.jsp";
			}
			else{
			dao.add(dto);
			forward = "refundedit.do";
			}
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return forward;

        }

}