approverecordinfomanager.java

一个完整的

package com.gforce.gfoa;

/**
 * <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 2.0
 * DATE : 2003-12-30
 * 审批记录信息管理类
 */

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

public class ApproveRecordInfoManager extends RecordManager
{
  public ApproveRecordInfoManager()
  {}

  protected final static String TableName = "ApproveRecordInfo"; //定义声明本类操作表名称
  protected final static String IDFieldName = "ID"; //定义声明主键或者可以确定唯一记录的字段名称为“ID”，必须为自增整型
  protected final static String[] NumericFieldsName = {"FlowTacheID","DocumentID","ApproveUserID","IsRead"}; //声明数值型字段名称
  protected final static String[] DatetimeFieldsName = {"ApproveTime"}; //声明日期时间型字段名称
  protected final static String[] StringFieldsName = {"ApproveFromIP"}; //声明字符型字段名称
  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;
  }

  /**
   * 返回待处理审批记录表
   * @param strID 审批记录ID
   * @param strFlowTacheID 审批环节ID
   * @param strFlowTacheName 审批环节名称
   * @param strDocumentID 审批公文ID
   * @param strDocumentName 审批公文名称
   * @param strApproveUserID 审批用户ID
   * @param strApproveUserName 审批用户姓名
   * @param strApproveTimeFrom 审批时间起始
   * @param strApproveTimeTo 审批时间结束
   * @param strApproveTime 审批精确时间
   * @param strApproveFromIP 审批来源IP
   * @param strIsRead 是否记录查阅
   * @param strOrderBy 排序字段
   * @param strIsDesc 是否降序排序
   * @return 符合条件记录向量集
   */
  public static Vector getRecordBySearch(String strID,String strFlowTacheID,String strFlowTacheName,String strDocumentID,
                                         String strDocumentName,String strApproveUserID,String strApproveUserName,
                                         String strApproveTimeFrom,String strApproveTimeTo,String strApproveTime,
                                         String strApproveFromIP,String strIsRead,String strOrderBy,String strIsDesc)
  {
    String strSQL="SELECT a.[ID],a.[FlowTacheID],a.[DocumentID],a.[ApproveUserID],a.[ApproveTime],a.[ApproveFromIP],a.[IsRead]," +
                  "b.[TacheName],c.[DocumentName],e.[Name]" +
                  " FROM [ApproveRecordInfo] AS a LEFT OUTER JOIN [FlowTacheInfo] AS b ON (a.[FlowTacheID]=b.[ID]) LEFT OUTER JOIN" +
                  " [Document] AS c ON (a.[DocumentID]=c.[ID]) LEFT OUTER JOIN [UserInfo] AS d ON (a.[ApproveUserID]=d.[ID])" +
                  " LEFT OUTER JOIN [PersonnelInfo] AS e ON (d.[PersonnelID]=e.[ID]) WHERE a.[ID] > 0";
    if (strID.trim().length()>0)
    {
      strSQL += " AND (a.[ID] IN (" + strID + "))";
    }

    if (strFlowTacheID.trim().length()>0)
    {
      strSQL += " AND a.[FlowTacheID] = '" + strFlowTacheID + "'";
    }

    if (strFlowTacheName.trim().length()>0)
    {
      strSQL += " AND b.[TacheName] LIKE '%" + strFlowTacheName + "%'";
    }

    if (strDocumentID.trim().length()>0)
    {
      strSQL += " AND a.[DocumentID] = '" + strDocumentID + "'";
    }

    if (strDocumentName.trim().length()>0)
    {
      strSQL += " AND c.[DocumentName] LIKE '%" + strDocumentName + "%'";
    }

    if (strApproveUserID.trim().length()>0)
    {
      strSQL += " AND a.[ApproveUserID] = '" + strApproveUserID + "'";
    }

    if (strApproveUserName.trim().length()>0)
    {
      strSQL += " AND e.[Name] LIKE '%" + strApproveUserName + "%'";
    }

    if (strApproveTimeFrom.trim().length()>0)
    {
      strSQL += " and a.[ApproveTime]>='" + strApproveTimeFrom + " 00:00:00.000'";
    }

    if (strApproveTimeTo.trim().length()>0)
    {
      strSQL += " and a.[ApproveTime]<='" + strApproveTimeTo + " 23:59:59.999'";
    }

    if (strApproveTime.trim().length()>0)
    {
      strSQL += " and a.[ApproveTime]= '" + strApproveTime + "'";
    }

    if (strApproveFromIP.trim().length()>0)
    {
      strSQL += " and a.[ApproveFromIP]= '" + strApproveFromIP + "'";
    }

    if (strIsRead.trim().length()>0)
    {
      if (strIsRead.equalsIgnoreCase("True"))
        strSQL += " and a.[IsRead] = 1";
      else if (strIsRead.equalsIgnoreCase("False"))
        strSQL += " and a.[IsRead] = 0";
    }

    if (strOrderBy.trim().length() > 0)
    {
      if (strIsDesc.equalsIgnoreCase("True"))
        strSQL += " Order by " + strOrderBy + " desc";
      else
        strSQL += " Order by " + strOrderBy + "";
    }

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

  /**
   * 插入审批记录
   * @param FlowTacheID 流转环节ID
   * @param DocumentID 公文ID
   * @param ApproveUserID 审批用户ID
   * @param ApproveTime 审批时间
   * @param ApproveFromIP 审批来源IP
   * @param IsRead 记录是否查阅
   * @return 整型值
   */
  public static int InsertApproveInfo(String FlowTacheID,String DocumentID,String ApproveUserID,String ApproveTime,
                                      String ApproveFromIP,String IsRead)
  {
    String strSQL="INSERT " + TableName + "(FlowTacheID,DocumentID,ApproveUserID,ApproveTime,ApproveFromIP,IsRead) values " +
                  "('" + FlowTacheID + "','" + DocumentID + "','" + ApproveUserID + "','" + ApproveTime + "','" + ApproveFromIP +
                  "','" + IsRead + "')";
    return SQLManager.ExcuteSQL(strSQL);
  }

}