POST jxc_api/ProjectedAvailableBalance/Search

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
BillStart	date	None.
BillEnd	date	None.
ProdIds	Collection of integer	None.
ProdCatId	integer	None.
Brand	string	None.
WhIds	Collection of integer	None.
WhCatId	integer	None.
Keyword	string	None.
NoneDataAfterWhCatFilter	boolean	None.
PageIndex	integer	None.
PageSize	integer	None.
IsAp	boolean	None.
ShowDisabled	boolean	None.
WithZero	boolean	None.
IsShowSubTotal	boolean	None.
CustomSearchAndOrderCondition	CustomSearchAndOrderCondition	None.

Request Formats

application/json, text/json

Sample:

{
  "BillStart": "2025-04-05 01:59:29",
  "BillEnd": "2025-04-05 01:59:29",
  "ProdIds": [
    1,
    2
  ],
  "ProdCatId": 1,
  "Brand": "sample string 2",
  "WhIds": [
    1,
    2
  ],
  "WhCatId": 3,
  "Keyword": "sample string 4",
  "NoneDataAfterWhCatFilter": true,
  "PageIndex": 6,
  "PageSize": 7,
  "IsAp": true,
  "ShowDisabled": true,
  "WithZero": true,
  "IsShowSubTotal": true,
  "CustomSearchAndOrderCondition": {
    "OrderColumnName": "sample string 1",
    "OrderType": 0,
    "CustomSearchParams": [
      {
        "ColumnName": "sample string 1",
        "Params": [
          {},
          {}
        ]
      },
      {
        "ColumnName": "sample string 1",
        "Params": [
          {},
          {}
        ]
      }
    ]
  }
}

application/xml, text/xml

Sample:

<ProjectedAvailableBalanceConditions xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Stock">
  <BillEnd>2025-04-05T01:59:29.7799284+08:00</BillEnd>
  <BillStart>2025-04-05T01:59:29.7799284+08:00</BillStart>
  <Brand>sample string 2</Brand>
  <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>
  <IsAp>true</IsAp>
  <IsShowSubTotal>true</IsShowSubTotal>
  <Keyword>sample string 4</Keyword>
  <NoneDataAfterWhCatFilter>true</NoneDataAfterWhCatFilter>
  <PageIndex>6</PageIndex>
  <PageSize>7</PageSize>
  <ProdCatId>1</ProdCatId>
  <ProdIds xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </ProdIds>
  <ShowDisabled>true</ShowDisabled>
  <WhCatId>3</WhCatId>
  <WhIds xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </WhIds>
  <WithZero>true</WithZero>
</ProjectedAvailableBalanceConditions>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

NewApiPagedListOfProjectedAvailableBalanceModel

Name	Type	Additional information
Items	Collection of ProjectedAvailableBalanceModel	None.
SumModel	ProjectedAvailableBalanceModel	None.
PageIndex	integer	None.
PageSize	integer	None.
Total	integer	None.
UsePager	boolean	None.
CategoriesFounded	Collection of integer	None.
RDocumentStartDate	string	None.
RDocumentEndDate	string	None.
RDeliveryStartDate	string	None.
RDeliveryEndDate	string	None.

Response Formats

application/json, text/json

Sample:

