Example #1
0
  private boolean initFordo(IMessage message, String soa_processid) {

    con = null;
    usrno = null;
    usrname = null;
    password = null;
    roleno = null;
    employeeid = null;
    state = null;
    lastupdateuser = null;
    lastupdatetime = null;
    note = null;
    enabled = null;
    oldRoleno = null;

    con = (Connection) message.getOtherParameter("con");
    usrno = message.getUserParameterValue("usrno");
    usrname = message.getUserParameterValue("usrname");
    password = message.getUserParameterValue("password");
    roleno = message.getUserParameterValue("roleno").trim();
    oldRoleno = message.getUserParameterValue("oldRoleno").trim();
    default_roleno = message.getUserParameterValue("default_roleno");
    old_default_roleno = message.getUserParameterValue("old_default_roleno");
    employeeid = message.getUserParameterValue("employeeid");
    state = message.getUserParameterValue("state");
    lastupdateuser = message.getUserParameterValue("lastupdateuser");
    lastupdatetime = message.getUserParameterValue("lastupdatetime");
    note = message.getUserParameterValue("note");
    enabled = message.getUserParameterValue("enabled");
    // 获取运行流程项
    IProcess process = ProcessFactory.getInstance(soa_processid);
    String processInfo = process.getNameSpace() + "." + process.getName();
    String debug_UpdateUser =
        "******"
            + usrno
            + "\n"
            + "usrname = "
            + usrname
            + "\n"
            + "password = "******"\n"
            + "roleno = "
            + roleno
            + "\n"
            + "oldRoleno = "
            + oldRoleno
            + "\n"
            + "default_roleno = "
            + default_roleno
            + "\n"
            + "old_default_roleno = "
            + old_default_roleno
            + "\n"
            + "employeeid = "
            + employeeid
            + "\n"
            + "state = "
            + state
            + "\n\r"
            + "lastupdateuser = "******"\n"
            + "lastupdatetime = "
            + lastupdatetime
            + "\n"
            + "note = "
            + note
            + "\n"
            + "enabled = "
            + enabled
            + "\n";
    log.debug(processInfo + ",修改用户时用户提交的参数: " + debug_UpdateUser);

    if (usrno == null
        || usrname == null
        || password == null
        || roleno == null
        || employeeid == null
        || state == null
        || lastupdateuser == null
        || lastupdatetime == null
        || note == null
        || enabled == null) {
      message.addServiceException(
          new ServiceException(
              ServiceExceptionType.PARAMETERLOST,
              "添加用户时参数为空",
              this.getId(),
              soa_processid,
              new java.util.Date(),
              null));
      log.error(processInfo + ",修改用户,缺少输入参数");
      return false;
    }
    return true;
  }
