dotnet日记
日记就是天天记

private string InsertFileToDB(DocAccessory docAccessory)
  {
   string tmpGuid = Guid.NewGuid().ToString();
   string tmpSQL = "INSERT INTO ECMSDOCACCESSORY (accessoryid,accessorydocid,accessoryfile,accessoryfilename,accessoryfilesize,accessorytype) ";
   tmpSQL += "VALUES(@accessoryid,@accessorydocid,@accessoryfile,@accessoryfilename,@accessoryfilesize,@accessorytype)";

   #region 插入数据 逻辑在此

   ComplusGetAll cg = ComplusGetAll.CreateSingletonObject();;
   ConnectionInfo ci = cg.GetConnectionManager().BaseConnection();
   System.Data.SqlClient.SqlConnection  dbConnection = new SqlConnection (ci.ConnectionString );
   dbConnection.Open ();
   SqlCommand CmdObj = new SqlCommand(tmpSQL,dbConnection);  
   CmdObj.Parameters.Add("@accessoryid",SqlDbType.VarChar ,128).Value =tmpGuid;
   CmdObj.Parameters.Add("@accessoryfilename",SqlDbType.VarChar,128).Value =docAccessory.AccessoryFileName;
   CmdObj.Parameters.Add("@accessoryfile",SqlDbType.Binary  ,50).Value =docAccessory.AccessoryFile ;
   CmdObj.Parameters.Add("@accessorydocid",SqlDbType.VarChar ,128).Value =docAccessory.AccessoryDocId;
   CmdObj.Parameters.Add("@accessoryfilesize",SqlDbType.VarChar ,50).Value =docAccessory.AccessoryFileSize;
   CmdObj.Parameters.Add("@accessorytype",SqlDbType.VarChar ,50).Value =docAccessory.AccessoryType;
   
   CmdObj.ExecuteNonQuery ();

posted on 2005-03-14 13:50  大牛  阅读(527)  评论(0编辑  收藏  举报