FrameAppWS

EjecutaQueryRQ

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

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

Namespace Global

    Namespace Administrador.Modelo.DevExtreme

        Public Partial Class gridGroupOptions
            Public Overridable Property selector As String
            Public Overridable Property desc As Boolean
            Public Overridable Property isExpanded As Boolean
        End Class

        Public Partial Class gridSortOptions
            Public Overridable Property selector As String
            Public Overridable Property desc As Boolean
        End Class

        Public Partial Class gridSummaryOptions
            Public Overridable Property selector As String
            Public Overridable Property summaryType As String
        End Class
    End Namespace

    Namespace Administrador.Modelo.Tipos

        Public Partial Class EjecutaQueryRQ
            Public Sub New()
                Parametros = New Dictionary(Of String, Object)
                Filter = New List(Of Object)
                SummaryGroupItems = New gridSummaryOptions(){}
                SummaryTotalItems = New gridSummaryOptions(){}
            End Sub

            Public Overridable Property IDVista As Integer
            Public Overridable Property DatosDetalles As Boolean
            Public Overridable Property Parametros As Dictionary(Of String, Object)
            Public Overridable Property Lenguaje As Lenguajes
            Public Overridable Property RecordSkip As Integer
            Public Overridable Property RecordTake As Integer
            Public Overridable Property Filter As List(Of Object)
            Public Overridable Property Sort As gridSortOptions
            Public Overridable Property Group As gridGroupOptions
            Public Overridable Property SummaryGroupItems As gridSummaryOptions()
            Public Overridable Property SummaryTotalItems As gridSummaryOptions()
            Public Overridable Property omitirPaginacion As Boolean
            Public Overridable Property multiEmpresaSel As Boolean
        End Class

        Public Partial Class EjecutaQueryRS
            Public Sub New()
                DatosConsulta = New List(Of Dictionary(Of String,Object))
                SummaryList = New List(Of Object)
            End Sub

            Public Overridable Property DatosConsulta As List(Of Dictionary(Of String,Object))
            Public Overridable Property TotalRegistros As Integer
            Public Overridable Property TotalGrupos As Integer
            Public Overridable Property SummaryList As List(Of Object)
        End Class

        Public Enum Lenguajes
            ES
            PT
            EN
        End Enum
    End Namespace
End Namespace

VB.NET EjecutaQueryRQ DTOs

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

HTTP + JSV

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: text/jsv
Content-Type: text/jsv
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: text/jsv
Content-Length: length

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