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 btnQuery_Click(object sender, EventArgs e) { try { gridControlUserList.DataSource = BSCommon.getUserInfoList(txtLoginID.Text.Trim(), txtUserName.Text.Trim(), lookUpReqDep.Text.Trim() == "全部" ? "" : lookUpReqDep.Text.Trim()); } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--查询用户权限信息错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + tsmiCxyhqxxxcw.Text, ex); } }
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 InitControl() { try { lookUpReqDep.Properties.DataSource = commonDAO.QueryDepartment_AllNode(true); lookUpReqDep.ItemIndex = 0; gridControlUserList.DataSource = BSCommon.getUserInfoList("", "", ""); //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].FieldName = dtblTmp.Columns["AutoId"].ToString(); //dgvUserList.Columns[1].FieldName = dtblTmp.Columns["LoginID"].ToString(); //dgvUserList.Columns[2].FieldName = dtblTmp.Columns["EmpName"].ToString(); //dgvUserList.Columns[3].FieldName = dtblTmp.Columns["DepartmentName"].ToString(); //dgvUserList.Columns[4].FieldName = dtblTmp.Columns["RoleName"].ToString(); //dgvUserList.Columns[5].FieldName = dtblTmp.Columns["RoleNo"].ToString(); //dgvUserList.Columns[0].Caption = "员工编号"; //dgvUserList.Columns[1].Caption = "用户编号"; //dgvUserList.Columns[2].Caption = "用户姓名"; //dgvUserList.Columns[3].Caption = "部门"; //dgvUserList.Columns[4].Caption = "角色"; //dgvUserList.Columns[5].Caption = "角色编号"; //dgvUserList.Columns[0].Visible = false; //dgvUserList.Columns[5].Visible = false; //角色combo cboRoleName.Properties.DataSource = BSCommon.getRoleList(); //cboRoleName.Properties.DisplayMember = "RoleName"; //cboRoleName.Properties.ValueMember = "RoleNo"; } catch (Exception ex) { //ExceptionHandler.HandleException(this.Text + "--窗体加载事件错误。", ex); ExceptionHandler.HandleException(this.Text + "--" + f.tsmiCtjzsjcw.Text, ex); } }
private void tsbQuery_Click(object sender, EventArgs e) { string[,] strsQueryTmp = new string[3, 2]; DataTable[] dt = new DataTable[strsQueryTmp.GetLongLength(0)]; strsQueryTmp[0, 0] = "部门编号"; strsQueryTmp[1, 0] = "部门名称"; strsQueryTmp[2, 0] = "上级部门编号"; strsQueryTmp[0, 1] = "txt"; strsQueryTmp[1, 1] = "cbo"; strsQueryTmp[2, 1] = "txt"; dt[1] = BSCommon.getDepartmentList();//下标代表代号 FrmQueryCondition f = new FrmQueryCondition(strsQueryTmp, dt); f.ShowDialog(); string strFilter; strFilter = "DepartmentNo like '*" + strsQueryTmp[0, 1] + "*' " + "and DepartmentNo like '*" + strsQueryTmp[1, 1] + "*' " + "and ParentDepartmentNo like '*" + strsQueryTmp[2, 1] + "*'"; this.bS_DepartmentBindingSource.Filter = strFilter; }
/// <summary> /// 筛选绑定数据源中的数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tsbQuery_Click(object sender, EventArgs e) { string[,] strsQueryTmp = new string[3, 2]; DataTable[] dt = new DataTable[strsQueryTmp.GetLongLength(0)]; strsQueryTmp[0, 0] = "用户ID"; strsQueryTmp[1, 0] = "用户姓名"; strsQueryTmp[2, 0] = "部门名称"; strsQueryTmp[0, 1] = "txt"; strsQueryTmp[1, 1] = "txt"; strsQueryTmp[2, 1] = "cbo"; dt[2] = BSCommon.getDepartmentList(); FrmQueryCondition f = new FrmQueryCondition(strsQueryTmp, dt); f.ShowDialog(); string strFilter; strFilter = "LoginId like '*" + strsQueryTmp[0, 1] + "*' " + "and EmpName like '*" + strsQueryTmp[1, 1] + "*' " + "and departmentNo like '*" + strsQueryTmp[2, 1] + "*'"; this.bS_UserInfoBindingSource.Filter = strFilter; }
//----------------------- /// <summary> /// 设置窗口(DockContent)语种(子方法) /// </summary> /// <param name="DockContentFormN"></param> /// <param name="ctlTmp"></param> public static void SetFormControlsLanuages(DockContent DockContentFormN, Control ctlTmp) { DataTable dt = new DataTable(); dt = BSCommon.GetFormLanuageData(DockContentFormN.Name); foreach (Control n in ctlTmp.Controls) { if (n.Text != null && n.Text != string.Empty && n.Text != '0'.ToString() && n.Name != string.Empty) { var TextValue = BSCommon.LocationControlsText(dt, n.Name, "Text"); if (TextValue.ToList().Count > 0) { n.Text = TextValue.ToList().First().Field <string>("LanguageText"); } //3.1 } if (n is DataGridView) { DataGridView dg = (DataGridView)n; foreach (object ch in dg.Columns) { { if (ch.GetType().Name == "DataGridViewTextBoxColumn") { var TextValue = BSCommon.LocationControlsText(dt, ((DataGridViewTextBoxColumn)ch).Name, "HeaderText"); if (TextValue.ToList().Count > 0) { ((DataGridViewTextBoxColumn)ch).HeaderText = TextValue.ToList().First().Field <string>("LanguageText"); } //3.1.1 } if (ch.GetType().Name == "DataGridViewComboBoxColumn") { var TextValue = BSCommon.LocationControlsText(dt, ((DataGridViewComboBoxColumn)ch).Name, "HeaderText"); if (TextValue.ToList().Count > 0) { ((DataGridViewComboBoxColumn)ch).HeaderText = TextValue.ToList().First().Field <string>("LanguageText"); } //3.1.2 } } } } if (n is ToolStrip) { ToolStrip tsTmp = (ToolStrip)n; for (int i = 0; i < tsTmp.Items.Count; i++) { if (tsTmp.Items[i].GetType().Name == "ToolStripButton")//判断是否为ToolStripButton { if (tsTmp.Items[i].Text != string.Empty) { var TextValue = BSCommon.LocationControlsText(dt, tsTmp.Items[i].Name, "Text"); if (TextValue.ToList().Count > 0) { tsTmp.Items[i].Text = TextValue.ToList().First().Field <string>("LanguageText"); } TextValue = BSCommon.LocationControlsText(dt, tsTmp.Items[i].Name, "ToolTipText"); if (TextValue.ToList().Count > 0) { tsTmp.Items[i].ToolTipText = TextValue.ToList().First().Field <string>("LanguageText"); } //3.3 //BSCommon.TraverseControlTextAdd(DockContentFormN.Name, tsTmp.Items[i].GetType().Name, tsTmp.Items[i].Name, tsTmp.Items[i].Text, "Text"); //BSCommon.TraverseControlTextAdd(DockContentFormN.Name, tsTmp.Items[i].GetType().Name, tsTmp.Items[i].Name, tsTmp.Items[i].ToolTipText, "ToolTipText"); } } } } #region ########GridControl if (n is GridControl) { GridControl gc = (GridControl)n; foreach (object gv in gc.Views) { DevExpress.XtraGrid.Views.Grid.GridView gvo = (DevExpress.XtraGrid.Views.Grid.GridView)gv; foreach (object column in gvo.Columns) { var TextValue = BSCommon.LocationControlsText(dt, ((DevExpress.XtraGrid.Columns.GridColumn)column).Name, "Caption"); DevExpress.XtraGrid.Columns.GridColumn column_o = (DevExpress.XtraGrid.Columns.GridColumn)column; MessageHandler.ShowMessageBox(column_o.GetTextCaption()); ((DevExpress.XtraGrid.Columns.GridColumn)column).Caption = TextValue.ToList().First().Field <string>("LanguageText"); } } } #endregion #########GridControl if (n.Controls.Count > 0) { SetFormControlsLanuages(DockContentFormN, n); } } }
/// <summary> /// 设置窗口语种DockContent(主方法) /// </summary> public static void SetFormLanguages(DockContent DockContentFormN) { DataTable dt = new DataTable(); dt = BSCommon.GetFormLanuageData(DockContentFormN.Name); var TextValue = BSCommon.LocationControlsText(dt, DockContentFormN.Name, "TabText"); if (TextValue.ToList().Count > 0) { DockContentFormN.TabText = TextValue.ToList().First().Field <string>("LanguageText"); } foreach (Control ctl in DockContentFormN.Controls)//遍历所有“DockContent”窗口控件 { if (ctl.Text != null && ctl.Text != string.Empty && ctl.Text != '0'.ToString() && ctl.Name != string.Empty) { TextValue = BSCommon.LocationControlsText(dt, ctl.Name, "Text"); if (TextValue.ToList().Count > 0) { ctl.Text = TextValue.ToList().First().Field <string>("LanguageText"); } //1.2 //BSCommon.TraverseControlTextAdd(DockContentFormN.Name, ctl.GetType().Name, ctl.Name, ctl.Text, "Text"); } if (ctl is DataGridView) { DataGridView dg = (DataGridView)ctl; foreach (object ch in dg.Columns) { { if (ch.GetType().Name == "DataGridViewTextBoxColumn") { TextValue = BSCommon.LocationControlsText(dt, ((DataGridViewTextBoxColumn)ch).Name, "HeaderText"); if (TextValue.ToList().Count > 0) { ((DataGridViewTextBoxColumn)ch).HeaderText = TextValue.ToList().First().Field <string>("LanguageText"); } //3.1.1 } if (ch.GetType().Name == "DataGridViewComboBoxColumn") { TextValue = BSCommon.LocationControlsText(dt, ((DataGridViewComboBoxColumn)ch).Name, "HeaderText"); if (TextValue.ToList().Count > 0) { ((DataGridViewComboBoxColumn)ch).HeaderText = TextValue.ToList().First().Field <string>("LanguageText"); } //3.1.2 } } } } if (ctl is ToolStrip) { ToolStrip tsTmp = (ToolStrip)ctl; for (int i = 0; i < tsTmp.Items.Count; i++) { if (tsTmp.Items[i].GetType().Name == "ToolStripButton")//判断是否为ToolStripButton { if (tsTmp.Items[i].Text != string.Empty) { TextValue = BSCommon.LocationControlsText(dt, tsTmp.Items[i].Name, "Text"); if (TextValue.ToList().Count > 0) { tsTmp.Items[i].Text = TextValue.ToList().First().Field <string>("LanguageText"); } TextValue = BSCommon.LocationControlsText(dt, tsTmp.Items[i].Name, "ToolTipText"); if (TextValue.ToList().Count > 0) { tsTmp.Items[i].ToolTipText = TextValue.ToList().First().Field <string>("LanguageText"); } //1.3 //BSCommon.TraverseControlTextAdd(DockContentFormN.Name, tsTmp.Items[i].GetType().Name, tsTmp.Items[i].Name, tsTmp.Items[i].Text, "Text"); //BSCommon.TraverseControlTextAdd(DockContentFormN.Name, tsTmp.Items[i].GetType().Name, tsTmp.Items[i].Name, tsTmp.Items[i].ToolTipText, "ToolTipText"); } } } } //gridView if (ctl is GridControl) { MessageHandler.ShowMessageBox("dfdf"); /* * DataGridView dg = (DataGridView)ctl; * foreach (object ch in dg.Columns) * { * { * if (ch.GetType().Name == "DataGridViewTextBoxColumn") * { * TextValue = BSCommon.LocationControlsText(dt, ((DataGridViewTextBoxColumn)ch).Name, "HeaderText"); * if (TextValue.ToList().Count > 0) * { * ((DataGridViewTextBoxColumn)ch).HeaderText = TextValue.ToList().First().Field<string>("LanguageText"); * } * } * if (ch.GetType().Name == "DataGridViewComboBoxColumn") * { * TextValue = BSCommon.LocationControlsText(dt, ((DataGridViewComboBoxColumn)ch).Name, "HeaderText"); * if (TextValue.ToList().Count > 0) * { * ((DataGridViewComboBoxColumn)ch).HeaderText = TextValue.ToList().First().Field<string>("LanguageText"); * } * } * } * } */ } //gridview if (ctl.Controls.Count > 0) { SetFormControlsLanuages(DockContentFormN, ctl); } DockContentFormN.Show(); } }
private void btnStretch_Click(object sender, EventArgs e) { dtblTmp = BSCommon.getUserInfoList(txtLoginID.Text, txtUserName.Text, cboDepartmentName.Text.Trim()); dgvUserList.DataSource = dtblTmp; }