TreeView的三级节点

最新推荐文章于 2023-11-03 22:17:08 发布

weishang1989

最新推荐文章于 2023-11-03 22:17:08 发布

阅读量1.8k

点赞数

分类专栏：专业相关文章标签： string table c

本文链接：https://blog.csdn.net/weishang1989/article/details/3514941

版权

专业相关专栏收录该内容

14 篇文章 0 订阅

订阅专栏

    public void MyGetBankList()
    {
        TreeView1.Nodes.Clear();

DataTable datatable = QuestionBankManage.GetBankList();

        if (datatable.Rows.Count > 0)
        {
            foreach (DataRow row in datatable.Rows)
            {
                string sId = row["BankId"].ToString();
                string sName = row["BankName"].ToString();

string sText = "<strong style='color:#473C8B'>" + sId + "_" + sName + "</strong>";

TreeNode node = new TreeNode(sText, sId);

this.MyGetTypeList(node);

                TreeView1.Nodes.Add(node);
            }
        }
    }

    public void MyGetTypeList(TreeNode parentNode)
    {
        DataTable datatable = QuestionTypeManage.GetQuestionTypeList();

parentNode.ChildNodes.Clear();

        if (datatable.Rows.Count > 0)
        {
            foreach (DataRow row in datatable.Rows)
            {
                string sId = row["TypeId"].ToString();
                string sName = row["TypeName"].ToString();
                string sCount = QuestionManage.MyGetQuestionCount(parentNode.Value, sId);
                string sText = "<strong style='color:#B22222'>" + sId + "_" + sName + sCount + "</strong>";

TreeNode node = new TreeNode(sText, sId);

this.MyGetQuestionList(node, parentNode.Value, node.Value);

                parentNode.ChildNodes.Add(node);
            }
        }
    }

    public void MyGetQuestionList(TreeNode parentNode, string sBankId, string sTypeId)
    {
        string sSql = string.Format("select * from Question where BankId='{0}' and TypeId='{1}'", sBankId, sTypeId);
        DataTable table = CommClass.GetDataTable(sSql);
        if (table.Rows.Count > 0)
        {
            parentNode.ChildNodes.Clear();
            foreach (DataRow row in table.Rows)
            {
                string sId = row["QuestionId"].ToString();
                string sName = row["Subject"].ToString();
                TreeNode node = new TreeNode(sId + "_" + sName, sId);

string sUrl = string.Format("QuestionMark.aspx?action=1&did={0}", row["Did"].ToString());
node.NavigateUrl = sUrl;

                parentNode.ChildNodes.Add(node);
            }
        }
    }