/// <summary> /// 根据用户ID查数据 /// </summary> private void btnUpdateUser() { if (Common.UserID > 0 || Common.RoleID > 0) { Expression <Func <PermissionsInfo, bool> > funPermissionsInfo = n => n.Permissions_UserId == Common.UserID || n.Permissions_Role_Id == Common.RoleID; var permissionsInfo = PermissionsInfoDAL.Query(funPermissionsInfo);//根据用户ID查出菜单ID if (permissionsInfo == null) { return; //没有数据跳出方法 } foreach (var m in permissionsInfo) { if (m.Permissions_Menu_ID.Value > 0) { UpdateSelectRole(m.Permissions_Menu_ID.Value); } } } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tsbtnDel_delete() { try { int j = 0; string Log_Content = ""; if (lvwUserList.SelectedRows.Count > 0)//选中删除 { if (MessageBox.Show("确定要删除吗?", "系统提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { //选中数量 int count = lvwUserList.SelectedRows.Count; //string id = ""; //遍历 for (int i = 0; i < count; i++) { Expression <Func <View_UserInfo_D_R_d, bool> > funviewuserinfo = n => n.Role_Name == lvwUserList.SelectedRows[i].Cells["Role_Name"].Value.ToString(); if (UserInfoDAL.Query(funviewuserinfo).Count() > 0) { MessageBox.Show("删除的用户角色中有角色正在使用,不能删除!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } Expression <Func <RoleInfo, bool> > funuserinfo = n => n.Role_Id.ToString() == lvwUserList.SelectedRows[i].Cells["Role_Id"].Value.ToString(); if (!RoleInfoDAL.DeleteToMany(funuserinfo)) { j++; } else { Log_Content += lvwUserList.SelectedRows[i].Cells["Role_Id"].Value.ToString() + " "; } if (lvwUserList.SelectedRows[i].Cells["Role_Id"].Value != null) { //删除角色的所有权限 Expression <Func <PermissionsInfo, bool> > funmenuinfo = n => n.Permissions_Role_Id == Common.GetInt(lvwUserList.SelectedRows[i].Cells["Role_Id"].Value.ToString()); if (!PermissionsInfoDAL.DeleteToMany(funmenuinfo))//用户权限菜单是否删除失败 { j++; } } } if (j == 0) { MessageBox.Show("成功删除", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("删除失败", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } Common.WriteLogData("删除", "删除角色" + Log_Content, Common.NAME);//操作日志 } } else//没有选中 { MessageBox.Show("请选择要删除的行!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { Common.WriteTextLog("角色管理 tsbtnDel_delete()" + ex.Message.ToString()); } finally { page = new PageControl(); page.PageMaxCount = tscbxPageSize2.SelectedItem.ToString(); LoadData(); } }
private void btnUpdate_Click() { try { arraylist.Clear();//清空动态数组内的成员 add(); int j = 0; bool Menu_Enabled = true; bool Menu_Visible = true; if (!chb_Menu_Visible.Checked) { Menu_Visible = false; } if (!chb_Menu_Enabled.Checked) { Menu_Enabled = false; } if (YesNoBoolRoleUser) { //删除用户的所有权限 if (Common.UserID <= 0) { return; } Expression <Func <PermissionsInfo, bool> > funmenuinfo = n => n.Permissions_UserId == Common.UserID; if (!PermissionsInfoDAL.DeleteToMany(funmenuinfo))//用户权限菜单是否删除失败 { j++; } for (int i = 0; i < arraylist.Count; i++) { var permissionsInfo = new PermissionsInfo { Permissions_Menu_ID = Common.GetInt(arraylist[i].ToString()), Permissions_Dictionary_ID = DictionaryDAL.GetDictionaryID("启动"), Permissions_Visible = Menu_Visible, Permissions_Enabled = Menu_Enabled, Permissions_UserId = Common.UserID }; if (!PermissionsInfoDAL.InsertOneQCRecord(permissionsInfo))//是否添加失败 { j++; } } } else { //删除用户的所有权限 Expression <Func <PermissionsInfo, bool> > funmenuinfo = n => n.Permissions_Role_Id == Common.RoleID; if (!PermissionsInfoDAL.DeleteToMany(funmenuinfo))//用户权限菜单是否删除失败 { j++; } for (int i = 0; i < arraylist.Count; i++) { var permissionsInfo = new PermissionsInfo { Permissions_Menu_ID = Common.GetInt(arraylist[i].ToString()), Permissions_Dictionary_ID = DictionaryDAL.GetDictionaryID("启动"), Permissions_Visible = Menu_Visible, Permissions_Enabled = Menu_Enabled, Permissions_Role_Id = Common.RoleID }; if (!PermissionsInfoDAL.InsertOneQCRecord(permissionsInfo))//是否添加失败 { j++; } } } if (j == 0) { MessageBox.Show("添加成功", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("添加失败", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("添加成功", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Information); Common.WriteTextLog("UserRoleADD.btnUpdate_Click()" + ex.Message.ToString()); } finally { this.Close(); } //try //{ // arraylist.Clear();//清空动态数组内的成员 // add(); // Common.arraylist = arraylist; //} //catch (Exception ex) //{ // Common.WriteTextLog("UserRoleADD.btnUpdate_Click()" + ex.Message.ToString()); //} //finally //{ // this.Close(); //} }
private void btnUpdate_Click() { try { arraylist.Clear();//清空动态数组内的成员 add(); int j = 0; bool Menu_Enabled = true; bool Menu_Visible = true; if (!chb_Menu_Visible.Checked) { Menu_Visible = false; } if (!chb_Menu_Enabled.Checked) { Menu_Enabled = false; } if (CommonalityEntity.YesNoBoolRoleUser) { //删除用户权限,只能删除我拥有的,已经配置的权限 if (CommonalityEntity.UserID <= 0) { return; } DataTable dt = LinQBaseDao.Query("select Permissions_ID from View_MenuInfo_P where Menu_Type=1 and Permissions_UserId=" + CommonalityEntity.UserID + "").Tables[0]; string pids = ""; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { pids += dt.Rows[i][0].ToString() + ","; } LinQBaseDao.Query("delete PermissionsInfo where Permissions_ID in (" + pids.TrimEnd(',') + ")"); } for (int i = 0; i < arraylist.Count; i++) { var permissionsInfo = new PermissionsInfo { Permissions_Menu_ID = CommonalityEntity.GetInt(arraylist[i].ToString()), Permissions_Visible = Menu_Visible, Permissions_Enabled = Menu_Enabled, Permissions_Type = 1,//1为winfrom程序菜单 Permissions_UserId = CommonalityEntity.UserID }; if (!PermissionsInfoDAL.InsertOneQCRecord(permissionsInfo))//是否添加失败 { j++; } } } else { //删除用户的所有权限 Expression <Func <PermissionsInfo, bool> > funmenuinfo = n => n.Permissions_Role_Id == CommonalityEntity.RoleID; if (!PermissionsInfoDAL.DeleteToMany(funmenuinfo))//用户权限菜单是否删除失败 { j++; } for (int i = 0; i < arraylist.Count; i++) { var permissionsInfo = new PermissionsInfo { Permissions_Menu_ID = CommonalityEntity.GetInt(arraylist[i].ToString()), //Dictionary_State = DictionaryDAL.GetDictionaryID("启动"), Permissions_Visible = Menu_Visible, Permissions_Enabled = Menu_Enabled, Permissions_Type = 1, Permissions_Role_Id = CommonalityEntity.RoleID }; if (!PermissionsInfoDAL.InsertOneQCRecord(permissionsInfo))//是否添加失败 { j++; } } } if (j == 0) { MessageBox.Show("添加成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); CommonalityEntity.WriteLogData("新增", "新增角色编号为:" + CommonalityEntity.RoleID + "权限的信息", CommonalityEntity.USERNAME); } else { MessageBox.Show("添加失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch { MessageBox.Show("添加失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); CommonalityEntity.WriteTextLog("UserRoleADD.btnUpdate_Click()"); } finally { this.Close(); } try { arraylist.Clear();//清空动态数组内的成员 add(); CommonalityEntity.arraylist = arraylist; } catch { CommonalityEntity.WriteTextLog("UserRoleADD.btnUpdate_Click()"); } finally { this.Close(); } }