wdscmbwhblh.java

以前做的一个j2ee的项目

package gov.gdlt.ssgly.taxcore.taxblh.wdsc;

import java.util.List;
import gov.gdlt.ssgly.taxcore.taxdao.wdsc.*;
import gov.gdlt.ssgly.taxcore.taxblh.wdsc.yhswdsc.WDSCyhswdscBLH;
import java.util.Vector;
import gov.gdlt.ssgly.taxcore.taxdao.wdsc.WDSCwdmbzbDAO;

import oracle.sql.BLOB;

import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.SQLException;
import java.sql.Connection;
import gov.gdlt.ssgly.taxcore.comm.util.StringUtils;
import gov.gdlt.ssgly.taxcore.comm.blh.BaseBizLogicHandler;
import gov.gdlt.ssgly.taxcore.comm.event.*;
import gov.gdlt.ssgly.taxcore.taxevent.wdsc.*;
import gov.gdlt.ssgly.taxcore.comm.exception.*;

import gov.gdlt.ssgly.taxcore.comm.log.LogWritter;
import gov.gdlt.ssgly.taxcore.taxevent.wdsc.WDSCmbwhVO;
import java.util.Date;

/**
 * <p>Title: </p>
 *
 * <p>Description: 广东地税税收管理员工作平台</p>
 *
 * <p>Copyright: Copyright (c) 2005 广东省地方税务局，广州市地方税务局</p>
 *
 * <p>Company: 广州地税</p>
 *
 * @author 张承华
 * @version 1.0
 */
public class WDSCmbwhBLH extends BaseBizLogicHandler{
    public WDSCmbwhBLH() {
    }

    LogWritter log = new LogWritter();

    //模板维护

    //取所有指标参数
    private List getAllZbMsg() throws Exception {
        DMzbglDAO zbgl = new DMzbglDAO();
        List list = null;
        try {
            list = zbgl.getZbDm();
        }catch(Exception e) {
            e.printStackTrace();
            throw new Exception(e.getMessage());
        }

        return list;
    }

    //得到 没有被指定模板选中的指标信息
    private List getZbMsgNotInMb(String mbdm, String mblb) throws TaxBaseSystemException{
         DMzbglDAO zbgl = new DMzbglDAO();
         List list = null;
         try {
             String swjg = "%";
             list = zbgl.getZbDmNotInMb(mbdm, swjg, mblb);
         } catch(Exception e) {
             e.printStackTrace();
             throw new TaxBaseSystemException(e.getMessage());
         }
         return list;
    }
    //取当前模板指标参数
    private List getCurrMbZb(String mbdm, String mblb) throws TaxBaseSystemException {
        DMzbglDAO zbgl = new DMzbglDAO();
        zbgl.setMB_DM(mbdm);
        zbgl.setMB_LB(mblb);
        try {
            String swjg = "%";
            return zbgl.getZbDmByMb(mbdm, mblb, swjg);
        } catch (Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }
    }

    //取当前模板内容，不取的模板指标的相关信息
    private WDSCwdmbDAO getCurrMb(String mbdm, String mblb, String swjg) throws TaxBaseSystemException {
        WDSCwdmbDAO wdmb = new WDSCwdmbDAO();
        //swjg = "000000000";
        try {
            wdmb = wdmb.getWdMbByBmWithOutZbMsg(mbdm, mblb, swjg);
        } catch (Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }
        return wdmb;
    }

    private String getCurrMbNr(String mbdm, String mblb, String swjg) throws TaxBaseSystemException {
        String mbnr = "";
        WDSCwdmbDAO wdmb = null;

        try {
            wdmb = getCurrMb(mbdm, mblb, swjg);
            WDSCyhswdscBLH yhs = new WDSCyhswdscBLH();
            StringBuffer buffer = null;
            if (wdmb != null) {
                buffer = yhs.outputWdMb2TempFile(wdmb);
                if (buffer != null)
                    mbnr = StringUtils.isoToGBK(buffer.toString());
                    //mbnr = buffer.toString();
            }
        } catch (Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }
        return mbnr;
    }


