aj_sdhz_tj_submit.jad

公务员管理系统,本系统的使用可以将工作的部分流程使用计算机的办公自动化处理

// Decompiled by DJ v2.9.9.60 Copyright 2000 Atanas Neshkov  Date: 2004-5-31 14:44:55
// Home Page : http://members.fortunecity.com/neshkov/dj.html  - Check often for new version!
// Decompiler options: packimports(3) 
// Source File Name:   Aj_Sdhz_Tj_Submit.java

package jc.aj;

import com.vstsoft.std.submit;
import com.vstsoft.std.vststd;
import java.io.PrintStream;
import javax.servlet.http.HttpServletRequest;

// Referenced classes of package jc.aj:
//            ML_Operation

public class Aj_Sdhz_Tj_Submit
{

    public Aj_Sdhz_Tj_Submit(HttpServletRequest request)
    {
        result_ms = "";
        try
        {
            vststd std1 = new vststd();
            String SSDR = std1.getValue(request, "SSDR");
            String SSDR_DZ = std1.getValue(request, "SSDR_DZ");
            String SDDZ = std1.getValue(request, "SDDZ");
            String SDRQ = std1.getValue(request, "SDRQ");
            String SDRQ_S = std1.getValue(request, "SDRQ_S");
            String SDRQ_F = std1.getValue(request, "SDRQ_F");
            String SJR_XM = std1.getValue(request, "SJR_XM");
            String SJRQ = std1.getValue(request, "SJRQ");
            String SJRQ_S = std1.getValue(request, "SJRQ_S");
            String SJRQ_F = std1.getValue(request, "SJRQ_S");
            String AJ_ID = std1.getValue(request, "AJ_ID");
            String LCID = std1.getValue(request, "LCID");
            String WDID = std1.getValue(request, "WDID");
            String INDEXID = std1.getValue(request, "INDEXID");
            String CREATOR = std1.getValue(request, "CBR_NAME");
            String JYDZ = std1.getValue(request, "JYDZ");
            String TIME_MOD = "sysdate";
            String TIME_CRE = "sysdate";
            String SDWS_BH = std1.getValue(request, "SDWS_BH");
            String SDWS_MC = std1.getValue(request, "SDWS_MC");
            String submit_type = std1.getValue(request, "submit_type");
            String BZ = std1.getValue(request, "BZ");
            SDRQ = String.valueOf(String.valueOf((new StringBuffer(String.valueOf(String.valueOf(SDRQ)))).append(" ").append(SDRQ_S).append(":").append(SDRQ_F)));
            SJRQ = String.valueOf(String.valueOf((new StringBuffer(String.valueOf(String.valueOf(SJRQ)))).append(" ").append(SJRQ_S).append(":").append(SJRQ_F)));
            if(SDWS_MC.equals(""))
            {
                result_ms = "loadframe(\"\u8BF7\u9009\u62E9\u9001\u8FBE\u6587\u4E66\u540D\u79F0\");";
                return;
            }
            if(!std1.checkMaxLength(SSDR_DZ, 50))
            {
                result_ms = "loadframe(\"\u53D7\u9001\u8FBE\u4EBA\u5730\u5740\u8F93\u5165\u6709\u8BEF\uFF08\u8981\u6C42\uFF1A\u4E0D\u80FD\u8D85\u8FC750\u4E2A\u6C49\u5B57\uFF09\uFF01\");";
                return;
            }
            if(!std1.checkLength(SDDZ, 50))
            {
                result_ms = "loadframe(\"\u9001\u8FBE\u5730\u5740\u8F93\u5165\u6709\u8BEF\uFF08\u8981\u6C42\uFF1A\u4E0D\u80FD\u4E3A\u7A7A\u6216\u8D85\u8FC750\u4E2A\u6C49\u5B57\uFF09\uFF01\");";
                return;
            }
            if(!std1.checkMaxLength(SJR_XM, 50))
            {
                result_ms = "loadframe(\"\u6536\u4EF6\u4EBA\u59D3\u540D\u8F93\u5165\u6709\u8BEF\uFF08\u8981\u6C42\uFF1A\u4E0D\u80FD\u8D85\u8FC750\u4E2A\u6C49\u5B57\uFF09\uFF01\");";
                return;
            }
            if(!std1.checkMaxLength(BZ, 2000))
            {
                result_ms = "loadframe(\"\u5907\u6CE8\u8F93\u5165\u6709\u8BEF\uFF08\u8981\u6C42\uFF1A\u4E0D\u80FD\u8D85\u8FC72000\u4E2A\u6C49\u5B57\uFF09\uFF01\");";
                return;
            }
            if(submit_type.equalsIgnoreCase("aj_sdhz_tj"))
            {
                String sql1 = ML_Operation.ML_insertSQL(AJ_ID, INDEXID, LCID, WDID, "", "");
                String sql2 = String.valueOf(String.valueOf((new StringBuffer("insert into aj_sdhz (INDEXID) values ('")).append(INDEXID).append("')")));
                String sql3 = String.valueOf(String.valueOf((new StringBuffer("update aj_sdhz set AJ_ID='")).append(AJ_ID).append("', TIME_MOD=").append(TIME_MOD).append(", TIME_CRE=").append(TIME_CRE).append(", CREATOR='").append(CREATOR).append("', SJRQ=to_date('").append(SJRQ).append("','yyyy-mm-dd hh24:mi'), SJR_XM='").append(SJR_XM).append("', SDRQ=to_date('").append(SDRQ).append("','yyyy-mm-dd hh24:mi'), SDDZ='").append(SDDZ).append("', SSDR_DZ='").append(SSDR_DZ).append("', SSDR='").append(SSDR).append("', SDWS_BH='").append(SDWS_BH).append("', SDWS_MC='").append(SDWS_MC).append("',BZ='").append(BZ).append("' where INDEXID='").append(INDEXID).append("'")));
                System.err.println(sql1);
                System.err.println(sql2);
                System.err.println(sql3);
                submit sub = new submit();
                sub.setInsertSql(sql1);
                sub.setInsertSql1(sql2);
                sub.setUpdateSql(sql3);
                sub.Submit();
            } else
            if(submit_type.equalsIgnoreCase("aj_sdhz_xg"))
            {
                String sql = String.valueOf(String.valueOf((new StringBuffer("update aj_sdhz set TIME_MOD=")).append(TIME_MOD).append(", CREATOR='").append(CREATOR).append("', SJRQ=to_date('").append(SJRQ).append("','yyyy-mm-dd hh24:mi'), SJR_XM='").append(SJR_XM).append("', SDRQ=to_date('").append(SDRQ).append("','yyyy-mm-dd hh24:mi'), SDDZ='").append(SDDZ).append("', SSDR_DZ='").append(SSDR_DZ).append("', SSDR='").append(SSDR).append("', SDWS_BH='").append(SDWS_BH).append("', SDWS_MC='").append(SDWS_MC).append("',BZ='").append(BZ).append("' where INDEXID='").append(INDEXID).append("'")));
                System.err.println(sql);
                submit sub = new submit();
                sub.setUpdateSql(sql);
                sub.Submit();
            }
            result_ms = String.valueOf(String.valueOf((new StringBuffer("succeed('")).append(AJ_ID).append("');")));
        }
        catch(Exception e)
        {
            result_ms = "loadframe(\"\u6570\u636E\u5E93\u64CD\u4F5C\u5931\u8D25\");";
        }
    }

    public String getResultMassage()
    {
        return result_ms;
    }

    String result_ms;
}