『原创』C#中TreeView类操作全攻略:建立树,新增节点,删除节点,修改节点,拖动节点,与Oracle数据库交互操作(一)(15) }
/// <summary> /// 查询功能表的全部内容,并初始化所有的树节点信息;把查询结果保存在funcDataTable这个DataTable对象中 /// 该过程对变量funcDataTable和treeNodes进行赋值 /// </summary> /// <param name=""></param> /// <returns></returns> private void QueryAllFuncInfo() { funcTableConn.Open (); OracleCommand mySelectCmd= new OracleCommand(); mySelectCmd.Connection = funcTableConn; mySelectCmd.CommandText = "SELECT * FROM 功能 ORDER BY 功能ID" ; mySelectCmd.CommandType = CommandType.Text ; OracleDataAdapter myOracleDataAdapter = new OracleDataAdapter(); myOracleDataAdapter.SelectCommand=mySelectCmd; myOracleDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; try { myOracleDataAdapter.Fill(funcDataTable); } catch(Exception ex) { ErrorHandle.show("查询功能表时发生异常错误。", ex, "功能维护"); //MessageBox.Show("查询功能表时出现错误:"+ex.ToString()); } finally { funcTableConn.Close ( ) ; }
} /// <summary> /// 查询功能ID为funcID的记录内容;把查询结构保存在funcItem这个FunctionTable对象中并且返回该结果; /// </summary> /// <param name="funcID"></param> /// <returns>funcItem</returns> private FunctionTable QueryFuncItem(long funcID) { int funcEntityNum=funcDataTable.Rows.Count; int findindex=-1; FunctionTable funcItem=new FunctionTable();