private void CreateSubDir_Click(object sender, EventArgs e)
{
TreeNode pNode = this.SelectedNode;
int ID = this.GetNodeID(pNode);
string ParentPath = this.GetFtpPathByNode(pNode);
string sql = "select SEQ_UP_DIRS.nextval from dual";
IDataBase pDataBase = SysDBConfig.GetInstance().GetOleDataBase("OrclConn");
pDataBase.OpenConnection();
string DirID = pDataBase.ExecuteScalar(sql).ToString();
string Path = string.Format("{0}/{1}", this.GetFtpPathByNode(pNode), DirID);
sql = string.Format("insert into up_dirs values({0},'新建目录',{1},'{2}\\{0}',1)", DirID, ID, ParentPath);
pDataBase.ExecuteNonQuery(sql);
pDataBase.CloseConnection();
this.RefreshSubTreeView(pNode);
pNode.ExpandAll();
TreeNode NewNode = this.FindNodeByID(int.Parse(DirID));
IFtpClient pFtpClient = SysDBConfig.GetInstance().GetFtpClient("CHXQ");
pFtpClient.Connect();
string FtpPath = GetFtpPathByNode(NewNode);
pFtpClient.CreateDirectory(FtpPath);
pFtpClient.Close();
this.SelectedNode = NewNode;
this.LabelEdit = true;
NewNode.BeginEdit();
}
private void Delete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("是否删除该文件夹", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question)
== DialogResult.Cancel)
{
return;
}
TreeNode pNode = this.SelectedNode;
int ID = this.GetNodeID(pNode);
IFtpClient pFtpClient = SysDBConfig.GetInstance().GetFtpClient("CHXQ");
pFtpClient.Connect();
pFtpClient.DeleteDirectory(GetFtpPathByNode(pNode));
pFtpClient.Close();
string sql = string.Format("delete from up_dirs where id={0}", ID);
IDataBase pDataBase = SysDBConfig.GetInstance().GetOleDataBase("OrclConn");
pDataBase.OpenConnection();
pDataBase.ExecuteNonQuery(sql);
pDataBase.CloseConnection();
this.RefreshSubTreeView(pNode.Parent);
}
public void UploadFiles(string[] FilePaths, TreeNode pNode)
{
IFtpClient pFtpClient = SysDBConfig.GetInstance().GetFtpClient("CHXQ");
pFtpClient.Connect();
IDataBase pDataBase = SysDBConfig.GetInstance().GetOleDataBase("OrclConn");
pDataBase.OpenConnection();
string DirPath = GetFtpPathByNode(pNode);
try
{
if (!pFtpClient.DirectoryExists(DirPath))
{
pFtpClient.CreateDirectory(DirPath);
}
foreach (string FilePath in FilePaths)
{
string RemotePath = string.Format("{0}\\{1}", DirPath, System.IO.Path.GetFileName(FilePath));
pFtpClient.UploadFile(FilePath, RemotePath);
string ProcedureName = "AddFile";
IDataParameter[] DataParameters = new IDataParameter[] {
new OracleParameter()
{
ParameterName = "V_FileName", OracleType = OracleType.NVarChar, Value = System.IO.Path.GetFileNameWithoutExtension(FilePath)
},
new OracleParameter()
{
ParameterName = "V_Path", OracleType = OracleType.NVarChar, Value = RemotePath
},
new OracleParameter()
{
ParameterName = "V_DirID", OracleType = OracleType.Number, Value = this.GetNodeID(pNode)
}
};
pDataBase.ExecuteProcedure(ProcedureName, ref DataParameters);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
pDataBase.CloseConnection();
pFtpClient.Close();
}
}
private void UploadFile(string FilePath, string UploadPath)
{
IFtpClient pFtpClient = HR.Utility.SysDBConfig.GetInstance().GetFtpClient("CHXQ");
pFtpClient.Connect();
string Dir = System.IO.Path.GetDirectoryName(UploadPath);
if (!pFtpClient.DirectoryExists(Dir))
{
pFtpClient.CreateDirectory(Dir);
}
if (pFtpClient.Exists(UploadPath))
{
pFtpClient.DeleteFile(UploadPath);
}
pFtpClient.UploadFile(FilePath, UploadPath);
pFtpClient.Close();
}
public virtual void DownloadFile(string SavePath)
{
IFtpClient pFtpClient = SysDBConfig.GetInstance().GetFtpClient("CHXQ");
pFtpClient.Connect();
try
{
pFtpClient.DownloadFile(SavePath, this.Path);
}
catch (Exception ex)
{
throw ex;
}
finally
{
pFtpClient.Close();
}
}
public void DownloadAD(string SavePath)
{
if (string.IsNullOrEmpty(m_CADPath))
{
throw new Exception("图纸未上传");
}
IFtpClient pFtpClient = HR.Utility.SysDBConfig.GetInstance().GetFtpClient("CHXQ");
pFtpClient.Connect();
try
{
pFtpClient.DownloadFile(SavePath, this.m_CADPath);
}
catch (Exception ex)
{
throw ex;
}
finally
{
pFtpClient.Close();
}
}
public override void Delete()
{
IFtpClient pFtpClient = SysDBConfig.GetInstance().GetFtpClient("CHXQ");
pFtpClient.Connect();
try
{
pFtpClient.DeleteFile(this.Path);
string sql = string.Format("delete from up_files where ID={0}", this.m_ID);
IDataBase OrclDataBase = HR.Utility.SysDBConfig.GetInstance().GetOleDataBase("OrclConn");
OrclDataBase.OpenConnection();
OrclDataBase.ExecuteNonQuery(sql);
OrclDataBase.CloseConnection();
}
catch (Exception ex)
{
throw ex;
}
finally
{
pFtpClient.Close();
}
}
