/**
   * 获得公司的分部
   *
   * @param con
   * @param company_code
   * @return
   * @throws SQLException
   */
  private static java.util.List<JUnit> getChildBranch(Connection con, String company_code)
      throws SQLException {
    java.util.List<JUnit> lsBranch = new java.util.ArrayList<JUnit>();
    java.sql.PreparedStatement pstmt = null;
    ResultSet rs = null;
    String sql = null;

    sql =
        "select unit_id from t_unit "
            + " where (parent_code =? or parent_code =?) and is_branch = 1 "
            + " order by unit_index ";
    pstmt = con.prepareStatement(sql);
    pstmt.setString(1, company_code);
    pstmt.setString(2, company_code + ".LX");
    rs = pstmt.executeQuery();
    while (rs.next()) {
      JUnit uObj = JUnit.getUnit(rs.getString("unit_id"));
      lsBranch.add(uObj);
    }
    /*
    if(lsBranch.size() == 0)
    {
    	lsBranch.add(JUnit.getUnitByCode(company_code));
    }*/
    rs.close();
    pstmt.close();
    return lsBranch;
  }
  public JCompany getCompanyById(String com_id) {
    if (com_id == null || com_id.length() == 0) return null;

    if (JUnit.getUnit(com_id) == null) {
      Exception e = new Exception("部门没找到 com_id=" + com_id);
      JLog.getLogger().error("", e);
      return null;
    }
    String code = JUnit.getUnit(com_id).getUnit_code();

    if (mapCompany.get(code) == null) {
      try {
        loadCompany(code);
      } catch (Exception e) {
        JLog.getLogger().error("", e);
      }
    }
    return mapCompany.get(code);
  }