跳到主要内容

查询BOM资料相关接口

Bom/KndListBom/IndxListBom/TreeBom/ListBom/Detail

接口:Bom/KndList

【基本信息】

信息备注
接口名称查询标准BOM中的大类列表可用于按大类分类标准BOM展示
请求状态GETRESTful方式
接口路径http://localhost:23798/api/Bom/KndList向服务器地址发送GET请求
远程模式http://www.linkerplus.com/api/ext_erp/Bom/KndList远程模式向服务器地址发送GET请求,需要ERP注册号注册远程模式,并在Headers添加sn参数

【请求参数】

Headers

参数名称是否必须参数值备注
Content-Typeapplication/json用于指定数据的传输类型
LoginIde835943e-55c2-4bf0-832d-6f4166592941用户登录的LoginId,取用户登录或账套验证接口返回的LoginId
snMGR_REST_1001远程模式需添加sn参数,MGR_REST_+ERP注册号

【返回数据】

参数名称类型参数值备注
codeint0:表示查询成功
messagestring执行信息
resultobject查询到的信息,JSON格式

返回:

{
"code": 0,
"message": "查询成功。",
"result": {
"data": [
{
"id": "2",
"name": "制成品"
},
{
"id": "3",
"name": "半成品"
}
]
}
}

接口:Bom/IndxList

【基本信息】

信息备注
接口名称查询标准BOM中的中类列表可用于按中类分类标准BOM展示
请求状态GETRESTful方式
接口路径http://localhost:23798/api/Bom/IndxList向服务器地址发送GET请求
远程模式http://www.linkerplus.com/api/ext_erp/Bom/IndxList远程模式向服务器地址发送GET请求,需要ERP注册号注册远程模式,并在Headers添加sn参数

【请求参数】

Headers

参数名称是否必须参数值备注
Content-Typeapplication/json用于指定数据的传输类型
LoginIde835943e-55c2-4bf0-832d-6f4166592941用户登录的LoginId,取用户登录或账套验证接口返回的LoginId
snMGR_REST_1001远程模式需添加sn参数,MGR_REST_+ERP注册号

【返回数据】

参数名称类型参数值备注
codeint0:表示查询成功
messagestring执行信息
resultobject查询到的信息,JSON格式

返回:

{
"code": 0,
"message": "查询成功。",
"result": {
"data": [
{
"IDX_NO": "01",
"UP_IDX": "",
"NAME": "A中类",
"CLS": "",
"REL_CLS": "",
"EFF_DD": "2024-07-24 11:20:41"
}
]
}
}

接口:Bom/Tree

【基本信息】

信息备注
接口名称获取标准BOM树按树形结构展示标准BOM
请求状态POSTRESTful方式
接口路径http://localhost:23798/api/Bom/Tree向服务器地址发送POST请求
远程模式http://www.linkerplus.com/api/ext_erp/Bom/Tree远程模式向服务器地址发送POST请求,需要ERP注册号注册远程模式,并在Headers添加sn参数

【请求参数】

Headers

参数名称是否必须参数值备注
Content-Typeapplication/json用于指定数据的传输类型
LoginIde835943e-55c2-4bf0-832d-6f4166592941用户登录的LoginId,取用户登录或账套验证接口返回的LoginId
snMGR_REST_1001远程模式需添加sn参数,MGR_REST_+ERP注册号

Body

参数名称类型是否必须参数值备注
BOM_NOstring3001->BOM代号

【返回数据】

参数名称类型参数值备注
codeint0:表示查询成功
messagestring执行信息
resultobject查询到的信息,JSON格式

【调用范例】

请求:

{
"BOM_NO": "3001->" // BOM代号
}

返回:

BOM_NO为3001->时的例子:
image-bom-tree-example

