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