contracttree.java

完整的合同管理信息系统

package com.ICT.AFC.contracttree.beans;

import com.ICT.AFC.DB.DB;
import java.lang.*;
import java.sql.*;
import com.ICT.AFC.user.beans.User;
import javax.servlet.http.HttpSession;
import com.sun.corba.se.internal.core.Request;
import org.apache.struts.action.*;
import javax.servlet.http.*;
import javax.servlet.ServletContext;

public class ContractTree {

  private String contractIsSell;
  private String contractMonth;
  private String contractName;
  private String contractNode;
  private String contractSource;
  private String contractYear;
  private int divNum;
  private int isSupper;
  private String fatherIsSell;
  private String fatherSource;
  private String fatherYear;
  private String fatherMonth;
  private String fatherNode;

  public String getContractIsSell() {
    return contractIsSell;
  }

  public void setContractIsSell(String contractIsSell) {
    this.contractIsSell = contractIsSell;
  }

  public String getContractMonth() {
    return contractMonth;
  }

  public void setContractMonth(String contractMonth) {
    this.contractMonth = contractMonth;
  }

  public String getContractName() {
    return contractName;
  }

  public void setContractName(String contractName) {
    this.contractName = contractName;
  }

  public String getContractNode() {
    return contractNode;
  }

  public void setContractNodeId(String contractNode) {
    this.contractNode = contractNode;
  }

  public String getContractSource() {
    return contractSource;
  }

  public void setContractSource(String contractSource) {
    this.contractSource = contractSource;
  }

  public String getContractYear() {
    return contractYear;
  }

  public void setContractYear(String contractYear) {
    this.contractYear = contractYear;
  }

  public int getDivNum() {
    return divNum;
  }

  public void setDivNum(int divNum) {
    this.divNum = divNum;
  }

  public String getFatherNode() {
    return fatherNode;
  }

  public void setFatherNodeId(String fatherNode) {
    this.fatherNode = fatherNode;
  }

  public int getIsSupper() {
    return isSupper;
  }

  public void setIsSupper(int isSupper) {
    this.isSupper = isSupper;
  }

  public String getFatherIsSell() {
    return fatherIsSell;
  }

  public void setFatherIsSell(String fatherIsSell) {
    this.fatherIsSell = fatherIsSell;
  }

  public String getFatherSource() {
    return fatherSource;
  }

  public void setFatherSource(String fatherSource) {
    this.fatherSource = fatherSource;
  }

  public String getFatherYear() {
    return fatherYear;
  }

  public void setFatherYear(String fatherYear) {
    this.fatherYear = fatherYear;
  }

  public String getFatherMonth() {
    return fatherMonth;
  }

  public void setFatherMonth(String fatherMonth) {
    this.fatherMonth = fatherMonth;
  }

