package com.ICT.AFC.contractmoney.payment;

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;

public class browsePaymentAction
    extends Action {
  public ActionForward execute(ActionMapping actionMapping,
                               ActionForm actionForm,
                               HttpServletRequest httpServletRequest,
                               HttpServletResponse httpServletResponse) {
    /**@todo: complete the business logic here, this is just a skeleton.*/
    browsePaymentActionForm browsePaymentActionForm = (browsePaymentActionForm)
        actionForm;
    String PageForward = "browsePayment";
    HttpSession session = httpServletRequest.getSession();
    ServletContext context = servlet.getServletContext();
    DataSource dataSource = (DataSource) context.getAttribute("contract");
    DB db = new DB(dataSource);
    String contractID=httpServletRequest.getParameter("contractID");
    try {
      Vector browseResult = browseOperate(db, contractID);
      if (browseResult.size() != 0) {
        session.setAttribute("browseResult", browseResult);
      }
      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();
      browsePaymentActionForm browsePaymentActionForm = new
          browsePaymentActionForm();
      browsePaymentActionForm.setPaymentContractID(strstr);
      browsePaymentActionForm.setPaymentDate(rs.getString("PAYDATE"));
      if (rs.getString("UPLOADPATH") == null)
        browsePaymentActionForm.setPaymentFile("nullnull");
        else
      browsePaymentActionForm.setPaymentFile(rs.getString("UPLOADPATH"));
      browsePaymentActionForm.setPaymentID(rs.getString("PAYID"));
      browsePaymentActionForm.setPaymentMoney(rs.getString("MONEY"));
      browsePaymentActionForm.setPaymentRECTime(rs.getString("RECORDTIME"));
      if (rs.getString("REMARK") == null) {
        browsePaymentActionForm.setPaymentRemark("無");
      }
      else {
        browsePaymentActionForm.setPaymentRemark(rs.getString("REMARK"));

      }
      browsePaymentActionForm.setPaymentWriter(rs.getString("WRITER"));
      ls.add(browsePaymentActionForm);

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

}