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() + "¶m1=V" + "¶m2=" + dt.Rows[i]["ClausrNmrClm"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Edit^KlaimUserForm.aspx?rand=" + r.Next() + "¶m1=E" + "¶m2=" + dt.Rows[i]["ClausrNmrClm"].ToString() + "") + "</cell>"); Response.Write("<cell>" + RemoveWhiteSpace("Delete^KlaimUserForm.aspx?rand=" + r.Next() + "¶m1=D" + "¶m2=" + 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; } }
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; } }