Esempio n. 1
0
  public synchronized void service(HttpServletRequest request, HttpServletResponse response)
      throws IOException, ServletException {
    HttpSession dbSession = request.getSession();
    JspFactory _jspxFactory = JspFactory.getDefaultFactory();
    PageContext pageContext =
        _jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
    ServletContext dbApplication = dbSession.getServletContext();

    try {
      HttpSession session = request.getSession();
      PrintWriter out = response.getWriter();
      counter count = new counter(dbApplication);
      nseer_db_backup1 hr_db = new nseer_db_backup1(dbApplication);
      nseer_db_backup1 hr_db1 = new nseer_db_backup1(dbApplication);
      if (hr_db.conn((String) dbSession.getAttribute("unit_db_name"))
          && hr_db1.conn((String) dbSession.getAttribute("unit_db_name"))) {
        String major_first_kind_ID = "";
        String major_first_kind_name = "";
        String major_second_kind_ID = "";
        String major_second_kind_name = "";
        String fileKind_chain = request.getParameter("kind_chain");
        String chain_id = Divide1.getId(fileKind_chain);
        String chain_name = Divide1.getName(fileKind_chain);
        String major_first_kind = request.getParameter("select4");
        StringTokenizer tokenTO4 = new StringTokenizer(major_first_kind, "/");
        while (tokenTO4.hasMoreTokens()) {
          major_first_kind_ID = tokenTO4.nextToken();
          major_first_kind_name = tokenTO4.nextToken();
        }
        String major_second_kind = request.getParameter("select5");
        StringTokenizer tokenTO5 = new StringTokenizer(major_second_kind, "/");
        while (tokenTO5.hasMoreTokens()) {
          major_second_kind_ID = tokenTO5.nextToken();
          major_second_kind_name = tokenTO5.nextToken();
        }
        String register = request.getParameter("register");
        String register_time = request.getParameter("register_time");
        String engage_type = request.getParameter("engage_type");
        String human_amount = request.getParameter("human_amount");
        String deadline = request.getParameter("deadline");
        String bodyc = new String(request.getParameter("remark1").getBytes("UTF-8"), "UTF-8");
        String remark1 = exchange.toHtml(bodyc);
        String bodyb = new String(request.getParameter("remark2").getBytes("UTF-8"), "UTF-8");
        String remark2 = exchange.toHtml(bodyb);
        try {
          int filenum1 = count.read((String) dbSession.getAttribute("unit_db_name"), "hrReleaseID");
          count.write((String) dbSession.getAttribute("unit_db_name"), "hrReleaseID", filenum1);
          String sql =
              "insert into hr_major_release(chain_id,chain_name,release_id,human_major_first_kind_ID,human_major_first_kind_name,human_major_second_kind_ID,human_major_second_kind_name,register,register_time,human_amount,deadline,remark1,remark2,engage_type,check_tag) values ('"
                  + chain_id
                  + "','"
                  + chain_name
                  + "','"
                  + filenum1
                  + "','"
                  + major_first_kind_ID
                  + "','"
                  + major_first_kind_name
                  + "','"
                  + major_second_kind_ID
                  + "','"
                  + major_second_kind_name
                  + "','"
                  + register
                  + "','"
                  + register_time
                  + "','"
                  + human_amount
                  + "','"
                  + deadline
                  + "','"
                  + remark1
                  + "','"
                  + remark2
                  + "','"
                  + engage_type
                  + "','0')";

          hr_db.executeUpdate(sql);

          List rsList1 = GetWorkflow.getList(hr_db, "ecommerce_config_workflow", "06");
          String[] elem1 = new String[3];
          if (rsList1.size() == 0) {
            String sql1 =
                "update hr_major_release set check_tag='1' where chain_id='"
                    + chain_id
                    + "' and chain_name='"
                    + chain_name
                    + "'";
            hr_db.executeUpdate(sql1);
          } else {
            Iterator ite1 = rsList1.iterator();
            while (ite1.hasNext()) {
              elem1 = (String[]) ite1.next();
              sql =
                  "insert into ecommerce_workflow(config_id,object_ID,describe1,describe2,type_id) values ('"
                      + elem1[0]
                      + "','"
                      + filenum1
                      + "','"
                      + elem1[1]
                      + "','"
                      + elem1[2]
                      + "','06')";
              hr_db.executeUpdate(sql);
            }
          }
          hr_db.commit();
          hr_db1.commit();
          hr_db.close();
          hr_db1.close();
          response.sendRedirect("hr/engage/major_release/register_ok_a.jsp");
        } catch (Exception ex) {
          out.println("error" + ex);
        }

      } else {
        response.sendRedirect("error_conn.htm");
      }
    } catch (Exception ex) {
    }
  }