{
"code": 0,
"message": "查询成功。",
"result": {
"data": [
{
"BOM_NO": "3001->",
"ITM": 1,
"BOM_LEVEL": 0,
"PARENT_ITM": 1,
"PARENT_BOM_NO": "3001->",
"PRD_NO": "3001",
"PRD_NAME": "A半成品审核",
"SPC": "abenchengpinshenheguige",
"TF_ITM": 0
},
{
"BOM_NO": "3002->",
"ITM": 2,
"BOM_LEVEL": 1,
"PARENT_ITM": 1,
"PARENT_BOM_NO": "3001->",
"PRD_NO": "3002",
"PRD_NAME": "A半成品托外",
"SPC": "abanchengpintuowaiguige",
"TF_ITM": 1
},
{
"BOM_NO": "",
"ITM": 3,
"BOM_LEVEL": 1,
"PARENT_ITM": 1,
"PARENT_BOM_NO": "3001->",
"PRD_NO": "4002",
"PRD_NAME": "原料2",
"SPC": "yuanliao2guige",
"TF_ITM": 2
},
{
"BOM_NO": "3003->",
"ITM": 4,
"BOM_LEVEL": 2,
"PARENT_ITM": 2,
"PARENT_BOM_NO": "3002->",
"PRD_NO": "3003",
"PRD_NAME": "A半成品多层",
"SPC": "",
"TF_ITM": 1
},
{
"BOM_NO": "",
"ITM": 5,
"BOM_LEVEL": 3,
"PARENT_ITM": 4,
"PARENT_BOM_NO": "3003->",
"PRD_NO": "4002",
"PRD_NAME": "原料2",
"SPC": "yuanliao2guige",
"TF_ITM": 1
},
{
"BOM_NO": "",
"ITM": 6,
"BOM_LEVEL": 3,
"PARENT_ITM": 4,
"PARENT_BOM_NO": "3003->",
"PRD_NO": "4003",
"PRD_NAME": "原料1损耗",
"SPC": "yuanliao1sunhaoguige",
"TF_ITM": 2
}
]
}
}

接口:Bom/List

【基本信息】

信息备注
接口名称查询标准BOM列表(分页)分页查询标准BOM
请求状态POSTRESTful方式
接口路径http://localhost:23798/api/Bom/List向服务器地址发送POST请求
远程模式http://www.linkerplus.com/api/ext_erp/Bom/List远程模式向服务器地址发送POST请求,需要ERP注册号注册远程模式,并在Headers添加sn参数

【请求参数】

Headers

参数名称是否必须参数值备注
Content-Typeapplication/json用于指定数据的传输类型
LoginIde835943e-55c2-4bf0-832d-6f4166592941用户登录的LoginId,取用户登录或账套验证接口返回的LoginId
snMGR_REST_1001远程模式需添加sn参数,MGR_REST_+ERP注册号

Body

参数名称类型是否必须参数值备注
TYPEstring"1"或"2""1":按大类查询、"2":按中类查询
OBJ_IDstringTYPE="1"时传大类代号,TYPE="2"时传中类代号TYPE="1"时传大类代号,TYPE="2"时传中类代号
PAGE_INFOobject{"CURRENT_PAGE":1,"PAGE_SIZE":100}包含当前页CURRENT_PAGE、每页大小PAGE_SIZE参数,PAGE_SIZE选传
SEARCH_INFOarray例如:[{"field":"EFF_DD","field_type":"datetime","operator":"range","value":["2023-11-01 00:00:00","2024-12-31 00:00:00"]}]过滤条件,关于field、operator、field_type、value的传值解释见下方SEARCH_INFO传值解释
ORDER_INFOarray例如:[{"field":"BOM_NO","value":"ASC"}]过滤条件,关于field、value的传值解释见下方ORDER_INFO传值解释

SEARCH_INFO传值解释

field:标准BOM表头(MF_BOM)栏位
field_type:暂时只支持string、number、date、datetime类型
operator:根据field_type的不同而不同,详细见下方表格
value:根据field_type、operator的不同而不同,支持字符串和数组

1、field_type:"string" 时operator、value的传值要求:

