POST api/Report/WEB/Busi/TickeDetail/Shop/Query
查询巨复杂的互联网交易明细表的门票部分,涉及到预订单、明细、年卡、售票单、退票单、账号等表,以复杂类型返回CommonOperationResultWithTag(V_Rpt_Web_Busi_TickeDetailDataTable)
Request Information
URI Parameters
None.
Body Parameters
Rpt_Web_Busi_TickeDetailParm| Name | 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": "cdae7f06-e93c-4b6c-b6ee-0d0d11b1b182",
"VAR_DJSBM": "791c530f-0f10-453f-92a9-9baa51c3d43d",
"VAR_ZTS": "51163cbd-8e6c-4577-ad20-845f354124c5",
"VAR_ZTSBM": "406277c7-1e2e-4548-9d97-a73a93ffa9ed",
"VAR_XYDW": "718d4a92-b831-4014-a5a2-1a040cfcf05a",
"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": [
"68303ef7-2879-48fb-82ff-fdc0d263c2fb",
"2bc09afa-a932-447d-8aaa-e699dbadc0ed"
]
}
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>cdae7f06-e93c-4b6c-b6ee-0d0d11b1b182</VAR_DJS>
<VAR_DJSBM>791c530f-0f10-453f-92a9-9baa51c3d43d</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>68303ef7-2879-48fb-82ff-fdc0d263c2fb</d2p1:guid>
<d2p1:guid>2bc09afa-a932-447d-8aaa-e699dbadc0ed</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>718d4a92-b831-4014-a5a2-1a040cfcf05a</VAR_XYDW>
<VAR_YDDH>sample string 4</VAR_YDDH>
<VAR_ZTS>51163cbd-8e6c-4577-ad20-845f354124c5</VAR_ZTS>
<VAR_ZTSBM>406277c7-1e2e-4548-9d97-a73a93ffa9ed</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)
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.