  public static String getTree(DB db, User user) throws Exception {
    String sql = "";
    String dbstr;
    String departmentName = "";
    String departmentID = "";
    ResultSet rs = null;
    int i = 0, j = 0, k = 0;
    int h=1;
    dbstr = "";
    String userdep = user.getUserDepID();
    String userroleid = user.getUserRole();
    sql = "select * from V_CONTRACTTREE order by NODEID";

    try {
      rs = db.OpenSql(sql);
    }
    catch (Exception e) {
      System.out.print("Exception:" + e);
    }
    int tempDiv = 0;
    while (rs.next()) {
      String contractissell = rs.getString("CONTRACTISSELL");
      departmentID = new String(rs.getString("DEPID").trim().
                                getBytes("8859_1"), "gb2312");
      departmentName = rs.getString("CONTRACTNAME");
      String is_supper = rs.getString("ISSUPER").trim();
      int divnum = rs.getInt("DIVNUM");
      if (is_supper.equals("1")
          && divnum == 0) {
        for (j = 0; j <= k; j++) {
          if (i != 0) {
            dbstr += "</div>";
          }
        }
        dbstr +=
            "<p style='word-spacing: 0; margin-top: 0; margin-bottom: 0' class='p11'>";
        dbstr += "</font> ";
        if (h==1){dbstr += "<img border='0' src='img/button-1.jpg' width='150' height='30' onclick=exportdiv(goodlist";}
        else{dbstr += "<img border='0' src='img/button-2.jpg' width='150' height='30' onclick=exportdiv(goodlist";}
        dbstr += java.lang.String.valueOf(i);
        dbstr += ") style='cursor:hand'></p>";
        dbstr += " <div id=goodlist";
        dbstr += java.lang.String.valueOf(i);
        dbstr += "  class='child' style='position:relative;display:block'> ";
        h=h+1;
      }
      else {
        if (is_supper.equals("1")) {
          if (tempDiv - divnum >= 1) {
            for (int ii = 0; ii < (tempDiv - divnum); ii++) {
              dbstr += "</div>";
            }
          }
          if (userroleid.equals("2")) {
            dbstr +=
                "<p style='word-spacing: 0; margin-top: 0; margin-bottom: 0' class='p11'> ";
            for (j = 0; j < divnum; j++) {
              dbstr +=
                  " <img border='0' src='img/space.jpg' width='8' height='8'>";
            }
            dbstr += " <img border='0' src='img/midplus.gif' width='33' height='23' name='mp' onclick=exportdiv(goodlist";
            dbstr += java.lang.String.valueOf(i);
            dbstr += ") style='cursor:hand'>";
            dbstr += " <a href='searchContractByYear.do?contractRdDate=";
            dbstr += departmentName.substring(0, departmentName.length() - 1);
            dbstr += "&contractIsSell=";
            dbstr += contractissell;
            dbstr += "' onclick=exportdiv(goodlist";
            dbstr += java.lang.String.valueOf(i);
            dbstr += ") style='cursor:hand' target='rightFrame'><font size='2'>";
            dbstr += departmentName;
            dbstr += "</font></a></p>";
            dbstr += " <div id=goodlist";
            dbstr += java.lang.String.valueOf(i);
            dbstr += "  class='child' style='position:relative;display:block'> ";
            k++;
          }
          else {
            dbstr +=
                "<p style='word-spacing: 0; margin-top: 0; margin-bottom: 0' class='p11'> ";
            for (j = 0; j < divnum; j++) {
              dbstr +=
                  " <img border='0' src='img/space.jpg' width='8' height='8'>";
            }
            dbstr += " <img border='0' src='img/midplus.gif' width='33' height='23' name='mp' onclick=exportdiv(goodlist";
            dbstr += java.lang.String.valueOf(i);
            dbstr += ") style='cursor:hand'>";
            dbstr += " <a onclick=exportdiv(goodlist";
            //dbstr += " <a href='searchContractByYear.do?contractRdDate=";
            //dbstr += departmentName.substring(0, departmentName.length() - 1);
            //dbstr += "&contractIsSell=";
            //dbstr += contractissell;
            //dbstr += "&departmentID=";
            //dbstr += departmentID;
            //dbstr += "' onclick=exportdiv(goodlist";
            dbstr += java.lang.String.valueOf(i);
            dbstr +=
                ") style='cursor:hand' target='rightFrame'><font size='2'>";
            dbstr += departmentName;
            dbstr += "</font></a></p>";
            dbstr += " <div id=goodlist";
            dbstr += java.lang.String.valueOf(i);
            dbstr += "  class='child' style='position:relative;display:block'> ";
            k++;

          }
        }
        else {

          if (userroleid.equals("2")) {
            dbstr +=
                " <p style='word-spacing: 0; margin-top: 0; margin-bottom: 0' class='p10'> ";
            for (j = 0; j < divnum; j++) {
              dbstr +=
                  " <img border='0' src='img/space.gif' width='8' height='8'>";
            }
            dbstr +=
                " <img border='0' src='img/midminus.gif' width='33' height='23'>";
            dbstr += " <a href='searchDepartmentAction.do?departmentID=";
            dbstr += departmentID;
            dbstr += "&contractIsSell=";
            dbstr += contractissell;
            dbstr += "' target='rightFrame'>";
            dbstr += departmentName;
            dbstr += "</a></font></p>";

          }

          else if (userdep.equals(departmentID)) {

            dbstr +=
                " <p style='word-spacing: 0; margin-top: 0; margin-bottom: 0' class='p10'> ";
            for (j = 0; j < divnum; j++) {
              dbstr +=
                  " <img border='0' src='img/space.gif' width='8' height='8'>";
            }
            dbstr +=
                " <img border='0' src='img/midminus.gif' width='33' height='23'>";
            dbstr += " <a href='searchDepartmentAction.do?departmentID=";
            dbstr += departmentID;
            dbstr += "&contractIsSell=";
            dbstr += contractissell;
            dbstr += "' target='rightFrame'>";
            dbstr += departmentName;
            dbstr += "</a></font></p>";
          }
        }
      }
      tempDiv = divnum;
      i = i + 1;
    }

    return dbstr;
  }

}