コード例 #1
0
ファイル: Home.aspx.cs プロジェクト: VikySihabudin/Landai
    public string graphic()
    {
        String output = "";
        var    param1 = Request.Params["param1"].ToString();
        var    param2 = Request.Params["param2"].ToString();

        //var param3 = Request.Params["param3"].ToString();
        //var param4 = Request.Params["param4"].ToString();
        //var param5 = Request.Params["param5"].ToString();
        //var param6 = Request.Params["param6"].ToString();

        try
        {
            LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
            eSTP.Datas();
            DataSet ds = new DataSet();
            ds = eSTP.List2("LANDCOMP.D_REPORT", param1, param2);

            DataTable dt = new DataTable();
            dt = ds.Tables[0];

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                output += (dt.Rows[i]["t_xmlxx"].ToString());
            }
        }
        catch (Exception e)
        {
            output = e.Message;
        }
        return(output);
    }
コード例 #2
0
    private String Admin()
    {
        var    Param1 = Request.Params["param1"].ToString();
        var    Param2 = Request.Params["param2"].ToString();
        string output = "";

        try
        {
            LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
            eSTP.Datas();
            DataSet ds = new DataSet();
            ds = eSTP.List2("landcomp.C_ADMINS", Param1, Param2);

            dt = ds.Tables[0];


            for (int i = 0; i < dt.Rows.Count; i++)
            {
                output += dt.Rows[i]["namass"].ToString() + "|";
                output += dt.Rows[i]["idents"].ToString() + "*";
            }
            dt.Dispose();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
        return(output);
    }
コード例 #3
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "V":

            var Param1 = Request.Params["param1"].ToString();
            var Param2 = Request.Params["param2"].ToString();

            LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
            eSTP.Datas();
            DataSet ds = new DataSet();
            ds = eSTP.List23("P_PMBYRN", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = ds.Tables[0];

            Response.ContentType = "text/plain";
            Response.Write(dt.Rows[0]["pmbyrnNmrByr"].ToString() + "|");  //0
            Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|");  //1
            Response.Write(dt.Rows[0]["pmbyrnNmrPid"].ToString() + "|");  //2
            Response.Write(dt.Rows[0]["pmbyrnNmrNeg"].ToString() + "|");  //3
            Response.Write(dt.Rows[0]["pmbyrnNovism"].ToString() + "|");  //4
            Response.Write(dt.Rows[0]["berks1NmrBr1"].ToString() + "|");  //5
            Response.Write(dt.Rows[0]["pmbyrnTglASH"].ToString() + "|");  //6
            Response.Write(dt.Rows[0]["pmbyrnTglAMn"].ToString() + "|");  //7
            Response.Write(dt.Rows[0]["pmbyrnTglSrv"].ToString() + "|");  //8
            Response.Write(dt.Rows[0]["pmbyrnTglAGm"].ToString() + "|");  //9
            Response.Write(dt.Rows[0]["pmbyrnTgABod"].ToString() + "|");  //10
            Response.Write(dt.Rows[0]["pmbyrnTglAcc"].ToString() + "|");  //11
            Response.Write(dt.Rows[0]["pmbyrnPengBer"].ToString() + "|"); //12
            Response.Write(dt.Rows[0]["pmbyrnKetrgn"].ToString() + "|");  //13
            Response.Write(dt.Rows[0]["pmbyrnLnjuts"].ToString() + "|");  //14
            Response.Write(dt.Rows[0]["pmbyrnEkseps"].ToString() + "|");  //15
            Response.Write(dt.Rows[0]["pmbyrnKeteks"].ToString() + "|");  //16
            Response.Write(dt.Rows[0]["pmbyrnNamPer"].ToString() + "|");  //17
            Response.Write(dt.Rows[0]["tawar"].ToString() + "|");         //18


            //Response.Write(dt.Rows[0]["pmbyrnKeteks"].ToString() + "|");



            dt.Dispose();

            Response.End();
            Response.End();
            return(false);

        case "CRUD":
            Response.ContentType = "text/plain";
            Response.Write(Save());
            Response.End();
            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #4
0
    private String SaveUploadKelengkapan()
    {
        string IDRegistrasi  = Request.Params["IDREGISTRASI"].ToString();
        string _stNamaFile   = Request.Params["NAMA"].ToString();
        string _stKeterangan = Request.Params["KETERANGAN"].ToString();
        string _stNomor      = Request.Params["NOMOR"].ToString();

        LANDCOMP.UploadFile uf = new LANDCOMP.UploadFile();
        uf.Datas();

        string _stDates = DateTime.Today.ToString("yyyyMMdd");

        string param1  = Request.Params["param1"].ToString();
        string param3  = Request.Params["param3"].ToString();
        string param4  = Request.Params["param4"].ToString();
        string user    = Request.Params["user"].ToString();
        string wilayah = Request.Params["wilay"].ToString();


        string _stUploadKeterangan = "";

        _stUploadKeterangan = _stKeterangan;

        string uploadFolder = Request.PhysicalApplicationPath + "uploadDocument\\";
        string extension    = Path.GetExtension(_stNamaFile);

        LANDCOMP.paramz ext = new LANDCOMP.paramz();

        LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
        eSTP.Datas();
        DataSet ds = new DataSet();

        eSTP.save6("P_REGIST_D", param1, IDRegistrasi, param3, param4, _stKeterangan, "");

        if (param3 == "1")
        {
            param3 = "10";
        }
        if (param3 == "2")
        {
            param3 = "11";
        }
        if (param3 == "3")
        {
            param3 = "12";
        }
        if (param3 == "4")
        {
            param3 = "13";
        }

        if (extension != ".exe")
        {
            uf.UploadFilesWeb("I", user, _stDates, "Registrasi", param3, uploadFolder, IDRegistrasi, _stNomor + extension, _stNamaFile, param4);
        }

        var _stOutput = IDRegistrasi;

        return(_stOutput);
    }
コード例 #5
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "L":

            var param1L = Request.Params["param1"].ToString();

            LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
            eSTP_L.Datas();
            DataSet ds_L = new DataSet();
            ds_L = eSTP_L.List7("P_GROUPS", param1L, "", "", "", "", "", "");

            dt = ds_L.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");

            groupsid = Session["groups"].ToString();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                //Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["GroupIDents"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["GroupsNamess"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["GroupsLanjut"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["GroupsExcept"].ToString()) + "</cell>");

                if (groupsid == "Operator")
                {
                    Response.Write("<cell>" + RemoveWhiteSpace("View^PengecekanLapanganForm.aspx?rand=" + r.Next() + "&param1=V" + "&param2=" + dt.Rows[i]["GroupIDents"].ToString() + "") + "</cell>");
                }
                else
                {
                    Response.Write("<cell>" + RemoveWhiteSpace("View^GroupManagementForm.aspx?rand=" + r.Next() + "&param1=V" + "&param2=" + dt.Rows[i]["GroupIDents"].ToString() + "") + "</cell>");
                    Response.Write("<cell>" + RemoveWhiteSpace("Edit^GroupManagementForm.aspx?rand=" + r.Next() + "&param1=E" + "&param2=" + dt.Rows[i]["GroupIDents"].ToString() + "") + "</cell>");
                    Response.Write("<cell>" + RemoveWhiteSpace("Delete^GroupManagementForm.aspx?rand=" + r.Next() + "&param1=D" + "&param2=" + dt.Rows[i]["GroupIDents"].ToString() + "") + "</cell>");
                }
                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #6
0
ファイル: Home.aspx.cs プロジェクト: VikySihabudin/Landai
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "L":

            var param1L = Request.Params["param1"].ToString();
            var param2L = Request.Params["param2"].ToString();
            LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
            eSTP_L.Datas();
            DataSet ds_L = new DataSet();
            ds_L = eSTP_L.List2("P_HOME", param1L, param2L);

            dt = ds_L.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>");
                //Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>"); ///////////
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiSepakt"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsVerLnj"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks1Lanjut"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnLnjuts"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2Slesai"].ToString()) + "</cell>");
                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        case "graph":
            Response.ContentType = "application/xhtml+xml";
            Response.Write(graphic());
            Response.End();
            return(false);

            break;

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #7
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "L":

            var param1L = Request.Params["param1"].ToString();
            var param2L = Request.Params["param2"].ToString();
            var param4L = Request.Params["param4"].ToString();
            var param5L = Request.Params["param5"].ToString();
            LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
            eSTP_L.Datas();
            DataSet ds_L = new DataSet();
            ds_L = eSTP_L.List34("P_REGIST", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = ds_L.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");

            groupsid = Session["groups"].ToString();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregNmrPra"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["penlapNmrPen"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registAssign"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registLanjut"].ToString()) + "</cell>");

                if (dt.Rows[i]["registNmrReg"].ToString() != "")
                {
                    Response.Write("<cell>" + RemoveWhiteSpace("View^RegistrasiForm.aspx?rand=" + r.Next() + "&param1=V" + "&param2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
                    Response.Write("<cell>" + RemoveWhiteSpace("Edit^RegistrasiForm.aspx?rand=" + r.Next() + "&param1=E" + "&param2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
                    Response.Write("<cell>" + RemoveWhiteSpace("Delete^RegistrasiForm.aspx?rand=" + r.Next() + "&param1=D" + "&param2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
                }
                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #8
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "L":

            var param1L = Request.Params["param1"].ToString();
            var param2L = Request.Params["param2"].ToString();
            var param4L = Request.Params["param4"].ToString();
            var param5L = Request.Params["param5"].ToString();
            LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
            eSTP_L.Datas();
            DataSet ds_L = new DataSet();
            ds_L = eSTP_L.List17("P_BERKS2", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "", "", "", "", "");

            dt = ds_L.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");

            //groupsid = Session["groups"].ToString();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2NmrBr2"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnNmrByr"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2Assign"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2Slesai"].ToString()) + "</cell>");    //"Status" Tidak Tahu Fieldnya


                Response.Write("<cell>" + RemoveWhiteSpace("View^PemberkasanDuaForm.aspx?rand=" + r.Next() + "&param1=V" + "&param2=" + dt.Rows[i]["pmbyrnNmrByr"].ToString() + "") + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace("Edit^PemberkasanDuaForm.aspx?rand=" + r.Next() + "&param1=E" + "&param2=" + dt.Rows[i]["pmbyrnNmrByr"].ToString() + "") + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace("Delete^PemberkasanDuaForm.aspx?rand=" + r.Next() + "&param1=D" + "&param2=" + dt.Rows[i]["pmbyrnNmrByr"].ToString() + "") + "</cell>");

                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #9
0
    private void HakAkses()
    {
        //Response.ContentType = "text/plain";

        LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
        eSTP.Datas();
        DataSet ds = new DataSet();

        ds = eSTP.List8("P_MENU", "CHA", "", groups, "", "", "", "", "");

        dt = ds.Tables[0];

        //Response.ContentType = "text/plain";

        praregistrasi      = dt.Rows[0]["PraRegistrasi"].ToString();                  //0
        PengecekanLapangan = dt.Rows[1]["PengecekanLapangan"].ToString();             //1
        Registrasi         = dt.Rows[2]["Registrasi"].ToString();                     //2
        PengukuranT0       = dt.Rows[5]["PengukuranT0"].ToString();                   //3
        Verifikasi         = dt.Rows[4]["Verifikasi"].ToString();                     //4
        Negosiasi          = dt.Rows[3]["Negosiasi"].ToString();                      //5
        Pemberkasan        = dt.Rows[6]["Pemberkasan"].ToString();                    //6
        Pembayaran         = dt.Rows[7]["Pembayaran"].ToString();                     //7
        Finalisasi         = dt.Rows[8]["Finalisasi"].ToString();                     //8
        GroupManagement    = dt.Rows[9]["GroupManagement"].ToString();                //9
        UserManagement     = dt.Rows[10]["UserManagement"].ToString();                //10
        MasterIdentitas    = dt.Rows[11]["MasterIdentitas"].ToString();               //11
        MasterPerusahaan   = dt.Rows[12]["MasterPerusahaan"].ToString();              //12
        MasterCodes        = dt.Rows[13]["MasterCodes"].ToString();                   //13
        MasterMenu         = dt.Rows[14]["MasterMenu"].ToString();                    //14
        SerahTerimaBerkas  = dt.Rows[15]["SerahTerimaBerkas"].ToString();             //15
        TopPriority        = dt.Rows[16]["TopPriority"].ToString();                   //16
        FiveYears          = dt.Rows[17]["FiveYears"].ToString();                     //17
        LOM   = dt.Rows[18]["LOM"].ToString();                                        //18
        Other = dt.Rows[19]["Other"].ToString();                                      //19
        ReportPraRegistrasi      = dt.Rows[0]["ReportPraRegistrasi"].ToString();      //20
        ReportPengecekanLapangan = dt.Rows[1]["ReportPengecekanLapangan"].ToString(); //21
        ReportRegistrasi         = dt.Rows[2]["ReportRegistrasi"].ToString();         //22
        ReportPengukuranT0       = dt.Rows[3]["ReportPengukuranT0"].ToString();       //23
        ReportNegosiasi          = dt.Rows[5]["ReportNegosiasi"].ToString();          //24
        ReportVerifikasi         = dt.Rows[4]["ReportVerifikasi"].ToString();         //25
        ReportFinalisasi         = dt.Rows[8]["ReportFinalisasi"].ToString();         //26

        //Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
        //Response.Write("alert('Viky Ganteng');" + ReportFinalisasi);
        //Response.Write("</script>");

        dt.Dispose();

        //Response.End();
    }
コード例 #10
0
    private String SaveDetail()
    {
        String param1 = ""; if (Request.Params["param1"] is object)
        {
            param1 = Request.Params["param1"].ToString();
        }
        String param2 = ""; if (Request.Params["param2"] is object)
        {
            param2 = Request.Params["param2"].ToString();
        }
        String param3 = ""; if (Request.Params["param3"] is object)
        {
            param3 = Request.Params["param3"].ToString();
        }
        String param4 = ""; if (Request.Params["param4"] is object)
        {
            param4 = Request.Params["param4"].ToString();
        }
        String param5 = ""; if (Request.Params["param5"] is object)
        {
            param5 = Request.Params["param5"].ToString();
        }
        String param6 = ""; if (Request.Params["param6"] is object)
        {
            param6 = Request.Params["param6"].ToString();
        }
        String param7 = ""; if (Request.Params["param7"] is object)

        {
            param7 = Request.Params["param7"].ToString();
        }

        try
        {
            LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
            eSTP.Datas();
            DataSet ds = new DataSet();
            eSTP.save7("P_PENGTO_D", param1, param2, param3, param4, param5, param6, param7);
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
            Response.End();
            return(ex.Message);
        }

        return(param1);
    }
コード例 #11
0
    private void HakAkses()
    {
        if (Session["userid"] is object)
        {
            userid = Session["userid"].ToString();

            if (Session["groups"] is object)
            {
                groups = Session["groups"].ToString();
            }
        }

        if (!(Session["userid"] is object))
        {
            Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
            Response.Write("alert('Session sudah habis. Silakan login kembali.');");
            Response.Write("location.href = '../login.aspx';");
            Response.Write("</script>");
        }

        LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
        eSTP.Datas();
        DataSet ds = new DataSet();

        ds = eSTP.List8("P_MENU", "CHA", "", groups, "", "", "", "", "");

        dt = ds.Tables[0];

        MasterCodesEdit   = dt.Rows[13]["MasterCodesEdit"].ToString();   //0
        MasterCodesDelete = dt.Rows[13]["MasterCodesDelete"].ToString(); //1
        MasterCodesView   = dt.Rows[13]["MasterCodes"].ToString();       //2
        MasterCodesAssign = dt.Rows[13]["MasterCodesAssign"].ToString(); //3

        dt.Dispose();


        if (MasterCodesView.ToString() != "1")
        {
            if (groups.ToString() != "1")
            {
                Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
                Response.Write("alert('Anda Tidak Memiliki Akses Untuk Melihat Modul Ini');");
                Response.Write("location.href = 'home.aspx';");
                Response.Write("</script>");
            }
        }
    }
コード例 #12
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "V":
            var Param1 = Request.Params["param1"].ToString();
            var Param2 = Request.Params["param2"].ToString();
            LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
            eSTP.Datas();
            DataSet ds = new DataSet();
            ds = eSTP.List7("P_PERUSA", Param1, Param2, "", "", "", "", "");

            dt = ds.Tables[0];

            Response.ContentType = "text/plain";
            Response.Write(dt.Rows[0]["perusaIdents"].ToString() + "|");     //
            Response.Write(dt.Rows[0]["perusaDatess"].ToString() + "|");     //1
            Response.Write(dt.Rows[0]["perusaNamass"].ToString() + "|");     //2
            Response.Write(dt.Rows[0]["perusaKeterg"].ToString() + "|");     //3



            dt.Dispose();

            Response.End();
            Response.End();
            return(false);

        //return false;

        case "CRUD":
            Response.ContentType = "text/plain";
            Response.Write(Save());
            Response.End();
            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #13
0
    private String SaveUploadRegistrasi()
    {
        string IDRegistrasi  = Request.Params["IDREGISTRASI"].ToString();
        string _stNamaFile   = Request.Params["NAMA"].ToString();
        string _stKeterangan = Request.Params["KETERANGAN"].ToString();
        string _stNomor      = Request.Params["NOMOR"].ToString();

        LANDCOMP.UploadFile uf = new LANDCOMP.UploadFile();
        uf.Datas();

        string _stDates = DateTime.Today.ToString("yyyyMMdd");

        string param1  = Request.Params["param1"].ToString();
        string param5  = Request.Params["param5"].ToString();
        string user    = Request.Params["user"].ToString();
        string wilayah = Request.Params["wilay"].ToString();


        string _stUploadKeterangan = "";

        _stUploadKeterangan = _stKeterangan;

        string uploadFolder = Request.PhysicalApplicationPath + "uploadDocument\\";
        string extension    = Path.GetExtension(_stNamaFile);

        LANDCOMP.paramz ext = new LANDCOMP.paramz();

        LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
        eSTP.Datas();
        DataSet ds = new DataSet();

        //eSTP.save5("P_REGIST_U", param1, IDRegistrasi, "", param5, _stKeterangan);

        if (extension != ".exe")
        {
            uf.UploadFilesWeb("I", user, _stDates, "Master Identitas", param5, uploadFolder, IDRegistrasi, _stNomor + extension, _stNamaFile, _stUploadKeterangan);
        }

        var _stOutput = IDRegistrasi;

        return(_stOutput);
    }
コード例 #14
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "V":

            var param1 = Request.Params["param1"].ToString();
            var param2 = Request.Params["param2"].ToString();

            LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
            eSTP.Datas();
            DataSet ds = new DataSet();
            ds = eSTP.List8("P_USERSS", param1, param2, "", "", "", "", "", "");
            dt = ds.Tables[0];

            Response.ContentType = "text/plain";
            Response.Write(dt.Rows[0]["UserssIDents"].ToString() + "|");     //0
            //Response.Write(dt.Rows[0]["UserssPasswd"].ToString() + "|"); //1
            Response.Write(dt.Rows[0]["UserssNamess"].ToString() + "|");     //2
            Response.Write(dt.Rows[0]["UserssGroups"].ToString() + "|");     //3
            Response.Write(dt.Rows[0]["UserrsActive"].ToString() + "|");     //4

            dt.Dispose();

            Response.End();
            Response.End();
            return(false);

        case "CRUD":
            Response.ContentType = "text/plain";
            Response.Write(Save());
            Response.End();
            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #15
0
    private void HakAkses()
    {
        if (Session["userid"] is object)
        {
            userid = Session["userid"].ToString();

            if (Session["groups"] is object)
            {
                groups = Session["groups"].ToString();
            }
        }

        LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
        eSTP.Datas();
        DataSet ds = new DataSet();

        ds = eSTP.List8("P_MENU", "CHA", "", groups, "", "", "", "", "");

        dt = ds.Tables[0];

        UserManagementEdit   = dt.Rows[10]["UserManagementEdit"].ToString();   //0
        UserManagementDelete = dt.Rows[10]["UserManagementDelete"].ToString(); //1
        UserManagementView   = dt.Rows[10]["UserManagement"].ToString();       //2
        UserManagementAssign = dt.Rows[10]["UserManagementAssign"].ToString(); //3

        dt.Dispose();


        if (UserManagementView.ToString() != "1")
        {
            if (groups.ToString() != "1")
            {
                Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
                Response.Write("alert('Anda Tidak Memiliki Akses Untuk Melihat Modul Ini');");
                Response.Write("location.href = 'home.aspx';");
                Response.Write("</script>");
            }
        }
    }
コード例 #16
0
    private String Save()
    {
        if (Session["userid"] is object)
        {
            userid = Session["userid"].ToString();
        }

        String param1 = ""; if (Request.Params["param1"] is object)
        {
            param1 = Request.Params["param1"].ToString();
        }
        String param2 = ""; if (Request.Params["param2"] is object)
        {
            param2 = Request.Params["param2"].ToString();
        }
        String param3 = ""; if (Request.Params["param3"] is object)
        {
            param3 = Request.Params["param3"].ToString();
        }
        String param4 = ""; if (Request.Params["param4"] is object)
        {
            param4 = Request.Params["param4"].ToString();
        }
        String param5 = ""; if (Request.Params["param5"] is object)
        {
            param5 = Request.Params["param5"].ToString();
        }
        String param6 = ""; if (Request.Params["param6"] is object)
        {
            param6 = Request.Params["param6"].ToString();
        }
        String param7 = ""; if (Request.Params["param7"] is object)
        {
            param7 = Request.Params["param7"].ToString();
        }
        String param8 = ""; if (Request.Params["param8"] is object)
        {
            param8 = Request.Params["param8"].ToString();
        }
        String param9 = ""; if (Request.Params["param9"] is object)
        {
            param9 = Request.Params["param9"].ToString();
        }
        String param10 = ""; if (Request.Params["param10"] is object)
        {
            param10 = Request.Params["param10"].ToString();
        }
        String param11 = ""; if (Request.Params["param11"] is object)
        {
            param11 = Request.Params["param11"].ToString();
        }
        String param12 = ""; if (Request.Params["param12"] is object)
        {
            param12 = Request.Params["param12"].ToString();
        }
        String param13 = ""; if (Request.Params["param13"] is object)
        {
            param13 = Request.Params["param13"].ToString();
        }
        String param14 = ""; if (Request.Params["param14"] is object)
        {
            param14 = Request.Params["param14"].ToString();
        }
        String param15 = ""; if (Request.Params["param15"] is object)
        {
            param15 = Request.Params["param15"].ToString();
        }
        String param16 = ""; if (Request.Params["param16"] is object)
        {
            param16 = Request.Params["param16"].ToString();
        }
        String param17 = ""; if (Request.Params["param17"] is object)
        {
            param17 = Request.Params["param17"].ToString();
        }
        String param18 = ""; if (Request.Params["param18"] is object)
        {
            param18 = Request.Params["param18"].ToString();
        }
        String param19 = ""; if (Request.Params["param19"] is object)
        {
            param19 = Request.Params["param19"].ToString();
        }
        String param20 = ""; if (Request.Params["param20"] is object)
        {
            param20 = Request.Params["param20"].ToString();
        }
        String param21 = ""; if (Request.Params["param21"] is object)
        {
            param21 = Request.Params["param21"].ToString();
        }
        String param22 = ""; if (Request.Params["param22"] is object)
        {
            param22 = Request.Params["param22"].ToString();
        }
        String param23 = ""; if (Request.Params["param23"] is object)
        {
            param23 = Request.Params["param23"].ToString();
        }
        //String sql = "";
        String output = "";

        try
        {
            output = param1;

            if (output == "E" || output == "D" || output == "A")
            {
                LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
                eSTP.Datas();
                DataSet ds = new DataSet();
                ds = eSTP.List23("P_PMBYRN", "X", param2, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");
                dt = ds.Tables[0];

                if (dt.Rows.Count > 0)
                {
                    if (output == "E")
                    {
                        output = "noedit";
                    }

                    if (output == "D")
                    {
                        output = "nodelete";
                    }

                    if (output == "A")
                    {
                        output = "noadd";
                    }

                    return(output);
                }
            }


            if (output == "I" || output == "E" || output == "D")
            {
                LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
                eSTP.Datas();
                DataSet ds = new DataSet();
                eSTP.save23("P_PMBYRN", param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15, param16, param17, param18, param19, param20, param21, userid, param23);

                return(output);
            }
            else
            {
                output = "gagal";
            }
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
            Response.End();
            return(ex.Message);
        }

        return(output);
    }
コード例 #17
0
    private String Save()
    {
        //string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["ConStrLANDCOMPLocal2"].ToString();

        //conn2 = new Connection(strCon);

        String param1 = ""; if (Request.Params["param1"] is object)
        {
            param1 = Request.Params["param1"].ToString();
        }
        String param2 = ""; if (Request.Params["param2"] is object)
        {
            param2 = Request.Params["param2"].ToString();
        }
        String param3 = ""; if (Request.Params["param3"] is object)
        {
            param3 = Request.Params["param3"].ToString();
        }
        String param4 = ""; if (Request.Params["param4"] is object)
        {
            param4 = Request.Params["param4"].ToString();
        }
        String param5 = ""; if (Request.Params["param5"] is object)
        {
            param5 = Request.Params["param5"].ToString();
        }
        String param6 = ""; if (Request.Params["param6"] is object)
        {
            param6 = Request.Params["param6"].ToString();
        }
        String param7 = ""; if (Request.Params["param7"] is object)
        {
            param7 = Request.Params["param7"].ToString();
        }
        String param8 = ""; if (Request.Params["param8"] is object)
        {
            param8 = Request.Params["param8"].ToString();
        }
        String param9 = ""; if (Request.Params["param9"] is object)
        {
            param9 = Request.Params["param9"].ToString();
        }
        String param10 = ""; if (Request.Params["param10"] is object)
        {
            param10 = Request.Params["param10"].ToString();
        }
        String param11 = ""; if (Request.Params["param11"] is object)
        {
            param11 = Request.Params["param11"].ToString();
        }
        String param12 = ""; if (Request.Params["param12"] is object)
        {
            param12 = Request.Params["param12"].ToString();
        }
        String param13 = ""; if (Request.Params["param13"] is object)
        {
            param13 = Request.Params["param13"].ToString();
        }
        //String sql = "";
        String output = "";



        try
        {
            output = param1;

            if (output == "E" || output == "D" || output == "A")
            {
                LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
                eSTP.Datas();
                DataSet ds = new DataSet();
                ds = eSTP.List13("P_NEGOSI", "X", param2, "", "", "", "", "", "", "", "", "", "", "");
                dt = ds.Tables[0];

                if (dt.Rows.Count > 0)
                {
                    if (output == "E")
                    {
                        output = "noedit";
                    }

                    if (output == "D")
                    {
                        output = "nodelete";
                    }

                    if (output == "A")
                    {
                        output = "noadd";
                    }

                    return(output);
                }
            }

            if (output == "I" || output == "E" || output == "D")
            {
                LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
                eSTP.Datas();
                DataSet ds = new DataSet();
                eSTP.save13("P_NEGOSI", param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13);

                return(output);
            }
            else
            {
                output = "gagal";
            }
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
            Response.End();
            return(ex.Message);
        }

        return(output);
    }
コード例 #18
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "L":

            var param1L = Request.Params["param1"].ToString();
            LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
            eSTP_L.Datas();
            DataSet ds_L = new DataSet();
            ds_L = eSTP_L.List8("P_USERSS", param1L, "", "", "", "", "", "", "");

            dt = ds_L.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");



            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                //Response.Write("<cell>" + (i + 1).ToString() + "</cell>"); // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["UserssIDents"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["UserssNamess"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["UserssGroups"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["UserrsActive"].ToString()) + "</cell>");

                if (groups.ToString() == "1")
                {
                    Response.Write("<cell>" + RemoveWhiteSpace("View^UserManagementForm.aspx?rand=" + r.Next() + "&param1=V" + "&param2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>");
                    Response.Write("<cell>" + RemoveWhiteSpace("Edit^UserManagementForm.aspx?rand=" + r.Next() + "&param1=E" + "&param2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>");
                    Response.Write("<cell>" + RemoveWhiteSpace("Delete^UserManagementForm.aspx?rand=" + r.Next() + "&param1=D" + "&param2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>");
                }

                else
                {
                    if (UserManagementView.ToString() == "1")
                    {
                        Response.Write("<cell>" + RemoveWhiteSpace("View^UserManagementForm.aspx?rand=" + r.Next() + "&param1=V" + "&param2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>");
                    }
                    if (UserManagementEdit.ToString() == "1")
                    {
                        Response.Write("<cell>" + RemoveWhiteSpace("Edit^UserManagementForm.aspx?rand=" + r.Next() + "&param1=E" + "&param2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>");
                    }
                    if (UserManagementDelete.ToString() == "1")
                    {
                        Response.Write("<cell>" + RemoveWhiteSpace("Delete^UserManagementForm.aspx?rand=" + r.Next() + "&param1=D" + "&param2=" + dt.Rows[i]["UserssIDents"].ToString() + "") + "</cell>");
                    }
                }



                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #19
0
    public void HakAkses()
    {
        if (Session["userid"] is object)
        {
            userid = Session["userid"].ToString();

            if (Session["groups"] is object)
            {
                groups = Session["groups"].ToString();
            }
        }

        LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
        eSTP.Datas();
        DataSet ds = new DataSet();

        var Param1 = "";

        bool cek = true;

        if (cek && (Request.Params["param1"] is object))
        {
            Param1 = Request.Params["param1"].ToString();
        }
        else
        {
            Param1 = "";
        }

        ds = eSTP.List8("P_MENU", "CHA", "", groups, "", "", "", "", "");
        dt = ds.Tables[0];

        UserManagementView   = dt.Rows[10]["UserManagement"].ToString();       //0
        UserManagementEdit   = dt.Rows[10]["UserManagementEdit"].ToString();   //1
        UserManagementDelete = dt.Rows[10]["UserManagementDelete"].ToString(); //2
        UserManagementAssign = dt.Rows[10]["UserManagementAssign"].ToString(); //3

        dt.Dispose();

        if (Param1 == "")
        {
            if (UserManagementView.ToString() != "1")
            {
                if (groups.ToString() != "1")
                {
                    Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
                    Response.Write("alert('Anda Tidak Memiliki Akses Untuk Menambah Di Modul Ini');");
                    Response.Write("location.href = 'home.aspx';");
                    Response.Write("</script>");
                }
            }
        }

        else if (Param1 == "V")
        {
            if (UserManagementView.ToString() != "1")
            {
                if (groups.ToString() != "1")
                {
                    Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
                    Response.Write("alert('Anda Tidak Memiliki Akses Untuk Melihat Di Modul Ini');");
                    Response.Write("location.href = 'home.aspx';");
                    Response.Write("</script>");
                }
            }
        }

        else if (Param1 == "E")
        {
            if (UserManagementEdit.ToString() != "1")
            {
                if (groups.ToString() != "1")
                {
                    Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
                    Response.Write("alert('Anda Tidak Memiliki Akses Untuk Edit Di Modul Ini');");
                    Response.Write("location.href = 'home.aspx';");
                    Response.Write("</script>");
                }
            }
        }

        else if (Param1.ToString() == "D")
        {
            if (UserManagementDelete.ToString() != "1")
            {
                if (groups.ToString() != "1")
                {
                    Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
                    Response.Write("alert('Anda Tidak Memiliki Akses Untuk Delete Di Modul Ini');");
                    Response.Write("location.href = 'home.aspx';");
                    Response.Write("</script>");
                }
            }
        }

        else
        {
            Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
            Response.Write("alert('Aksi Yang Anda Cari Tidak Ditemukan');");
            Response.Write("location.href = 'home.aspx';");
            Response.Write("</script>");
        }
    }
コード例 #20
0
    private String Save()
    {
        if (Session["userid"] is object)
        {
            userid = Session["userid"].ToString();
        }

        String param1 = ""; if (Request.Params["param1"] is object)
        {
            param1 = Request.Params["param1"].ToString();
        }
        String param2 = ""; if (Request.Params["param2"] is object)
        {
            param2 = Request.Params["param2"].ToString();
        }
        String param3 = ""; if (Request.Params["param3"] is object)
        {
            param3 = Request.Params["param3"].ToString();
        }
        String param4 = ""; if (Request.Params["param4"] is object)
        {
            param4 = Request.Params["param4"].ToString();
        }
        String param5 = ""; if (Request.Params["param5"] is object)
        {
            param5 = Request.Params["param5"].ToString();
        }
        String param6 = ""; if (Request.Params["param6"] is object)
        {
            param6 = Request.Params["param6"].ToString();
        }
        String param7 = ""; if (Request.Params["param7"] is object)
        {
            param7 = Request.Params["param7"].ToString();
        }
        String param8 = ""; if (Request.Params["param8"] is object)
        {
            param8 = Request.Params["param8"].ToString();
        }
        //String sql = "";
        String output = "";

        try
        {
            output = param1;

            if (output == "E")
            {
                LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
                eSTP.Datas();
                DataSet ds = new DataSet();
                ds = eSTP.List8("P_USERSS", "X", param2, param8, "", "", "", "", "");
                dt = ds.Tables[0];

                if (dt.Rows.Count > 0)
                {
                    eSTP.Datas();
                    eSTP.save8("P_USERSS", param1, param2, param3, param4, param5, param6, userid, "");
                    return(output);
                }
                output = "noedit";
                return(output);
            }

            if (output == "D" || output == "I")
            {
                LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
                eSTP.Datas();
                eSTP.save8("P_USERSS", param1, param2, param3, param4, param5, param6, userid, param8);
                return(output);
            }
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
            Response.End();
            return(ex.Message);
        }

        return(output);
    }
コード例 #21
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "V":     // Untuk Menampilkan Data Form Registrasi

            var Param1 = Request.Params["param1"].ToString();
            var Param2 = Request.Params["param2"].ToString();



            LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
            eSTP.Datas();
            DataSet ds = new DataSet();
            ds = eSTP.List34("P_REGIST", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = ds.Tables[0];

            Response.ContentType = "text/plain";

            Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|");     //0
            Response.Write(dt.Rows[0]["penlapNmrPen"].ToString() + "|");     //1
            Response.Write(dt.Rows[0]["registIdents"].ToString() + "|");     //2
            Response.Write(dt.Rows[0]["MidentNamass"].ToString() + "|");     //3
            Response.Write(dt.Rows[0]["MidentIdents"].ToString() + "|");     //4
            Response.Write(dt.Rows[0]["MidentNamass"].ToString() + "|");     //5
            Response.Write(dt.Rows[0]["MidentJnsKel"].ToString() + "|");     //6
            Response.Write(dt.Rows[0]["MidentTmplhr"].ToString() + "|");     //7
            Response.Write(dt.Rows[0]["MidentTgllhr"].ToString() + "|");     //8
            Response.Write(dt.Rows[0]["MidentPekerj"].ToString() + "|");     //9
            Response.Write(dt.Rows[0]["MidentNmrPeg"].ToString() + "|");     //10
            Response.Write(dt.Rows[0]["MidentAlamat"].ToString() + "|");     //11
            Response.Write(dt.Rows[0]["MidentJnsIdn"].ToString() + "|");     //12
            Response.Write(dt.Rows[0]["MidentNmrHps"].ToString() + "|");     //13
            Response.Write(dt.Rows[0]["MidentStatus"].ToString() + "|");     //14
            Response.Write(dt.Rows[0]["MidentNmPsng"].ToString() + "|");     //15
            Response.Write(dt.Rows[0]["MidentTmpPas"].ToString() + "|");     //16
            Response.Write(dt.Rows[0]["MidentTglPas"].ToString() + "|");     //17
            Response.Write(dt.Rows[0]["MidentThnNkh"].ToString() + "|");     //18
            Response.Write(dt.Rows[0]["registTy1Sts"].ToString() + "|");     //19
            Response.Write(dt.Rows[0]["registTy1Sts"].ToString() + "|");     //20
            Response.Write(dt.Rows[0]["registTy2Jml"].ToString() + "|");     //21
            Response.Write(dt.Rows[0]["registTy2Sts"].ToString() + "|");     //22
            Response.Write(dt.Rows[0]["registAlshak"].ToString() + "|");     //23
            Response.Write(dt.Rows[0]["registSHMsss"].ToString() + "|");     //24
            Response.Write(dt.Rows[0]["registSHMNmr"].ToString() + "|");     //25
            Response.Write(dt.Rows[0]["registSKTsss"].ToString() + "|");     //26
            Response.Write(dt.Rows[0]["registSKTNmr"].ToString() + "|");     //27
            Response.Write(dt.Rows[0]["registTahuns"].ToString() + "|");     //28
            Response.Write(dt.Rows[0]["praregLokkab"].ToString() + "|");     //29
            Response.Write(dt.Rows[0]["praregLokkec"].ToString() + "|");     //30
            Response.Write(dt.Rows[0]["praregLokdes"].ToString() + "|");     //31
            Response.Write(dt.Rows[0]["registLuasss"].ToString() + "|");     //32
            Response.Write(dt.Rows[0]["registBtsutr"].ToString() + "|");     //33
            Response.Write(dt.Rows[0]["registBtsslt"].ToString() + "|");     //34
            Response.Write(dt.Rows[0]["registBtstmr"].ToString() + "|");     //35
            Response.Write(dt.Rows[0]["registBtsbrt"].ToString() + "|");     //36
            Response.Write(dt.Rows[0]["registTy3Sts"].ToString() + "|");     //37
            Response.Write(dt.Rows[0]["registTy3Thn"].ToString() + "|");     //38
            Response.Write(dt.Rows[0]["registTy4Sts"].ToString() + "|");     //39
            Response.Write(dt.Rows[0]["registTy4Thn"].ToString() + "|");     //40
            Response.Write(dt.Rows[0]["registTy5Sts"].ToString() + "|");     //41
            Response.Write(dt.Rows[0]["registTy5Thn"].ToString() + "|");     //42
            Response.Write(dt.Rows[0]["registKtergn"].ToString() + "|");     //43
            Response.Write(dt.Rows[0]["registEkspsi"].ToString() + "|");     //44
            Response.Write(dt.Rows[0]["registLanjut"].ToString() + "|");     //45
            Response.Write(dt.Rows[0]["registKeteks"].ToString() + "|");     //46

            dt.Dispose();

            Response.End();
            Response.End();
            return(false);

        case "cek":

            var Param1x = Request.Params["param1"].ToString();
            var Param2x = Request.Params["param2"].ToString();



            LANDCOMP.ExecuteSTP eSTPx = new LANDCOMP.ExecuteSTP();
            eSTPx.Datas();
            DataSet dsx = new DataSet();
            dsx = eSTPx.List34("P_REGIST", Param1x, "", "", "", "", "", "", "", "", "", "", Param2x, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = dsx.Tables[0];

            Response.ContentType = "text/plain";

            Response.Write(dt.Rows[0]["duplikat"].ToString() + "|");     //0
            Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|"); //1

            dt.Dispose();

            Response.End();
            return(false);

        case "LAN":

            var param1LAN = Request.Params["param1"].ToString();
            var param2LAN = Request.Params["param2"].ToString();

            LANDCOMP.ExecuteSTP eSTP_LAN = new LANDCOMP.ExecuteSTP();
            eSTP_LAN.Datas();
            DataSet ds_LAN = new DataSet();
            ds_LAN = eSTP_LAN.List34("P_REGIST", param1LAN, param2LAN, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = ds_LAN.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentNamass"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentTgllhr"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentPkrjan"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentAlamat"].ToString()) + "</cell>");
                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        case "LAY":

            var param1LAY = Request.Params["param1"].ToString();
            var param2LAY = Request.Params["param2"].ToString();

            LANDCOMP.ExecuteSTP eSTP_LAY = new LANDCOMP.ExecuteSTP();
            eSTP_LAY.Datas();
            DataSet ds_LAY = new DataSet();
            ds_LAY = eSTP_LAY.List34("P_REGIST", param1LAY, param2LAY, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = ds_LAY.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");

            for (int i = 0; i < 1; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNmAyah"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentTglAyh"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentKrjAyh"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentAlmAyh"].ToString()) + "</cell>");
                Response.Write("</row>");
            }

            Response.Write("</rows>");
            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        case "LIB":

            var param1LIB = Request.Params["param1"].ToString();
            var param2LIB = Request.Params["param2"].ToString();

            LANDCOMP.ExecuteSTP eSTP_LIB = new LANDCOMP.ExecuteSTP();
            eSTP_LIB.Datas();
            DataSet ds_LIB = new DataSet();
            ds_LIB = eSTP_LIB.List34("P_REGIST", param1LIB, param2LIB, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = ds_LIB.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");

            for (int i = 0; i < 1; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNmIbus"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentTglIbu"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentKrjIbu"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentAlmIbu"].ToString()) + "</cell>");
                Response.Write("</row>");
            }

            Response.Write("</rows>");
            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        case "CRUD":
            Response.ContentType = "text/plain";
            Response.Write(Save());
            Response.End();
            return(false);

        case "ddkl":
            Response.ContentType = "text/plain";
            Response.Write(IsiKelengkapan("1"));
            Response.End();
            return(false);

        case "IA":

            string param1IA = Request.Params["param1"].ToString();
            string param2IA = Request.Params["param2"].ToString();
            string param3IA = Request.Params["param3"].ToString();
            string param4IA = Request.Params["param4"].ToString();
            string param5IA = Request.Params["param5"].ToString();
            string param6IA = Request.Params["param6"].ToString();


            LANDCOMP.ExecuteSTP eSTP_IA = new LANDCOMP.ExecuteSTP();
            eSTP_IA.Datas();
            eSTP_IA.param6("P_REGIST_D", param1IA, param2IA, param3IA, param4IA, param5IA, param6IA);

            return(false);

        case "SA":     // Untuk Menampilkan Data Grid Kondisi Lahan Dan Ifra Stuktur

            var param1SA = Request.Params["param1"].ToString();
            var param2SA = Request.Params["param2"].ToString();
            var param3SA = Request.Params["param3"].ToString();

            LANDCOMP.ExecuteSTP eSTP_SA = new LANDCOMP.ExecuteSTP();
            eSTP_SA.Datas();
            DataSet ds_SA = new DataSet();
            ds_SA = eSTP_SA.param6("P_REGIST_D", param1SA, param2SA, param3SA, "", "", "");

            dt = ds_SA.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registKondis"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registKeters"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:Hapus(\"" + "DA" + "\",\"" + "DA" + "\",\"" + dt.Rows[i]["registNmrReg"].ToString() + "\",\"" + dt.Rows[i]["registSequen"].ToString() + "\",\"" + dt.Rows[i]["registSequen"].ToString() + "\");^_self") + "</cell>");

                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();

            Response.End();

            return(false);

        case "DA":

            string param1DA = Request.Params["param1"].ToString();
            string param2DA = Request.Params["param2"].ToString();
            string param3DA = Request.Params["param3"].ToString();

            LANDCOMP.ExecuteSTP eSTP_DA = new LANDCOMP.ExecuteSTP();
            eSTP_DA.Datas();
            eSTP_DA.save6("P_REGIST_D", param1DA, param2DA, "", "", "", param3DA);

            return(false);

        case "ListUploadIdentitasLahan":

            var Param1z = Request.Params["param1"].ToString();
            var Param2z = Request.Params["IDRegistrasi"].ToString();

            String path_pic = (HttpContext.Current.Request.Url.AbsolutePath).ToLower();


            LANDCOMP.ExecuteSTP eSTPz = new LANDCOMP.ExecuteSTP();
            eSTPz.Datas();
            DataSet dsz = new DataSet();
            dsz = eSTPz.List34("P_REGIST", Param1z, Param2z, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = dsz.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");

                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["codessDescs1"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumFiless"].ToString()) + "</cell>");

                Response.Write("<cell>" + "Download^" + path_pic + "?sm=df&amp;namafile=" + dt.Rows[i]["hdocumIdLink"].ToString() + "&amp;filelama=" + dt.Rows[i]["hdocumFiless"].ToString() + "</cell>");
                //Response.Write("<cell>" + "Delete^" + path_pic + "?sm=Deletepic&amp;IDSOURCE=" + dt.Rows[i]["IDSource"].ToString() + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:DeletePic(\"" + dt.Rows[i]["hdocumIdLink"].ToString()) + "\",\"" + Param2z + "\");^_self" + "</cell>");

                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdSour"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdLink"].ToString()) + "</cell>");
                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();
            //conn.myConnectionClose();
            Response.End();
            return(false);

        case "ListUploadKelengkapan":

            var Param1a = Request.Params["param1"].ToString();
            var Param2a = Request.Params["IDRegistrasi"].ToString();

            String path_pica = (HttpContext.Current.Request.Url.AbsolutePath).ToLower();


            LANDCOMP.ExecuteSTP eSTPa = new LANDCOMP.ExecuteSTP();
            eSTPa.Datas();
            DataSet dsa = new DataSet();
            dsa = eSTPa.List6("P_REGIST_D", Param1a, Param2a, "", "", "", "");

            dt = dsa.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");

                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["codessDescs1"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["codessDescs2"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumFiless"].ToString()) + "</cell>");

                Response.Write("<cell>" + "Download^" + path_pica + "?sm=df&amp;namafile=" + dt.Rows[i]["hdocumIdLink"].ToString() + "&amp;filelama=" + dt.Rows[i]["hdocumFiless"].ToString() + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:DeletePic(\"" + dt.Rows[i]["hdocumIdLink"].ToString()) + "\",\"" + Param2a + "\");^_self" + "</cell>");

                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdSour"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdLink"].ToString()) + "</cell>");
                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();
            //conn.myConnectionClose();
            Response.End();
            return(false);

        case "SaveUploadRegistrasi":
            Response.ContentType = "text/plain";
            Response.Write(SaveUploadRegistrasi());
            Response.End();
            return(false);

        case "SaveUploadKelengkapan":
            Response.ContentType = "text/plain";
            Response.Write(SaveUploadKelengkapan());
            Response.End();
            return(false);


        case "df":
            Response.Clear();
            string namafile   = (Request.Params["filelama"] is object?Request.Params["filelama"].ToString() : "");
            String urlfile    = (Request.Params["namafile"] is object?Request.Params["namafile"].ToString() : "");
            String randomfile = (Request.Params["random"] is object?Request.Params["random"].ToString() : "");
            string type       = "";
            switch (namafile.Substring(namafile.Length - 4))
            {
            case ".htm":
            case ".html":
                type = "text/HTML";
                break;

            case ".txt":
                type = "text/plain";
                break;

            case ".doc":
            case ".docx":
            case ".rtf":
                type = "Application/msword";
                break;

            case ".xls":
            case ".xlsx":
                type = "Application/msexcel";
                break;

            case ".zip":
            case ".rar":
                type = "application/zip";
                break;

            case ".pdf":
                type = "application/pdf";
                break;

            case ".jpg":
                type = "image/JPG";
                break;

            case ".pgn":
                type = "image/PNG";
                break;

            case ".tif":
                type = "image/tif";
                break;
            }

            Response.AddHeader("content-disposition", "attachment;filename=" + namafile + "");
            Response.ContentType = type;

            Response.WriteFile(Server.MapPath(@"~/uploaddocument/" + Request.Params["namafile"].ToString().Replace("&amp;", "&")));

            Response.End();
            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #22
0
    private String Save()
    {
        String param1 = ""; if (Request.Params["param1"] is object)
        {
            param1 = Request.Params["param1"].ToString();
        }
        String param2 = ""; if (Request.Params["param2"] is object)
        {
            param2 = Request.Params["param2"].ToString();
        }
        String param3 = ""; if (Request.Params["param3"] is object)
        {
            param3 = Request.Params["param3"].ToString();
        }
        String param4 = ""; if (Request.Params["param4"] is object)
        {
            param4 = Request.Params["param4"].ToString();
        }
        String param5 = ""; if (Request.Params["param5"] is object)
        {
            param5 = Request.Params["param5"].ToString();
        }
        String param6 = ""; if (Request.Params["param6"] is object)
        {
            param6 = Request.Params["param6"].ToString();
        }
        String param7 = ""; if (Request.Params["param7"] is object)
        {
            param7 = Request.Params["param7"].ToString();
        }
        String param8 = ""; if (Request.Params["param8"] is object)
        {
            param8 = Request.Params["param8"].ToString();
        }
        String param9 = ""; if (Request.Params["param9"] is object)
        {
            param9 = Request.Params["param9"].ToString();
        }
        String param10 = ""; if (Request.Params["param10"] is object)
        {
            param10 = Request.Params["param10"].ToString();
        }
        String param11 = ""; if (Request.Params["param11"] is object)
        {
            param11 = Request.Params["param11"].ToString();
        }
        String param12 = ""; if (Request.Params["param12"] is object)
        {
            param12 = Request.Params["param12"].ToString();
        }
        String param13 = ""; if (Request.Params["param13"] is object)
        {
            param13 = Request.Params["param13"].ToString();
        }
        String param14 = ""; if (Request.Params["param14"] is object)
        {
            param14 = Request.Params["param14"].ToString();
        }
        String param15 = ""; if (Request.Params["param15"] is object)
        {
            param15 = Request.Params["param15"].ToString();
        }
        String param16 = ""; if (Request.Params["param16"] is object)
        {
            param16 = Request.Params["param16"].ToString();
        }
        String param17 = ""; if (Request.Params["param17"] is object)
        {
            param17 = Request.Params["param17"].ToString();
        }
        String param18 = ""; if (Request.Params["param18"] is object)
        {
            param18 = Request.Params["param18"].ToString();
        }
        String param19 = ""; if (Request.Params["param19"] is object)
        {
            param19 = Request.Params["param19"].ToString();
        }
        String param20 = ""; if (Request.Params["param20"] is object)
        {
            param20 = Request.Params["param20"].ToString();
        }
        String param21 = ""; if (Request.Params["param21"] is object)
        {
            param21 = Request.Params["param21"].ToString();
        }
        String param22 = ""; if (Request.Params["param22"] is object)
        {
            param22 = Request.Params["param22"].ToString();
        }
        String param23 = ""; if (Request.Params["param23"] is object)
        {
            param23 = Request.Params["param23"].ToString();
        }
        String param24 = ""; if (Request.Params["param24"] is object)
        {
            param24 = Request.Params["param24"].ToString();
        }
        String param25 = ""; if (Request.Params["param25"] is object)
        {
            param25 = Request.Params["param25"].ToString();
        }
        String param26 = ""; if (Request.Params["param26"] is object)
        {
            param26 = Request.Params["param26"].ToString();
        }


        String sql    = "";
        String output = "";

        try
        {
            output = param1;

            if (output == "I" || output == "E" || output == "D")
            {
                LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
                eSTP.Datas();
                DataSet ds = new DataSet();
                eSTP.save26("P_MINDENT", param1, param2, param3, param4, param5, param6, param7, param8, param9, param10, param11, param12, param13, param14, param15, param16, param17, param18, param19, param20, param21, param22, param23, param24, param25, param26);


                return(output);
            }
            else
            {
                output = "gagal";
            }
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
            Response.End();
            return(ex.Message);
        }

        return(output);
    }
コード例 #23
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "select":

            var param1SM = Request.Params["param1"].ToString();
            var param2SM = Request.Params["param2"].ToString();

            LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
            eSTP.Datas();
            DataSet ds = new DataSet();
            ds = eSTP.param26("P_MINDENT", param1SM, param2SM, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = ds.Tables[0];

            Response.ContentType = "text/plain";

            Response.Write(dt.Rows[0]["MidentIdents"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentJnsIdn"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentNamass"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentJnsKel"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentTmplhr"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentTgllhr"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentPekerj"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentNmrPeg"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentAlamat"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentNmrHps"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentStatus"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentNmPsng"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentTmpPas"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentTglPas"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentThnNkh"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentNmAyah"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentTglAyh"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentKrjAyh"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentAlmAyh"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentNmIbus"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentTglIbu"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentKrjIbu"].ToString() + "|");
            Response.Write(dt.Rows[0]["MidentAlmIbu"].ToString() + "|");


            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        case "SA":

            var param1SA = Request.Params["param1"].ToString();
            var param2SA = Request.Params["param2"].ToString();

            LANDCOMP.ExecuteSTP eSTP_SA = new LANDCOMP.ExecuteSTP();
            eSTP_SA.Datas();
            DataSet ds_SA = new DataSet();
            ds_SA = eSTP_SA.param7("P_MINDENT_A", param1SA, param2SA, "", "", "", "", "");

            dt = ds_SA.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentNamass"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentTgllhr"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentPkrjan"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentAlamat"].ToString()) + "</cell>");
                //Response.Write("<cell>" + RemoveWhiteSpace("View^javascript:View(\"" + "SA" + "\",\"" + "SA" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</cell>");
                //Response.Write("<cell>" + RemoveWhiteSpace("Edit^javascript:EditDetil(\"" + "UA" + "\",\"" + "UA" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:Hapus(\"" + "DA" + "\",\"" + "DA" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</cell>");

                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        case "SS":

            var param1SS = Request.Params["param1"].ToString();
            var param2SS = Request.Params["param2"].ToString();


            LANDCOMP.ExecuteSTP eSTP_SS = new LANDCOMP.ExecuteSTP();
            eSTP_SS.Datas();
            DataSet ds_SS = new DataSet();
            ds_SA = eSTP_SS.param7("P_MINDENT_S", param1SS, param2SS, "", "", "", "", "");

            dt = ds_SA.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentNamass"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentTgllhr"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentPkrjan"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["midentAlamat"].ToString()) + "</cell>");
                //Response.Write("<cell>" + RemoveWhiteSpace("View^javascript:View(\"" + "SS" + "\",\"" + "SS" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</cell>");
                //Response.Write("<cell>" + RemoveWhiteSpace("Edit^javascript:Edit(\"" + "US" + "\",\"" + "US" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:Hapus(\"" + "DS" + "\",\"" + "DS" + "\",\"" + dt.Rows[i]["MidentIdents"].ToString() + "\",\"" + dt.Rows[i]["midentSequen"].ToString() + "\");^_self") + "</cell>");

                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        case "IA":

            string param1IA = Request.Params["param1"].ToString();
            string param2IA = Request.Params["param2"].ToString();
            //string param3IA = Request.Params["param3"].ToString();
            string param4IA = Request.Params["param4"].ToString();
            string param5IA = Request.Params["param5"].ToString();
            string param6IA = Request.Params["param6"].ToString();
            string param7IA = Request.Params["param7"].ToString();


            LANDCOMP.ExecuteSTP eSTP_IA = new LANDCOMP.ExecuteSTP();
            eSTP_IA.Datas();
            eSTP_IA.save7("P_MINDENT_A", param1IA, param2IA, "", param4IA, param5IA, param6IA, param7IA);

            return(false);

        case "IS":

            string param1IS = Request.Params["param1"].ToString();
            string param2IS = Request.Params["param2"].ToString();
            //string param3IS = Request.Params["param3"].ToString();
            string param4IS = Request.Params["param4"].ToString();
            string param5IS = Request.Params["param5"].ToString();
            string param6IS = Request.Params["param6"].ToString();
            string param7IS = Request.Params["param7"].ToString();


            LANDCOMP.ExecuteSTP eSTP_IS = new LANDCOMP.ExecuteSTP();
            eSTP_IS.Datas();
            eSTP_IS.save7("P_MINDENT_S", param1IS, param2IS, "", param4IS, param5IS, param6IS, param7IS);

            return(false);

        case "DA":

            string param1DA = Request.Params["param1"].ToString();
            string param2DA = Request.Params["param2"].ToString();
            string param3DA = Request.Params["param3"].ToString();

            LANDCOMP.ExecuteSTP eSTP_DA = new LANDCOMP.ExecuteSTP();
            eSTP_DA.Datas();
            eSTP_DA.save7("P_MINDENT_A", param1DA, param2DA, param3DA, "", "", "", "");

            return(false);

        case "DS":

            string param1DS = Request.Params["param1"].ToString();
            string param2DS = Request.Params["param2"].ToString();
            string param3DS = Request.Params["param3"].ToString();

            LANDCOMP.ExecuteSTP eSTP_DS = new LANDCOMP.ExecuteSTP();
            eSTP_DS.Datas();
            eSTP_DS.save7("P_MINDENT_S", param1DS, param2DS, param3DS, "", "", "", "");

            return(false);

        case "Save":
            Response.ContentType = "text/plain";
            Response.Write(Save());
            Response.End();
            return(false);

        case "Insert":
            Response.ContentType = "text/plain";
            Response.Write(Save());
            Response.End();
            return(false);

        case "Delete":
            Response.ContentType = "text/plain";
            Response.Write(Save());
            Response.End();
            return(false);


        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #24
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "L":

            HakAkses();
            var param1L = Request.Params["param1"].ToString();
            var param2L = Request.Params["param2"].ToString();
            var param4L = Request.Params["param4"].ToString();
            var param5L = Request.Params["param5"].ToString();
            LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
            eSTP_L.Datas();
            DataSet ds_L = new DataSet();
            ds_L = eSTP_L.List11("P_VISUMS", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "");

            dt = ds_L.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");

            //groupsid = Session["groups"].ToString();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsNovism"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNmrPid"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsAssign"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsVerLnj"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNamPLK"].ToString()) + "</cell>");

                if (dt.Rows[i]["visumsNovism"].ToString() != "")
                {
                    if (groups.ToString() == "1")
                    {
                        Response.Write("<cell>" + RemoveWhiteSpace("View^VisumForm.aspx?rand=" + r.Next() + "&param1=V" + "&param2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
                        Response.Write("<cell>" + RemoveWhiteSpace("Edit^VisumForm.aspx?rand=" + r.Next() + "&param1=E" + "&param2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
                        Response.Write("<cell>" + RemoveWhiteSpace("Delete^VisumForm.aspx?rand=" + r.Next() + "&param1=D" + "&param2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
                    }
                    else
                    {
                        if (dt.Rows[i]["visumsVerLnj"].ToString() != "Lanjut")
                        {
                            if (VerifikasiView.ToString() == "1")
                            {
                                Response.Write("<cell>" + RemoveWhiteSpace("View^VisumForm.aspx?rand=" + r.Next() + "&param1=V" + "&param2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
                            }
                            if (VerifikasiEdit.ToString() == "1")
                            {
                                Response.Write("<cell>" + RemoveWhiteSpace("Edit^VisumForm.aspx?rand=" + r.Next() + "&param1=E" + "&param2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
                            }
                            if (VerifikasiDelete.ToString() == "1")
                            {
                                Response.Write("<cell>" + RemoveWhiteSpace("Delete^VisumForm.aspx?rand=" + r.Next() + "&param1=D" + "&param2=" + dt.Rows[i]["registNmrReg"].ToString() + "") + "</cell>");
                            }
                        }
                    }
                }


                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();
            Response.End();
            Response.End();

            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #25
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "select":

            var Param1 = Request.Params["param1"].ToString();
            var Param2 = Request.Params["param2"].ToString();

            LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
            eSTP.Datas();
            DataSet ds = new DataSet();
            ds = eSTP.select9("landcomp.P_PRAREG", Param1, Param2, "", "", "", "", "", "", "");

            dt = ds.Tables[0];

            Response.ContentType = "text/plain";

            Response.Write(dt.Rows[0]["praregNmrPra"].ToString() + "|");     //0
            Response.Write(dt.Rows[0]["praregIdents"].ToString() + "|");     //1
            Response.Write(dt.Rows[0]["MidentNamass"].ToString() + "|");     //2
            Response.Write(dt.Rows[0]["MidentJnsKel"].ToString() + "|");     //3
            Response.Write(dt.Rows[0]["MidentTmplhr"].ToString() + "|");     //4
            Response.Write(dt.Rows[0]["MidentTgllhr"].ToString() + "|");     //5
            Response.Write(dt.Rows[0]["MidentPekerj"].ToString() + "|");     //6
            Response.Write(dt.Rows[0]["MidentAlamat"].ToString() + "|");     //7
            Response.Write(dt.Rows[0]["MidentNmrHps"].ToString() + "|");     //8
            Response.Write(dt.Rows[0]["MidentJnsIdn"].ToString() + "|");     //9
            Response.Write(dt.Rows[0]["praregLokkab"].ToString() + "|");     //10
            Response.Write(dt.Rows[0]["praregLokkec"].ToString() + "|");     //11
            Response.Write(dt.Rows[0]["praregLokdes"].ToString() + "|");     //12
            Response.Write(dt.Rows[0]["praregLanjut"].ToString() + "|");     //13

            dt.Dispose();

            Response.End();
            Response.End();
            return(false);

        case "Save":
            Response.ContentType = "text/plain";
            Response.Write(Save());
            Response.End();
            return(false);

        case "Delete":
            Response.ContentType = "text/plain";
            Response.Write(Delete());
            Response.End();
            return(false);

        case "dd":
            Response.ContentType = "text/plain";
            Response.Write(Admin());
            Response.End();
            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #26
0
    private String Delete()
    {
        String param1 = ""; if (Request.Params["param1"] is object)
        {
            param1 = Request.Params["param1"].ToString();
        }
        String param2 = ""; if (Request.Params["param2"] is object)
        {
            param2 = Request.Params["param2"].ToString();
        }
        String param3 = ""; if (Request.Params["param3"] is object)
        {
            param3 = Request.Params["param3"].ToString();
        }
        String param4 = ""; if (Request.Params["param4"] is object)
        {
            param4 = Request.Params["param4"].ToString();
        }
        String param5 = ""; if (Request.Params["param5"] is object)
        {
            param5 = Request.Params["param5"].ToString();
        }
        String param6 = ""; if (Request.Params["param6"] is object)
        {
            param6 = Request.Params["param6"].ToString();
        }
        String param7 = ""; if (Request.Params["param7"] is object)
        {
            param7 = Request.Params["param7"].ToString();
        }
        String param8 = ""; if (Request.Params["param8"] is object)
        {
            param8 = Request.Params["param8"].ToString();
        }
        String param9 = ""; if (Request.Params["param9"] is object)
        {
            param8 = Request.Params["param9"].ToString();
        }

        String sql    = "";
        String output = "";



        try
        {
            output = param1;

            if (output == "I" || output == "E" || output == "D")
            {
                LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
                eSTP.Datas();
                DataSet ds = new DataSet();
                ds = eSTP.List9("P_PRAREG", "X", param2, "", "", "", "", "", "", "");
                dt = ds.Tables[0];

                if (dt.Rows.Count > 0)
                {
                    if (output == "E")
                    {
                        output = "noedit";
                    }

                    if (output == "D")
                    {
                        output = "nodelete";
                    }

                    if (output == "A")
                    {
                        output = "noadd";
                    }

                    return(output);
                }

                eSTP.Datas();
                eSTP.save9("P_PRAREG", param1, param2, param3, param4, param5, param6, param7, param8, param9);

                return(output);
            }
            else
            {
                output = "gagal";
            }
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
            Response.End();
            return(ex.Message);
        }

        return(output);
    }
コード例 #27
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "V":

            var Param1 = Request.Params["param1"].ToString();
            var Param2 = Request.Params["param2"].ToString();
            LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
            eSTP.Datas();
            DataSet ds = new DataSet();
            ds = eSTP.List20("P_PENGTO", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = ds.Tables[0];

            Response.ContentType = "text/plain";
            Response.Write(dt.Rows[0]["pengtoNmrPid"].ToString() + "|");     //0
            Response.Write(dt.Rows[0]["pengtoDatess"].ToString() + "|");     //1
            Response.Write(dt.Rows[0]["registNmrReg"].ToString() + "|");     //2
            Response.Write(dt.Rows[0]["pengtoTgljdw"].ToString() + "|");     //3
            Response.Write(dt.Rows[0]["MidentNamass"].ToString() + "|");     //4
            Response.Write(dt.Rows[0]["MidentIdents"].ToString() + "|");     //5
            Response.Write(dt.Rows[0]["MidentNmrHps"].ToString() + "|");     //6
            Response.Write(dt.Rows[0]["MidentAlamat"].ToString() + "|");     //7
            Response.Write(dt.Rows[0]["registDatess"].ToString() + "|");     //8
            Response.Write(dt.Rows[0]["pengtoKeteks"].ToString() + "|");     //9
            Response.Write(dt.Rows[0]["pengtoEkseps"].ToString() + "|");     //10
            Response.Write(dt.Rows[0]["pengtoTglpen"].ToString() + "|");     //11
            Response.Write(dt.Rows[0]["pengtoToLMss"].ToString() + "|");     //12
            Response.Write(dt.Rows[0]["pengtoToSurv"].ToString() + "|");     //13
            Response.Write(dt.Rows[0]["pengtoAppsur"].ToString() + "|");     //14
            Response.Write(dt.Rows[0]["pengtoAppTss"].ToString() + "|");     //15
            Response.Write(dt.Rows[0]["pengtoDiteri"].ToString() + "|");     //16
            Response.Write(dt.Rows[0]["pengtoKtergn"].ToString() + "|");     //17
            Response.Write(dt.Rows[0]["pengtoLanjut"].ToString() + "|");     //18
            Response.Write(dt.Rows[0]["pengtoOverlp"].ToString() + "|");     //19
            Response.Write(dt.Rows[0]["pengtoIdents"].ToString() + "|");     //20
            dt.Dispose();

            Response.End();
            Response.End();
            return(false);

        //return false;

        case "CRUD":
            Response.ContentType = "text/plain";
            Response.Write(Save());
            Response.End();
            return(false);

        case "ID":
            Response.ContentType = "text/plain";
            Response.Write(SaveDetail());
            Response.End();
            return(false);

        case "df":
            Response.Clear();
            string namafile   = (Request.Params["filelama"] is object?Request.Params["filelama"].ToString() : "");
            String urlfile    = (Request.Params["namafile"] is object?Request.Params["namafile"].ToString() : "");
            String randomfile = (Request.Params["random"] is object?Request.Params["random"].ToString() : "");
            string type       = "";
            switch (namafile.Substring(namafile.Length - 4))
            {
            case ".htm":
            case ".html":
                type = "text/HTML";
                break;

            case ".txt":
                type = "text/plain";
                break;

            case ".doc":
            case ".docx":
            case ".rtf":
                type = "Application/msword";
                break;

            case ".xls":
            case ".xlsx":
                type = "Application/msexcel";
                break;

            case ".zip":
            case ".rar":
                type = "application/zip";
                break;

            case ".pdf":
                type = "application/pdf";
                break;

            case ".jpg":
                type = "image/JPG";
                break;

            case ".pgn":
                type = "image/PNG";
                break;

            case ".tif":
                type = "image/tif";
                break;
            }

            Response.AddHeader("content-disposition", "attachment;filename=" + namafile + "");
            Response.ContentType = type;

            Response.WriteFile(Server.MapPath(@"~/uploaddocument/" + Request.Params["namafile"].ToString().Replace("&amp;", "&")));

            Response.End();
            return(false);

            break;

        case "SavePic":
            Response.ContentType = "text/plain";
            Response.Write(SaveUploadGIFDUMP());
            Response.End();
            return(false);

        case "DOCpic":

            String path_pic = (HttpContext.Current.Request.Url.AbsolutePath).ToLower();

            string IDREGISTRASI = Request.Params["IDREGISTRASI"].ToString();
            string param1       = Request.Params["param1"].ToString();

            LANDCOMP.ExecuteSTP eSTPx = new LANDCOMP.ExecuteSTP();
            eSTPx.Datas();
            DataSet dsx = new DataSet();
            dsx = eSTPx.List20("P_PENGTO", param1, IDREGISTRASI, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = dsx.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");

                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumFiless"].ToString()) + "</cell>");

                Response.Write("<cell>" + "Download^" + path_pic + "?sm=df&amp;namafile=" + dt.Rows[i]["hdocumIdLink"].ToString() + "&amp;filelama=" + dt.Rows[i]["hdocumFiless"].ToString() + "</cell>");
                //Response.Write("<cell>" + "Delete^" + path_pic + "?sm=Deletepic&amp;IDSOURCE=" + dt.Rows[i]["IDSource"].ToString() + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace("Delete^javascript:DeletePic(\"" + dt.Rows[i]["hdocumIdLink"].ToString()) + "\",\"" + IDREGISTRASI + "\");^_self" + "</cell>");

                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdSour"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["hdocumIdLink"].ToString()) + "</cell>");

                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();
            Response.End();


            return(false);

        case "SD":

            var param1SA = Request.Params["param1"].ToString();
            var param2SA = Request.Params["param2"].ToString();

            LANDCOMP.ExecuteSTP eSTP_SA = new LANDCOMP.ExecuteSTP();
            eSTP_SA.Datas();
            DataSet ds_SA = new DataSet();
            ds_SA = eSTP_SA.param7("P_PENGTO_D", param1SA, param2SA, "", "", "", "", "");

            dt = ds_SA.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoNamPlk"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoLuaPlk"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoStatus"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoIdents"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pengtoSequen"].ToString()) + "</cell>");

                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();

            Response.End();

            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }
コード例 #28
0
    public void HakAkses()
    {
        var Param1 = "";

        bool cek = true;

        if (cek && (Request.Params["param1"] is object))
        {
            Param1 = Request.Params["param1"].ToString();
        }
        else
        {
            Param1 = "";
        }

        if (Session["userid"] is object)
        {
            userid = Session["userid"].ToString();

            if (Session["lanjut"] is object)
            {
                lanjut = Session["lanjut"].ToString();
            }

            if (Session["except"] is object)
            {
                except = Session["except"].ToString();
            }
            if (Session["groups"] is object)
            {
                groups = Session["groups"].ToString();
            }
        }

        if (!(Session["userid"] is object))
        {
            Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
            Response.Write("alert('Session sudah habis. Silakan login kembali.');");
            Response.Write("location.href = '../login.aspx';");
            Response.Write("</script>");
        }

        LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
        eSTP.Datas();
        DataSet ds = new DataSet();

        ds = eSTP.List8("P_MENU", "CHA", "", groups, "", "", "", "", "");
        dt = ds.Tables[0];

        PembayaranView   = dt.Rows[7]["Pembayaran"].ToString();       //0
        PembayaranEdit   = dt.Rows[7]["PembayaranEdit"].ToString();   //1
        PembayaranDelete = dt.Rows[7]["PembayaranDelete"].ToString(); //2
        PembayaranAssign = dt.Rows[7]["PembayaranAssign"].ToString(); //3

        dt.Dispose();

        if (Param1 == "")
        {
            Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
            Response.Write("alert('Tidak Ada Aksi Yang Ada Pilih');");
            Response.Write("location.href = 'home.aspx';");
            Response.Write("</script>");
        }

        else if (Param1 == "V")
        {
            if (PembayaranView.ToString() != "1")
            {
                if (groups.ToString() != "1")
                {
                    Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
                    Response.Write("alert('Anda Tidak Memiliki Akses Untuk Melihat Di Modul Ini');");
                    Response.Write("location.href = 'home.aspx';");
                    Response.Write("</script>");
                }
            }
        }

        else if (Param1 == "E")
        {
            if (PembayaranEdit.ToString() != "1")
            {
                if (groups.ToString() != "1")
                {
                    Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
                    Response.Write("alert('Anda Tidak Memiliki Akses Untuk Edit Di Modul Ini');");
                    Response.Write("location.href = 'home.aspx';");
                    Response.Write("</script>");
                }
            }
        }

        else if (Param1.ToString() == "D")
        {
            if (PembayaranDelete.ToString() != "1")
            {
                if (groups.ToString() != "1")
                {
                    Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
                    Response.Write("alert('Anda Tidak Memiliki Akses Untuk Delete Di Modul Ini');");
                    Response.Write("location.href = 'home.aspx';");
                    Response.Write("</script>");
                }
            }
        }

        else
        {
            Response.Write("<script language=\"javascript\" type=\"text/javascript\">");
            Response.Write("alert('Aksi Yang Anda Cari Tidak Ditemukan');");
            Response.Write("location.href = 'home.aspx';");
            Response.Write("</script>");
        }
    }
コード例 #29
0
    private String Save()
    {
        String param1 = ""; if (Request.Params["param1"] is object)
        {
            param1 = Request.Params["param1"].ToString();
        }
        String param2 = ""; if (Request.Params["param2"] is object)
        {
            param2 = Request.Params["param2"].ToString();
        }
        String param3 = ""; if (Request.Params["param3"] is object)
        {
            param3 = Request.Params["param3"].ToString();
        }
        String param4 = ""; if (Request.Params["param4"] is object)
        {
            param4 = Request.Params["param4"].ToString();
        }
        String param5 = ""; if (Request.Params["param5"] is object)
        {
            param5 = Request.Params["param5"].ToString();
        }
        String param6 = ""; if (Request.Params["param6"] is object)
        {
            param6 = Request.Params["param6"].ToString();
        }
        String param7 = ""; if (Request.Params["param7"] is object)
        {
            param7 = Request.Params["param7"].ToString();
        }
        String param8 = ""; if (Request.Params["param8"] is object)
        {
            param8 = Request.Params["param8"].ToString();
        }
        String param9 = ""; if (Request.Params["param9"] is object)
        {
            param8 = Request.Params["param9"].ToString();
        }

        String sql    = "";
        String output = "";

        try
        {
            output = param1;

            if (output == "I" || output == "E" || output == "D")
            {
                LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
                eSTP.Datas();
                DataSet ds = new DataSet();
                eSTP.save9("P_PRAREG", param1, param2, param3, param4, param5, param6, param7, param8, param9);



                return(output);
            }
            else
            {
                output = "gagal";
            }
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
            Response.End();
            return(ex.Message);
        }

        return(output);
    }
コード例 #30
0
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {
        case "E":

            Response.ContentType = "text/plain";
            var param1  = Request.Params["param1"].ToString();
            var param2  = Request.Params["param2"].ToString();
            var param4  = Request.Params["param4"].ToString();
            var param34 = Request.Params["param34"].ToString();
            var param5  = Request.Params["param5"].ToString();
            //var param17 = "hanny"; //session
            var param32 = Session["userid"].ToString();
            LANDCOMP.ExecuteSTP eSTP = new LANDCOMP.ExecuteSTP();
            eSTP.Datas();
            DataSet ds = new DataSet();
            ds = eSTP.List34("P_REGIST", param1, param2, "", param4, param5, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", param32, "", param34);
            Response.End();
            return(false);

        case "L":

            var param1L = Request.Params["param1"].ToString();
            var param2L = Request.Params["param2"].ToString();
            var param4L = Request.Params["param4"].ToString();
            var param5L = Request.Params["param5"].ToString();
            LANDCOMP.ExecuteSTP eSTP_L = new LANDCOMP.ExecuteSTP();
            eSTP_L.Datas();
            DataSet ds_L = new DataSet();
            ds_L = eSTP_L.List34("P_REGIST", param1L, param2L, "", param4L, param5L, "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "");

            dt = ds_L.Tables[0];

            Response.ContentType = "application/xhtml+xml";
            Response.Write("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
            Response.Write("<rows>");
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Random r = new Random();
                Response.Write("<row id=\"" + (i + 1).ToString() + "\">");
                Response.Write("<cell>" + (i + 1).ToString() + "</cell>");     // Untuk Membuat Angka
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registNmrReg"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["penlapNmrPen"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["MidentNamass"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregLokkec"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregLokdes"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["registAssign"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Assign"].ToString()) + "</cell>");
                Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["praregIdents"].ToString()) + "</cell>");
                Response.Write("</row>");
            }
            Response.Write("</rows>");
            dt.Dispose();

            Response.End();
            Response.End();

            return(false);

        default:
            Response.ContentType = "text/plain";
            Response.End();
            return(true);
        }
    }