文件查询

SELECT [file_name] 文件名,'http://124.71.33.56:3000'+replace([file_path],'\','/')  页面地址,'['+[file_name]+']('+'http://124.71.33.56:3000'+replace([file_path],'\','/')+')' 复制到文档 
FROM [mindoclink].[dbo].[md_attachment_view] where [file_ext] not in ('.jpg','.jpeg','.png','.gif') and [file_name] like '%'+@name+'%' order by [attachment_id] desc

SELECT [file_name] AS '文件名','http://124.71.33.56:3000' || replace([file_path], '\', '/') AS '页面地址','[' || [file_name] || '](' || 'http://124.71.33.56:3000' || replace([file_path], '\', '/') || ')' AS '复制到文档' FROM "main"."md_attachment" WHERE [file_ext] NOT IN ('.jpg', '.jpeg', '.png', '.gif') ORDER BY [attachment_id] DESC

第三版文件查询

SELECT [create_time] AS 时间,[file_name] AS '文件名','http://124.71.33.56:3000' || replace([file_path], '\', '/') AS '页面地址','[' || [file_name] || '](' || 'http://124.71.33.56:3000' || replace([file_path], '\', '/') || ')' AS '复制到文档' FROM "main"."md_attachment" WHERE [file_ext] NOT IN ('.jpg', '.jpeg', '.png', '.gif') ORDER BY [attachment_id] DESC

第四版文件查询

SELECT a.[create_time] AS 时间,[file_name] AS '文件名','http://124.71.33.56:3000' || replace([file_path], '\', '/') AS '页面地址','[' || [file_name] || '](' || 'http://124.71.33.56:3000' || replace([file_path], '\', '/') || ')' AS '复制到文档' 
,b.book_name
,c.document_name
FROM "main"."md_attachment" a
join "main"."md_books" b on b.book_id=a.book_id
join "main"."md_documents" c on c.document_id=a.document_id
WHERE [file_ext] NOT IN ('.jpg', '.jpeg', '.png', '.gif') ORDER BY a.[attachment_id] DESC

MES bin目录 需要添加dll 文件
“D:\MES\华派\huapai\COPY_MES\bin\System.Data.SQLite.DLL”
使用智能报表

https://data.avuejs.com/

ms_pan
密
ms_pan

任务分配
https://www.kdocs.cn/l/cgiRI8X9nD4M

SELECT a.[BillNo]
,a.[ApproveState]
,b.[OGA01]
,b.[TC_OGGSTUS]
,CASE when  a.[ApproveState]=0 and b.[TC_OGGSTUS]='N' then '开立'
WHEN a.[ApproveState]=0 and b.[TC_OGGSTUS]='Y' THEN 'QC'
WHEN a.[ApproveState]=1 and b.[TC_OGGSTUS]='Y' THEN '过账'
ELSE '关单' END 状态
FROM [Udit.Mms].[dbo].[mms_bills] a
join [Udit.Mms].[dbo].[oga_file] b on b.[OGA01]=a.[BillNo]

```sql
SELECT [file_name] 文件名,'http://124.71.33.56:3000'+replace([file_path],'\','/')  页面地址,'['+[file_name]+']('+'http://124.71.33.56:3000'+replace([file_path],'\','/')+')' 复制到文档 
FROM [mindoclink].[dbo].[md_attachment_view] where [file_ext] not in ('.jpg','.jpeg','.png','.gif') and [file_name] like '%'+@name+'%' order by [attachment_id] desc

“D:\bolg\mindoc_windows_386\database\old\mindoc.db”