📄 setorginfo.cs
字号:
//
// btnModify
//
this.btnModify.Location = new System.Drawing.Point(280, 120);
this.btnModify.Name = "btnModify";
this.btnModify.Size = new System.Drawing.Size(112, 23);
this.btnModify.TabIndex = 3;
this.btnModify.Text = "修改(&M)";
this.btnModify.Click += new System.EventHandler(this.btnModify_Click);
//
// btnDelete
//
this.btnDelete.Location = new System.Drawing.Point(280, 280);
this.btnDelete.Name = "btnDelete";
this.btnDelete.Size = new System.Drawing.Size(112, 23);
this.btnDelete.TabIndex = 8;
this.btnDelete.Text = "删除(&D)";
this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "组织机构编码表", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("内部编号", "内部编号"),
new System.Data.Common.DataColumnMapping("类别", "类别"),
new System.Data.Common.DataColumnMapping("AbsIndex", "AbsIndex"),
new System.Data.Common.DataColumnMapping("ItemIndex", "ItemIndex"),
new System.Data.Common.DataColumnMapping("ItemLevel", "ItemLevel"),
new System.Data.Common.DataColumnMapping("ParentIndex", "ParentIndex"),
new System.Data.Common.DataColumnMapping("类别号", "类别号"),
new System.Data.Common.DataColumnMapping("单位编号", "单位编号"),
new System.Data.Common.DataColumnMapping("单位名称", "单位名称"),
new System.Data.Common.DataColumnMapping("拼音编码", "拼音编码"),
new System.Data.Common.DataColumnMapping("单位地址", "单位地址"),
new System.Data.Common.DataColumnMapping("单位电话号码", "单位电话号码"),
new System.Data.Common.DataColumnMapping("开户银行", "开户银行"),
new System.Data.Common.DataColumnMapping("帐号", "帐号"),
new System.Data.Common.DataColumnMapping("开户全称", "开户全称")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM 组织机构编码表 WHERE (单位编号 = @Original_单位编号) AND (AbsIndex = @Original_AbsIndex OR @Original_AbsIndex IS NULL AND AbsIndex IS NULL) AND (ItemIndex = @Original_ItemIndex OR @Original_ItemIndex IS NULL AND ItemIndex IS NULL) AND (ItemLevel = @Original_ItemLevel OR @Original_ItemLevel IS NULL AND ItemLevel IS NULL) AND (ParentIndex = @Original_ParentIndex OR @Original_ParentIndex IS NULL AND ParentIndex IS NULL) AND (内部编号 = @Original_内部编号) AND (单位名称 = @Original_单位名称 OR @Original_单位名称 IS NULL AND 单位名称 IS NULL) AND (单位地址 = @Original_单位地址 OR @Original_单位地址 IS NULL AND 单位地址 IS NULL) AND (单位电话号码 = @Original_单位电话号码 OR @Original_单位电话号码 IS NULL AND 单位电话号码 IS NULL) AND (帐号 = @Original_帐号 OR @Original_帐号 IS NULL AND 帐号 IS NULL) AND (开户全称 = @Original_开户全称 OR @Original_开户全称 IS NULL AND 开户全称 IS NULL) AND (开户银行 = @Original_开户银行 OR @Original_开户银行 IS NULL AND 开户银行 IS NULL) AND (拼音编码 = @Original_拼音编码 OR @Original_拼音编码 IS NULL AND 拼音编码 IS NULL) AND (类别 = @Original_类别 OR @Original_类别 IS NULL AND 类别 IS NULL) AND (类别号 = @Original_类别号 OR @Original_类别号 IS NULL AND 类别号 IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单位编号", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单位编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_AbsIndex", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AbsIndex", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ItemIndex", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ItemIndex", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ItemLevel", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ItemLevel", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ParentIndex", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ParentIndex", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_内部编号", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "内部编号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单位名称", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单位名称", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单位地址", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单位地址", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单位电话号码", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单位电话号码", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_帐号", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "帐号", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_开户全称", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "开户全称", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_开户银行", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "开户银行", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_拼音编码", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "拼音编码", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类别", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类别", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类别号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类别号", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=hrmbook;";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO 组织机构编码表(类别, AbsIndex, ItemIndex, ItemLevel, ParentIndex, 类别号, 单位编号, 单位名称, 拼音编码, 单位地址, 单位电话号码, 开户银行, 帐号, 开户全称) VALUES (@类别, @AbsIndex, @ItemIndex, @ItemLevel, @ParentIndex, @类别号, @单位编号, @单位名称, @拼音编码, @单位地址, @单位电话号码, @开户银行, @帐号, @开户全称); SELECT 内部编号, 类别, AbsIndex, ItemIndex, ItemLevel, ParentIndex, 类别号, 单位编号, 单位名称, 拼音编码, 单位地址, 单位电话号码, 开户银行, 帐号, 开户全称 FROM 组织机构编码表 WHERE (单位编号 = @单位编号) ORDER BY AbsIndex";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类别", System.Data.SqlDbType.VarChar, 100, "类别"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@AbsIndex", System.Data.SqlDbType.Int, 4, "AbsIndex"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ItemIndex", System.Data.SqlDbType.Int, 4, "ItemIndex"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ItemLevel", System.Data.SqlDbType.Int, 4, "ItemLevel"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ParentIndex", System.Data.SqlDbType.Int, 4, "ParentIndex"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类别号", System.Data.SqlDbType.VarChar, 10, "类别号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位编号", System.Data.SqlDbType.VarChar, 20, "单位编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位名称", System.Data.SqlDbType.VarChar, 100, "单位名称"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@拼音编码", System.Data.SqlDbType.VarChar, 50, "拼音编码"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位地址", System.Data.SqlDbType.VarChar, 100, "单位地址"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位电话号码", System.Data.SqlDbType.VarChar, 50, "单位电话号码"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@开户银行", System.Data.SqlDbType.VarChar, 100, "开户银行"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@帐号", System.Data.SqlDbType.VarChar, 50, "帐号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@开户全称", System.Data.SqlDbType.VarChar, 100, "开户全称"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 内部编号, 类别, AbsIndex, ItemIndex, ItemLevel, ParentIndex, 类别号, 单位编号, 单位名称, 拼音" +
"编码, 单位地址, 单位电话号码, 开户银行, 帐号, 开户全称 FROM 组织机构编码表 ORDER BY AbsIndex";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE 组织机构编码表 SET 类别 = @类别, AbsIndex = @AbsIndex, ItemIndex = @ItemIndex, ItemLevel = @ItemLevel, ParentIndex = @ParentIndex, 类别号 = @类别号, 单位编号 = @单位编号, 单位名称 = @单位名称, 拼音编码 = @拼音编码, 单位地址 = @单位地址, 单位电话号码 = @单位电话号码, 开户银行 = @开户银行, 帐号 = @帐号, 开户全称 = @开户全称 WHERE (单位编号 = @Original_单位编号) AND (AbsIndex = @Original_AbsIndex OR @Original_AbsIndex IS NULL AND AbsIndex IS NULL) AND (ItemIndex = @Original_ItemIndex OR @Original_ItemIndex IS NULL AND ItemIndex IS NULL) AND (ItemLevel = @Original_ItemLevel OR @Original_ItemLevel IS NULL AND ItemLevel IS NULL) AND (ParentIndex = @Original_ParentIndex OR @Original_ParentIndex IS NULL AND ParentIndex IS NULL) AND (单位名称 = @Original_单位名称 OR @Original_单位名称 IS NULL AND 单位名称 IS NULL) AND (单位地址 = @Original_单位地址 OR @Original_单位地址 IS NULL AND 单位地址 IS NULL) AND (单位电话号码 = @Original_单位电话号码 OR @Original_单位电话号码 IS NULL AND 单位电话号码 IS NULL) AND (帐号 = @Original_帐号 OR @Original_帐号 IS NULL AND 帐号 IS NULL) AND (开户全称 = @Original_开户全称 OR @Original_开户全称 IS NULL AND 开户全称 IS NULL) AND (开户银行 = @Original_开户银行 OR @Original_开户银行 IS NULL AND 开户银行 IS NULL) AND (拼音编码 = @Original_拼音编码 OR @Original_拼音编码 IS NULL AND 拼音编码 IS NULL) AND (类别 = @Original_类别 OR @Original_类别 IS NULL AND 类别 IS NULL) AND (类别号 = @Original_类别号 OR @Original_类别号 IS NULL AND 类别号 IS NULL); SELECT 内部编号, 类别, AbsIndex, ItemIndex, ItemLevel, ParentIndex, 类别号, 单位编号, 单位名称, 拼音编码, 单位地址, 单位电话号码, 开户银行, 帐号, 开户全称 FROM 组织机构编码表 WHERE (单位编号 = @单位编号) ORDER BY AbsIndex";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类别", System.Data.SqlDbType.VarChar, 100, "类别"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@AbsIndex", System.Data.SqlDbType.Int, 4, "AbsIndex"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ItemIndex", System.Data.SqlDbType.Int, 4, "ItemIndex"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ItemLevel", System.Data.SqlDbType.Int, 4, "ItemLevel"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ParentIndex", System.Data.SqlDbType.Int, 4, "ParentIndex"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类别号", System.Data.SqlDbType.VarChar, 10, "类别号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位编号", System.Data.SqlDbType.VarChar, 20, "单位编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位名称", System.Data.SqlDbType.VarChar, 100, "单位名称"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@拼音编码", System.Data.SqlDbType.VarChar, 50, "拼音编码"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位地址", System.Data.SqlDbType.VarChar, 100, "单位地址"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单位电话号码", System.Data.SqlDbType.VarChar, 50, "单位电话号码"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@开户银行", System.Data.SqlDbType.VarChar, 100, "开户银行"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@帐号", System.Data.SqlDbType.VarChar, 50, "帐号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@开户全称", System.Data.SqlDbType.VarChar, 100, "开户全称"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单位编号", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单位编号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_AbsIndex", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AbsIndex", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ItemIndex", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ItemIndex", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ItemLevel", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ItemLevel", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ParentIndex", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ParentIndex", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单位名称", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单位名称", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单位地址", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单位地址", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_单位电话号码", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "单位电话号码", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_帐号", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "帐号", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_开户全称", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "开户全称", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_开户银行", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "开户银行", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_拼音编码", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "拼音编码", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类别", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类别", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类别号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类别号", System.Data.DataRowVersion.Original, null));
//
// SetOrgInfo
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(672, 421);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.treeView1);
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.Name = "SetOrgInfo";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "【机构设置及编码】";
this.Load += new System.EventHandler(this.SetOrgInfo_Load);
this.groupBox1.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
///
//-------------在窗体初始化时，根据数据库中的记录创建树形图----------------
private void SetOrgInfo_Load(object sender, System.EventArgs e)
{
this.sqlDataAdapter1.Fill(tblSetOrgInfo);//读入数据
DataTable tempDataTable = tblSetOrgInfo.Copy();//将组织机构表另存一份为tempDataTable
DataView viewSetOrgInfo = new DataView(tempDataTable);//新建一个数据视图
viewSetOrgInfo.RowFilter = "ItemLevel = 0";
//将数据集中的所有记录逐个根据他们之间的关系添加到树形表中去
if (viewSetOrgInfo.Count > 0)
{
foreach (DataRowView myRow in viewSetOrgInfo)
{
string strEnterpriseName = myRow["单位名称"].ToString().Trim();
//此处是添加第一个节点“省医药集团”
this.treeView1.Nodes.Add(new TreeNode(strEnterpriseName));
//此处初始化参数是第一个节点“省医药集团”,然后该函数会递归添加所有子节点
PopulateTreeView(strEnterpriseName,treeView1.Nodes[0],myRow);
treeView1.SelectedNode = treeView1.Nodes[0]; //选中第一个节点
}
}
}
//---------------根据输入的节点信息，递归调用最终添加所有的节点-----------------------
private void PopulateTreeView(string parentPart,TreeNode parentNode,DataRowView parentRow)
{
string strEnterpriseName = "";
DataTable tempDataTable = tblSetOrgInfo.Copy();
DataView viewSetOrgInfo = new DataView(tempDataTable);
//筛选获得当前传递过来的节点的子项，并将其添加到树形图中
//判断方法是凡parentIndex等于传递过来的节点的absIndex的，就是该节点的子项
viewSetOrgInfo.RowFilter = "ParentIndex = '" + parentRow["AbsIndex"].ToString().Trim() + "'";
//递归的添加每一个节点的所有子节点
foreach (DataRowView myRow in viewSetOrgInfo)
{
strEnterpriseName = myRow["单位名称"].ToString().Trim();
TreeNode myNode = new TreeNode(strEnterpriseName);
parentNode.Nodes.Add(myNode);
//函数递归调用，将所有节点按顺序添加完毕
PopulateTreeView(strEnterpriseName,myNode,myRow);
}
}
//-----------当选中某一个节点时，在右边的文本框中显示其详细信息-------------------
private void treeView1_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
{
this.textBox1.Text = e.Node.Text.Trim();
InputTextBox2AndTextBox3(e.Node); //填写TextBox2和TextBox3
}
//-----------根据父节点和节点所处的位置，计算合成编码，编码算法见章节中叙述-------------------
private void CalParentNodesCount(TreeNode myNode)
{
if (myNode == null)
{
return;
}
if (myNode.Index>=10 || myNode.Parent == null)
strTextBox3_Text = myNode.Index.ToString().Trim() + strTextBox3_Text;
else
strTextBox3_Text = "0" + myNode.Index.ToString().Trim() + strTextBox3_Text;
if (myNode.Parent != null)
{
CalParentNodesCount(myNode.Parent);
}
}
//-----------------根据节点位置，显示本级别编码和机构合成编码信息---------------------
private void InputTextBox2AndTextBox3(TreeNode myNode)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -