关于附件管理的问题

from---yangzheng
附件存储一般为数据库存储，以2进制存储在表t_Accessory 的FData字段中。

sFileName 为本地文件，例如：C:\Users\Desktop\11.txt
sTmpFileName 为保存临时文件路径，用于保存压缩本地文件后的临时文件例如 D:\CODE\temp.tmp
varFile 为 kdzip压缩文件后得到的二进制，用户保存到数据库

VB 保存
Public Function SaveData()
Dim ozip As Object
Dim sFileName As String
Dim sTmpFileName As String
Dim smFile As Stream
Dim smFileNoCompress As Stream
Dim varFile As Variant
Dim bytFile() As Byte

Set ozip = CreateObject("KDZIP.ZIP")
ozip.Compress sFileName, sTmpFileName, 7
Set ozip = Nothing
Set smFile = New ADODB.Stream
Set smFileNoCompress = New ADODB.Stream
smFile.Type = adTypeBinary
smFile.Open
smFile.LoadFromFile sTmpFileName
bytFile() = smFile.Read
Set smFile = Nothing
varFile = bytFile()
End Function

C#
//SQL存储方式
private DataTable SQLStore()
{
DataTable rtn = new DataTable();
string desFilePath = HttpContext.Current.Server.MapPath("./") + FileUpload1.FileName;
if (FileUpload1.HasFile)
{
FileUpload1.MoveTo(desFilePath, MoveToOptions.Overwrite);
KDZipLib zip = new KDZipLib();
FileStream FStream = new FileStream(desFilePath, FileMode.Open, FileAccess.Read, FileShare.Read);
byte[] data = new byte[FStream.Length];