POST jxc_api/WarehousingList/SearchDetail

Request Information

URI Parameters

None.

Body Parameters

Name	Type	Additional information
Start	date	None.
End	date	None.
VendorIds	Collection of integer	None.
Ids	Collection of integer	None.
WhsStatus	Collection of integer	None.
InvoiceStatus	Collection of integer	None.
Checked	Collection of integer	None.
Keywords	string	None.
AccountingItemId	Collection of integer	None.
DepartmentId	Collection of integer	None.
PageIndex	integer	None.
PageSize	integer	None.
ExportDetails	boolean	None.
Purchaser	Collection of integer	None.
ProdIds	Collection of integer	None.
WhIds	Collection of integer	None.
CreatedBy	Collection of integer	None.
CheckedBy	Collection of integer	None.
InvoiceType	Collection of integer	None.
CustomSearchAndOrderCondition	CustomSearchAndOrderCondition	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.
BillOrigins	Collection of integer	None.

Request Formats

application/json, text/json

Sample:

{
  "Start": "2025-04-04 21:14:39",
  "End": "2025-04-04 21:14:39",
  "VendorIds": [
    1,
    2
  ],
  "Ids": [
    1,
    2
  ],
  "WhsStatus": [
    1,
    2
  ],
  "InvoiceStatus": [
    1,
    2
  ],
  "Checked": [
    1,
    2
  ],
  "Keywords": "sample string 3",
  "AccountingItemId": [
    1,
    2
  ],
  "DepartmentId": [
    1,
    2
  ],
  "PageIndex": 4,
  "PageSize": 5,
  "ExportDetails": true,
  "Purchaser": [
    1,
    2
  ],
  "ProdIds": [
    1,
    2
  ],
  "WhIds": [
    1,
    2
  ],
  "CreatedBy": [
    1,
    2
  ],
  "CheckedBy": [
    1,
    2
  ],
  "InvoiceType": [
    1,
    2
  ],
  "CustomSearchAndOrderCondition": {
    "OrderColumnName": "sample string 1",
    "OrderType": 0,
    "CustomSearchParams": [
      {
        "ColumnName": "sample string 1",
        "Params": [
          {},
          {}
        ]
      },
      {
        "ColumnName": "sample string 1",
        "Params": [
          {},
          {}
        ]
      }
    ]
  },
  "ExportType": 1,
  "CurrUserSn": 7,
  "CanViewAllBill": true,
  "CanOpeAllWh": true,
  "OpeWhList": [
    1,
    2
  ],
  "DocumentDateType": 10,
  "DocumentDateArr": [
    "2025-04-04 21:14:39",
    "2025-04-04 21:14:39"
  ],
  "DeliveryDateType": 11,
  "DeliveryDateArr": [
    "2025-04-04 21:14:39",
    "2025-04-04 21:14:39"
  ],
  "OffDateType": 12,
  "OffDateArr": [
    "2025-04-04 21:14:39",
    "2025-04-04 21:14:39"
  ],
  "InventoryDateType": 13,
  "InventoryDateArr": [
    "2025-04-04 21:14:39",
    "2025-04-04 21:14:39"
  ],
  "BillOrigins": [
    1,
    2
  ]
}

application/xml, text/xml

Sample:

<WhsSearchConditions xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/LemonScm.Model.NewApi.Purchase">
  <_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-04T21:14:39.917571+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T21:14:39.917571+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">11</_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-04T21:14:39.917571+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T21:14:39.917571+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">10</_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-04T21:14:39.917571+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T21:14:39.917571+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">13</_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-04T21:14:39.917571+08:00</d2p1:dateTime>
    <d2p1:dateTime>2025-04-04T21:14:39.917571+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">12</_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">7</_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_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_CustomSearchAndOrderCondition_x003E_k__BackingField 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>
  </_x003C_CustomSearchAndOrderCondition_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>2025-04-04T21:14:39.917571+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_InvoiceStatus_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_InvoiceStatus_x003E_k__BackingField>
  <_x003C_InvoiceType_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_InvoiceType_x003E_k__BackingField>
  <_x003C_Keywords_x003E_k__BackingField>sample string 3</_x003C_Keywords_x003E_k__BackingField>
  <_x003C_PageIndex_x003E_k__BackingField>4</_x003C_PageIndex_x003E_k__BackingField>
  <_x003C_PageSize_x003E_k__BackingField>5</_x003C_PageSize_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_Purchaser_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_Purchaser_x003E_k__BackingField>
  <_x003C_Start_x003E_k__BackingField>2025-04-04T21:14:39.917571+08:00</_x003C_Start_x003E_k__BackingField>
  <_x003C_VendorIds_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_VendorIds_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_WhsStatus_x003E_k__BackingField xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:int>1</d2p1:int>
    <d2p1:int>2</d2p1:int>
  </_x003C_WhsStatus_x003E_k__BackingField>
