POST api/Report/DJS/QueryV_RPT_YQ_DJSYDDB
获取地接社购票月度对比表(2)的api,以复杂类型返回数据(CommonOperationResultWithTag(V_RPT_YQ_DJSYDDBDataTable))。
Request Information
URI Parameters
None.
Body Parameters
Rpt_DJS_BuyTicketParm| Name | Description | Type | Additional information |
|---|---|---|---|
| MPLXID1 |
单选的门票类型ID |
string |
Max length: 36 |
| ISALL |
@ISALL CHAR(1),/*是否查询全部数据(1-查询所有 0-仅查询旅行社数据(即不查询其他的数据)) |
string |
Max length: 1 |
| Top20 |
@Top20 char(1) /*是否只显示前20名*/ |
string |
Max length: 1 |
| XZQHDMp |
@VAR_XZQHDM varchar(6),/*行政区划代码*/ |
string |
Max length: 6 |
| GPXZ |
@VAR_GPXZ char(1),/*购票人性质 '0' 只含旅行社部门导游组团组团部门 '1' 只含散客 其他值全包括*/ |
string |
Max length: 1 |
| SCQHDM |
@VAR_SCQHDM char(2),/*一级市场区划代码*/ |
string |
Max length: 8 |
| TJFW |
@TJFW char(1)统计范围1营业类,2返款类,A营业类+返款类 |
string |
Max length: 1 |
| 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
{
"MPLXID1": "sample string 1",
"ISALL": "sample string 2",
"Top20": "sample string 3",
"XZQHDMp": "sample string 4",
"GPXZ": "sample string 5",
"SCQHDM": "sample string 6",
"TJFW": "sample string 7",
"FLAG": "sample string 8",
"JG1": 9.0,
"JG2": 10.0,
"MPLXID": "482d4856-cdcc-44dd-b0cc-82065107169e",
"JMDM": 1,
"YQID": "877181e4-cd5a-4369-b863-238bf146bdfa",
"PCMC": "sample string 13",
"PCID": "aa9b2800-60e6-48d1-8bb0-768c5f61c337",
"ISJQ": "sample string 15",
"TJNR": "sample string 16",
"SPZD": "sample string 17",
"SYSID": "sample string 18",
"DayType": "sample string 19",
"StartDate": "sample string 20",
"EndDate": "sample string 21",
"DJSFZID": "64ea8e6b-9279-4032-afcd-bf1e23bf36d3",
"DJSID": "532d39de-e4dc-42a6-a3e6-de92800685c7",
"DJSBMID": "cb0929a5-9921-4bdf-bc18-ddd575552eb5",
"ZTSID": "1d46f679-ad45-4abd-90d8-e54130a87e49",
"ZTSBMID": "a1e3af7c-be1b-444a-9a59-579ef7b93471",
"XYDWID": "15f4564e-ea67-435e-9934-c7d7076b50b3",
"SPDH": "sample string 28",
"LBSBH": "sample string 29",
"YHDLM": "sample string 30",
"DYZH": "sample string 31",
"JYLY": "sample string 32",
"XFFAID": "sample string 33",
"FKFSID": "sample string 34",
"MPLXList": "sample string 35",
"SPZDList": "sample string 36"
}
application/xml, text/xml
<Rpt_DJS_BuyTicketParm xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DigitalScience.DataTransfer.Tour.V5.Parm.Report"> <DJSBMID>cb0929a5-9921-4bdf-bc18-ddd575552eb5</DJSBMID> <DJSFZID>64ea8e6b-9279-4032-afcd-bf1e23bf36d3</DJSFZID> <DJSID>532d39de-e4dc-42a6-a3e6-de92800685c7</DJSID> <DYZH>sample string 31</DYZH> <DayType>sample string 19</DayType> <EndDate>sample string 21</EndDate> <FKFSID>sample string 34</FKFSID> <JYLY>sample string 32</JYLY> <LBSBH>sample string 29</LBSBH> <MPLXList>sample string 35</MPLXList> <SPDH>sample string 28</SPDH> <SPZDList>sample string 36</SPZDList> <StartDate>sample string 20</StartDate> <XFFAID>sample string 33</XFFAID> <XYDWID>15f4564e-ea67-435e-9934-c7d7076b50b3</XYDWID> <YHDLM>sample string 30</YHDLM> <ZTSBMID>a1e3af7c-be1b-444a-9a59-579ef7b93471</ZTSBMID> <ZTSID>1d46f679-ad45-4abd-90d8-e54130a87e49</ZTSID> <ISJQ>sample string 15</ISJQ> <JMDM>1</JMDM> <MPLXID>482d4856-cdcc-44dd-b0cc-82065107169e</MPLXID> <PCID>aa9b2800-60e6-48d1-8bb0-768c5f61c337</PCID> <PCMC>sample string 13</PCMC> <SPZD>sample string 17</SPZD> <SYSID>sample string 18</SYSID> <TJNR>sample string 16</TJNR> <YQID>877181e4-cd5a-4369-b863-238bf146bdfa</YQID> <FLAG>sample string 8</FLAG> <JG1>9</JG1> <JG2>10</JG2> <GPXZ>sample string 5</GPXZ> <ISALL>sample string 2</ISALL> <MPLXID1>sample string 1</MPLXID1> <SCQHDM>sample string 6</SCQHDM> <TJFW>sample string 7</TJFW> <Top20>sample string 3</Top20> <XZQHDMp>sample string 4</XZQHDMp> </Rpt_DJS_BuyTicketParm>
application/x-www-form-urlencoded
Sample not available.
application/bson
Binary JSON content. See http://bsonspec.org for details.
Response Information
Resource Description
获取地接社购票月度对比表(2)的api,以复杂类型返回数据(CommonOperationResultWithTag(V_RPT_YQ_DJSYDDBDataTable))。
ComplexParm| Name | Description | Type | Additional information |
|---|---|---|---|
| Zipped |
读取或设置一个值,指示当前缓冲区是否经过了压缩 |
boolean |
None. |
| Buffer |
读取或设置一个值,指明当前缓冲区的内容 |
Collection of byte |
None. |
Response Formats
application/json, text/json
{
"Zipped": true,
"Buffer": "QEA="
}
application/xml, text/xml
<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
Binary JSON content. See http://bsonspec.org for details.