using IWareDataAccess.EF;
|
using IWareDataAccess.Entity.Base;
|
using IWareDataAccess.Entity.Summary;
|
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.PERMISSION
|
{
|
public static class PermissionSqlFunc
|
{
|
/// <summary>
|
/// 搜索全部（视图）
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
public static List<View_SYS_PERMISSION> SearchView(PermissionWebEntity webEntity, out string msg)
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<View_SYS_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_SYS_PERMISSION> list = edm.View_SYS_PERMISSION.Where(f.Compile()).ToList();
|
|
return list;
|
}
|
}
|
|
/// <summary>
|
/// 搜索全部（视图）
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
public static int SearchViewNum(PermissionWebEntity webEntity)
|
{
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<View_SYS_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_SYS_PERMISSION.Where(f.Compile()).Count();
|
|
return num;
|
}
|
}
|
|
/// <summary>
|
/// 搜索全部（表）
|
/// </summary>
|
/// <param name="keyValue"></param>
|
/// <param name="page"></param>
|
/// <returns></returns>
|
public static List<SYS_PERMISSION> Search(PermissionWebEntity webEntity)
|
{
|
using (Model edm = new Model())
|
{
|
var f = PredicateBuilder.True<SYS_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<SYS_PERMISSION> list = edm.SYS_PERMISSION.Where(f.Compile()).ToList();
|
|
return list;
|
}
|
}
|
|
public static List<UserRolePermissionViewEntity> urpvlst;
|
/// <summary>
|
/// 获取指定角色的菜单
|
/// </summary>
|
/// <param name="model"></param>
|
/// <param name="msg"></param>
|
/// <returns></returns>
|
public static List<UserRolePermissionViewEntity> GetUserRoleAllPermission(string roleName, int type,out string msg)
|
{
|
try
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
urpvlst = new List<UserRolePermissionViewEntity>();
|
var rvplst = edm.SYS_ROLE_VS_PERMISSION.Where(x => x.SYS_ROLE.ROLENAME == roleName).ToList();
|
|
var prolst = edm.SYS_PERMISSION.Where(x => x.ENABLE == 1&&x.TYPE==type).ToList();
|
|
if (prolst != null && prolst.Count > 0)
|
{
|
foreach (var item in prolst.FindAll(c => c.FATHERPERMISSIONID == 0))
|
{
|
UserRolePermissionViewEntity ure = new UserRolePermissionViewEntity();
|
ure.menu_Id = item.ID;
|
ure.menuName = item.PERMISSION;
|
ure.state = "open";
|
ure.parentId = (int)item.FATHERPERMISSIONID;
|
urpvlst.Add(ure);
|
|
FillMenu(ure, prolst, rvplst);
|
}
|
}
|
else
|
{
|
msg = "查询异常";
|
return new List<UserRolePermissionViewEntity>();
|
}
|
return urpvlst;
|
}
|
}
|
catch (Exception ex)
|
{
|
msg = "查询异常";
|
return new List<UserRolePermissionViewEntity>();
|
}
|
|
}
|
private static void FillMenu(UserRolePermissionViewEntity node, List<SYS_PERMISSION> list, List<SYS_ROLE_VS_PERMISSION> rplst)
|
{
|
foreach (var i in list.FindAll(i => i.FATHERPERMISSIONID == node.menu_Id))
|
{
|
UserRolePermissionViewEntity ure = new UserRolePermissionViewEntity();
|
ure.menu_Id = i.ID;
|
ure.menuName = i.PERMISSION;
|
ure.state = "open";
|
ure.parentId = (int)i.FATHERPERMISSIONID;
|
int vl = 0;
|
if (rplst != null && rplst.Count > 0)
|
{
|
var rp = rplst.FirstOrDefault(x => x.PERMISSIONID == i.ID);
|
if (rp != null)
|
{
|
vl = 1;
|
}
|
else
|
{
|
vl = 0;
|
}
|
}
|
else
|
{
|
vl = 0;
|
}
|
|
if (i.ISBUTTON == 1)
|
{
|
|
node.hasChild = "false";
|
if (node.auth == null)
|
{
|
node.auth = new List<AuthEntity>();
|
}
|
node.auth.Add(new AuthEntity()
|
{
|
menu_Id=i.ID,
|
label = i.PERMISSION,
|
nodeName = i.BUTTONNAME,
|
value = vl
|
});
|
}
|
else
|
{
|
var pd = list.FirstOrDefault(x => x.FATHERPERMISSIONID == i.ID);
|
if (pd == null)
|
{
|
node.hasChild = "false";
|
if (node.auth == null)
|
{
|
node.auth = new List<AuthEntity>();
|
}
|
node.auth.Add(new AuthEntity()
|
{
|
menu_Id = i.ID,
|
label = i.PERMISSION,
|
nodeName = i.BUTTONNAME,
|
value = vl
|
});
|
}
|
else
|
{
|
if (node.children == null)
|
{
|
node.children = new List<UserRolePermissionViewEntity>();
|
}
|
node.children.Add(ure);
|
if (node.children != null && node.children.Count > 0)
|
{
|
node.hasChild = "true";
|
|
}
|
}
|
|
}
|
FillMenu(ure, list, rplst);
|
}
|
}
|
public static List<UserRoleMenuEntity> urmlst;
|
public static List<UserRoleMenuEntity> GetUserRolePermission(string roleName,int type, out string msg)
|
{
|
try
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
List<UserRolePermissionViewEntity> urplst = new List<UserRolePermissionViewEntity>();
|
urmlst = new List<UserRoleMenuEntity>();
|
var rvplst = edm.SYS_ROLE_VS_PERMISSION.Where(x => x.SYS_ROLE.ROLENAME==roleName).ToList();
|
|
var prolst = edm.SYS_PERMISSION.Where(x => x.ENABLE == 1&&x.TYPE==type).ToList();
|
|
if (prolst != null && prolst.Count > 0)
|
{
|
foreach (var item in prolst.FindAll(c => c.FATHERPERMISSIONID == 0))
|
{
|
var rp = rvplst.FirstOrDefault(x => x.PERMISSIONID == item.ID);
|
if (rp!=null)
|
{
|
UserRolePermissionViewEntity ure = new UserRolePermissionViewEntity();
|
ure.menu_Id = item.ID;
|
ure.parentId = (int)item.FATHERPERMISSIONID;
|
urplst.Add(ure);
|
UserRoleMenuEntity urm = new UserRoleMenuEntity();
|
var titlels=item.PERMISSION.Split('-');
|
urm.path = item.PATH;
|
if (!string.IsNullOrEmpty(item.PATH))
|
{
|
var pn = item.PATH.Split('/');
|
urm.name = pn[pn.Length - 1];
|
}
|
urm.meta = new Meta() { icon = item.ICON, title = titlels[titlels.Length - 1] };
|
urmlst.Add(urm);
|
FillRoleMenu(ure,urm,prolst, rvplst);
|
}
|
|
}
|
}
|
else
|
{
|
msg = "查询异常";
|
return new List<UserRoleMenuEntity>();
|
}
|
return urmlst;
|
}
|
}
|
catch (Exception ex)
|
{
|
msg = "查询异常";
|
return new List<UserRoleMenuEntity>();
|
}
|
}
|
private static void FillRoleMenu(UserRolePermissionViewEntity node,UserRoleMenuEntity urm, List<SYS_PERMISSION> list, List<SYS_ROLE_VS_PERMISSION> rplst)
|
{
|
foreach (var i in list.FindAll(i => i.FATHERPERMISSIONID == node.menu_Id))
|
{
|
int vl = 0;
|
if (rplst != null && rplst.Count > 0)
|
{
|
var rp = rplst.FirstOrDefault(x => x.PERMISSIONID == i.ID);
|
if (rp != null)
|
{
|
vl = 1;
|
}
|
else
|
{
|
vl = 0;
|
}
|
}
|
else
|
{
|
|
vl = 0;
|
}
|
if (vl==1)
|
{
|
UserRolePermissionViewEntity ure = new UserRolePermissionViewEntity();
|
ure.menu_Id = i.ID;
|
ure.parentId = (int)i.FATHERPERMISSIONID;
|
|
UserRoleMenuEntity ur = new UserRoleMenuEntity();
|
var titlels = i.PERMISSION.Split('-');
|
ur.path = i.PATH;
|
if (!string.IsNullOrEmpty(i.PATH) &&i.PATH.Contains('/'))
|
{
|
var pn = i.PATH.Split('/');
|
ur.name = pn[pn.Length - 1];
|
}
|
else
|
{
|
ur.name = "";
|
}
|
ur.meta = new Meta() { icon =i.ICON, title = titlels[titlels.Length-1] };
|
|
if (i.ISBUTTON != 1)
|
{
|
if (node.children == null)
|
{
|
node.children = new List<UserRolePermissionViewEntity>();
|
}
|
node.children.Add(ure);
|
if (urm.children == null)
|
{
|
urm.children = new List<UserRoleMenuEntity>();
|
}
|
urm.children.Add(ur);
|
|
}
|
else //添加按钮级别的子功能
|
{
|
|
}
|
FillRoleMenu(ure, ur, list, rplst);
|
}
|
|
}
|
}
|
|
public static List<PdaPermissionEntity> GetPdaUserRolePermission(string roleName, out string msg)
|
{
|
try
|
{
|
msg = "";
|
using (Model edm = new Model())
|
{
|
List<PdaPermissionEntity> meanlst = new List<PdaPermissionEntity>();
|
var pdalst = edm.SYS_PERMISSION.Where(x => x.TYPE == 2&&x.PERMISSIONLEVEL==2).ToList();
|
var rolevplst = edm.View_ROLE_VS_PERMISSION.Where(x => x.roleName == roleName);
|
if (pdalst!=null)
|
{
|
pdalst.ForEach(x =>
|
{
|
var ishave = rolevplst.FirstOrDefault(y => y.permission == x.PERMISSION);
|
if (ishave!=null)
|
{
|
meanlst.Add(new PdaPermissionEntity() { title = x.PERMISSION, name = x.DEC,color=x.BUTTONNAME });
|
}
|
});
|
}
|
return meanlst;
|
}
|
}
|
catch (Exception ex)
|
{
|
msg = "查询异常";
|
return new List<PdaPermissionEntity>();
|
}
|
}
|
}
|
}
|
