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