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, "");
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;
}
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;
}
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]["pengtoNmrPid"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["negosiNmrNeg"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["visumsNovism"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks1NmrBr1"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["pmbyrnNmrByr"].ToString()) + "</cell>");
Response.Write("<cell>" + RemoveWhiteSpace(dt.Rows[i]["berks2NmrBr2"].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;
}
}