POST api/Report/Business/Month/QueryV_RPT_SPYHZ_SPY

以复杂参数和复杂结果查询V_RPT_SPYHZ_SPY数据。

Request Information

URI Parameters

None.

Body Parameters

Name	Description	Type	Additional information
VAR_RQ1	VAR_RQ1 char(6)/起始日期/,	string	None.
VAR_RQ2	VAR_RQ2 char(6)/截止日期/,	string	None.
VAR_MODEL	VAR_MODEL char(1),/查询模式0-按照营业日期 1-按照门票日期默认按照营业方式查询/	string	None.
VAR_HasCoupon	VAR_HasCoupon char(1) ,/是否使用的优惠券，1使用了，0未使用，空不限/	string	None.
VAR_JoinActivation	VAR_JoinActivation char(1),/是否参与了优惠活动，1参与了，0未参与，空不限/	string	None.
VAR_DJSID	VAR_DJSID uniqueidentifier,/地接社ID/	globally unique identifier	None.
VAR_DJSBMID	VAR_DJSBMID uniqueidentifier ,/地接社部门ID/	globally unique identifier	None.
VAR_ZTSID	VAR_ZTSID uniqueidentifier,/组团社ID/	globally unique identifier	None.
VAR_ZTSBMID	VAR_ZTSBMID uniqueidentifier,/组团社ID/	globally unique identifier	None.
VAR_XYDWID	VAR_XYDWID uniqueidentifier,/协议单位ID/	globally unique identifier	None.
VAR_DYZH	VAR_DYZH varchar(20),/导游证号/	string	None.
VAR_JYLY	VAR_JYLY char(1),/交易来源，1前台，2互联网/	string	None.
VAR_MemberId	VAR_MemberId bigint,/会员ID，0表示不限/	integer	None.
VAR_MemberLevel	VAR_MemberLevel tinyint ,/会员等级，FF表示不限/	byte	None.
VAR_TDLX	VAR_TDLX char(2),/游客类型或团队类型/	string	None.
VAR_SCQH	VAR_SCQH varchar(8),/市场区划/	string	None.
VAR_FAID	VAR_FAID char(4) ,/现返方案ID/	string	None.
VAR_YWYDM	VAR_YWYDM varchar(4),/业务员代码/	string	None.
VAR_YHDLM	VAR_YHDLM AS CT_STR50_UNIQUE_ARR READONLY/售票员/,	string	None.
VAR_MPLXID	VAR_MPLXID as CT_GUID_UNIQUE_ARR READONLY/门票类型/,	string	None.
VAR_SPZDDM	VAR_SPZDDM as CT_STR50_UNIQUE_ARR READONLY/售票站点代码/	string	None.

Request Formats

application/json, text/json

Sample:

{
  "VAR_RQ1": "sample string 1",
  "VAR_RQ2": "sample string 2",
  "VAR_MODEL": "sample string 3",
  "VAR_HasCoupon": "sample string 4",
  "VAR_JoinActivation": "sample string 5",
  "VAR_DJSID": "01395113-5c0c-4589-842c-197cceeb6755",
  "VAR_DJSBMID": "da3d5f2d-6864-4073-9a7f-4044f80b9720",
  "VAR_ZTSID": "78802d6c-46a7-457a-8385-0ca971f84899",
  "VAR_ZTSBMID": "ba2a386f-bf79-46f4-9a33-f5891352e1b2",
  "VAR_XYDWID": "78f72b7a-d7e7-41b0-8545-e2b1af0defb7",
  "VAR_DYZH": "sample string 11",
  "VAR_JYLY": "sample string 12",
  "VAR_MemberId": 13,
  "VAR_MemberLevel": 64,
  "VAR_TDLX": "sample string 15",
  "VAR_SCQH": "sample string 16",
  "VAR_FAID": "sample string 17",
  "VAR_YWYDM": "sample string 18",
  "VAR_YHDLM": "sample string 19",
  "VAR_MPLXID": "sample string 20",
  "VAR_SPZDDM": "sample string 21"
}

application/xml, text/xml

Sample:

<Rpt_TikcketMonthCommonParametersParm xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DigitalScience.DataTransfer.Tour.V5.Parm.Report">
  <VAR_DJSBMID>da3d5f2d-6864-4073-9a7f-4044f80b9720</VAR_DJSBMID>
  <VAR_DJSID>01395113-5c0c-4589-842c-197cceeb6755</VAR_DJSID>
  <VAR_DYZH>sample string 11</VAR_DYZH>
  <VAR_FAID>sample string 17</VAR_FAID>
  <VAR_HasCoupon>sample string 4</VAR_HasCoupon>
  <VAR_JYLY>sample string 12</VAR_JYLY>
  <VAR_JoinActivation>sample string 5</VAR_JoinActivation>
  <VAR_MODEL>sample string 3</VAR_MODEL>
  <VAR_MPLXID>sample string 20</VAR_MPLXID>
  <VAR_MemberId>13</VAR_MemberId>
  <VAR_MemberLevel>64</VAR_MemberLevel>
  <VAR_RQ1>sample string 1</VAR_RQ1>
  <VAR_RQ2>sample string 2</VAR_RQ2>
  <VAR_SCQH>sample string 16</VAR_SCQH>
  <VAR_SPZDDM>sample string 21</VAR_SPZDDM>
  <VAR_TDLX>sample string 15</VAR_TDLX>
  <VAR_XYDWID>78f72b7a-d7e7-41b0-8545-e2b1af0defb7</VAR_XYDWID>
  <VAR_YHDLM>sample string 19</VAR_YHDLM>
  <VAR_YWYDM>sample string 18</VAR_YWYDM>
  <VAR_ZTSBMID>ba2a386f-bf79-46f4-9a33-f5891352e1b2</VAR_ZTSBMID>
  <VAR_ZTSID>78802d6c-46a7-457a-8385-0ca971f84899</VAR_ZTSID>
</Rpt_TikcketMonthCommonParametersParm>

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

以复杂参数和复杂结果查询V_RPT_SPYHZ_SPY数据。

ComplexParm

Name	Description	Type	Additional 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.