http://bbs.csdn.net/topics/370139193
1
2
3
4
5
6
|
CREATE
TABLE
[dbo].[Company] (
[Id] [
int
] IDENTITY (1, 1)
Primary
Key
NOT
NULL
,
[Levers] [
varchar
] (50)
COLLATE
Chinese_PRC_CI_AS
NULL
,
[LevelId] [
varchar
] (50)
COLLATE
Chinese_PRC_CI_AS
NULL
,
[
Name
] [
varchar
] (50)
COLLATE
Chinese_PRC_CI_AS
NULL
)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
|
public
partial
class
Form1 : Form
{
public
string
rootId =
"-1"
;
public
Form1()
{
InitializeComponent();
AddRootCompany(rootId);
AddSubCompany();
}
/// <summary>
/// 添加总公司
/// </summary>
/// <param name="rootId"></param>
private
void
AddRootCompany(
string
rootId)
{
DataSet ds =
new
DataSet();
using
(SqlConnection con =
new
SqlConnection(
"Data Source=localhost;uid=sa;pwd=saiyang;Database=CSDN"
))
{
con.Open();
string
strSQL =
"select * from Company where Levers='"
+ rootId +
"'"
;
using
(SqlDataAdapter adapter =
new
SqlDataAdapter(strSQL, con))
{
adapter.Fill(ds);
}
TreeNode NewNode =
new
TreeNode();
NewNode.Text = ds.Tables[0].Rows[0][
"Name"
].ToString().Trim();
this
.treeView1.Nodes.Add(NewNode);
}
}
/// <summary>
/// 添加子公司
/// </summary>
private
void
AddSubCompany()
{
DataSet ds = getMenuByLevel(rootId.ToString());
for
(
int
j = 0; j < ds.Tables[0].Rows.Count; j++)
{
InitTreeCompanyChildNode(treeView1.Nodes[j], ds.Tables[0].Rows[j][
"LevelId"
].ToString());
}
}
/// <summary>
/// 获取层次级别
/// </summary>
/// <param name="getparams"></param>
/// <returns></returns>
public
DataSet getMenuByLevel(
string
param)
{
DataSet ds =
new
DataSet();
using
(SqlConnection con =
new
SqlConnection(
"Data Source=localhost;Initial Catalog=CSDN;User ID=sa;Password=saiyang"
))
{
con.Open();
string
strSQL =
"select * from Company where Levers='"
+ param +
"'"
;
using
(SqlDataAdapter adapter =
new
SqlDataAdapter(strSQL, con))
{
adapter.Fill(ds);
}
}
return
ds;
}
/// <summary>
/// 递归获取子节点
/// </summary>
/// <param name="PNode"></param>
/// <param name="classParentID"></param>
private
void
InitTreeCompanyChildNode(TreeNode pNode,
string
classParentID)
{
DataSet ds = getMenuByLevel(classParentID);
DataView dataView =
new
DataView();
dataView = ds.Tables[0].DefaultView;
foreach
(DataRowView drv
in
dataView)
{
string
id = drv[
"LevelId"
].ToString();
string
name = drv[
"Name"
].ToString();
TreeNode NewNode =
new
TreeNode();
//将子公司添加到父节点下面
NewNode.Text = name;
pNode.Nodes.Add(NewNode);
InitTreeCompanyChildNode(NewNode, id);
}
}
}
|