using IWareDataAccess.EF;
|
using IWareDataAccess.Entity.Sys;
|
using IWareDataAccess.Helper;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace IWareDataAccess.Sys.ROLE_VS_PERMISSION
|
{
|
public static class Role_Vs_PermissionSqlFunc
|
{
|
/// <summary>
|
/// 搜索视图
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <returns></returns>
|
public static List<View_ROLE_VS_PERMISSION> SearchView(PermissionVsRoleWebEntity webEntity,out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<View_ROLE_VS_PERMISSION>();
|
|
//便利所有属性
|
Type type = webEntity.GetType();
|
foreach (var i in type.GetProperties())
|
{
|
object v = Helper.Helper.GetFieldValueByName(webEntity, i.Name);
|
if (i.PropertyType == typeof(String))
|
{
|
string value;
|
if (v != null)
|
{
|
value = v.ToString();
|
f = f.And(x => Helper.Helper.GetFieldValueByName(x, i.Name) != null ? Helper.Helper.GetFieldValueByName(x, i.Name).ToString().Contains(value) : false);
|
}
|
}
|
else
|
{
|
if (v != null)
|
{
|
f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
|
}
|
}
|
}
|
|
List<View_ROLE_VS_PERMISSION> list = edm.View_ROLE_VS_PERMISSION.Where(f.Compile()).ToList();
|
|
return list;
|
}
|
}
|
|
/// <summary>
|
/// 搜索视图
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <returns></returns>
|
public static int SearchViewNum(PermissionVsRoleWebEntity webEntity)
|
{
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<View_ROLE_VS_PERMISSION>();
|
|
//便利所有属性
|
Type type = webEntity.GetType();
|
foreach (var i in type.GetProperties())
|
{
|
object v = Helper.Helper.GetFieldValueByName(webEntity, i.Name);
|
if (i.PropertyType == typeof(String))
|
{
|
string value;
|
if (v != null)
|
{
|
value = v.ToString();
|
f = f.And(x => Helper.Helper.GetFieldValueByName(x, i.Name) != null ? Helper.Helper.GetFieldValueByName(x, i.Name).ToString().Contains(value) : false);
|
}
|
}
|
else
|
{
|
if (v != null)
|
{
|
f = f.And(x => Object.Equals(Helper.Helper.GetFieldValueByName(x, i.Name), v));
|
}
|
}
|
}
|
|
int num = edm.View_ROLE_VS_PERMISSION.Where(f.Compile()).Count();
|
|
return num;
|
}
|
}
|
|
/// <summary>
|
/// 添加权限
|
/// </summary>
|
/// <param name="role"></param>
|
/// <returns></returns>
|
public static bool AddOrUpdate(PermissionVsRoleWebEntity webRoleVsPermission,out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
RoleWebEntity searchEntity = new RoleWebEntity();
|
//查询是否存在此角色
|
SYS_ROLE role = edm.SYS_ROLE.FirstOrDefault(x => x.ROLENAME == webRoleVsPermission.roleName);
|
if (role == null)
|
{
|
//无此角色
|
msg = "无此角色";
|
return false;
|
}
|
int type = 1;
|
if (webRoleVsPermission.permissionNameList != null && webRoleVsPermission.permissionNameList.Count > 0)
|
{
|
int id = webRoleVsPermission.permissionNameList[0];
|
type=(int)edm.SYS_PERMISSION.FirstOrDefault(x=>x.ID==id).TYPE;
|
}
|
else
|
{
|
msg = "获取该角色的权限失败！";
|
return false;
|
}
|
if (DeleteAll(webRoleVsPermission.roleName, type, out msg))
|
{
|
foreach (var i in webRoleVsPermission.permissionNameList)
|
{
|
//如果输入权限包含遍历的权限，添加
|
|
SYS_ROLE_VS_PERMISSION rvp = new SYS_ROLE_VS_PERMISSION();
|
rvp.PERMISSIONID = i;
|
rvp.ROLEID = role.ID;
|
edm.SYS_ROLE_VS_PERMISSION.AddOrUpdateExtension(rvp);
|
|
}
|
|
}
|
else
|
{
|
msg = "保存失败！";
|
return false;
|
}
|
|
if (edm.SaveChanges() > 0)
|
{
|
return true;
|
}
|
else
|
{
|
msg = "修改失败";
|
return false;
|
}
|
}
|
}
|
|
/// <summary>
|
/// 初始化角色权限
|
/// </summary>
|
/// <param name="roleName"></param>
|
/// <returns></returns>
|
public static bool DeleteAll(string roleName,int type,out string msg)
|
{
|
try
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
List<SYS_ROLE_VS_PERMISSION> rvplst = new List<SYS_ROLE_VS_PERMISSION>();
|
var list = edm.SYS_ROLE_VS_PERMISSION.Where(x => x.SYS_ROLE.ROLENAME == roleName);
|
var plst = edm.SYS_PERMISSION.Where(x => x.TYPE == type).ToList();
|
plst.ForEach(x =>
|
{
|
var rvp = list.FirstOrDefault(y => y.PERMISSIONID == x.ID);
|
if (rvp != null)
|
{
|
rvplst.Add(rvp);
|
}
|
});
|
edm.SYS_ROLE_VS_PERMISSION.RemoveRange(rvplst);
|
edm.SaveChanges();
|
return true;
|
|
}
|
}
|
catch (Exception ex)
|
{
|
msg = "保存失败";
|
return false;
|
}
|
}
|
}
|
}
|
