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