usermanager.java

一个完整的

package com.gforce.gfoa;

import com.gforce.currency.database.*;
import com.gforce.currency.*;
import java.util.*;

/**
 * <p>Title: 吉力科技办公自动化系统</p>
 * <p>Description: 吉力科技办公自动化系统</p>
 * <p>Copyright: 版权所有 2003 (c) 西安吉力科技发展有限公司  Copyright (c) 2003 GForce Sceince & Technology</p>
 * <p>Company: 西安吉力科技发展有限公司 (GForce Sceince & Technology)</p>
 * @author 马登军
 * @version 1.0
 */
public class UserManager
  extends RecordManager
{
  public UserManager()
  {
  }

  protected final static String TableName = "UserInfo"; //定义声明本类操作表名称为“UserInfo”
  protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
  protected final static String[] NumericFieldsName =
    {
    "PersonnelID", "RoleID"}; //声明数值型字段名称
  protected final static String[] StringFieldsName =
    {
    "UserName", "Password"}; //声明字符型字段名称
  protected final static String[] DatetimeFieldsName =
    {}; //声明日期时间型字段名称
  protected final static String[] TextFieldsName =
    {}; //声明大字符串型字段名称

  /**
   * 根据字段名称获取插入数据时表单元素名称
   * @param strFieldName  字段名称
   * @return  表单素名称
   */
  protected String InsertParament(String strFieldName)
  {
    return "" + strFieldName + ""; //可以根据需要加前缀、后缀
  }

  /**
   * 根据字段名称获取修改数据时表单元素名称
   * @param strFieldName  字段名称
   * @return  表单素名称
   */
  protected String UpdateParament(String strFieldName)
  {
    return "" + strFieldName + ""; //可以根据需要加前缀、后缀
  }

  /**
   * 获取本类操作表名称
   * @return  表名称
   */
  public String getTableName()
  { //获取本类操作表名称
    return TableName;
  }

  protected String getIDFieldName()
  { //获取主键或者可以确定唯一记录的字段名称
    return IDFieldName;
  }

  protected String[] getNumericFieldsName()
  { //获取数值型字段名称
    return NumericFieldsName;
  }

  protected String[] getStringFieldsName()
  { //获取字符型字段名称
    return StringFieldsName;
  }

  protected String[] getDatetimeFieldsName()
  { //获取日期时间型字段名称
    return DatetimeFieldsName;
  }

  protected String[] getTextFieldsName()
  { //获取大字符串型字段名称
    return TextFieldsName;
  }

  /**
   *检查用户登录是否正确，并返回用户ID
   * @param strUserName  用户名
   * @param strPassword  用户密码
   * @return  用户ID
   */
  public static int CheckLogin(String strUserName, String strPassword)
  {
    int intReturn = 0;
    Vector vt = SQLManager.GetResultSet(
      "Select ID from UserInfo where UserName = '" + strUserName.toLowerCase() +
      "' and Password = '" + StringNew.getEncodePassword(strPassword) + "'");
    if (vt.size() > 0)
    {
      intReturn = Integer.parseInt( ( (Vector) vt.get(0)).get(0).toString());
    }
    return intReturn;
  }

  /**
   * 通过用户ID获取用户角色ID
   * @param intUserID  用户ID
   * @return  角色ID
   */
  public static int GetUserRoleID(int intUserID)
  {
    int intReturn = 0;
    try
    {
      Vector vt = SQLManager.GetResultSet("Select RoleID from UserInfo where ID=" + intUserID + "");
      if (vt.size() > 0)
      {
        intReturn = Integer.parseInt( ( (Vector) vt.get(0)).get(0).toString());
      }
    }
    catch (Exception err)
    {

    }
    return intReturn;
  }

  /**
   * 获取所有记录向量集
   * @return 所有记录向量集
   */
  public static Vector getAllRecord()
  {
    Vector vt = SQLManager.GetResultSet("SELECT a.*,b.Number,b.Name FROM " + TableName +
      " as a left outer join PersonnelInfo as b on (a.PersonnelID = b.ID) ORDER BY b.Number,b.ID,a.ID");
    return vt;
  }

  /**
   * 获取属于指定ID部门的所有用户向量集和员工信息
   * @param iDepartmentID  指定部门ID
   * @return 属于指定部门的用户向量集
   */
  public static Vector getRecordAndPersonnelInfoByDepartmentID(int iDepartmentID)
  {
    String strSQL = "SELECT a.*,b.Number,b.Name FROM " + TableName
      + " as a left outer join PersonnelInfo as b on (a.PersonnelID = b.ID) where not b.ID is null  ORDER BY b.Number,b.ID,a.ID";
    if (iDepartmentID == 0)
    {
      strSQL = "SELECT a.*,b.Number,b.Name FROM " + TableName
        + " as a left outer join PersonnelInfo as b on (a.PersonnelID = b.ID) where not b.ID is null ORDER BY b.Number,b.ID,a.ID";
    }
    else
    {
      strSQL = "SELECT a.*,b.Number,b.Name FROM " + TableName + " as a left outer join PersonnelInfo as b on (a.PersonnelID = b.ID) Where b.DepartmentID in (select ID from DepartmentInfo where Station like ((select Station from DepartmentInfo where ID="
        + iDepartmentID + ")+'" + iDepartmentID + "_%')) or b.DepartmentID=" +
        iDepartmentID + " ORDER BY b.Number,b.ID,a.ID";
    }

    Vector vt = SQLManager.GetResultSet(strSQL);
    return vt;
  }

  /**
   * 获取属于指定ID部门的所有用户向量集
   * @param iDepartmentID  指定部门ID
   * @return  属于指定部门的用户向量集
   */
  public static Vector getRecordByDepartmentID(int iDepartmentID)
  {
    Vector vt = SQLManager.GetResultSet("SELECT a.ID,a.UserName,a.Password,a.PersonnelID,a.RoleID,c.RoleName FROM "
                                        + TableName + " as a left outer join PersonnelInfo as b on (a.PersonnelID=b.ID) left outer join RoleInfo as c on (a.RoleID=c.ID) where b.DepartmentID=" +
                                        iDepartmentID +
                                        " ORDER BY a.ID");
    return vt;
  }

  /**
   * 获取属于指定IDs部门的所有用户向量集
   * @param iDepartmentID  指定部门ID
   * @return  属于指定部门的用户向量集
   */
  public static Vector getRecordByDepartmentIDs(String strDepartmentIDs)
  {
    Vector vt = SQLManager.GetResultSet("SELECT a.ID,a.UserName,a.Password,a.PersonnelID,a.RoleID,c.RoleName FROM "
                                        + TableName + " as a left outer join PersonnelInfo as b on (a.PersonnelID=b.ID) left outer join RoleInfo as c on (a.RoleID=c.ID) where b.DepartmentID in (" +
                                        strDepartmentIDs +
                                        ") ORDER BY a.ID");
    return vt;
  }


  /**
   * 获取指定用户ID的用户信息，包括部门ID
   * @param iUserID 用户ID
   * @return 指定用户ID的用户信息，包括部门ID
   */
  public static Vector getUserInfoByID(int iUserID)
  {
    Vector vt = SQLManager.GetResultSet("SELECT a.ID,a.UserName,a.Password,a.PersonnelID,a.RoleID,b.DepartmentID FROM "
                                        + TableName +
                                        " as a left outer join PersonnelInfo as b on (a.PersonnelID=b.ID) where a.ID="
                                        + iUserID + " ORDER BY a.ID");
    return vt;
  }

  /**
   * 通过用户ID获取员工姓名
   * @param iUserID  用户ID
   * @return  员工姓名
   */
  public static String getPersonnelNameByUserID(int iUserID)
  {
    String strReturnValue = "姓名未知";
    Vector vt = SQLManager.GetResultSet("SELECT b.Name 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;
  }

  /**
   * 通过用户IDs字符串获取员工姓名
   * @param strUserIDs  用户IDs字符串
   * @return  员工姓名
   */
  public static String getPersonnelNamesByUserIDs(String strUserIDs)
  {
    String strReturnValue = "";
    if(strUserIDs.length()>0)
    {
      Vector vt = SQLManager.GetResultSet("SELECT b.Name FROM " + TableName +
        " as a left outer join PersonnelInfo as b on (a.PersonnelID=b.ID) where a.ID in ("
        + strUserIDs + ") ORDER BY b.Number");
      for(int i=0;i<vt.size();i++)
      {
        strReturnValue += "," + ((Vector) vt.get(i)).get(0).toString();
      }
    }
    if(strReturnValue.length()>0)
    {
      return strReturnValue.substring(1);
    }
    else
    {
      return "";
    }
  }

  /**
   * 通过用户ID获取员工编号
   * @param iUserID  用户ID
   * @return  员工编号
   */
  public static String getPersonnelNumberByUserID(int iUserID)