package com.ICT.AFC.contractmoney.gathering;

import org.apache.struts.action.*;
import java.util.*;
import javax.servlet.http.*;
import com.ICT.AFC.DB.*;
import javax.servlet.http.*;
import javax.servlet.ServletContext;
import javax.sql.*;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;
import com.ICT.AFC.contract.beans.ContractOperate;

public class browseGatheringAction
    extends Action {
  public ActionForward execute(ActionMapping actionMapping,
                               ActionForm actionForm,
                               HttpServletRequest httpServletRequest,
                               HttpServletResponse httpServletResponse) {
    /**@todo: complete the business logic here, this is just a skeleton.*/
    browseGatheringActionForm browseGatheringActionForm = (
        browseGatheringActionForm)
        actionForm;
    String PageForward = "browseGathering";
    HttpSession session = httpServletRequest.getSession();
    ServletContext context = servlet.getServletContext();
    DataSource dataSource = (DataSource) context.getAttribute("contract");
    DB db = new DB(dataSource);

    String contractId=httpServletRequest.getParameter("contractID");
    int contractID = Integer.parseInt(contractId);
    try {
      Vector browseResult = browseOperate(db, contractId);
      if (browseResult.size() != 0) {
        session.setAttribute("browseResult", browseResult);
        session.setAttribute("SEARCHCONTRACTINFO",
                         ContractOperate.searchContract(db, contractID));
      }
      else {
        session.setAttribute("browseResult", browseResult);
      }
    }
    catch (Exception e) {
    }
    finally {
      //throw new java.lang.UnsupportedOperationException("Method perform() not yet implemented.");
      return (actionMapping.findForward(PageForward));
    }
    //throw new java.lang.UnsupportedOperationException("Method perform() not yet implemented.");
  }

  public Vector browseOperate(DB db, String strstr) throws
      Exception {

    String strSql = "SELECT * FROM M_MONEY WHERE CONTRACTID=" +
        strstr + " and CONTRACTTYPE='收款'";
    ResultSet rs = db.OpenSql(strSql);
    Vector ls = new Vector();
    for (; rs.next(); ) { //Vector ls=new Vector();
      browseGatheringActionForm browseGatheringActionForm = new
          browseGatheringActionForm();
      browseGatheringActionForm.setGatheringContractID(strstr);
      browseGatheringActionForm.setGatheringDate(rs.getString("PAYDATE"));
      if (rs.getString("UPLOADPATH") == null)
        browseGatheringActionForm.setGatheringFile("nullnull");
        else
      browseGatheringActionForm.setGatheringFile(rs.getString("UPLOADPATH"));
      browseGatheringActionForm.setGatheringID(rs.getString("PAYID"));
      browseGatheringActionForm.setGatheringMoney(rs.getString("MONEY"));
      browseGatheringActionForm.setGatheringRECTime(rs.getString("RECORDTIME"));
      if (rs.getString("REMARK") == null) {
        browseGatheringActionForm.setGatheringRemark("無");
      }
      else {
        browseGatheringActionForm.setGatheringRemark(rs.getString("REMARK"));
      }
      browseGatheringActionForm.setGatheringWriter(rs.getString("WRITER"));
      ls.add(browseGatheringActionForm);

    }
    rs.close();
    db.close();
    return ls;
  }

}