POST jxc_api/PriceQuery/Export

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
ShowDisabledProd	boolean	None.
ShowDisabledCust	boolean	None.
ShowDisabledVend	boolean	None.
IntPriceStatus	integer	None.
IntPriceSource	integer	None.
CustIds	Collection of integer	None.
VendIds	Collection of integer	None.
ProdIds	Collection of ProdIdApIdModel	None.
ProdType	Collection of integer	None.
Keywords	string	None.
PriceQueryIds	Collection of PriceQueryIdsModel	None.
DomModel	FromDomModel	None.
CustomSearchAndOrderCondition	CustomSearchAndOrderCondition	None.
PageIndex	integer	None.
PageSize	integer	None.
UsePager	boolean	None.
CurrUserSn	integer	None.
CanViewAllBill	boolean	None.
CanOpeAllWh	boolean	None.
OpeWhList	Collection of integer	None.
DocumentDateType	integer	None.
DocumentDateArr	Collection of date	None.
DeliveryDateType	integer	None.
DeliveryDateArr	Collection of date	None.
OffDateType	integer	None.
OffDateArr	Collection of date	None.
InventoryDateType	integer	None.
InventoryDateArr	Collection of date	None.
BillOrigins	Collection of integer	None.

Request Formats

application/json, text/json

Sample:

{
  "ShowDisabledProd": true,
  "ShowDisabledCust": true,
  "ShowDisabledVend": true,
  "IntPriceStatus": 4,
  "IntPriceSource": 5,
  "CustIds": [
    1,
    2
  ],
  "VendIds": [
    1,
    2
  ],
  "ProdIds": [
    {
      "ProdId": 1,
      "ApId": 2
    },
    {
      "ProdId": 1,
      "ApId": 2
    }
  ],
  "ProdType": [
    1,
    2
  ],
  "Keywords": "sample string 6",
  "PriceQueryIds": [
    {
      "SourceType": 1010,
      "ProdId": 1,
      "UnitId": 2,
      "ApId": 3,
      "InfoId": 4,
      "LevelId": 5
    },
    {
      "SourceType": 1010,
      "ProdId": 1,
      "UnitId": 2,
      "ApId": 3,
      "InfoId": 4,
      "LevelId": 5
    }
  ],
  "DomModel": {
    "VcId": 1,
    "ProdId": 2,
    "ApId": 3,
    "UnitId": 4,
    "Count": 5.0,
    "OrderDate": "2025-04-04 20:43:27",
    "Price": 7.0,
    "RuleId": 8,
    "IsSell": true
  },
  "CustomSearchAndOrderCondition": {
    "OrderColumnName": "sample string 1",
    "OrderType": 0,
    "CustomSearchParams": [
      {
        "ColumnName": "sample string 1",
        "Params": [
          {},
          {}
        ]
      },
      {
        "ColumnName": "sample string 1",
        "Params": [
          {},
          {}
        ]
      }
    ]
  },
  "PageIndex": 7,
  "PageSize": 8,
  "UsePager": true,
  "CurrUserSn": 10,
  "CanViewAllBill": true,
  "CanOpeAllWh": true,
  "OpeWhList": [
    1,
    2
  ],
  "DocumentDateType": 13,
  "DocumentDateArr": [
    "2025-04-04 20:43:27",
    "2025-04-04 20:43:27"
  ],
  "DeliveryDateType": 14,
  "DeliveryDateArr": [
    "2025-04-04 20:43:27",
    "2025-04-04 20:43:27"
  ],
  "OffDateType": 15,
  "OffDateArr": [
    "2025-04-04 20:43:27",
    "2025-04-04 20:43:27"
  ],
  "InventoryDateType": 16,
  "InventoryDateArr": [
    "2025-04-04 20:43:27",
    "2025-04-04 20:43:27"
  ],
  "BillOrigins": [
    1,
    2
  ]
}

application/xml, text/xml

Sample:

