POST jxc_api/SellOrderSummary/Search

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
SummaryType	SaleSummaryType	None.
ProductIds	Collection of integer	None.
Category	Collection of integer	None.
CustomerIds	Collection of integer	None.
CustTypeId	Collection of integer	None.
SalesId	Collection of integer	None.
DepartmentId	Collection of integer	None.
Keywords	string	None.
BillStart	string	None.
BillEnd	string	None.
WarehouseId	Collection of integer	None.
WhCat	Collection of integer	None.
ShowAP	boolean	None.
WithGrossProfit	boolean	None.
ShowSubtotalRows	boolean	None.
MaxRecCount	integer	None.
ApName	string	None.
ApIds	Collection of integer	None.
Spec	string	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.

Request Formats

application/json, text/json

Sample:

{
  "SummaryType": 1010,
  "ProductIds": [
    1,
    2
  ],
  "Category": [
    1,
    2
  ],
  "CustomerIds": [
    1,
    2
  ],
  "CustTypeId": [
    1,
    2
  ],
  "SalesId": [
    1,
    2
  ],
  "DepartmentId": [
    1,
    2
  ],
  "Keywords": "sample string 1",
  "BillStart": "sample string 2",
  "BillEnd": "sample string 3",
  "WarehouseId": [
    1,
    2
  ],
  "WhCat": [
    1,
    2
  ],
  "ShowAP": true,
  "WithGrossProfit": true,
  "ShowSubtotalRows": true,
  "MaxRecCount": 7,
  "ApName": "sample string 8",
  "ApIds": [
    1,
    2
  ],
  "Spec": "sample string 9",
  "PageIndex": 10,
  "PageSize": 11,
  "UsePager": true,
  "CurrUserSn": 13,
  "CanViewAllBill": true,
  "CanOpeAllWh": true,
  "OpeWhList": [
    1,
    2
  ],
  "DocumentDateType": 16,
  "DocumentDateArr": [
    "2024-11-25 02:41:40",
    "2024-11-25 02:41:40"
  ],
  "DeliveryDateType": 17,
  "DeliveryDateArr": [
    "2024-11-25 02:41:40",
    "2024-11-25 02:41:40"
  ],
  "OffDateType": 18,
  "OffDateArr": [
    "2024-11-25 02:41:40",
    "2024-11-25 02:41:40"
  ],
  "InventoryDateType": 19,
  "InventoryDateArr": [
    "2024-11-25 02:41:40",
    "2024-11-25 02:41:40"
  ]
}

application/xml, text/xml

Sample:

<SoSummarySearchCondition xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.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:41:40.0613508+08:00</d2p1:dateTime>
    <d2p1:dateTime>2024-11-25T02:41:40.0613508+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">17</_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:41:40.0613508+08:00</d2p1:dateTime>
    <d2p1:dateTime>2024-11-25T02:41:40.0613508+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">16</_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:41:40.0613508+08:00</d2p1:dateTime>
    <d2p1:dateTime>2024-11-25T02:41:40.0613508+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">19</_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:41:40.0613508+08:00</d2p1:dateTime>
    <d2p1:dateTime>2024-11-25T02:41:40.0613508+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">18</_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">13</_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_ApIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_ApIds_x003E_k__BackingField>
  <_x003C_ApName_x003E_k__BackingField>sample string 8</_x003C_ApName_x003E_k__BackingField>
  <_x003C_BillEnd_x003E_k__BackingField>sample string 3</_x003C_BillEnd_x003E_k__BackingField>
  <_x003C_BillStart_x003E_k__BackingField>sample string 2</_x003C_BillStart_x003E_k__BackingField>
  <_x003C_Category_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_Category_x003E_k__BackingField>
  <_x003C_CustTypeId_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_CustTypeId_x003E_k__BackingField>
  <_x003C_CustomerIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_CustomerIds_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_Keywords_x003E_k__BackingField>sample string 1</_x003C_Keywords_x003E_k__BackingField>
  <_x003C_MaxRecCount_x003E_k__BackingField>7</_x003C_MaxRecCount_x003E_k__BackingField>
  <_x003C_PageIndex_x003E_k__BackingField>10</_x003C_PageIndex_x003E_k__BackingField>
  <_x003C_PageSize_x003E_k__BackingField>11</_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_SalesId_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_SalesId_x003E_k__BackingField>
  <_x003C_ShowAP_x003E_k__BackingField>true</_x003C_ShowAP_x003E_k__BackingField>
  <_x003C_ShowSubtotalRows_x003E_k__BackingField>true</_x003C_ShowSubtotalRows_x003E_k__BackingField>
  <_x003C_Spec_x003E_k__BackingField>sample string 9</_x003C_Spec_x003E_k__BackingField>
  <_x003C_SummaryType_x003E_k__BackingField>ProductWarehouse</_x003C_SummaryType_x003E_k__BackingField>
  <_x003C_UsePager_x003E_k__BackingField>true</_x003C_UsePager_x003E_k__BackingField>
  <_x003C_WarehouseId_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_WarehouseId_x003E_k__BackingField>
  <_x003C_WhCat_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_WhCat_x003E_k__BackingField>
  <_x003C_WithGrossProfit_x003E_k__BackingField>true</_x003C_WithGrossProfit_x003E_k__BackingField>
