Http方法：POST
路由：api/Base_ProductInfo_Storage/Search
根据条件获得商品库存数据
请求参数
None.
Body Parameters
SearchProductStorageModel| 参数名称 | 参数描述 | 类型 | 附加信息 |
|---|---|---|---|
| Id |
主键ID |
integer |
None |
| Storage_Id |
仓库ID，和仓库编号二选一 |
integer |
None |
| StorageCode |
仓库编号，和仓库ID二选一 |
string |
None |
| ProductCode |
商品编号 |
string |
None |
| CreateDateBegin |
创建日期从 |
date |
None |
| CreateDateEnd |
创建日期到 |
date |
None |
Request Formats
application/json, text/json
Sample:
{
"Id": 1,
"Storage_Id": 1,
"StorageCode": "sample string 1",
"ProductCode": "sample string 2",
"CreateDateBegin": "2025-05-04T19:48:54.7514274+08:00",
"CreateDateEnd": "2025-05-04T19:48:54.7514274+08:00"
}
返回响应信息
根据条件获得商品库存数据
Collection of Base_ProductInfo_Storage| 参数名称 | 参数描述 | 类型 | 附加信息 |
|---|---|---|---|
| DataId |
数据ID |
integer |
None |
| Storage_Id |
仓库ID |
integer |
None |
| StorageName |
仓库名称 |
string |
None |
| Product_Id |
产品ID |
integer |
None |
| ProductCode |
产品编号 |
string |
None |
| ProductName |
产品名称 |
string |
None |
| ProductModel |
条形码 |
string |
None |
| ProductSpec |
产品规格 |
string |
None |
| ProductStorage |
库存量 |
integer |
None |
| PlaceholderStorage |
占位数量 |
integer |
None |
| DamagedStorage |
残品库存量 |
integer |
None |
| ValidQuantity |
有效库存 |
integer |
None |
| TransitStorage |
在途数量 |
integer |
None |
| DestineStorage |
预定数量 |
integer |
None |
| AllocateTransitStorage |
调拨在途数量 |
integer |
None |
| AllocateDestineStorage |
调拨预定数量 |
integer |
None |
| PurchasePrice |
成本价 |
decimal number |
None |
| SalePrice |
市场价 |
decimal number |
None |
| DayPrice |
销售价 |
decimal number |
None |
| VipPrice |
VIP价 |
decimal number |
None |
| ActivityPrice |
活动价 |
decimal number |
None |
| DamagedPurchasePrice |
残品成本价 |
decimal number |
None |
| DamagedPurchaseMoney |
残品成本额 |
decimal number |
None |
| PurchaseMoney |
成本总额 |
decimal number |
None |
| SaleMoney |
销售总额 |
decimal number |
None |
| AdvicePurchaseQuantity |
建议采购量 |
integer |
None |
| AdviceAllocateQuantity |
建议调拨量 |
integer |
None |
| StorageUpper |
库存上限 |
integer |
None |
| StorageLower |
库存下限 |
integer |
None |
| RatePrice |
税价 |
decimal number |
None |
| RateMoney |
价税合计 |
decimal number |
None |
| Cycle |
采购周期 |
integer |
None |
| FirstWeekSaleQuantity |
1-7天销售量 |
integer |
None |
| SecondWeekSaleQuantity |
8-14天销售量 |
integer |
None |
| ThirdWeekSaleQuantity |
15-21天销售量 |
integer |
None |
| FourthWeekSaleQuantity |
22-28天销售量 |
integer |
None |
| MonthSaleQuantity |
最近30天销售量 |
integer |
None |
| PromotQuantity |
促销增量 |
integer |
None |
| CreateID |
创建人ID |
integer |
None |
| Creator |
创建人 |
string |
None |
| CreateDate |
创建时间 |
date |
None |
| ModifyID |
修改人ID |
integer |
None |
| Modifier |
修改人 |
string |
None |
| ModifyDate |
修改时间 |
date |
None |
| Consignor_Id |
货主ID |
integer |
None |
| ConsignorCode |
货主编号 |
string |
None |
| ConsignorName |
货主名称 |
string |
None |
| BatchNumber |
批次号 |
string |
None |
| ProduceDate |
生成日期 |
date |
None |
| RelationCode |
关联码 |
string |
None |
| IsCreateReplenishment |
是否生成补货单 |
byte |
None |
| RecordAction |
记录操作动作 |
RecordAction |
None |
Response Formats
application/json, text/json
Sample:
[
{
"DataId": 1,
"Storage_Id": 2,
"StorageName": "sample string 3",
"Product_Id": 4,
"ProductCode": "sample string 5",
"ProductName": "sample string 6",
"ProductModel": "sample string 7",
"ProductSpec": "sample string 8",
"ProductStorage": 1,
"PlaceholderStorage": 1,
"DamagedStorage": 1,
"ValidQuantity": 1,
"TransitStorage": 1,
"DestineStorage": 1,
"AllocateTransitStorage": 1,
"AllocateDestineStorage": 1,
"PurchasePrice": 1.0,
"SalePrice": 1.0,
"DayPrice": 1.0,
"VipPrice": 1.0,
"ActivityPrice": 1.0,
"DamagedPurchasePrice": 1.0,
"DamagedPurchaseMoney": 1.0,
"PurchaseMoney": 1.0,
"SaleMoney": 1.0,
"AdvicePurchaseQuantity": 1,
"AdviceAllocateQuantity": 1,
"StorageUpper": 1,
"StorageLower": 1,
"RatePrice": 1.0,
"RateMoney": 1.0,
"Cycle": 1,
"FirstWeekSaleQuantity": 1,
"SecondWeekSaleQuantity": 1,
"ThirdWeekSaleQuantity": 1,
"FourthWeekSaleQuantity": 1,
"MonthSaleQuantity": 1,
"PromotQuantity": 1,
"CreateID": 9,
"Creator": "sample string 10",
"CreateDate": "2025-05-04T19:48:54.7514274+08:00",
"ModifyID": 1,
"Modifier": "sample string 11",
"ModifyDate": "2025-05-04T19:48:54.7514274+08:00",
"Consignor_Id": 1,
"ConsignorCode": "sample string 12",
"ConsignorName": "sample string 13",
"BatchNumber": "sample string 14",
"ProduceDate": "2025-05-04T19:48:54.7514274+08:00",
"RelationCode": "sample string 15",
"IsCreateReplenishment": 64,
"RecordAction": 0
},
{
"DataId": 1,
"Storage_Id": 2,
"StorageName": "sample string 3",
"Product_Id": 4,
"ProductCode": "sample string 5",
"ProductName": "sample string 6",
"ProductModel": "sample string 7",
"ProductSpec": "sample string 8",
"ProductStorage": 1,
"PlaceholderStorage": 1,
"DamagedStorage": 1,
"ValidQuantity": 1,
"TransitStorage": 1,
"DestineStorage": 1,
"AllocateTransitStorage": 1,
"AllocateDestineStorage": 1,
"PurchasePrice": 1.0,
"SalePrice": 1.0,
"DayPrice": 1.0,
"VipPrice": 1.0,
"ActivityPrice": 1.0,
"DamagedPurchasePrice": 1.0,
"DamagedPurchaseMoney": 1.0,
"PurchaseMoney": 1.0,
"SaleMoney": 1.0,
"AdvicePurchaseQuantity": 1,
"AdviceAllocateQuantity": 1,
"StorageUpper": 1,
"StorageLower": 1,
"RatePrice": 1.0,
"RateMoney": 1.0,
"Cycle": 1,
"FirstWeekSaleQuantity": 1,
"SecondWeekSaleQuantity": 1,
"ThirdWeekSaleQuantity": 1,
"FourthWeekSaleQuantity": 1,
"MonthSaleQuantity": 1,
"PromotQuantity": 1,
"CreateID": 9,
"Creator": "sample string 10",
"CreateDate": "2025-05-04T19:48:54.7514274+08:00",
"ModifyID": 1,
"Modifier": "sample string 11",
"ModifyDate": "2025-05-04T19:48:54.7514274+08:00",
"Consignor_Id": 1,
"ConsignorCode": "sample string 12",
"ConsignorName": "sample string 13",
"BatchNumber": "sample string 14",
"ProduceDate": "2025-05-04T19:48:54.7514274+08:00",
"RelationCode": "sample string 15",
"IsCreateReplenishment": 64,
"RecordAction": 0
},
{
"DataId": 1,
"Storage_Id": 2,
"StorageName": "sample string 3",
"Product_Id": 4,
"ProductCode": "sample string 5",
"ProductName": "sample string 6",
"ProductModel": "sample string 7",
"ProductSpec": "sample string 8",
"ProductStorage": 1,
"PlaceholderStorage": 1,
"DamagedStorage": 1,
"ValidQuantity": 1,
"TransitStorage": 1,
"DestineStorage": 1,
"AllocateTransitStorage": 1,
"AllocateDestineStorage": 1,
"PurchasePrice": 1.0,
"SalePrice": 1.0,
"DayPrice": 1.0,
"VipPrice": 1.0,
"ActivityPrice": 1.0,
"DamagedPurchasePrice": 1.0,
"DamagedPurchaseMoney": 1.0,
"PurchaseMoney": 1.0,
"SaleMoney": 1.0,
"AdvicePurchaseQuantity": 1,
"AdviceAllocateQuantity": 1,
"StorageUpper": 1,
"StorageLower": 1,
"RatePrice": 1.0,
"RateMoney": 1.0,
"Cycle": 1,
"FirstWeekSaleQuantity": 1,
"SecondWeekSaleQuantity": 1,
"ThirdWeekSaleQuantity": 1,
"FourthWeekSaleQuantity": 1,
"MonthSaleQuantity": 1,
"PromotQuantity": 1,
"CreateID": 9,
"Creator": "sample string 10",
"CreateDate": "2025-05-04T19:48:54.7514274+08:00",
"ModifyID": 1,
"Modifier": "sample string 11",
"ModifyDate": "2025-05-04T19:48:54.7514274+08:00",
"Consignor_Id": 1,
"ConsignorCode": "sample string 12",
"ConsignorName": "sample string 13",
"BatchNumber": "sample string 14",
"ProduceDate": "2025-05-04T19:48:54.7514274+08:00",
"RelationCode": "sample string 15",
"IsCreateReplenishment": 64,
"RecordAction": 0
}
]