ordermanagerimpl.java

为交课程设计

      condition += e.nextElement() + " AND ";
    }

    condition = condition.substring(0, condition.length() - 4);

    sql = header + sfield + from + table + condition;
    System.out.println(sql);

    final ArrayList al = new ArrayList();
    DBUtil.ProccessSql(conn, sql, new ResultHandler() {
      public void proccess(ResultSet rs) throws Exception {
        searchResult sr = new searchResult();
        sr.setOrder_id(rs.getString("order_id"));
        sr.setCustomer_name(rs.getString("customer_name"));
        sr.setPerson_name(rs.getString("responsibility_by"));
        if (rs.getString("orderstatus_id").equalsIgnoreCase("0")) {
          sr.setOrderstatus_name("0");
        }
        else {
          sr.setOrderstatus_name("1");
        }
        al.add(sr);
      }
    });
    return al;
  }

  public boolean updateOrder(OrderActionForm obj) throws Exception {
    if (conn == null) {
      conn = new DBConnection(2);
    }
    return false;
  }

  public List sortOrder(String strwhere, int currentpage, int pagesize) throws
      Exception {
    if (conn == null) {
      conn = new DBConnection(2);
    }
    return null;
  }

  public List viewOrder(String orderid) throws Exception {
    if (conn == null) {
      conn = new DBConnection(2);
    }

    String condition = " AND o.job_type=t.jobtype_id AND o.job_position=p.jobposition_id AND o.major=m.major_id AND o.customer_id=c.customer_id  AND o.degree=d.degree_id";
    String sql = "SELECT o.*,t.jobtype_name,p.jobposition_name,m.major_name,c.customer_name,d.degree_name FROM o_order AS o,i_jobtype AS t,i_jobposition AS p,i_degree AS d,i_major AS m,o_customer AS c WHERE " +
        "order_id=" + orderid;
    sql = sql + condition;
    System.out.println(sql);
    final Order order = new Order();
    final List list = new ArrayList();
    DBUtil.ProccessSql(conn, sql, new ResultHandler() {
      public void proccess(ResultSet rs) throws Exception {

        order.setOrder_id(rs.getLong("order_id"));
        order.setBelongto(rs.getString("belongto"));
        order.setStart_time(rs.getString("start_time"));
        order.setFinish_time(rs.getString("finish_time"));

        order.setDepartment_name(rs.getString("department_name"));
        order.setResponsibility_by(rs.getString("responsibility_by"));
        order.setResponsibility_by_address(rs.getString(
            "responsibility_by_address"));
        order.setResponsibility_by_phone(rs.getString("responsibility_by_phone"));
        order.setResponsibility_by_fax(rs.getString("responsibility_by_fax"));
        order.setResponsibility_by_email(rs.getString("responsibility_by_email"));
        order.setBelongto_department(rs.getString("belongto_department"));

        order.setAge_from(rs.getInt("age_from"));
        order.setAge_to(rs.getInt("age_to"));

        order.setNumber(rs.getString("number"));

        order.setSex(rs.getString("sex"));
        order.setNationality(rs.getString("nationality"));
        order.setRegistered_residence(rs.getString("registered_residence"));

        order.setLanguage_japanese_level(rs.getString("language_japanese_level"));
        order.setLanguage_english_level(rs.getString("Language_english_level"));
        order.setDetail_work_todo(rs.getString("detail_work_todo"));
        order.setRequest_skill_work_expericence(rs.getString(
            "request_skill_work_expericence"));
        order.setRequest_competency(rs.getString("request_competency"));
        order.setOther_competency(rs.getString("other_competency"));
        order.setSalary_from(rs.getString("salary_from"));
        order.setSalary_to(rs.getString("salary_to"));
        order.setProbationership_month(rs.getString("probationership_month"));
        order.setBonus(rs.getString("bonus"));
        order.setSub(rs.getString("sub"));

        order.setOrderstatus_id(rs.getString("orderstatus_id"));
        order.setOther_things(rs.getString("other_things"));
        order.setInputer(rs.getString("inputer"));
        order.setBargain_month(rs.getInt("bargain_month"));
        order.setSub_housing(rs.getString("sub_housing"));
        order.setSub_traffic(rs.getString("sub_traffic"));
        // id convert to name
        order.setJob_type(rs.getString("jobtype_name"));
        order.setJob_position(rs.getString("jobposition_name"));
        order.setDegree(rs.getString("degree_name"));
        order.setMajor(rs.getString("major_name"));
        order.setCustomer_id(rs.getString("customer_name"));
        //list.add(order);
      }
    });
    String sql2 =
        "SELECT welfare_detail_name FROM o_w_welfare_detail WHERE order_id='" +
        orderid + "'";

    final List list1 = new ArrayList();
    DBUtil.ProccessSql(conn, sql2, new ResultHandler() {
      public void proccess(ResultSet rs) throws Exception {
        list1.add(rs.getString("welfare_detail_name"));
      }
    });
    Iterator it = list1.iterator();
    int i = 0;
    StringBuffer bf = new StringBuffer();
    //String welf[] = new String[list1.size()];
    while (it.hasNext()) {
      //welf[i] =(String)it.next();
      // i++;
      bf.append( (String) it.next());
      bf.append(" ");
    }
    order.setFuli1(bf.toString());
    list.add(order);
    return list;

  }

  //write by whzhang
  public List showDetail(int temp) throws Exception {
    //orderId = 2;
    final int orderId = temp;
    final List ls = new ArrayList();
    if (conn == null) {
      conn = new DBConnection(2);
    }
    String sql = "select * from o_order where order_id=" + orderId;
    String sql_fuli = "select * from o_w_welfare_detail where order_id" +
        orderId;
    final OrderActionForm order = new OrderActionForm();
    try {
      DBUtil.ProccessSql(conn, sql, new ResultHandler() {
        public void proccess(ResultSet rs) throws Exception {

          order.setOrder_id(orderId);
          order.setBelongto(rs.getString("belongto"));
          order.setStart_time(rs.getString("start_time"));
          order.setFinish_time(rs.getString("finish_time"));
          order.setHas_done(rs.getString("has_done"));
          order.setWill_do(rs.getString("will_do"));
          order.setDepartment_name(rs.getString("department_name"));
          order.setResponsibility_by(rs.getString("responsibility_by"));
          order.setResponsibility_by_address(rs.getString(
              "responsibility_by_address"));
          order.setResponsibility_by_phone(rs.getString(
              "responsibility_by_phone"));
          order.setBelongto_department(rs.getString("belongto_department"));
          order.setJobtype_name(rs.getString("job_type"));
          order.setAge_from(rs.getInt("age_from"));
          order.setAge_to(rs.getInt("age_to"));
          order.setWorkplace(rs.getString("workplace"));
          order.setStart_work_time(rs.getString("start_work_time"));
          order.setNumber(rs.getString("number"));
          order.setJobpositionname(rs.getString("job_position"));
          order.setSex(rs.getString("sex"));
          order.setNationality(rs.getString("nationality"));
          order.setRegistered_residence(rs.getString("registered_residence"));
          order.setDegree(rs.getString("degree"));
          order.setMajorname(rs.getString("major"));
          order.setLanguage_japanese_level(rs.getString(
              "language_japanese_level"));
          order.setLanguage_english_level(rs.getString("language_englih_level"));
          order.setDetail_work_todo(rs.getString("detail_work_todo"));
          order.setRequest_skill_work_expericence(rs.getString(
              "request_skill_work_expericence"));
          order.setRequest_competency(rs.getString("request_competency"));
          order.setOther_competency(rs.getString("other_competency"));
          //order.setSalary_method(rs.getString("salary_method"));
          order.setProbationership_month(rs.getString("probationership_month"));
          order.setBonus(rs.getString("bonus"));
          order.setCustomer_id(rs.getString("customer_id"));
          order.setOrderstatus_id(rs.getString("orderstatus_id"));
          order.setOther_things(rs.getString("other_things"));
          order.setInputer(rs.getString("inputer"));
          order.setResponsibility_by_fax(rs.getString("responsibility_by_fax"));
          order.setResponsibility_by_email(rs.getString(
              "responsibility_by_email"));
          order.setSalary_from(rs.getString("salary_from"));
          order.setSalary_to(rs.getString("salary_to"));
          order.setResponsibility_by_email(rs.getString(
              "responsibility_by_email"));
          order.setResponsibility_by_fax(rs.getString("responsibility_by_fax"));
          order.setBargin_month(rs.getString("bargain_month"));
          //ls.add(order);
        }

      });
      final List fuli_list = new ArrayList();
      DBUtil.ProccessSql(conn, sql_fuli, new ResultHandler() {
        public void proccess(ResultSet rs) throws Exception {
          fuli_list.add(rs.getString("welfare_detail_name"));
        }
      });
      String[] fuli = this.ListToArray(fuli_list);
      order.setFuli(fuli);
      ls.add(order);

    }
    catch (Exception e) {}
    return ls;
  }

  public boolean UpdateOrder(String orderId, OrderActionForm temp) throws
      Exception {
    //int orderId = 10;
    if (conn == null) {
      conn = new DBConnection(2);
    }

    final OrderActionForm order = temp; //new Order();
    String update = "update o_order set belongto=? , " +
        " department_name=? ,  responsibility_by=? " +
        ",  responsibility_by_address=? ,  responsibility_by_phone=? ,  belongto_department=? " +
        ",  job_type=? ,  age_from=? ,  age_to=? ,  number=? " +
        ",  job_position=? ,  sex=? ,  nationality=? ,  registered_residence=? ,  degree=? " +
        ",  major=? ,  language_japanese_level=? ,  language_english_level=? " +
        ",  detail_work_todo=? ,  request_skill_work_expericence=? " +
        ",  request_competency=? , other_competency=? , " +
        " probationership_month=? ,  bonus=? ,  customer_id=? ,  orderstatus_id=? ,  " +
        "other_things=? ,responsibility_by_fax=?,responsibility_by_email=?,salary_from=?,salary_to=?,sub=?," +
        "inputer=?,bargain_month=?,sub_housing=?,sub_traffic=? where order_id=" +
        orderId;
    System.out.println(update);
    String del = "delete from o_w_welfare_detail where order_id=" + orderId;
    try {
      DBUtil.ProccessPreparedStatement(conn, update,
                                       new PreparedStmtementHandler() {
        public void proccess(PreparedStatement pstmt) throws Exception {
          pstmt.setString(1, order.getBelongto());
          //System.out.println(order.getBelongto());
          pstmt.setString(2, order.getDepartment_name());
          pstmt.setString(3, order.getResponsibility_by());
          pstmt.setString(4, order.getResponsibility_by_address());
          pstmt.setString(5, order.getResponsibility_by_phone());
          pstmt.setString(6, order.getBelongto_department());
          pstmt.setString(7, order.getJobtype_id());
          pstmt.setInt(8, order.getAge_from());
          pstmt.setInt(9, order.getAge_to());
          //pstmt.setString(10, order.getWorkplace());
          pstmt.setString(10, order.getNumber());
          pstmt.setString(11, order.getJobposition_id());
          pstmt.setString(12, order.getSex());
          pstmt.setString(13, order.getNationality());
          pstmt.setString(14, order.getRegistered_residence());
          pstmt.setString(15, order.getDegree());
          pstmt.setString(16, order.getMajor_id());
          pstmt.setString(17, order.getLanguage_japanese_level());
          pstmt.setString(18, order.getLanguage_english_level());
          pstmt.setString(19, order.getDetail_work_todo());
          pstmt.setString(20, order.getRequest_skill_work_expericence());
          pstmt.setString(21, order.getRequest_competency());
          pstmt.setString(22, order.getOther_competency());
          pstmt.setString(23, order.getProbationership_month());
          pstmt.setString(24, order.getBonus());
          pstmt.setString(25, order.getCustomer_id());
          pstmt.setString(26, order.getOrderstatus_id());
          pstmt.setString(27, order.getOther_things());
          pstmt.setString(28, order.getResponsibility_by_fax());
          pstmt.setString(29, order.getResponsibility_by_email());
          pstmt.setString(30, order.getSalary_from());
          pstmt.setString(31, order.getSalary_to());
          pstmt.setString(32, order.getSub());
          pstmt.setString(33, order.getInputer());
          pstmt.setString(34, order.getBargin_month());
          pstmt.setString(35, order.getSub_housing());
          pstmt.setString(36, order.getSub_traffic());

        }

      });
      DBUtil.ProccessPreparedStatement(conn, del);

      //取得福利
      String[] temp_fuli = order.getFuli();
      String temp_fuli1 = order.getFuli1();
      String temp_fuli2 = order.getFuli2();
      String temp_fuli3 = order.getFuli3();
      List temp_list = new ArrayList();
      temp_list = this.ArrayToList(temp_fuli);
      temp_list.add(temp_fuli1);
      //temp_fuli2 = new String(temp_fuli2.getBytes("ISO8859_1"));
      temp_list.add(temp_fuli2);
      temp_list.add(temp_fuli3);
      final List fuli_list = temp_list; //order.getFuli();

      final long temp_orderId = Long.parseLong(orderId);
      for (int i = 0; i < fuli_list.size(); i++) {
        final int t = i;
        String insert_fuli =
            "insert into o_w_welfare_detail(order_id,welfare_detail_name) values(?,?)";
        DBUtil.ProccessPreparedStatement(conn, insert_fuli,
                                         new PreparedStmtementHandler() {
          public void proccess(PreparedStatement pstmt) throws Exception {

            pstmt.setLong(1, temp_orderId);
            pstmt.setString(2, (String) fuli_list.get(t));

          }

        });

      }

    }
    catch (Exception e) {
      System.out.print(e.toString());
    }
    return true;
    //return update;
  }

  public List listOrder() throws Exception {
    conn = null;
    conn = new DBConnection(2);

    final List ls = new ArrayList();
    String sql = "select * from o_order";
    try {
      DBUtil.ProccessSql(conn, sql, new ResultHandler() {
        public void proccess(ResultSet rs) throws Exception {
          Order order = new Order();
          order.setOrder_id(rs.getInt("order_id"));
          order.setInputer(rs.getString("belongto"));
          order.setCustomer_id(rs.getString("customer_id"));
          if (rs.getString("orderstatus_id").equalsIgnoreCase("0")) {
            order.setOrderstatus_id(new String("未完成".getBytes("GB2312")));
          }
          else {
            order.setOrderstatus_id(new String("已完成".getBytes("GB2312")));
          }
          ls.add(order);
        }
      });
    }
    catch (Exception e) {}
    return ls;
  }

  public String[] ListToArray(List list) throws Exception {
    String[] temp = new String[list.size()];
    for (int i = 0; i < list.size(); i++) {
      temp[i] = (String) list.get(i);
    }

    return temp;
  }

  public List ArrayToList(String[] array) throws Exception {
    List ls = new ArrayList();

    for (int i = 0; i < array.length; i++) {
      ls.add(array[i]);
    }
    return ls;
  }

  // by zeb 03.31
  public List viewOrderAdv(String order_id) throws Exception {
    DBConnection dbconn = new DBConnection(2);
    final List ls = new ArrayList();
    final viewAdv view = new viewAdv();
    String sql =
        "SELECT o.order_id,o.start_time,o.finish_time,c.customer_name," +
        "o.belongto,t.jobtype_name,o.number FROM o_order AS o,o_customer AS c,i_jobtype AS t " +
        "WHERE o.customer_id=c.customer_id AND o.job_type=t.jobtype_id AND o.order_id=" +
        order_id;

    DBUtil.ProccessSql(dbconn, sql, new ResultHandler() {
      public void proccess(ResultSet rs) throws Exception {

        view.setOrder_id(rs.getLong("order_id"));
        view.setStart_time(rs.getString("start_time"));
        view.setFinish_time(rs.getString("finish_time"));
        view.setCustomer_name(rs.getString("customer_name"));
        view.setBelongto(rs.getString("belongto"));
        view.setJobtype_name(rs.getString("jobtype_name"));