用友每日批处理

最新推荐文章于 2022-03-17 19:51:23 发布
tt39635552
最新推荐文章于 2022-03-17 19:51:23 发布
阅读量1.1k
点赞数
CC 4.0 BY-SA版权
分类专栏： XML 文章标签： null table date filenames xml buffer
本文链接：https://blog.youkuaiyun.com/tt39635552/article/details/2914274
XML 专栏收录该内容
3 篇文章
订阅专栏
该博客主要介绍了如何使用Java处理用友系统的XML批处理任务，包括校验文件、费用总额核对、异常记录、文件操作和事务管理。通过检查文件的记录数、大小、验证码等信息，以及执行不同的操作如费用录入和更正处理。
摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >
package cn.gwssi.cpees.d_sf.xml;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.lang.reflect.Method;
import java.text.SimpleDateFormat;
import java.util.Date;
import cn.gwssi.common.component.exception.TxnException;
import cn.gwssi.common.component.security.MD5;
import cn.gwssi.common.component.util.DateUtil;
import cn.gwssi.common.context.DataBus;
import cn.gwssi.common.context.Recordset;
import cn.gwssi.common.context.TxnContext;
import cn.gwssi.common.dao.BaseTable;
import cn.gwssi.common.dao.ds.ConnectFactory;
import cn.gwssi.common.dao.impl.TableFactory;
import cn.gwssi.common.txn.xml.XmlDocument;
import cn.gwssi.cpees.d_sf.exception.FeiyongException;
public class ReadAndDoAction extends XmlDocument {
    public String getConfigFileName(TxnContext arg0) {      
        return "E:/index080220151023.XML";
    }
    public ReadAndDoAction()
    {
        super();
        dtdFile = "/cn/gwssi/cpees/d_sf/xml/dtd/idx.dtd";
        
    }
     public void txn02(TxnContext context)throws TxnException
     {
        //异常输出文件 
         File file = new File("c://批处理异常信息.txt");
        //记录异常 
        StringBuffer sumString = new StringBuffer();//总线程异常  
        //************************校验费总******************************* 
        Recordset set = checkSumFee();
        DataBus da = new DataBus();
        da.addRecord("核对结果", set);
        //****************************校验文件*************************** 
        Recordset index = config.getRecordset("filerecord", null );
        Recordset tempIndex = (Recordset)index.clone();//克隆文件信息      
        publicMothed(tempIndex, sumString);//实体操作类 
        try {
            BufferedWriter write = new BufferedWriter(new FileWriter(file,true));
            write.write(da.toString());
            write.write(sumString.toString());
            write.close();
        } catch (IOException e) {
            e.printStackTrace();
        }   
        
    }
     //核对费总 核对每笔费用的原始费用表中数据是否与待生效+已生效+退费的总和是否相等 
     private Recordset checkSumFee() throws TxnException{
         TxnContext context = new TxnContext();
        BaseTable table1 = TableFactory.getInstance().getTableObject(this, "gg_fy_ysxfyjlb");//已生效费用表 
        BaseTable table2 = TableFactory.getInstance().getTableObject(this, "gg_fy_dsxfyjlb");//待生效费用表 
        BaseTable table3 = TableFactory.getInstance().getTableObject(this, "sf_ysfyb");//原始费用表 
        BaseTable table4 = TableFactory.getInstance().getTableObject(this, "gg_fy_tfclb");//退费处理表        
        table3.executeFunction("selectUseFeeList",context, "", "recordforyxfy");//查询有效费用 
        Recordset set = context.getRecordset("recordforyxfy");
        Recordset setMes = new Recordset();//记录核对信息 
        int count = set.size();
        for(int i=0;i<count;i++){
            String feiyongid = set.get(i).getValue("feiyongid");//费用ID 
            String jiaofeije = set.get(i).getValue("jiaofeije");//缴费金额 
            DataBus da = new DataBus();
            //1.查询费用表 
            context.getRecord("selectall").setValue("feiyongid", feiyongid);
            table1.executeFunction("getSumFeeByFeiyongid",context, "selectall", "recordgetysxju");//已生效 
            table2.executeFunction("getSumFeeByFeiyongid",context, "selectall", "recordgetdsxju");//待生效 
            table4.executeFunction("getSumFeeByFeiyongid",context, "selectall", "recordgettf");//退费处理 
            
            String ysxje = context.getRecord("recordgetysxju").getValue("fee");
            String dsxje = context.getRecord("recordgetdsxju").getValue("fee");
            String tfje = context.getRecord("recordgettf").getValue("fee");
            if(ysxje.equals("")){
                ysxje = "0";
            }
            if(dsxje.equals("")){
                dsxje = "0";
            }
            if(tfje.equals("")){
                tfje = "0";
            }   
            Double sumFee = Double.parseDouble(ysxje)+ Double.parseDouble(dsxje)+Double.parseDouble(tfje);
            if(sumFee!=Double.parseDouble(jiaofeije)){
                da.put("feiyongid", feiyongid);
                da.put("status", "错误");
            }else{
                da.put("feiyongid", feiyongid);
                da.put("status", "正常");
            }
           setMes.add(da);
        }   
        return setMes;
     }
     //公共方法类 
     private void publicMothed(Recordset tempIndex,StringBuffer sumString) throws TxnException{
         
         StringBuffer buffer = new StringBuffer();//记录异常信息 
         int tempIndexSize = tempIndex.size();
         for(int i=0;i<tempIndexSize;i++){           
             buffer = checkWenj(tempIndex.get(i), i);
             sumString.append("文件校验信息");
             sumString.append("/n");
             sumString.append(buffer);
             sumString.append("/n");            
         }
            
     }
     //文件验证辅助类 
     private StringBuffer checkWenj(DataBus db, int i)throws TxnException{
            StringBuffer buffer = new StringBuffer();//记录异常信息 
            try{
             checkIndexMes(db, i);
             String wenjianm = db.getValue("FILENAME").trim();//子文件名     
             String jiluts  = db.getValue("RECORDCOUNT").trim();//记录条数 
             String wenjiandx  = db.getValue("FILESIZE").trim();//文件大小 
             String fz  = db.getValue("CHARGETOTAL").trim();//费总 
             String sm  = db.getValue("FILEMEMO").trim();//说明 
             String wenjianxym  = db.getValue("FILEMD5").trim();//验证码 
             File xmlFile = new File("E:/");//xml暂定存储E盘 
             String[] str = xmlFile.list();
             int fileCount = str.length;
             int temp = 0;//文件存在与否标示 
             //查找文件 
             String fileName = null;
             //****************************************************** 
             for(int j=0;j<fileCount;j++){
                 String fileNames = str[j].trim();//文件名 
                 if(wenjianm.equals(fileNames)){//如果文件名相同,即文件存在 
                     fileName = fileNames;
                     temp = 1;  
                 }
             }
             //****************************************************** 
             if(temp==1){
                   DataBus getResourse = getDtdFile(fileName);//得到文件相关信息 
                    File file = new File(getResourse.getValue("xml"));
                    long fileSize = file.length();//xml大小 
                    String mdValue = new MD5().getMD5Code(getResourse.getValue("xml"));//得到文件验证码 
                    config.setData(new DataBus());
                    config.parser(getResourse.getValue("xml"), getResourse.getValue("dtd"));
                    Recordset patent = config.getRecordset(getResourse.getValue("part"), null );    //得到具体文件结点 
                    String check = getResourse.getValue("check");
                    if(null!=check && check.equals("1")){//如果是已记账信息，检查费用总额 
                        boolean isEqual = checkSumFeeForPos(fz, patent);
                        if(!isEqual){
                          buffer.append("第"+(i+1)+"条文件已记账费总不符");
                          }
                        }
                        if(Integer.parseInt(jiluts)!=(patent.size())){
                            buffer.append("第"+(i+1)+"条文件记录数不符");
                        }else if(Long.parseLong(wenjiandx)!=fileSize){
                            buffer.append("第"+(i+1)+"条文件大小不符");
                        }else if(!(mdValue.equals(wenjianxym))){
                            buffer.append("第"+(i+1)+"条文件验证码错误");
                        }else{
                            buffer.append("/n");
                            buffer.append("******************"+sm+"操作日志"+getTime()+"************************");
                            buffer.append(doAction(fileName, patent));//操作方法 
                            buffer.append("/n");
                        }
                                            
             }else{
                       buffer.append("第"+(i+1)+"条文件找不到");
             }
            }catch (FeiyongException e) {
                buffer.append(e.getMessage());
                buffer.append("/n");            
            }
         return buffer;
     }
        
    
    //未记账信息录入 
    private StringBuffer actionForClzMes(Recordset patent) throws TxnException{
        TxnContext context = new TxnContext();
        StringBuffer buffer = new StringBuffer();//记录异常信息 
        int count = patent.size();
        for(int i=0;i<count;i++){   
            try{
            ConnectFactory.getInstance().begin();//开始一个事物 
                //异常处理 
            checkClzMes(patent.get(i),i);
            DataBus da = new DataBus();
            String jiaofeisj = patent.get(i).getValue("TC_PMT_DAT");//缴费时间 
            da.put("feiyongid", patent.get(i).getValue("TC_ROWID"));//费用ID 
            da.put("shenqingh",patent.get(i).getValue("TC_APP_DOM"));//申请号 
            da.put("guowaisqh", patent.get(i).getValue("TC_APP_INT"));//国外申请号 
            da.put("jiaofeisj", changeDate(jiaofeisj));//缴费时间 
            
            da.put("feiyongzldm", patent.get(i).getValue("TC_KM_CODE"));//费用种类代码 
            da.put("feiyongzlmc",patent.get(i).getValue("TC_KM_NAME"));//费用种类名称 
            da.put("jiaofeije", patent.get(i).getValue("TC_JE_RMB"));//缴费金额  
            
            da.put("jiaofeirxm", patent.get(i).getValue("TC_PMT"));//缴费人姓名 
            da.put("jiaofeirdz", patent.get(i).getValue("TC_PMT_ADDR"));//缴费人地址 
            da.put("jiaofeiryb", patent.get(i).getValue("TC_PMT_ZIP"));//缴费人邮编 
            da.put("feiyongbj", patent.get(i).getValue("TC_STAT"));//费用标记 
            context.put("rep", da);
            BaseTable table = TableFactory.getInstance().getTableObject(this, "sf_ysrzcb");
            table.executeFunction("insert one sf_ysrzcb",context, "rep", "record");
            ConnectFactory.getInstance().getConnection().commit();      
        }catch (FeiyongException e) {
            buffer.append(e.getMessage());
            buffer.append("/n");                    
        }catch (TxnException ef){
            buffer.append("第"+(i+1)+"条"+ef.getMessage());
            buffer.append("/n");
            ConnectFactory.getInstance().rollback();
        }       
        }
        return buffer;
                
    }
   //已记账信息处理 
    private StringBuffer actionForPayMes(Recordset ele) throws TxnException{      
        TxnContext context = new TxnContext();
        StringBuffer buffer = new StringBuffer();//记录异常信息 
        int counts = ele.size();
        for(int j=0;j<counts;j++){
            try{
            ConnectFactory.getInstance().begin();//开始一个事物 
            DataBus db = new DataBus();         
            //异常处理 
            checkYsfMes(ele.get(j),j);          
            db.put("feiyongid", ele.get(j).getValue("TC_ROWID"));
            
            db.put("shenqingh",ele.get(j).getValue("TC_APP_DOM"));
            db.put("guowaisqh", ele.get(j).getValue("TC_APP_INT"));
            db.put("jiaofeisj", changeDate(ele.get(j).getValue("TC_PMT_DAT")));
            
            db.put("feiyongzldm", ele.get(j).getValue("TC_KM_CODE"));
            db.put("feiyongzlmc",ele.get(j).getValue("TC_KM_NAME"));
            db.put("jiaofeije", ele.get(j).getValue("TC_JE_RMB"));
            db.put("shoujuh", ele.get(j).getValue("TC_RCP"));
            db.put("shoujurq", changeDate(ele.get(j).getValue("TC_RCP_DAT")));
            
            db.put("jiaofeirxm", ele.get(j).getValue("TC_PMT"));
            db.put("jiaofeirdz", ele.get(j).getValue("TC_PMT_ADDR"));
            db.put("jiaofeiryb", ele.get(j).getValue("TC_PMT_ZIP"));
            db.put("feiyongbj", ele.get(j).getValue("TC_STAT"));
            db.put("shaomiaozt", "1");//已扫描 
        
        //1.插原始费用表 
        context.put("repa", db);
        BaseTable tablea = TableFactory.getInstance().getTableObject(this, "sf_ysfyb");
        tablea.executeFunction("insert one sf_ysfyb",context, "repa", "record");
        //插待生效费用表 
        DataBus dc = db;
        String shenqingh = dc.getValue("shenqingh");//得到申请号 
        if(!(shenqingh.equals(""))){
            dc.remove("guowaisqh");
            dc.remove("xiaofeirxm");
            dc.remove("xiaofeirdz");
            dc.remove("xiaofeiryb");
            dc.remove("feiyongbj");
            dc.remove("shaomiaozt");
            dc.setValue("xitongjzsj", this.getTime());
            dc.setValue("yanshijfje", dc.getValue("jiaofeije"));
            dc.setValue("feiyongzt", "1");//暂定为1 
            context.put("repb", dc);
            //2.插入待生效费用表中 
            BaseTable tableb = TableFactory.getInstance().getTableObject(this,"gg_fy_dsxfyjlb");
            tableb.executeFunction("insert one gg_fy_dsxfyjlb", context,"repb", "record"); 
        }           
        ConnectFactory.getInstance().getConnection().commit();
        } catch (FeiyongException e) {
            buffer.append(e.getMessage());
            buffer.append("/n");            
        }catch (TxnException ef){
            buffer.append("第"+(j+1)+"条"+ef.getMessage());
            buffer.append("/n");
            ConnectFactory.getInstance().rollback();
        }       
        }
        return buffer;
    }
    //根据规定费用表中的申请号和费用种类代码查询待生效费用表中对应费用是否费足 
    private StringBuffer updateFyzt() throws TxnException{
        TxnContext context = new TxnContext();
        StringBuffer buffer = new StringBuffer();//记录异常信息 
        BaseTable tableone = TableFactory.getInstance().getTableObject(this,"gg_fy_gdqxfyglb");
        tableone.executeFunction("getMoneyBysqhAndfydm", context,"select-key", "recordforsqhandfydm"); 
        Recordset seta = context.getRecordset("recordforsqhandfydm");//得到对比费用集合 
        int size = seta.size();
        for(int i = 0;i<size;i++){
            try{
            ConnectFactory.getInstance().begin();//开始一个事物 
            DataBus databus = seta.get(i);
            DataBus tempda = (DataBus)databus.clone();//暂存修改费用状态条件 
            tempda.remove("shijiaoje");
            tempda.remove("jiaofeije");
            String shijiaoje = databus.getValue("shijiaoje");//规定要交金额 
            String sumje = databus.getValue("jiaofeije");//实际缴费金额 
            if(null==shijiaoje && shijiaoje.equals("")){
                shijiaoje = "0";
            }
            if(null==sumje && sumje.equals("")){
                sumje = "0";
            }
            Double gdje =  Double.parseDouble(shijiaoje);//规定金额 
            Double sjje =  Double.parseDouble(sumje);//实际金额 
            if(sjje>=gdje){
            tempda.put("feiyongzt", "1"); //费足 
            }else{
            //将费用状态置为2 
            tempda.put("feiyongzt", "2");//费不足 
            }           
            //根据是否足额判断是否费足或不足 
            context.put("updatefeiyongztbysqhandfydm", tempda);
            tableone.executeFunction("update feiyongzt bysqhandfydm", context,"updatefeiyongztbysqhandfydm", "recordByupdate");             
            ConnectFactory.getInstance().getConnection().commit();
            }catch (TxnException e){
                buffer.append("第"+(i+1)+"条"+e.getMessage());
                buffer.append("/n");
                ConnectFactory.getInstance().rollback();
            }       
        }
        return buffer;
    }
    //费用更正信息读取信息到收费处更正表 
    private StringBuffer actionForGzMes(Recordset gz) throws TxnException{
        TxnContext context = new TxnContext();
        StringBuffer buffer = new StringBuffer();//记录异常信息 
        int gzSize =  gz.size();
        for(int j=0;j<gz.size();j++){
            System.out.println(gz.get(j));
        }
        for(int i = 0;i<gzSize;i++){
            BaseTable table = TableFactory.getInstance().getTableObject(this, "sf_sfcgzb");
            try{
            ConnectFactory.getInstance().begin();//开始一个事务 
            //检查字段异常 
            checkGzMes(gz.get(i),i);
            DataBus gzda = new DataBus();
            gzda.put("feiyongid", gz.get(i).getValue("TC_ROWID"));//费用ID 
            gzda.put("shenqingh", gz.get(i).getValue("TC_APP_DOM"));//申请号 
            gzda.put("guowaisqh", gz.get(i).getValue("TC_APP_INT"));//国外申请号  
            gzda.put("feiyongzldm", gz.get(i).getValue("TC_KM_CODE"));//费用代码 
            gzda.put("feiyongzlmc", gz.get(i).getValue("TC_KM_NAME"));//费用种类名称   
            gzda.put("jiaofeije", gz.get(i).getValue("TC_JE_RMB"));//费用金额 
            gzda.put("jiaofeisj", changeDate(gz.get(i).getValue("TC_PMT_DAT")));//缴费时间 
            gzda.put("shoujuh", gz.get(i).getValue("TC_RCP"));//收据号 
            gzda.put("yuanshenqh", gz.get(i).getValue("TC_APP_DOM1"));//原申请号 
            gzda.put("yuanguowsqh", gz.get(i).getValue("TC_APP_INT1"));//原国外申请号 
            gzda.put("yuanfeiyzldm", gz.get(i).getValue("TC_KM_CODE1"));//原费用种类代码 
            gzda.put("yuanfeiyzlmc", gz.get(i).getValue("TC_KM_NAME1"));//原费用种类名称 
            gzda.put("yuanjfje", gz.get(i).getValue("TC_JE_RMB1"));//原缴费金额 
            gzda.put("yuanjiaofsj", changeDate(gz.get(i).getValue("TC_PMT_DAT1")));//原缴费时间 
            gzda.put("yuanshoujh", gz.get(i).getValue("TC_RCP1"));//原收据号 
            gzda.put("gengzhengm", gz.get(i).getValue("TC_MOD_TYPE"));//更正码 
            gzda.put("gengzhengzt", "0");//更正状态 
            gzda.put("gengzhengtcrq", changeDate(gz.get(i).getValue("TC_MOD_DATE")));//提出更正日期 
            gzda.put("gengzhengsm", gz.get(i).getValue("TC_MOD_MEMO"));//更正说明 
            context.put("repgzrk", gzda);
            table.executeFunction("insert one sf_sfcgzb",context, "repgzrk", "record");         
            ConnectFactory.getInstance().getConnection().commit();
            }catch (FeiyongException e) {
                buffer.append(e.getMessage());
                buffer.append("/n");        
            }catch (TxnException ef){
                buffer.append("第"+(i+1)+"条"+ef.getMessage());
                buffer.append("/n");
                ConnectFactory.getInstance().rollback();
            }           
        }
        return buffer;
    }
    //费用更正信息读取后操作 
    private StringBuffer actionAfterGzMes() throws TxnException{
        TxnContext context = new TxnContext();
        StringBuffer buffer = new StringBuffer();//记录异常信息 
        context.getRecord("selectgz").setValue("gengzhengzt", "0");
        
        BaseTable table = TableFactory.getInstance().getTableObject(this, "sf_sfcgzb");//收费处更正表 
        BaseTable table1 = TableFactory.getInstance().getTableObject(this, "gg_fy_ysxfyjlb");//已生效费用表 
        BaseTable table2 = TableFactory.getInstance().getTableObject(this, "gg_fy_dsxfyjlb");//待生效费用表 
        BaseTable table3 = TableFactory.getInstance().getTableObject(this, "sf_ysfyb");//原始费用表 
        BaseTable table4 = TableFactory.getInstance().getTableObject(this, "gg_fy_tfclb");//退费处理表 
        
        table.executeFunction("select sf_sfcgzb list",context, "selectgz", "recordforwgz");
        Recordset setwgz = context.getRecordset("recordforwgz");//得到未更正的全部记录 
        int wgzcount = setwgz.size();
        for(int j = 0;j<wgzcount;j++){
            try{
            ConnectFactory.getInstance().begin();//开始一个事务 
            /////////////////////////////////////////////////////////////////////////////// 
            String uuid = setwgz.get(j).getValue("uuid");//得到主键 
            String feiyongid = setwgz.get(j).getValue("feiyongid");//费用ID 
            
            String gengzhengm = setwgz.get(j).getValue("gengzhengm");//更正类型 
            /////////////比对字段/////////////////////// 
            String yuanshenqh = setwgz.get(j).getValue("yuanshenqh");//原申请号 
            String yuanguowsqh = setwgz.get(j).getValue("yuanguowsqh");//原国外申请号 
            String yuanjiaofsj = setwgz.get(j).getValue("yuanjiaofsj");//原缴费时间 
            String yuanfeiyzldm = setwgz.get(j).getValue("yuanfeiyzldm");//原费用种类代码 
            String yuanfeiyzlmc = setwgz.get(j).getValue("yuanfeiyzlmc");//原费用种类名称 
            String yuanshoujh = setwgz.get(j).getValue("yuanshoujh");//原收据号 
            String yuanjfje = setwgz.get(j).getValue("yuanjfje");//原缴费金额 
            ///////////////修改字段///////////////// 
            String shenqingh = setwgz.get(j).getValue("shenqingh");//申请号 
            String guowaisqh = setwgz.get(j).getValue("guowaisqh");//国外申请号 
            String jiaofeisj = setwgz.get(j).getValue("jiaofeisj");//缴费时间 
            String feiyongzldm = setwgz.get(j).getValue("feiyongzldm");//费用种类代码 
            String feiyongzlmc = setwgz.get(j).getValue("feiyongzlmc");//费用种类名称 
            String shoujuh = setwgz.get(j).getValue("shoujuh");//收据号 
            String jiaofeije = setwgz.get(j).getValue("jiaofeije");//缴费金额 
            ///////////////////////////////////////// 
            if(null==uuid || uuid.equals("") || null==feiyongid || feiyongid.equals("")){
                throw new FeiyongException("041002","没有要更正的信息");
            }else{
                //1.查询费用表 
                context.getRecord("selectbyfeiyongid").setValue("feiyongid", feiyongid);
                table1.executeFunction("get items for feiyong gengzheng",context, "selectbyfeiyongid", "recordgetysxju");//已生效 
                table2.executeFunction("get items for feiyong gengzheng",context, "selectbyfeiyongid", "recordgetdsxju");//待生效 
                table4.executeFunction("getExiteRecord",context, "selectbyfeiyongid", "recordgettf");//退费处理 
                
                Recordset ysxset = context.getRecordset("recordgetysxju");//得到已生效费用记录 
                Recordset dsxset = context.getRecordset("recordgetdsxju");//得到待生效费用记录 
                Recordset tfset = context.getRecordset("recordgettf");//得到退费处理记录 
                int acount = ysxset.size();
                int bcount = dsxset.size();
                int ccount = tfset.size();
                char sjh = 0;
                char sqh  = 0;
                char gwsqh  = 0;
                char jfrq  = 0;
                char fydm  = 0;
                char fydmmc  = 0;
                char fyje  = 0;
                //*********************************************************// 
                if(acount==0 && bcount==0 && ccount==0){ //如果没有纪录 
                    throw new FeiyongException("041002","费用id为:"+feiyongid+"的费用信息为空");
                }
                if(acount==0 && ccount==0 && bcount!=0){//如果只有待生效有记录,删除记录,同时将原始费用表中对应费用ID记录插入该表 修改两张表和该更正表状态 
                    context.getRecord("deletedsxbyid").setValue("feiyongid", feiyongid);
                    table2.executeFunction("delete record by feiyongid",context, "deletedsxbyid", "recorddeletebyid");//待生效 
                    table3.executeFunction("select record list",context, "deletedsxbyid", "recordforysjl");//查询得到原始记录 
                    Recordset setysfy = context.getRecordset("recordforysjl");//得到原始记录信息(唯一一条) 
                    if(setysfy.size()==0){
                        throw new FeiyongException("041002","费用id为:"+feiyongid+"记录对应原始费用为空");
                        
                    }else{
                        DataBus tempdatabusa = setysfy.get(0);
                        //比对修改信息 
                        if(!(tempdatabusa.getValue("shenqingh").equals(yuanshenqh)) 
                            && !(tempdatabusa.getValue("guowaisqh").equals(yuanguowsqh))
                            && !(tempdatabusa.getValue("jiaofeisj").equals(yuanjiaofsj))
                            && !(tempdatabusa.getValue("feiyongzldm").equals(yuanfeiyzldm))
                            && !(tempdatabusa.getValue("feiyongzlmc").equals(yuanfeiyzlmc))
                            && !(tempdatabusa.getValue("shoujuh").equals(yuanshoujh))
                            && !(tempdatabusa.getValue("jiaofeije").equals(yuanjfje))
                                ){
                            throw new FeiyongException("041003","费用id为:"+feiyongid+"更正信息中原始信息与原始费用表中信息不对应");
                        }else{//更正操作 
                            //1.修改原始费用表 
                            context.getRecord("updatetj").setValue("feiyongid", feiyongid);
                             sqh  = gengzhengm.charAt(0);
                             gwsqh  = gengzhengm.charAt(1);
                             jfrq  = gengzhengm.charAt(2);
                             fydm  = gengzhengm.charAt(3);
                             fydmmc  = gengzhengm.charAt(4);
                            sjh  = gengzhengm.charAt(5);
                             fyje  = gengzhengm.charAt(6);
                            
                            if(sqh=='1'){
                                context.getRecord("updatetj").setValue("shenqingh", shenqingh);
                            }
                            if(gwsqh=='1'){
                                context.getRecord("updatetj").setValue("guowaisqh", guowaisqh);
                            }
                            if(jfrq=='1'){
                                context.getRecord("updatetj").setValue("jiaofeisj", jiaofeisj);
                            }
                            if(fydm=='1'){
                                context.getRecord("updatetj").setValue("feiyongzldm", feiyongzldm);
                            }
                            if(fydmmc=='1'){
                                context.getRecord("updatetj").setValue("feiyongzlmc", feiyongzlmc);
                            }
                            if(sjh=='1'){
                                context.getRecord("updatetj").setValue("shoujuh", shoujuh);
                            }
                            if(fyje=='1'){
                                context.getRecord("updatetj").setValue("jiaofeije", jiaofeije);
                            }       
                        table3.executeFunction("updateForGz",context, "updatetj", "recordupdatays");//按更正信息修改原始费用信息 
                        context.remove("updatetj");
                        context.getRecord("selectbyfeiyongids").setValue("feiyongid", feiyongid);
                        table3.executeFunction("select record list",context, "selectbyfeiyongids", "recordbyxiugaih");//查询得到修改后原始记录 
                        //插入待生效费用表 
                        DataBus xiugaidb = context.getRecord("recordbyxiugaih");            
                        xiugaidb.remove("guowaisqh");
                        xiugaidb.remove("xiaofeirxm");
                        xiugaidb.remove("xiaofeirdz");
                        xiugaidb.remove("xiaofeiryb");
                        xiugaidb.remove("feiyongbj");
                        xiugaidb.remove("shaomiaozt");
                        xiugaidb.setValue("xitongjzsj", this.getTime());
                        xiugaidb.setValue("yanshijfje", xiugaidb.getValue("jiaofeije"));
                        xiugaidb.setValue("feiyongzt", "1");//暂定为1 
                        xiugaidb.setValue("gzid", uuid);//更正id 
                        context.put("insertRecord", xiugaidb); 
                        table2.executeFunction("insert one gg_fy_dsxfyjlb", context,"insertRecord", "record");
                        context.remove("insertRecord");
                        //修改更正信息 
                        context.getRecord("xiugaigzzt").setValue("uuid", uuid);//主键 
                        context.getRecord("xiugaigzzt").setValue("gengzhengzt", "1");//更正状态改为已更正 
                        context.getRecord("xiugaigzzt").setValue("gengzhengzxsj", this.getTime());//更正执行时间 
                        table.executeFunction("update one sf_sfcgzb",context, "xiugaigzzt", "record");  
                        context.remove("xiugaigzzt");
                        }                       
                    }                                                       
                }
            
                if(acount!=0){
                    //将费用ID匹配的已生效费用记录的费用状态改为待释放(如果需要修改收据号该收据号) 
                    context.getRecord("updateysxfyzt").setValue("feiyongid", feiyongid);//修改条件:费用ID 
                    if(sjh=='1'&& sqh=='0'&& gwsqh=='0'&& jfrq=='0'&& fydm=='0'&& fydmmc=='0'&& fyje=='0'){
                        context.getRecord("updateysxfyzt").setValue("shoujuh", shoujuh);
                        table1.executeFunction("update sjh by feiyongid",context, "updateysxfyzt", "recordupdateysxfyzt");
                        context.getRecord("updatetj").setValue("shoujuh", shoujuh);
                        table3.executeFunction("updateForGz",context, "updatetj", "recordupdatays");//按更正信息修改原始费用信息 
                         context.getRecord("xiugaigzzt").setValue("uuid", uuid);//主键 
                        context.getRecord("xiugaigzzt").setValue("gengzhengzt", "1");//更正状态改为已更正 
                        context.getRecord("xiugaigzzt").setValue("gengzhengzxsj", this.getTime());//更正执行时间 
                        table.executeFunction("update one sf_sfcgzb",context, "xiugaigzzt", "record");  
                    }
                        
                        context.getRecord("updateysxfyzt").setValue("feiyongzt", "1");//修改记录:费用状态 
                        table1.executeFunction("update feiyongzt by feiyongid",context, "updateysxfyzt", "recordupdateysxfyzt");  
                        context.remove("updateysxfyzt");
                }
                if(ccount!=0){
                    if(sjh=='1'&& sqh=='0'&& gwsqh=='0'&& jfrq=='0'&& fydm=='0'&& fydmmc=='0'&& fyje=='0'){
                        context.getRecord("updatesjh").setValue("feiyongid", feiyongid);//修改条件:费用ID 
                        context.getRecord("updatesjh").setValue("shoujuh", shoujuh);
                        table4.executeFunction("update sjh by feiyongid",context, "updatesjh", "recordupdatesjh");
                        context.remove("updatesjh");
                    }
                    continue;
                }
                //****************************************************************//             
            }           
            ////////////////////////////////////////////////////////////////////////////// 
            ConnectFactory.getInstance().getConnection().commit();
            }catch (FeiyongException e) {
                buffer.append(e.getMessage());
                buffer.append("/n");
                ConnectFactory.getInstance().rollback();            
            }catch (TxnException ef){
                buffer.append("第"+(j+1)+"条"+ef.getMessage());
                buffer.append("/n");
                ConnectFactory.getInstance().rollback();
            }       
        }
        return buffer;
    }
    //费用代码费用标准减缓比例信息录入 
    private StringBuffer actionForFjblMes(Recordset fjbl) throws TxnException{
        TxnContext context = new TxnContext();
        StringBuffer buffer = new StringBuffer();//记录异常信息 
        BaseTable table = TableFactory.getInstance().getTableObject(this, "gg_fy_fycspzb");
        int fjblsize = fjbl.size();
        for(int i=0;i<fjblsize;i++){
            ///////////////////////////////////// 
            try{
            ConnectFactory.getInstance().begin();//开始一个事务 
            //异常处理 
            checkFjblMes(fjbl.get(i),i);
            //根据费用种类代码查询费用简称 
            context.getRecord("selectfjbl").setValue("feiyongzldm", fjbl.get(i).getValue("TC_KM_CODE"));//费用种类代码 
            table.executeFunction("getFeiyjcByFyzldm",context, "selectfjbl", "recordfjbl");
            String feiyongjc = context.getRecord("recordfjbl").getValue("feiyongjc");//费用简称 
            DataBus fjblda = new DataBus();
            fjblda.put("feiyongzldm", fjbl.get(i).getValue("TC_KM_CODE"));//费用种类代码 
            fjblda.put("feiyongzlmc", fjbl.get(i).getValue("TC_KM_NAME"));//费用种类名称 
            fjblda.put("jiaofeije", fjbl.get(i).getValue("TC_KM_JE_RMB"));//费用金额 
            fjblda.put("feiyongjc", feiyongjc);//费用金额 
            fjblda.put("feiyongjhbl1", fjbl.get(i).getValue("TC_DERATE1"));//减缓比例1 
            fjblda.put("feiyongjhbl2", fjbl.get(i).getValue("TC_DERATE2"));//减缓比例2 
            fjblda.put("feiyongjhbl3", fjbl.get(i).getValue("TC_DERATE3"));//减缓比例3 
            fjblda.put("zhixingsj", changeDate(fjbl.get(i).getValue("TC_KM_DATE")));//执行日期  
            context.put("repfjbl", fjblda);         
            table.executeFunction("insert one gg_fy_fycspzb",context, "repfjbl", "record");
            ConnectFactory.getInstance().getConnection().commit();  
            }catch (FeiyongException e) {
                buffer.append(e.getMessage());
                buffer.append("/n");        
            }catch (TxnException ef){
                buffer.append("第"+(i+1)+"条"+ef.getMessage());
                buffer.append("/n");
                ConnectFactory.getInstance().rollback();
            }       
            /////////////////////////////////////// 
        }
        return buffer;
    }
    //退费处理 
    private StringBuffer actionForTfMes(Recordset tf) throws TxnException{
        TxnContext context = new TxnContext();
        StringBuffer buffer = new StringBuffer();//记录异常信息 
        int tfSize = tf.size();
        BaseTable tablea = TableFactory.getInstance().getTableObject(this, "gg_fy_tfclb");//退费处理表 
        BaseTable tableb =  TableFactory.getInstance().getTableObject( this, "gg_fy_dsxfyjlb");//待生效记录表 
        BaseTable tablec =  TableFactory.getInstance().getTableObject( this, "gg_fy_chtfjlb");//撤回退费记录表 
        for(int i = 0;i<tfSize;i++){
            ////////////////////////////////////////////////////// 
            try{
                ConnectFactory.getInstance().begin();//开始一个事务 
                checkTfMes(tf.get(i),i);//字段异常处理 
                String tuifeiid = tf.get(i).getValue("TC_RFD_ID");//退费ID 
                String tuifeizt = tf.get(i).getValue("TC_RFD_STAT");//退费状态 
                String shenqingh = tf.get(i).getValue("TC_APP_DOM");//申请号 
                String chulisj = changeDate(tf.get(i).getValue("TC_RFD_DATE"));//实际退费时间 
                //根据费用id查询退费处理表中数据 
                context.getRecord("selecttf").setValue("tuifeilsh", tuifeiid);//退费ID 
                tablea.executeFunction("getExiteRecord",context, "selecttf", "recordtfa");
                String feiyongid = context.getRecord("recordtfa").getValue("feiyongid");//费用ID  
                String tuifeibj = context.getRecord("recordtfa").getValue("tuifeibj");//退费标记 
                String tuifeije = context.getRecord("recordtfa").getValue("tuifeije");//退费金额 
                //////////////////////待生效费用表字段///////////////////////////////////// 
                //用于增加 
                context.getRecord("insertdsx").setValue("shenqingh",context.getRecord("recordtfa").getValue("shenqingh"));//申请号 
                context.getRecord("insertdsx").setValue("feiyongzlmc",context.getRecord("recordtfa").getValue("feiyongzlmc"));//费用种类名称 
                context.getRecord("insertdsx").setValue("feiyongzldm",context.getRecord("recordtfa").getValue("feiyongzldm"));//费用种类代码 
                context.getRecord("insertdsx").setValue("jiaofeije",context.getRecord("recordtfa").getValue("tuifeije"));//缴费金额 
                context.getRecord("insertdsx").setValue("shoujuh",context.getRecord("recordtfa").getValue("shoujuh"));//收据号 
                context.getRecord("insertdsx").setValue("feiyongid",context.getRecord("recordtfa").getValue("feiyongid"));//费用ID                 
                context.getRecord("insertdsx").setValue("yanshijfje",getParentInfo(feiyongid).getValue("jiaofeije"));//原始缴费金额 
                context.getRecord("insertdsx").setValue("jiaofeisj",getParentInfo(feiyongid).getValue("jiaofeisj"));//原始缴费时间 
                context.getRecord("insertdsx").setValue("xitongjzsj",new DateUtil().currentDate());//系统时间 
                context.getRecord("insertdsx").setValue("feiyongzt","");//费用状态 暂定88 
                context.getRecord("insertdsx").setValue("gzid","");//更正ID 暂定88 
                //////////////////////////////////////////////////////////////////////////// 
                if(null==feiyongid || feiyongid.equals("")){
                    throw new FeiyongException("041002","第"+(i+1)+"条的记录没找到");
                }else if((tuifeizt.equals("1") && tuifeibj.equals("0")) ||(tuifeizt.equals("2") && tuifeibj.equals("2"))){
                    throw new FeiyongException("041003","第"+(i+1)+"条的退费类型不匹配");
                }else {
                    //用于修改退费处理表 
                    context.getRecord("updatetf").setValue("tuifeilsh", tuifeiid);//退费ID 
                    context.getRecord("updatetf").setValue("shijitfrq", chulisj);//实际退费日期 
                    context.getRecord("updatetf").setValue("tuifeibj", "1");//退费标记 
                    //用于删除 
                    context.getRecord("deletetf").setValue("tuifeilsh", tuifeiid);//退费ID 
                    //1.当退费标记为0:-申请退费  (1)用友返回意见为0:-成功退费  (2)用友返回意见为2:-不予退款  
                    if(tuifeibj.equals("0") && tuifeizt.equals("0")){//退费成功   
                        //操作:修改实际退费日期  修改退费标记为1,费用已退 
                        tablea.executeFunction("update one gg_fy_tfclb with sjtfrqandtfbj",context, "updatetf", "record");                                              
                    }
                    if(tuifeibj.equals("0") && tuifeizt.equals("2")){//不予退款 
                        //操作:将退费处理表中记录插入待生效费用表,删除退费处理表中此记录 
                        tableb.executeFunction( "insert one gg_fy_dsxfyjlb", context, "insertdsx", "record");                       
                        tablea.executeFunction( "delete one gg_fy_tfclb", context, "deletetf", "record");
                    }
                    //2.当提出撤回退费2:-撤回退费 (1)用友反馈意见为0:-退费成功  (2)用友反馈意见为1:-已取消退费 
                    if(tuifeibj.equals("2") && tuifeizt.equals("0")){
                        //操作:修改实际退费日期  修改退费标记为1,费用已退  修改撤回退费历史表 
                        tablea.executeFunction("update one gg_fy_tfclb with sjtfrqandtfbj",context, "updatetf", "record");
                        context.getRecord("updatechtf").setValue("tuifeilsh", tuifeiid);//退费ID 
                        context.getRecord("updatechtf").setValue("chehuirq", "");//实际退费日期 
                        context.getRecord("updatechtf").setValue("chehuizt", "2");//无法撤回 
                        tablec.executeFunction("update one gg_fy_chtfjlb",context, "updatechtf", "record");                     
                    }                   
                    if(tuifeibj.equals("2") && tuifeizt.equals("1")){//已经取消退费 即 同意撤回 
                        //操作:将退费处理表中记录插入待生效费用表,删除退费处理表中此记录 修改撤回退费历史表 
                        tableb.executeFunction( "insert one gg_fy_dsxfyjlb", context, "insertdsx", "record");
                        context.getRecord("updatechtf").setValue("tuifeilsh", tuifeiid);//退费ID 
                        context.getRecord("updatechtf").setValue("chehuirq", chulisj);//实际退费日期 
                        context.getRecord("updatechtf").setValue("chehuizt", "0");//已经撤回 
                        tablec.executeFunction("update one gg_fy_chtfjlb",context, "updatechtf", "record"); 
                        tablea.executeFunction( "delete one gg_fy_tfclb", context, "deletetf", "record");                                               
                    }   
                }
                ConnectFactory.getInstance().getConnection().commit();
            }catch (FeiyongException e) {
                buffer.append(e.getMessage());
                buffer.append("/n");
                ConnectFactory.getInstance().rollback();            
            }catch (TxnException ef){
                buffer.append("第"+(i+1)+"条"+ef.getMessage());
                buffer.append("/n");
                ConnectFactory.getInstance().rollback();
            }       
            ////////////////////////////////////////////////////// 
        }   
        return buffer;
    }
    
