using DevExpress.Data;
|
using DevExpress.XtraTreeList;
|
using DevExpress.XtraTreeList.Nodes;
|
using Gs.DevApp.Entity;
|
using Gs.DevApp.ToolBox;
|
using Newtonsoft.Json;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Drawing;
|
using System.Windows.Forms;
|
|
namespace Gs.DevApp.DevFrm.Sys
|
{
|
/// <summary>
|
/// 看板目录管理 - 树形结构维护界面（用户控件）
|
/// </summary>
|
public partial class SimpleKanBan : DevExpress.XtraEditors.XtraUserControl
|
{
|
private string _webServiceName = "MesSimpleManager/";
|
|
public SimpleKanBan()
|
{
|
InitializeComponent();
|
|
// 工具栏事件绑定
|
toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick;
|
toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick;
|
// TreeList 行号显示
|
tlMenu.IndicatorWidth = 50;
|
tlMenu.CustomDrawNodeIndicator += (s, ee) =>
|
{
|
if (ee.IsNodeIndicator)
|
{
|
var index = ee.Node.TreeList.GetVisibleIndexByNode(ee.Node);
|
ee.Info.DisplayText = (index + 1).ToString();
|
}
|
};
|
|
// 初始化加载数据
|
getPageList();
|
|
// 右键菜单事件
|
tlMenu.MouseDown += TlMenu_MouseDown;
|
|
// 增加子项
|
toolStripMenuItemAdd.Click += (s, ee) =>
|
{
|
string strGuid = "";
|
string strUpGuid = "";
|
if (tlMenu.FocusedNode != null)
|
{
|
strUpGuid = tlMenu.FocusedNode.GetValue("id").ToString();
|
}
|
SimpleKanBanEdit frm = new SimpleKanBanEdit(strGuid, strUpGuid);
|
frm.UpdateParent += (s2, ee2) =>
|
{
|
getPageList();
|
TreeListNode node = tlMenu.FindNodeByKeyID(long.Parse(strUpGuid));
|
if (node != null)
|
{
|
node.Expanded = true;
|
tlMenu.MakeNodeVisible(node);
|
}
|
};
|
frm.ShowDialog();
|
};
|
|
// 增加主项（根节点）
|
toolStripMenuItemRoot.Click += (s, ee) =>
|
{
|
string strGuid = "";
|
string strUpGuid = "";
|
SimpleKanBanEdit frm = new SimpleKanBanEdit(strGuid, strUpGuid);
|
frm.UpdateParent += (s2, ee2) =>
|
{
|
getPageList();
|
};
|
frm.ShowDialog();
|
};
|
|
// 删除节点
|
toolStripMenuItemDel.Click += (s, ee) =>
|
{
|
if (tlMenu.FocusedNode != null)
|
{
|
string rowGuid = "";
|
string rowName = "";
|
rowGuid = tlMenu.FocusedNode.GetValue("id").ToString();
|
rowName = tlMenu.FocusedNode.GetValue("title").ToString();
|
if (string.IsNullOrEmpty(rowGuid))
|
{
|
MsgHelper.Warning("请先选择你要操作的行！");
|
return;
|
}
|
if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】，确定删除吗？"))
|
return;
|
List<dynamic> lst = new List<dynamic>();
|
lst.Add(rowGuid);
|
try
|
{
|
string strJson = UtilityHelper.HttpPost("", _webServiceName + "DeleteModel", JsonConvert.SerializeObject(lst));
|
ReturnModel<dynamic> _rtn = UtilityHelper.ReturnToDynamic(strJson);
|
if (_rtn.rtnCode > 0)
|
{
|
tlMenu.DeleteNode(tlMenu.FocusedNode);
|
}
|
else
|
MsgHelper.ShowError("提示：" + _rtn.rtnMsg);
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.ShowError("提示：" + ex.Message);
|
}
|
}
|
};
|
// 创建刷新菜单项
|
ToolStripMenuItem toolStripMenuItemRefresh = new ToolStripMenuItem();
|
toolStripMenuItemRefresh.Text = "刷新";
|
toolStripMenuItemRefresh.Click += ToolBarMenu1_btnLoadClick; // 直接调用已有刷新事件
|
|
// 添加到右键菜单，不清空原有 Items
|
cms1.Items.Add(toolStripMenuItemRefresh);
|
|
// 编辑节点
|
toolStripMenuItemEdt.Click += (s, ee) =>
|
{
|
string strGuid = "";
|
string strUpGuid = "";
|
if (tlMenu.FocusedNode != null)
|
{
|
strGuid = tlMenu.FocusedNode.GetValue("id").ToString();
|
var fidValue = tlMenu.FocusedNode.GetValue("parentId");
|
strUpGuid = fidValue != null ? fidValue.ToString() : "";
|
}
|
SimpleKanBanEdit frm = new SimpleKanBanEdit(strGuid, strUpGuid);
|
frm.UpdateParent += (s2, ee2) =>
|
{
|
getPageList();
|
TreeListNode node = tlMenu.FindNodeByKeyID(long.Parse(strGuid));
|
if (node != null)
|
{
|
node.Expanded = true;
|
tlMenu.MakeNodeVisible(node);
|
}
|
};
|
frm.ShowDialog();
|
};
|
}
|
|
/// <summary>
|
/// 查询事件
|
/// </summary>
|
private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e)
|
{
|
MsgHelper.ShowInformation("该窗体不支持查询，若想更新页面，请点击 刷新");
|
}
|
|
/// <summary>
|
/// 刷新事件
|
/// </summary>
|
private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e)
|
{
|
getPageList();
|
MsgHelper.ShowInformation("刷新成功！");
|
}
|
/// <summary>
|
/// 右键弹出菜单
|
/// </summary>
|
private void TlMenu_MouseDown(object sender, MouseEventArgs e)
|
{
|
if (e.Button == MouseButtons.Right)
|
{
|
TreeListHitInfo hInfo = tlMenu.CalcHitInfo(new Point(e.X, e.Y));
|
TreeListNode node = hInfo.Node;
|
tlMenu.FocusedNode = node;
|
if (hInfo.HitInfoType == HitInfoType.Cell ||
|
hInfo.HitInfoType == HitInfoType.Row ||
|
hInfo.HitInfoType == HitInfoType.RowIndent ||
|
hInfo.HitInfoType == HitInfoType.RowIndicator)
|
{
|
if (node != null)
|
{
|
toolStripMenuItemAdd.Visible = true;
|
toolStripMenuItemEdt.Visible = true;
|
toolStripMenuItemDel.Visible = true;
|
toolStripMenuItemRoot.Visible = false;
|
cms1.Show(tlMenu, e.Location);
|
}
|
}
|
else
|
{
|
toolStripMenuItemAdd.Visible = false;
|
toolStripMenuItemEdt.Visible = false;
|
toolStripMenuItemDel.Visible = false;
|
toolStripMenuItemRoot.Visible = true;
|
cms1.Show(tlMenu, e.Location);
|
}
|
}
|
}
|
|
/// <summary>
|
/// 加载数据列表 - 树形结构显示
|
/// </summary>
|
private void getPageList()
|
{
|
var pgq = new PageQueryModel(1, 999999, "a.node_level", "asc", "", "");//sort_order
|
var json = JsonConvert.SerializeObject(pgq);
|
|
try
|
{
|
var strReturn = UtilityHelper.HttpPost("", _webServiceName + "GetListPage", json);
|
var dd = UtilityHelper.ReturnToTablePage(strReturn);
|
var dt = dd.rtnData.list; // 获取原始 DataTable
|
|
|
// 检测 parentId 是否存在且类型不对
|
if (dt.Columns.Contains("parentId") && dt.Columns["parentId"].DataType != typeof(long))
|
{
|
// 1. 创建一个新的 Int64 类型的临时列
|
DataColumn newCol = new DataColumn("parentId_Fixed", typeof(long));
|
dt.Columns.Add(newCol);
|
|
// 2. 遍历所有行，把 String 转成 Long
|
foreach (DataRow row in dt.Rows)
|
{
|
object oldVal = row["parentId"];
|
// 只有非空值才转换，空值保持 DBNull (即根节点)
|
if (oldVal != null && oldVal != DBNull.Value && !string.IsNullOrEmpty(oldVal.ToString()))
|
{
|
if (long.TryParse(oldVal.ToString(), out long val))
|
{
|
row["parentId_Fixed"] = val;
|
}
|
}
|
}
|
|
// 3. 移除旧的 String 列
|
dt.Columns.Remove("parentId");
|
|
// 4. 把新列改名为 parentId
|
newCol.ColumnName = "parentId";
|
}
|
|
|
tlMenu.BeginUpdate();
|
|
// 1. 绑定处理过的数据
|
tlMenu.DataSource = dt;
|
|
// 2. 绑定字段 (现在类型完全一致了)
|
tlMenu.KeyFieldName = "id";
|
tlMenu.ParentFieldName = "parentId";
|
// 设置根节点 (Int64 类型的列，空值就是 DBNull)
|
tlMenu.RootValue = DBNull.Value;
|
|
|
string sortColName = "sortOrder";
|
|
if (tlMenu.Columns[sortColName] != null)
|
{
|
|
tlMenu.ClearSorting();
|
|
tlMenu.Columns[sortColName].SortOrder = System.Windows.Forms.SortOrder.Ascending;
|
|
tlMenu.Columns[sortColName].SortIndex = 0;
|
}
|
tlMenu.ForceInitialize();
|
|
// 4. 调用展开逻辑
|
ApplyExpandState();
|
|
tlMenu.EndUpdate();
|
tlMenu.BestFitColumns();
|
|
|
|
}
|
catch (Exception ex)
|
{
|
tlMenu.EndUpdate();
|
MsgHelper.Warning("加载失败：" + ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 根据 isExpanded (bool) 字段设置节点展开
|
/// </summary>
|
private void ApplyExpandState()
|
{
|
// 1. 先全部折叠
|
tlMenu.CollapseAll();
|
|
// 2. 使用 DevExpress 高效迭代器遍历
|
tlMenu.NodesIterator.DoOperation(node =>
|
{
|
// 获取值 (注意：列名必须与 DataTable 中一致，通常是 "isExpanded")
|
object val = node.GetValue("isExpanded");
|
|
// 3. 判断并展开
|
if (val != null && val != DBNull.Value)
|
{
|
if ((bool)val)
|
{
|
node.Expanded = true;
|
}
|
}
|
});
|
}
|
/// <summary>
|
/// 将动态数据转换为DataTable
|
/// </summary>
|
private DataTable ConvertToDataTable(dynamic sourceData)
|
{
|
DataTable dt = new DataTable();
|
|
if (sourceData == null) return dt;
|
|
// 如果已经是DataTable，直接返回
|
if (sourceData is DataTable)
|
return sourceData as DataTable;
|
|
// 尝试从JSON数组转换
|
string jsonStr = JsonConvert.SerializeObject(sourceData);
|
dt = JsonConvert.DeserializeObject<DataTable>(jsonStr);
|
|
return dt;
|
}
|
|
/// <summary>
|
/// 处理parentId字段，确保树形结构正确构建
|
/// 根节点（node_level=0 或 parentId为null/0）的parentId设为DBNull
|
/// </summary>
|
private void ProcessParentIdForTreeStructure(DataTable dt)
|
{
|
if (dt == null || dt.Rows.Count == 0) return;
|
|
foreach (DataRow row in dt.Rows)
|
{
|
// 获取nodeLevel
|
int nodeLevel = 0;
|
if (dt.Columns.Contains("nodeLevel") && row["nodeLevel"] != DBNull.Value)
|
{
|
nodeLevel = Convert.ToInt32(row["nodeLevel"]);
|
}
|
|
// 获取parentId
|
object parentIdValue = null;
|
if (dt.Columns.Contains("parentId"))
|
{
|
parentIdValue = row["parentId"];
|
}
|
|
// 如果是根节点（nodeLevel=0 或 parentId为null/0/空），将parentId设为DBNull
|
bool isRootNode = nodeLevel == 0;
|
bool hasNoParent = parentIdValue == null ||
|
parentIdValue == DBNull.Value ||
|
string.IsNullOrEmpty(parentIdValue.ToString()) ||
|
parentIdValue.ToString() == "0";
|
|
if (isRootNode || hasNoParent)
|
{
|
row["parentId"] = DBNull.Value;
|
}
|
}
|
}
|
|
/// <summary>
|
/// 展开第一级节点（根节点）
|
/// </summary>
|
private void ExpandFirstLevelNodes()
|
{
|
foreach (TreeListNode node in tlMenu.Nodes)
|
{
|
node.Expanded = true;
|
}
|
}
|
|
}
|
}
|
