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();//初始化控件按钮状态
}
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;
}
