applyservlet.java

招标网站

package com.jblack.servlet;
//投标方:投标申请
import java.util.Date;
import java.util.List;

import com.jblack.dao.ApplyDAO;
import com.jblack.dao.TcompanyDAO;
import com.jblack.dao.TpublishDAO;
import com.jblack.model.Tapply;
import com.jblack.model.Tcompany;
import com.jblack.model.Tpublish;
import com.jblack.tool.BaseServlet;

public class ApplyServlet extends BaseServlet {
	private static final long serialVersionUID = 1L;
	private ApplyDAO applyDAO = new ApplyDAO();
	private TpublishDAO tpublishDAO = new TpublishDAO();
	private TcompanyDAO tcompanyDAO = new TcompanyDAO();
	
	protected void doBusiness() {
		String method = request.getParameter("method");
		if (method.equals("search")){
			String field = request.getParameter("field");
			String operator = request.getParameter("operator");
			String fieldvalue = request.getParameter("fieldValue");
			String sql = "select * from Tpublish where "+ field+operator+fieldvalue;
			List<Tpublish> tpublishs = applyDAO.query(sql);
			request.setAttribute("tpublishs", tpublishs);		
			forward("/company/bid/tbsq.jsp");
		}else if (method.equals("detail")) {
			int tpid = Integer.parseInt(request.getParameter("id"));
			Tpublish tpub = tpublishDAO.get(tpid);
			request.setAttribute("tpublishs", tpub);		
			forward("/company/bid/th_tpublish_detail_bid.jsp");
		} else if (method.equals("apply")) {
			int tpid = Integer.parseInt(request.getParameter("id"));
			Tpublish tpub = tpublishDAO.get(tpid);
			String tcusername = (String) request.getSession().getAttribute("username");
			Tcompany tc = tcompanyDAO.getpub(tcusername);
			Tapply ta = new Tapply();
			ta.setTcid(tc.getTcid());
			ta.setTpid(tpub.getTpid()); 
			ta.setTaapplydate(new Date());
			ta.setTastatus(Tapply.UN_APPLY_PASS); //投标申请未通过
			applyDAO.save(ta);			
		}
	}
}