/// <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); } }