contractoperate.java

完整的合同管理信息系统

package com.ICT.AFC.contract.beans;

import com.ICT.AFC.DB.DB;
import java.sql.ResultSet;

import java.util.ArrayList;
import java.util.Vector;
import java.sql.SQLException;

/**
 * <p>Title:合同类相关操作 </p>
 * <p>Description:合同类相关操作，包括合同插入、修改、删除、查询。 </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: 电子所AFC事业部</p>
 * @author 梅晓峰
 * @version 1.0
 */
public class ContractOperate {
  public static int PageSize = 2; //设置一页显示的记录数
  public static int PageNum = 0; //初始化页码为1
  public static int PageNumCount = 0; //总页数
  public static int TotalItem = 0; //总的记录数

  public void setPageSize(int PageSize) {
    this.PageSize = PageSize;
  }

  public int getPageSize() {
    return this.PageSize;
  }

  public void setPageNum(int PageNum) {
    this.PageNum = PageNum;
  }

  public int getPageNum() {
    return this.PageNum;
  }

  public void setPageNumCount(int PageNumCount) {
    this.PageNumCount = PageNumCount;
  }

  public int getPageNumCount() {
    return this.PageNumCount;
  }

  public void setTotalItem(int TotalItem) {
    this.TotalItem = TotalItem;
  }

  public int getTotalItem() {
    return this.TotalItem;
  }

  public ContractOperate() {
  }

  /**
   * 添加新合同方法
   * @param db DB
   * @param contract Contract
   * @throws Exception
   * @return boolean
   */
  public static boolean addContract(DB db, Contract contract) throws Exception {
    String conditions;
    conditions = "select seq_contract.nextval from dual";
    ResultSet rs = db.OpenSql(conditions);
    rs.next();
    int contractid = rs.getInt(1); //提取id
    //从参数contract对象中提取合同属性
    String contractowner = contract.getContractOwner();
    String contractno = contract.getContractNo();
    String contractotherside = contract.getContractOtherSide();
    String contractstartdate = contract.getContractStartDate();
    String contractenddate = contract.getContractEndDate();
    String contractsigner = contract.getContractSigner();
    String contractsigndate = contract.getContractSignDate();
    String contractsource = contract.getContractSource();
    String contractissell = contract.getContractIsSell();
    String contractisperside = contract.getContractIsPerside();
    String contractmoneysys = contract.getContractMoneySys();
    float contracttotal = Float.parseFloat(contract.getContractTotal());
    float contractrealtotal = Float.parseFloat(contract.getContractRealTotal());
    String contractcopy = contract.getContractCopy();
    String contractremark = contract.getContractRemark();
    String contractrddate = contract.getContractRdDate();
    String contractrdaccount = contract.getContractrdaccout();
    String contractname = contract.getContractName();
    String contractentity = contract.getContractEntity();
    String contractsubtype = contract.getContractSubType();
    //合同属性提取结束
    String sqlstr =
        "INSERT INTO M_CONTRACT(CONTRACTID,CONTRACTOWNER,CONTRACTNO,CONTRACTOTHERSIDE,"
        +
        "CONTRACTSTARTDATE,CONTRACTENDDATE,CONTRACTSIGNER,CONTRACTSIGNDATE,"
        + "CONTRACTSOURCE,CONTRACTISSELL,"
        + "CONTRACTISPRESIDE,CONTRACTMONEYSYS,CONTRACTTOTAL,CONTRACTREALTOTAL,"

        + "CONTRACTCOPY,CONTRACTREMARK,CONTRACTRDDATE,CONTRACTRDACCOUT,CONTRACTNAME,CONTRACTSUBTYPE,CONTRACTENTITY) values("

        + contractid + ",'"
        + contractowner + "','"
        + contractno + "','"
        + contractotherside + "', to_date('"
        + contractstartdate + "','yyyy-mm-dd'),to_date('"
        + contractenddate + "','yyyy-mm-dd'),'"
        + contractsigner + "',to_date('"
        + contractsigndate + "','yyyy-mm-dd'),'"
        + contractsource + "','"
        + contractissell + "','"
        + contractisperside + "','"
        + contractmoneysys + "',"
        + contracttotal + ",'"
        + contractrealtotal + "','"
        + contractcopy + "','"
        + contractremark + "',to_date('"
        + contractrddate + "','yyyy-mm-dd HH24:mi:ss'),'"
        + contractrdaccount + "','"
        + contractname + "','"
        + contractsubtype + "','"
        + contractentity + "')";
    System.out.println("addsql=" + sqlstr);
    //合同信息插入成功返回true，插入失败返回false。
    if (db.ExecSql(sqlstr) == 0) {
      return false;
    }
    else {
      return true;
    }
  }

