POST api/Report/Business/Summary/QueryV_RPT_SPNNTQDB

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

Request Information

URI Parameters

None.

Body Parameters

Name	Description	Type	Additional 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": "f7869793-4567-41ab-8c9d-f36f837e8be1",
  "JMDM": 1,
  "YQID": "8cad53e2-811a-47d5-bae6-1d03893bfe51",
  "PCMC": "sample string 6",
  "PCID": "cb4f659e-02ea-4767-ae69-427417a7e616",
  "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": "400b02b4-e2ae-401d-838c-9cc12667e499",
  "DJSID": "a93a2e87-cb40-4f4f-9d33-abfef82f66f3",
  "DJSBMID": "2f1453c9-3833-49a6-9304-505cbe3f1314",
  "ZTSID": "2244c627-dde5-475e-849f-fc2d38b062e2",
  "ZTSBMID": "67ae06f3-7b5b-43f5-9529-5a125baea0a3",
  "XYDWID": "081cfefd-88a8-4c43-9db5-2a0863abccc5",
  "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>2f1453c9-3833-49a6-9304-505cbe3f1314</DJSBMID>
  <DJSFZID>400b02b4-e2ae-401d-838c-9cc12667e499</DJSFZID>
  <DJSID>a93a2e87-cb40-4f4f-9d33-abfef82f66f3</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>081cfefd-88a8-4c43-9db5-2a0863abccc5</XYDWID>
  <YHDLM>sample string 23</YHDLM>
  <ZTSBMID>67ae06f3-7b5b-43f5-9529-5a125baea0a3</ZTSBMID>
  <ZTSID>2244c627-dde5-475e-849f-fc2d38b062e2</ZTSID>
  <ISJQ>sample string 8</ISJQ>
  <JMDM>1</JMDM>
  <MPLXID>f7869793-4567-41ab-8c9d-f36f837e8be1</MPLXID>
  <PCID>cb4f659e-02ea-4767-ae69-427417a7e616</PCID>
  <PCMC>sample string 6</PCMC>
  <SPZD>sample string 10</SPZD>
  <SYSID>sample string 11</SYSID>
  <TJNR>sample string 9</TJNR>
  <YQID>8cad53e2-811a-47d5-bae6-1d03893bfe51</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

Name	Description	Type	Additional 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.