recvdoclogmanager.java

OA典型例子

package com.sure.oa.recvdoc;

import com.sure.businessmodel.Page;
import com.sure.businessmodel.UpdateException;
import com.sure.businesslogic.AlreadyExistsException;
import com.sure.businesslogic.NotFoundException;
import com.sure.dataabstraction.DBManager;
import com.sure.dataabstraction.DBPoolException;
import com.sure.util.StringUtils;
import com.sure.oa.attachment.*;
import com.sure.oa.orgnization.*;
import com.sure.oa.senddoc.*;
import com.sure.util.*;
import java.sql.SQLException;
import java.sql.Connection;
import java.util.*;
import java.io.*;
/**
 * <p>Title: OA</p>
 * <p>Description: 国办项目</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: sure</p>
 * @author mengzy
 * OrperateId编号  0：签收 1：打印 2：退回  3：归档 4:删除(未起用)
 */

public class RecvDocLogManager {

  public RecvDocLogManager() {
  }
  /**
   * 获得某单位对某一条收文的签收日志
   * 返回:签收日志
   */
  public static  Vector getSignLog(String docId,String unitId) throws SQLException,DBPoolException{
     Connection cn=DBManager.getConnection();
     Vector v=new Vector();
     String where="where unitId="+unitId+" and docId="+docId+" and operateId=0";
     try {
         v=RecvDocLogPersistent.load(cn,where);
     }
     catch(Exception e){
       e.printStackTrace();
     }
     finally{
       cn.close();
       return v;
     }

  }

   /**
    * 打印后插入打印日志,并且刷新RecvPermission可打印份数
    */
   public static  void  savePrintLog(String docId,String unitId,String userId,String userName,String printNum) throws SQLException,DBPoolException{
      Connection cn=DBManager.getConnection();
      try {
          cn.setAutoCommit(false);
          //插入收文日志
          RecvDocLog log=new RecvDocLog();
          log.setLogId(0);
          log.setDocId(docId);
          log.setOperator(userName);
          log.setOperatorId(userId);
          log.setOperateDate(DateWrapper.getLongTime(new Date()));
          log.setOperateId("1");
          log.setUnitId(unitId);
          RecvDocLogPersistent slog=new RecvDocLogPersistent(log);
          slog.setRecordExists(false);
          slog.persist(cn);
          //刷新可打印份数
          RecvPermission per=RecvPermissionManager.getRecvPermission(docId,unitId);
          per.setPrintNumber(printNum);
          RecvPermissionPersistent sper=new RecvPermissionPersistent(per);
          sper.setRecordExists(true);
          sper.persist(cn);
          cn.commit();
      }
      catch(Exception e){
        cn.rollback();
        e.printStackTrace();
      }
      finally{
        cn.setAutoCommit(true);
        cn.close();
      }
   }

    /**
     * 收文签收时插入签收日志,并把RecvPermission状态置位
     */
    public static  void  saveQianShou(String docId,String sendDocId,String unitId,String userId,String userName,String receiveType) throws SQLException,DBPoolException{
       Connection cn=DBManager.getConnection();
       try {
           cn.setAutoCommit(false);
           //插入收文签收日志
           RecvDocLog log=new RecvDocLog();
           log.setLogId(0);
           log.setDocId(docId);
           log.setOperator(userName);
           log.setOperatorId(userId);
           log.setOperateDate(DateWrapper.getLongTime(new Date()));
           log.setOperateId("0");
           log.setUnitId(unitId);
           RecvDocLogPersistent slog=new RecvDocLogPersistent(log);
           slog.setRecordExists(false);
           slog.persist(cn);
           //刷新收文授权表的状态
           RecvPermission per=RecvPermissionManager.getRecvPermission(docId,unitId);
           per.setStatus("2");
           per.setReceiveDate(DateWrapper.getLongTime(new Date()));
           per.setReceiveType(receiveType);
           RecvPermissionPersistent sper=new RecvPermissionPersistent(per);
           sper.setRecordExists(true);
           sper.persist(cn);
           String sendlogId=sper.getBean().getSendlogId();
           //插入发文日志
           SendDocLog logs=new SendDocLog();
           logs.setLogId(0);
           logs.setDocId(sendDocId);
           logs.setOperator(userName);
           logs.setOperatorId(userId);
           logs.setOperateDate(DateWrapper.getLongTime(new Date()));
           logs.setOperateId("6");
           logs.setUnitId(unitId);
           logs.setSendlogId(sendlogId);
           SendDocLogPersistent slogs=new SendDocLogPersistent(logs);
           slogs.setRecordExists(false);
           slogs.persist(cn);
           cn.commit();
       }
       catch(Exception e){
         cn.rollback();
         e.printStackTrace();
       }
       finally{
         cn.setAutoCommit(true);
         cn.close();
       }
   }

