//
//====================================================================================================
/// <summary>
/// getFieldEditorPreference remote method
/// </summary>
/// <param name="cp"></param>
/// <returns></returns>
public override object Execute(Contensive.BaseClasses.CPBaseClass cp)
{
string result = "";
try {
CoreController core = ((CPClass)cp).core;
string ArgList = core.docProperties.getText("args");
string[] Args = ArgList.Split('&');
GoogleDataType gd = new GoogleDataType();
gd.IsEmpty = true;
for (var Ptr = 0; Ptr <= Args.GetUpperBound(0); Ptr++)
{
string[] ArgNameValue = Args[Ptr].Split('=');
string PropertyName = ArgNameValue[0];
string PropertyValue = "";
if (ArgNameValue.GetUpperBound(0) > 0)
{
PropertyValue = ArgNameValue[1];
}
core.visitProperty.setProperty(PropertyName, PropertyValue);
}
result = RemoteQueryController.format(core, gd, RemoteQueryController.RemoteFormatEnum.RemoteFormatJsonNameValue);
result = HtmlController.encodeHtml(result);
} catch (Exception ex) {
cp.Site.ErrorReport(ex);
}
return(result);
}
//
//
//
public static string format(CoreController core, GoogleDataType gd, RemoteFormatEnum RemoteFormat)
{
//
StringBuilderLegacyController s = null;
string ColDelim = null;
string RowDelim = null;
int ColPtr = 0;
int RowPtr = 0;
//
// Select output format
//
s = new StringBuilderLegacyController();
switch (RemoteFormat)
{
case RemoteFormatEnum.RemoteFormatJsonNameValue:
//
//
//
s.add("{");
if (!gd.IsEmpty)
{
ColDelim = "";
for (ColPtr = 0; ColPtr <= gd.col.Count; ColPtr++)
{
s.add(ColDelim + gd.col[ColPtr].Id + ":'" + gd.row[0].Cell[ColPtr].v + "'");
ColDelim = ",";
}
}
s.add("}");
break;
case RemoteFormatEnum.RemoteFormatJsonNameArray:
//
//
//
s.add("{");
if (!gd.IsEmpty)
{
ColDelim = "";
for (ColPtr = 0; ColPtr <= gd.col.Count; ColPtr++)
{
s.add(ColDelim + gd.col[ColPtr].Id + ":[");
ColDelim = ",";
RowDelim = "";
for (RowPtr = 0; RowPtr <= gd.row.Count; RowPtr++)
{
var tempVar = gd.row[RowPtr].Cell[ColPtr];
s.add(RowDelim + "'" + tempVar.v + "'");
RowDelim = ",";
}
s.add("]");
}
}
s.add("}");
break;
case RemoteFormatEnum.RemoteFormatJsonTable:
//
//
//
s.add("{");
if (!gd.IsEmpty)
{
s.add("cols: [");
ColDelim = "";
for (ColPtr = 0; ColPtr <= gd.col.Count; ColPtr++)
{
var tempVar2 = gd.col[ColPtr];
s.add(ColDelim + "{id: '" + GenericController.encodeJavascriptStringSingleQuote(tempVar2.Id) + "', label: '" + GenericController.encodeJavascriptStringSingleQuote(tempVar2.Label) + "', type: '" + GenericController.encodeJavascriptStringSingleQuote(tempVar2.Type) + "'}");
ColDelim = ",";
}
s.add("],rows:[");
RowDelim = "";
for (RowPtr = 0; RowPtr <= gd.row.Count; RowPtr++)
{
s.add(RowDelim + "{c:[");
RowDelim = ",";
ColDelim = "";
for (ColPtr = 0; ColPtr <= gd.col.Count; ColPtr++)
{
var tempVar3 = gd.row[RowPtr].Cell[ColPtr];
s.add(ColDelim + "{v: '" + GenericController.encodeJavascriptStringSingleQuote(tempVar3.v) + "'}");
ColDelim = ",";
}
s.add("]}");
}
s.add("]");
}
s.add("}");
break;
}
return(s.text);
//
}