Example #2
0
  @SuppressWarnings("unchecked")
  public ExecuteResult undoService(IMessage message, String soa_processid) {
    IProcess process = ProcessFactory.getInstance(soa_processid);
    String processInfo = process.getNameSpace() + "." + process.getName();
    Object obj = message.getOtherParameter(this.getClass().getName());
    if (obj instanceof Map) {
      Map<String, String> map = (Map<String, String>) obj;
      String map_usrno = map.get("rs_usrno");
      String map_usrname = map.get("rs_usrname");
      String map_password = map.get("rs_password");
      String map_oldRoleno = map.get("rs_oldRoleno").trim();
      String map_employeeid = map.get("rs_employeeid").trim();
      String map_old_default_roleno = map.get("rs_old_default_roleno");
      String map_state = map.get("rs_state");
      String map_lastupdateuser = map.get("rs_lastupdateuser");
      String map_lastupdatetime = map.get("rs_lastupdatetime");
      String map_note = map.get("rs_note");
      String map_enabled = map.get("rs_enabled");
      String map_debug =
          "map_usrno = "
              + map_usrno
              + "\n"
              + "map_usrname = "
              + map_usrname
              + "\n"
              + "map_password = "******"\n"
              + "map_oldRoleno = "
              + map_oldRoleno
              + "\n"
              + "map_employeeid = "
              + map_employeeid
              + "\n"
              + "map_state = "
              + map_state
              + "\n"
              + "map_lastupdateuser = "******"\n"
              + "map_lastupdatetime = "
              + map_lastupdatetime
              + "\n"
              + "map_note = "
              + map_note
              + "\n"
              + "map_enabled = "
              + map_enabled;
      log.debug(processInfo + "修改用户回退操作Map接收的所有信息为: map_debug = " + map_debug);
      try {
        Statement stmt = null;
        try {
          IDAO_UserManager dao =
              DAOFactory_UserManager.getInstance(DataBaseType.getDataBaseType(con));
          if (dao == null) {
            message.addServiceException(
                new ServiceException(
                    ServiceExceptionType.UNKNOWNDATABASETYPE,
                    "",
                    this.getId(),
                    soa_processid,
                    new Date(),
                    null));
            log.error(processInfo + ",修改用户回退操作,加载数据库错误,未知的数据库类型");
            return ExecuteResult.fail;
          }
          log.debug(processInfo + ",修改用户回退操作,加载数据库成功");
          stmt = con.createStatement();
          String undo_sql_update;
          // password be changed
          if (!password.equals("********")) {
            undo_sql_update =
                dao.getSQL_UpdateUser(
                    map_usrno,
                    map_usrname,
                    map_password,
                    map_employeeid,
                    map_state,
                    map_lastupdateuser,
                    map_lastupdatetime,
                    map_note,
                    map_enabled);
          } else // password not changed
          {
            undo_sql_update =
                dao.getSQL_UpdateUser(
                    map_usrno,
                    map_usrname,
                    map_employeeid,
                    map_state,
                    map_lastupdateuser,
                    map_lastupdatetime,
                    map_note,
                    map_enabled);
          }
          log.debug("修改用户回退操作的sql语句: undo_sql_update = " + undo_sql_update);
          stmt.executeUpdate(undo_sql_update);

          String sql_deleteDataUserRole = "";
          String sql_insertDataUserRole = "";

          String[] role_old = map_oldRoleno.split(":");
          sql_deleteDataUserRole = dao.getSQL_DeleteDataUserRole(new Integer(map_usrno));
          log.debug("根据角色号,删除新角色号的sql语句:sql_deleteDataUserRole = " + sql_deleteDataUserRole);
          stmt.executeUpdate(sql_deleteDataUserRole);
          for (String ch : role_old) {
            if (ch != null && !ch.equals("")) {
              if (map_old_default_roleno.equals(ch)) {
                sql_insertDataUserRole =
                    dao.getSQL_insertDataUserRole(new Integer(usrno), new Integer(ch), "0");
              } else {
                sql_insertDataUserRole =
                    dao.getSQL_insertDataUserRole(new Integer(usrno), new Integer(ch), "1");
              }
              log.debug(
                  "插入原有角色号data_user_role表的sql语句: sql_insertDataUserRole = "
                      + sql_insertDataUserRole);
              stmt.executeUpdate(sql_insertDataUserRole);
            }
          }

        } catch (SQLException sqle) {
          message.addServiceException(
              new ServiceException(
                  ServiceExceptionType.DATABASEERROR,
                  "数据库错误" + sqle,
                  this.getId(),
                  soa_processid,
                  new Date(),
                  sqle));
          log.fatal(processInfo + ",修改用户,数据库操作异常" + sqle.toString());
          return ExecuteResult.fail;
        } finally {
          if (stmt != null) stmt.close();
        }
      } catch (Exception e) {
        message.addServiceException(
            new ServiceException(
                ServiceExceptionType.UNKNOWN,
                e.toString(),
                this.getId(),
                soa_processid,
                new java.util.Date(),
                e));
        log.fatal(processInfo + ",修改用户,未知异常" + e.toString());
        return ExecuteResult.fail;
      }
    }
    return ExecuteResult.sucess;
  }