operatorvalue的格式备注
containstringvalue传字符串
inarrayvalue传字符串数组格式
not_inarrayvalue传字符串数组格式
rangearrayvalue传字符串数组格式,数组且只有2个值
equalstringvalue传字符串
not_equalstringvalue传字符串
nullvalue传值自动忽略,可不传
not_nullvalue传值自动忽略,可不传

2、field_type:"number" 时operator、value的传值要求:

operatorvalue的格式备注
equalnumbervalue传数值,等于
not_equalnumbervalue传数值,不等于
greater_thannumbervalue传数值,大于
less_thannumbervalue传数值,小于
greater_equal_thannumbervalue传数值,大于等于
less_equal_thannumbervalue传数值,小于等于

3、field_type:"date"、field_type:"datetime" 时operator、value的传值要求:

  • date格式:yyyy-MM-dd
  • datetime格式:yyyy-MM-dd HH:mm:ss
operatorvalue的格式备注
equalstringvalue传数值,等于
nullvalue传值自动忽略,可不传
not_nullvalue传值自动忽略,可不传
rangearrayvalue传字符串数组格式,数组且只有2个值,表示起止日期时间
todayvalue传值自动忽略,可不传。表示今天
yesterdayvalue传值自动忽略,可不传。表示昨天
last_7_daysvalue传值自动忽略,可不传。表示最近7天
last_30_daysvalue传值自动忽略,可不传。表示最近30天
this_weekvalue传值自动忽略,可不传。表示本周
this_monthvalue传值自动忽略,可不传。表示本月
this_quartervalue传值自动忽略,可不传。表示本季度
this_yearvalue传值自动忽略,可不传。表示本年
last_weekvalue传值自动忽略,可不传。表示上周
last_monthvalue传值自动忽略,可不传。表示上月
last_quartervalue传值自动忽略,可不传。表示上季度
last_yearvalue传值自动忽略,可不传。表示去年
on_or_after_todayvalue传值自动忽略,可不传。表示大于等于今天
on_or_before_todayvalue传值自动忽略,可不传。表示小于等于今天
after_todayvalue传值自动忽略,可不传。表示大于今天
befor_todayvalue传值自动忽略,可不传。表示小于今天
days_after_todaynumbervalue传天数,如10,表示从今天到今天之后(10天)之间
days_before_todaynumbervalue传天数,如10,表示从今天之前(10天)到今天之间

ORDER_INFO传值解释

默认按标准BOM表头(MF_BOM)的BOM_NO栏位正序排序

field:标准BOM表头(MF_BOM)栏位
value:ASC:正序、DESC:倒序

【返回数据】

参数名称类型参数值备注
codeint0:表示查询成功
messagestring执行信息
resultobject查询到的信息,JSON格式

【调用范例】

请求:

{
//"TYPE": "2", // "1": 按大类查询、"2": 按中类查询
//"OBJ_ID": "********", // TYPE="1"时,传大类代号、TYPE="2"时,传中类代号。其中TYPE="2"按中类查询时,OBJ_ID传"********"或空值时,查询未设置中类信息的标准BOM。
"PAGE_INFO": {
// 必填
"CURRENT_PAGE": 1, //当前第几页
// 可选填
"PAGE_SIZE": 100 // 默认每页100,可传1-1000,超出1000按100查询
},
"SEARCH_INFO": [ // 过滤条件
{
"field": "EFF_DD",
"operator": "range",
"field_type": "datetime",
"value":["2023-11-01 00:00:00", "2024-12-31 00:00:00"]
}
],
"ORDER_INFO": [ // 排序条件
{
"field": "BOM_NO",
"value": "ASC"
}
]
}

返回:

