/// <summary>
/// 上传文件
/// </summary>
public void FileUp(string FullName, string DBFullName, byte[] bFile)
{
string FileName = System.IO.Path.GetFileName(FullName);
string CFolder = System.IO.Path.GetDirectoryName(FullName);
string DBFolder = System.IO.Path.GetDirectoryName(DBFullName);
// 1.上传到数据库
Apq.Data.Common.DbConnectionHelper.Open(Connection);
System.Data.Common.DbCommand sqlCmd = Connection.CreateCommand();
sqlCmd.CommandText = "Apq_FileTrans_Insert";
sqlCmd.CommandType = CommandType.StoredProcedure;
Apq.Data.Common.DbCommandHelper cmdHelper = new Apq.Data.Common.DbCommandHelper(sqlCmd);
cmdHelper.AddParameter("@FileName", FileName);
cmdHelper.AddParameter("@DBFolder", DBFolder);
cmdHelper.AddParameter("@CFolder", CFolder);
cmdHelper.AddParameter("@FileStream", bFile);
cmdHelper.AddParameter("@ID", 0);
sqlCmd.Parameters["@ID"].Direction = ParameterDirection.InputOutput;
sqlCmd.ExecuteNonQuery();
int ID = Apq.Convert.ChangeType <int>(sqlCmd.Parameters["@ID"].Value);
// 2.转到磁盘
sqlCmd.Parameters.Clear();
sqlCmd.CommandText = "Apq_FileTrans_WriteToHD_ADO";
sqlCmd.CommandType = CommandType.StoredProcedure;
cmdHelper.AddParameter("@ID", ID);
cmdHelper.AddParameter("@KeepInDB", DBNull.Value);
sqlCmd.ExecuteNonQuery();
}