{
  "Items": [
    {
      "IsCountRow": true,
      "ProdId": 2,
      "Image": "sample string 3",
      "Images": [
        "sample string 1",
        "sample string 2"
      ],
      "ProdNo": "sample string 4",
      "ProdName": "sample string 5",
      "Ap": 6,
      "ApId": 7,
      "ApName": "sample string 8",
      "Spec": "sample string 9",
      "Brand": "sample string 10",
      "ProdLocation": "sample string 11",
      "CatId": 12,
      "CatNo": "sample string 13",
      "CatName": "sample string 14",
      "UnitID": 15,
      "UnitName": "sample string 16",
      "WhId": 17,
      "WhNo": "sample string 18",
      "WhName": "sample string 19",
      "WhCatNo": "sample string 20",
      "WhCatName": "sample string 21",
      "sumCurrent": 22.0,
      "sumLocked": 23.0,
      "sumAvailable": 24.0,
      "modifiedDate": "2025-04-05 01:59:29",
      "WithZero": true
    },
    {
      "IsCountRow": true,
      "ProdId": 2,
      "Image": "sample string 3",
      "Images": [
        "sample string 1",
        "sample string 2"
      ],
      "ProdNo": "sample string 4",
      "ProdName": "sample string 5",
      "Ap": 6,
      "ApId": 7,
      "ApName": "sample string 8",
      "Spec": "sample string 9",
      "Brand": "sample string 10",
      "ProdLocation": "sample string 11",
      "CatId": 12,
      "CatNo": "sample string 13",
      "CatName": "sample string 14",
      "UnitID": 15,
      "UnitName": "sample string 16",
      "WhId": 17,
      "WhNo": "sample string 18",
      "WhName": "sample string 19",
      "WhCatNo": "sample string 20",
      "WhCatName": "sample string 21",
      "sumCurrent": 22.0,
      "sumLocked": 23.0,
      "sumAvailable": 24.0,
      "modifiedDate": "2025-04-05 01:59:29",
      "WithZero": true
    }
  ],
  "SumModel": {
    "IsCountRow": true,
    "ProdId": 2,
    "Image": "sample string 3",
    "Images": [
      "sample string 1",
      "sample string 2"
    ],
    "ProdNo": "sample string 4",
    "ProdName": "sample string 5",
    "Ap": 6,
    "ApId": 7,
    "ApName": "sample string 8",
    "Spec": "sample string 9",
    "Brand": "sample string 10",
    "ProdLocation": "sample string 11",
    "CatId": 12,
    "CatNo": "sample string 13",
    "CatName": "sample string 14",
    "UnitID": 15,
    "UnitName": "sample string 16",
    "WhId": 17,
    "WhNo": "sample string 18",
    "WhName": "sample string 19",
    "WhCatNo": "sample string 20",
    "WhCatName": "sample string 21",
    "sumCurrent": 22.0,
    "sumLocked": 23.0,
    "sumAvailable": 24.0,
    "modifiedDate": "2025-04-05 01:59:29",
    "WithZero": true
  },
  "PageIndex": 1,
  "PageSize": 2,
  "Total": 3,
  "UsePager": true,
  "CategoriesFounded": [
    1,
    2
  ],
  "RDocumentStartDate": "sample string 5",
  "RDocumentEndDate": "sample string 6",
  "RDeliveryStartDate": "sample string 7",
  "RDeliveryEndDate": "sample string 8"
}

application/xml, text/xml

Sample:

