dmgldictblh.java

以前做的一个j2ee的项目

     * 功能:取回某个分类所有的代码表列表
     * 参数:dmb_fl 代码表分类
     */
    public ResponseEvent IgetZdbList(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try{
        ArrayList ret=this.getZdbList(null);
        res.setZdbList(ret);
      }catch(Exception ex){
        ex.printStackTrace();
        throw new TaxBaseSystemException("YCDMGL01001");
      }
      return res;
    }


    /**
     * 功能:取回可用的代码表列表
     * 参数:dmb_fl 代码表分类
     */
    public ResponseEvent IgetValidZdbList(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try{
          ArrayList ret = this.getValidZdbList();
          res.setValidZdbList(ret);
      }catch(Exception ex){
        ex.printStackTrace();
        throw new TaxBaseSystemException("YCDMGL01002");
      }
      return res;
    }

    /**
     * 功能:向字典表添加,代码表有而字典表中没有的字段
     * @param ATableName String
     * @return boolean
     */
    public ResponseEvent IaddZdb(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
       DMGLDictResEvent res = new DMGLDictResEvent();
       try{
           int ret = this.addZdb(reqEvent.getTable_name());
           res.setOprResult(ret);
       }catch(Exception ex){
         ex.printStackTrace();
         throw new TaxBaseSystemException("YCDMGL01003");
      }
       return res;
    }

    /**
     * 功能:取代码表的字段列表
     * 参数:table_name 表名
     */
    public ResponseEvent IgetFieldsByTable(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try {
        List ret = this.getFieldsByTable(reqEvent.getTable_name());
        res.setZdList(ret);
      }catch(Exception ex){
        ex.printStackTrace();
        throw new TaxBaseSystemException("YCDMGL01004");
      }
      return res;
    }

    /**
     * 功能:取代码表某个字段对象
     * 参数:table_name 表名
     * 参数:column_name 字段名
     */
    public ResponseEvent IgetFieldObject(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try {
        DMGLDictFieldVO ret = this.getFieldObject(reqEvent.getTable_name(),
        reqEvent.getField_name());
        res.setZdObject(ret);
      }catch(Exception ex){
        ex.printStackTrace();
        throw new TaxBaseSystemException("YCDMGL01005");
      }
      return res;
    }

    /**
     * 功能:取代码表某个字段的取值列表
     */
    public ResponseEvent IgetQZBList(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try {
        int zdbXh = Integer.parseInt(reqEvent.getZdbXh());
        List ret = this.getQZBList(zdbXh);
        res.setQzbList(ret);
      } catch (Exception ex) {
        ex.printStackTrace();
        throw new TaxBaseSystemException("YCDMGL01006");
      }
      return res;
    }

    /**
     * 功能:修改字典表
     */
    public ResponseEvent IupdateZDB(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try {
          int ret = this.updateZDB(reqEvent.getZdVO());
          res.setOprResult(ret);
      } catch (Exception ex) {
          ex.printStackTrace();
          throw new TaxBaseSystemException("YCDMGL01007");
      }
      return res;
    }

    /**
     * 功能:删除字典表中某个代码表
     */
    public ResponseEvent IdelZDB(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try {
          int ret = this.delZDB(reqEvent.getZdVO());
          res.setOprResult(ret);
      } catch (Exception ex) {
          ex.printStackTrace();
          throw new TaxBaseSystemException("YCDMGL01008");
      }
      return res;
    }

    /**
     * 功能:导入目标表数据至取值表中
     */
    public ResponseEvent IimportQZB(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try {
          int ret = this.importQZB(reqEvent.getZdVO());
          res.setOprResult(ret);
      } catch (Exception ex) {
          ex.printStackTrace();
          throw new TaxBaseSystemException("YCDMGL01009");
      }
      return res;
    }

    /**
     * 功能:向取值表添加取值数据
     */
    public ResponseEvent IaddQZB(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try {
          int ret = this.addQZB(reqEvent.getZdqzVO());
          res.setOprResult(ret);
      } catch (Exception ex) {
          ex.printStackTrace();
          throw new TaxBaseSystemException("YCDMGL01010");
      }
      return res;
    }

    /**
     * 功能:删除取值表记录
     */
    public ResponseEvent IdelQZB(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try {
          int ret = this.delQZB(reqEvent.getZdqzVO());
          res.setOprResult(ret);
      } catch (Exception ex) {
          ex.printStackTrace();
          throw new TaxBaseSystemException("YCDMGL01011");
      }
      return res;
    }

    /**
     * 功能:修改取值表记录
     */
    public ResponseEvent IupdQZB(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try {
          int ret = this.updQZB(reqEvent.getZdqzVO());
          res.setOprResult(ret);
      } catch (Exception ex) {
          ex.printStackTrace();
          throw new TaxBaseSystemException("YCDMGL01012");
      }
      return res;
    }

    /**
     * 功能:返回一个table的数据列表
     */
    public ResponseEvent IgetTableData(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try {
          ArrayList ret = this.getTableData(reqEvent.getFdList());
          res.setTableData(ret);
      } catch (Exception ex) {
          ex.printStackTrace();
          throw new TaxBaseSystemException("YCDMGL01013");
      }
      return res;
    }

    /**
     * 功能:向table插入一条数据
     * 参数:fdList 字段列表
     * 参数:vlList 数据列表
     */
    public ResponseEvent IaddTableData(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      try {
          List s1 = reqEvent.getFdList();
          String[] s2 = reqEvent.getVlList();
          int ret = this.addTableData(s1, s2);
          res.setOprResult(ret);
      } catch (Exception ex) {
          ex.printStackTrace();
          throw new TaxBaseSystemException("YCDMGL01014");
      }
      return res;
    }

    /**
     * 功能:修改table的一条数据
     * 参数:fdList 字段列表
     * 参数:vlList 数据列表
     * 参数:ftList 数据类型
     */
    public ResponseEvent IupdTableData(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      String s1=reqEvent.getKeyField();
      String s2=reqEvent.getKeyValue();
      List s3=reqEvent.getFdList();
      String[] s4=reqEvent.getVlList();
      try{
          int ret = this.updTableData(s1, s2, s3, s4);
          res.setOprResult(ret);
      } catch (Exception ex) {
          ex.printStackTrace();
          throw new TaxBaseSystemException("YCDMGL01015");
      }
      return res;
    }

    /**
     * 功能:删除table的一条数据
     * 参数:table_name表名
     * 参数:keyField关键字段
     * 参数:keyValue条件值
     */
    public ResponseEvent IdelTableData(DMGLDictReqEvent reqEvent) throws TaxBaseSystemException,Exception{
      DMGLDictResEvent res = new DMGLDictResEvent();
      String s1=reqEvent.getTable_name();
      String s2=reqEvent.getKeyField();
      String s3=reqEvent.getKeyValue();
      try{
          int ret = this.delTableData(s1, s2, s3);
          res.setOprResult(ret);
      } catch (Exception ex) {
          ex.printStackTrace();
          throw new TaxBaseSystemException("YCDMGL01016");
      }
      return res;
    }

    private void jbInit() throws Exception {
    }

}