package com.ICT.AFC.contract.actions;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import javax.servlet.ServletContext;
import javax.sql.DataSource;
import com.ICT.AFC.DB.DB;
import com.ICT.AFC.contract.beans.ContractOperate;
import java.util.ArrayList;

public class searchDepartmentAction
    extends Action {
  String TwosqlStr = "";
  public ActionForward execute(ActionMapping Mapping,
                               ActionForm Form,
                               HttpServletRequest Request,
                               HttpServletResponse Response) throws Exception {

    HttpSession session = Request.getSession();
    ServletContext context = servlet.getServletContext();
    DataSource dataSource = (DataSource) context.getAttribute("contract");
    DB db = new DB(dataSource);
    String PageForward = "departmentcontract";
    String departmentID = Request.getParameter("departmentID");//提取部門編號
    String contractIsSell = Request.getParameter("contractIsSell");//提取收/付款
    session.setAttribute("DEPARTMENTID", departmentID);
    session.setAttribute("CONTRACTISSELL", contractIsSell);

    String sqlStr = "";
   String PageNum=Request.getParameter("PageNum");

   //聲明ArrayList對象
   ArrayList contract = new ArrayList();

   ContractOperate contractoperate = new ContractOperate();

   if(PageNum == null || PageNum.equals(""))
   {


     sqlStr = sqlStr + " where contractowner='"
      + departmentID + "' and contractissell='"+ contractIsSell + "'";

      this.TwosqlStr = sqlStr;
     contract = contractoperate.getOnePageData(sqlStr, db, 1);
   }
   else
   {
       int k = Integer.parseInt(PageNum);
       String s =this.TwosqlStr;
       contract = contractoperate.getOnePageData(TwosqlStr, db,k );
    }

   session.setAttribute("DEPARTMENTCONTRACTLIST",contract);
   Request.setAttribute("contractoperate",contractoperate);
    //獲取該部門所有合同信息列表放置session中
    db.close();
    return (Mapping.findForward(PageForward));
  }
}