<NewApiPagedListOfProjectedAvailableBalanceModelXjY_Puht2 xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.NewApi">
  <_x003C_RDeliveryEndDate_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 8</_x003C_RDeliveryEndDate_x003E_k__BackingField>
  <_x003C_RDeliveryStartDate_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 7</_x003C_RDeliveryStartDate_x003E_k__BackingField>
  <_x003C_RDocumentEndDate_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 6</_x003C_RDocumentEndDate_x003E_k__BackingField>
  <_x003C_RDocumentStartDate_x003E_k__BackingField xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.Abstraction.CommonData">sample string 5</_x003C_RDocumentStartDate_x003E_k__BackingField>
  <_x003C_CategoriesFounded_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_CategoriesFounded_x003E_k__BackingField>
  <_x003C_Items_x003E_k__BackingField xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm.WebApi.Areas.Storage.Models">
    <d2p1:ProjectedAvailableBalanceModel>
      <d2p1:_x003C_ApId_x003E_k__BackingField>7</d2p1:_x003C_ApId_x003E_k__BackingField>
      <d2p1:_x003C_ApName_x003E_k__BackingField>sample string 8</d2p1:_x003C_ApName_x003E_k__BackingField>
      <d2p1:_x003C_Ap_x003E_k__BackingField>6</d2p1:_x003C_Ap_x003E_k__BackingField>
      <d2p1:_x003C_Brand_x003E_k__BackingField>sample string 10</d2p1:_x003C_Brand_x003E_k__BackingField>
      <d2p1:_x003C_CatId_x003E_k__BackingField>12</d2p1:_x003C_CatId_x003E_k__BackingField>
      <d2p1:_x003C_CatName_x003E_k__BackingField>sample string 14</d2p1:_x003C_CatName_x003E_k__BackingField>
      <d2p1:_x003C_CatNo_x003E_k__BackingField>sample string 13</d2p1:_x003C_CatNo_x003E_k__BackingField>
      <d2p1:_x003C_Image_x003E_k__BackingField>sample string 3</d2p1:_x003C_Image_x003E_k__BackingField>
      <d2p1:_x003C_Images_x003E_k__BackingField xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:string>sample string 1</d4p1:string>
        <d4p1:string>sample string 2</d4p1:string>
      </d2p1:_x003C_Images_x003E_k__BackingField>
      <d2p1:_x003C_IsCountRow_x003E_k__BackingField>true</d2p1:_x003C_IsCountRow_x003E_k__BackingField>
      <d2p1:_x003C_ProdId_x003E_k__BackingField>2</d2p1:_x003C_ProdId_x003E_k__BackingField>
      <d2p1:_x003C_ProdLocation_x003E_k__BackingField>sample string 11</d2p1:_x003C_ProdLocation_x003E_k__BackingField>
      <d2p1:_x003C_ProdName_x003E_k__BackingField>sample string 5</d2p1:_x003C_ProdName_x003E_k__BackingField>
      <d2p1:_x003C_ProdNo_x003E_k__BackingField>sample string 4</d2p1:_x003C_ProdNo_x003E_k__BackingField>
      <d2p1:_x003C_Spec_x003E_k__BackingField>sample string 9</d2p1:_x003C_Spec_x003E_k__BackingField>
      <d2p1:_x003C_UnitID_x003E_k__BackingField>15</d2p1:_x003C_UnitID_x003E_k__BackingField>
      <d2p1:_x003C_UnitName_x003E_k__BackingField>sample string 16</d2p1:_x003C_UnitName_x003E_k__BackingField>
      <d2p1:_x003C_WhCatName_x003E_k__BackingField>sample string 21</d2p1:_x003C_WhCatName_x003E_k__BackingField>
      <d2p1:_x003C_WhCatNo_x003E_k__BackingField>sample string 20</d2p1:_x003C_WhCatNo_x003E_k__BackingField>
      <d2p1:_x003C_WhId_x003E_k__BackingField>17</d2p1:_x003C_WhId_x003E_k__BackingField>
      <d2p1:_x003C_WhName_x003E_k__BackingField>sample string 19</d2p1:_x003C_WhName_x003E_k__BackingField>
      <d2p1:_x003C_WhNo_x003E_k__BackingField>sample string 18</d2p1:_x003C_WhNo_x003E_k__BackingField>
      <d2p1:_x003C_WithZero_x003E_k__BackingField>true</d2p1:_x003C_WithZero_x003E_k__BackingField>
      <d2p1:_x003C_modifiedDate_x003E_k__BackingField>2025-04-05T01:59:29.795615+08:00</d2p1:_x003C_modifiedDate_x003E_k__BackingField>
      <d2p1:_x003C_sumAvailable_x003E_k__BackingField>24</d2p1:_x003C_sumAvailable_x003E_k__BackingField>
      <d2p1:_x003C_sumCurrent_x003E_k__BackingField>22</d2p1:_x003C_sumCurrent_x003E_k__BackingField>
      <d2p1:_x003C_sumLocked_x003E_k__BackingField>23</d2p1:_x003C_sumLocked_x003E_k__BackingField>
    </d2p1:ProjectedAvailableBalanceModel>
    <d2p1:ProjectedAvailableBalanceModel>
      <d2p1:_x003C_ApId_x003E_k__BackingField>7</d2p1:_x003C_ApId_x003E_k__BackingField>
      <d2p1:_x003C_ApName_x003E_k__BackingField>sample string 8</d2p1:_x003C_ApName_x003E_k__BackingField>
      <d2p1:_x003C_Ap_x003E_k__BackingField>6</d2p1:_x003C_Ap_x003E_k__BackingField>
      <d2p1:_x003C_Brand_x003E_k__BackingField>sample string 10</d2p1:_x003C_Brand_x003E_k__BackingField>
      <d2p1:_x003C_CatId_x003E_k__BackingField>12</d2p1:_x003C_CatId_x003E_k__BackingField>
      <d2p1:_x003C_CatName_x003E_k__BackingField>sample string 14</d2p1:_x003C_CatName_x003E_k__BackingField>
      <d2p1:_x003C_CatNo_x003E_k__BackingField>sample string 13</d2p1:_x003C_CatNo_x003E_k__BackingField>
      <d2p1:_x003C_Image_x003E_k__BackingField>sample string 3</d2p1:_x003C_Image_x003E_k__BackingField>
      <d2p1:_x003C_Images_x003E_k__BackingField xmlns:d4p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
        <d4p1:string>sample string 1</d4p1:string>
        <d4p1:string>sample string 2</d4p1:string>
      </d2p1:_x003C_Images_x003E_k__BackingField>
      <d2p1:_x003C_IsCountRow_x003E_k__BackingField>true</d2p1:_x003C_IsCountRow_x003E_k__BackingField>
      <d2p1:_x003C_ProdId_x003E_k__BackingField>2</d2p1:_x003C_ProdId_x003E_k__BackingField>
      <d2p1:_x003C_ProdLocation_x003E_k__BackingField>sample string 11</d2p1:_x003C_ProdLocation_x003E_k__BackingField>
      <d2p1:_x003C_ProdName_x003E_k__BackingField>sample string 5</d2p1:_x003C_ProdName_x003E_k__BackingField>
      <d2p1:_x003C_ProdNo_x003E_k__BackingField>sample string 4</d2p1:_x003C_ProdNo_x003E_k__BackingField>
      <d2p1:_x003C_Spec_x003E_k__BackingField>sample string 9</d2p1:_x003C_Spec_x003E_k__BackingField>
      <d2p1:_x003C_UnitID_x003E_k__BackingField>15</d2p1:_x003C_UnitID_x003E_k__BackingField>
      <d2p1:_x003C_UnitName_x003E_k__BackingField>sample string 16</d2p1:_x003C_UnitName_x003E_k__BackingField>
      <d2p1:_x003C_WhCatName_x003E_k__BackingField>sample string 21</d2p1:_x003C_WhCatName_x003E_k__BackingField>
      <d2p1:_x003C_WhCatNo_x003E_k__BackingField>sample string 20</d2p1:_x003C_WhCatNo_x003E_k__BackingField>
      <d2p1:_x003C_WhId_x003E_k__BackingField>17</d2p1:_x003C_WhId_x003E_k__BackingField>
      <d2p1:_x003C_WhName_x003E_k__BackingField>sample string 19</d2p1:_x003C_WhName_x003E_k__BackingField>
      <d2p1:_x003C_WhNo_x003E_k__BackingField>sample string 18</d2p1:_x003C_WhNo_x003E_k__BackingField>
      <d2p1:_x003C_WithZero_x003E_k__BackingField>true</d2p1:_x003C_WithZero_x003E_k__BackingField>
      <d2p1:_x003C_modifiedDate_x003E_k__BackingField>2025-04-05T01:59:29.795615+08:00</d2p1:_x003C_modifiedDate_x003E_k__BackingField>
      <d2p1:_x003C_sumAvailable_x003E_k__BackingField>24</d2p1:_x003C_sumAvailable_x003E_k__BackingField>
      <d2p1:_x003C_sumCurrent_x003E_k__BackingField>22</d2p1:_x003C_sumCurrent_x003E_k__BackingField>
      <d2p1:_x003C_sumLocked_x003E_k__BackingField>23</d2p1:_x003C_sumLocked_x003E_k__BackingField>
    </d2p1:ProjectedAvailableBalanceModel>
  </_x003C_Items_x003E_k__BackingField>
  <_x003C_PageIndex_x003E_k__BackingField>1</_x003C_PageIndex_x003E_k__BackingField>
  <_x003C_PageSize_x003E_k__BackingField>2</_x003C_PageSize_x003E_k__BackingField>
  <_x003C_SumModel_x003E_k__BackingField xmlns:d2p1="http://schemas.datacontract.org/2004/07/LemonScm.WebApi.Areas.Storage.Models">
    <d2p1:_x003C_ApId_x003E_k__BackingField>7</d2p1:_x003C_ApId_x003E_k__BackingField>
    <d2p1:_x003C_ApName_x003E_k__BackingField>sample string 8</d2p1:_x003C_ApName_x003E_k__BackingField>
    <d2p1:_x003C_Ap_x003E_k__BackingField>6</d2p1:_x003C_Ap_x003E_k__BackingField>
    <d2p1:_x003C_Brand_x003E_k__BackingField>sample string 10</d2p1:_x003C_Brand_x003E_k__BackingField>
    <d2p1:_x003C_CatId_x003E_k__BackingField>12</d2p1:_x003C_CatId_x003E_k__BackingField>
    <d2p1:_x003C_CatName_x003E_k__BackingField>sample string 14</d2p1:_x003C_CatName_x003E_k__BackingField>
    <d2p1:_x003C_CatNo_x003E_k__BackingField>sample string 13</d2p1:_x003C_CatNo_x003E_k__BackingField>
    <d2p1:_x003C_Image_x003E_k__BackingField>sample string 3</d2p1:_x003C_Image_x003E_k__BackingField>
    <d2p1:_x003C_Images_x003E_k__BackingField xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:string>sample string 1</d3p1:string>
      <d3p1:string>sample string 2</d3p1:string>
    </d2p1:_x003C_Images_x003E_k__BackingField>
    <d2p1:_x003C_IsCountRow_x003E_k__BackingField>true</d2p1:_x003C_IsCountRow_x003E_k__BackingField>
    <d2p1:_x003C_ProdId_x003E_k__BackingField>2</d2p1:_x003C_ProdId_x003E_k__BackingField>
    <d2p1:_x003C_ProdLocation_x003E_k__BackingField>sample string 11</d2p1:_x003C_ProdLocation_x003E_k__BackingField>
    <d2p1:_x003C_ProdName_x003E_k__BackingField>sample string 5</d2p1:_x003C_ProdName_x003E_k__BackingField>
    <d2p1:_x003C_ProdNo_x003E_k__BackingField>sample string 4</d2p1:_x003C_ProdNo_x003E_k__BackingField>
    <d2p1:_x003C_Spec_x003E_k__BackingField>sample string 9</d2p1:_x003C_Spec_x003E_k__BackingField>
    <d2p1:_x003C_UnitID_x003E_k__BackingField>15</d2p1:_x003C_UnitID_x003E_k__BackingField>
    <d2p1:_x003C_UnitName_x003E_k__BackingField>sample string 16</d2p1:_x003C_UnitName_x003E_k__BackingField>
    <d2p1:_x003C_WhCatName_x003E_k__BackingField>sample string 21</d2p1:_x003C_WhCatName_x003E_k__BackingField>
    <d2p1:_x003C_WhCatNo_x003E_k__BackingField>sample string 20</d2p1:_x003C_WhCatNo_x003E_k__BackingField>
    <d2p1:_x003C_WhId_x003E_k__BackingField>17</d2p1:_x003C_WhId_x003E_k__BackingField>
    <d2p1:_x003C_WhName_x003E_k__BackingField>sample string 19</d2p1:_x003C_WhName_x003E_k__BackingField>
    <d2p1:_x003C_WhNo_x003E_k__BackingField>sample string 18</d2p1:_x003C_WhNo_x003E_k__BackingField>
    <d2p1:_x003C_WithZero_x003E_k__BackingField>true</d2p1:_x003C_WithZero_x003E_k__BackingField>
    <d2p1:_x003C_modifiedDate_x003E_k__BackingField>2025-04-05T01:59:29.795615+08:00</d2p1:_x003C_modifiedDate_x003E_k__BackingField>
    <d2p1:_x003C_sumAvailable_x003E_k__BackingField>24</d2p1:_x003C_sumAvailable_x003E_k__BackingField>
    <d2p1:_x003C_sumCurrent_x003E_k__BackingField>22</d2p1:_x003C_sumCurrent_x003E_k__BackingField>
    <d2p1:_x003C_sumLocked_x003E_k__BackingField>23</d2p1:_x003C_sumLocked_x003E_k__BackingField>
  </_x003C_SumModel_x003E_k__BackingField>
  <_x003C_Total_x003E_k__BackingField>3</_x003C_Total_x003E_k__BackingField>
  <_x003C_UsePager_x003E_k__BackingField>true</_x003C_UsePager_x003E_k__BackingField>
</NewApiPagedListOfProjectedAvailableBalanceModelXjY_Puht2>