发货订单复杂查询方法

  • 名称 GetOrderListByPage
    描述 发货订单复杂查询方法
    接口地址 Order/GetOrderListByPage
    HTTP请求方式 POST
  • 请求参数 类型 描述
    param ApiSearchParamsters
    订单查询参数
  • 请求参数示例(Request body formats)

    application/json, text/json
    Sample:
         
         
    {
    • -
      "Search": {
      • -
        "QueryModel": {
        • -
          "Items": [
          • -
            {
            • "Field": "【FIELD】,字符串类型,字段",
            • "Method": "【方法名】,查询方式",
            • "Value": { },
            • "Prefix": "【PREFIX】,字符串类型,前缀,用于标记作用域",
            • "OrGroup": "【ORGROUP】,字符串类型,此值相同的一组Condition 会使用or 拼接起来 并和其他condition 使用and 连接\r\n 当需要使用((A='1' and B='2') or (C='3'))操作,则此值需要维护为 xx,xxx"
            }
          ]
        },
      • -
        "PageInfo": {
        • "CurrentPage": "【CURRENTPAGE】,当前页 , 和SkipCount不能同时赋值, 否则以SkipCount为准",
        • "SkipCount": "【SKIPCOUNT】,跳过条数,和CurrentPage不能同时赋值, 否则以SkipCount为准",
        • "PageSize": "【PAGESIZE】,页大小",
        • "SortField": "【SORTFIELD】,字符串类型,排序字段",
        • "SortDirection": "【SORTDIRECTION】,字符串类型,升序 降序",
        • "IsPaging": true,
        • "TotalCount": "【TOTALCOUNT】,是否分页"
        }
      },
    • "token": "【登录标识】,字符串类型"
    }
    application/xml, text/xml
    Sample:
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    <ApiSearchParamsters xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/SCM.TMS7.WebApi.Common">
    <token>【登录标识】,字符串类型</token>
    <Search xmlns:d2p1="http://schemas.datacontract.org/2004/07/Quantum.FrameWorkCore.EFEx.DynamicSearch">
    <d2p1:PageInfo>
    <d2p1:CurrentPage>1</d2p1:CurrentPage>
    <d2p1:IsPaging>true</d2p1:IsPaging>
    <d2p1:PageSize>3</d2p1:PageSize>
    <d2p1:SkipCount>2</d2p1:SkipCount>
    <d2p1:SortDirection>【SORTDIRECTION】,字符串类型,升序 降序</d2p1:SortDirection>
    <d2p1:SortField>【SORTFIELD】,字符串类型,排序字段</d2p1:SortField>
    <d2p1:TotalCount>7</d2p1:TotalCount>
    </d2p1:PageInfo>
    <d2p1:QueryModel xmlns:d3p1="http://schemas.datacontract.org/2004/07/Quantum.FrameWorkCore.EFEx.DynamicSearch.Model">
    <d3p1:Items>
    <d3p1:ConditionItem>
    <d3p1:Field>【FIELD】,字符串类型,字段</d3p1:Field>
    <d3p1:Method>Equal</d3p1:Method>
    <d3p1:OrGroup>【ORGROUP】,字符串类型,此值相同的一组Condition 会使用or 拼接起来 并和其他condition 使用and 连接
    当需要使用((A='1' and B='2') or (C='3'))操作,则此值需要维护为 xx,xxx</d3p1:OrGroup>
    <d3p1:Prefix>【PREFIX】,字符串类型,前缀,用于标记作用域</d3p1:Prefix>
    <d3p1:Value />
    </d3p1:ConditionItem>
    </d3p1:Items>
    </d2p1:QueryModel>
    </Search>
    </ApiSearchParamsters>
    application/x-www-form-urlencoded
    Sample:

    Failed to generate the sample for media type 'application/x-www-form-urlencoded'. Cannot use formatter 'JQueryMvcFormUrlEncodedFormatter' to write type 'ApiSearchParamsters'.

  • 返回数据示例(Request body formats)

    application/json, text/json
    Sample:
         
         
    { }
    application/xml, text/xml
    Sample:
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    <ApiResultOfPageOfOfOrderInfoQueryDTO73uwOkV65HTuIuy5 xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Quantum.FrameWorkCore.BaseClass">
    <data>
    <list xmlns:d3p1="http://schemas.datacontract.org/2004/07/SCM.TMS7.DTO.OrderInfo">
    <d3p1:OrderInfoQueryDTO>
    <ListUdfDisplays xmlns="http://schemas.datacontract.org/2004/07/Quantum.FrameWorkCore.WebUI.UDF">
    <UdfDisplayForQuery>
    <IsForzen>5</IsForzen>
    <IsHidden>4</IsHidden>
    <PropName>【PROPNAME】,字符串类型,属性名称,包含了DTO上的所有属性,以及UdfRecord中的 RecordName</PropName>
    <SortID>3</SortID>
    <TypeName>【模块名称】,字符串类型,模型名称</TypeName>
    <Width>6</Width>
    </UdfDisplayForQuery>
    </ListUdfDisplays>
    <ListUdfRecords xmlns="http://schemas.datacontract.org/2004/07/Quantum.FrameWorkCore.WebUI.UDF">
    <UdfRecord>
    <RecordID>【RECORDID】,字符串类型,扩展记录ID</RecordID>
    <RecordValue>【RECORDVALUE】,字符串类型,记录值</RecordValue>
    <SetLine>
    <DataType>4</DataType>
    <DdlSource xmlns:d8p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d8p1:KeyValueOfstringstring>
    <d8p1:Key>sample string 1</d8p1:Key>
    <d8p1:Value>sample string 2</d8p1:Value>
    </d8p1:KeyValueOfstringstring>
    </DdlSource>
    <DisplayName>【显示名称】,字符串类型,显示名称</DisplayName>
    <DropDownListSource>【下拉框数据源】,字符串类型,下拉框数据源,数据字典类型的值</DropDownListSource>
    <IsShowInQuery>6</IsShowInQuery>
    <Name>【名称】,字符串类型,名称</Name>
    <TTID>【租户ID】,字符串类型,租户ID</TTID>
    <TypeName>【模块名称】,字符串类型</TypeName>
    </SetLine>
    </UdfRecord>
    </ListUdfRecords>
    <d3p1:ADDRESS_GUID>【ADDRESS_GUID】,字符串类型,最大长度32</d3p1:ADDRESS_GUID>
    <d3p1:DEST_ADDRESS>【目的地地址】,字符串类型</d3p1:DEST_ADDRESS>
    <d3p1:DEST_CITY>【目的地城市】,字符串类型</d3p1:DEST_CITY>
    <d3p1:DEST_CITY_STREET>【目的地街道】,字符串类型</d3p1:DEST_CITY_STREET>
    <d3p1:DEST_CONTACT_NAME>【联系人姓名(D)】,字符串类型</d3p1:DEST_CONTACT_NAME>
    <d3p1:DEST_CONTACT_PHONE>【联系人电话(D)】,字符串类型</d3p1:DEST_CONTACT_PHONE>
    <d3p1:DEST_COUNTRY_CODE_ID>【目的地国家代码】,字符串类型</d3p1:DEST_COUNTRY_CODE_ID>
    <d3p1:DEST_COUNTY_ID>【目的地区(县)】,字符串类型</d3p1:DEST_COUNTY_ID>
    <d3p1:DEST_EMAIL>【联系人邮箱(D)】,字符串类型</d3p1:DEST_EMAIL>
    <d3p1:DEST_FLOOR>90</d3p1:DEST_FLOOR>
    <d3p1:DEST_LATITUED>【目的地纬度】,字符串类型</d3p1:DEST_LATITUED>
    <d3p1:DEST_LOCATION_GID>【目的地GID】,字符串类型</d3p1:DEST_LOCATION_GID>
    <d3p1:DEST_LOCATION_ID>【目的地ID】,字符串类型</d3p1:DEST_LOCATION_ID>
    <d3p1:DEST_LOCATION_NAME>【目的地名称】,字符串类型</d3p1:DEST_LOCATION_NAME>
    <d3p1:DEST_LONGITUDE>【目的地经度】,字符串类型</d3p1:DEST_LONGITUDE>
    <d3p1:DEST_PERIOD>【送货时间段】,字符串类型</d3p1:DEST_PERIOD>
    <d3p1:DEST_PROVINCE>【目的地省份】,字符串类型</d3p1:DEST_PROVINCE>
    <d3p1:DEST_REGION>【目的地地区】,字符串类型</d3p1:DEST_REGION>
    <d3p1:DEST_REMARK>【目的地备注】,字符串类型</d3p1:DEST_REMARK>
    <d3p1:DEST_ZONE1>【目的地区域1】,字符串类型</d3p1:DEST_ZONE1>
    <d3p1:DEST_ZONE1_GID>【目的区域1】,字符串类型</d3p1:DEST_ZONE1_GID>
    <d3p1:DEST_ZONE2>【目的地区域2】,字符串类型</d3p1:DEST_ZONE2>
    <d3p1:DEST_ZONE2_GID>【目的区域2】,字符串类型</d3p1:DEST_ZONE2_GID>
    <d3p1:SRC_ADDRESS>【起始地地址】,字符串类型</d3p1:SRC_ADDRESS>
    <d3p1:SRC_CITY>【起始地城市】,字符串类型</d3p1:SRC_CITY>
    <d3p1:SRC_CITY_STREET>【起始街道】,字符串类型</d3p1:SRC_CITY_STREET>
    <d3p1:SRC_CONTACT_NAME>【联系人姓名(S)】,字符串类型</d3p1:SRC_CONTACT_NAME>
    <d3p1:SRC_CONTACT_PHONE>【联系人电话(S)】,字符串类型</d3p1:SRC_CONTACT_PHONE>
    <d3p1:SRC_COUNTRY_CODE_ID>【起始地国家代码】,字符串类型</d3p1:SRC_COUNTRY_CODE_ID>
    <d3p1:SRC_COUNTY_ID>【起始地区(县)】,字符串类型</d3p1:SRC_COUNTY_ID>
    <d3p1:SRC_EMAIL>【联系人邮箱(S)】,字符串类型</d3p1:SRC_EMAIL>
    <d3p1:SRC_FLOOR>61</d3p1:SRC_FLOOR>
    <d3p1:SRC_LATITUED>【起始地纬度】,字符串类型</d3p1:SRC_LATITUED>
    <d3p1:SRC_LOCATION_GID>【起始地GID】,字符串类型</d3p1:SRC_LOCATION_GID>
    <d3p1:SRC_LOCATION_ID>【起始地ID】,字符串类型</d3p1:SRC_LOCATION_ID>
    <d3p1:SRC_LOCATION_NAME>【起始地名称】,字符串类型</d3p1:SRC_LOCATION_NAME>
    <d3p1:SRC_LONGITUDE>【起始地经度】,字符串类型</d3p1:SRC_LONGITUDE>
    <d3p1:SRC_PERIOD>【提货时间段】,字符串类型</d3p1:SRC_PERIOD>
    <d3p1:SRC_PROVINCE>【起始地省份】,字符串类型</d3p1:SRC_PROVINCE>
    <d3p1:SRC_REGION>【起始地地区】,字符串类型</d3p1:SRC_REGION>
    <d3p1:SRC_REMARK>【起始地备注】,字符串类型</d3p1:SRC_REMARK>
    <d3p1:SRC_ZONE1>【起始地区域1】,字符串类型</d3p1:SRC_ZONE1>
    <d3p1:SRC_ZONE1_GID>【起始区域1】,字符串类型</d3p1:SRC_ZONE1_GID>
    <d3p1:SRC_ZONE2>【起始地区域2】,字符串类型</d3p1:SRC_ZONE2>
    <d3p1:SRC_ZONE2_GID>【起始区域2】,字符串类型</d3p1:SRC_ZONE2_GID>
    <d3p1:APPOINT_STATUS>【预约状态】,字符串类型,最大长度5,值必须为不预约,待预约,已预约等</d3p1:APPOINT_STATUS>
    <d3p1:AUTO_RUN_FLAG>【自动运行标记】,字符串类型,值必须为成功,失败等</d3p1:AUTO_RUN_FLAG>
    <d3p1:CREATED_BY>【创建人】,字符串类型,最大长度40</d3p1:CREATED_BY>
    <d3p1:CREATED_DATE>2016-09-30 10:45:40</d3p1:CREATED_DATE>
    <d3p1:CUSTOMER_GID>【CUSTOMER_GID】,字符串类型,最大长度52</d3p1:CUSTOMER_GID>
    <d3p1:CUSTOMER_ID>【客户ID】,字符串类型,最大长度30</d3p1:CUSTOMER_ID>
    <d3p1:CUSTOMER_NAME>【客户名称】,字符串类型,最大长度32</d3p1:CUSTOMER_NAME>
    <d3p1:CUSTOMS_DECLARE_PLACE>【报关地】,字符串类型,最大长度60</d3p1:CUSTOMS_DECLARE_PLACE>
    <d3p1:C_ORDER_NO>【客户订单号】,字符串类型,最大长度256</d3p1:C_ORDER_NO>
    <d3p1:DOMAIN_NAME>【域】,字符串类型,最大长度10</d3p1:DOMAIN_NAME>
    <d3p1:ERROR_MSG>【异常信息】,字符串类型</d3p1:ERROR_MSG>
    <d3p1:FORECAST_ARRIVE_DATE>2016-09-30 10:45:40</d3p1:FORECAST_ARRIVE_DATE>
    <d3p1:GROSS_VOLUME>21</d3p1:GROSS_VOLUME>
    <d3p1:GROSS_WEIGHT>20</d3p1:GROSS_WEIGHT>
    <d3p1:IMAGE_FLAG>【图片标识】,字符串类型,值必须为附件,加急,议价,关联租户等</d3p1:IMAGE_FLAG>
    <d3p1:INVOICE_NO>【发票号】,字符串类型,最大长度20</d3p1:INVOICE_NO>
    <d3p1:LATE_DELIVERY_DATE>2016-09-30 10:45:40</d3p1:LATE_DELIVERY_DATE>
    <d3p1:LATE_PICKUP_DATE>2016-09-30 10:45:40</d3p1:LATE_PICKUP_DATE>
    <d3p1:NET_WEIGHT>19</d3p1:NET_WEIGHT>
    <d3p1:ORDER_GID>【订单标识】,字符串类型,最大长度80</d3p1:ORDER_GID>
    <d3p1:ORDER_ID>【发货订单ID】,字符串类型,最大长度50</d3p1:ORDER_ID>
    <d3p1:ORDER_RELEASE_TYPE_PSC>【发货订单类型】,字符串类型,最大长度5,值必须为普通单,预约单,退货单,市内单,调拨单等</d3p1:ORDER_RELEASE_TYPE_PSC>
    <d3p1:PACKAGING_COUNT>18</d3p1:PACKAGING_COUNT>
    <d3p1:PLAN_SP_GID>【PLAN_SP_GID】,字符串类型,最大长度52</d3p1:PLAN_SP_GID>
    <d3p1:PLAN_SP_ID>【计划承运商ID】,字符串类型,最大长度30</d3p1:PLAN_SP_ID>
    <d3p1:RELEASE_FROM_TYPE_PSC>【发货订单来源】,字符串类型,最大长度30,值必须为手工录入,系统导入,Milk单,客户单,APP等</d3p1:RELEASE_FROM_TYPE_PSC>
    <d3p1:SALESMAN_CONTACT>【业务员联系方式】,字符串类型,最大长度40</d3p1:SALESMAN_CONTACT>
    <d3p1:SALESMAN_DEPT>【所属业务部门】,字符串类型,最大长度40</d3p1:SALESMAN_DEPT>
    <d3p1:SALESMAN_EMAIL>【业务员邮箱】,字符串类型,最大长度80</d3p1:SALESMAN_EMAIL>
    <d3p1:SALESMAN_NAME>【业务员】,字符串类型,最大长度20</d3p1:SALESMAN_NAME>
    <d3p1:SERVICE_TYPE>【服务类型】,字符串类型,最大长度30,值必须为加急,客户专签等</d3p1:SERVICE_TYPE>
    <d3p1:STATUS>【状态】,字符串类型,最大长度5,值必须为开放,审核,部分计划,完全计划,已到货等</d3p1:STATUS>
    <d3p1:UDF1>【母单号】,字符串类型,最大长度60</d3p1:UDF1>
    <d3p1:UDF10>【UDF10】,字符串类型,最大长度60</d3p1:UDF10>
    <d3p1:UDF2>【专签份数】,字符串类型,最大长度60</d3p1:UDF2>
    <d3p1:UDF3>【UDF3】,字符串类型,最大长度60</d3p1:UDF3>
    <d3p1:UDF4>【UDF4】,字符串类型,最大长度60</d3p1:UDF4>
    <d3p1:UDF5>【UDF5】,字符串类型,最大长度60</d3p1:UDF5>
    <d3p1:UDF6>【UDF6】,字符串类型,最大长度60</d3p1:UDF6>
    <d3p1:UDF7>【UDF7】,字符串类型,最大长度60</d3p1:UDF7>
    <d3p1:UDF8>【UDF8】,字符串类型,最大长度60</d3p1:UDF8>
    <d3p1:UDF9>【UDF9】,字符串类型,最大长度60</d3p1:UDF9>
    <d3p1:UDF_D1>2016-09-30 10:45:40</d3p1:UDF_D1>
    <d3p1:UDF_D2>2016-09-30 10:45:40</d3p1:UDF_D2>
    <d3p1:UDF_N1>40</d3p1:UDF_N1>
    <d3p1:UDF_N2>41</d3p1:UDF_N2>
    </d3p1:OrderInfoQueryDTO>
    </list>
    <pageCount>1</pageCount>
    <pageIndex>2</pageIndex>
    <total>3</total>
    </data>
    <domain>【域】,字符串类型</domain>
    <flag>true</flag>
    <msg>【MSG】,字符串类型</msg>
    <resultCode>1</resultCode>
    <token>【登录标识】,字符串类型</token>
    <ttid>【租户ID】,字符串类型</ttid>
    </ApiResultOfPageOfOfOrderInfoQueryDTO73uwOkV65HTuIuy5>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值