{
"code": 0,
"message": "查询成功。",
"result": {
"total": 3,
"total_page": 1,
"current_total": 3,
"current_page": 1,
"page_size": 100,
"has_pre": false,
"has_next": false,
"data": [
{
"BOM_NO": "3001->",
"NAME": "A半成品审核",
"PRD_NO": "3001",
"PRD_MARK": "",
"PF_NO": "",
"WH_NO": "0000",
"PRD_KND": "3",
"UNIT": "1",
"QTY": "1.00",
"QTY1": "0.00",
"CST_MAKE": "0.00",
"CST_PRD": "0.00",
"CST_MAN": "0.00",
"CST_OUT": "0.00",
"USED_TIME": "",
"CST": "0.00",
"USR_NO": "",
"TREE_STRU": "",
"DEP": "0000",
"PHOTO_BOM": "",
"EC_NO": "",
"VALID_DD": "2024-08-08 00:00:00",
"END_DD": "",
"REM": "",
"USR": "T01",
"CHK_MAN": "T01",
"PRT_SW": "N",
"CPY_SW": "",
"CLS_DATE": "2024-08-08 00:00:00",
"LOCK_MAN": "",
"TIME_CNT": "",
"MAN_CNT": "",
"MCH_CNT": "",
"QTY_DAY": "0.00",
"CST_DMAKE": "0.00",
"CST_DMAN": "0.00",
"CST_DPRD": "0.00",
"CST_DOUT": "0.00",
"UPD_USR": "T01",
"UPD_DD": "2024-08-08 00:00:00",
"CREATE_DD": "2024-08-08 00:00:00",
"EFF_DD": "2024-08-08 17:37:42",
"RECORD_DD": "2024-08-08 17:32:54",
"MD_NO": "",
"GY_NAME": "",
"SPC": "abenchengpinshenheguige",
"IDX_NO": "",
"IDX_NAME": "",
"PRD_CHK": "",
"FORMULA": "",
"PRD_NAME_ENG": "abenchengpinshenhe",
"DEP_NAME": "First Department",
"UNIT_NAME": "个",
"UNIT1_NAME": "",
"WH_NAME": "First Stock"
},
{
"BOM_NO": "3002->",
"NAME": "A半成品托外",
"PRD_NO": "3002",
"PRD_MARK": "",
"PF_NO": "",
"WH_NO": "0000",
"PRD_KND": "3",
"UNIT": "1",
"QTY": "1.00",
"QTY1": "0.00",
"CST_MAKE": "0.00",
"CST_PRD": "0.00",
"CST_MAN": "0.00",
"CST_OUT": "0.00",
"USED_TIME": "",
"CST": "0.00",
"USR_NO": "",
"TREE_STRU": "",
"DEP": "0000",
"PHOTO_BOM": "",
"EC_NO": "",
"VALID_DD": "2024-08-08 00:00:00",
"END_DD": "",
"REM": "",
"USR": "T01",
"CHK_MAN": "T01",
"PRT_SW": "N",
"CPY_SW": "",
"CLS_DATE": "2024-08-08 00:00:00",
"LOCK_MAN": "",
"TIME_CNT": "",
"MAN_CNT": "",
"MCH_CNT": "",
"QTY_DAY": "0.00",
"CST_DMAKE": "0.00",
"CST_DMAN": "0.00",
"CST_DPRD": "0.00",
"CST_DOUT": "0.00",
"UPD_USR": "T01",
"UPD_DD": "2024-08-08 00:00:00",
"CREATE_DD": "2024-08-08 00:00:00",
"EFF_DD": "2024-08-08 17:37:20",
"RECORD_DD": "2024-08-08 17:34:17",
"MD_NO": "",
"GY_NAME": "",
"SPC": "abanchengpintuowaiguige",
"IDX_NO": "",
"IDX_NAME": "",
"PRD_CHK": "",
"FORMULA": "",
"PRD_NAME_ENG": "abanchengpintuowai",
"DEP_NAME": "First Department",
"UNIT_NAME": "个",
"UNIT1_NAME": "",
"WH_NAME": "First Stock"
},
{
"BOM_NO": "3003->",
"NAME": "A半成品多层",
"PRD_NO": "3003",
"PRD_MARK": "",
"PF_NO": "",
"WH_NO": "0000",
"PRD_KND": "3",
"UNIT": "1",
"QTY": "1.00",
"QTY1": "0.00",
"CST_MAKE": "0.00",
"CST_PRD": "0.00",
"CST_MAN": "0.00",
"CST_OUT": "0.00",
"USED_TIME": "",
"CST": "0.00",
"USR_NO": "",
"TREE_STRU": "",
"DEP": "0000",
"PHOTO_BOM": "",
"EC_NO": "",
"VALID_DD": "2024-08-08 00:00:00",
"END_DD": "",
"REM": "",
"USR": "T01",
"CHK_MAN": "T01",
"PRT_SW": "N",
"CPY_SW": "",
"CLS_DATE": "2024-08-08 00:00:00",
"LOCK_MAN": "",
"TIME_CNT": "",
"MAN_CNT": "",
"MCH_CNT": "",
"QTY_DAY": "0.00",
"CST_DMAKE": "0.00",
"CST_DMAN": "0.00",
"CST_DPRD": "0.00",
"CST_DOUT": "0.00",
"UPD_USR": "T01",
"UPD_DD": "2024-08-08 00:00:00",
"CREATE_DD": "2024-08-08 00:00:00",
"EFF_DD": "2024-08-08 17:35:58",
"RECORD_DD": "2024-08-08 17:35:58",
"MD_NO": "",
"GY_NAME": "",
"SPC": "",
"IDX_NO": "",
"IDX_NAME": "",
"PRD_CHK": "",
"FORMULA": "",
"PRD_NAME_ENG": "",
"DEP_NAME": "First Department",
"UNIT_NAME": "个",
"UNIT1_NAME": "",
"WH_NAME": "First Stock"
}
]
}
}

