POST api/Report/WEB/Busi/TickeDetail/Shop/Query

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

Request Information

URI Parameters

None.

Body Parameters

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

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": "a68847e6-3658-479a-903a-f3f1600c23fb",
  "VAR_DJSBM": "bb62b6b2-b20a-4dee-8ae1-f416b99e6855",
  "VAR_ZTS": "3c391df5-e8ff-4cbc-be0d-4c5c9093dd88",
  "VAR_ZTSBM": "fae1788c-d866-4dc5-a1ac-a99788f70d80",
  "VAR_XYDW": "8ca40b62-ae33-4beb-8ddb-b552febe2797",
  "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": [
    "a81cfbdb-f622-4392-976e-86cffd50ec72",
    "f94afc58-dad4-4f8a-9656-9ce4966a9979"
  ]
}

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>a68847e6-3658-479a-903a-f3f1600c23fb</VAR_DJS>
  <VAR_DJSBM>bb62b6b2-b20a-4dee-8ae1-f416b99e6855</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>a81cfbdb-f622-4392-976e-86cffd50ec72</d2p1:guid>
    <d2p1:guid>f94afc58-dad4-4f8a-9656-9ce4966a9979</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>8ca40b62-ae33-4beb-8ddb-b552febe2797</VAR_XYDW>
  <VAR_YDDH>sample string 4</VAR_YDDH>
  <VAR_ZTS>3c391df5-e8ff-4cbc-be0d-4c5c9093dd88</VAR_ZTS>
  <VAR_ZTSBM>fae1788c-d866-4dc5-a1ac-a99788f70d80</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

ComplexHugeParmOfInt32

Name	Type	Additional information
errcode	integer	None.
errmsg	string	None.
SpecialParm	integer	None.
ComplexParmCount	integer	None.
ComplexParms	Collection of ComplexParm	None.

Response Formats

application/json, text/json

Sample:

{
  "errcode": 1,
  "errmsg": "sample string 2",
  "SpecialParm": 3,
  "ComplexParmCount": 4,
  "ComplexParms": [
    {
      "Zipped": true,
      "Buffer": "QEA="
    },
    {
      "Zipped": true,
      "Buffer": "QEA="
    }
  ]
}

application/xml, text/xml

Sample:

<ComplexHugeParmOfint xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DigitalScience.DataTransfer">
  <ComplexParmCount>4</ComplexParmCount>
  <ComplexParms>
    <ComplexParm>
      <Buffer>QEA=</Buffer>
      <Zipped>true</Zipped>
    </ComplexParm>
    <ComplexParm>
      <Buffer>QEA=</Buffer>
      <Zipped>true</Zipped>
    </ComplexParm>
  </ComplexParms>
  <SpecialParm>3</SpecialParm>
  <errcode>1</errcode>
  <errmsg>sample string 2</errmsg>
</ComplexHugeParmOfint>

application/bson

Sample:

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