POST jxc_api/Balances/Search

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
StockDate	date	None.
WhIds	Collection of integer	None.
ShowDisableWh	boolean	None.
WhCatId	Collection of integer	None.
WhRange	integer	None.
ProdIds	Collection of integer	None.
CatId	Collection of integer	None.
Spec	string	None.
WithZero	boolean	None.
WithMinus	boolean	None.
ShowDisableProd	boolean	None.
UseAP	boolean	None.
Keyword	string	None.
LoadPrice	boolean	None.
NoneDataAfterWhCatFilter	boolean	None.

Request Formats

application/json, text/json

Sample:

{
  "StockDate": "2024-05-03 14:49:31",
  "WhIds": [
    1,
    2
  ],
  "ShowDisableWh": true,
  "WhCatId": [
    1,
    2
  ],
  "WhRange": 3,
  "ProdIds": [
    1,
    2
  ],
  "CatId": [
    1,
    2
  ],
  "Spec": "sample string 4",
  "WithZero": true,
  "WithMinus": true,
  "ShowDisableProd": true,
  "UseAP": true,
  "Keyword": "sample string 9",
  "LoadPrice": true,
  "NoneDataAfterWhCatFilter": true
}

application/xml, text/xml

Sample:

<StockBalanceSearchCondition xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Stock">
  <_x003C_CatId_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_CatId_x003E_k__BackingField>
  <_x003C_Keyword_x003E_k__BackingField>sample string 9</_x003C_Keyword_x003E_k__BackingField>
  <_x003C_LoadPrice_x003E_k__BackingField>true</_x003C_LoadPrice_x003E_k__BackingField>
  <_x003C_NoneDataAfterWhCatFilter_x003E_k__BackingField>true</_x003C_NoneDataAfterWhCatFilter_x003E_k__BackingField>
  <_x003C_ProdIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_ProdIds_x003E_k__BackingField>
  <_x003C_ShowDisableProd_x003E_k__BackingField>true</_x003C_ShowDisableProd_x003E_k__BackingField>
  <_x003C_ShowDisableWh_x003E_k__BackingField>true</_x003C_ShowDisableWh_x003E_k__BackingField>
  <_x003C_Spec_x003E_k__BackingField>sample string 4</_x003C_Spec_x003E_k__BackingField>
  <_x003C_StockDate_x003E_k__BackingField>2024-05-03T14:49:31.7313754+08:00</_x003C_StockDate_x003E_k__BackingField>
  <_x003C_UseAP_x003E_k__BackingField>true</_x003C_UseAP_x003E_k__BackingField>
  <_x003C_WhCatId_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_WhCatId_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>
  <_x003C_WhRange_x003E_k__BackingField>3</_x003C_WhRange_x003E_k__BackingField>
  <_x003C_WithMinus_x003E_k__BackingField>true</_x003C_WithMinus_x003E_k__BackingField>
  <_x003C_WithZero_x003E_k__BackingField>true</_x003C_WithZero_x003E_k__BackingField>
</StockBalanceSearchCondition>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

ReportResultOfStockBalanceModel

Name	Type	Additional information
DataList	Collection of StockBalanceModel	None.
TotalRow	StockBalanceModel	None.
RDocumentStartDate	string	None.
RDocumentEndDate	string	None.
RDeliveryStartDate	string	None.
RDeliveryEndDate	string	None.

Response Formats

application/json, text/json

Sample:

