技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 7288
|
本帖最后由 Grant 于 2012-1-11 17:22 編輯
用了一天時間寫成了這個東西,準(zhǔn)備融入到客戶管理軟件中去,現(xiàn)在很多客戶電腦都安裝了新的office2010
不得不轉(zhuǎn)型學(xué)習(xí)office2010的新功能,發(fā)現(xiàn)有不少好東西,暫時先研究這個,先貼上來給大家分享一下
- Option Compare Database
- '===============================================================================
- '-函數(shù)名稱: modAdj
- '-功能描述: 保存,刪除,添加附件
- '-輸入?yún)?shù)說明: 參數(shù)1:strPath As String 目標(biāo)路徑
- ' 參數(shù)2:strFileName As String 文件名稱
- ' 參數(shù)3:ID As long 自動編號
- '-使用語法示例: AddAdj(自動編號,文件名,路徑) '添加附件
- ' DelAdj(自動編號,文件名) '刪除附件
- ' GetAdj(自動編號,列表框) '讀取附件
- ' GetSave(自動編號,文件名,路徑) '保存附件
- '-參考:
- '-使用注意:
- '-兼容性: Office2007,Office2010
- '-作者: Grant
- '-聯(lián)系方式: QQ:20991943 Email:20991943@qq.com
- '-更新日期: 2012-01-11
- '===============================================================================
- Public Function AddAdj(ID As Long, strFileName As String, strPath As String) '添加附件
- Dim db As Database
- Dim Rstable As Recordset
- Dim RsAdj As Recordset2
-
- '數(shù)據(jù)庫
- Set db = DBEngine.Workspaces(0).Databases(0)
-
- '打開表
- Set Rstable = db.OpenRecordset("select * from 企業(yè)信息 where ID=" & ID)
- ' While Not Rstable.EOF
- '獲取附件列的文件集合
- Set RsAdj = Rstable("附件").Value
- '往附件列添加文件
- Rstable.Edit
- RsAdj.AddNew
- RsAdj("FileData").LoadFromFile (strPath)
- RsAdj("FileName") = strFileName
- RsAdj.Update
- Rstable.Update
- Rstable.Close
- End Function
- Public Function DelAdj(ID As Long, strFileName As String) '添加附件
- Dim db As Database
- Dim Rstable As Recordset
- Dim RsAdj As Recordset2
-
- '數(shù)據(jù)庫
- Set db = DBEngine.Workspaces(0).Databases(0)
-
- '打開表
- Set Rstable = db.OpenRecordset("select * from 企業(yè)信息 where ID=" & ID)
- ' While Not Rstable.EOF
- '獲取附件列的文件集合
- Set RsAdj = Rstable("附件").Value
- '往附件列添加文件
- Rstable.Edit
- While Not RsAdj.EOF
-
- If RsAdj("FileName") = strFileName Then
- Rstable.Edit
- RsAdj.Delete
- Rstable.Update
- Rstable.Close
- Exit Function
- End If
- RsAdj.MoveNext
- Wend
- Rstable.Close
- End Function
- Public Function GetAdj(ID As Long, list As ListBox) '獲取附件,讀取到list
- Dim db As Database
- Dim Rstable As Recordset
- Dim RsAdj As Recordset2
- Set db = DBEngine.Workspaces(0).Databases(0) '數(shù)據(jù)庫
- Set Rstable = db.OpenRecordset("select * from 企業(yè)信息 where ID=" & ID) '定位表記錄
- If Rstable.RecordCount = 0 Then Exit Function '記錄為0退出
-
- Set RsAdj = Rstable("附件").Value
- While Not RsAdj.EOF '循環(huán)
- list.AddItem RsAdj("FileName") '讀取文件到列表
- ' RsAdj("FileData").SaveToFile ("C:\Documents" & rsatts("FileName").Value)
- RsAdj.MoveNext
- Wend
-
- Rstable.Close
-
- End Function
- Public Function GetSave(ID As Long, strFileName As String, strPath As String)
- Dim db As Database
- Dim Rstable As Recordset
- Dim RsAdj As Recordset2
-
- '數(shù)據(jù)庫
- Set db = DBEngine.Workspaces(0).Databases(0)
-
- '打開表
- Set Rstable = db.OpenRecordset("select * from 企業(yè)信息 where ID=" & ID)
- Set RsAdj = Rstable("附件").Value
- While Not RsAdj.EOF
-
- If RsAdj("FileName") = strFileName Then
- If Dir(strPath) <> "" Then
- Kill strPath
- End If
-
- RsAdj("FileData").SaveToFile (strPath)
- Rstable.Close
- Exit Function
- End If
- RsAdj.MoveNext
- Wend
- Rstable.Close
- End Function
復(fù)制代碼 |
本帖子中包含更多資源
您需要 登錄 才可以下載或查看,沒有帳號?注冊
x
評分
-
查看全部評分
|