IotCloudPlatform/IoTIntegrationPlatform/IoTIntegrationPlatform.Services/AdminUserService.cs

using System;
using System.Collections.Generic;
using System.Linq;
using IoTIntegrationPlatform.Common;
using IoTIntegrationPlatform.Interface;
using IoTIntegrationPlatform.Model.common;
using IoTIntegrationPlatform.Model.Model;
using SqlSugar;

namespace IoTIntegrationPlatform.Services
{
    public class AdminUserService : IAdminUserService
    {
        private ISqlSugarClient db { get; }
        public AdminUserService(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;
        }
        ~AdminUserService()
        {
            Dispose(false);
        }

        #endregion

        /// <summary>
        /// 获取管理人员信息
        /// </summary>
        /// <param name="uuid"></param>
        /// <param name="account"></param>
        /// <param name="passWord"></param>
        /// <param name="mobile"></param>
        /// <returns></returns>
        public AdminUser GetAdminUserInfo(string uuid, string account, string passWord, string mobile)
        {
            AdminUser model = new AdminUser();
            try
            {
                model = db.Queryable<AdminUser>()
                    .Where(it => it.IsValid == true)
                    .WhereIF(!string.IsNullOrEmpty(account), it => it.Account == account)
                    .WhereIF(!string.IsNullOrEmpty(passWord), it => it.Password == passWord)
                    .WhereIF(!string.IsNullOrEmpty(mobile), it => it.Mobile == mobile)
                    .First();
            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return model;
        }



        /// <summary>
        /// 获取用户列表
        /// </summary>
        /// <param name="parm"></param>
        /// <param name="totalPage"></param>
        /// <returns></returns>
        public List<AdminUser> GetUserList(BaseParm parm, ref int totalPage)
        {
            List<AdminUser> list = new List<AdminUser>();
            try
            {
                list = db.CopyNew().Queryable<AdminUser>()
                    .Where(it => it.IsValid == true && it.IsSuper != true)//隐藏到超级管理员
                    .WhereIF(!string.IsNullOrEmpty(parm.Name), it => it.RealName.Contains(parm.Name) || it.Account.Contains(parm.Name))
                    .WhereIF(!string.IsNullOrEmpty(parm.Param), it => it.Mobile == parm.Param )
                    .ToPageList(parm.PageIndex, parm.PageSize, ref totalPage);
            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return list;
        }

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool Add(AdminUser model)
        {
            bool result = false;
            try
            {
                model.IsSuper = false;
                model.CreateTime = DateTime.Now;
                model.UpdateTime = DateTime.Now;
                model.IsValid = true;

                model.Id = db.Insertable(model).ExecuteReturnIdentity();
                if (model != null && model.Id > 0)
                {
                    result = true;
                }
            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return result;
        }



        /// <summary>
        /// 编辑管理员
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateUser(AdminUser model)
        {

            bool result = false;
            try
            {
                model.UpdateTime = DateTime.Now;
                int row = db.Updateable(model).ExecuteCommand();

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

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



        /// <summary>
        /// 修改密码
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdatePassWord(AdminUser model)
        {

            bool result = false;
            try
            {
                model.UpdateTime = DateTime.Now;
                int row = db.Updateable<AdminUser>()
                    .SetColumns(it => new AdminUser { UpdateTime = DateTime.Now, Password = model.Password,SecretKey=model.SecretKey })
                    .Where(it => it.Uuid == model.Uuid)
                    .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 DeleteUser(BaseParm parm)
        {
            bool result = false;
            try
            {
                int row = db.Updateable<AdminUser>()
                    .SetColumns(it => new AdminUser { UpdateTime = DateTime.Now, IsValid = true })
                    .Where(it => it.Id == parm.Id)
                    .ExecuteCommand();

                if (row > 0)
                {
                    result = true;
                }
            }
            catch (Exception ex)
            {
                Logging.Error(ex, ex.Message);
            }
            return result;
        }

        /// <summary>
        /// 获取用户菜单权限
        /// </summary>
        /// <param name="userid"></param>
        /// <returns></returns>
        public List<AdminMenu> GetUserMenus(int userid)
        {
            List<AdminMenu> list = new List<AdminMenu>();

            try
            {
                var query= db.Queryable<AdminMenu>()
                         .LeftJoin<AdminRoleMenu>((a, b) => a.IsValid == true && a.MenuCode == b.MenuCode)
                         .LeftJoin<AdminRole>((a, b, c) => b.IsValid == true && c.IsValid == true && b.RoleId == c.Id)
                         .LeftJoin<AdminUserRole>((a, b, c, d) => d.IsValid == true && c.Id== d.RoleId)
                         .Where((a,b,c,d) => d.UserId == userid)
                         .Select((a, b, c, d) => new AdminMenu { });
                list = query.ToList();
            }
            catch (Exception ex)
            {
                Logging.Error(ex, "GetUserMenus");
            }
            return list;    
        }



    }
}