<PriceQueryCondition xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.NewApi.BaseData.PriceQuery">
  <_billOrigins xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_billOrigins>
  <_x003C_DeliveryDateArr_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">
    <d2p1:dateTime>2025-04-04T20:43:27.5012043+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T20:43:27.5012043+08:00</d2p1:dateTime>
  </_x003C_DeliveryDateArr_x003E_k__BackingField>
  <_x003C_DeliveryDateType_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">14</_x003C_DeliveryDateType_x003E_k__BackingField>
  <_x003C_DocumentDateArr_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">
    <d2p1:dateTime>2025-04-04T20:43:27.5012043+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T20:43:27.5012043+08:00</d2p1:dateTime>
  </_x003C_DocumentDateArr_x003E_k__BackingField>
  <_x003C_DocumentDateType_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">13</_x003C_DocumentDateType_x003E_k__BackingField>
  <_x003C_InventoryDateArr_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">
    <d2p1:dateTime>2025-04-04T20:43:27.5012043+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T20:43:27.5012043+08:00</d2p1:dateTime>
  </_x003C_InventoryDateArr_x003E_k__BackingField>
  <_x003C_InventoryDateType_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">16</_x003C_InventoryDateType_x003E_k__BackingField>
  <_x003C_OffDateArr_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">
    <d2p1:dateTime>2025-04-04T20:43:27.5012043+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T20:43:27.5012043+08:00</d2p1:dateTime>
  </_x003C_OffDateArr_x003E_k__BackingField>
  <_x003C_OffDateType_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.Setting">15</_x003C_OffDateType_x003E_k__BackingField>
  <_x003C_CanOpeAllWh_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Setting">true</_x003C_CanOpeAllWh_x003E_k__BackingField>
  <_x003C_CanViewAllBill_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Setting">true</_x003C_CanViewAllBill_x003E_k__BackingField>
  <_x003C_CurrUserSn_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Setting">10</_x003C_CurrUserSn_x003E_k__BackingField>
  <_x003C_OpeWhList_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Setting">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_OpeWhList_x003E_k__BackingField>
  <_x003C_PageIndex_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.NewApi">7</_x003C_PageIndex_x003E_k__BackingField>
  <_x003C_PageSize_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.NewApi">8</_x003C_PageSize_x003E_k__BackingField>
  <_x003C_UsePager_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.NewApi">true</_x003C_UsePager_x003E_k__BackingField>
  <CustIds xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </CustIds>
  <CustomSearchAndOrderCondition xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.NewApi.BaseData">
    <d2p1:CustomSearchParams>
      <d2p1:CustomSearchParam>
        <d2p1:ColumnName>sample string 1</d2p1:ColumnName>
        <d2p1:Params xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:anyType />
          <d5p1:anyType />
        </d2p1:Params>
      </d2p1:CustomSearchParam>
      <d2p1:CustomSearchParam>
        <d2p1:ColumnName>sample string 1</d2p1:ColumnName>
        <d2p1:Params xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:anyType />
          <d5p1:anyType />
        </d2p1:Params>
      </d2p1:CustomSearchParam>
    </d2p1:CustomSearchParams>
    <d2p1:OrderColumnName>sample string 1</d2p1:OrderColumnName>
    <d2p1:OrderType>None</d2p1:OrderType>
  </CustomSearchAndOrderCondition>
  <DomModel>
    <ApId>3</ApId>
    <Count>5</Count>
    <IsSell>true</IsSell>
    <OrderDate>2025-04-04T20:43:27.5012043+08:00</OrderDate>
    <Price>7</Price>
    <ProdId>2</ProdId>
    <RuleId>8</RuleId>
    <UnitId>4</UnitId>
    <VcId>1</VcId>
  </DomModel>
  <IntPriceSource>5</IntPriceSource>
  <IntPriceStatus>4</IntPriceStatus>
  <Keywords>sample string 6</Keywords>
  <PriceQueryIds>
    <PriceQueryIdsModel>
      <ApId>3</ApId>
      <InfoId>4</InfoId>
      <LevelId>5</LevelId>
      <ProdId>1</ProdId>
      <SourceType>CustPriceInfo</SourceType>
      <UnitId>2</UnitId>
    </PriceQueryIdsModel>
    <PriceQueryIdsModel>
      <ApId>3</ApId>
      <InfoId>4</InfoId>
      <LevelId>5</LevelId>
      <ProdId>1</ProdId>
      <SourceType>CustPriceInfo</SourceType>
      <UnitId>2</UnitId>
    </PriceQueryIdsModel>
  </PriceQueryIds>
  <ProdIds>
    <ProdIdApIdModel>
      <ApId>2</ApId>
      <ProdId>1</ProdId>
    </ProdIdApIdModel>
    <ProdIdApIdModel>
      <ApId>2</ApId>
      <ProdId>1</ProdId>
    </ProdIdApIdModel>
  </ProdIds>
  <ProdType xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </ProdType>
  <ShowDisabledCust>true</ShowDisabledCust>
  <ShowDisabledProd>true</ShowDisabledProd>
  <ShowDisabledVend>true</ShowDisabledVend>
  <VendIds xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </VendIds>
</PriceQueryCondition>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

HttpResponseMessage

Name	Type	Additional information
Version	Version	None.
Content	HttpContent	None.
StatusCode	HttpStatusCode	None.
ReasonPhrase	string	None.
Headers	Collection of Object	None.
RequestMessage	HttpRequestMessage	None.
IsSuccessStatusCode	boolean	None.