注意看下面兩個鏈接

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地址的文檔是網(wǎng)頁形式的文檔，直接插入到數(shù)據(jù)庫，沒有附件存放到服務(wù)器目錄下，是查詢不到附件的存放路徑的。

SELECT

imagefileid,

imagefilename,

imagefiletype,

imagefile,

imagefileused,

filerealpath,

iszip,

isencrypt,

fileSize,

downloads,

miniimgpath,

imgsize,

isFTP,

FTPConfigId

FROM ImageFile

WHERE (imagefileid in

(SELECT imagefileid

FROM DocImageFile

WHERE (docid = 40369))

)

下面這個是DocImageFile表的查詢語句

SELECT

id,

docid,

imagefileid,

imagefilename,

imagefiledesc,

imagefilewidth,

imagefileheight,

imagefielsize,

docfiletype,

versionId,

versionDetail,

isextfile,

hasUsedTemplet

FROM DocImageFile

WHERE (id = 41353)

下面這個是DocDetail表的查詢語句

SELECT

id,

maincategory,

subcategory,

seccategory,

doctype,

doclangurage,

docapprovable,

docreplyable,

isreply,

replydocid,

docsubject,

doccontent,

docsharetype,

shareroleid,

docpublishtype,

itemid,

itemmaincategoryid,

hrmresid,

crmid,

projectid,

financeid,

financerefenceid1,

financerefenceid2,

doccreaterid,

docdepartmentid,

doccreatedate,

doccreatetime,

doclastmoduserid,

doclastmoddate,

doclastmodtime,

docapproveuserid,

docapprovedate,

docapprovetime,

docarchiveuserid,

docarchivedate,

docarchivetime,

docstatus,

parentids,

assetid,

ownerid,

keyword,

accessorycount,

replaydoccount,

usertype,

docno,

cancopy,

canremind,

countMark,

sumMark,

sumReadCount,

orderable,

docExtendName,

doccode,

docedition,

doceditionid,

ishistory,

maindoc,

approvetype,

readoptercanprint,

docvaliduserid,

docvaliddate,

docvalidtime,

docpubuserid,

docpubdate,

docpubtime,

docreopenuserid,

docreopendate,

docreopentime,

docinvaluserid,

docinvaldate,

docinvaltime,

doccanceluserid,

doccanceldate,

doccanceltime,

selectedpubmouldid,

checkOutStatus,

checkOutUserId,

checkOutUserType,

checkOutDate,

checkOutTime,

hasUsedTemplet,

invalidationdate,

docCreaterType,

docLastModUserType,

docApproveUserType,

docValidUserType,

docInvalUserType,

docArchiveUserType,

docCancelUserType,

docPubUserType,

docReopenUserType,

ownerType,

canPrintedNum,

hasPrintedNum,

approverequestid,

fromworkflow,

istop,

topdate,

toptime,

topstartdate,

topenddate,

invalidRequestId

FROM DocDetail

WHERE (docsubject = '消防設(shè)備維護(hù)保養(yǎng)合同')

總結(jié)

以上是生活随笔為你收集整理的泛微文档存放在服务器哪个地址,泛微OA根据文档的docid查询文档附件存放的路径...的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。