FrameAppWS

EjecutaQueryRQ

The following routes are available for this service:
All Verbs	/Utilidades/Consultas/Listados/Ejecucion

using System;
using System.Collections;
using System.Collections.Generic;
using System.Runtime.Serialization;
using ServiceStack;
using ServiceStack.DataAnnotations;
using Administrador.Modelo.Tipos;
using Administrador.Modelo.DevExtreme;

namespace Administrador.Modelo.DevExtreme
{
    public partial class gridGroupOptions
    {
        public virtual string selector { get; set; }
        public virtual bool desc { get; set; }
        public virtual bool isExpanded { get; set; }
    }

    public partial class gridSortOptions
    {
        public virtual string selector { get; set; }
        public virtual bool desc { get; set; }
    }

    public partial class gridSummaryOptions
    {
        public virtual string selector { get; set; }
        public virtual string summaryType { get; set; }
    }

}

namespace Administrador.Modelo.Tipos
{
    public partial class EjecutaQueryRQ
    {
        public EjecutaQueryRQ()
        {
            Parametros = new Dictionary<string, Object>{};
            Filter = new List<Object>{};
            SummaryGroupItems = new gridSummaryOptions[]{};
            SummaryTotalItems = new gridSummaryOptions[]{};
        }

        public virtual int IDVista { get; set; }
        public virtual bool DatosDetalles { get; set; }
        public virtual Dictionary<string, Object> Parametros { get; set; }
        public virtual Lenguajes Lenguaje { get; set; }
        public virtual int RecordSkip { get; set; }
        public virtual int RecordTake { get; set; }
        public virtual List<Object> Filter { get; set; }
        public virtual gridSortOptions Sort { get; set; }
        public virtual gridGroupOptions Group { get; set; }
        public virtual gridSummaryOptions[] SummaryGroupItems { get; set; }
        public virtual gridSummaryOptions[] SummaryTotalItems { get; set; }
        public virtual bool omitirPaginacion { get; set; }
        public virtual bool multiEmpresaSel { get; set; }
    }

    public partial class EjecutaQueryRS
    {
        public EjecutaQueryRS()
        {
            DatosConsulta = new List<Dictionary<String,Object>>{};
            SummaryList = new List<Object>{};
        }

        public virtual List<Dictionary<String,Object>> DatosConsulta { get; set; }
        public virtual int TotalRegistros { get; set; }
        public virtual int TotalGrupos { get; set; }
        public virtual List<Object> SummaryList { get; set; }
    }

    public enum Lenguajes
    {
        ES,
        PT,
        EN,
    }

}

C# EjecutaQueryRQ DTOs

To override the Content-type in your clients, use the HTTP Accept Header, append the .json suffix or ?format=json

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /Utilidades/Consultas/Listados/Ejecucion HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"IDVista":0,"DatosDetalles":false,"Parametros":{"String":{}},"Lenguaje":"ES","RecordSkip":0,"RecordTake":0,"Filter":[{}],"Sort":{"selector":"String","desc":false},"Group":{"selector":"String","desc":false,"isExpanded":false},"SummaryGroupItems":[{"selector":"String","summaryType":"String"}],"SummaryTotalItems":[{"selector":"String","summaryType":"String"}],"omitirPaginacion":false,"multiEmpresaSel":false}

HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"DatosConsulta":[{"String":{}}],"TotalRegistros":0,"TotalGrupos":0,"SummaryList":[{}]}