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();
                ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP();
                eSTP_L.Datas();
                DataSet ds_L = new DataSet();
                ds_L = eSTP_L.List14("P_CLAUSR", 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]["ClausrNmrClm"].ToString()) + "</cell>");
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrNamass"].ToString()) + "</cell>");
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrLokKab"].ToString()) + "</cell>");
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrLokKec"].ToString()) + "</cell>");
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrLokDes"].ToString()) + "</cell>");

                    if (dt.Rows[i]["ClausrNmrClm"].ToString() != "")
                    {

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

                    }

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

                Response.End();

                return false;

            default:
                Response.ContentType = "text/plain";
                Response.End();
                return true;
        }
    }
示例#2
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();
                var param9L = Request.Params["param9"].ToString();
                ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP();
                eSTP_L.Datas();
                DataSet ds_L = new DataSet();
                ds_L = eSTP_L.List14("P_LEGALL", param1L, param2L, "", param4L, param5L, "", userid, "", param9L, "", "", "", "", "");

                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]["LegallNmrLeg"].ToString()) + "</cell>"); //1
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["VerdokNmrVrd"].ToString()) + "</cell>"); //2
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrNmrClm"].ToString()) + "</cell>"); //3
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrNmrIdn"].ToString()) + "</cell>"); //4
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrNamass"].ToString()) + "</cell>"); //5
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["ClausrLokDes"].ToString()) + "</cell>"); //6
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["perusaNamass"].ToString()) + "</cell>"); //7
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["LegallAssign"].ToString()) + "</cell>"); //8
                    Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["Assign"].ToString()) + "</cell>"); //9

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

                Response.End();

                return false;

            case "A":

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

                ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP();
                eSTP.Datas();
                DataSet ds = new DataSet();
                eSTP.save14("P_LEGALL", param1, param2, "", param4, "", "", userid, "", param9, "", "", param12, "", "");
                Response.End();
                return false;

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

            default:
                Response.ContentType = "text/plain";
                Response.End();
                return true;
        }
    }
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {

            case "L":

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

                ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP();
                eSTP_L.Datas();
                DataSet ds_L = new DataSet();
                ds_L = eSTP_L.List14("P_COMPLA", 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]["namexx"].ToString()) + "</cell>");

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

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

                return false;

            case "E":

                Response.ContentType = "text/plain";
                var param1 = Request.Params["param1"].ToString();
                var param2 = Request.Params["param2"].ToString();
                var param3 = Request.Params["param3"].ToString();
                var param4 = Request.Params["param4"].ToString();

                ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP();
                eSTP.Datas();
                DataSet ds = new DataSet();
                eSTP.save4("almisgis.SDE.p_ULANDCMP", param1, param2, param3, param4);
                Response.End();
                return false;

            default:
                Response.ContentType = "text/plain";
                Response.End();
                return true;
        }
    }
    private bool ServiceSelect(string sm)
    {
        switch (sm)
        {

            case "V":

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

                ALMIS.ExecuteSTP eSTP = new ALMIS.ExecuteSTP();
                eSTP.Datas();
                DataSet ds = new DataSet();
                ds = eSTP.List14("P_COMPLA", Param1, Param2, "", "", "", "", "", "", "", "", "", "", "", "");

                dt = ds.Tables[0];

                Response.ContentType = "text/plain";

                Response.Write(dt.Rows[0]["complaNmrCom"].ToString() + "|"); //0
                Response.Write(dt.Rows[0]["complaDatess"].ToString() + "|"); //1
                Response.Write(dt.Rows[0]["complaJnsPrj"].ToString() + "|"); //2
                Response.Write(dt.Rows[0]["complaIdProj"].ToString() + "|"); //3
                Response.Write(dt.Rows[0]["complaIdPicx"].ToString() + "|"); //4
                Response.Write(dt.Rows[0]["complaIdAnal"].ToString() + "|"); //5
                Response.Write(dt.Rows[0]["complaStDate"].ToString() + "|"); //6
                Response.Write(dt.Rows[0]["complaInterv"].ToString() + "|"); //7
                Response.Write(dt.Rows[0]["complaEnDate"].ToString() + "|"); //8
                Response.Write(dt.Rows[0]["complakodper"].ToString() + "|"); //9
                Response.Write(dt.Rows[0]["complaNamaPicx"].ToString() + "|"); //10
                Response.Write(dt.Rows[0]["complaNamaAnal"].ToString() + "|"); //11

                dt.Dispose();

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

            case "LNP":

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

                ALMIS.ExecuteSTP eSTP_Ln = new ALMIS.ExecuteSTP();
                eSTP_Ln.Datas();
                DataSet ds_Ln = new DataSet();
                ds_Ln = eSTP_Ln.List14("P_COMPLA", param1Ln, param2Ln, "", "", "", "", "", "", "", "", "", "", "", "");

                dt = ds_Ln.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]["namexx"].ToString()) + "</cell>");

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

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

                return false;

            case "L":

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

                ALMIS.ExecuteSTP eSTP_L = new ALMIS.ExecuteSTP();
                eSTP_L.Datas();
                DataSet ds_L = new DataSet();
                ds_L = eSTP_L.List14("P_COMPLA", 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("</row>");
                }
                Response.Write("</rows>");
                dt.Dispose();

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

                return false;

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

            case "cekRepeat":

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

                ALMIS.ExecuteSTP eSTPr = new ALMIS.ExecuteSTP();
                eSTPr.Datas();
                DataSet dsr = new DataSet();
                dsr = eSTPr.List14("P_COMPLA", Param1r, Param2r, "", "", "", "", "", "", "", "", "", "", "", "");

                dt = dsr.Tables[0];

                Response.ContentType = "text/plain";

                Response.Write(dt.Rows[0]["jenkeg"].ToString() + "|"); //0
                Response.Write(dt.Rows[0]["dskrps"].ToString() + "|"); //1
                Response.Write(dt.Rows[0]["kntktr"].ToString() + "|"); //2

                Response.Write(dt.Rows[0]["wiladm"].ToString() + "|"); //3
                Response.Write(dt.Rows[0]["luasha"].ToString() + "|"); //4
                Response.Write(dt.Rows[0]["PIDxxx"].ToString() + "|"); //5

                Response.Write(dt.Rows[0]["pkp2bx"].ToString() + "|"); //6
                Response.Write(dt.Rows[0]["mouxxx"].ToString() + "|"); //7
                Response.Write(dt.Rows[0]["reklam"].ToString() + "|"); //8

                Response.Write(dt.Rows[0]["htnlnd"].ToString() + "|"); //9
                Response.Write(dt.Rows[0]["htnptb"].ToString() + "|"); //10
                Response.Write(dt.Rows[0]["htnptp"].ToString() + "|"); //11
                Response.Write(dt.Rows[0]["htnpdd"].ToString() + "|"); //12
                Response.Write(dt.Rows[0]["htndlr"].ToString() + "|"); //13

                Response.Write(dt.Rows[0]["ippkh1"].ToString() + "|"); //14
                Response.Write(dt.Rows[0]["ippkh2"].ToString() + "|"); //15
                Response.Write(dt.Rows[0]["ippkh3"].ToString() + "|"); //16
                Response.Write(dt.Rows[0]["ippkh4"].ToString() + "|"); //17
                Response.Write(dt.Rows[0]["ippkhl"].ToString() + "|"); //18

                Response.Write(dt.Rows[0]["izinl1"].ToString() + "|"); //19
                Response.Write(dt.Rows[0]["izinl2"].ToString() + "|"); //20
                Response.Write(dt.Rows[0]["izinl3"].ToString() + "|"); //21
                Response.Write(dt.Rows[0]["izinl4"].ToString() + "|"); //22
                Response.Write(dt.Rows[0]["izinl5"].ToString() + "|"); //23

                Response.Write(dt.Rows[0]["dumpi"].ToString() + "|"); //24
                Response.Write(dt.Rows[0]["irekla"].ToString() + "|"); //25
                Response.Write(dt.Rows[0]["pentaa"].ToString() + "|"); //26
                Response.Write(dt.Rows[0]["manfaa"].ToString() + "|"); //27
                Response.Write(dt.Rows[0]["imbxxx"].ToString() + "|"); //28

                Response.Write(dt.Rows[0]["hgu1xx"].ToString() + "|"); //29
                Response.Write(dt.Rows[0]["hgu2xx"].ToString() + "|"); //30
                Response.Write(dt.Rows[0]["hgu3xx"].ToString() + "|"); //31
                Response.Write(dt.Rows[0]["hgu4xx"].ToString() + "|"); //32
                Response.Write(dt.Rows[0]["hgu5xx"].ToString() + "|"); //33
                Response.Write(dt.Rows[0]["hgulua"].ToString() + "|"); //34
                Response.Write(dt.Rows[0]["iup1xx"].ToString() + "|"); //35

                Response.Write(dt.Rows[0]["jenase"].ToString() + "|"); //36
                Response.Write(dt.Rows[0]["staase"].ToString() + "|"); //37
                Response.Write(dt.Rows[0]["pemanf"].ToString() + "|"); //38

                Response.Write(dt.Rows[0]["btbara"].ToString() + "|"); //39
                Response.Write(dt.Rows[0]["hptxxx"].ToString() + "|"); //40
                Response.Write(dt.Rows[0]["pemuki"].ToString() + "|"); //41
                Response.Write(dt.Rows[0]["indust"].ToString() + "|"); //42

                dt.Dispose();

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

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