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