『原创』C#中TreeView类操作全攻略:建立树，新增节点，删除节点，修改节点，拖动节点，与Oracle数据库交互操作（一）

『原创』C#中TreeView类操作全攻略:建立树，新增节点，删除节点，修改节点，拖动节点，与Oracle数据库交互操作（一）(28)    System.Data.OracleClient.OracleTransaction myTran = funcTableConn.BeginTransaction ();
   try
   {
    OracleCommand cmd = new OracleCommand ();
    cmd.Transaction = myTran;
    cmd.Connection =funcTableConn;
    cmd.CommandText = "DELETE from 功能 where 功能ID = '"+funcID+"'";
    cmd.ExecuteNonQuery ();
    cmd.CommandText = "DELETE from 角色功能 where 功能ID = '"+funcID+"'";
    cmd.ExecuteNonQuery ();
    cmd.CommandText = "DELETE from 操作员授权 where 功能ID = '"+funcID+"'";
    cmd.ExecuteNonQuery ();
    string newFuncName=funcName+"(该功能已收回！)";
    cmd.CommandText = "UPDATE 界面定制 set 功能ID=null,节点名称='" + newFuncName+"'"+ " where 功能ID ="+funcID;
    cmd.ExecuteNonQuery ();
    myTran.Commit ();
   }
   catch(Exception ee)
   {
    try
    {
     myTran.Rollback();
     MessageBox.Show ("rollback over");
    }
    catch (OracleException ex)
    {
     if (myTran.Connection != null)
     {
      MessageBox.Show ("在回滚时发生 " + ex.GetType() +" 异常！",
       "警告",System.Windows.Forms.MessageBoxButtons.OK,
       System.Windows.Forms.MessageBoxIcon.Warning);
     }
    }
 
    MessageBox.Show ("发生" + ee.GetType() +
     "异常\n" +"删除功能出错！","警告",System.Windows.Forms.MessageBoxButtons.OK,