FrameAppWS

<back to all web services

EjecutaQueryBackRQ

Requires Authentication
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 .xml suffix or ?format=xml

HTTP + XML

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: application/xml
Content-Type: application/xml
Content-Length: length

<EjecutaQueryBackRQ xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <DatosDetalles>false</DatosDetalles>
  <Filter xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:anyType />
  </Filter>
  <Group xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:desc>false</d2p1:desc>
    <d2p1:isExpanded>false</d2p1:isExpanded>
    <d2p1:selector>String</d2p1:selector>
  </Group>
  <IDVista>0</IDVista>
  <Lenguaje>ES</Lenguaje>
  <Parametros xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringanyType>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value />
    </d2p1:KeyValueOfstringanyType>
  </Parametros>
  <RecordSkip>0</RecordSkip>
  <RecordTake>0</RecordTake>
  <Sort xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:desc>false</d2p1:desc>
    <d2p1:selector>String</d2p1:selector>
  </Sort>
  <SummaryGroupItems xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:gridSummaryOptions>
      <d2p1:selector>String</d2p1:selector>
      <d2p1:summaryType>String</d2p1:summaryType>
    </d2p1:gridSummaryOptions>
  </SummaryGroupItems>
  <SummaryTotalItems xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:gridSummaryOptions>
      <d2p1:selector>String</d2p1:selector>
      <d2p1:summaryType>String</d2p1:summaryType>
    </d2p1:gridSummaryOptions>
  </SummaryTotalItems>
</EjecutaQueryBackRQ>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<EjecutaQueryBackgroundRS xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <AppAdm>false</AppAdm>
  <Empresa>0</Empresa>
  <Error>String</Error>
  <Login>String</Login>
  <Sistema>0</Sistema>
  <Success>false</Success>
  <TxtSQL>String</TxtSQL>
  <URLArchivo>String</URLArchivo>
</EjecutaQueryBackgroundRS>