POST jxc_api/OrderBySale/Export

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
Start	date	None.
End	date	None.
DeliveryDateStart	date	None.
DeliveryDateEnd	date	None.
UpdateTimeStart	date	None.
UpdateTimeEnd	date	None.
BillNo	string	None.
Sales	Collection of integer	None.
Sales1	integer	None.
Status	Collection of BillStatus	None.
BillType	integer	None.
Checked	Collection of integer	None.
Keywords	string	None.
Ids	Collection of integer	None.
AccountingItemId	Collection of integer	None.
DepartmentId	Collection of integer	None.
PageIndex	integer	None.
PageSize	integer	None.
ExportDetails	boolean	None.
CustIds	Collection of integer	None.
CategoryId	integer	None.
ProductIds	Collection of integer	None.
WhIds	Collection of integer	None.
CreatedBy	Collection of integer	None.
CheckedBy	Collection of integer	None.
CategoryIds	Collection of integer	None.
MappingItems	ProdWhMapping	None.
SoeIds	Collection of integer	None.
ExportType	ThreeSheetExportType	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.

Request Formats

application/json, text/json

Sample:

{
  "Start": "2024-11-25 02:32:33",
  "End": "2024-11-25 02:32:33",
  "DeliveryDateStart": "2024-11-25 02:32:33",
  "DeliveryDateEnd": "2024-11-25 02:32:33",
  "UpdateTimeStart": "2024-11-25 02:32:33",
  "UpdateTimeEnd": "2024-11-25 02:32:33",
  "BillNo": "sample string 7",
  "Sales": [
    1,
    2
  ],
  "Sales1": 8,
  "Status": [
    1010,
    1010
  ],
  "BillType": 9,
  "Checked": [
    1,
    2
  ],
  "Keywords": "sample string 10",
  "Ids": [
    1,
    2
  ],
  "AccountingItemId": [
    1,
    2
  ],
  "DepartmentId": [
    1,
    2
  ],
  "PageIndex": 11,
  "PageSize": 12,
  "ExportDetails": true,
  "CustIds": [
    1,
    2
  ],
  "CategoryId": 14,
  "ProductIds": [
    1,
    2
  ],
  "WhIds": [
    1,
    2
  ],
  "CreatedBy": [
    1,
    2
  ],
  "CheckedBy": [
    1,
    2
  ],
  "CategoryIds": [
    1,
    2
  ],
  "MappingItems": {
    "isLocked": true,
    "ProdId": 2,
    "WhId": 3
  },
  "SoeIds": [
    1,
    2
  ],
  "ExportType": 1,
  "CurrUserSn": 15,
  "CanViewAllBill": true,
  "CanOpeAllWh": true,
  "OpeWhList": [
    1,
    2
  ],
  "DocumentDateType": 18,
  "DocumentDateArr": [
    "2024-11-25 02:32:33",
    "2024-11-25 02:32:33"
  ],
  "DeliveryDateType": 19,
  "DeliveryDateArr": [
    "2024-11-25 02:32:33",
    "2024-11-25 02:32:33"
  ],
  "OffDateType": 20,
  "OffDateArr": [
    "2024-11-25 02:32:33",
    "2024-11-25 02:32:33"
  ],
  "InventoryDateType": 21,
  "InventoryDateArr": [
    "2024-11-25 02:32:33",
    "2024-11-25 02:32:33"
  ]
}

application/xml, text/xml

Sample:

