public List <Z_一级结构表> 查询一级结构()
{
string sql = "SELECT * from Z_一级结构表";
SqlDataReader read = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
List <Z_一级结构表> listonejg = new List <Z_一级结构表>();
while (read.Read())
{
Z_一级结构表 model = new Z_一级结构表();
model.ID = Convert.ToInt32(read["ID"].ToString());
model.称 = read["名称"].ToString();
model.序显示名称 = read["程序显示名称"].ToString();
listonejg.Add(model);
}
read.Close();
return(listonejg);
}
private void ResolveSubTwo(Z_一级结构表 Row, TreeNode treeNode)
{
if (Row.ID > 0)
{
// 如果是目录，则默认展开
//treeNode.Expanded = true;
//treeNode.NodeID = "123";
List <用户单位表> listyhdw = bll.查询二级结构(Row.ID);
foreach (用户单位表 row in listyhdw)
{
if (row.ID > 0)
{
TreeNode node = new TreeNode();
node.IconUrl = @"~/res/icon/asterisk_yellow.png";
node.Text = row.称;
node.EnableClickEvent = true;
//node.NodeID = ;
node.NodeID = row.ID + "-二级";
treeNode.Nodes.Add(node);
ResolveSubTree(row, node);
}
}
}
}