    //根据费用id得到原始费用表中的相关项目(方法类) 
    private DataBus getParentInfo(String feiyongid) throws TxnException{
        TxnContext context = new TxnContext();
        context.getRecord("rep").setValue("feiyongid",feiyongid);
        BaseTable table = TableFactory.getInstance().getTableObject( this, "gg_fy_dsxfyjlb");
        table.executeFunction( "getDetailedRecord", context, "rep", "recordone");       
        DataBus db = context.getRecord("recordone");
        return db;      
    }
//转换时间格式 2008-01-11--------20080111 
    private String changeDate(String date){
        if(null==date||"".equals(date.trim())){
            return date;
        }
        else{   
        String newDate =date.replaceAll("-", "");
        return newDate;
        }
    }
        
//取当前时间 
    private String getTime(){
        Date date = new Date();
        SimpleDateFormat sim = new SimpleDateFormat("yyyyMMdd");
        return sim.format(date);
    }
    
    //文件校验字段异常处理 
    private void checkIndexMes(DataBus db,int num) throws FeiyongException{
        String wenjianm = db.getValue("FILENAME");//文件名 
        String jiluts  = db.getValue("RECORDCOUNT");//记录条数 
        String feiyongze = db.getValue("CHARGETOTAL");//费用总额 
        String jiluscrq  = db.getValue("FILEDATE");//记录生成日期 
        String wenjiandx  = db.getValue("FILESIZE");//文件大小 
        String wenjianxym  =  db.getValue("FILEMD5");//文件校验码 
        String wenjiansm  =  db.getValue("FILEMEMO");//文件说明  
        
        StringBuffer error = new StringBuffer();
        if(null==wenjianm || wenjianm.equals("")){
            error.append("文件名为空");
        }
        if(null==jiluts || jiluts.equals("")){
            error.append("记录条数为空");
        }
        if(null!=feiyongze || !(feiyongze.equals(""))){
            double sumMoney = 0;
            try{
            sumMoney = Double.parseDouble(feiyongze);
            }catch (NumberFormatException e) {
                error.append("费用金额不符合规定");  
            }
            if(sumMoney<0){
                error.append("费用金额小于0");    
            }
            
        }
        if(null==jiluscrq || jiluscrq.equals("")){
            error.append("记录生成日期为空");
        }
        if(null==wenjiandx || wenjiandx.equals("")){
            error.append("文件大小为空");
        }
        if(null==wenjianxym || wenjianxym.equals("")){
            error.append("文件校验码为空");
        }
        if(null==wenjiansm || wenjiansm.equals("")){
            error.append("文件说明为空");
        }
        if(!(((error.toString()).trim()).equals(""))){
            throw new FeiyongException("041001","第"+(num+1)+"条记录中'"+error+"'");
        }       
    }
    //处理中异常处理 
    private void checkClzMes(DataBus db,int num) throws FeiyongException{
        String data = db.getValue("TC_PMT_DAT");//缴费时间 
        String feiyongid  = db.getValue("TC_ROWID");//费用ID 
        String shenqingh = db.getValue("TC_APP_DOM");//申请号 
        String guowaisqh  = db.getValue("TC_APP_INT");//国外申请号 
        String feiyongzldm  = db.getValue("TC_KM_CODE");//费用种类代码 
        String feiyongzlmc  =  db.getValue("TC_KM_NAME");//费用种类名称 
        String jiaofeije  =  db.getValue("TC_JE_RMB");//缴费金额             
        String feiyongbj  =db.getValue("TC_STAT");//费用标记 
        
        StringBuffer error = new StringBuffer();
        if(null==feiyongid || feiyongid.equals("")){
            error.append("费用ID为空");
        }
        if(null==data || data.equals("")){
            error.append("缴费时间为空");
        }
        if(null==jiaofeije || jiaofeije.equals("")){
            error.append("缴费金额为空");             
        }else{
            double sumMoney = 0;
            try{
            sumMoney = Double.parseDouble(jiaofeije);
            }catch (NumberFormatException e) {
                error.append("费用金额不符合规定");  
            }
            if(sumMoney<0){
                error.append("费用金额小于0");    
            }
        }
        if(null==feiyongzldm || feiyongzldm.equals("")){
            error.append("费用种类代码为空");
        }
        if(null==feiyongzlmc || feiyongzlmc.equals("")){
            error.append("费用种类名称为空");
        }
        if(null==feiyongbj || feiyongbj.equals("")){
            error.append("费用标记为空");
        }
        if(((null==shenqingh || shenqingh.equals("")) && (null==guowaisqh || guowaisqh.equals("")))){
            error.append("申请号和国外申请号不能同时为空");
        }
        if(!(((error.toString()).trim()).equals(""))){
            throw new FeiyongException("041001","第"+(num+1)+"条记录中'"+error+"'");
        }       
    }
    
