public bool SaveTemplateContent(string aTID, Stream stream)
{
if (aTID != "")
{
stream.Position = 0;
byte[] vFile = new byte[stream.Length]; //分配数组大小
stream.Read(vFile, 0, (int)stream.Length); //将文件内容读进数组
OleDbCommand com = FDBConn.CreateCommand();
//其中picture字段是OLE对象数据类型
com.CommandText = string.Format("UPDATE Template set content = @content WHERE id = {0}", aTID);
com.Parameters.AddWithValue("@content", vFile);
com.ExecuteNonQuery();
return(true);
}
else
{
return(false);
}
}
public byte[] GetTemplateContent(string aTID)
{
if (aTID != "")
{
OleDbCommand com = FDBConn.CreateCommand();
com.CommandText = string.Format("SELECT content FROM Template where id={0}", aTID);
object vObj = com.ExecuteScalar();
if (!(vObj is System.DBNull))
{
return((byte[])vObj);//读取之后转换成二进制字节数组
}
else
{
return(null);
}
}
else
{
return(null);
}
}
