POST api/Report/WEB/Busi/TickeDetail/Shop/Query
查询巨复杂的互联网交易明细表的门票部分,涉及到预订单、明细、年卡、售票单、退票单、账号等表,以复杂类型返回CommonOperationResultWithTag(V_Rpt_Web_Busi_TickeDetailDataTable)
Request Information
URI Parameters
None.
Body Parameters
Rpt_Web_Busi_TickeDetailParmName | Description | Type | Additional information |
---|---|---|---|
VAR_RQ1 |
VAR_RQ1 CHAR(8), /*开始日期,格式 YYYYMMDD*/ |
string |
Max length: 8 |
VAR_RQ2 |
VAR_RQ2 CHAR(8), /*截止日期,格式 YYYYMMDD*/ |
string |
Max length: 8 |
VAR_DATEMODE |
VAR_DATEMODE char(1),/* 交易日期,'0'预订日期,'1'生效日期, 默认为‘0’*/ |
string |
Max length: 1 |
VAR_YDDH |
VAR_YDDH char(20),/*预订单号,左匹配*/ |
string |
Max length: 20 |
VAR_SPDH |
VAR_SPDH char(20),/*售票单号,左匹配*/ |
string |
Max length: 20 |
VAR_DSFDH |
VAR_DSFDH varchar(200),/*第三方单号 ,左匹配*/ |
string |
Max length: 200 |
VAR_TicketNumber |
VAR_TicketNumber nvarchar(32),/*门票号码,左匹配*/ |
string |
Max length: 32 |
VAR_UserName |
VAR_UserName nvarchar(64),/*姓名,主要联系人姓名或持票人姓名*/ |
string |
Max length: 64 |
VAR_UserNumber |
VAR_UserNumber nvarchar(20),/*联系方式,主要联系手机号或持票人手机号*/ |
string |
Max length: 20 |
VAR_UserID |
VAR_UserID nvarchar(20),/*证件号码,主要联系证件号或持票人证件号*/ |
string |
Max length: 20 |
VAR_DJS |
地接社 |
globally unique identifier |
None. |
VAR_DJSBM |
地接社部门 |
globally unique identifier |
None. |
VAR_ZTS |
组团社 |
globally unique identifier |
None. |
VAR_ZTSBM |
组团社部门 |
globally unique identifier |
None. |
VAR_XYDW |
协议单位 |
globally unique identifier |
None. |
VAR_Guider |
导游员 |
string |
None. |
VAR_FLWDP |
VAR_FLWDP char(1),/*交易来源,1前台 2互 联网*/ |
string |
Max length: 1 |
VAR_ActivateMode |
VAR_ActivateMode char(1),/*激活方式*/ |
string |
Max length: 1 |
VAR_ActivateStatus |
VAR_ActivateStatus char(1),/*激活状态*/ |
string |
Max length: 1 |
VAR_TicketState |
VAR_TicketState char(1),/*门票状态 1-正常,2已退票*/ |
string |
Max length: 1 |
VAR_BillState |
VAR_BillState char(1),/*订单状态 属于预订的交易时的预订单状态,等于(如果不是预订,不能命中)*/ |
string |
Max length: 1 |
VAR_TicketUsedSegment |
VAR_TicketUsedSegment char(1),/*使用阶段 1,2,3,9*/ |
string |
Max length: 1 |
VAR_ValidityPeriod |
VAR_ValidityPeriod char(1),/*有效期状态 1-有效期内,2未到有效期,3已过有效期*/ |
string |
Max length: 1 |
VAR_TicketNames |
VAR_TicketNames CT_GUID_UNIQUE_ARR READONLY,/*票型名称*/ |
Collection of globally unique identifier |
None. |
Request Formats
application/json, text/json
{ "VAR_RQ1": "sample string 1", "VAR_RQ2": "sample string 2", "VAR_DATEMODE": "sample string 3", "VAR_YDDH": "sample string 4", "VAR_SPDH": "sample string 5", "VAR_DSFDH": "sample string 6", "VAR_TicketNumber": "sample string 7", "VAR_UserName": "sample string 8", "VAR_UserNumber": "sample string 9", "VAR_UserID": "sample string 10", "VAR_DJS": "ea2cf7be-845f-4d77-86f2-c0d515deb075", "VAR_DJSBM": "589ed727-2095-462e-8e60-09778ec5fbfb", "VAR_ZTS": "c5369bee-0274-431d-90b0-272b5c60cb53", "VAR_ZTSBM": "2ced716d-3345-42f3-a6bd-32e8570b097a", "VAR_XYDW": "16bf3d25-d64b-4da0-bb16-28272ea6e7b7", "VAR_Guider": "sample string 16", "VAR_FLWDP": "sample string 17", "VAR_ActivateMode": "sample string 18", "VAR_ActivateStatus": "sample string 19", "VAR_TicketState": "sample string 20", "VAR_BillState": "sample string 21", "VAR_TicketUsedSegment": "sample string 22", "VAR_ValidityPeriod": "sample string 23", "VAR_TicketNames": [ "81a8f5f5-2466-4fb9-9760-6824ae4055db", "b14ca100-aa96-460a-b337-9ed91b50079f" ] }
application/xml, text/xml
<Rpt_Web_Busi_TickeDetailParm xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DigitalScience.DataTransfer.Tour.V5.Parm.Report"> <VAR_ActivateMode>sample string 18</VAR_ActivateMode> <VAR_ActivateStatus>sample string 19</VAR_ActivateStatus> <VAR_BillState>sample string 21</VAR_BillState> <VAR_DATEMODE>sample string 3</VAR_DATEMODE> <VAR_DJS>ea2cf7be-845f-4d77-86f2-c0d515deb075</VAR_DJS> <VAR_DJSBM>589ed727-2095-462e-8e60-09778ec5fbfb</VAR_DJSBM> <VAR_DSFDH>sample string 6</VAR_DSFDH> <VAR_FLWDP>sample string 17</VAR_FLWDP> <VAR_Guider>sample string 16</VAR_Guider> <VAR_RQ1>sample string 1</VAR_RQ1> <VAR_RQ2>sample string 2</VAR_RQ2> <VAR_SPDH>sample string 5</VAR_SPDH> <VAR_TicketNames xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays"> <d2p1:guid>81a8f5f5-2466-4fb9-9760-6824ae4055db</d2p1:guid> <d2p1:guid>b14ca100-aa96-460a-b337-9ed91b50079f</d2p1:guid> </VAR_TicketNames> <VAR_TicketNumber>sample string 7</VAR_TicketNumber> <VAR_TicketState>sample string 20</VAR_TicketState> <VAR_TicketUsedSegment>sample string 22</VAR_TicketUsedSegment> <VAR_UserID>sample string 10</VAR_UserID> <VAR_UserName>sample string 8</VAR_UserName> <VAR_UserNumber>sample string 9</VAR_UserNumber> <VAR_ValidityPeriod>sample string 23</VAR_ValidityPeriod> <VAR_XYDW>16bf3d25-d64b-4da0-bb16-28272ea6e7b7</VAR_XYDW> <VAR_YDDH>sample string 4</VAR_YDDH> <VAR_ZTS>c5369bee-0274-431d-90b0-272b5c60cb53</VAR_ZTS> <VAR_ZTSBM>2ced716d-3345-42f3-a6bd-32e8570b097a</VAR_ZTSBM> </Rpt_Web_Busi_TickeDetailParm>
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_Web_Busi_TickeDetailDataTable)
ComplexParmName | 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.