</SoSummarySearchCondition>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

ReportResultOfSSummaryModel

Name	Type	Additional information
DataList	Collection of SSummaryModel	None.
TotalRow	SSummaryModel	None.
PageIndex	integer	None.
PageSize	integer	None.
Total	integer	None.
RDocumentStartDate	string	None.
RDocumentEndDate	string	None.
RDeliveryStartDate	string	None.
RDeliveryEndDate	string	None.

Response Formats

application/json, text/json

Sample:

{
  "DataList": [
    {
      "IsCountRow": true,
      "CustId": 2,
      "CustNo": "sample string 3",
      "CustName": "sample string 4",
      "CustTypeName": "sample string 5",
      "Sales": 6,
      "SalesNo": "sample string 7",
      "SalesName": "sample string 8",
      "ProdId": 9,
      "ProdNo": "sample string 10",
      "ProdName": "sample string 11",
      "CatName": "sample string 12",
      "Spec": "sample string 13",
      "ApName": "sample string 14",
      "WhId": 15,
      "WhNo": "sample string 16",
      "WhName": "sample string 17",
      "WhType": "sample string 18",
      "UnitName": "sample string 19",
      "MulQtyDesc": "sample string 20",
      "UnitBaseName": "sample string 21",
      "QTY": 22.0,
      "Price": 23.0,
      "Amount": 24.0,
      "DiscAllocation": 25.0,
      "Tax": 26.0,
      "AmountTax": 27.0,
      "UnitCost": 28.0,
      "SalesCost": 29.0,
      "GrossProfit": 30.0,
      "GrossProfitRate": "125.00%",
      "DepartmentId": 31,
      "DepartmentNo": "sample string 32",
      "DepartmentName": "sample string 33"
    },
    {
      "IsCountRow": true,
      "CustId": 2,
      "CustNo": "sample string 3",
      "CustName": "sample string 4",
      "CustTypeName": "sample string 5",
      "Sales": 6,
      "SalesNo": "sample string 7",
      "SalesName": "sample string 8",
      "ProdId": 9,
      "ProdNo": "sample string 10",
      "ProdName": "sample string 11",
      "CatName": "sample string 12",
      "Spec": "sample string 13",
      "ApName": "sample string 14",
      "WhId": 15,
      "WhNo": "sample string 16",
      "WhName": "sample string 17",
      "WhType": "sample string 18",
      "UnitName": "sample string 19",
      "MulQtyDesc": "sample string 20",
      "UnitBaseName": "sample string 21",
      "QTY": 22.0,
      "Price": 23.0,
      "Amount": 24.0,
      "DiscAllocation": 25.0,
      "Tax": 26.0,
      "AmountTax": 27.0,
      "UnitCost": 28.0,
      "SalesCost": 29.0,
      "GrossProfit": 30.0,
      "GrossProfitRate": "125.00%",
      "DepartmentId": 31,
      "DepartmentNo": "sample string 32",
      "DepartmentName": "sample string 33"
    }
  ],
  "TotalRow": {
    "IsCountRow": true,
    "CustId": 2,
    "CustNo": "sample string 3",
    "CustName": "sample string 4",
    "CustTypeName": "sample string 5",
    "Sales": 6,
    "SalesNo": "sample string 7",
    "SalesName": "sample string 8",
    "ProdId": 9,
    "ProdNo": "sample string 10",
    "ProdName": "sample string 11",
    "CatName": "sample string 12",
    "Spec": "sample string 13",
    "ApName": "sample string 14",
    "WhId": 15,
    "WhNo": "sample string 16",
    "WhName": "sample string 17",
    "WhType": "sample string 18",
    "UnitName": "sample string 19",
    "MulQtyDesc": "sample string 20",
    "UnitBaseName": "sample string 21",
    "QTY": 22.0,
    "Price": 23.0,
    "Amount": 24.0,
    "DiscAllocation": 25.0,
    "Tax": 26.0,
    "AmountTax": 27.0,
    "UnitCost": 28.0,
    "SalesCost": 29.0,
    "GrossProfit": 30.0,
    "GrossProfitRate": "125.00%",
    "DepartmentId": 31,
    "DepartmentNo": "sample string 32",
    "DepartmentName": "sample string 33"
  },
  "PageIndex": 1,
  "PageSize": 2,
  "Total": 3,
  "RDocumentStartDate": "sample string 4",
  "RDocumentEndDate": "sample string 5",
  "RDeliveryStartDate": "sample string 6",
  "RDeliveryEndDate": "sample string 7"
}

