1、查询附件节点信息:
select * from sm_pub_filesystem where filepath = '单据主键' or filepath like '单据主键/%';
2、查询文件信息:
select * from bap_fs_header where path = sm_pub_filesystem.pk_doc;
3、查询文件路径:
select storepath from bap_fs_body where headid = bap_fs_header.guid;
原文链接:https://blog.csdn.net/qq_37729885/article/details/84790906

894

被折叠的 条评论
为什么被折叠?



