IotCloudPlatform/IoTIntegrationPlatform/IoTIntegrationPlatform.Services/AdminService.cs


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Diagnostics.Eventing.Reader;
using System.Linq;
using System.Reflection;
using System.Text;
using Mysqlx.Crud;
using SqlSugar;
using System.Threading.Tasks;
using IoTIntegrationPlatform.Interface;
using IoTIntegrationPlatform.Model.Model;
using IoTIntegrationPlatform.Model.common;
using IoTIntegrationPlatform.Common;

namespace IoTIntegrationPlatform.Services
{
    public class AdminService : IAdminService
    {
        private ISqlSugarClient db { get; }
        public AdminService(ISqlSugarClient _db)
        {
            db = _db;
        }

        #region 类句柄操作
        private IntPtr handle;
        private bool disposed = false;
        //关闭句柄
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Design", "CA1060:MovePInvokesToNativeMethodsClass"), System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Interoperability", "CA1401:PInvokesShouldNotBeVisible"), System.Runtime.InteropServices.DllImport("Kernel32")]
        public extern static Boolean CloseHandle(IntPtr handle);


        /// <summary>
        /// 释放对象资源
        /// </summary>
        public void Dispose()
        {
            Dispose(true);
            GC.SuppressFinalize(this);
        }

        /// <summary>
        /// 释放对象资源
        /// </summary>
        /// <param name="disposing"></param>
        protected virtual void Dispose(bool disposing)
        {
            if (!this.disposed)
            {
                if (handle != IntPtr.Zero)
                {
                    CloseHandle(handle);
                    handle = IntPtr.Zero;
                }
            }
            disposed = true;
        }
        ~AdminService()
        {
            Dispose(false);
        }

        #endregion

        #region 角色管理


        /// <summary>
        /// 获取角色信息
        /// </summary>
        /// <param name="email"></param>
        /// <param name="passWord"></param>
        /// <param name="mobile"></param>
        /// <returns></returns>
        public AdminRole GetRoleInfo(BaseParm parm)
        {
            AdminRole model = new AdminRole();
            try
            {
                model = db.Queryable<AdminRole>()
                    .Where(it => it.IsValid == true)
                    .WhereIF(!string.IsNullOrEmpty(parm.Name), it => it.RoleName.Equals(parm.Name))
                    .WhereIF(!string.IsNullOrEmpty(parm.Code), it => it.RoleCode == parm.Code)
                    .First();
            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return model;
        }

        /// <summary>
        /// 获取角色列表
        /// </summary>
        /// <param name="parm"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public List<AdminRole> GetRoleList(BaseParm parm, ref int page)
        {
            List<AdminRole> list = new List<AdminRole>();
            try
            {
                list = db.Queryable<AdminRole>()
                    .Where(it => it.IsValid == true)
                    .WhereIF(!string.IsNullOrEmpty(parm.Code), it => it.RoleCode.Equals(parm.Code))
                    .WhereIF(!string.IsNullOrEmpty(parm.Name), it => it.RoleName.Contains(parm.Name))
                    .ToPageList(parm.PageIndex, parm.PageSize, ref page);
            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return list;
        }

        /// <summary>
        /// 添加管理-角色
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool AddRole(AdminRole model)
        {
            bool result = false;
            try
            {
                model.CreateTime = DateTime.Now;
                model.UpdateTime = DateTime.Now;
                model.IsValid = true;

                int row = db.Insertable(model).ExecuteCommand();

                if (row > 0)
                {
                    result = true;
                }
            }
            catch (Exception ex)
            {
                Logging.Error(ex, "添加角色");
            }
            return result;
        }

        /// <summary>
        /// 编辑管理-角色
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateRole(AdminRole model)
        {

            bool result = false;
            try
            {
                var row = db.Updateable(model).IgnoreColumns(it => new { it.Id, it.CreateTime, it.IsValid })
                    .Where(it => it.Id == model.Id)
                    .ExecuteCommand();

                if (row > 0)
                {
                    result = true;
                }

            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return result;
        }

        /// <summary>
        /// 删除管理-角色
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public bool DeleteRole(BaseParm parm)
        {
            bool result = false;
            try
            {
                int row = db.Updateable<AdminRole>()
                    .SetColumns(it => new AdminRole { UpdateTime = DateTime.Now, IsValid = false })
                    .Where(it => it.Id == parm.Id)
                    .ExecuteCommand();

                if (row > 0)
                {
                    result = true;
                }

            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return result;

        }
        #endregion

        #region 菜单管理

        /// <summary>
        /// 获取菜单信息
        /// </summary>
        /// <param name="email"></param>
        /// <param name="passWord"></param>
        /// <param name="mobile"></param>
        /// <returns></returns>
        public AdminMenu GetMenuInfo(BaseParm parm)
        {
            AdminMenu model = new AdminMenu();
            try
            {
                model = db.Queryable<AdminMenu>()
                    .Where(it => it.IsValid == true)
                    .WhereIF(!string.IsNullOrEmpty(parm.Name), it => it.MenuName.Equals(parm.Name))
                    .WhereIF(!string.IsNullOrEmpty(parm.Code), it => it.MenuCode == parm.Code)
                    .First();
            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return model;
        }

        /// <summary>
        /// 获取菜单列表
        /// </summary>
        /// <param name="parm"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public List<AdminMenu> GetMenuList(BaseParm parm, ref int page)
        {
            List<AdminMenu> list = new List<AdminMenu>();
            try
            {
                list = db.Queryable<AdminMenu>()
                    .Where(it => it.IsValid == true)
                    .WhereIF(!string.IsNullOrEmpty(parm.Code), it => it.MenuCode.Equals(parm.Code))
                    .WhereIF(!string.IsNullOrEmpty(parm.Name), it => it.MenuName.Contains(parm.Name))
                    .ToPageList(parm.PageIndex, parm.PageSize, ref page);
            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return list;
        }

        /// <summary>
        /// 添加管理-菜单
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool AddMenu(AdminMenu model)
        {
            bool result = false;
            try
            {
                model.CreateTime = DateTime.Now;
                model.UpdateTime = DateTime.Now;
                model.IsValid = true;

                int row = db.Insertable(model).ExecuteCommand();

                if (row > 0)
                {
                    result = true;
                }
            }
            catch (Exception ex)
            {
                //Log4NetHelper.WriteLog(ex.Message);
                Logging.Error(ex, "添加菜单");
            }
            return result;
        }

        /// <summary>
        /// 编辑管理-菜单
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateMenu(AdminMenu model)
        {

            bool result = false;
            try
            {
                var row = db.Updateable(model).IgnoreColumns(it => new { it.Id, it.CreateTime, it.IsValid })
                     .Where(it => it.Id == model.Id)
                     .ExecuteCommand();

                if (row > 0)
                {
                    result = true;
                }

            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return result;
        }

        /// <summary>
        /// 删除管理-菜单
        /// </summary>
        /// <param name="parm"></param>
        /// <returns></returns>
        public bool DeleteMenu(BaseParm parm)
        {
            bool result = false;
            try
            {
                int row = db.Updateable<AdminMenu>()
                    .SetColumns(it => new AdminMenu { UpdateTime = DateTime.Now, IsValid = false })
                    .Where(it => it.Id == parm.Id)
                    .ExecuteCommand();

                if (row > 0)
                {
                    result = true;
                }

            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return result;
        }

        /// <summary>
        /// 获取菜单权限列表
        /// </summary>
        /// <returns></returns>
        public List<MenuDetail> GetPowerMenuList()
        {
            List<MenuDetail> allMenuList = new List<MenuDetail>();
            try
            {
                List<AdminMenu> menuList = db.Queryable<AdminMenu>()
                      .Where(it => it.IsValid == true)
                      .ToList();
                allMenuList = MenuDetail.FromAdminMenu(menuList);
            }
            catch (Exception ex)
            {

                Logging.Error(ex, "GetPowerMenuList");
            }
            return allMenuList;
        }

        #endregion

        #region 角色菜单管理

        /// <summary>
        /// 获取角色菜单列表
        /// </summary>
        /// <param name="parm"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public List<AdminRoleMenu> GetRoleMenuList(BaseParm parm)
        {
            List<AdminRoleMenu> list = new List<AdminRoleMenu>();
            try
            {
                list = db.Queryable<AdminRoleMenu>()
                    .Where(it => it.IsValid == true)
                    .WhereIF(parm.Id > 0, it => it.RoleId == parm.Id)
                    .WhereIF(!string.IsNullOrEmpty(parm.Code), it => it.RoleCode.Equals(parm.Code))
                    .WhereIF(!string.IsNullOrEmpty(parm.Param1), it => it.MenuCode.Contains(parm.Name))
                    .ToList();
            }
            catch (Exception ex)
            {
                Logging.Error(ex, "GetRoleMenuList");
            }
            return list;
        }

        /// <summary>
        /// 后台管理-编辑角色菜单权限
        /// </summary>
        /// <param name="parm"></param>
        /// <param name="list"></param>
        /// <returns></returns>
        public bool UpdateRoleMenu(BaseParm parm, List<AdminRoleMenu> list)
        {
            bool result = false;
            try
            {
                //根据角色id删除当前角色的所有权限
                int delrow = db.Deleteable<AdminRoleMenu>().Where(it => it.RoleId == parm.Id).ExecuteCommand();
                if (list.Count > 0)
                {
                    int row = db.Insertable(list).ExecuteCommand();
                }
                result = true;
            }
            catch (Exception ex)
            {
                Logging.Error(ex, "UpdateRoleMenu");
            }
            return result;
        }

        #endregion

        #region 用户角色管理

        /// <summary>
        /// 获取用户角色列表
        /// </summary>
        /// <param name="parm"></param>
        /// <param name="page"></param>
        /// <returns></returns>
        public List<AdminUserRole> GetUserRoleList(BaseParm parm)
        {
            List<AdminUserRole> list = new List<AdminUserRole>();
            try
            {
                list = db.Queryable<AdminUserRole>()
                    .Where(it => it.IsValid == true)
                    .WhereIF(parm.Id > 0, it => it.UserId == parm.Id)
                    .ToList();
            }
            catch (Exception ex)
            {
                Logging.Error(ex, "GetRoleMenuList");
            }
            return list;
        }

        /// <summary>
        /// 后台管理-编辑用户角色
        /// </summary>
        /// <param name="parm"></param>
        /// <param name="list"></param>
        /// <returns></returns>
        public bool UpdateUserRole(BaseParm parm, List<AdminUserRole> list)
        {
            bool result = false;
            try
            {
                //根据角色id删除当前角色的所有权限
                int delrow = db.Deleteable<AdminUserRole>().Where(it => it.UserId == parm.Id).ExecuteCommand();
                if (list.Count > 0)
                {
                    int row = db.Insertable(list).ExecuteCommand();
                }
                result = true;
            }
            catch (Exception ex)
            {
                Logging.Error(ex, "UpdateRoleMenu");
            }
            return result;
        }



        #endregion

    }
}