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
NameDescriptionTypeAdditional 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

Sample:
{
  "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": "aa724dca-482d-4f1c-aa3d-c9f6f645d6ff",
  "VAR_DJSBM": "82bdaad9-dbf8-48ff-b373-8ef6efe2ebfb",
  "VAR_ZTS": "6debbc52-c1cb-4e48-8d49-367d8b16acae",
  "VAR_ZTSBM": "f1cbc47d-fcce-4de5-8938-8eb8973fe253",
  "VAR_XYDW": "bcae106d-4d87-4a55-8a35-df8e7374bc75",
  "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": [
    "3167a880-b6fd-4bfa-af43-7d654dc14935",
    "f1ee069a-1e49-4d02-9c17-20e706e5951c"
  ]
}

application/xml, text/xml

Sample:
<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>aa724dca-482d-4f1c-aa3d-c9f6f645d6ff</VAR_DJS>
  <VAR_DJSBM>82bdaad9-dbf8-48ff-b373-8ef6efe2ebfb</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>3167a880-b6fd-4bfa-af43-7d654dc14935</d2p1:guid>
    <d2p1:guid>f1ee069a-1e49-4d02-9c17-20e706e5951c</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>bcae106d-4d87-4a55-8a35-df8e7374bc75</VAR_XYDW>
  <VAR_YDDH>sample string 4</VAR_YDDH>
  <VAR_ZTS>6debbc52-c1cb-4e48-8d49-367d8b16acae</VAR_ZTS>
  <VAR_ZTSBM>f1cbc47d-fcce-4de5-8938-8eb8973fe253</VAR_ZTSBM>
</Rpt_Web_Busi_TickeDetailParm>

application/x-www-form-urlencoded

Sample:

Sample not available.

application/bson

Sample:
Binary JSON content. See http://bsonspec.org for details.

Response Information

Resource Description

查询巨复杂的互联网交易明细表的门票部分,涉及到预订单、明细、年卡、售票单、退票单、账号等表,以复杂类型返回CommonOperationResultWithTag(V_Rpt_Web_Busi_TickeDetailDataTable)

ComplexParm
NameDescriptionTypeAdditional information
Zipped

读取或设置一个值,指示当前缓冲区是否经过了压缩

boolean

None.

Buffer

读取或设置一个值,指明当前缓冲区的内容

Collection of byte

None.

Response Formats

application/json, text/json

Sample:
{
  "Zipped": true,
  "Buffer": "QEA="
}

application/xml, text/xml

Sample:
<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

Sample:
Binary JSON content. See http://bsonspec.org for details.