<SoSearchConditions xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.NewApi.Sell">
  <_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>2024-11-25T02:32:33.1733255+08:00</d2p1:dateTime>
    <d2p1:dateTime>2024-11-25T02:32:33.1733255+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">19</_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>2024-11-25T02:32:33.1733255+08:00</d2p1:dateTime>
    <d2p1:dateTime>2024-11-25T02:32:33.1733255+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">18</_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>2024-11-25T02:32:33.1733255+08:00</d2p1:dateTime>
    <d2p1:dateTime>2024-11-25T02:32:33.1733255+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">21</_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>2024-11-25T02:32:33.1733255+08:00</d2p1:dateTime>
    <d2p1:dateTime>2024-11-25T02:32:33.1733255+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">20</_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">15</_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_AccountingItemId_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_AccountingItemId_x003E_k__BackingField>
  <_x003C_BillNo_x003E_k__BackingField>sample string 7</_x003C_BillNo_x003E_k__BackingField>
  <_x003C_BillType_x003E_k__BackingField>9</_x003C_BillType_x003E_k__BackingField>
  <_x003C_CategoryId_x003E_k__BackingField>14</_x003C_CategoryId_x003E_k__BackingField>
  <_x003C_CategoryIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_CategoryIds_x003E_k__BackingField>
  <_x003C_CheckedBy_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_CheckedBy_x003E_k__BackingField>
  <_x003C_Checked_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_Checked_x003E_k__BackingField>
  <_x003C_CreatedBy_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_CreatedBy_x003E_k__BackingField>
  <_x003C_CustIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_CustIds_x003E_k__BackingField>
  <_x003C_DeliveryDateEnd_x003E_k__BackingField>2024-11-25T02:32:33.1733255+08:00</_x003C_DeliveryDateEnd_x003E_k__BackingField>
  <_x003C_DeliveryDateStart_x003E_k__BackingField>2024-11-25T02:32:33.1733255+08:00</_x003C_DeliveryDateStart_x003E_k__BackingField>
  <_x003C_DepartmentId_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_DepartmentId_x003E_k__BackingField>
  <_x003C_End_x003E_k__BackingField>2024-11-25T02:32:33.1733255+08:00</_x003C_End_x003E_k__BackingField>
  <_x003C_ExportDetails_x003E_k__BackingField>true</_x003C_ExportDetails_x003E_k__BackingField>
  <_x003C_ExportType_x003E_k__BackingField>DETAIL_MERGE_ONLY</_x003C_ExportType_x003E_k__BackingField>
  <_x003C_Ids_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_Ids_x003E_k__BackingField>
  <_x003C_Keywords_x003E_k__BackingField>sample string 10</_x003C_Keywords_x003E_k__BackingField>
  <_x003C_MappingItems_x003E_k__BackingField>
    <ProdId>2</ProdId>
    <WhId>3</WhId>
    <isLocked>true</isLocked>
  </_x003C_MappingItems_x003E_k__BackingField>
  <_x003C_PageIndex_x003E_k__BackingField>11</_x003C_PageIndex_x003E_k__BackingField>
  <_x003C_PageSize_x003E_k__BackingField>12</_x003C_PageSize_x003E_k__BackingField>
  <_x003C_ProductIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_ProductIds_x003E_k__BackingField>
  <_x003C_Sales1_x003E_k__BackingField>8</_x003C_Sales1_x003E_k__BackingField>
  <_x003C_Sales_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_Sales_x003E_k__BackingField>
  <_x003C_SoeIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_SoeIds_x003E_k__BackingField>
  <_x003C_Start_x003E_k__BackingField>2024-11-25T02:32:33.1733255+08:00</_x003C_Start_x003E_k__BackingField>
  <_x003C_Status_x003E_k__BackingField xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm">
    <d2p1:BillStatus>None</d2p1:BillStatus>
    <d2p1:BillStatus>None</d2p1:BillStatus>
  </_x003C_Status_x003E_k__BackingField>
  <_x003C_UpdateTimeEnd_x003E_k__BackingField>2024-11-25T02:32:33.1733255+08:00</_x003C_UpdateTimeEnd_x003E_k__BackingField>
  <_x003C_UpdateTimeStart_x003E_k__BackingField>2024-11-25T02:32:33.1733255+08:00</_x003C_UpdateTimeStart_x003E_k__BackingField>
  <_x003C_WhIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_WhIds_x003E_k__BackingField>
</SoSearchConditions>

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.