{
  "DataList": [
    {
      "Id": 1,
      "Status": 2,
      "No": "sample string 3",
      "ProdName": "sample string 4",
      "CatName": "sample string 5",
      "Spec": "sample string 6",
      "Brand": "sample string 7",
      "ProdLocation": "sample string 8",
      "UnitName": "sample string 10",
      "MunitName": "sample string 11",
      "ApId": 12,
      "AssistingProperty": true,
      "IsApRow": true,
      "ApName": "sample string 15",
      "RetPric": 16.0,
      "WsPrice": 17.0,
      "VipPrice": 18.0,
      "PurPrice": 19.0,
      "CompUnitQty": 20.0,
      "CompMunitQty": "sample string 21",
      "CompCost": 22.0,
      "LastOrder": 23,
      "CompUnitCost": 24.0,
      "CompUsableUnitQty": 25.0,
      "Image": "sample string 26",
      "WhList": [
        {
          "WhId": 1,
          "WhName": "sample string 2",
          "UnitQty": 3.0,
          "UsableUnitQty": 4.0,
          "MunitQty": "sample string 5"
        },
        {
          "WhId": 1,
          "WhName": "sample string 2",
          "UnitQty": 3.0,
          "UsableUnitQty": 4.0,
          "MunitQty": "sample string 5"
        }
      ],
      "ProductPrices": [
        {
          "ProdId": 1,
          "LevelId": 2,
          "LevelName": "sample string 3",
          "Price": "sample string 4",
          "UnitId": 5,
          "ApId": 6
        },
        {
          "ProdId": 1,
          "LevelId": 2,
          "LevelName": "sample string 3",
          "Price": "sample string 4",
          "UnitId": 5,
          "ApId": 6
        }
      ]
    },
    {
      "Id": 1,
      "Status": 2,
      "No": "sample string 3",
      "ProdName": "sample string 4",
      "CatName": "sample string 5",
      "Spec": "sample string 6",
      "Brand": "sample string 7",
      "ProdLocation": "sample string 8",
      "UnitName": "sample string 10",
      "MunitName": "sample string 11",
      "ApId": 12,
      "AssistingProperty": true,
      "IsApRow": true,
      "ApName": "sample string 15",
      "RetPric": 16.0,
      "WsPrice": 17.0,
      "VipPrice": 18.0,
      "PurPrice": 19.0,
      "CompUnitQty": 20.0,
      "CompMunitQty": "sample string 21",
      "CompCost": 22.0,
      "LastOrder": 23,
      "CompUnitCost": 24.0,
      "CompUsableUnitQty": 25.0,
      "Image": "sample string 26",
      "WhList": [
        {
          "WhId": 1,
          "WhName": "sample string 2",
          "UnitQty": 3.0,
          "UsableUnitQty": 4.0,
          "MunitQty": "sample string 5"
        },
        {
          "WhId": 1,
          "WhName": "sample string 2",
          "UnitQty": 3.0,
          "UsableUnitQty": 4.0,
          "MunitQty": "sample string 5"
        }
      ],
      "ProductPrices": [
        {
          "ProdId": 1,
          "LevelId": 2,
          "LevelName": "sample string 3",
          "Price": "sample string 4",
          "UnitId": 5,
          "ApId": 6
        },
        {
          "ProdId": 1,
          "LevelId": 2,
          "LevelName": "sample string 3",
          "Price": "sample string 4",
          "UnitId": 5,
          "ApId": 6
        }
      ]
    }
  ],
  "TotalRow": {
    "Id": 1,
    "Status": 2,
    "No": "sample string 3",
    "ProdName": "sample string 4",
    "CatName": "sample string 5",
    "Spec": "sample string 6",
    "Brand": "sample string 7",
    "ProdLocation": "sample string 8",
    "UnitName": "sample string 10",
    "MunitName": "sample string 11",
    "ApId": 12,
    "AssistingProperty": true,
    "IsApRow": true,
    "ApName": "sample string 15",
    "RetPric": 16.0,
    "WsPrice": 17.0,
    "VipPrice": 18.0,
    "PurPrice": 19.0,
    "CompUnitQty": 20.0,
    "CompMunitQty": "sample string 21",
    "CompCost": 22.0,
    "LastOrder": 23,
    "CompUnitCost": 24.0,
    "CompUsableUnitQty": 25.0,
    "Image": "sample string 26",
    "WhList": [
      {
        "WhId": 1,
        "WhName": "sample string 2",
        "UnitQty": 3.0,
        "UsableUnitQty": 4.0,
        "MunitQty": "sample string 5"
      },
      {
        "WhId": 1,
        "WhName": "sample string 2",
        "UnitQty": 3.0,
        "UsableUnitQty": 4.0,
        "MunitQty": "sample string 5"
      }
    ],
    "ProductPrices": [
      {
        "ProdId": 1,
        "LevelId": 2,
        "LevelName": "sample string 3",
        "Price": "sample string 4",
        "UnitId": 5,
        "ApId": 6
      },
      {
        "ProdId": 1,
        "LevelId": 2,
        "LevelName": "sample string 3",
        "Price": "sample string 4",
        "UnitId": 5,
        "ApId": 6
      }
    ]
  },
  "RDocumentStartDate": "sample string 1",
  "RDocumentEndDate": "sample string 2",
  "RDeliveryStartDate": "sample string 3",
  "RDeliveryEndDate": "sample string 4"
}

