/// <summary>
/// 树的数据绑定，1张表，上级-1；
/// </summary>
/// <param name="TView"></param>
/// <param name="node"></param>
/// <param name="id"></param>
/// <param name="DataTable"></param>
/// <param name="ParentGuid"></param>
/// <param name="MenuGuid"></param>
/// <param name="MenuName"></param>
/// <param name="ConnetionString"></param>
public void AddNodes(TreeView TView, TreeNode node, string PidValue, string DataTable, string ParentGuid, string MenuGuid, string MenuName, string StrCondition, string OrderField, string SessionID)
{
try
{
sql = ControlDataBindSql.AddNodesSql(DataTable, ParentGuid, PidValue, StrCondition, OrderField);
DataSet ds = db.GetDataSet(sql);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows) //循环子节点集合
{
TreeNode nd = new TreeNode();
nd.Value = dr[MenuGuid].ToString(); //存放节点 ID
nd.Text = dr[MenuName].ToString(); //设置节点名称//
if (node == null || PidValue == "-1")
{
TView.Nodes.Add(nd); //添加至根节点
}
else
{
node.ChildNodes.Add(nd); //添加子节点
}
AddNodes(TView, nd, nd.Value, DataTable, ParentGuid, MenuGuid, MenuName, StrCondition, OrderField, SessionID); //递归，添加该节点的子节点
}
}
catch (Exception Err)
{
ErrorLog.LogInsert(Err.Message, "ControlDataBind", SessionID);
}
}
/// <summary>
/// 知识树/文章列表
/// </summary>
/// <param name="TView"></param>
/// <param name="node"></param>
/// <param name="PidValue"></param>
/// <param name="DataTable"></param>
/// <param name="ParentGuid"></param>
/// <param name="MenuGuid"></param>
/// <param name="MenuName"></param>
/// <param name="StrCondition"></param>
/// <param name="OrderField"></param>
/// <param name="SessionID"></param>
public void AddNodesArticle(TreeView TView, TreeNode node, string PidValue, string DataTable, string ParentGuid, string MenuGuid, string MenuName, string StrCondition, string OrderField, string SessionID)
{
try
{
if (node != null && PidValue != "-1")
{
sql = ControlDataBindSql.AddArticleSql(PidValue);
DataSet ds1 = db.GetDataSet(sql);
if (ds1.Tables[0].Rows.Count > 0)
{
for (int i = 0; i <= ds1.Tables[0].Rows.Count - 1; i++)
{
TreeNode nd1 = new TreeNode();
//nd1.ShowCheckBox = true;
nd1.Text = ds1.Tables[0].Rows[i]["ArticleTitle"].ToString();
nd1.Value = ds1.Tables[0].Rows[i]["KBaseArticle_Guid"].ToString();
//nd1.ImageUrl = "../images/folder.gif";
node.ChildNodes.Add(nd1);
}
}
}
sql = ControlDataBindSql.AddNodesSql(DataTable, ParentGuid, PidValue, StrCondition, OrderField);
DataSet ds = db.GetDataSet(sql);
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows) //循环子节点集合
{
TreeNode nd = new TreeNode();
nd.Value = dr[MenuGuid].ToString(); //存放节点 ID
nd.Text = dr[MenuName].ToString(); //设置节点名称
nd.ImageUrl = "../images/folder.gif"; //图像Url
nd.NavigateUrl = "#";
if (node == null || PidValue == "-1")
{
TView.Nodes.Add(nd); //添加至根节点
}
else
{
node.ChildNodes.Add(nd); //添加子节点
}
AddNodesArticle(TView, nd, nd.Value, DataTable, ParentGuid, MenuGuid, MenuName, StrCondition, OrderField, SessionID); //递归，添加该节点的子节点
}
}
}
catch (Exception Err)
{
ErrorLog.LogInsert(Err.Message, "CS/ControlDataBind", SessionID);
}
}
//树的数据绑定，2张表，子菜单
private void AddSNodes(TreeView TView, TreeNode node, string ParentValue, string SDataTable, string ConParentGuid, string SMenuGuid, string SMenuName, string SMenuUrl, string SStrCondition, string OrderField, string SessionID)
{
try
{
sql = ControlDataBindSql.AddNodesSql(SDataTable, ConParentGuid, ParentValue, SStrCondition, OrderField);
DataTable dt = db.GetDataTable(sql);
foreach (DataRow dr in dt.Rows) //循环子节点集合
{
TreeNode nd = new TreeNode();
nd.Value = dr[SMenuGuid].ToString(); //存放节点 ID
nd.Text = dr[SMenuName].ToString(); //设置节点名称
nd.Target = "QuestionMain";
nd.NavigateUrl = SMenuUrl + "?" + SMenuGuid + "=" + dr[SMenuGuid].ToString();
node.ChildNodes.Add(nd); //添加子节点
}
}
catch (Exception Err)
{
ErrorLog.LogInsert(Err.Message, "ControlDataBind", SessionID);
}
}