接口:Bom/Detail

【基本信息】

信息备注
接口名称查询标准BOM详细数据查询标准BOM详细数据
请求状态POSTRESTful方式
接口路径http://localhost:23798/api/Bom/Detail向服务器地址发送POST请求
远程模式http://www.linkerplus.com/api/ext_erp/Bom/Detail远程模式向服务器地址发送POST请求,需要ERP注册号注册远程模式,并在Headers添加sn参数

【请求参数】

Headers

参数名称是否必须参数值备注
Content-Typeapplication/json用于指定数据的传输类型
LoginIde835943e-55c2-4bf0-832d-6f4166592941用户登录的LoginId,取用户登录或账套验证接口返回的LoginId
snMGR_REST_1001远程模式需添加sn参数,MGR_REST_+ERP注册号

Body

参数名称类型是否必须参数值备注
BOM_NOstring3001->BOM代号

【返回数据】

参数名称类型参数值备注
codeint0:表示查询成功
messagestring执行信息
resultobject查询到的信息,JSON格式

【调用范例】

请求:

{
"BOM_NO": "3001->" // BOM代号
}

返回:

{
"code": 0,
"message": "查询成功。",
"result": {
"MF_BOM": { // 标准BOM表头数据
"BOM_NO": "3001->",
"NAME": "A半成品审核",
"PRD_NO": "3001",
"PRD_MARK": "",
"PF_NO": "",
"WH_NO": "0000",
"PRD_KND": "3",
"UNIT": "1",
"QTY": "1.00",
"QTY1": "0.00",
"CST_MAKE": "0.00",
"CST_PRD": "0.00",
"CST_MAN": "0.00",
"CST_OUT": "0.00",
"USED_TIME": "",
"CST": "0.00",
"USR_NO": "",
"TREE_STRU": "",
"DEP": "0000",
"PHOTO_BOM": "",
"EC_NO": "",
"VALID_DD": "2024-08-08 00:00:00",
"END_DD": "",
"REM": "",
"USR": "T01",
"CHK_MAN": "T01",
"PRT_SW": "N",
"CPY_SW": "",
"CLS_DATE": "2024-08-08 00:00:00",
"LOCK_MAN": "",
"TIME_CNT": "",
"MAN_CNT": "",
"MCH_CNT": "",
"QTY_DAY": "0.00",
"CST_DMAKE": "0.00",
"CST_DMAN": "0.00",
"CST_DPRD": "0.00",
"CST_DOUT": "0.00",
"UPD_USR": "T01",
"UPD_DD": "2024-08-08 00:00:00",
"CREATE_DD": "2024-08-08 00:00:00",
"EFF_DD": "2024-08-08 17:37:42",
"RECORD_DD": "2024-08-08 17:32:54",
"MD_NO": "",
"GY_NAME": "",
"SPC": "abenchengpinshenheguige",
"DEP_NAME": "First Department",
"WH_NAME": "First Stock"
},
"TF_BOM": [ // 标准BOM表身数据,子件明细
{
"BOM_NO": "3001->",
"ITM": "1",
"PRD_NO": "3002",
"PRD_MARK": "",
"ID_NO": "3002->",
"NAME": "A半成品托外",
"WH_NO": "0000",
"BOM_ID": "",
"UNIT": "1",
"QTY": "1.00",
"QTY1": "0.00",
"LOS_RTO": "",
"CST": "0.00",
"PRD_NO_UP": "",
"EXP_ID": "",
"PRD_NO_CHG": "",
"REM": "",
"START_DD": "",
"END_DD": "",
"ZC_NO": "",
"TW_ID": "1",
"USEIN_NO": "",
"QTY_BAS": "1.00",
"PZ_ID": "",
"CST_MAKE": "0.00",
"CST_MAN": "0.00",
"CST_PRD": "0.00",
"CST_OUT": "0.00",
"UP_CST": "0.0000",
"CHG_DD": "2024-08-08 00:00:00",
"EFF_DD": "2024-08-08 17:37:42",
"EC_NO": "",
"CCC": "",
"WHEREUSE": "",
"OUTPUT_RTO": "",
"FORMULA_CSV": "",
"WHEREUSE_REM": "",
"PRD_FEAT": "",
"ITM_NEW": "",
"ITM_OLD": "",
"UNIT_NAME": "个",
"UNIT1_NAME": "",
"WH_NAME": "First Stock",
"PRD_CHK": "",
"FORMULA": "",
"SPC": "abanchengpintuowaiguige",
"PRD_NAME_ENG": "abanchengpintuowai"
},
{
"BOM_NO": "3001->",
"ITM": "2",
"PRD_NO": "4002",
"PRD_MARK": "",
"ID_NO": "",
"NAME": "原料2",
"WH_NO": "0002",
"BOM_ID": "",
"UNIT": "1",
"QTY": "1.00",
"QTY1": "0.00",
"LOS_RTO": "",
"CST": "0.00",
"PRD_NO_UP": "",
"EXP_ID": "",
"PRD_NO_CHG": "",
"REM": "",
"START_DD": "",
"END_DD": "",
"ZC_NO": "",
"TW_ID": "",
"USEIN_NO": "",
"QTY_BAS": "1.00",
"PZ_ID": "",
"CST_MAKE": "0.00",
"CST_MAN": "0.00",
"CST_PRD": "0.00",
"CST_OUT": "0.00",
"UP_CST": "0.0000",
"CHG_DD": "2024-08-08 00:00:00",
"EFF_DD": "2024-08-08 17:37:42",
"EC_NO": "",
"CCC": "",
"WHEREUSE": "",
"OUTPUT_RTO": "",
"FORMULA_CSV": "",
"WHEREUSE_REM": "",
"PRD_FEAT": "",
"ITM_NEW": "",
"ITM_OLD": "",
"UNIT_NAME": "个",
"UNIT1_NAME": "",
"WH_NAME": "原料仓",
"PRD_CHK": "",
"FORMULA": "",
"SPC": "yuanliao2guige",
"PRD_NAME_ENG": "yuanliao2"
}
],
"TF_BOM2": [] // 标准BOM表身副产品明细
}
}

【备注】

  • 必须在Headers里面传入用户登录或账套验证的LoginId。

  • 自定义字段与普通字段一样的方式返回,自定义字段区分用户。