万能树状列表

2008-03-11 10:55:04 141 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Dendrogam树状图谱：用可解释性归因重构BI决策逻辑树状图谱（Dendrogam）是一种面向归因分析的结构化可视化范式，其核心在于将多维数据按‘根—干—枝—叶’四级建模，同步呈现绝对值、占父节点比、占根节点比三层数值关系，从而实现对‘谁导致了什么、影响有多大’的直观、可信、可干预表达。它不同于旭日图（侧重比例嵌套）和桑基图（侧重流向），本质是XAI（可解释人工智能）在商业分析中的工程落地，强调逻辑刚性与业务语义对齐。典型应用于财务归因、渠道效能诊断、成本偏差溯源等需向上沟通与快速决策的场景，尤其适合需要向非技术管理者讲清数字背后故事的数据分析师与产品运营人员阅读详情

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlConnection conn = new SqlConnection("server=127.0.0.1;uid=sa;pwd=cuihufox;database=Text");
SqlDataAdapter sda = new SqlDataAdapter("select * from demo", conn);
DataSet ds = new DataSet();
sda.Fill(ds, "demo");
BindTreeView("default", ds.Tables["demo"]);
}
}

//邦定根节点
public void BindTreeView(string TargetFrame, DataTable dt)
{
DataRow[] drs = dt.Select("M_Id= " + 0);//　选出所有子节点

//菜单状态
bool menuExpand = false;

TreeView1.Nodes.Clear(); // 清空树

foreach (DataRow r in drs)//遍历节点,读取数据库对应字段
{
string nodeid = r["I_Id"].ToString();
string text = r["I_Name"].ToString();
string parentid = r["M_Id"].ToString();
string url = r["I_URl"].ToString();
string imageurl = r["I_Image"].ToString();
string framename = TargetFrame;
this.TreeView1.Font.Name = "宋体";
this.TreeView1.Font.Size = FontUnit.Parse("9");

TreeNode rootnode = new TreeNode();
rootnode.Text = text;
rootnode.Value = nodeid;
rootnode.NavigateUrl = url;
rootnode.Target = framename;
rootnode.Expanded = menuExpand;
rootnode.ImageUrl = imageurl;
rootnode.SelectAction = TreeNodeSelectAction.Expand;//和ASP.NET1.1中TREEVIEW的SelectExpands属性等效

TreeView1.Nodes.Add(rootnode);

int sonparentid = int.Parse(nodeid);// Ｏr =location
CreateNode(framename, sonparentid, rootnode, dt);

}

}

//邦定任意节点
public void CreateNode(string TargetFrame, int parentid, TreeNode parentnode, DataTable dt)
{

DataRow[] drs = dt.Select("M_Id= " + parentid);//选出所有子节点
foreach (DataRow r in drs)
{
string nodeid = r["I_Id"].ToString();
string text = r["I_Name"].ToString();
string url = r["I_URl"].ToString();
string imageurl = r["I_Image"].ToString();
string framename = TargetFrame;

TreeNode node = new TreeNode();
node.Text = text;
node.Value = nodeid;
node.NavigateUrl = url;
node.Target = TargetFrame;
node.ImageUrl = imageurl;
//node.Expanded=true;
node.SelectAction = TreeNodeSelectAction.Expand; //和ASP.NET1.1中TREEVIEW的SelectExpands属性等效
int sonparentid = int.Parse(nodeid);// Ｏr =location

if (parentnode == null)
{
TreeView1.Nodes.Clear();
parentnode = new TreeNode();
TreeView1.Nodes.Add(parentnode);
}
parentnode.ChildNodes.Add(node);
CreateNode(framename, sonparentid, node, dt);

}

}

}

...全文