    //增加模板指标
    private void IaddMbZb(Vector v) throws TaxBaseSystemException {
        if (v != null) {
            try {
                for (int i = 0; i < v.size(); i++) {
                    WDSCwdmbzbDAO mbzb = (WDSCwdmbzbDAO) v.get(i);
                    mbzb.insertWdMbZb();
                }
            } catch (Exception e) {
                e.printStackTrace();
                throw new TaxBaseSystemException(e.getMessage());
            }
        }
    }

    //增加模板指标
    public void IaddMbZbWithOutTras(Vector v) throws TaxBaseSystemException {
        if (v != null) {
            try {
                for (int i = 0; i < v.size(); i++) {
                    WDSCwdmbzbDAO mbzb = (WDSCwdmbzbDAO) v.get(i);
                    mbzb.insertWdMbZbWithOutTrans();
                }
            } catch (Exception e) {
                e.printStackTrace();
                throw new TaxBaseSystemException(e.getMessage());
            }
        }
    }


    //删除模板指标
    //v:模板指标，且模板代码在指标对象中
    private int delMbZb(Vector v) throws TaxBaseSystemException {
        if (v != null) {
            WDSCwdmbzbDAO mbzb = null;
            try {
                for (int i = 0; i < v.size(); i++) {
                    mbzb = (WDSCwdmbzbDAO) v.get(i);
                    mbzb.deleteWdMbZb();
                }
            } catch (Exception e) {
                e.printStackTrace();
                throw new TaxBaseSystemException(e.getMessage());
            }
        }
        return 0;
    }


    //删除模板指标
    //v:指标列表,模板代码不在指标对象中
    //mbbm:模板编码
    //mblb:模板类别
    //推荐使用
    private int IdelMbZb(Vector v, String mbbm, String mblb) throws TaxBaseSystemException{
        int count = 0;
        try {
            if (v != null) {
                String zb = "(";
                WDSCwdmbzbDAO mbzb = null;
                for (int i = 0; i < v.size(); i++) {
                    mbzb = (WDSCwdmbzbDAO) v.get(i);
                    if (i == (v.size() - 1))
                        zb = zb + "'" + mbzb.getZB_DM() + "')  ";
                    else
                        zb = zb + "'" + mbzb.getZB_DM() + "', ";
                }
                //System.out.println("sql =" + zb);
                mbzb = new WDSCwdmbzbDAO();
                mbzb.setMB_DM(mbbm);
                mbzb.setMB_LB(mblb);
                mbzb.setZB_DM(zb);
                mbzb.setMB_SWJG("%");
                count = mbzb.deleteWdMbZb();
            }
        } catch (Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException("错误代码：" + String.valueOf(21000)+ ", " + e.getMessage());
        }
        return count;
    }

    //

    //更新指定模板内容
    private void updateMbNr(String mbbm, String mbnr, String mblb) throws TaxBaseSystemException{
        WDSCwdmbDAO wdmb = new WDSCwdmbDAO();
        wdmb.setMB_DM(mbbm);
        wdmb.setMB_LB(mblb);
        wdmb.setMB_SWJG("%");

        StringBuffer sbuffer = new StringBuffer(mbnr);
        wdmb.setMB_NR_BUFFER(sbuffer);
        try {
            wdmb.updateWdMbNr();
            try {
                wdmb.execProc();
            } catch (Exception e) {//将模板插入到T_GZDA失败
                System.out.println(e.getMessage());
            }

        } catch (FileNotFoundException e) {
            e.printStackTrace();
            throw new TaxBaseSystemException("错误编码:(FileNotFoundException)"+ String.valueOf(21001) +","+ e.getMessage());
        } catch (IOException e) {
            e.printStackTrace();
            throw new TaxBaseSystemException("错误编码:(IOException)"+ String.valueOf(21001) +","+ e.getMessage());
        } catch (SQLException e) {
            e.printStackTrace();
            throw new TaxBaseSystemException("错误编码:(SQLException)"+ String.valueOf(21001) +","+ e.getMessage());
        }catch (Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException("错误编码:(Exception)"+ String.valueOf(21001) +","+ e.getMessage());
        }
    }

