public Task <int> DeleteSystemPermissionsByPrivilegeAccessAndValue(EnumPrivilegeAccess privilegeAccess, Guid?privilegeAccessValue = null)
{
StringBuilder sql =
new StringBuilder(
"DELETE FROM System_Permission WHERE PrivilegeAccess=@privilegeAccess");
if (privilegeAccessValue != null)
{
sql.Append(" AND PrivilegeAccessValue=@privilegeAccessValue");
}
return(SqlMapperUtil.InsertUpdateOrDeleteSql <SystemPermission>(sql.ToString(), new { privilegeAccess, privilegeAccessValue }));
}
/// <summary>
/// 获取菜单、功能项等被使用的权限信息
/// </summary>
/// <param name="privilegeAccess">类型:菜单、功能项</param>
/// <param name="privilegeAccessValue">对应值</param>
/// <returns></returns>
public async Task <IEnumerable <SystemPermission> > GetSystemPermissionsByPrivilegeAccessAndValue(
EnumPrivilegeAccess privilegeAccess,
Guid?privilegeAccessValue = null)
{
return((await _permissionRepository.GetSystemPermissionsByPrivilegeAccessAndValue(privilegeAccess, privilegeAccessValue)).ToList());
}
/// <summary>
/// 获取菜单、功能项等被使用的权限信息
/// </summary>
/// <param name="privilegeAccess">类型:菜单、功能项</param>
/// <param name="privilegeAccessValue">对应值</param>
/// <returns></returns>
public Task <IEnumerable <SystemPermission> > GetSystemPermissionsByPrivilegeAccessAndValue(EnumPrivilegeAccess privilegeAccess,
Guid?privilegeAccessValue = null)
{
StringBuilder sql =
new StringBuilder(
String.Format(
"SELECT * FROM System_Permission WHERE PrivilegeAccess=@privilegeAccess"));
if (privilegeAccessValue != null)
{
sql.Append(" AND PrivilegeAccessValue=@privilegeAccessValue");
}
return(SqlMapperUtil.SqlWithParams <SystemPermission>(sql.ToString(),
new { privilegeAccess, privilegeAccessValue }));
}
public async Task <int> DeleteSystemPermissionsByPrivilegeAccessAndValue(EnumPrivilegeAccess privilegeAccess, Guid?privilegeAccessValue = null)
{
return(await _permissionRepository.DeleteSystemPermissionsByPrivilegeAccessAndValue(privilegeAccess, privilegeAccessValue));
}