application/xml, text/xml

Sample:

<ReportResultOfSSummaryModel8DTg6HPT xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.NewApi">
  <RDeliveryEndDate xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 7</RDeliveryEndDate>
  <RDeliveryStartDate xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 6</RDeliveryStartDate>
  <RDocumentEndDate xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 5</RDocumentEndDate>
  <RDocumentStartDate xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 4</RDocumentStartDate>
  <DataList xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm.WebApi.Areas.Sell.Models">
    <d2p1:SSummaryModel>
      <d2p1:Amount>24</d2p1:Amount>
      <d2p1:AmountTax>27</d2p1:AmountTax>
      <d2p1:ApName>sample string 14</d2p1:ApName>
      <d2p1:CatName>sample string 12</d2p1:CatName>
      <d2p1:CustId>2</d2p1:CustId>
      <d2p1:CustName>sample string 4</d2p1:CustName>
      <d2p1:CustNo>sample string 3</d2p1:CustNo>
      <d2p1:CustTypeName>sample string 5</d2p1:CustTypeName>
      <d2p1:DepartmentId>31</d2p1:DepartmentId>
      <d2p1:DepartmentName>sample string 33</d2p1:DepartmentName>
      <d2p1:DepartmentNo>sample string 32</d2p1:DepartmentNo>
      <d2p1:DiscAllocation>25</d2p1:DiscAllocation>
      <d2p1:GrossProfit>30</d2p1:GrossProfit>
      <d2p1:IsCountRow>true</d2p1:IsCountRow>
      <d2p1:MulQtyDesc>sample string 20</d2p1:MulQtyDesc>
      <d2p1:Price>23</d2p1:Price>
      <d2p1:ProdId>9</d2p1:ProdId>
      <d2p1:ProdName>sample string 11</d2p1:ProdName>
      <d2p1:ProdNo>sample string 10</d2p1:ProdNo>
      <d2p1:QTY>22</d2p1:QTY>
      <d2p1:Sales>6</d2p1:Sales>
      <d2p1:SalesCost>29</d2p1:SalesCost>
      <d2p1:SalesName>sample string 8</d2p1:SalesName>
      <d2p1:SalesNo>sample string 7</d2p1:SalesNo>
      <d2p1:Spec>sample string 13</d2p1:Spec>
      <d2p1:Tax>26</d2p1:Tax>
      <d2p1:UnitBaseName>sample string 21</d2p1:UnitBaseName>
      <d2p1:UnitCost>28</d2p1:UnitCost>
      <d2p1:UnitName>sample string 19</d2p1:UnitName>
      <d2p1:WhId>15</d2p1:WhId>
      <d2p1:WhName>sample string 17</d2p1:WhName>
      <d2p1:WhNo>sample string 16</d2p1:WhNo>
      <d2p1:WhType>sample string 18</d2p1:WhType>
    </d2p1:SSummaryModel>
    <d2p1:SSummaryModel>
      <d2p1:Amount>24</d2p1:Amount>
      <d2p1:AmountTax>27</d2p1:AmountTax>
      <d2p1:ApName>sample string 14</d2p1:ApName>
      <d2p1:CatName>sample string 12</d2p1:CatName>
      <d2p1:CustId>2</d2p1:CustId>
      <d2p1:CustName>sample string 4</d2p1:CustName>
      <d2p1:CustNo>sample string 3</d2p1:CustNo>
      <d2p1:CustTypeName>sample string 5</d2p1:CustTypeName>
      <d2p1:DepartmentId>31</d2p1:DepartmentId>
      <d2p1:DepartmentName>sample string 33</d2p1:DepartmentName>
      <d2p1:DepartmentNo>sample string 32</d2p1:DepartmentNo>
      <d2p1:DiscAllocation>25</d2p1:DiscAllocation>
      <d2p1:GrossProfit>30</d2p1:GrossProfit>
      <d2p1:IsCountRow>true</d2p1:IsCountRow>
      <d2p1:MulQtyDesc>sample string 20</d2p1:MulQtyDesc>
      <d2p1:Price>23</d2p1:Price>
      <d2p1:ProdId>9</d2p1:ProdId>
      <d2p1:ProdName>sample string 11</d2p1:ProdName>
      <d2p1:ProdNo>sample string 10</d2p1:ProdNo>
      <d2p1:QTY>22</d2p1:QTY>
      <d2p1:Sales>6</d2p1:Sales>
      <d2p1:SalesCost>29</d2p1:SalesCost>
      <d2p1:SalesName>sample string 8</d2p1:SalesName>
      <d2p1:SalesNo>sample string 7</d2p1:SalesNo>
      <d2p1:Spec>sample string 13</d2p1:Spec>
      <d2p1:Tax>26</d2p1:Tax>
      <d2p1:UnitBaseName>sample string 21</d2p1:UnitBaseName>
      <d2p1:UnitCost>28</d2p1:UnitCost>
      <d2p1:UnitName>sample string 19</d2p1:UnitName>
      <d2p1:WhId>15</d2p1:WhId>
      <d2p1:WhName>sample string 17</d2p1:WhName>
      <d2p1:WhNo>sample string 16</d2p1:WhNo>
      <d2p1:WhType>sample string 18</d2p1:WhType>
    </d2p1:SSummaryModel>
  </DataList>
  <PageIndex>1</PageIndex>
  <PageSize>2</PageSize>
  <Total>3</Total>
  <TotalRow xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm.WebApi.Areas.Sell.Models">
    <d2p1:Amount>24</d2p1:Amount>
    <d2p1:AmountTax>27</d2p1:AmountTax>
    <d2p1:ApName>sample string 14</d2p1:ApName>
    <d2p1:CatName>sample string 12</d2p1:CatName>
    <d2p1:CustId>2</d2p1:CustId>
    <d2p1:CustName>sample string 4</d2p1:CustName>
    <d2p1:CustNo>sample string 3</d2p1:CustNo>
    <d2p1:CustTypeName>sample string 5</d2p1:CustTypeName>
    <d2p1:DepartmentId>31</d2p1:DepartmentId>
    <d2p1:DepartmentName>sample string 33</d2p1:DepartmentName>
    <d2p1:DepartmentNo>sample string 32</d2p1:DepartmentNo>
    <d2p1:DiscAllocation>25</d2p1:DiscAllocation>
    <d2p1:GrossProfit>30</d2p1:GrossProfit>
    <d2p1:IsCountRow>true</d2p1:IsCountRow>
    <d2p1:MulQtyDesc>sample string 20</d2p1:MulQtyDesc>
    <d2p1:Price>23</d2p1:Price>
    <d2p1:ProdId>9</d2p1:ProdId>
    <d2p1:ProdName>sample string 11</d2p1:ProdName>
    <d2p1:ProdNo>sample string 10</d2p1:ProdNo>
    <d2p1:QTY>22</d2p1:QTY>
    <d2p1:Sales>6</d2p1:Sales>
    <d2p1:SalesCost>29</d2p1:SalesCost>
    <d2p1:SalesName>sample string 8</d2p1:SalesName>
    <d2p1:SalesNo>sample string 7</d2p1:SalesNo>
    <d2p1:Spec>sample string 13</d2p1:Spec>
    <d2p1:Tax>26</d2p1:Tax>
    <d2p1:UnitBaseName>sample string 21</d2p1:UnitBaseName>
    <d2p1:UnitCost>28</d2p1:UnitCost>
    <d2p1:UnitName>sample string 19</d2p1:UnitName>
    <d2p1:WhId>15</d2p1:WhId>
    <d2p1:WhName>sample string 17</d2p1:WhName>
    <d2p1:WhNo>sample string 16</d2p1:WhNo>
    <d2p1:WhType>sample string 18</d2p1:WhType>
  </TotalRow>
</ReportResultOfSSummaryModel8DTg6HPT>