contractoperate.java

完整的合同管理信息系统

      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 searchContractEntity(DB db, String contractEntity,
                                               String departmentid,
                                               String contractIssell) throws
      Exception {
    ArrayList Contracts = new ArrayList();
    String strSql = null;
    strSql = "select * from M_CONTRACT where CONTRACTENTITY='" +
        contractEntity + "' and 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 boolean deleteContract(DB db, int contractid) throws
      Exception {
    String strSql = null;
    strSql = "delete from M_CONTRACT where CONTRACTID=" + contractid;
    if (db.ExecSql(strSql) == 0) {
      return false;
    }
    else {
      return true;
    }
  }

  public static boolean mondifyContract(DB db, Contract contract) throws
      Exception {

    //从参数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 contractname = contract.getContractName();
    String contractentity = contract.getContractEntity();

    //合同属性提取结束

    String sqlstr =
        "UPDATE M_CONTRACT SET CONTRACTOWNER='" + contractowner +
        "',CONTRACTOTHERSIDE='" + contractotherside + "',"
        +
        "CONTRACTENDDATE=to_date('" + contractenddate +
        "','yyyy-mm-dd'),CONTRACTSTARTDATE= to_date('" + contractstartdate +
        "','yyyy-mm-dd'),CONTRACTSIGNER='" + contractsigner +
        "',CONTRACTSIGNDATE=to_date('" + contractsigndate + "','yyyy-mm-dd'),"
        + "CONTRACTSOURCE='" + contractsource + "',CONTRACTISSELL='" +
        contractissell + "',"
        +
        "CONTRACTISPRESIDE='" + contractisperside + "',CONTRACTMONEYSYS='" +
        contractmoneysys + "',CONTRACTTOTAL='" + contracttotal +
        "',CONTRACTREALTOTAL='" + contractrealtotal + "',"
        + "CONTRACTCOPY='" + contractcopy + "',CONTRACTREMARK='" +
        contractremark + "',CONTRACTNAME='" + contractname +
        "',CONTRACTENTITY='" + contractentity + "'  WHERE CONTRACTNO = '" +
        contractno + "'";

    //合同信息修改成功返回true，插入失败返回false。
    if (db.ExecSql(sqlstr) == 0) {
      return false;
    }
    else {
      return true;
    }
  }

  public static ArrayList queryContract(DB db, String str) throws Exception {
    ResultSet rs;
    String strSql = "SELECT * FROM M_CONTRACT " + str;
    ArrayList contractlist = new ArrayList();
    Contract contract = null;

    for (rs = db.OpenSql(strSql); rs.next(); contractlist.add(contract)) {
      contract = new Contract();
      contract.setContractNo(rs.getString("CONTRACTNO"));
      contract.setContractName(rs.getString("CONTRACTNAME"));
      contract.setContractStartDate(rs.getDate("CONTRACTSTARTDATE").toString());
      contract.setContractEndDate(rs.getDate("CONTRACTENDDATE").toString());
      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);
      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.setContractEntity(rs.getString("CONTRACTENTITY"));
      contract.setContractTotal(String.valueOf(rs.getInt("CONTRACTTOTAL")));
      contract.setContractRealTotal(String.valueOf(rs.getInt(
          "CONTRACTREALTOTAL")));
    }
    return contractlist;
  }

  public ArrayList getOnePageData(String condition, DB db, int PageNum) throws
      SQLException, Exception {
    String sql = "";
    Vector pageV = new Vector(); //每页的内容
    Vector totalV = new Vector(); //所有的内容
    pageV.removeAllElements();
    totalV.removeAllElements();

    String strSql = "SELECT count(*)  FROM M_CONTRACT " + condition;

    ResultSet rs = db.OpenSql(strSql);

    rs.next();
    this.TotalItem = rs.getInt(1);

    this.PageNum = PageNum;
    this.PageNumCount = (TotalItem + PageSize - 1) / PageSize; //计算总页数
    System.out.println(PageNumCount);
    sql =
        "SELECT * FROM M_CONTRACT WHERE contractid IN ( SELECT contractid FROM (";
    sql = sql +
        " SELECT ROWNUM AS NUMROW, contractid FROM (select contractid FROM M_CONTRACT ";
    sql = sql + condition + " ORDER BY  CONTRACTRDDATE desc)) WHERE NUMROW > " +
        (PageNum - 1) * PageSize;
    sql = sql + "  AND NUMROW <= " + PageNum * PageSize +
        " ) ORDER BY  CONTRACTRDDATE  desc";

    rs = db.OpenSql(sql);

    ArrayList contractlist = new ArrayList();
    Contract contract = new Contract();

    int i = 0;
    while (rs.next()) {

      contract = ContractOperate.searchContract(db, rs.getInt("contractid"));

      contractlist.add(contract);
      i++;
    }

    return contractlist;

  }

}