usermanager.java

一个完整的

  {
    String strReturnValue = "";
    Vector vt = SQLManager.GetResultSet("SELECT b.Number FROM " + TableName +
                                        " as a left outer join PersonnelInfo as b on (a.PersonnelID=b.ID) where a.ID="
                                        + iUserID + " ORDER BY a.ID");
    if (vt.size() > 0)
    {
      strReturnValue = ( (Vector) vt.get(0)).get(0).toString();
    }
    return strReturnValue;
  }

  /**
   * 通过用户ID获取员工职务
   * @param iUserID  用户ID
   * @return  员工职务
   */
  public static String getPlaceNameByUserID(int iUserID)
  {
    String strReturnValue = "职务未知";
    Vector vt = SQLManager.GetResultSet("SELECT c.PlaceName FROM " + TableName + " as a left outer join PersonnelInfo as b on (a.PersonnelID=b.ID) left outer join PlaceInfo as c on (b.PlaceID=c.ID) where a.ID=" +
                                        iUserID + " ORDER BY a.ID");
    if (vt.size() > 0)
    {
      strReturnValue = ( (Vector) vt.get(0)).get(0).toString();
    }
    return strReturnValue;
  }

  /**
   * 通过用户ID获取部门名称
   * @param iUserID  用户ID
   * @return  员工所属部门名称
   */
  public static String getDepartmentNameByUserID(int iUserID)
  {
    String strReturnValue = SystemParament.GetSystemName();
    Vector vt = SQLManager.GetResultSet("SELECT c.Name FROM " + TableName + " as a left outer join PersonnelInfo as b on (a.PersonnelID=b.ID) left outer join DepartmentInfo as c on (b.DepartmentID=c.ID) where a.ID=" +
                                        iUserID + " ORDER BY a.ID");
    if (vt.size() > 0)
    {
      strReturnValue = ( (Vector) vt.get(0)).get(0).toString();
    }
    return strReturnValue;
  }

  /**
   * 通过用户ID获取部门ID
   * @param iUserID  用户ID
   * @return  员工所属部门ID
   */
  public static String getDepartmentIDByUserID(int iUserID)
  {
    String strReturnValue = SystemParament.GetSystemName();
    Vector vt = SQLManager.GetResultSet("SELECT c.ID FROM " + TableName + " as a left outer join PersonnelInfo as b on (a.PersonnelID=b.ID) left outer join DepartmentInfo as c on (b.DepartmentID=c.ID) where a.ID=" +
                                        iUserID + " ORDER BY a.ID");
    if (vt.size() > 0)
    {
      strReturnValue = ( (Vector) vt.get(0)).get(0).toString();
    }
    return strReturnValue;
  }

  /**
   * 通过用户ID获取用户角色名称
   * @param iUserID  用户ID
   * @return 用户角色名称
   */
  public static String getRoleNameByUserID(int iUserID)
  {
    String strReturnValue = "未知角色";
    Vector vt = SQLManager.GetResultSet("SELECT b.RoleName FROM " + TableName +
                                        " as a left outer join RoleInfo as b on (a.RoleID=b.ID) where a.ID=" +
                                        iUserID + " ORDER BY a.ID");
    if (vt.size() > 0)
    {
      strReturnValue = ( (Vector) vt.get(0)).get(0).toString();
    }
    return strReturnValue;
  }

  /**
   * 修改用户密码
   * @param strUserName 用户名
   * @param strOldPassword  旧密码
   * @param strNewPassword  新密码
   * @return  错误代码
   */
  public static int changeUserPassword(String strUserName, String strOldPassword, String strNewPassword)
  {
    strNewPassword = StringNew.getEncodePassword(strNewPassword);
    int iReturnValue = CheckLogin(strUserName, strOldPassword);
    if (iReturnValue < 1)
    {
      return -4;
    }
    return SQLManager.ExcuteSQL("Update " + TableName + " set Password='" + strNewPassword + "' where ID="
                                + iReturnValue);
  }

  /**
   * 获取用户列表数据向量集
   * @return  用户列表数据向量集
   */
  public static Vector getUserTreeData()
  {
    Vector vc = new Vector();
    vc = SQLManager.GetResultSet("select a.ID,b.Name,b.DepartmentID,b.Number,c.Station from UserInfo as a left outer join PersonnelInfo as b on (a.PersonnelID=b.ID) left outer join DepartmentInfo as c on(c.ID=b.DepartmentID) where b.Name<>'' and (not b.Number like '%离职%') order by b.Number,b.ID,a.ID");
    return vc;
  }

  /**
   * 获取所有用户FTP用户名、密码数据
   * @return 所有用户FTP用户名、密码数据
   */
  public static Vector getAllUserFTPData()
  {
    return SQLManager.GetResultSet("Select a.ID,b.Name,b.Number,a.FTPUserName,a.FTPPassword from " + TableName
      + " as a left outer join PersonnelInfo as b on (a.PersonnelID = b.ID) order by b.Number,b.ID,a.ID");
  }

  /**
   * 获取指定用户的FTP用户名、密码
   * @param iUserID 用户ID
   * @return 指定用户的FTP用户名、密码
   */
  public static Vector getUserFTPData(int iUserID)
  {
    return SQLManager.GetResultSet("Select FTPUserName,FTPPassword from " + TableName + " where ID=" + iUserID);
  }

  /**
   * 设置指定用户的FTP用户名、密码
   * @param iUserID 用户ID
   * @param strFTPUserName FTP用户名
   * @param strFTPPassword FTP密码
   * @return 错误代码
   */
  public static int updateUserFTPData(int iUserID, String strFTPUserName, String strFTPPassword)
  {
    Vector vt = SQLManager.GetResultSet("Select * from " + TableName + " where ID=" + iUserID);
    if (vt.size() > 0)
    {
      strFTPUserName = strFTPUserName.replaceAll("'", "''");
      strFTPPassword = strFTPPassword.replaceAll("'", "''");
      return SQLManager.ExcuteSQL("Update " + TableName + " set FTPUserName='" + strFTPUserName + "',FTPPassword='"
                                  + strFTPPassword + "' where ID=" + iUserID);
    }
    else
    {
      /**
       * 该用户不存在
       */
      return -1;
    }
  }

  /**
   * 获取指定用户的风格ID
   * @param iUserID 用户ID
   * @return 指定用户的风格ID
   */
  public static int getUserStyleID(int iUserID)
  {
    try
    {
      Vector vt = SQLManager.GetResultSet("Select StyleID from " + TableName + " where ID=" + iUserID);
      if (vt.size() > 0)
      {
        String strStyle = ( (Vector) vt.get(0)).get(0).toString();
        if (strStyle.length() > 0)
        {
          return Integer.parseInt(strStyle);
        }
        else
        {
          return 0;
        }
      }
      else
      {
        return 0;
      }
    }
    catch (Exception err)
    {
      return 0;
    }
  }

  /**
   * 设置指定用户风格ID
   * @param iUserID 用户ID
   * @param iStyleID 风格ID
   * @return 错误代码
   */
  public static int setUserStyle(int iUserID, int iStyleID)
  {
    Vector vt = SQLManager.GetResultSet("Select * from " + TableName + " where ID=" + iUserID);
    if (vt.size() > 0)
    {
      vt = SQLManager.GetResultSet("Select * from StyleInfo where ID=" + iStyleID);
      if (vt.size() > 0)
      {
        return SQLManager.ExcuteSQL("Update " + TableName + " set StyleID='" + iStyleID + "' where ID=" + iUserID);
      }
      else
      {
        /**
         * 该系统风格不存在
         */
        return -8;
      }
    }
    else
    {
      /**
       * 该用户不存在
       */
      return -1;
    }
  }

  /**
   * 重构插入记录的方法，将用户名自动转换为小写，解决用户名区分大小写的问题
   * @param m_request 包含记录内容的Request请求
   * @return 新用户ID或者错误代码(小于1)
   */
  public int InsertRecord(Request m_request)
  {
    int iReturnValue = 0;
    iReturnValue = super.InsertRecord(m_request);
    SQLManager.ExcuteSQL("Update " + TableName + " set UserName='" + m_request.GetString(InsertParament("UserName")).toLowerCase() + "',Password='" + StringNew.getEncodePassword(m_request.GetString(InsertParament("Password"))) + "' where ID=" + iReturnValue);
    return iReturnValue;
  }

  /**
   * 重构修改记录的方法，将用户名自动转换为小写，解决用户名区分大小写的问题
   * @param m_request  包含记录内容的Request请求
   * @return  错误代码(小于1)
   */
  public int UpdateRecord(Request m_request)
  {
    int iReturnValue = super.UpdateRecord(m_request);
    SQLManager.ExcuteSQL("update " + TableName + " set UserName='" + m_request.GetString(UpdateParament("UserName")).toLowerCase() + "',Password='" + StringNew.getEncodePassword(m_request.GetString(UpdateParament("Password"))) + "' where " + IDFieldName + "=" + m_request.GetInt(UpdateParament(IDFieldName)) + "");
    return iReturnValue;
  }

  /**
   * 获取属于指定ID部门的所有用户向量集
   * @param iDepartmentID  指定部门ID
   * @return  属于指定部门的用户向量集
   */
  public static Vector getRecordByIDs(String strIDs)
  {
    Vector vt = SQLManager.GetResultSet("select * from " + TableName + " where ID IN (" + strIDs + ")");
    return vt;
  }
}