aj_dj_tj_submit.jad

公务员管理系统

        {
            result_ms = "loadframe(\"\u68C0\u67E5\u60C5\u51B5\u8F93\u5165\u6709\u8BEF(\u8981\u6C42\uFF1A\u4E0D\u80FD\u8D85\u8FC72000\u4E2A\u6C49\u5B57\u3002)\uFF01\");";
            return;
        }
        break MISSING_BLOCK_LABEL_1980;
        if(!submit_type.equalsIgnoreCase("aj_jbxx_tj"))
            break MISSING_BLOCK_LABEL_1980;
        AJ_ID = std1.getValue(request, "AJ_ID");
        WDID = std1.getValue(request, "WDID");
        INDEXID = std1.getValue(request, "INDEXID");
        JBR = std1.getValue(request, "JBR");
        JBR_XB = std1.getValue(request, "JBR_XB");
        JBR_HJLB = std1.getValue(request, "JBR_HJLB");
        JBRTJ = std1.getValue(request, "JBRTJ");
        JBR_YB = std1.getValue(request, "JBR_YB");
        JBR_DH = std1.getValue(request, "JBR_DH");
        JBR_LX = std1.getValue(request, "JBR_LX");
        JDSJ = std1.getValue(request, "JDSJ");
        JBR_DZ = std1.getValue(request, "JBR_DZ");
        JBNR = std1.getValue(request, "JBNR");
        BZ = std1.getValue(request, "BZ");
        TIME_MOD = "sysdate";
        CREATOR = std1.getValue(request, "CREATOR");
        if(!std1.checkLength(JBR, 20))
        {
            result_ms = "loadframe(\"\u4E3E\u62A5\u4EBA\u59D3\u540D\u8F93\u5165\u6709\u8BEF(\u8981\u6C42\uFF1A\u4E0D\u80FD\u4E3A\u7A7A\u6216\u8D85\u8FC710\u4E2A\u6C49\u5B57\u3002)\uFF01\");";
            return;
        }
        if(JBR_XB.equals(""))
        {
            result_ms = "loadframe(\"\u8BF7\u9009\u62E9\u4E3E\u62A5\u4EBA\u6027\u522B!\");";
            return;
        }
        if(JBR_HJLB.equals(""))
        {
            result_ms = "loadframe(\"\u8BF7\u9009\u62E9\u4E3E\u62A5\u6237\u7C4D\u7C7B\u522B!\");";
            return;
        }
        if(JBRTJ.equals(""))
        {
            result_ms = "loadframe(\"\u8BF7\u9009\u62E9\u4E3E\u62A5\u9014\u5F84!\");";
            return;
        }
        if(JBR_YB.length() != 6 || !std1.checkNumber(JBR_YB))
        {
            result_ms = "loadframe(\"\u4E3E\u62A5\u4EBA\u90AE\u653F\u7F16\u7801\u8F93\u5165\u6709\u8BEF(\u8981\u6C42\uFF1A\u53EA\u80FD\u662F\u7A7A6\u4E2A\u6570\u5B57\u3002)\");";
            return;
        }
        if(!std1.checkMaxLength(JBR_DH, 20))
        {
            result_ms = "loadframe(\"\u4E3E\u62A5\u4EBA\u8054\u7CFB\u7535\u8BDD\u8F93\u5165\u6709\u8BEF(\u8981\u6C42\uFF1A\u4E0D\u80FD\u8D85\u8FC720\u4E2A\u5B57\u7B26\u3002)\");";
            return;
        }
        if(JBR_LX.equals(""))
        {
            result_ms = "loadframe(\"\u8BF7\u9009\u62E9\u4E3E\u62A5\u4EBA\u7C7B\u578B!\");";
            return;
        }
        if(!std1.checkLength(JBR_DZ, 60))
        {
            result_ms = "loadframe(\"\u4E3E\u62A5\u4EBA\u901A\u8BAF\u5730\u5740\u8F93\u5165\u6709\u8BEF(\u8981\u6C42\uFF1A\u4E0D\u80FD\u4E3A\u7A7A\u6216\u8D85\u8FC730\u4E2A\u6C49\u5B57\u3002)\");";
            return;
        }
        if(!std1.checkMaxLength(JBNR, 2000))
        {
            result_ms = "loadframe(\"\u4E3E\u62A5\u5185\u5BB9\u8F93\u5165\u6709\u8BEF(\u8981\u6C42\uFF1A\u4E0D\u80FD\u8D85\u8FC72000\u4E2A\u6C49\u5B57\u3002)\");";
            return;
        }
        if(!std1.checkMaxLength(BZ, 2000))
        {
            result_ms = "loadframe(\"\u5907\u6CE8\u8F93\u5165\u6709\u8BEF(\u8981\u6C42\uFF1A\u4E0D\u80FD\u8D85\u8FC72000\u4E2A\u6C49\u5B57\u3002)\");";
            return;
        }
        if(submit_type.equalsIgnoreCase("aj_dj_tj"))
        {
            System.out.println("\u6DFB\u52A0");
            String sql1 = "insert into AJ_DJB (AJ_ID) values ('" + AJ_ID + "')";
            String sql2 = "update AJ_DJB set DWMC ='" + DWMC + "', JCID = '" + JCID + "', DWID = '" + DWID + "', DWLB = '" + DWLB + "', AJ_ID = '" + AJ_ID + "', AJ_BH = '" + AJ_BH + "', JYDZ ='" + JYDZ + "', ZCDZ = '" + ZCDZ + "', AJ_LB = '" + AJ_LB + "', JC_JCTJ = '" + JCTJ + "', AJ_DJSJ =to_date('" + AJ_DJSJ + "','yyyy-mm-dd'), AJ_LASJ ='" + AJ_LASJ + "', FCBR ='" + FCBR + "', FCBR_NAME ='" + FCBR_NAME + "', CBR ='" + CBR + "', CBR_NAME ='" + CBR_NAME + "', DEL_FLAG =null, AJ_FLAG = '" + AJ_FLAG + "', AJ_JCQK ='" + AJ_JCQK + "', TIME_MOD =" + TIME_MOD + ", TIME_CRE =" + TIME_CRE + ", ZCBR_DW ='" + ZCBR_DW + "', FCBR_DW ='" + FCBR_DW + "', ZCBR_ZW ='" + ZCBR_ZW + "', DWXZ ='" + DWXZ + "', DWFR ='" + DWFR + "', DWYB ='" + DWYB + "', DWDH ='" + DWDH + "', FRZW ='" + FRZW + "', FCBR_ZW='" + FCBR_ZW + "', FKJE=null, FKRS=null, ZXJC='" + ZXJC + "', QX='" + QX + "', BLFS='" + BLFS + "', QXMC='" + QXMC + "' where AJ_ID ='" + AJ_ID + "'";
            System.err.println(sql1);
            System.err.println(sql2);
            submit sub = new submit();
            sub.setInsertSql(sql1);
            sub.setUpdateSql(sql2);
            sub.Submit();
            submit sub2 = new submit();
            INDEXID = ML_Operation.getIndexid(AJ_ID);
            String sql3 = ML_Operation.ML_insertSQL(AJ_ID, INDEXID, LCID, WDID, "", "");
            System.err.println(sql3);
            sub2.setInsertSql(sql3);
            sub2.Submit();
            if(JCTJ.equals("01"))
            {
                WDID = "002";
                INDEXID = ML_Operation.getIndexid(AJ_ID);
                sql2 = "insert into AJ_JBXX (INDEXID) values('" + INDEXID + "')";
                sql3 = "update AJ_JBXX set BZ ='" + BZ + "', JBNR='" + JBNR + "', JDSJ=to_date('" + JDSJ + "','yyyy-mm-dd'), JBR_LX='" + JBR_LX + "', JBRTJ='" + JBRTJ + "', JBR_DH='" + JBR_DH + "', JBR_YB='" + JBR_YB + "', JBR_DZ='" + JBR_DZ + "', JBR_HJLB='" + JBR_HJLB + "', JBR_XB='" + JBR_XB + "', JBR='" + JBR + "', TIME_MOD=" + TIME_MOD + ", TIME_CRE=" + TIME_CRE + ", AJ_ID='" + AJ_ID + "', CREATOR='" + CBR + "' where  INDEXID='" + INDEXID + "'";
                sql1 = ML_Operation.ML_insertSQL(AJ_ID, INDEXID, LCID, WDID, "", "");
                System.err.println(sql1);
                System.err.println(sql2);
                System.err.println(sql3);
                submit sub3 = new submit();
                sub3.setInsertSql(sql1);
                sub3.setInsertSql1(sql2);
                sub3.setUpdateSql(sql3);
                sub3.Submit();
            }
        } else
        if(submit_type.equalsIgnoreCase("aj_dj_xg"))
        {
            String sql = "update AJ_DJB set FCBR ='" + FCBR + "', FCBR_NAME = '" + FCBR_NAME + "', BLFS='" + BLFS + "', AJ_LB = '" + AJ_LB + "', TIME_MOD =" + TIME_MOD + ", AJ_DJSJ =to_date('" + AJ_DJSJ + "','yyyy-mm-dd')" + ", AJ_JCQK ='" + AJ_JCQK + "', FCBR_DW = '" + FCBR_DW + "', FCBR_ZW = '" + FCBR_ZW + "' where AJ_ID ='" + AJ_ID + "'";
            System.err.println(sql);
            submit sub = new submit();
            sub.setUpdateSql(sql);
            sub.Submit();
        } else
        if(submit_type.equalsIgnoreCase("aj_jbxx_tj"))
        {
            System.out.println("\u4FEE\u6539");
            String sql = "update AJ_JBXX set JBR ='" + JBR + "', JBR_XB = '" + JBR_XB + "', JBR_HJLB = '" + JBR_HJLB + "', JBRTJ = '" + JBRTJ + "', JBR_YB ='" + JBR_YB + "', JDSJ =to_date('" + JDSJ + "','yyyy-mm-dd')" + ", JBR_DH ='" + JBR_DH + "', JBR_LX = '" + JBR_LX + "', JBR_DZ = '" + JBR_DZ + "', JBNR = '" + JBNR + "', BZ = '" + BZ + "', TIME_MOD =" + TIME_MOD + ", CREATOR = '" + CREATOR + "' where AJ_ID ='" + AJ_ID + "'";
            System.err.println(sql);
            submit sub = new submit();
            sub.setUpdateSql(sql);
            sub.Submit();
        }
        result_ms = "succeed('" + AJ_ID + "');";
        break MISSING_BLOCK_LABEL_3395;
        Exception e;
        e;
        System.err.println(e.getMessage());
        result_ms = "loadframe(\"\u6570\u636E\u5E93\u64CD\u4F5C\u5931\u8D25\");";
        return;
    }

    public String getResultMassage()
    {
        return result_ms;
    }

    String AJ_BH;
    String AJ_DJSJ;
    String AJ_FLAG;
    String AJ_ID;
    String AJ_JCQK;
    String AJ_LASJ;
    String AJ_LB;
    String BLFS;
    String BZ;
    String CBR;
    String CBR_NAME;
    String CREATOR;
    String DWDH;
    String DWFR;
    String DWID;
    String DWLB;
    String DWMC;
    String DWXZ;
    String DWYB;
    String FCBR;
    String FCBR_DW;
    String FCBR_NAME;
    String FCBR_ZW;
    String FRZW;
    String INDEXID;
    String JBNR;
    String JBR;
    String JBRTJ;
    String JBR_DH;
    String JBR_DZ;
    String JBR_HJLB;
    String JBR_LX;
    String JBR_XB;
    String JBR_YB;
    String JCID;
    String JCTJ;
    String JDSJ;
    String JYDZ;
    String LCID;
    String QX;
    String QXMC;
    String TIME_CRE;
    String TIME_MOD;
    String WDID;
    String ZCBR_DW;
    String ZCBR_ZW;
    String ZCDZ;
    String ZXJC;
    String result_ms;
    String submit_type;
}