#### 將所有的路徑都找出來
```
select fs.ID,fs.Name,fs.Ext,fs.CreateTime,fs.CreateID,u.Name as Uploader,
case when f5.Path IS not null then f5.Path + '/' else '' end +
case when f4.Path IS not null then f4.Path + '/' else '' end +
case when f3.Path IS not null then f3.Path + '/' else '' end + f2.Path+'/'+fs.Path as Path
from Slops.dbo.P_FileRelated pf
inner join Slops.dbo.S_FileSystem fs on fs.ID = pf.FileID
inner join Slops.dbo.H_User u on u.ID = fs.CreateID
inner join Slops.dbo.S_FileSystem f2 on f2.ID = fs.PreID
left join Slops.dbo.S_FileSystem f3 on f3.ID = f2.PreID
left join Slops.dbo.S_FileSystem f4 on f4.ID = f3.PreID
left join Slops.dbo.S_FileSystem f5 on f5.ID = f4.PreID
where pf.RelatedType = 30 and pf.RelatedID = @ID
and fs.Ext in ('.jpg','.JPG','.jpeg','.JPEG','.png','.PNG','.bmp','.BMP')
```
*****
#### 引用照片墻，填寫對應數據
```
hongbo.photoWall({
elem: '#bid-pipeline-scan-detail-showphoto' //照片墻區域
, photoPage: { pageorder: "CreateTime desc" } //sql排序依據
, data: { //sql其他參數
path: 'bid/pipeline/pipe/detail/PhotoList.txt'
, ID: top.ID
}
, prePath: layui.setter.apiUrl.FileApi + '/FilePreview?appid=' + 'Slops' + '&downloadPath=' //前置文件路徑
});
```
