0001 读取文件,将文件内容写入Blob字段

///

/// ///

public byte[] GetBytes(string fileName) {

byte[] _bytes = new byte[1];

if (File.Exists(fileName) == false) {

return _bytes; }

System.IO.FileStream _fileStream = new System.IO.FileStream(fileName, FileMode.OpenOrCreate);

BinaryReader _binaryReader = new BinaryReader(_fileStream); long _size = _binaryReader.BaseStream.Seek(0, SeekOrigin.End); _binaryReader.BaseStream.Seek(0, SeekOrigin.Begin); _bytes = _binaryReader.ReadBytes((int)_size); _binaryReader.Close(); _fileStream.Close();

if (_bytes.Length == 0) {

_bytes = new byte[1]; }

return _bytes; }

2、设置Oracle参数，执行Oracle命令，将文件写入到Blob字段中

OracleConnection _connection = new OracleConnection(m_connectionString);

try {

_connection.Open(); string _insertSQL = \"\";

OracleCommand _inesertCommand = null; if (_liMianDiagram.WMFFileName != null) {

_insertSQL = \"Insert into hsuser.LMT values('\" + m_ZoneNo + \"','\" + m_buildingName + \"','\" + _fileName + \"',:dwgFile,:wmfFile)\";

_inesertCommand = new OracleCommand(_insertSQL, _connection);

OracleParameter _dwgParameter = new OracleParameter(\":dwgFile\", OracleType.Blob);

OracleParameter _wmfParameter = new OracleParameter(\":wmfFile\", OracleType.Blob);

_dwgParameter.Value = this.GetBytes(_liMianDiagram.DWGFileName); _dwgParameter.Size = this.GetBytes(_liMianDiagram.DWGFileName).Length;

_wmfParameter.Value = this.GetBytes(_liMianDiagram.WMFFileName); _wmfParameter.Size = this.GetBytes(_liMianDiagram.WMFFileName).Length;

_inesertCommand.Parameters.Add(_dwgParameter); _inesertCommand.Parameters.Add(_wmfParameter);

_inesertCommand.ExecuteNonQuery(); }

catch (Exception ex) { return; }