  /**
   * 查找指定合同
   * @param db DB
   * @param contractid int
   * @throws Exception
   * @return Contract
   */
  public static Contract searchContract(DB db, int contractid) throws
      Exception {
    String strSql = null;
    if (contractid == 0) {
      strSql = "select * from M_CONTRACT order by contractrddate desc";
    }
    else {
      strSql = "select * from M_CONTRACT where contractID=" + contractid;
    }
    ResultSet rs = db.OpenSql(strSql);
    Contract contract = new Contract();
    if (rs.next()) {
      contract.setContractId(Integer.parseInt(rs.getString("CONTRACTID")));
      contract.setContractNo(rs.getString("CONTRACTNO"));
      contract.setContractName(rs.getString("CONTRACTNAME"));
      String contractowner = rs.getString("CONTRACTOWNER");
      if (contractowner.equals("0")) {
        contractowner = "AFC事业部";
      }
      if (contractowner.equals("1")) {
        contractowner = "ASP事业部";
      }
      if (contractowner.equals("2")) {
        contractowner = "智能中心";
      }
      if (contractowner.equals("3")) {
        contractowner = "机电市场部";
      }
      if (contractowner.equals("4")) {
        contractowner = "信息化监理部";
      }
      if (contractowner.equals("5")) {
        contractowner = "研发部";
      }
      if (contractowner.equals("6")) {
        contractowner = "综合部";
      }
      if (contractowner.equals("7")) {
        contractowner = "财务部";
      }
      if (contractowner.equals("8")) {
        contractowner = "质管部";
      }
      if (contractowner.equals("9")) {
        contractowner = "人力资源部";
      }
      if (contractowner.equals("10")) {
        contractowner = "杂志社";
      }

      contract.setContractOwner(contractowner);
      contract.setContractEntity(rs.getString("CONTRACTENTITY"));
      contract.setContractOtherSide(rs.getString("CONTRACTOTHERSIDE"));
      contract.setContractStartDate(rs.getDate("CONTRACTSTARTDATE").toString());
      contract.setContractEndDate(rs.getDate("CONTRACTENDDATE").toString());
      contract.setContractSigner(rs.getString("CONTRACTSIGNER"));
      contract.setContractSignDate(rs.getDate("CONTRACTSIGNDATE").toString());
      String contractsource = rs.getString("CONTRACTSOURCE");
      if (contractsource.equals("1")) {
        contractsource = "国家";
      }
      System.out.println("contractsource=" + contractsource);
      if (contractsource.equals("2")) {
        contractsource = "部委";
      }
      if (contractsource.equals("3")) {
        contractsource = "铁科院";
      }
      if (contractsource.equals("4")) {
        contractsource = "电子所";
      }
      contract.setContractSource(contractsource);
      String contractissell = rs.getString("CONTRACTISSELL");
      if (contractissell.equals("1")) {
        contractissell = "收款";
      }
      if (contractissell.equals("2")) {
        contractissell = " 付款";
      }

      contract.setContractIsSell(contractissell);
      contract.setContractIsPerside(rs.getString("CONTRACTISPRESIDE"));
      contract.setContractMoneySys(rs.getString("CONTRACTMONEYSYS"));
      contract.setContractTotal(String.valueOf(rs.getInt("contractTotal")));
      contract.setContractRealTotal(String.valueOf(rs.getInt(
          "contractRealTotal")));
      contract.setContractCopy(rs.getString("CONTRACTCOPY"));
      contract.setContractRemark(rs.getString("CONTRACTREMARK"));
      contract.setContractrdaccout(rs.getString("CONTRACTRDACCOUT"));

    }

    return contract;
  }