application/xml, text/xml

Sample:

<ReportResultOfStockBalanceModelXjY_Puht2 xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.WebApi">
  <RDeliveryEndDate xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 4</RDeliveryEndDate>
  <RDeliveryStartDate xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 3</RDeliveryStartDate>
  <RDocumentEndDate xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 2</RDocumentEndDate>
  <RDocumentStartDate xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 1</RDocumentStartDate>
  <DataList xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm.WebApi.Areas.Storage.Models">
    <d2p1:StockBalanceModel>
      <d2p1:ApId>12</d2p1:ApId>
      <d2p1:ApName>sample string 15</d2p1:ApName>
      <d2p1:AssistingProperty>true</d2p1:AssistingProperty>
      <d2p1:Brand>sample string 7</d2p1:Brand>
      <d2p1:CatName>sample string 5</d2p1:CatName>
      <d2p1:CompCost>22</d2p1:CompCost>
      <d2p1:CompMunitQty>sample string 21</d2p1:CompMunitQty>
      <d2p1:CompUnitCost>24</d2p1:CompUnitCost>
      <d2p1:CompUnitQty>20</d2p1:CompUnitQty>
      <d2p1:CompUsableUnitQty>25</d2p1:CompUsableUnitQty>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Image>sample string 26</d2p1:Image>
      <d2p1:IsApRow>true</d2p1:IsApRow>
      <d2p1:LastOrder>23</d2p1:LastOrder>
      <d2p1:MunitName>sample string 11</d2p1:MunitName>
      <d2p1:No>sample string 3</d2p1:No>
      <d2p1:ProdLocation>sample string 8</d2p1:ProdLocation>
      <d2p1:ProdName>sample string 4</d2p1:ProdName>
      <d2p1:ProductPrices xmlns:d4p1="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.NewApi.BaseData.Product">
        <d4p1:ProductPriceSimpleModel>
          <d4p1:ApId>6</d4p1:ApId>
          <d4p1:LevelId>2</d4p1:LevelId>
          <d4p1:LevelName>sample string 3</d4p1:LevelName>
          <d4p1:Price>sample string 4</d4p1:Price>
          <d4p1:ProdId>1</d4p1:ProdId>
          <d4p1:UnitId>5</d4p1:UnitId>
        </d4p1:ProductPriceSimpleModel>
        <d4p1:ProductPriceSimpleModel>
          <d4p1:ApId>6</d4p1:ApId>
          <d4p1:LevelId>2</d4p1:LevelId>
          <d4p1:LevelName>sample string 3</d4p1:LevelName>
          <d4p1:Price>sample string 4</d4p1:Price>
          <d4p1:ProdId>1</d4p1:ProdId>
          <d4p1:UnitId>5</d4p1:UnitId>
        </d4p1:ProductPriceSimpleModel>
      </d2p1:ProductPrices>
      <d2p1:PurPrice>19</d2p1:PurPrice>
      <d2p1:RetPric>16</d2p1:RetPric>
      <d2p1:Spec>sample string 6</d2p1:Spec>
      <d2p1:Status>2</d2p1:Status>
      <d2p1:UnitId>9</d2p1:UnitId>
      <d2p1:UnitName>sample string 10</d2p1:UnitName>
      <d2p1:VipPrice>18</d2p1:VipPrice>
      <d2p1:WhList>
        <d2p1:StockBalanceWhModel>
          <d2p1:MunitQty>sample string 5</d2p1:MunitQty>
          <d2p1:UnitQty>3</d2p1:UnitQty>
          <d2p1:UsableUnitQty>4</d2p1:UsableUnitQty>
          <d2p1:WhId>1</d2p1:WhId>
          <d2p1:WhName>sample string 2</d2p1:WhName>
        </d2p1:StockBalanceWhModel>
        <d2p1:StockBalanceWhModel>
          <d2p1:MunitQty>sample string 5</d2p1:MunitQty>
          <d2p1:UnitQty>3</d2p1:UnitQty>
          <d2p1:UsableUnitQty>4</d2p1:UsableUnitQty>
          <d2p1:WhId>1</d2p1:WhId>
          <d2p1:WhName>sample string 2</d2p1:WhName>
        </d2p1:StockBalanceWhModel>
      </d2p1:WhList>
      <d2p1:WsPrice>17</d2p1:WsPrice>
    </d2p1:StockBalanceModel>
    <d2p1:StockBalanceModel>
      <d2p1:ApId>12</d2p1:ApId>
      <d2p1:ApName>sample string 15</d2p1:ApName>
      <d2p1:AssistingProperty>true</d2p1:AssistingProperty>
      <d2p1:Brand>sample string 7</d2p1:Brand>
      <d2p1:CatName>sample string 5</d2p1:CatName>
      <d2p1:CompCost>22</d2p1:CompCost>
      <d2p1:CompMunitQty>sample string 21</d2p1:CompMunitQty>
      <d2p1:CompUnitCost>24</d2p1:CompUnitCost>
      <d2p1:CompUnitQty>20</d2p1:CompUnitQty>
      <d2p1:CompUsableUnitQty>25</d2p1:CompUsableUnitQty>
      <d2p1:Id>1</d2p1:Id>
      <d2p1:Image>sample string 26</d2p1:Image>
      <d2p1:IsApRow>true</d2p1:IsApRow>
      <d2p1:LastOrder>23</d2p1:LastOrder>
      <d2p1:MunitName>sample string 11</d2p1:MunitName>
      <d2p1:No>sample string 3</d2p1:No>
      <d2p1:ProdLocation>sample string 8</d2p1:ProdLocation>
      <d2p1:ProdName>sample string 4</d2p1:ProdName>
      <d2p1:ProductPrices xmlns:d4p1="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.NewApi.BaseData.Product">
        <d4p1:ProductPriceSimpleModel>
          <d4p1:ApId>6</d4p1:ApId>
          <d4p1:LevelId>2</d4p1:LevelId>
          <d4p1:LevelName>sample string 3</d4p1:LevelName>
          <d4p1:Price>sample string 4</d4p1:Price>
          <d4p1:ProdId>1</d4p1:ProdId>
          <d4p1:UnitId>5</d4p1:UnitId>
        </d4p1:ProductPriceSimpleModel>
        <d4p1:ProductPriceSimpleModel>
          <d4p1:ApId>6</d4p1:ApId>
          <d4p1:LevelId>2</d4p1:LevelId>
          <d4p1:LevelName>sample string 3</d4p1:LevelName>
          <d4p1:Price>sample string 4</d4p1:Price>
          <d4p1:ProdId>1</d4p1:ProdId>
          <d4p1:UnitId>5</d4p1:UnitId>
        </d4p1:ProductPriceSimpleModel>
      </d2p1:ProductPrices>
      <d2p1:PurPrice>19</d2p1:PurPrice>
      <d2p1:RetPric>16</d2p1:RetPric>
      <d2p1:Spec>sample string 6</d2p1:Spec>
      <d2p1:Status>2</d2p1:Status>
      <d2p1:UnitId>9</d2p1:UnitId>
      <d2p1:UnitName>sample string 10</d2p1:UnitName>
      <d2p1:VipPrice>18</d2p1:VipPrice>
      <d2p1:WhList>
        <d2p1:StockBalanceWhModel>
          <d2p1:MunitQty>sample string 5</d2p1:MunitQty>
          <d2p1:UnitQty>3</d2p1:UnitQty>
          <d2p1:UsableUnitQty>4</d2p1:UsableUnitQty>
          <d2p1:WhId>1</d2p1:WhId>
          <d2p1:WhName>sample string 2</d2p1:WhName>
        </d2p1:StockBalanceWhModel>
        <d2p1:StockBalanceWhModel>
          <d2p1:MunitQty>sample string 5</d2p1:MunitQty>
          <d2p1:UnitQty>3</d2p1:UnitQty>
          <d2p1:UsableUnitQty>4</d2p1:UsableUnitQty>
          <d2p1:WhId>1</d2p1:WhId>
          <d2p1:WhName>sample string 2</d2p1:WhName>
        </d2p1:StockBalanceWhModel>
      </d2p1:WhList>
      <d2p1:WsPrice>17</d2p1:WsPrice>
    </d2p1:StockBalanceModel>
  </DataList>
  <TotalRow xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm.WebApi.Areas.Storage.Models">
    <d2p1:ApId>12</d2p1:ApId>
    <d2p1:ApName>sample string 15</d2p1:ApName>
    <d2p1:AssistingProperty>true</d2p1:AssistingProperty>
    <d2p1:Brand>sample string 7</d2p1:Brand>
    <d2p1:CatName>sample string 5</d2p1:CatName>
    <d2p1:CompCost>22</d2p1:CompCost>
    <d2p1:CompMunitQty>sample string 21</d2p1:CompMunitQty>
    <d2p1:CompUnitCost>24</d2p1:CompUnitCost>
    <d2p1:CompUnitQty>20</d2p1:CompUnitQty>
    <d2p1:CompUsableUnitQty>25</d2p1:CompUsableUnitQty>
    <d2p1:Id>1</d2p1:Id>
    <d2p1:Image>sample string 26</d2p1:Image>
    <d2p1:IsApRow>true</d2p1:IsApRow>
    <d2p1:LastOrder>23</d2p1:LastOrder>
    <d2p1:MunitName>sample string 11</d2p1:MunitName>
    <d2p1:No>sample string 3</d2p1:No>
    <d2p1:ProdLocation>sample string 8</d2p1:ProdLocation>
    <d2p1:ProdName>sample string 4</d2p1:ProdName>
    <d2p1:ProductPrices xmlns:d3p1="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.NewApi.BaseData.Product">
      <d3p1:ProductPriceSimpleModel>
        <d3p1:ApId>6</d3p1:ApId>
        <d3p1:LevelId>2</d3p1:LevelId>
        <d3p1:LevelName>sample string 3</d3p1:LevelName>
        <d3p1:Price>sample string 4</d3p1:Price>
        <d3p1:ProdId>1</d3p1:ProdId>
        <d3p1:UnitId>5</d3p1:UnitId>
      </d3p1:ProductPriceSimpleModel>
      <d3p1:ProductPriceSimpleModel>
        <d3p1:ApId>6</d3p1:ApId>
        <d3p1:LevelId>2</d3p1:LevelId>
        <d3p1:LevelName>sample string 3</d3p1:LevelName>
        <d3p1:Price>sample string 4</d3p1:Price>
        <d3p1:ProdId>1</d3p1:ProdId>
        <d3p1:UnitId>5</d3p1:UnitId>
      </d3p1:ProductPriceSimpleModel>
    </d2p1:ProductPrices>
    <d2p1:PurPrice>19</d2p1:PurPrice>
    <d2p1:RetPric>16</d2p1:RetPric>
    <d2p1:Spec>sample string 6</d2p1:Spec>
    <d2p1:Status>2</d2p1:Status>
    <d2p1:UnitId>9</d2p1:UnitId>
    <d2p1:UnitName>sample string 10</d2p1:UnitName>
    <d2p1:VipPrice>18</d2p1:VipPrice>
    <d2p1:WhList>
      <d2p1:StockBalanceWhModel>
        <d2p1:MunitQty>sample string 5</d2p1:MunitQty>
        <d2p1:UnitQty>3</d2p1:UnitQty>
        <d2p1:UsableUnitQty>4</d2p1:UsableUnitQty>
        <d2p1:WhId>1</d2p1:WhId>
        <d2p1:WhName>sample string 2</d2p1:WhName>
      </d2p1:StockBalanceWhModel>
      <d2p1:StockBalanceWhModel>
        <d2p1:MunitQty>sample string 5</d2p1:MunitQty>
        <d2p1:UnitQty>3</d2p1:UnitQty>
        <d2p1:UsableUnitQty>4</d2p1:UsableUnitQty>
        <d2p1:WhId>1</d2p1:WhId>
        <d2p1:WhName>sample string 2</d2p1:WhName>
      </d2p1:StockBalanceWhModel>
    </d2p1:WhList>
    <d2p1:WsPrice>17</d2p1:WsPrice>
  </TotalRow>
</ReportResultOfStockBalanceModelXjY_Puht2>