Http方法：POST
路由：api/CRM_SaleQuotation/Search

根据条件获得采购询价单数据

请求参数

None.

Body Parameters

条件

SearchModel
参数名称参数描述类型附加信息
Id

主键ID

 integer

None
Code

单据编号

 string

None
StatusText

单据状态

 string

None
CreateDateBegin

创建日期从

 date

None
CreateDateEnd

创建日期到

 date

None

Request Formats

application/json, text/json

Sample: 
{
  "Id": 1,
  "Code": "sample string 1",
  "StatusText": "sample string 2",
  "CreateDateBegin": "2024-04-18T18:07:45.4694457+08:00",
  "CreateDateEnd": "2024-04-18T18:07:45.4694457+08:00"
}

返回响应信息

根据条件获得采购询价单数据

Collection of CRM_SaleQuotation
参数名称参数描述类型附加信息
Quotation_Id

计划单ID

 integer

None
QuotationCode

计划单号

 string

None
Consignor_Id

货主ID

 integer

None
ConsignorCode

货主编号

 string

None
ConsignorName

货主名称

 string

None
Provider_Id

供应商ID

 integer

None
ProviderCode

供应商编号

 string

None
ProviderShortName

供应商名称

 string

None
Linker_Id

联系人ID

 integer

None
LinkerName

联系人

 string

None
SaleChance_Id

销售机会ID

 integer

None
ChanceTitle

关联机会主题

 string

None
SaleChanceCode

关联机会单号

 string

None
ArrivedDate

预计交货日期

 date

None
User_Id

经手人ID

 integer

None
UserTrueName

经手人

 string

None
Dept_Id

部门ID

 integer

None
DeptName

部门

 string

None
ApplyDate

报价日期

 date

None
IsTransferOrder

可转为预到货

 byte

None
TurnOver

交付说明

 string

None
TotalQuantity

合计数量

 integer

None
TotalSaleMoney

合计销售额

 decimal number

None
StatusID

询价单状态ID

 byte

None
StatusText

询价单状态

 string

None
Auditor

审核人

 string

None
Auditing

审核

 byte

None
AuditDate

审核日期

 date

None
Remark

备注

 string

None
CreateID

创建人ID

 integer

None
Creator

创建人

 string

None
CreateDate

创建时间

 date

None
ModifyID

修改人ID

 integer

None
Modifier

修改人

 string

None
ModifyDate

修改时间

 date

None
CRM_SaleQuotationList

Collection of CRM_SaleQuotationList

None
RecordAction

记录操作动作

 RecordAction

None

Response Formats

application/json, text/json