</WhsSearchConditions>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

NewApiPagedListOfWarehousingDetailListModel

Name	Type	Additional information
Items	Collection of WarehousingDetailListModel	None.
SumModel	WarehousingDetailListModel	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": [
    null,
    {
      "AmountFirst": 1.0,
      "AmountDebt": 2.0,
      "AmountSum": 3.0,
      "OfuAmount": -3.0,
      "InvoiceNo": "sample string 5",
      "InvoiceAmount": 6.0,
      "NoInvoiceAmount": 7.0,
      "InvoiceStatus": 1020,
      "InvoiceStatusStr": "部分开票",
      "Expense": 8.0,
      "AcId": 9,
      "AcName": "sample string 10",
      "MultipleAccounts": "sample string 11",
      "PayStatus": 1010,
      "AccInvoices": [
        {
          "InvoiceType": 1010,
          "InvoiceTypeName": "sample string 1",
          "InvoiceDate": "2025-04-04 21:14:39",
          "InvoiceNo": "sample string 3",
          "InvoiceAmount": 4.0
        },
        {
          "InvoiceType": 1010,
          "InvoiceTypeName": "sample string 1",
          "InvoiceDate": "2025-04-04 21:14:39",
          "InvoiceNo": "sample string 3",
          "InvoiceAmount": 4.0
        }
      ],
      "AmountTax": 12.0,
      "Id": 13,
      "WhsEId": 14,
      "IsChecked": true,
      "CheckedStatus": "sample string 16",
      "IsClosed": true,
      "IsGoodsClosed": true,
      "DisplayStatus": "sample string 19",
      "Date": "0001-01-01",
      "DateFmt": "0001-01-01",
      "No": null,
      "BillType": 0,
      "BTypeName": null,
      "VendId": 0,
      "VendName": null,
      "VendNo": null,
      "DeliveryDate": "0001-01-01",
      "CreatedBy": 0,
      "CreatedByName": null,
      "CheckedBy": 0,
      "CheckedByName": null,
      "Note": null,
      "AccountingItemId": 0,
      "AccountingItemName": null,
      "DepartmentId": 0,
      "DepartmentName": null,
      "PurchaserId": 0,
      "PurchaserName": null,
      "PrintCount": null,
      "ProdID": 0,
      "ProdName": null,
      "ProdNo": null,
      "Spec": null,
      "ApID": 0,
      "ApName": null,
      "CatID": 0,
      "CatName": null,
      "Brand": null,
      "ProdLocation": null,
      "WhID": 0,
      "WhName": null,
      "UnitID": 0,
      "UnitName": null,
      "BaseUnitId": 0,
      "BaseUnitName": null,
      "BaseUnitQty": 0.0,
      "GoodsQTY": 0.0,
      "AvailableQty": null,
      "WholeLooseQty": null,
      "GoodsWHSQTY": 0.0,
      "GoodsWHSREALQTY": 0.0,
      "Price": 0.0,
      "PriceTax": 0.0,
      "PriceDis": 0.0,
      "DiscRate": 0.0,
      "DiscAmount": 0.0,
      "DiscAllocation": 0.0,
      "GoodsAmount": 0.0,
      "TaxRate": 0.0,
      "Tax": 0.0,
      "GoodsAmountTax": 0.0,
      "BillDiscRate": 0.0,
      "BillDiscAmount": 0.0,
      "GoodsExpense": 0.0,
      "MainExpense": 0.0,
      "BillDiscAfterAmount": 0.0,
      "BillAmount": 0.0,
      "GoodsNote": null,
      "Image": null,
      "Images": null,
      "StrValue1": null,
      "StrValue2": null,
      "StrValue3": null,
      "StrValue4": null,
      "StrValue5": null,
      "StrValue6": null,
      "StrValue7": null,
      "StrValue8": null,
      "SettlePeriodId": 0,
      "SettlePeriodDate": "",
      "SettlePeriodName": null,
      "InvoiceType": 0,
      "InvoiceTypeName": null,
      "RelaPo": null,
      "RelaWhs": null,
      "RelaSos": null,
      "WhsStatus": 1010,
      "BatchNo": null,
      "ProductionDate": "",
      "LifeTime": 0,
      "LifeTimeUnit": 0,
      "LifeTimeUnitName": "",
      "ExpirationDate": "",
      "BillOrigin": 0,
      "BillOriginDesc": null
    }
  ],
  "SumModel": {
    "AmountFirst": 1.0,
    "AmountDebt": 2.0,
    "AmountSum": 3.0,
    "OfuAmount": -3.0,
    "InvoiceNo": "sample string 5",
    "InvoiceAmount": 6.0,
    "NoInvoiceAmount": 7.0,
    "InvoiceStatus": 1020,
    "InvoiceStatusStr": "部分开票",
    "Expense": 8.0,
    "AcId": 9,
    "AcName": "sample string 10",
    "MultipleAccounts": "sample string 11",
    "PayStatus": 1010,
    "AccInvoices": [
      {
        "InvoiceType": 1010,
        "InvoiceTypeName": "sample string 1",
        "InvoiceDate": "2025-04-04 21:14:39",
        "InvoiceNo": "sample string 3",
        "InvoiceAmount": 4.0
      },
      {
        "InvoiceType": 1010,
        "InvoiceTypeName": "sample string 1",
        "InvoiceDate": "2025-04-04 21:14:39",
        "InvoiceNo": "sample string 3",
        "InvoiceAmount": 4.0
      }
    ],
    "AmountTax": 12.0,
    "Id": 13,
    "WhsEId": 14,
    "IsChecked": true,
    "CheckedStatus": "sample string 16",
    "IsClosed": true,
    "IsGoodsClosed": true,
    "DisplayStatus": "sample string 19",
    "Date": "0001-01-01",
    "DateFmt": "0001-01-01",
    "No": null,
    "BillType": 0,
    "BTypeName": null,
    "VendId": 0,
    "VendName": null,
    "VendNo": null,
    "DeliveryDate": "0001-01-01",
    "CreatedBy": 0,
    "CreatedByName": null,
    "CheckedBy": 0,
    "CheckedByName": null,
    "Note": null,
    "AccountingItemId": 0,
    "AccountingItemName": null,
    "DepartmentId": 0,
    "DepartmentName": null,
    "PurchaserId": 0,
    "PurchaserName": null,
    "PrintCount": null,
    "ProdID": 0,
    "ProdName": null,
    "ProdNo": null,
    "Spec": null,
    "ApID": 0,
    "ApName": null,
    "CatID": 0,
    "CatName": null,
    "Brand": null,
    "ProdLocation": null,
    "WhID": 0,
    "WhName": null,
    "UnitID": 0,
    "UnitName": null,
    "BaseUnitId": 0,
    "BaseUnitName": null,
    "BaseUnitQty": 0.0,
    "GoodsQTY": 0.0,
    "AvailableQty": null,
    "WholeLooseQty": null,
    "GoodsWHSQTY": 0.0,
    "GoodsWHSREALQTY": 0.0,
    "Price": 0.0,
    "PriceTax": 0.0,
    "PriceDis": 0.0,
    "DiscRate": 0.0,
    "DiscAmount": 0.0,
    "DiscAllocation": 0.0,
    "GoodsAmount": 0.0,
    "TaxRate": 0.0,
    "Tax": 0.0,
    "GoodsAmountTax": 0.0,
    "BillDiscRate": 0.0,
    "BillDiscAmount": 0.0,
    "GoodsExpense": 0.0,
    "MainExpense": 0.0,
    "BillDiscAfterAmount": 0.0,
    "BillAmount": 0.0,
    "GoodsNote": null,
    "Image": null,
    "Images": null,
    "StrValue1": null,
    "StrValue2": null,
    "StrValue3": null,
    "StrValue4": null,
    "StrValue5": null,
    "StrValue6": null,
    "StrValue7": null,
    "StrValue8": null,
    "SettlePeriodId": 0,
    "SettlePeriodDate": "",
    "SettlePeriodName": null,
    "InvoiceType": 0,
    "InvoiceTypeName": null,
    "RelaPo": null,
    "RelaWhs": null,
    "RelaSos": null,
    "WhsStatus": 1010,
    "BatchNo": null,
    "ProductionDate": "",
    "LifeTime": 0,
    "LifeTimeUnit": 0,
    "LifeTimeUnitName": "",
    "ExpirationDate": "",
    "BillOrigin": 0,
    "BillOriginDesc": null
  },
  "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

Sample:

Sample not available.

text/xml

Sample:

Sample not available.