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); } }