   /**
    * 收文退回时插入退回日志,并把RecvPermission状态置位
    */
    public static  void  saveBack(String docId,String sendDocId,String unitId,String userId,String userName,String TuiYy) throws SQLException,DBPoolException{
       Connection cn=DBManager.getConnection();
       try {
           cn.setAutoCommit(false);
           //插入收文退回日志
           RecvDocLog log=new RecvDocLog();
           log.setLogId(0);
           log.setDocId(docId);
           log.setOperator(userName);
           log.setOperatorId(userId);
           log.setOperateDate(DateWrapper.getLongTime(new Date()));
           log.setOperateId("2");
           log.setMemo(TuiYy);
           log.setUnitId(unitId);
           RecvDocLogPersistent slog=new RecvDocLogPersistent(log);
           slog.setRecordExists(false);
           slog.persist(cn);
           //刷新收文授权表的状态
           RecvPermission per=RecvPermissionManager.getRecvPermission(docId,unitId);
           per.setStatus("4");
           RecvPermissionPersistent sper=new RecvPermissionPersistent(per);
           sper.setRecordExists(true);
           sper.persist(cn);
           String sendlogId=sper.getBean().getSendlogId();
           //插入发文日志
           Vector v=SendDocLogManager.getRecvLogReWrite(sendDocId,unitId,sendlogId);
           SendDocLog logs=new SendDocLog();
           SendDocLogPersistent slogs;
           if (v.size()>0){
             //System.out.println("已经有日志");
             logs=(SendDocLog)v.firstElement();
             logs.setDocId(sendDocId);
             logs.setOperator(userName);
             logs.setOperatorId(userId);
             logs.setOperateDate(DateWrapper.getLongTime(new Date()));
             logs.setOperateId("7");
             logs.setMemo(TuiYy);
             logs.setUnitId(unitId);
             logs.setSendlogId(sendlogId);
             slogs=new SendDocLogPersistent(logs);
             slogs.setRecordExists(true);
             slogs.persist(cn);
           }
           else
           {
             logs.setLogId(0);
             logs.setDocId(sendDocId);
             logs.setOperator(userName);
             logs.setOperatorId(userId);
             logs.setOperateDate(DateWrapper.getLongTime(new Date()));
             logs.setOperateId("7");
             logs.setMemo(TuiYy);
             logs.setUnitId(unitId);
             logs.setSendlogId(sendlogId);
             slogs=new SendDocLogPersistent(logs);
             slogs.setRecordExists(false);
             slogs.persist(cn);
           }
           cn.commit();
       }
       catch(Exception e){
         cn.rollback();
         e.printStackTrace();
       }
       finally{
         cn.setAutoCommit(true);
         cn.close();
       }
    }

 public static  Vector getLog(String docId,String unitId,String operateId) throws SQLException,NotFoundException,DBPoolException {
     Connection cn = DBManager.getConnection();
      try{
          String where = "where docId=" + docId + " and unitId="+unitId+" and operateId="+operateId+"";
          //System.out.println(where);
          Vector v = RecvDocLogPersistent.load(cn,where);
          return  v;
      }finally {
          cn.close();
      }
}

  /**
   * 保存日志信息
   */
  public static  void  saveLog(RecvDocLog log){
  }

  /**
   * 删除日志信息
   */
  public static  void  delLog(RecvDocLog log){
  }

}