    //已收费异常处理 
    private void checkYsfMes(DataBus db,int num) throws FeiyongException{
        String jiaofeisj = db.getValue("TC_PMT_DAT");//缴费时间1         
        String feiyongid  = db.getValue("TC_ROWID");//费用ID1 
        String shenqingh = db.getValue("TC_APP_DOM");//申请号 
        String guowaisqh  = db.getValue("TC_APP_INT");//国外申请号        
        String feiyongzldm  = db.getValue("TC_KM_CODE");//费用种类代码1 
        String feiyongzlmc  =  db.getValue("TC_KM_NAME");//费用种类名称1 
        String jiaofeije  =  db.getValue("TC_JE_RMB");//缴费金额    1 
        String shoujuh  =  db.getValue("TC_RCP");//收据号 
        String shoujurq =  db.getValue("TC_RCP_DAT");//收据日期 
        String jiaofeirxm =  db.getValue("TC_PMT");//缴费人姓名 
        String feiyongbj  =db.getValue("TC_STAT");//费用标记1 
        
        
        StringBuffer error = new StringBuffer();
        if(null==feiyongid || feiyongid.equals("")){
            error.append("费用ID为空");
        }
        if(null==jiaofeisj || jiaofeisj.equals("")){
            error.append("缴费时间为空");
        }
        if(null==jiaofeije || jiaofeije.equals("")){
            error.append("缴费金额为空");             
        }else{
            double sumMoney = 0;
            try{
            sumMoney = Double.parseDouble(jiaofeije);
            }catch (NumberFormatException e) {
                error.append("费用金额不符合规定");  
            }
            if(sumMoney<0){
                error.append("费用金额小于0");    
            }
        }
        if(null==feiyongzldm || feiyongzldm.equals("")){
            error.append("费用种类代码为空");
        }
        if(null==feiyongzlmc || feiyongzlmc.equals("")){
            error.append("费用种类名称为空");
        }
        if(null==feiyongbj || feiyongbj.equals("")){
            error.append("费用标记为空");
        }
        if(null==shoujuh || shoujuh.equals("")){
            error.append("收据号为空");
        }
        if(null==shoujurq || shoujurq.equals("")){
            error.append("收据日期为空");
        }
        if(null==jiaofeirxm || jiaofeirxm.equals("")){
            error.append("缴费人姓名为空");
        }
        if(((null==shenqingh || shenqingh.equals("")) && (null==guowaisqh || guowaisqh.equals("")))){
            error.append("申请号和国外申请号不能同时为空");
        }
        if(!(((error.toString()).trim()).equals(""))){
            throw new FeiyongException("041001","第"+(num+1)+"条记录中'"+error+"'");
        }                   
    }
        
