POST api/Report/Business/Summary/QueryV_RPT_SPNNTQDB

查询门票销售历年同期对比表的api

Request Information

URI Parameters

None.

Body Parameters

Rpt_BusinessSummaryParm
NameDescriptionTypeAdditional information
FLAG

@VAR_FLAG char(1),/*是否启用价格区间查询 1表示启用*/

string

Max length: 1

JG1

@VAR_JG1 decimal(18,2),/*价格区间1*/

decimal number

None.

JG2

@VAR_JG2 decimal(18,2)/*价格区间2*/

decimal number

None.

MPLXID

门票类型id GUID类型

globally unique identifier

None.

JMDM

@VAR_JMDM bigint, 剧目代码

integer

None.

YQID

@VAR_YQID UNIQUEIDENTIFIER,园区ID

globally unique identifier

None.

PCMC

@VAR_PCMC nvarchar(64) 场次名称

string

Max length: 64

PCID

@VAR_PCID uniqueidentifier,场次ID

globally unique identifier

None.

ISJQ

@VAR_ISJQ char(1),是否是景区统计 1表示景区,其他值表示演艺系统

string

Max length: 1

TJNR

@VAR_TJNR char(1)1仅统计数量,2仅统计金额,其他值,全部统计

string

Max length: 1

SPZD

@VAR_SPZD char(2),售票站点

string

Max length: 2

SYSID

@VAR_SYSID char(1)/*1-仅检索团队购票 2-仅检索散客购票 0或空,检索上序两种购票*/

string

Max length: 1

DayType

string

Max length: 1

StartDate

string

Required

Max length: 8

EndDate

string

Required

Max length: 8

DJSFZID

globally unique identifier

None.

DJSID

globally unique identifier

None.

DJSBMID

globally unique identifier

None.

ZTSID

globally unique identifier

None.

ZTSBMID

globally unique identifier

None.

XYDWID

globally unique identifier

None.

SPDH

string

Max length: 20

LBSBH

string

Max length: 32

YHDLM

string

Max length: 20

DYZH

string

Max length: 20

JYLY

string

Max length: 1

XFFAID

string

Max length: 6

FKFSID

string

Max length: 2

MPLXList

string

Max length: 2000

SPZDList

string

Max length: 2000

Request Formats

application/json, text/json

Sample:
{
  "FLAG": "sample string 1",
  "JG1": 2.0,
  "JG2": 3.0,
  "MPLXID": "a69f4a6c-a6d4-4a28-b1e9-418df2b1ad1e",
  "JMDM": 1,
  "YQID": "a10abf37-3f64-4263-aee7-244c3b860d9e",
  "PCMC": "sample string 6",
  "PCID": "7b0261ae-926b-4625-a879-c4336e7b849f",
  "ISJQ": "sample string 8",
  "TJNR": "sample string 9",
  "SPZD": "sample string 10",
  "SYSID": "sample string 11",
  "DayType": "sample string 12",
  "StartDate": "sample string 13",
  "EndDate": "sample string 14",
  "DJSFZID": "f7cbec39-6098-40cd-a2b5-cc6181ff4297",
  "DJSID": "8f71c1d1-7415-48d9-97bf-f982f60a3806",
  "DJSBMID": "3ef24004-492c-4350-b624-8eb94d1f24ee",
  "ZTSID": "f0d0cd6d-9904-49a9-93db-9fd40da90fe8",
  "ZTSBMID": "011be742-b8c3-4b2c-954a-57346c8dc6e4",
  "XYDWID": "233071bb-24b9-4d45-88d9-3b5ac6711200",
  "SPDH": "sample string 21",
  "LBSBH": "sample string 22",
  "YHDLM": "sample string 23",
  "DYZH": "sample string 24",
  "JYLY": "sample string 25",
  "XFFAID": "sample string 26",
  "FKFSID": "sample string 27",
  "MPLXList": "sample string 28",
  "SPZDList": "sample string 29"
}

application/xml, text/xml

Sample:
<Rpt_BusinessSummaryParm xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DigitalScience.DataTransfer.Tour.V5.Parm.Report">
  <DJSBMID>3ef24004-492c-4350-b624-8eb94d1f24ee</DJSBMID>
  <DJSFZID>f7cbec39-6098-40cd-a2b5-cc6181ff4297</DJSFZID>
  <DJSID>8f71c1d1-7415-48d9-97bf-f982f60a3806</DJSID>
  <DYZH>sample string 24</DYZH>
  <DayType>sample string 12</DayType>
  <EndDate>sample string 14</EndDate>
  <FKFSID>sample string 27</FKFSID>
  <JYLY>sample string 25</JYLY>
  <LBSBH>sample string 22</LBSBH>
  <MPLXList>sample string 28</MPLXList>
  <SPDH>sample string 21</SPDH>
  <SPZDList>sample string 29</SPZDList>
  <StartDate>sample string 13</StartDate>
  <XFFAID>sample string 26</XFFAID>
  <XYDWID>233071bb-24b9-4d45-88d9-3b5ac6711200</XYDWID>
  <YHDLM>sample string 23</YHDLM>
  <ZTSBMID>011be742-b8c3-4b2c-954a-57346c8dc6e4</ZTSBMID>
  <ZTSID>f0d0cd6d-9904-49a9-93db-9fd40da90fe8</ZTSID>
  <ISJQ>sample string 8</ISJQ>
  <JMDM>1</JMDM>
  <MPLXID>a69f4a6c-a6d4-4a28-b1e9-418df2b1ad1e</MPLXID>
  <PCID>7b0261ae-926b-4625-a879-c4336e7b849f</PCID>
  <PCMC>sample string 6</PCMC>
  <SPZD>sample string 10</SPZD>
  <SYSID>sample string 11</SYSID>
  <TJNR>sample string 9</TJNR>
  <YQID>a10abf37-3f64-4263-aee7-244c3b860d9e</YQID>
  <FLAG>sample string 1</FLAG>
  <JG1>2</JG1>
  <JG2>3</JG2>
</Rpt_BusinessSummaryParm>

application/x-www-form-urlencoded

Sample:

Sample not available.

application/bson

Sample:
Binary JSON content. See http://bsonspec.org for details.

Response Information

Resource Description

查询门票销售历年同期对比表的api

ComplexParm
NameDescriptionTypeAdditional information
Zipped

读取或设置一个值,指示当前缓冲区是否经过了压缩

boolean

None.

Buffer

读取或设置一个值,指明当前缓冲区的内容

Collection of byte

None.

Response Formats

application/json, text/json

Sample:
{
  "Zipped": true,
  "Buffer": "QEA="
}

application/xml, text/xml

Sample:
<ComplexParm xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DigitalScience.DataTransfer">
  <Buffer>QEA=</Buffer>
  <Zipped>true</Zipped>
</ComplexParm>

application/bson

Sample:
Binary JSON content. See http://bsonspec.org for details.