  /**
   * 查找某个部门的所有合同
   * @param db DB
   * @param departmentid String
   * @throws Exception
   * @return ArrayList
   */
  public static ArrayList searchDepartment(DB db, String departmentid,
                                           String contractIsSell) throws
      Exception {
    ArrayList Contracts = new ArrayList();
    String strSql = null;
    strSql = "select * from M_CONTRACT where contractowner='"
        + departmentid + "' and contractissell='"
        + contractIsSell + "'";
    ResultSet rs = db.OpenSql(strSql);

    while (rs.next()) {
      Contract contract = new Contract();
      contract.setContractId(Integer.parseInt(rs.getString("CONTRACTID")));
      contract.setContractNo(rs.getString("CONTRACTNO"));
      contract.setContractName(rs.getString("CONTRACTNAME"));
      String contractowner = rs.getString("CONTRACTOWNER");
      if (contractowner.equals("0")) {
        contractowner = "AFC事业部";
      }
      if (contractowner.equals("1")) {
        contractowner = "ASP事业部";
      }
      if (contractowner.equals("2")) {
        contractowner = "智能中心";
      }
      if (contractowner.equals("3")) {
        contractowner = "机电市场部";
      }
      if (contractowner.equals("4")) {
        contractowner = "信息化监理部";
      }
      if (contractowner.equals("5")) {
        contractowner = "研发部";
      }
      if (contractowner.equals("6")) {
        contractowner = "综合部";
      }
      if (contractowner.equals("7")) {
        contractowner = "财务部";
      }
      if (contractowner.equals("8")) {
        contractowner = "质管部";
      }
      if (contractowner.equals("9")) {
        contractowner = "人力资源部";
      }
      if (contractowner.equals("10")) {
        contractowner = "杂志社";
      }

      contract.setContractOwner(contractowner);
      contract.setContractEntity(rs.getString("CONTRACTENTITY"));
      contract.setContractOtherSide(rs.getString("CONTRACTOTHERSIDE"));
      contract.setContractStartDate(rs.getDate("CONTRACTSTARTDATE").toString());
      contract.setContractEndDate(rs.getDate("CONTRACTENDDATE").toString());
      contract.setContractSigner(rs.getString("CONTRACTSIGNER"));
      contract.setContractSignDate(rs.getDate("CONTRACTSIGNDATE").toString());
      String contractsource = rs.getString("CONTRACTSOURCE");
      if (contractsource.equals("1")) {
        contractsource = "国家";
      }
      if (contractsource.equals("2")) {
        contractsource = "部委";
      }
      if (contractsource.equals("3")) {
        contractsource = "铁科院";
      }
      if (contractsource.equals("4")) {
        contractsource = "电子所";
      }
      contract.setContractSource(contractsource);
      String contractissell = rs.getString("CONTRACTISSELL");
      if (contractissell.equals("1")) {
        contractissell = "收款";
      }
      if (contractissell.equals("2")) {
        contractissell = " 付款";
      }

      contract.setContractIsSell(contractissell);
      contract.setContractIsPerside(rs.getString("CONTRACTISPRESIDE"));
      contract.setContractMoneySys(rs.getString("CONTRACTMONEYSYS"));
      contract.setContractTotal(String.valueOf(rs.getInt("contractTotal")));
      contract.setContractRealTotal(String.valueOf(rs.getInt(
          "contractRealTotal")));
      contract.setContractCopy(rs.getString("CONTRACTCOPY"));
      contract.setContractRemark(rs.getString("CONTRACTREMARK"));
      Contracts.add(contract);

    }

    return Contracts;
  }

  public static ArrayList searchContractByYear(DB db, String contractRdDate,
                                               String contractIsSell,
                                               String departmentID) throws
      Exception {
    ArrayList Contracts = new ArrayList();
    String strSql = null;
    if (departmentID == null) {
      strSql =
          "select * from M_CONTRACT where to_char(CONTRACTRDDATE,'yyyy')='"
          + contractRdDate + "' and contractissell='"
          + contractIsSell + "'";
    }
    else {
      strSql =
          "select * from M_CONTRACT where to_char(CONTRACTRDDATE,'yyyy')='"
          + contractRdDate + "' and contractissell='" + contractIsSell +
          "' and CONTRACTOWNER='"
          + departmentID + "'";
    }
    ResultSet rs = db.OpenSql(strSql);

    while (rs.next()) {
      Contract contract = new Contract();
      contract.setContractId(Integer.parseInt(rs.getString("CONTRACTID")));
      contract.setContractNo(rs.getString("CONTRACTNO"));
      contract.setContractName(rs.getString("CONTRACTNAME"));
      String contractowner = rs.getString("CONTRACTOWNER");