/// <summary> /// moveTreeNode: 移动树节点 /// </summary> /// <param name="table">表名</param> /// <param name="id"></param> public void moveTreeNode(string table, int id) { MySqlTrans _trans = new MySqlTrans(this); string _val = String.Empty; try { _val = _trans.execReader(""); _trans.commit(); } catch (Exception e) { _val = Native.getErrorMsg(e.Message.ToString()); _trans.rollback(); } finally { _trans.close(); } }
/*树状表结构的基本操作 --begin*/ #region updateTreeOrder: 更新树结构的treeOrder /// <summary> /// updateTreeOrder: 更新树结构的treeOrder /// </summary> /// <param name="table">表名</param> /// <param name="condition">where条件 如: id=12</param> /// <param name="treeOrder">更新之后的treeOrder值</param> /// <returns></returns> public string updateTreeOrder(string table, string condition, int treeOrder) { MySqlTrans _trans = new MySqlTrans(this); string _val = String.Empty; try { _val = _trans.execReader(""); _trans.commit(); } catch (Exception e) { _val = Native.getErrorMsg(e.Message.ToString()); _trans.rollback(); } finally { _trans.close(); } return(_val); }