POST api/Report/DJSBM/QueryV_RPT_DJSBM_TDLX_MPZL_HZ
查询地接社部门购票分游客类型（团队类型）-票型汇总表，以复杂参数类型返回(CommonOperationResultWithTag(V_RPT_DJSBM_TDLX_MPZL_HZ))
Request Information
URI Parameters
None.
Body Parameters
Rpt_DJS_TicketSaleParm| 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 |
| VAR_HasInsurance |
统计结果中是否包含保险数据。 |
string |
Max length: 1 |
| DayType |
@DayType char(1),1交易日期，2门票日期 |
string |
Max length: 1 |
| StartDate |
@StartDate char(8),起始日期YYYYMMDD |
string |
Required Max length: 8 |
| EndDate |
@EndDate char(8),截止日期 YYYYMMDD |
string |
Required Max length: 8 |
| DJSFZID |
@DJSFZID uniqueidentifier, 地接社分组的ID |
globally unique identifier |
None. |
| DJSID |
@DJSID uniqueidentifier,地接社ID |
globally unique identifier |
None. |
| DJSBMID |
@DJSBMID uniqueidentifier,地接社部门ID |
globally unique identifier |
None. |
| ZTSID |
@ZTSID uniqueidentifier,组团社ID |
globally unique identifier |
None. |
| ZTSBMID |
@ZTSBMID uniqueidentifier,组团社部门ID |
globally unique identifier |
None. |
| XYDWID |
@XYDWID uniqueidentifier,/*协议单位ID |
globally unique identifier |
None. |
| SPDH |
@SPDH CHAR(20),/*售票单号 |
string |
Max length: 20 |
| LBSBH |
@LBSBH varchar(32),门票卡号 |
string |
Max length: 32 |
| YHDLM |
@YHDLM varchar(20),用户登录名 |
string |
Max length: 20 |
| DYZH |
@DYZH VARCHAR(20),导游证号 |
string |
Max length: 20 |
| JYLY |
@JYLY char(1),交易来源 |
string |
Max length: 1 |
| XFFAID |
@XFFAID CHAR(2),现返方案ID |
string |
Max length: 6 |
| FKFSID |
@FKFSID char(2),付款方式ID |
string |
Max length: 2 |
| MPLXList |
@MPLXList varchar(2000),门票类型ID |
Collection of globally unique identifier |
None. |
| SPZDList |
@SPZDList varchar(2000)售票站点代码 |
Collection of string |
None. |
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": "3d87775e-c2a0-4087-a783-99f18debb005",
"JMDM": 1,
"YQID": "a07fec92-d61f-4131-87df-daed1a130858",
"PCMC": "sample string 13",
"PCID": "93e49953-06d8-4e9f-b81c-aa20ff0471df",
"ISJQ": "sample string 15",
"TJNR": "sample string 16",
"SPZD": "sample string 17",
"SYSID": "sample string 18",
"VAR_HasInsurance": "sample string 19",
"DayType": "sample string 20",
"StartDate": "sample string 21",
"EndDate": "sample string 22",
"DJSFZID": "00dc00c3-2955-4cc6-adef-85aa2a704240",
"DJSID": "c5c753f7-526c-43b5-a0fd-63be52641737",
"DJSBMID": "49640c14-889e-4e03-be41-f35f34bff067",
"ZTSID": "6b08f2e4-f632-4f77-8ba2-e79ecdf31ba7",
"ZTSBMID": "737a73c4-6633-46c5-87fb-5b1ff8fbaff2",
"XYDWID": "ece3ea6d-728c-43a6-98d1-dd1e40ce4dd9",
"SPDH": "sample string 29",
"LBSBH": "sample string 30",
"YHDLM": "sample string 31",
"DYZH": "sample string 32",
"JYLY": "sample string 33",
"XFFAID": "sample string 34",
"FKFSID": "sample string 35",
"MPLXList": [
"a1601d29-1221-4ad2-aade-9c568c1fc1a6",
"57d7dab9-45bc-4e05-9b7e-416408e6d6ab"
],
"SPZDList": [
"sample string 1",
"sample string 2"
]
}
application/xml, text/xml
<Rpt_DJS_TicketSaleParm xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DigitalScience.DataTransfer.Tour.V5.Parm.Report">
<DJSBMID>49640c14-889e-4e03-be41-f35f34bff067</DJSBMID>
<DJSFZID>00dc00c3-2955-4cc6-adef-85aa2a704240</DJSFZID>
<DJSID>c5c753f7-526c-43b5-a0fd-63be52641737</DJSID>
<DYZH>sample string 32</DYZH>
<DayType>sample string 20</DayType>
<EndDate>sample string 22</EndDate>
<FKFSID>sample string 35</FKFSID>
<FLAG>sample string 8</FLAG>
<GPXZ>sample string 5</GPXZ>
<ISALL>sample string 2</ISALL>
<ISJQ>sample string 15</ISJQ>
<JG1>9</JG1>
<JG2>10</JG2>
<JMDM>1</JMDM>
<JYLY>sample string 33</JYLY>
<LBSBH>sample string 30</LBSBH>
<MPLXID>3d87775e-c2a0-4087-a783-99f18debb005</MPLXID>
<MPLXID1>sample string 1</MPLXID1>
<MPLXList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d2p1:guid>a1601d29-1221-4ad2-aade-9c568c1fc1a6</d2p1:guid>
<d2p1:guid>57d7dab9-45bc-4e05-9b7e-416408e6d6ab</d2p1:guid>
</MPLXList>
<PCID>93e49953-06d8-4e9f-b81c-aa20ff0471df</PCID>
<PCMC>sample string 13</PCMC>
<SCQHDM>sample string 6</SCQHDM>
<SPDH>sample string 29</SPDH>
<SPZD>sample string 17</SPZD>
<SPZDList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d2p1:string>sample string 1</d2p1:string>
<d2p1:string>sample string 2</d2p1:string>
</SPZDList>
<SYSID>sample string 18</SYSID>
<StartDate>sample string 21</StartDate>
<TJFW>sample string 7</TJFW>
<TJNR>sample string 16</TJNR>
<Top20>sample string 3</Top20>
<VAR_HasInsurance>sample string 19</VAR_HasInsurance>
<XFFAID>sample string 34</XFFAID>
<XYDWID>ece3ea6d-728c-43a6-98d1-dd1e40ce4dd9</XYDWID>
<XZQHDMp>sample string 4</XZQHDMp>
<YHDLM>sample string 31</YHDLM>
<YQID>a07fec92-d61f-4131-87df-daed1a130858</YQID>
<ZTSBMID>737a73c4-6633-46c5-87fb-5b1ff8fbaff2</ZTSBMID>
<ZTSID>6b08f2e4-f632-4f77-8ba2-e79ecdf31ba7</ZTSID>
</Rpt_DJS_TicketSaleParm>
application/x-www-form-urlencoded
Sample not available.
application/bson
Binary JSON content. See http://bsonspec.org for details.
Response Information
Resource Description
查询地接社部门购票分游客类型（团队类型）-票型汇总表，以复杂参数类型返回(CommonOperationResultWithTag(V_RPT_DJSBM_TDLX_MPZL_HZ))
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.