public List <RoleMenuAuthoritiesVM> GetRoleMenuAuthorities(RoleMenuAuthoritiesVM vm) { StringBuilder sb = new StringBuilder(); try { StringBuilder sql = new StringBuilder(@" select rma.ID,m.TabHeaderText MenuName,r.Name RoleName ,a.Name AuthorityName from [dbo].[RoleMenuAuthorities] rma join [dbo].[Menus] m on rma.[MenuID]=m.ID join [dbo].[Roles] r on rma.RoleID=r.ID join [dbo].[Authorities] a on a.ID=rma.AuthorityID "); List <SqlParameter> paramList = new List <SqlParameter>(); StringBuilder where = new StringBuilder(" where 1=1 and m.[Status]=1 "); if (!string.IsNullOrEmpty(vm.MenuName)) { where.Append(" and m.TabHeaderText like @MenuName"); SqlParameter paramMenuName = new SqlParameter("@MenuName", string.Format("%{0}%", vm.MenuName)); paramList.Add(paramMenuName); } if (!string.IsNullOrEmpty(vm.RoleName)) { where.Append(" and r.Name like @RoleName"); SqlParameter paramRoleName = new SqlParameter("@RoleName", string.Format("%{0}%", vm.RoleName)); paramList.Add(paramRoleName); } sql.Append(where); return(DataTableToList.DataSetToList <RoleMenuAuthoritiesVM>(SqlHelper.ExecuteDataset(SqlHelper.GetConnSting(), CommandType.Text, sql.ToString(), paramList.ToArray()))); } catch (Exception ex) { return(null); } }
public int DeleteRoleMenuAuthority(RoleMenuAuthoritiesVM vm) { StringBuilder sb = new StringBuilder(); try { SqlParameter paramID = new SqlParameter("@ID", vm.ID); string sql = @"DELETE FROM [dbo].[RoleMenuAuthorities] WHERE ID=@ID "; return(SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sql, new SqlParameter[] { paramID })); } catch (Exception ex) { return(0); } }
private void ribeDeleteRoleMenuAuthority_Click(object sender, EventArgs e) { RoleMenuAuthoritiesVM vm = this.gvRoleMenuAuthority.GetRow(this.gvRoleMenuAuthority.FocusedRowHandle) as RoleMenuAuthoritiesVM;//获取选中行的实体 var resDeleteUserRoles = _bll.DeleteRoleMenuAuthority(vm); if (resDeleteUserRoles > 0) { XtraMessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK); RequestRoleMenuAuthoritiesData(); } else { XtraMessageBox.Show("删除失败!", "提示", MessageBoxButtons.OK); } }
public int AddRoleMenuAuthorities(RoleMenuAuthoritiesVM vm) { StringBuilder sb = new StringBuilder(); try { string sql = @" INSERT INTO [dbo].[RoleMenuAuthorities] ([AuthorityID] ,[RoleID] ,[MenuID]) VALUES (@AuthorityID,@RoleID,@MenuID ); "; SqlParameter paramAuthorityID = new SqlParameter("@AuthorityID", vm.AuthorityID); SqlParameter paramRoleID = new SqlParameter("@RoleID", vm.RoleID); SqlParameter paramMenuID = new SqlParameter("@MenuID", vm.MenuID); return(SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sql, new SqlParameter[] { paramAuthorityID, paramRoleID, paramMenuID })); } catch (Exception ex) { return(0); } }
private void btnSave_Click(object sender, EventArgs e) { if (this.lueAddRole.EditValue == null) { XtraMessageBox.Show("role is empty!!", "提示", MessageBoxButtons.OK); return; } if (this.tllueAddMenu.EditValue == null) { XtraMessageBox.Show("menu is empty!", "提示", MessageBoxButtons.OK); return; } if (this.lueAuthority.EditValue == null) { XtraMessageBox.Show("Authority is empty!", "提示", MessageBoxButtons.OK); return; } RoleMenuAuthoritiesVM vm = new RoleMenuAuthoritiesVM() { RoleID = (this.lueAddRole.EditValue as RolesVM).ID, MenuID = (this.tllueAddMenu.EditValue as RoleMenusVM).MenuID, AuthorityID = (this.lueAuthority.EditValue as AuthoritiesVM).ID }; var res = _bll.AddRoleMenuAuthorities(vm); if (res > 0) { XtraMessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK); RequestRoleMenuAuthoritiesData(); } else { XtraMessageBox.Show("保存失败!", "提示", MessageBoxButtons.OK); } }
public int AddRoleMenuAuthorities(RoleMenuAuthoritiesVM vm) { return(_dal.AddRoleMenuAuthorities(vm)); }
public int DeleteRoleMenuAuthority(RoleMenuAuthoritiesVM vm) { return(_dal.DeleteRoleMenuAuthority(vm)); }
public List <RoleMenuAuthoritiesVM> GetRoleMenuAuthorities(RoleMenuAuthoritiesVM vm) { return(_dal.GetRoleMenuAuthorities(vm)); }