documentmanagerplus.java

一个完整的

package com.gforce.gfoa;

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

/**
 * <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 DocumentManagerPlus
  extends RecordManager
{
  public DocumentManagerPlus()
  {
  }

  protected final static String TableName = "Document"; //定义声明本类操作表名称
  protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
  protected final static String[] NumericFieldsName =
    {
    "DocFlowTempletID", "BuildUserID", "FillUserID", "CurrentFlowTacheID"}; //声明数值型字段名称
  protected final static String[] StringFieldsName =
    {
    "DocumentName"}; //声明字符型字段名称
  protected final static String[] DatetimeFieldsName =
    {
    "BuildTime", "RemindTime"}; //声明日期时间型字段名称
  protected final static String[] BoolFieldsName =
    {
    "IsPigeonholed", "IsReminded"}; //声明布尔型字段名称
  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[] getBoolFieldsName()
  { //获取布尔型字段名称
    return BoolFieldsName;
  }

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

  /**
   * 获取所有文档记录集
   * @return 所有文档记录集
   */
  public static Vector getAllRecord()
  {
    Vector vt = SQLManager.GetResultSet("Select * from " + TableName);
    return vt;
  }

  /**
   * 获取指定ID地记录
   * @param iDocID 指定地记录ID
   * @return 记录数据集
   */
  public static Vector getByIDRecord(int iDocID)
  {
    Vector vt = SQLManager.GetResultSet("Select * from " + TableName +
                                        " WHERE ID ='" + iDocID + "'");
    return vt;
  }

  /**
   * 按制定条件查询记录集
   * @param strID ID标识
   * @param strDocumentName 公文名称
   * @param iDocFlowTempletID 公文流转模板ID
   * @param strDocFlowTempletName 公文流转模板名称
   * @param iBuildUserID 生成用户ID
   * @param strBuildUserName 生成用户姓名
   * @param iFillUserID 填表用户ID
   * @param strFillUserName 填表用户ID
   * @param bIsPigeonholed 是否已经归档
   * @param iCurrentFlowTacheID 当前流程环节ID
   * @param strCurrentFlowTacheName 当前流程环节名称
   * @param iTacheStatus 当前流程环节状态ID
   * @param strTacheStatus 当前流程环节状态
   * @param bIsReminded 是否已经提醒
   * @param strRemindTime 提醒时间
   * @param strBuildTimeFrom 建立时间起始
   * @param strBuildTimeTo 建立时间截至
   * @param strOrderBy 排序字段
   * @param bIsDesc 是否降序排序
   * @return 符合条件记录向量集
   */
  public static Vector getRecordBySearch(String strID, String strDocumentName,
                                         int iDocFlowTempletID,
                                         String strDocFlowTempletName,
                                         int iBuildUserID,
                                         String strBuildUserName,
                                         int iFillUserID,
                                         String strFillUserName,
                                         boolean bIsPigeonholed,
                                         int iCurrentFlowTacheID,
                                         String strCurrentFlowTacheName,
                                         int iTacheStatus,
                                         String strTacheStatus,
                                         boolean bIsReminded,
                                         String strRemindTime,
                                         String strBuildTimeFrom,
                                         String strBuildTimeTo,
                                         String strOrderBy, boolean bIsDesc)
  {
    return getRecordBySearch(strID, strDocumentName, iDocFlowTempletID,
                             strDocFlowTempletName, iBuildUserID,
                             strBuildUserName, iFillUserID, strFillUserName,
                             bIsPigeonholed, iCurrentFlowTacheID,
                             strCurrentFlowTacheName, iTacheStatus,
                             strTacheStatus, bIsReminded + "", strRemindTime,
                             strBuildTimeFrom, strBuildTimeTo, strOrderBy,
                             bIsDesc);
  }

  /**
   * 按制定条件查询记录集
   * @param strID ID标识
   * @param strDocumentName 公文名称
   * @param iDocFlowTempletID 公文流转模板ID
   * @param strDocFlowTempletName 公文流转模板名称
   * @param iBuildUserID 生成用户ID
   * @param strBuildUserName 生成用户姓名
   * @param iFillUserID 填表用户ID
   * @param strFillUserName 填表用户ID
   * @param bIsPigeonholed 是否已经归档
   * @param iCurrentFlowTacheID 当前流程环节ID
   * @param strCurrentFlowTacheName 当前流程环节名称
   * @param iTacheStatus 当前流程环节状态ID
   * @param strTacheStatus 当前流程环节状态
   * @param strIsReminded 是否已经提醒
   * @param strRemindTime 提醒时间
   * @param strBuildTimeFrom 建立时间起始
   * @param strBuildTimeTo 建立时间截至
   * @param strOrderBy 排序字段
   * @param bIsDesc 是否降序排序
   * @return 符合条件记录向量集
   */
  public static Vector getRecordBySearch(String strID, String strDocumentName,
                                         int iDocFlowTempletID,
                                         String strDocFlowTempletName,
                                         int iBuildUserID,
                                         String strBuildUserName,
                                         int iFillUserID,
                                         String strFillUserName,
                                         boolean bIsPigeonholed,
                                         int iCurrentFlowTacheID,
                                         String strCurrentFlowTacheName,
                                         int iTacheStatus,
                                         String strTacheStatus,
                                         String strIsReminded,
                                         String strRemindTime,
                                         String strBuildTimeFrom,
                                         String strBuildTimeTo,
                                         String strOrderBy, boolean bIsDesc)
  {
    return getRecordBySearch(strID, strDocumentName, iDocFlowTempletID,
                             strDocFlowTempletName, iBuildUserID,
                             strBuildUserName, iFillUserID, strFillUserName,
                             bIsPigeonholed, iCurrentFlowTacheID,
                             strCurrentFlowTacheName, iTacheStatus,
                             strTacheStatus, strIsReminded, strRemindTime,
                             strBuildTimeFrom, strBuildTimeTo, 0, strOrderBy,
                             bIsDesc);
  }

  /**
   * 按制定条件查询记录集
   * @param strID ID标识
   * @param strDocumentName 公文名称
   * @param iDocFlowTempletID 公文流转模板ID
   * @param strDocFlowTempletName 公文流转模板名称
   * @param iBuildUserID 生成用户ID
   * @param strBuildUserName 生成用户姓名
   * @param iFillUserID 填表用户ID
   * @param strFillUserName 填表用户ID
   * @param bIsPigeonholed 是否已经归档
   * @param iCurrentFlowTacheID 当前流程环节ID
   * @param strCurrentFlowTacheName 当前流程环节名称
   * @param iTacheStatus 当前流程环节状态ID
   * @param strTacheStatus 当前流程环节状态
   * @param strIsReminded 是否已经提醒
   * @param strRemindTime 提醒时间
   * @param strBuildTimeFrom 建立时间起始
   * @param strBuildTimeTo 建立时间截至
   * @param iReadUserID 读取用户ID
   * @param strOrderBy 排序字段
   * @param bIsDesc 是否降序排序
   * @return 符合条件记录向量集
   */

  public static Vector getRecordBySearch(String strID, String strDocumentName,
                                         int iDocFlowTempletID,
                                         String strDocFlowTempletName,
                                         int iBuildUserID,
                                         String strBuildUserName,
                                         int iFillUserID,
                                         String strFillUserName,
                                         boolean bIsPigeonholed,
                                         int iCurrentFlowTacheID,
                                         String strCurrentFlowTacheName,
                                         int iTacheStatus,
                                         String strTacheStatus,
                                         String strIsReminded,
                                         String strRemindTime,
                                         String strBuildTimeFrom,
                                         String strBuildTimeTo, int iReadUserID,
                                         String strOrderBy, boolean bIsDesc)
  {
    String strSQL = "Select a.[ID], a.[DocumentName], a.[DocFlowTempletID], a.[BuildTime], a.[BuildUserID], a.[FillUserID]," +
      " a.[IsPigeonholed], a.[CurrentFlowTacheID], a.[IsReminded], a.[RemindTime]," +
      " c.[Name], d.[Name], e.[Name], f.[TacheName], f.[TacheStatus] from [" +
      TableName + "] as a" +
      " left outer join [UserInfo] as b on (a.BuildUserId=b.ID) left outer join [PersonnelInfo] as c on (b.PersonnelID=c.ID)" +
      " left outer join [UserInfo] as g on (a.FillUserID=g.ID) left outer join [PersonnelInfo] as d on (g.PersonnelID=d.ID)" +
      " left outer join [DocTempletMoveFlow] as e on (a.DocFlowTempletID=e.ID)" +
      " left outer join [FlowTacheInfo] as f on (a.CurrentFlowTacheID=f.ID) where a.[CurrentFlowTacheID]>-2";
    if (strDocumentName.trim().length() > 0)
    {
      strSQL += " and a.[DocumentName] like '%" + strDocumentName + "%'";
    }
    if (strDocFlowTempletName.trim().length() > 0)
    {
      strSQL += " and e.[Name] like '%" + strDocFlowTempletName + "%'";
    }
    if (strIsReminded.trim().equalsIgnoreCase("true"))
    {
      strSQL += " and a.[IsReminded] = 1";
    }
    else if (strIsReminded.trim().equalsIgnoreCase("false"))
    {
      strSQL += " and (a.[IsReminded] IS null OR a.[IsReminded] = 0)";
    }
    if (strBuildUserName.trim().length() > 0)
    {
      strSQL += " and c.[Name] like '%" + strBuildUserName + "%'";
    }
    if (strFillUserName.trim().length() > 0)
    {
      strSQL += " and d.[Name] like '%" + strFillUserName + "%'";
    }
    if (bIsPigeonholed)
    {
      strSQL += " and a.[IsPigeonholed] = 1";
    }
    else
    {
      strSQL += " and (a.[IsPigeonholed] IS null OR a.[IsPigeonholed] = 0)";
    }
    if (strCurrentFlowTacheName.trim().length() > 0)
    {
      strSQL += " and f.[TacheName] like '%" + strCurrentFlowTacheName + "%'";
    }
    if (strTacheStatus.trim().length() > 0)
    {
      strSQL += " and '%' + f.[TacheStatus] + '%' like '%" + strTacheStatus +
        "%'";
    }
    if (strBuildTimeFrom.trim().length() > 0)
    {
      strSQL += " and a.[BuildTime]>='" + strBuildTimeFrom + " 00:00:00.000'";
    }
    if (strBuildTimeTo.trim().length() > 0)
    {
      strSQL += " and a.[BuildTime]<='" + strBuildTimeTo + " 23:59:59.999'";
    }
    if (iReadUserID > 0)
    {
      strSQL += " and ',' + e.[ReadOnlyUserIDs] + ',' like '%," + iReadUserID +
        ",%'";
    }
    if (iDocFlowTempletID > 0)
    {
      strSQL += " and e.[DocFlowTempletID]=" + iReadUserID + "";
    }

    if (iCurrentFlowTacheID != 0)
    {
      strSQL += " and a.[CurrentFlowTacheID]=" + iCurrentFlowTacheID + "";
    }

    if (strOrderBy.trim().length() > 0)
    {
      if (bIsDesc)
      {
        strSQL += " Order by " + strOrderBy + " desc";
      }
      else
      {
        strSQL += " Order by " + strOrderBy + "";
      }
    }
    Vector vt = SQLManager.GetResultSet(strSQL);
    return vt;
  }