/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmRight_MenuManagement_Load(object sender, EventArgs e)
{
try
{
if (editForm == null)
{
editForm = new FrmBaseEdit();
editForm.FormBorderStyle = FormBorderStyle.None;
editForm.TopLevel = false;
editForm.TableName = "BS_Menu";
editForm.TableCaption = "主菜单管理";
editForm.Sql = "select BS_Menu.*, menu.MenuText as ParentMenuText from BS_Menu left join BS_Menu as menu on BS_Menu.ParentMenuName = menu.MenuName order by BS_Menu.MenuOrder, BS_Menu.AutoId";
//必须按照MenuOrder，AutoId进行排序，否则树显示的顺序不准确
editForm.PrimaryKeyColumn = "MenuName";
editForm.MasterDataSet = dSMenu;
editForm.MasterBindingSource = bSMenu;
editForm.MasterEditPanel = pnlEdit;
//editForm.PrimaryKeyControl = textMenuText;
editForm.BrowseXtraGridView = gridViewMenu;
editForm.CheckControl += CheckControl;
editForm.QueryDataAfter += QueryDataAfter;
editForm.SaveRowBefore += SaveRowBefore;
this.pnlToolBar.Controls.Add(editForm);
editForm.Dock = DockStyle.Fill;
editForm.Show();
lookUpFormName.Properties.DataSource = FrmRightBLL.InitFormNameDataTable();
searchParentMenuName.Properties.DataSource = FrmRightDAO.QueryMenuList();
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
private void addRootTreeNode_Click(object sender, EventArgs e)
{
try
{
tvwMainMenu.Nodes.Add("新建主菜单");
tvwMainMenu.SelectedNode.Expand();
//选定新建节点
tvwMainMenu.SelectedNode = tvwMainMenu.Nodes[tvwMainMenu.Nodes.Count - 1];
string nodeId = FrmRightBLL.getNewNodeId();
tvwMainMenu.SelectedNode.Name = nodeId;
//将新建节点同步到数据库
bS_MenuBindingSource.AddNew();
bS_MenuDataGridView.CurrentRow.Cells[0].Value = tvwMainMenu.SelectedNode.Name;
bS_MenuDataGridView.CurrentRow.Cells[1].Value = tvwMainMenu.SelectedNode.Text;
bS_MenuDataGridView.CurrentRow.Cells[5].Value = tvwMainMenu.SelectedNode.Index.ToString();
this.Validate();
this.bS_MenuBindingSource.EndEdit();
this.bS_MenuTableAdapter.Update(dsPSAP.BS_Menu);
FrmRightDAO.RefreshMenuButton(nodeId);
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
/// <summary>
/// 保存权限事件
/// </summary>
private void btnSaveRight_Click(object sender, EventArgs e)
{
try
{
if (!FrmMainDAO.QueryUserButtonPower(this.Name, this.Text, sender, true))
{
return;
}
if (!string.IsNullOrEmpty(DataTypeConvert.GetString(cboRoleName.EditValue)))
{
dgvUserList.SetFocusedRowCellValue(dgvUserList.Columns["RoleName"], cboRoleName.Text);
dgvUserList.SetFocusedRowCellValue(dgvUserList.Columns["RoleNo"], cboRoleName.EditValue);
dgvUserList.SetFocusedRowCellValue(gridColButtonPower, DataTypeConvert.GetInt(checkButtonPower.EditValue));
FrmRightDAO.SaveRoleUser(cboRoleName.EditValue.ToString(), DataTypeConvert.GetInt(dgvUserList.GetFocusedDataRow()["AutoId"]), DataTypeConvert.GetInt(checkButtonPower.EditValue));
FrmRightDAO.GiveRoleAllButtonRight();
}
FrmRightBLL.SavePersonalRightFromTree(tvwUserRight, dgvUserList);//遍历树保存权限
//FrmMain.frmMain.tsrLblCurrentStatusText = "【用户权限】已成功保存";
MessageHandler.ShowMessageBox(tsmiYhqxycgbc.Text);// ("【用户权限】已成功保存。");
}
catch (Exception ex)
{
//ExceptionHandler.HandleException(this.Text + "--查询用户权限信息错误。", ex);
ExceptionHandler.HandleException(this.Text + "--" + tsmiCxyhqxxxcw.Text, ex);
}
}
private void FrmUserRight_Load(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“dsPSAP.BS_Menu”中。您可以根据需要移动或删除它。
this.bS_MenuTableAdapter.Fill(this.dsPSAP.BS_Menu);
// TODO: 这行代码将数据加载到表“dsPSAP.BS_Role”中。您可以根据需要移动或删除它。
this.bS_RoleTableAdapter.Fill(this.dsPSAP.BS_Role);
// TODO: 这行代码将数据加载到表“dsPSAP.BS_Department”中。您可以根据需要移动或删除它。
this.bS_DepartmentTableAdapter.Fill(this.dsPSAP.BS_Department);
dtblTmp = BSCommon.getUserInfoList("", "", "");
dgvUserList.DataSource = dtblTmp;
dgvUserList.ColumnHeadersHeight = 32;
dgvUserList.Columns[0].Width = 40;
dgvUserList.Columns[1].Width = 60;
dgvUserList.Columns[2].Width = 60;
dgvUserList.Columns[3].Width = 90;
dgvUserList.Columns[4].Width = 90;
dgvUserList.Columns[5].Width = 60;
dgvUserList.Columns[0].DataPropertyName = dtblTmp.Columns["AutoId"].ToString();
dgvUserList.Columns[1].DataPropertyName = dtblTmp.Columns["LoginID"].ToString();
dgvUserList.Columns[2].DataPropertyName = dtblTmp.Columns["EmpName"].ToString();
dgvUserList.Columns[3].DataPropertyName = dtblTmp.Columns["DepartmentName"].ToString();
dgvUserList.Columns[4].DataPropertyName = dtblTmp.Columns["RoleName"].ToString();
dgvUserList.Columns[5].DataPropertyName = dtblTmp.Columns["RoleNo"].ToString();
dgvUserList.Columns[0].HeaderText = "员工编号";
dgvUserList.Columns[1].HeaderText = "用户编号";
dgvUserList.Columns[2].HeaderText = "用户姓名";
dgvUserList.Columns[3].HeaderText = "部门";
dgvUserList.Columns[4].HeaderText = "角色";
dgvUserList.Columns[5].HeaderText = "角色编号";
dgvUserList.Columns[0].Visible = false;
dgvUserList.Columns[5].Visible = false;
dtblTmp1 = BSCommon.getDepartmentList();
cboDepartmentName.DataSource = dtblTmp1;
cboDepartmentName.DisplayMember = "DepartmentName";
//角色combo
dtblTmp1 = BSCommon.getRoleList();
cboRoleName.DataSource = dtblTmp1;
cboRoleName.DisplayMember = "RoleName";
cboRoleName.ValueMember = "RoleNo";
//初始化【菜单管理page】
mnsMainMenu.Items.Clear();
FrmMainBLL.InitMenuItem(mnsMainMenu);//初始化主菜单
FrmRightBLL.TreeGetNodeForMns(tvwMainMenu, mnsMainMenu);
tvwMainMenu.ExpandAll();
FrmRightBLL.InitDataGridViewComboFormName(dataGridViewComboFormName); //初始化窗口名下拉列表
FrmRightBLL.TraverseFormControlToTable(); // 遍历所有DockContent窗口及其中控件,并将结果加至数据库表中(系统完成后可停用)
//初始化【角色管理page】
InitEnableState();//初始化控件按钮状态
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmRight_MenuManagement_Load(object sender, EventArgs e)
{
try
{
lookUpFormName.Properties.DataSource = FrmRightBLL.InitFormNameDataTable();
searchParentMenuName.Properties.DataSource = FrmRightDAO.QueryMenuList();
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
private void btnSaveRight_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(cboRoleName.SelectedValue.ToString()))
{
dgvUserList.CurrentRow.Cells[4].Value = cboRoleName.Text;
dgvUserList.CurrentRow.Cells[5].Value = cboRoleName.SelectedValue;
FrmRightDAO.SaveRoleUser(cboRoleName.SelectedValue.ToString(), (int)dgvUserList.CurrentRow.Cells[0].Value, 0);
FrmRightDAO.GiveRoleAllButtonRight();
}
FrmRightBLL.SavePersonalRightFromTree(tvwUserRight, dgvUserList);//遍历树保存权限
FrmMain.frmMain.tsrLblCurrentStatusText = "【用户权限】已成功保存";
}
/// <summary>
/// 设定默认值
/// </summary>
private void TableMenu_TableNewRow(object sender, DataTableNewRowEventArgs e)
{
e.Row["MenuName"] = FrmRightBLL.getNewNodeId();
e.Row["FormName"] = "";
e.Row["FormText"] = "";
if (parentMenuNameStr != "")
{
e.Row["ParentMenuName"] = parentMenuNameStr;
e.Row["ParentMenuText"] = parentMenuTextStr;
parentMenuNameStr = "";
parentMenuTextStr = "";
}
}
private void dgvRoleList_SelectionChanged(object sender, EventArgs e)
{
if (dgvRoleList.CurrentRow != null)
{
mnsRight.Items.Clear();
FrmMainBLL.InitMenuItem(mnsRight); //初始化权限菜单
FrmMainBLL.SetMenuItemByRole(mnsRight, dgvRoleList.CurrentRow.Cells[1].Value.ToString()); //初始化角色权限
tvwRoleRight.Nodes.Clear();
FrmRightBLL.TreeGetNodeForMns(tvwRoleRight, mnsRight);
tvwRoleRight.ExpandAll();
//FrmRightBLL.TreeAddButtonsNode(tvwRoleRight, dgvUserList.CurrentRow.Cells[0].Value.ToString());//遍历窗口中的按钮，加到指定的Tree的叶子节点上
}
}
/// <summary>
/// 窗体加载事件
/// </summary>
private void FrmRight_UserMenuButton_Load(object sender, EventArgs e)
{
try
{
tvwUserRight.Nodes.Clear();
new FrmMainBLL().InitTreeList(tvwUserRight);
FrmRightBLL.TreeAddButtonsNode(tvwUserRight);
InitControl();
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex);
}
}
private void addChildTreeNode_Click(object sender, EventArgs e)
{
try
{
tvwOrganizationStru.SelectedNode.Nodes.Add("新建子部门");
tvwOrganizationStru.SelectedNode.Expand();
tvwOrganizationStru.SelectedNode = tvwOrganizationStru.SelectedNode.LastNode;
string nodeId = FrmRightBLL.getNewNodeId();
tvwOrganizationStru.SelectedNode.Name = nodeId;
saveNodeToTable();//将新建节点同步到数据库
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--addChildTreeNode_Click错误。", ex);
}
}
private void addChildTreeNode_Click(object sender, EventArgs e)
{
try
{
tvwOrganizationStru.SelectedNode.Nodes.Add("新建子部门");
tvwOrganizationStru.SelectedNode.Expand();
tvwOrganizationStru.SelectedNode = tvwOrganizationStru.SelectedNode.LastNode;
string nodeId = FrmRightBLL.getNewNodeId();
tvwOrganizationStru.SelectedNode.Name = nodeId;
saveNodeToTable();//将新建节点同步到数据库
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
private void tsbSave_Click(object sender, EventArgs e)
{
//createDateDateTimePicker.Value = DateTime.Now;//建立日期设定为保存时间
//founderTextBox.Text = BSCheckUser.user.EmpName;//获取当前登录用户姓名
if (string.IsNullOrEmpty(roleNoTextBox.Text))
{
MessageBox.Show("【角色编码】为必填项！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
roleNoTextBox.Focus();
return;
}
if (string.IsNullOrEmpty(roleNameTextBox.Text))
{
MessageBox.Show("【角色名称】为必填项！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
roleNameTextBox.Focus();
return;
}
try
{
this.Validate();
this.bS_RoleBindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.dsPSAP);
ChangeEnabledState();//保存后更新控件状态
//刷新角色combo
dtblTmp1 = BSCommon.getRoleList();
cboRoleName.DataSource = dtblTmp1;
cboRoleName.DisplayMember = "RoleName";
cboRoleName.ValueMember = "RoleNo";
}
catch (System.Data.ConstraintException)//关键字字段值重复
{
MessageBox.Show("此角色【部门编码】已经存在！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
roleNoTextBox.Focus();
}
catch (System.Data.SqlClient.SqlException)//外键约束
{
MessageBox.Show("此角色【部门编码】已经被分配权限，不允许修改！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
//执行一遍取消操作
}
FrmRightBLL.SaveRoleRightFromTree(tvwRoleRight, dgvRoleList); //遍历树保存权限
FrmRightDAO.GiveRoleAllButtonRight();
dgvRoleList.Enabled = true; //保存后数据表控件可用
}
private void dgvUserList_SelectionChanged(object sender, EventArgs e)
{
if (dgvUserList.CurrentRow != null)
{
cboRoleName.Text = "";
mnsRight.Items.Clear();
FrmMainBLL.InitMenuItem(mnsRight); //初始化权限菜单
FrmMainBLL.SetMenuItemByRole(mnsRight, dgvUserList.CurrentRow.Cells[5].Value.ToString()); //初始化用户权限
FrmMainBLL.SetMenuItemByPersonal(mnsRight, dgvUserList.CurrentRow.Cells[0].Value.ToString()); //初始化用户"个人"权限
//初始化treeView1
tvwUserRight.Nodes.Clear();
FrmRightBLL.TreeGetNodeForMns(tvwUserRight, mnsRight);
tvwUserRight.ExpandAll();
FrmRightBLL.TreeAddButtonsNode(tvwUserRight, dgvUserList.CurrentRow.Cells[0].Value.ToString());//遍历窗口中的按钮，加到指定的Tree的叶子节点上
}
}
private void addChildTreeNode_Click(object sender, EventArgs e)
{
try
{
tvwMainMenu.SelectedNode.Nodes.Add("新建子菜单");
tvwMainMenu.SelectedNode.Expand();
tvwMainMenu.SelectedNode = tvwMainMenu.SelectedNode.LastNode;
string nodeId = FrmRightBLL.getNewNodeId();
tvwMainMenu.SelectedNode.Name = nodeId;
saveNodeToTable();//将新建节点同步到数据库
FrmRightDAO.RefreshMenuButton(nodeId);
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
//显示查询条件End
#region 表标题树相关方法
//private void insertColumnHeader_Click(object sender, EventArgs e)
//{
// try
// {
// int i = tabControl2.SelectedIndex;
// string nName;
// nName = tvwTablesHeader[i].SelectedNode.Name;
// if (tvwTablesHeader[i].SelectedNode.Parent != null)
// {
// tvwTablesHeader[i].SelectedNode.Parent.Nodes.Insert(tvwTablesHeader[i].SelectedNode.Index, "插入列标题");
// }
// else
// {
// tvwTablesHeader[i].Nodes.Insert(tvwTablesHeader[i].SelectedNode.Index, "插入列标题");
// }
// tvwTablesHeader[i].SelectedNode.Expand();
// tvwTablesHeader[tabControl2.SelectedIndex].SelectedNode = tvwTablesHeader[i].SelectedNode.PrevNode;
// string nodeId = FrmRightBLL.getNewNodeId();
// tvwTablesHeader[i].SelectedNode.Name = nodeId;
// FrmDataQueryDesignDAO.saveCreateChildNode(Convert.ToInt16(tvtbQueryList_User.SelectedNode.Name),
// Convert.ToInt16(tvwTablesHeader[i].Tag), nodeId, tvwTablesHeader[i].SelectedNode.Text, tvwTablesHeader[i].SelectedNode.Parent != null && tvwTablesHeader[i].SelectedNode.Parent.Name != string.Empty ? tvwTablesHeader[i].SelectedNode.Parent.Name : null);
// }
// catch (Exception e1)
// {
// MessageBox.Show(e1.Message);
// }
//}
private void insertChildColumnHeader_Click(object sender, EventArgs e)
{
try
{
int i = tabControl2.SelectedIndex;
tvwTablesHeader[i].SelectedNode.Nodes.Add("新建子列标题");
tvwTablesHeader[i].SelectedNode.Expand();
tvwTablesHeader[i].SelectedNode = tvwTablesHeader[i].SelectedNode.LastNode;
string nodeId = FrmRightBLL.getNewNodeId();
tvwTablesHeader[i].SelectedNode.Name = nodeId;
FrmDataQueryDesignDAO.saveCreateChildNode(Convert.ToInt16(tvtbQueryList_User.SelectedNode.Name),
Convert.ToInt16(tvwTablesHeader[i].Tag), nodeId, tvwTablesHeader[i].SelectedNode.Text, tvwTablesHeader[i].SelectedNode.Parent.Name);
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
//同级菜单
private void insertTreeNode_Click(object sender, EventArgs e)
{
try
{
string nName;
nName = tvwOrganizationStru.SelectedNode.Name;
tvwOrganizationStru.SelectedNode.Parent.Nodes.Insert(tvwOrganizationStru.SelectedNode.Index, "插入同级部门");
tvwOrganizationStru.SelectedNode.Expand();
tvwOrganizationStru.SelectedNode = tvwOrganizationStru.SelectedNode.PrevNode;
string nodeId = FrmRightBLL.getNewNodeId();
tvwOrganizationStru.SelectedNode.Name = nodeId;
saveNodeToTable();//将新建节点同步到数据库
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
//同级菜单
private void insertTreeNode_Click(object sender, EventArgs e)
{
try
{
string nName;
nName = tvwOrganizationStru.SelectedNode.Name;
tvwOrganizationStru.SelectedNode.Parent.Nodes.Insert(tvwOrganizationStru.SelectedNode.Index, "插入同级部门");
tvwOrganizationStru.SelectedNode.Expand();
tvwOrganizationStru.SelectedNode = tvwOrganizationStru.SelectedNode.PrevNode;
string nodeId = FrmRightBLL.getNewNodeId();
tvwOrganizationStru.SelectedNode.Name = nodeId;
saveNodeToTable();//将新建节点同步到数据库
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--insertTreeNode_Click错误。", ex);
}
}
private void createRootColumnHeader_Click(object sender, EventArgs e)
{
try
{
int i = tabControl2.SelectedIndex;
tvwTablesHeader[i].Nodes.Add("新建根列标题");
tvwTablesHeader[i].SelectedNode.Expand();
//选定新建节点
tvwTablesHeader[i].SelectedNode = tvwTablesHeader[i].Nodes[tvwTablesHeader[i].Nodes.Count - 1];
string nodeId = FrmRightBLL.getNewNodeId();
tvwTablesHeader[i].SelectedNode.Name = nodeId;
FrmDataQueryDesignDAO.saveCreateRootNode(Convert.ToInt16(tvtbQueryList_User.SelectedNode.Name),
Convert.ToInt16(tvwTablesHeader[i].Tag), nodeId, tvwTablesHeader[i].SelectedNode.Text);
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--deleteRootColumnHeader_Click错误。", ex);
}
}
//同级菜单
private void insertTreeNode_Click(object sender, EventArgs e)
{
try
{
string nName;
nName = tvwMainMenu.SelectedNode.Name;
tvwMainMenu.SelectedNode.Parent.Nodes.Insert(tvwMainMenu.SelectedNode.Index, "插入同级菜单");
tvwMainMenu.SelectedNode.Expand();
tvwMainMenu.SelectedNode = tvwMainMenu.SelectedNode.PrevNode;
string nodeId = FrmRightBLL.getNewNodeId();
tvwMainMenu.SelectedNode.Name = nodeId;
saveNodeToTable();//将新建节点同步到数据库
FrmRightDAO.RefreshMenuButton(nodeId);
}
catch (Exception e1)
{
MessageBox.Show(e1.Message);
}
}
