POST api/Report/DJS/QueryV_Rpt_DJS_SCQH_HZ

获取地接社分市场区划汇总表的api,并以复杂类型返回(CommonOperationResultWithTag(V_Rpt_DJS_SCQH_HZDataTable))。

Request Information

URI Parameters

None.

Body Parameters

Rpt_DJS_TicketSaleParm
NameDescriptionTypeAdditional information
MPLXID1

单选的门票类型ID

 string

Max length: 36
ISALL

@ISALL CHAR(1),/*是否查询全部数据(1-查询所有 0-仅查询旅行社数据(即不查询其他的数据))

 string

Max length: 1
Top20

@Top20 char(1) /*是否只显示前20名*/

 string

Max length: 1
XZQHDMp

@VAR_XZQHDM varchar(6),/*行政区划代码*/

 string

Max length: 6
GPXZ

@VAR_GPXZ char(1),/*购票人性质 '0' 只含旅行社部门导游组团组团部门　'1' 只含散客 其他值全包括*/

 string

Max length: 1
SCQHDM

@VAR_SCQHDM char(2),/*一级市场区划代码*/

 string

Max length: 8
TJFW

@TJFW char(1)统计范围1营业类，2返款类，A营业类+返款类

 string

Max length: 1
FLAG

@VAR_FLAG char(1),/*是否启用价格区间查询 1表示启用*/

 string

Max length: 1
JG1

@VAR_JG1 decimal(18,2),/*价格区间1*/

 decimal number

None.
JG2

@VAR_JG2 decimal(18,2)/*价格区间2*/

 decimal number

None.
MPLXID

门票类型id GUID类型

 globally unique identifier

None.
JMDM

@VAR_JMDM bigint, 剧目代码

 integer

None.
YQID

@VAR_YQID UNIQUEIDENTIFIER,园区ID

 globally unique identifier

None.
PCMC

@VAR_PCMC nvarchar(64) 场次名称

 string

Max length: 64
PCID

@VAR_PCID uniqueidentifier,场次ID

 globally unique identifier

None.
ISJQ

@VAR_ISJQ char(1),是否是景区统计 1表示景区,其他值表示演艺系统

 string

Max length: 1
TJNR

@VAR_TJNR char(1)1仅统计数量,2仅统计金额,其他值,全部统计

 string

Max length: 1
SPZD

@VAR_SPZD char(2),售票站点

 string

Max length: 2
SYSID

@VAR_SYSID char(1)/*1-仅检索团队购票 2-仅检索散客购票 0或空，检索上序两种购票*/

 string

Max length: 1
VAR_HasInsurance

统计结果中是否包含保险数据。

 string

Max length: 1
DayType

@DayType char(1),1交易日期，2门票日期

 string

Max length: 1
StartDate

@StartDate char(8),起始日期YYYYMMDD

 string

Required

Max length: 8
EndDate

@EndDate char(8),截止日期 YYYYMMDD

 string

Required

Max length: 8
DJSFZID

@DJSFZID uniqueidentifier, 地接社分组的ID

 globally unique identifier

None.
DJSID

@DJSID uniqueidentifier,地接社ID

 globally unique identifier

None.
DJSBMID

@DJSBMID uniqueidentifier,地接社部门ID

 globally unique identifier

None.
ZTSID

@ZTSID uniqueidentifier,组团社ID

 globally unique identifier

None.
ZTSBMID

@ZTSBMID uniqueidentifier,组团社部门ID

 globally unique identifier

None.
XYDWID

