注意看下面两个链接
http://127.0.0.1/docs/docs/DocDspExt.jsp?id=40369
http://127.0.0.1/docs/docs/DocDsp.jsp?id=41353
DocDspExt.jsp地址的文档才会把附件存放到/WEAVER/ecology/filesystem目录下。
DocDsp.jsp地址的文档是网页形式的文档,直接插入到数据库,没有附件存放到服务器目录下,是查询不到附件的存放路径的。
select * from formtable_main_180 where danh='MD09-2020110007'
--update formtable_main_180 set ygjg=500000 where danh='MD09-2020110007'
select * from DocImageFile where imagefilename='汽车氧传感器立项报告.pdf'
--或者 (因为文件名称可能存在重复,需要自己确定是哪一项)
select * from workflow_docshareinfo where requestid=134359
--SELECT * FROM DocImageFile WHERE docid in( 75721,74260,74259)
--SELECT * FROM ImageFile WHERE (imagefileid in(SELECT imagefileid FROM DocImageFile WHERE (docid = 74259)))
--SELECT * FROM DocDetail WHERE (docsubject = '传感器耐久性测试机方案及报价20201102-03')
select * from ImageFile where imagefileid in(select imagefileid from DocImageFile where imagefilename='汽车氧传感器立项报告.pdf')
-- 如果已经打开过流程中的附件,会产生预览文件,下面两个表数据也要清空
select * from DocPreviewHtml where imagefileid in(102554,102555,104400)
select * from DocPreviewHtmlImage WHERE imagefileid in(102554,102555,104400)
delete from DocPreviewHtml where imagefileid in(102554,102555,104400)
delete from DocPreviewHtmlImage WHERE imagefileid in(102554,102555,104400)
替代方法就是找到存档文件,把zip里面的文件替换