/// <summary> /// 保存配置 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Save_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { TreeList_Station.Focus();//通过切换焦点,确保当前编辑的内容进入空间节点 Save_Node(TreeList_Station.Nodes); MessageBox.Show("保存成功!"); } catch (Exception ex) { MessageBox.Show("保存失败:" + ex.Message); } finally { InitTreeList(); } }
/// <summary> /// 删除节点 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_Del_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (MessageBox.Show("是否删除该节点?", "友情提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.OK) { try { if (Del_Node(TreeList_Station.FocusedNode)) { TreeList_Station.DeleteSelectedNodes(); } } catch (Exception ex) { MessageBox.Show("删除失败:" + ex.Message); } } }
/// <summary> /// 加载车站树 /// </summary> private void InitTreeList() { using (MySqlConnection mycon = new MySqlConnection(CommonSetting.Default.ConStr_Inspection)) { DataTable dt = new DataTable(); mycon.Open(); MySqlDataAdapter mda = new MySqlDataAdapter("SELECT * FROM t_station;", mycon); mda.Fill(dt); mycon.Close(); if (dt.Rows.Count > 0) { //设置字段 TreeList_Station.KeyFieldName = "ID"; TreeList_Station.ParentFieldName = "PID"; TreeList_Station.DataSource = dt; TreeList_Station.ExpandAll(); } else { MessageBox.Show("未查询到车站信息", "友情提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation); } } }