@XYDWID uniqueidentifier,/*协议单位ID

 globally unique identifier

None.
SPDH

@SPDH CHAR(20),/*售票单号

 string

Max length: 20
LBSBH

@LBSBH varchar(32),门票卡号

 string

Max length: 32
YHDLM

@YHDLM varchar(20),用户登录名

 string

Max length: 20
DYZH

@DYZH VARCHAR(20),导游证号

 string

Max length: 20
JYLY

@JYLY char(1),交易来源

 string

Max length: 1
XFFAID

@XFFAID CHAR(2),现返方案ID

 string

Max length: 6
FKFSID

@FKFSID char(2),付款方式ID

 string

Max length: 2
MPLXList

@MPLXList varchar(2000),门票类型ID

 Collection of globally unique identifier

None.
SPZDList

@SPZDList varchar(2000)售票站点代码

 Collection of string

None.

Request Formats

application/json, text/json

Sample: 
{
  "MPLXID1": "sample string 1",
  "ISALL": "sample string 2",
  "Top20": "sample string 3",
  "XZQHDMp": "sample string 4",
  "GPXZ": "sample string 5",
  "SCQHDM": "sample string 6",
  "TJFW": "sample string 7",
  "FLAG": "sample string 8",
  "JG1": 9.0,
  "JG2": 10.0,
  "MPLXID": "e2747d36-1c5b-447c-b058-63e02b3c6384",
  "JMDM": 1,
  "YQID": "8fe73b9d-8e4d-4d96-9c23-286bbcbc3ff8",
  "PCMC": "sample string 13",
  "PCID": "ccab011f-9676-462e-b418-2ab63e821758",
  "ISJQ": "sample string 15",
  "TJNR": "sample string 16",
  "SPZD": "sample string 17",
  "SYSID": "sample string 18",
  "VAR_HasInsurance": "sample string 19",
  "DayType": "sample string 20",
  "StartDate": "sample string 21",
  "EndDate": "sample string 22",
  "DJSFZID": "17fb955b-0cc5-48db-b1dd-55b8b5876823",
  "DJSID": "6f6d9c6a-b21f-4aa7-ac02-a5e98d2f6634",
  "DJSBMID": "bd60534d-fd70-40f4-8e6e-5f9f0ef1c291",
  "ZTSID": "3ad95f78-5c6d-4f9f-891d-f1dba6cdb0a7",
  "ZTSBMID": "a8ad773a-2191-4008-9b1f-ba951577768d",
  "XYDWID": "12046fff-7781-4c46-84b3-e1fb563e2030",
  "SPDH": "sample string 29",
  "LBSBH": "sample string 30",
  "YHDLM": "sample string 31",
  "DYZH": "sample string 32",
  "JYLY": "sample string 33",
  "XFFAID": "sample string 34",
  "FKFSID": "sample string 35",
  "MPLXList": [
    "0c91dca2-0a5e-441b-b755-330113ce935e",
    "2d7fb482-c3db-4e3d-ab40-f4e5c33209dc"
  ],
  "SPZDList": [
    "sample string 1",
    "sample string 2"
  ]
}

application/xml, text/xml

Sample: 
<Rpt_DJS_TicketSaleParm xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DigitalScience.DataTransfer.Tour.V5.Parm.Report">
  <DJSBMID>bd60534d-fd70-40f4-8e6e-5f9f0ef1c291</DJSBMID>
  <DJSFZID>17fb955b-0cc5-48db-b1dd-55b8b5876823</DJSFZID>
  <DJSID>6f6d9c6a-b21f-4aa7-ac02-a5e98d2f6634</DJSID>
  <DYZH>sample string 32</DYZH>
  <DayType>sample string 20</DayType>
  <EndDate>sample string 22</EndDate>
  <FKFSID>sample string 35</FKFSID>
  <FLAG>sample string 8</FLAG>
  <GPXZ>sample string 5</GPXZ>
  <ISALL>sample string 2</ISALL>
  <ISJQ>sample string 15</ISJQ>
  <JG1>9</JG1>
  <JG2>10</JG2>
  <JMDM>1</JMDM>
  <JYLY>sample string 33</JYLY>
  <LBSBH>sample string 30</LBSBH>
  <MPLXID>e2747d36-1c5b-447c-b058-63e02b3c6384</MPLXID>
  <MPLXID1>sample string 1</MPLXID1>
  <MPLXList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:guid>0c91dca2-0a5e-441b-b755-330113ce935e</d2p1:guid>
    <d2p1:guid>2d7fb482-c3db-4e3d-ab40-f4e5c33209dc</d2p1:guid>
  </MPLXList>
  <PCID>ccab011f-9676-462e-b418-2ab63e821758</PCID>
  <PCMC>sample string 13</PCMC>
  <SCQHDM>sample string 6</SCQHDM>
  <SPDH>sample string 29</SPDH>
  <SPZD>sample string 17</SPZD>
  <SPZDList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>sample string 1</d2p1:string>
    <d2p1:string>sample string 2</d2p1:string>
  </SPZDList>
  <SYSID>sample string 18</SYSID>
  <StartDate>sample string 21</StartDate>
  <TJFW>sample string 7</TJFW>
  <TJNR>sample string 16</TJNR>
  <Top20>sample string 3</Top20>
  <VAR_HasInsurance>sample string 19</VAR_HasInsurance>
  <XFFAID>sample string 34</XFFAID>
  <XYDWID>12046fff-7781-4c46-84b3-e1fb563e2030</XYDWID>
  <XZQHDMp>sample string 4</XZQHDMp>
  <YHDLM>sample string 31</YHDLM>
  <YQID>8fe73b9d-8e4d-4d96-9c23-286bbcbc3ff8</YQID>
  <ZTSBMID>a8ad773a-2191-4008-9b1f-ba951577768d</ZTSBMID>
  <ZTSID>3ad95f78-5c6d-4f9f-891d-f1dba6cdb0a7</ZTSID>
</Rpt_DJS_TicketSaleParm>

application/x-www-form-urlencoded

Sample:

Failed to generate the sample for media type 'application/x-www-form-urlencoded'. Cannot use formatter 'JQueryMvcFormUrlEncodedFormatter' to write type 'Rpt_DJS_TicketSaleParm'.

application/bson

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

Response Information

Resource Description

获取地接社分市场区划汇总表的api,并以复杂类型返回(CommonOperationResultWithTag(V_Rpt_DJS_SCQH_HZDataTable))。

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.