Sample: 
[
  {
    "Quotation_Id": 1,
    "QuotationCode": "sample string 2",
    "Consignor_Id": 1,
    "ConsignorCode": "sample string 3",
    "ConsignorName": "sample string 4",
    "Provider_Id": 5,
    "ProviderCode": "sample string 6",
    "ProviderShortName": "sample string 7",
    "Linker_Id": 1,
    "LinkerName": "sample string 8",
    "SaleChance_Id": 1,
    "ChanceTitle": "sample string 9",
    "SaleChanceCode": "sample string 10",
    "ArrivedDate": "2024-04-18T18:07:45.7062564+08:00",
    "User_Id": 11,
    "UserTrueName": "sample string 12",
    "Dept_Id": 1,
    "DeptName": "sample string 13",
    "ApplyDate": "2024-04-18T18:07:45.707227+08:00",
    "IsTransferOrder": 64,
    "TurnOver": "sample string 14",
    "TotalQuantity": 1,
    "TotalSaleMoney": 1.0,
    "StatusID": 64,
    "StatusText": "sample string 15",
    "Auditor": "sample string 16",
    "Auditing": 64,
    "AuditDate": "2024-04-18T18:07:45.707227+08:00",
    "Remark": "sample string 17",
    "CreateID": 18,
    "Creator": "sample string 19",
    "CreateDate": "2024-04-18T18:07:45.707227+08:00",
    "ModifyID": 1,
    "Modifier": "sample string 20",
    "ModifyDate": "2024-04-18T18:07:45.707227+08:00",
    "CRM_SaleQuotationList": [
      {
        "QuotationList_Id": 1,
        "Quotation_Id": 2,
        "Product_Id": 3,
        "ProductCode": "sample string 4",
        "ProductName": "sample string 5",
        "ProductSpec": "sample string 6",
        "ProductModel": "sample string 7",
        "SmallUnit": "sample string 8",
        "BigUnit": "sample string 9",
        "Quantity": 10,
        "UnitConvert": 1.0,
        "UnitConvertText": "sample string 11",
        "PurchasePrice": 1.0,
        "PurchaseMoney": 1.0,
        "BatchNumber": "sample string 12",
        "ProduceDate": "2024-04-18T18:07:45.7081976+08:00",
        "CustomProduct": 64,
        "AppendParameter": "sample string 13",
        "SingleSignCode": "sample string 14",
        "Rate": 1.0,
        "RatePrice": 1.0,
        "RateMoney": 1.0,
        "Remark": "sample string 15",
        "CreateID": 16,
        "Creator": "sample string 17",
        "CreateDate": "2024-04-18T18:07:45.7091756+08:00",
        "ModifyID": 1,
        "Modifier": "sample string 18",
        "ModifyDate": "2024-04-18T18:07:45.7091756+08:00",
        "OrderList_Id": 1,
        "RecordAction": 0
      },
      {
        "QuotationList_Id": 1,
        "Quotation_Id": 2,
        "Product_Id": 3,
        "ProductCode": "sample string 4",
        "ProductName": "sample string 5",
        "ProductSpec": "sample string 6",
        "ProductModel": "sample string 7",
        "SmallUnit": "sample string 8",
        "BigUnit": "sample string 9",
        "Quantity": 10,
        "UnitConvert": 1.0,
        "UnitConvertText": "sample string 11",
        "PurchasePrice": 1.0,
        "PurchaseMoney": 1.0,
        "BatchNumber": "sample string 12",
        "ProduceDate": "2024-04-18T18:07:45.7081976+08:00",
        "CustomProduct": 64,
        "AppendParameter": "sample string 13",
        "SingleSignCode": "sample string 14",
        "Rate": 1.0,
        "RatePrice": 1.0,
        "RateMoney": 1.0,
        "Remark": "sample string 15",
        "CreateID": 16,
        "Creator": "sample string 17",
        "CreateDate": "2024-04-18T18:07:45.7091756+08:00",
        "ModifyID": 1,
        "Modifier": "sample string 18",
        "ModifyDate": "2024-04-18T18:07:45.7091756+08:00",
        "OrderList_Id": 1,
        "RecordAction": 0
      },
      {
        "QuotationList_Id": 1,
        "Quotation_Id": 2,
        "Product_Id": 3,
        "ProductCode": "sample string 4",
        "ProductName": "sample string 5",
        "ProductSpec": "sample string 6",
        "ProductModel": "sample string 7",
        "SmallUnit": "sample string 8",
        "BigUnit": "sample string 9",
        "Quantity": 10,
        "UnitConvert": 1.0,
        "UnitConvertText": "sample string 11",
        "PurchasePrice": 1.0,
        "PurchaseMoney": 1.0,
        "BatchNumber": "sample string 12",
        "ProduceDate": "2024-04-18T18:07:45.7081976+08:00",
        "CustomProduct": 64,
        "AppendParameter": "sample string 13",
        "SingleSignCode": "sample string 14",
        "Rate": 1.0,
        "RatePrice": 1.0,
        "RateMoney": 1.0,
        "Remark": "sample string 15",
        "CreateID": 16,
        "Creator": "sample string 17",
        "CreateDate": "2024-04-18T18:07:45.7091756+08:00",
        "ModifyID": 1,
        "Modifier": "sample string 18",
        "ModifyDate": "2024-04-18T18:07:45.7091756+08:00",
        "OrderList_Id": 1,
        "RecordAction": 0
      }
    ],
    "RecordAction": 0
  },
  {
    "Quotation_Id": 1,
    "QuotationCode": "sample string 2",
    "Consignor_Id": 1,
    "ConsignorCode": "sample string 3",
    "ConsignorName": "sample string 4",
    "Provider_Id": 5,
    "ProviderCode": "sample string 6",
    "ProviderShortName": "sample string 7",
    "Linker_Id": 1,
    "LinkerName": "sample string 8",
    "SaleChance_Id": 1,
    "ChanceTitle": "sample string 9",
    "SaleChanceCode": "sample string 10",
    "ArrivedDate": "2024-04-18T18:07:45.7062564+08:00",
    "User_Id": 11,
    "UserTrueName": "sample string 12",
    "Dept_Id": 1,
    "DeptName": "sample string 13",
    "ApplyDate": "2024-04-18T18:07:45.707227+08:00",
    "IsTransferOrder": 64,
    "TurnOver": "sample string 14",
    "TotalQuantity": 1,
    "TotalSaleMoney": 1.0,
    "StatusID": 64,
    "StatusText": "sample string 15",
    "Auditor": "sample string 16",
    "Auditing": 64,
    "AuditDate": "2024-04-18T18:07:45.707227+08:00",
    "Remark": "sample string 17",
    "CreateID": 18,
    "Creator": "sample string 19",
    "CreateDate": "2024-04-18T18:07:45.707227+08:00",
    "ModifyID": 1,
    "Modifier": "sample string 20",
    "ModifyDate": "2024-04-18T18:07:45.707227+08:00",
    "CRM_SaleQuotationList": [
      {
        "QuotationList_Id": 1,
        "Quotation_Id": 2,
        "Product_Id": 3,
        "ProductCode": "sample string 4",
        "ProductName": "sample string 5",
        "ProductSpec": "sample string 6",
        "ProductModel": "sample string 7",
        "SmallUnit": "sample string 8",
        "BigUnit": "sample string 9",
        "Quantity": 10,
        "UnitConvert": 1.0,
        "UnitConvertText": "sample string 11",
        "PurchasePrice": 1.0,
        "PurchaseMoney": 1.0,
        "BatchNumber": "sample string 12",
        "ProduceDate": "2024-04-18T18:07:45.7081976+08:00",
        "CustomProduct": 64,
        "AppendParameter": "sample string 13",
        "SingleSignCode": "sample string 14",
        "Rate": 1.0,
        "RatePrice": 1.0,
        "RateMoney": 1.0,
        "Remark": "sample string 15",
        "CreateID": 16,
        "Creator": "sample string 17",
        "CreateDate": "2024-04-18T18:07:45.7091756+08:00",
        "ModifyID": 1,
        "Modifier": "sample string 18",
        "ModifyDate": "2024-04-18T18:07:45.7091756+08:00",
        "OrderList_Id": 1,
        "RecordAction": 0
      },
      {
        "QuotationList_Id": 1,
        "Quotation_Id": 2,
        "Product_Id": 3,
        "ProductCode": "sample string 4",
        "ProductName": "sample string 5",
        "ProductSpec": "sample string 6",
        "ProductModel": "sample string 7",
        "SmallUnit": "sample string 8",
        "BigUnit": "sample string 9",
        "Quantity": 10,
        "UnitConvert": 1.0,
        "UnitConvertText": "sample string 11",
        "PurchasePrice": 1.0,
        "PurchaseMoney": 1.0,
        "BatchNumber": "sample string 12",
        "ProduceDate": "2024-04-18T18:07:45.7081976+08:00",
        "CustomProduct": 64,
        "AppendParameter": "sample string 13",
        "SingleSignCode": "sample string 14",
        "Rate": 1.0,
        "RatePrice": 1.0,
        "RateMoney": 1.0,
        "Remark": "sample string 15",
        "CreateID": 16,
        "Creator": "sample string 17",
        "CreateDate": "2024-04-18T18:07:45.7091756+08:00",
        "ModifyID": 1,
        "Modifier": "sample string 18",
        "ModifyDate": "2024-04-18T18:07:45.7091756+08:00",
        "OrderList_Id": 1,
        "RecordAction": 0
      },
      {
        "QuotationList_Id": 1,
        "Quotation_Id": 2,
        "Product_Id": 3,
        "ProductCode": "sample string 4",
        "ProductName": "sample string 5",
        "ProductSpec": "sample string 6",
        "ProductModel": "sample string 7",
        "SmallUnit": "sample string 8",
        "BigUnit": "sample string 9",
        "Quantity": 10,
        "UnitConvert": 1.0,
        "UnitConvertText": "sample string 11",
        "PurchasePrice": 1.0,
        "PurchaseMoney": 1.0,
        "BatchNumber": "sample string 12",
        "ProduceDate": "2024-04-18T18:07:45.7081976+08:00",
        "CustomProduct": 64,
        "AppendParameter": "sample string 13",
        "SingleSignCode": "sample string 14",
        "Rate": 1.0,
        "RatePrice": 1.0,
        "RateMoney": 1.0,
        "Remark": "sample string 15",
        "CreateID": 16,
        "Creator": "sample string 17",
        "CreateDate": "2024-04-18T18:07:45.7091756+08:00",
        "ModifyID": 1,
        "Modifier": "sample string 18",
        "ModifyDate": "2024-04-18T18:07:45.7091756+08:00",
        "OrderList_Id": 1,
        "RecordAction": 0
      }
    ],
    "RecordAction": 0
  },
  {
    "Quotation_Id": 1,
    "QuotationCode": "sample string 2",
    "Consignor_Id": 1,
    "ConsignorCode": "sample string 3",
    "ConsignorName": "sample string 4",
    "Provider_Id": 5,
    "ProviderCode": "sample string 6",
    "ProviderShortName": "sample string 7",
    "Linker_Id": 1,
    "LinkerName": "sample string 8",
    "SaleChance_Id": 1,
    "ChanceTitle": "sample string 9",
    "SaleChanceCode": "sample string 10",
    "ArrivedDate": "2024-04-18T18:07:45.7062564+08:00",
    "User_Id": 11,
    "UserTrueName": "sample string 12",
    "Dept_Id": 1,
    "DeptName": "sample string 13",
    "ApplyDate": "2024-04-18T18:07:45.707227+08:00",
    "IsTransferOrder": 64,
    "TurnOver": "sample string 14",
    "TotalQuantity": 1,
    "TotalSaleMoney": 1.0,
    "StatusID": 64,
    "StatusText": "sample string 15",
    "Auditor": "sample string 16",
    "Auditing": 64,
    "AuditDate": "2024-04-18T18:07:45.707227+08:00",
    "Remark": "sample string 17",
    "CreateID": 18,
    "Creator": "sample string 19",
    "CreateDate": "2024-04-18T18:07:45.707227+08:00",
    "ModifyID": 1,
    "Modifier": "sample string 20",
    "ModifyDate": "2024-04-18T18:07:45.707227+08:00",
    "CRM_SaleQuotationList": [
      {
        "QuotationList_Id": 1,
        "Quotation_Id": 2,
        "Product_Id": 3,
        "ProductCode": "sample string 4",
        "ProductName": "sample string 5",
        "ProductSpec": "sample string 6",
        "ProductModel": "sample string 7",
        "SmallUnit": "sample string 8",
        "BigUnit": "sample string 9",
        "Quantity": 10,
        "UnitConvert": 1.0,
        "UnitConvertText": "sample string 11",
        "PurchasePrice": 1.0,
        "PurchaseMoney": 1.0,
        "BatchNumber": "sample string 12",
        "ProduceDate": "2024-04-18T18:07:45.7081976+08:00",
        "CustomProduct": 64,
        "AppendParameter": "sample string 13",
        "SingleSignCode": "sample string 14",
        "Rate": 1.0,
        "RatePrice": 1.0,
        "RateMoney": 1.0,
        "Remark": "sample string 15",
        "CreateID": 16,
        "Creator": "sample string 17",
        "CreateDate": "2024-04-18T18:07:45.7091756+08:00",
        "ModifyID": 1,
        "Modifier": "sample string 18",
        "ModifyDate": "2024-04-18T18:07:45.7091756+08:00",
        "OrderList_Id": 1,
        "RecordAction": 0
      },
      {
        "QuotationList_Id": 1,
        "Quotation_Id": 2,
        "Product_Id": 3,
        "ProductCode": "sample string 4",
        "ProductName": "sample string 5",
        "ProductSpec": "sample string 6",
        "ProductModel": "sample string 7",
        "SmallUnit": "sample string 8",
        "BigUnit": "sample string 9",
        "Quantity": 10,
        "UnitConvert": 1.0,
        "UnitConvertText": "sample string 11",
        "PurchasePrice": 1.0,
        "PurchaseMoney": 1.0,
        "BatchNumber": "sample string 12",
        "ProduceDate": "2024-04-18T18:07:45.7081976+08:00",
        "CustomProduct": 64,
        "AppendParameter": "sample string 13",
        "SingleSignCode": "sample string 14",
        "Rate": 1.0,
        "RatePrice": 1.0,
        "RateMoney": 1.0,
        "Remark": "sample string 15",
        "CreateID": 16,
        "Creator": "sample string 17",
        "CreateDate": "2024-04-18T18:07:45.7091756+08:00",
        "ModifyID": 1,
        "Modifier": "sample string 18",
        "ModifyDate": "2024-04-18T18:07:45.7091756+08:00",
        "OrderList_Id": 1,
        "RecordAction": 0
      },
      {
        "QuotationList_Id": 1,
        "Quotation_Id": 2,
        "Product_Id": 3,
        "ProductCode": "sample string 4",
        "ProductName": "sample string 5",
        "ProductSpec": "sample string 6",
        "ProductModel": "sample string 7",
        "SmallUnit": "sample string 8",
        "BigUnit": "sample string 9",
        "Quantity": 10,
        "UnitConvert": 1.0,
        "UnitConvertText": "sample string 11",
        "PurchasePrice": 1.0,
        "PurchaseMoney": 1.0,
        "BatchNumber": "sample string 12",
        "ProduceDate": "2024-04-18T18:07:45.7081976+08:00",
        "CustomProduct": 64,
        "AppendParameter": "sample string 13",
        "SingleSignCode": "sample string 14",
        "Rate": 1.0,
        "RatePrice": 1.0,
        "RateMoney": 1.0,
        "Remark": "sample string 15",
        "CreateID": 16,
        "Creator": "sample string 17",
        "CreateDate": "2024-04-18T18:07:45.7091756+08:00",
        "ModifyID": 1,
        "Modifier": "sample string 18",
        "ModifyDate": "2024-04-18T18:07:45.7091756+08:00",
        "OrderList_Id": 1,
        "RecordAction": 0
      }
    ],
    "RecordAction": 0
  }
]