Esempio n. 2
0
  public synchronized void service(HttpServletRequest request, HttpServletResponse response)
      throws IOException, ServletException {
    HttpSession dbSession = request.getSession();
    JspFactory _jspxFactory = JspFactory.getDefaultFactory();
    PageContext pageContext =
        _jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
    ServletContext dbApplication = dbSession.getServletContext();

    try {
      HttpSession session = request.getSession();
      PrintWriter out = response.getWriter();
      businessComment demo = new businessComment();
      demo.setPath(request);
      Email mail = new Email();
      nseer_db_backup1 design_db = new nseer_db_backup1(dbApplication);
      nseer_db_backup1 intrmanufacture_db = new nseer_db_backup1(dbApplication);
      if (design_db.conn((String) dbSession.getAttribute("unit_db_name"))
          && intrmanufacture_db.conn((String) dbSession.getAttribute("unit_db_name"))) {
        String kind_chain = request.getParameter("kind_chain");
        String chain_id = Divide1.getId(kind_chain);
        String chain_name = Divide1.getName(kind_chain);
        String provider_ID =
            NseerId.getId("intrmanufacture/file", (String) dbSession.getAttribute("unit_db_name"));
        String intrmanufacturer = request.getParameter("intrmanufacturer");
        String intrmanufacturer_ID = request.getParameter("intrmanufacturer_ID");
        String provider_name = request.getParameter("provider_name");
        String provider_address = request.getParameter("provider_address");
        String type = request.getParameter("type");
        String provider_class = request.getParameter("class1");
        String used_provider_name = request.getParameter("used_provider_name");
        String provider_bank = request.getParameter("provider_bank");
        String provider_account = request.getParameter("provider_account");
        String provider_web = request.getParameter("provider_web");
        String provider_tel1 = request.getParameter("provider_tel1");
        String provider_fax = request.getParameter("provider_fax");
        String provider_postcode = request.getParameter("provider_postcode");
        String contact_person1 = request.getParameter("contact_person1");
        String contact_person1_department = request.getParameter("contact_person1_department");
        String contact_person1_duty = request.getParameter("contact_person1_duty");
        String contact_person1_sex = request.getParameter("contact_person1_sex");
        String contact_person1_office_tel = request.getParameter("contact_person1_office_tel");
        String contact_person1_home_tel = request.getParameter("contact_person1_home_tel");
        String contact_person1_mobile = request.getParameter("contact_person1_mobile");
        String contact_person1_email = request.getParameter("contact_person1_email");
        String contact_person2 = request.getParameter("contact_person2");
        String contact_person2_department = request.getParameter("contact_person2_department");
        String contact_person2_duty = request.getParameter("contact_person2_duty");
        String contact_person2_sex = request.getParameter("contact_person2_sex");
        String contact_person2_office_tel = request.getParameter("contact_person2_office_tel");
        String contact_person2_home_tel = request.getParameter("contact_person2_home_tel");
        String contact_person2_mobile = request.getParameter("contact_person2_mobile");
        String contact_person2_email = request.getParameter("contact_person2_email");
        String register = request.getParameter("register");
        String register_time = request.getParameter("register_time");
        String bodyc = new String(request.getParameter("invoice_info").getBytes("UTF-8"), "UTF-8");
        String invoice_info = exchange.toHtml(bodyc);
        String bodya =
            new String(request.getParameter("demand_products").getBytes("UTF-8"), "UTF-8");
        String demand_products = exchange.toHtml(bodya);
        try {
          if (!chain_id.equals("")) {
            String sqll =
                "select * from intrmanufacture_file where provider_ID='"
                    + provider_ID
                    + "' and provider_name='"
                    + provider_name
                    + "'";
            ResultSet rset = intrmanufacture_db.executeQuery(sqll);
            if (rset.next()) {
              response.sendRedirect("portal/oem/register1_ok_a.jsp");
            } else {
              String sql =
                  "insert into intrmanufacture_file(chain_id,chain_name,provider_ID,provider_name,provider_address,provider_class,type,provider_bank,provider_account,provider_web,provider_tel1,provider_fax,provider_postcode,used_provider_name,contact_person1,contact_person1_department,contact_person1_duty,contact_person1_sex,contact_person1_office_tel,contact_person1_home_tel,contact_person1_mobile,contact_person1_email,contact_person2,contact_person2_department,contact_person2_duty,contact_person2_sex,contact_person2_office_tel,contact_person2_home_tel,contact_person2_mobile,contact_person2_email,register,register_time,invoice_info,demand_products,check_tag,modify_tag,excel_tag,intrmanufacturer,intrmanufacturer_ID) values ('"
                      + chain_id
                      + "','"
                      + chain_name
                      + "','"
                      + provider_ID
                      + "','"
                      + provider_name
                      + "','"
                      + provider_address
                      + "','"
                      + provider_class
                      + "','"
                      + type
                      + "','"
                      + provider_bank
                      + "','"
                      + provider_account
                      + "','"
                      + provider_web
                      + "','"
                      + provider_tel1
                      + "','"
                      + provider_fax
                      + "','"
                      + provider_postcode
                      + "','"
                      + used_provider_name
                      + "','"
                      + contact_person1
                      + "','"
                      + contact_person1_department
                      + "','"
                      + contact_person1_duty
                      + "','"
                      + contact_person1_sex
                      + "','"
                      + contact_person1_office_tel
                      + "','"
                      + contact_person1_home_tel
                      + "','"
                      + contact_person1_mobile
                      + "','"
                      + contact_person1_email
                      + "','"
                      + contact_person2
                      + "','"
                      + contact_person2_department
                      + "','"
                      + contact_person2_duty
                      + "','"
                      + contact_person2_sex
                      + "','"
                      + contact_person2_office_tel
                      + "','"
                      + contact_person2_home_tel
                      + "','"
                      + contact_person2_mobile
                      + "','"
                      + contact_person2_email
                      + "','"
                      + register
                      + "','"
                      + register_time
                      + "','"
                      + invoice_info
                      + "','"
                      + demand_products
                      + "','0','0','1','"
                      + intrmanufacturer
                      + "','"
                      + intrmanufacturer_ID
                      + "')";
              intrmanufacture_db.executeUpdate(sql);
              String[] email_box = {contact_person1_email};
              mail.send(
                  email_box,
                  "smtp.sina.com.cn",
                  "*****@*****.**",
                  "123456",
                  demo.getLang("erp", "注册信息"),
                  "欢迎您注册成为我们的委外厂商,您的档案编号是:" + provider_ID);

              CdefineUpdate CdefineUpdate = new CdefineUpdate();
              sql =
                  CdefineUpdate.update("intrmanufacture_file", "provider_ID", provider_ID, request);
              intrmanufacture_db.executeUpdate(sql);
              /** ************************************************** */
              List rsList = (List) new java.util.ArrayList();
              String[] elem = new String[3];
              sql =
                  "select id,describe1,describe2 from intrmanufacture_config_workflow where type_id='01'";
              rset = intrmanufacture_db.executeQuery(sql);
              while (rset.next()) {
                elem = new String[3];
                elem[0] = rset.getString("id");
                elem[1] = rset.getString("describe1");
                elem[2] = rset.getString("describe2");
                rsList.add(elem);
              }
              if (rsList.size() == 0) {
                sql =
                    "update intrmanufacture_file set check_tag='1' where provider_ID='"
                        + provider_ID
                        + "'";
                intrmanufacture_db.executeUpdate(sql);
              } else {
                Iterator ite = rsList.iterator();
                while (ite.hasNext()) {
                  elem = (String[]) ite.next();
                  sql =
                      "insert into intrmanufacture_workflow(config_id,object_ID,describe1,describe2) values ('"
                          + elem[0]
                          + "','"
                          + provider_ID
                          + "','"
                          + elem[1]
                          + "','"
                          + elem[2]
                          + "')";
                  intrmanufacture_db.executeUpdate(sql);
                }
              }
              response.sendRedirect(
                  "portal/oem/register1_choose_attachment.jsp?provider_ID=" + provider_ID + "");
            }
          } else {
            response.sendRedirect("portal/oem/register1_ok_b.jsp");
          }
        } catch (Exception ex) {
          out.println("error" + ex);
        }
        intrmanufacture_db.commit();
        design_db.commit();
        intrmanufacture_db.close();
        design_db.close();
      } else {
        response.sendRedirect("error_conn.htm");
      }
    } catch (Exception ex) {
      ex.printStackTrace();
    }
  }