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": "ea5fbf22-ddce-40c1-a580-2b6bc84b0790",
"VAR_DJSBM": "499afbd5-f78d-4c50-95a5-303a64a9bb88",
"VAR_ZTS": "17a736d0-a00e-40c2-932c-62e83b4869f1",
"VAR_ZTSBM": "9f311a3f-99c2-4f3b-884a-01d664e0a8ab",
"VAR_XYDW": "dc99bdd5-e0fe-4f28-ad5c-b420688ac62c",
"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": [
"1619b757-80b6-4b36-a2cf-b753ac1a6e45",
"5c4c7c4c-2eb3-4b66-b89e-9df0b4a987a1"
]
}
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>ea5fbf22-ddce-40c1-a580-2b6bc84b0790</VAR_DJS>
<VAR_DJSBM>499afbd5-f78d-4c50-95a5-303a64a9bb88</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>1619b757-80b6-4b36-a2cf-b753ac1a6e45</d2p1:guid>
<d2p1:guid>5c4c7c4c-2eb3-4b66-b89e-9df0b4a987a1</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>dc99bdd5-e0fe-4f28-ad5c-b420688ac62c</VAR_XYDW>
<VAR_YDDH>sample string 4</VAR_YDDH>
<VAR_ZTS>17a736d0-a00e-40c2-932c-62e83b4869f1</VAR_ZTS>
<VAR_ZTSBM>9f311a3f-99c2-4f3b-884a-01d664e0a8ab</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.