FrameAppWS

EjecutaQueryBackRQ

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

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 EjecutaQueryBackgroundRS
    {
        public virtual decimal Empresa { get; set; }
        public virtual decimal Sistema { get; set; }
        public virtual string Login { get; set; }
        public virtual bool AppAdm { get; set; }
        public virtual string TxtSQL { get; set; }
        public virtual string URLArchivo { get; set; }
        public virtual bool Success { get; set; }
        public virtual string Error { get; set; }
    }

    public partial class EjecutaQueryBackRQ
    {
        public EjecutaQueryBackRQ()
        {
            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 enum Lenguajes
    {
        ES,
        PT,
        EN,
    }

}

C# EjecutaQueryBackRQ DTOs

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

HTTP + CSV

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

POST /Utilidades/Consultas/Listados/EjecucionBackground HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: text/csv
Content-Type: text/csv
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"}]}

HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"Empresa":0,"Sistema":0,"Login":"String","AppAdm":false,"TxtSQL":"String","URLArchivo":"String","Success":false,"Error":"String"}