    //费用更正异常处理 
    private void checkGzMes(DataBus db,int num) throws FeiyongException{
        String feiyongid  = db.getValue("TC_ROWID");//费用ID1 
        String yshenqingh = db.getValue("TC_APP_DOM1");//原申请号 
        String yguowaisqh  = db.getValue("TC_APP_INT1");//原国外申请号         
        String yjiaofeirq  = db.getValue("TC_PMT_DAT1");//缴费日期（原） 
        String yfeiyongdm  =  db.getValue("TC_KM_CODE1");//费用代码（原） 
        String yfeiyongmc  =  db.getValue("TC_KM_NAME1");//费用代码名称（原）  
        String yshoujuh  =  db.getValue("TC_RCP1");//收据号（原） 
        String yfeiyongje =  db.getValue("TC_JE_RMB1");//费用金额（原）         
        String shenqingh = db.getValue("TC_APP_DOM");//申请号 
        String guowaisqh  = db.getValue("TC_APP_INT");//国外申请号        
        String jiaofeirq  = db.getValue("TC_PMT_DAT");//缴费日期 
        String feiyongdm  =  db.getValue("TC_KM_CODE");//费用代码 
        String feiyongmc  =  db.getValue("TC_KM_NAME");//费用代码名称  
        String shoujuh  =  db.getValue("TC_RCP");//收据号 
        String feiyongje =  db.getValue("TC_JE_RMB");//费用金额      
        String xiugailx =  db.getValue("TC_MOD_TYPE");//修改类型  
        String gengzhengtcrq  =db.getValue("TC_MOD_DATE");//更正提出日期 
        //String gengzhengsm  =db.getValue("TC_MOD_MEMO");//更正说明  
        
        
        StringBuffer error = new StringBuffer();
        if(null==feiyongid || feiyongid.equals("")){
            error.append("费用ID为空");
        }
        if(null==yjiaofeirq || yjiaofeirq.equals("")){
            error.append("原缴费日期为空");
        }
        if(null==yfeiyongdm || yfeiyongdm.equals("")){
            error.append("原费用种类代码为空");
        }
        if(null==yfeiyongmc || yfeiyongmc.equals("")){
            error.append("原费用种类名称为空");
        }
        if(null==yshoujuh || yshoujuh.equals("")){
            error.append("原收据号为空");
        }
        if(null==yfeiyongje || yfeiyongje.equals("")){
            error.append("原费用金额为空");
        }else{
            double sumMoney = 0;
            try{
            sumMoney = Double.parseDouble(yfeiyongje);
            }catch (NumberFormatException e) {
                error.append("费用金额不符合规定");  
            }
            if(sumMoney<0){
                error.append("费用金额小于0");    
            }
        }
        if(null==xiugailx || xiugailx.equals("")){
            error.append("修改类型为空");
        }
        if(null==gengzhengtcrq || gengzhengtcrq.equals("")){
            error.append("更正提出日期为空");
        }
        if(null==gengzhengtcrq || gengzhengtcrq.equals("")){
            error.append("更正提出日期为空");
        }
        if(((null==yshenqingh || yshenqingh.equals("")) && (null==yguowaisqh || yguowaisqh.equals("")))){
            error.append("申请号和国外申请号不能同时为空");
        }
        if(!(((error.toString()).trim()).equals(""))){
            throw new FeiyongException("041001","第"+(num+1)+"条记录中'"+error+"'");
        }                   
        
            //费用更正的更正码是7位（申请号、国外申请号、缴费日期、费用代码、费用代码名称、收据号、费用金额） 
            char sqh  = xiugailx.charAt(0);
            char gwsqh  = xiugailx.charAt(1);
            char jfrq  = xiugailx.charAt(2);
            char fydm  = xiugailx.charAt(3);
            char fydmmc  = xiugailx.charAt(4);
            char sjh  = xiugailx.charAt(5);
            char fyje  = xiugailx.charAt(6);
            
            if(sqh=='1' && (null==shenqingh || shenqingh.equals(""))){
                throw new FeiyongException("041001","第"+(num+1)+"更正码不对应");
            }
            if(gwsqh=='1' && (null==guowaisqh || guowaisqh.equals(""))){
                throw new FeiyongException("041001","第"+(num+1)+"更正码不对应");
            }
            if(jfrq=='1' && (null==jiaofeirq || jiaofeirq.equals(""))){
                throw new FeiyongException("041001","第"+(num+1)+"更正码不对应");
            }
            if(fydm=='1' && (null==feiyongdm || feiyongdm.equals(""))){
                throw new FeiyongException("041001","第"+(num+1)+"更正码不对应");
            }
            if(fydmmc=='1' && (null==feiyongmc || feiyongmc.equals(""))){
                throw new FeiyongException("041001","第"+(num+1)+"更正码不对应");
            }
            if(sjh=='1' && (null==shoujuh || shoujuh.equals(""))){
                throw new FeiyongException("041001","第"+(num+1)+"更正码不对应");
            }
            if(fyje=='1' && (null==feiyongje || feiyongje.equals(""))){
                throw new FeiyongException("041001","第"+(num+1)+"更正码不对应");
            }   
    }
    //费用代码费用标准减缓比例信息录入异常处理 
    private void checkFjblMes(DataBus db,int num) throws FeiyongException{
        String feiyongzldm = db.getValue("TC_KM_CODE");//费用种类代码 
        String feiyongzlmc = db.getValue("TC_KM_NAME");//费用种类名称 
        String jiaofeije = db.getValue("TC_KM_JE_RMB");//缴费金额 
        String feiyongjhbl1 = db.getValue("TC_DERATE1");//费减比例1 
        String feiyongjhbl2 = db.getValue("TC_DERATE2");//费减比例2 
        String feiyongjhbl3 = db.getValue("TC_DERATE3");//费减比例3 
        String zhijiansj = db.getValue("TC_KM_DATE");//执行时间 
                
        StringBuffer error = new StringBuffer();
        if(null==feiyongjhbl1 || feiyongjhbl1.equals("")){
            error.append("费减比例1为空");
        }
        if(null==feiyongjhbl2 || feiyongjhbl2.equals("")){
            error.append("费减比例2为空");
        }
        if(null==jiaofeije || jiaofeije.equals("")){
            error.append("缴费金额为空");             
        }else{
            double sumMoney = 0;
            try{
            sumMoney = Double.parseDouble(jiaofeije);
            }catch (NumberFormatException e) {
                error.append("费用金额不符合规定");  
            }
            if(sumMoney<0){
                error.append("费用金额小于0");    
            }
        }
        if(null==feiyongzldm || feiyongzldm.equals("")){
            error.append("费用种类代码为空");
        }
        if(null==feiyongzlmc || feiyongzlmc.equals("")){
            error.append("费用种类名称为空");
        }
        if(null==feiyongjhbl3 || feiyongjhbl3.equals("")){
            error.append("费减比例3为空");
        }
        if(null==zhijiansj || zhijiansj.equals("")){
            error.append("执行时间为空");
        }
        if(!(((error.toString()).trim()).equals(""))){
            throw new FeiyongException("041001","第"+(num+1)+"条记录中'"+error+"'");
        }                                   
    }
    //退费字段异常处理 
    private void checkTfMes(DataBus db,int num)throws FeiyongException{
        String shenqingh = db.getValue("TC_APP_DOM");//申请号 
        String chulisj = db.getValue("TC_RFD_DATE");//处理时间 
        String tuifeiid = db.getValue("TC_RFD_ID");//退费ID   
        String tuifeizt = db.getValue("TC_RFD_STAT");//退款状态 
        
        StringBuffer error = new StringBuffer();
        if(null==shenqingh || shenqingh.equals("")){
            error.append("申请号为空");
        }
        if(null==chulisj || chulisj.equals("")){
            error.append("处理时间为空");
        }
        if(null==tuifeiid || tuifeiid.equals("")){
            error.append("退费ID为空");
        }
        if(null==tuifeizt || tuifeizt.equals("")){
            error.append("退款状态为空");
        }
        if(!(((error.toString()).trim()).equals(""))){
            throw new FeiyongException("041001","第"+(num+1)+"条记录中'"+error+"'");
        }                           
    }
   //根据文件名前三位得到dtd文件路径和子节点名 
    private DataBus getDtdFile(String wenjianm) throws TxnException{
        DataBus databus = new DataBus();
        databus.put("xml", "E:/"+wenjianm);
        String headName = wenjianm.substring(0, 3);
        if(headName.equals("unp")){
            databus.put("dtd", "/cn/gwssi/cpees/d_sf/xml/dtd/unpos.dtd");
            databus.put("part", "feerecord");
        }
        if(headName.equals("pos")){
            databus.put("dtd", "/cn/gwssi/cpees/d_sf/xml/dtd/pos.dtd");
            databus.put("part", "feerecord");
            databus.put("check", "1");//作为判断已记账费用总额是否相等标记 
        }
        if(headName.equals("kmx")){
            databus.put("dtd", "/cn/gwssi/cpees/d_sf/xml/dtd/kmx.dtd");
            databus.put("part", "kmrecord");
        }
        if(headName.equals("rdf")){
            databus.put("dtd", "/cn/gwssi/cpees/d_sf/xml/dtd/rfd.dtd");
            databus.put("part", "tkrecord");
        }
        if(headName.equals("mod")){
            databus.put("dtd", "/cn/gwssi/cpees/d_sf/xml/dtd/mod.dtd");
            databus.put("part", "feerecord");
        }
        return databus;
    }
    //检查已记账费总是否相符 
    private boolean checkSumFeeForPos(String fz,Recordset patent){
        int patentSize = patent.size();
        double sumFee = 0;
        for(int i=0;i<patentSize;i++){
            String feiyongje = patent.get(i).getValue("TC_JE_RMB");
            if(null==feiyongje || feiyongje.equals("")){
                feiyongje = "0";
            }
            sumFee+=Double.parseDouble(feiyongje);
        }
        if(Double.parseDouble(fz)==sumFee){
        return true;
        }else{
        return false;
        }
    }
    //根据文件名前三位得到操作该文件的方法 
    private StringBuffer doAction(String wenjianm,Recordset patent) throws TxnException{
        StringBuffer buffer = new StringBuffer();//记录异常信息 
        String headName = wenjianm.substring(0, 3);
        if(headName.equals("unp")){
            buffer.append(actionForClzMes(patent));
        }
        if(headName.equals("pos")){
            buffer.append(actionForPayMes(patent));
            buffer.append(updateFyzt());
        }
        if(headName.equals("kmx")){
            buffer.append(actionForFjblMes(patent));
        }
        if(headName.equals("rdf")){
            buffer.append(actionForTfMes(patent));
        }
        if(headName.equals("mod")){
            buffer.append(actionForGzMes(patent));
            buffer.append(actionAfterGzMes());
        }
        return buffer;
    }
    
    public void prepare(TxnContext context) throws TxnException {
        super.prepare(context);
    }
    public void cleanup(TxnContext context) throws TxnException {
        super.cleanup(context);
    }
    
}