查询执行单用法配置（返回勾选明细）

接口名称：queryUsageOfExecutionSheet
涉及表结构：
SELECT * FROM BASEDATA.BAS_USAGE_EXEC;

SELECT A.*, B.CODE, B.NAME, B.WB_CODE, B.PY_CODE
FROM BASEDATA.BAS_USAGE_EXEC A, BASEDATA.BAS_USAGE B
WHERE A.ORG_CODE = B.ORG_CODE
AND A.USAGE_ID = B.ID
AND A.ORG_CODE = 'BLJZXCSHJ'
AND A.EXEC_LIST_ID = '255953148492398592'
AND A.IS_DELETE = 'N';

https://www.processon.com/f/681c778999215745c2df3893#查询执行单用法配置（返回勾选明细）

请求参数

Header 参数

Token

string

可选

默认值:

7d7bc205-a05f-40a0-a79b-addea1ded679

示例值:

7d7bc205-a05f-40a0-a79b-addea1ded679

appId

string

可选

默认值:

trasen

Body 参数application/json

orgCode

string

机构代码

必需

数据库字段：ORG_CODE

<= 50 字符

hospCode

string | null

院区编码

必需

数据库字段：HOSP_CODE

exeSheetIdList

array[string] | null

执行单ID集合

必需

示例

{
    "orgCode": "string",
    "hospCode": "string",
    "exeSheetIdList": [
        "string"
    ]
}

示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

返回响应

🟢200成功

application/json

Body

Code

string

返回码

必需

200段正常返回 400段业务逻辑错误 500段系统级代码级错误

Message

string

消息

可选

exception

string

详细异常

可选

apiCode

string

接口编码

可选

data

object

必需

list

array[object (MD执行单与用法关系) {16}]

必需

示例

{
    "Code": "string",
    "Message": "string",
    "exception": "string",
    "apiCode": "string",
    "data": {
        "list": [
            {
                "id": "string",
                "orgCode": "string",
                "createDate": "2019-08-24T14:15:22Z",
                "createUserId": "string",
                "createUserName": "string",
                "updateDate": "2019-08-24T14:15:22Z",
                "updateUserId": "string",
                "updateUserName": "string",
                "isDelete": "N",
                "updatekey": "string",
                "usageId": "string",
                "exeSheetId": "string",
                "usageName": "string",
                "usageCode": "string",
                "pyCode": "string",
                "wbCode": "string"
            }
        ]
    }
}