2025-12-06 09:49:57 执行时长：12.16秒 sql: select distinct a.id, a.FileName,  'https://oa.china-isc.org.cn/bizattach' + '/GB_PlanDoc/' + a.id + '/002202/' + a.FileName as Url,  'https://oa.china-isc.org.cn/bizattach' + '/GB_PlanDoc/' + a.id + '/002202/' + a.FileName as weburl, e.ClassName as ApproveClass,c.username as UploadBy,UploadOn,  'd:\redsoft\BizAttach\GB_PlanDoc\' + a.id + '\002202\' + a.FileName +'' as path ,b.CodeName as DocType  from GB_PlanDoc a left join Pub_Code b on a.DocumentType = b.CodeID  left join Base_UserV c on a.uploadby = c.UserID  left join GB_ProjectPlan d on a.TaskNo = d.TaskNo  left join Pub_ApproveClass e on d.ApproveClass=e.ClassCode where d.Corp = '5752'  and UploadOn>'2022-12-06'  and (a.DocumentType='214' or a.IsHistry=1)  order by UploadOn desc