/// <summary>
/// 将表中的项按照层次加到TreeNode中
/// </summary>
/// <param name="treeV"></param>
/// <param name="menuS"></param>
public static void tvwDepartmentGetNode(TreeView treeV)
{
DataTable dt = FrmOrganizationStruDAO.GetTopDepartmentData();//获取根部门数据
//遍历数据表中的一级菜单项
foreach (DataRow dr in dt.Rows)
{
//循环添加根部门
TreeNode node1 = treeV.Nodes.Add(dr["DepartmentNo"].ToString(), dr["DepartmentName"].ToString());
GetChildNode(node1, dr["DepartmentNo"].ToString());
}
}
//生成子部门节点
private static void GetChildNode(TreeNode node1, string strParentDepartmentNo)
{
//ToolStripMenuItem pItem = (ToolStripMenuItem)item;
DataTable dt1 = FrmOrganizationStruDAO.GetChildDepartmentData(strParentDepartmentNo);//获取子部门数据
foreach (DataRow dr1 in dt1.Rows)
{
if (dr1 != null)
{
TreeNode node2 = node1.Nodes.Add(dr1["DepartmentNo"].ToString(), dr1["DepartmentName"].ToString());
GetChildNode(node2, node2.Name);//递归
}
}
}
private void tsbSave_Click(object sender, EventArgs e)
{
//createDateDateTimePicker.Value = DateTime.Now;//建立日期设定为保存时间
//founderTextBox.Text = FrmLoginDAO.user.EmpName;//获取当前登录用户姓名
if (string.IsNullOrEmpty(departmentNoTextBox1.Text))
{
MessageBox.Show("【部门编码】为必填项！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
departmentNoTextBox1.Focus();
return;
}
//if (string.IsNullOrEmpty(departmentNameTextBox1.Text))
//{
// MessageBox.Show("【部门名称】为必填项！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
// departmentNameTextBox1.Focus();
// return;
//}
try
{
//先更新相关数据
FrmOrganizationStruDAO.UpdateDeptmentNoCorrelationData(bS_DepartmentDataGridView.CurrentRow.Cells[1].Value.ToString(), departmentNoTextBox1.Text);
//更新部门编码
this.Validate();
this.bS_DepartmentBindingSource.EndEdit();
this.bS_DepartmentTableAdapter.Update(this.dsPSAP);
ChangeEnabledState();//保存后更新控件状态
//使sql更改同步到DataGridView
this.bS_DepartmentTableAdapter.Fill(this.dsPSAP.BS_Department);
bS_DepartmentDataGridView.DataSource = bS_DepartmentBindingSource;
}
catch (System.Data.ConstraintException)//关键字字段值重复
{
MessageBox.Show("此部门编码已经存在！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
departmentNoTextBox1.Focus();
}
bS_DepartmentDataGridView.Enabled = true;//保存后数据表控件可用
}