    //msg: format: 指标1，指标2，指标3，
    //mbbm:模板编码
    //mblb:模板类别
    //返回指标信息 Vector WDSCwdmbzbDAO
    private Vector getMbZb(String msg, String mbbm, String mblb) throws TaxBaseSystemException{

      Vector vTemp = new Vector();
      try {
        String tempArray[] = msg.split(",");
        for (int i = 0; i < tempArray.length; i++) {
          if (!tempArray[i].equals("")) {
            WDSCwdmbzbDAO mbzb = new WDSCwdmbzbDAO();
            mbzb.setMB_DM(mbbm);
            mbzb.setZB_DM(tempArray[i]);
            mbzb.setMB_LB(mblb);
            mbzb.setXG_SJ(new Date());
            //调用系统变量填入操作员编码
            mbzb.setXG_CZY_DM("000000");
            mbzb.setMB_SWJG("%");
            vTemp.add(mbzb);
          }
        }
      } catch(Exception e) {
          throw new TaxBaseSystemException(e.getMessage());
      }
      return vTemp;
    }

    private List getWdMb(String swjg) throws Exception {
        try {
            WDSCwdmbDAO wdmb = new WDSCwdmbDAO();
            return wdmb.getWdMb(swjg);
        }catch(Exception e) {
            e.printStackTrace();
            throw new Exception(e.getMessage());
        }

    }


    /////////////////////////////////////////////////////////////////////////
    /////////////////////////////////////////////////////////////////////////
    /////////////////////////////////////////////////////////////////////////
    //页面接口

    //通过 税务机关取得 文档模板的信息
    private ResponseEvent IgetWdMbMsg(WDSCmbwhReqEvent reqEvent) throws TaxBaseSystemException, Exception {
        WDSCmbwhResEvent resEvent = new WDSCmbwhResEvent();
        String swjg = "%";
        //swjg = reqEvent.getSwjg();
        try {
            List list = getWdMb(swjg);
            resEvent.setMbList(list);
            resEvent.setRetStr("取模板,税务机关编码:" + swjg + "。");
        } catch (Exception e) {
            e.printStackTrace();
            throw new TaxBaseSystemException(e.getMessage());
        }
        resEvent.setRepCode("0");
        return resEvent;
    }

    private ResponseEvent IaddMbZb(WDSCmbwhReqEvent reqEvent) throws TaxBaseSystemException {
         WDSCmbwhResEvent resEvent = new WDSCmbwhResEvent();
         String addmsg = reqEvent.getAddZbElement();
         String mbbm = reqEvent.getMbbm();
         String mblb = reqEvent.getMB_LB();
         try {
             Vector v = getMbZb(addmsg, mbbm, mblb);
             IaddMbZb(v);
             resEvent.setRetStr("增加模板指标,模板编码:" + mbbm +
                               ", 模板类别:" + mblb + ", 指标信息:" + addmsg + "。");

         } catch (Exception e) {
             throw new TaxBaseSystemException(e.getMessage());
         }
         resEvent.setRepCode("0");
         return resEvent;
    }

    private ResponseEvent IdelMbZb(WDSCmbwhReqEvent reqEvent) throws TaxBaseSystemException {
        WDSCmbwhResEvent resEvent = new WDSCmbwhResEvent();
        String delmsg = reqEvent.getDelZbElement();
        String mbbm = reqEvent.getMbbm();
        String mblb = reqEvent.getMB_LB();
        try {
            Vector v = getMbZb(delmsg, mbbm, mblb);
            int i = IdelMbZb(v, mbbm, mblb);