getcodingtable.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 集团成员类型
     * @return
     */
    public static ArrayList getCodingJtcylx(){
        String sql = "select * from dict_jtcylx order by bm";
        return getCoding(sql);
    }

    /**
     * 获取集团成员编码表的值
     * @ ArrayList
     */
    public static String getCodingJtcylx(String bm){
        String sql = "select * from dict_jtcylx where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){

            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();

        }
        return resultStr;
    }

    /**
     * 获取银行帐号类型编码表的值
     * @ ArrayList 类型编码表
     */
    public static ArrayList getCodingZhlx(){
        String sql = "select * from dict_account order by bm";
        return getCoding(sql);
    }

    /**
     * 获取银行帐号类型编码表的值
     * @ ArrayList
     */
    public static String getCodingZhlx(String bm){
        String sql = "select * from dict_account where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 获取税务类型编码表的值
     * @ ArrayList 类型编码表
     */
    public static ArrayList getCodingSwlx(){
        String sql = "select * from dict_tax order by bm";
        return getCoding(sql);
    }

    /**
     * 获取税务类型编码表的值
     * @ ArrayList
     */
    public static String getCodingSwlx(String bm){
        String sql = "select * from dict_tax where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 获取登记机关编码表的值
     * @ ArrayList 类型编码表
     */
    public static ArrayList getCodingDjjg(){
        String sql = "select content,coding from a_bm_djjg where content like '37%' order by content";
        String sql2 = "select content,coding from a_bm_djjg where not content like '37%' order by content";
        ArrayList al = getCoding(sql);
        al.addAll(getCoding(sql2));
        return al;
    }

    /**
     * 获取登记机关编码表的值
     * @ ArrayList 类型编码表
     */
    public static ArrayList getCodingDjjg(String coding){
        String sql = "select content,coding,dqjc from a_bm_djjg where content='" + coding + "' order by content";
        return getCoding(sql);
    }

    /**
     * 获取登记机关编码表(山东省内)
     * @ ArrayList 类型编码表
     */
    public static ArrayList getSDDjjg(String djjg){
        String sql = null;
        if(djjg == null || djjg.length() == 0){ //空，取全部
            sql = "select * from " + TableNameUtil.GSSHARE_CODING_REGISTERORG + " where length(coding)<11 order by coding";
        } else{
            if(djjg.length() > 9){ //管片
                djjg = djjg.substring(0,9);
            }
            if(djjg.length() == 9){ //工商所
            } else{ //登记机关
                while(djjg.substring(djjg.length() - 2).equals("00")){
                    djjg = djjg.substring(0,djjg.length() - 2);
                }
            }
            sql = "select * from " + TableNameUtil.GSSHARE_CODING_REGISTERORG + " where coding like '" + djjg + "%' and length(coding)<11 order by coding";
        }
        return getCoding(sql);
    }

    /**
     * 获取管片代码编码表(山东省内)
     * @ ArrayList 类型编码表
     */
    public static ArrayList getSDGpdm(String djjg){
        String sql = null;
        if(djjg == null || djjg.length() == 0){ //空，取全部
            sql = "select * from " + TableNameUtil.GSSHARE_CODING_REGISTERORG + " where length(coding)>9 order by coding";
        } else{
            if(djjg.length() > 9){ //管片
                djjg = djjg.substring(0,9);
            }
            if(djjg.length() == 9){ //工商所

            } else{ //登记机关
                while(djjg.substring(djjg.length() - 2).equals("00")){
                    djjg = djjg.substring(0,djjg.length() - 2);
                }
            }
            sql = "select * from " + TableNameUtil.GSSHARE_CODING_REGISTERORG + " where coding like '" + djjg + "%' and length(coding)>9 order by coding";
        }
        return getCoding(sql);
    }

    /**
     * 是否lxh2003-12-4
     * @ ArrayList 是否
     */
    public static ArrayList getCodingYesno(){
        String sql = "select * from dict_yesno order by bm";
        return getCoding(sql);
    }

    /**
     * 是否
     * @ ArrayList 是否Msg
     */
    public static String getCodingYesno(String bm){
        String sql = "select * from dict_yesno where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 获取登记机关编码表的值
     * @ ArrayList 类型编码表
     * @author glt 2004-05-31 15:06
     */
    public static ArrayList getCodingDJJG(){
        return getCodingDjjg();
    }

    /**
     * 获取登记机关编码表的值lxh2003-11-16
     * @ ArrayList
     */
    public static String getCodingDJJG(String bm){
        String sql = "select coding,content from a_bm_djjg where content='" + bm + "' order by content";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getCode();
        }
        return resultStr;
    }

    /**
     * hjm 2004-4-2
     * 获取变更原因表的值
     * @ ArrayList 类型编码表
     */
    public static ArrayList getCodingBGYY(){
        String sql = "select * from a_bm_bgyy order by bm";
        return getCoding(sql);
    }

    /**
     * 获取许可证类型编码表的值
     * @ ArrayList 类型编码表
     */
    public static ArrayList getCodingXkzlx(){
        String sql = "select * from dict_license order by bm";
        return getCoding(sql);
    }

    /**
     * 获取许可证类型编码表的值
     * @ ArrayList
     */
    public static String getCodingXkzlx(String bm){
        String sql = "select * from dict_license where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 获取隶属分类类型编码表的值
     * @ ArrayList 类型编码表
     */
    public static ArrayList getCodingLsfl(){
        String sql = "select * from a_bm_lsfl order by bm";
        return getCoding(sql);
    }

    /**
     * 获取隶属分类类型编码表的值
     * @ ArrayList
     */
    public static String getCodingLsfl(String bm){
        String sql = "select * from a_bm_lsfl where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 获取核算形式编码表的值
     * @ ArrayList 类型编码表
     */
    public static ArrayList getCodingHsxs(){
        String sql = "select * from a_bm_hsxs order by bm";
        return getCoding(sql);
    }

    /**
     * 获取核算形式编码表的值
     * @ ArrayList
     */
    public static String getCodingHsxs(String bm){
        String sql = "select * from a_bm_hsxs where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

    /**
     * 获取经营方式编码表的值
     * @ ArrayList 类型编码表
     */
    public static ArrayList getCodingJyfs(){
        String sql = "select * from a_bm_jyfs order by bm";
        return getCoding(sql);
    }

    /**
     * 获取经营方式编码表的值
     * @ ArrayList
     */
    public static String getCodingJyfs(String bm){
        String sql = "select * from a_bm_jyfs where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

//年检受理情况说明lxh2003-11-22
    /**
     * 获取受理情况编码值
     * @ ArrayList 受理情况编码表
     */
    public static ArrayList getAcceptCircs(){
        String sql = "select * from a_bm_njsl order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 受理情况编码表
     */
    public static String getAcceptCircs(String bm){
        String sql = "select * from a_bm_njsl where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

//年检年检结果说明lxh2003-11-22
    /**
     * 获取年检结果编码值
     * @ ArrayList 年检结果编码表
     */
    public static ArrayList getAcceptResult(){
        String sql = "select * from a_bm_njjg order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 年检结果编码表
     */
    public static String getAcceptResult(String bm){
        String sql = "select * from a_bm_njjg where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

//股票种类结果说明lxh2003-11-22
    /**
     * 获取股票种类编码值
     * @ ArrayList 股票种类编码表
     */
    public static ArrayList getCodingGpzl(){
        String sql = "select * from a_bm_gpzl order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList  股票种类编码表
     */
    public static String getCodingGpzl(String bm){
        String sql = "select * from a_bm_gpzl where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);
            resultStr = eCode.getContent();
        }
        return resultStr;
    }

//年检办理单位说明lxh2003-11-22
    /**
     * 获取办理单位编码值
     * @ ArrayList 办理单位编码表 /主体分类
     */
    public static ArrayList getTransactUnit(){
        String sql = "select * from a_bm_ztfl order by bm";
        return getCoding(sql);
    }

    /**
     *
     * @ ArrayList 办理单位编码表
     */
    public static String getTransactUnit(String bm){
        String sql = "select * from a_bm_jbdw where bm='" + bm + "' order by bm";
        String resultStr = null;
        EnterpriseCoding eCode = null;
        ArrayList al = getCoding(sql);
        if(0 < al.size()){
            eCode = (EnterpriseCoding) al.get(0);