using AutoMapper;
using Model.ModelDto.SysDto;
using System;
using System.Collections.Generic;
using System.Security.Cryptography;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading.Tasks;
using SqlSugar;
using WMS.DAL;
using WMS.Entity.Context;
using WMS.Entity.SysEntity;
using WMS.IBLL.ISysServer;
using WMS.IDAL.ISysInterface;

namespace WMS.BLL.SysServer
{
    public class FunSettingServer : DbHelper<SysFunSetting>, IFunSettingServer
    {
        private static readonly SqlSugarScope Db = DataContext.Db;

        /// <summary>
        /// 依赖注入
        /// </summary>
        private readonly IFunSettingRepository _setting;
        private readonly IMapper _mapper;
        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="setting">功能设定</param>
        /// <param name="mapper">automapper</param>
        public FunSettingServer(IFunSettingRepository setting, IMapper mapper) : base(Db)
        {
            _setting = setting;//功能设定
            _mapper = mapper;//automapper
        }


        /// <summary>
        /// 获取功能设定信息列表
        /// </summary>
        /// <param name="FunSetName">功能名称</param>
        /// <param name="IsEnable">开启状态</param>
        /// <param name="GroupNo">组号</param>
        /// <returns></returns>
        public List<FunSettingDto> GetFunSettingList(string FunSetName, string IsEnable, string GroupNo)
        {

            List<FunSettingDto> settinglist = _setting.GetFunSettingList(FunSetName, IsEnable, GroupNo);
            return settinglist;
        }

        /// <summary>
        /// 根据id查询功能设定信息
        /// </summary>
        /// <param name="id">功能id</param>
        /// <returns></returns>
        public SysFunSetting GetFunSettingById(int id)
        {
            SysFunSetting settinglist = _setting.GetFunSettingById(id);
            return settinglist;
        }

        /// <summary>
        /// 根据编号查询功能设定消息
        /// </summary>
        /// <param name="funSetNo">功能编号</param>
        /// <returns></returns>
        public SysFunSetting GetFunSettingByNo(string funSetNo)
        {
            try
            {
                var list = Db.Queryable<SysFunSetting>().First(a => a.IsDel == "0" && a.FunSetNo == funSetNo);
                return list;
            }
            catch (Exception ex)
            {

                throw ex;
            }
        }

        ///// <summary>
        ///// 根据编号查询功能设定信息
        ///// </summary>
        ///// <param name="FunSetNo">功能编号</param>
        ///// <returns></returns>
        //public int GetFunSettingByNo(string FunSetNo)
        //{
        //    List<SysFunSetting> funSettings = _setting.GetFunSettingByNo(FunSetNo);
        //    return funSettings.Count;
        //}

        /// <summary>
        /// 新增功能信息
        /// </summary>
        /// <param name="settingdto">功能设定dto</param>
        /// <returns></returns>
        /// <exception cref="Exception">捕获异常</exception>
        public async Task<int> AddFunSettings(FunSettingDto settingdto)
        {
            //捕获异常
            try
            {
                //映射模型
                SysFunSetting setting = _mapper.Map<SysFunSetting>(settingdto);
                //判断功能编号是否唯一
                var set = GetFunSettingByNo(setting.FunSetNo);
                int i = 0;
                if (set != null)
                {
                    i = 3;
                }
                else if (set == null)
                {
                    var setData = Db.Queryable<SysFunSetting>()
                        .First(m => m.IsDel == "0" && m.GroupNo == settingdto.GroupNo && m.SetValue==settingdto.SetValue);
                    if (setData!=null)
                    {
                        throw new Exception("同组内设定值重复");
                    }
                    //新增
                    i = await _setting.AddFunSettings(setting);
                }
                return i;
            }
            catch (Exception ex)
            {
                //抛出异常
                throw new Exception(ex.Message);
            }
        }

        /// <summary>
        /// 删除功能信息
        /// </summary>
        /// <param name="funSetting">功能设定实体模型</param>
        /// <returns></returns>
        /// <exception cref="Exception">捕获异常</exception>
        public async Task<int> DelFunSettings(SysFunSetting funSetting)
        {
            //捕获异常
            try
            {
                //删除
                int i = await _setting.DelFunSettings(funSetting);
                return i;
            }
            catch (Exception ex)
            {
                //抛出异常
                throw new Exception("删除功能异常", ex);
            }
        }

        /// <summary>
        /// 编辑功能信息
        /// </summary>
        /// <param name="setting">功能设定实体</param>
        /// <returns></returns>
        /// <exception cref="Exception">捕获异常</exception>
        public async Task<int> ExitFunSettings(FunSettingDto settingdto)
        {
            //捕获异常
            try
            {
                //映射模型
                SysFunSetting setting = _mapper.Map<SysFunSetting>(settingdto);

                var setData = Db.Queryable<SysFunSetting>()
                    .First(m => m.IsDel == "0" && m.GroupNo == settingdto.GroupNo && m.SetValue == settingdto.SetValue && m.Id!=settingdto.Id);
                if (setData != null)
                {
                    throw new Exception("同组内设定值重复");
                }
                //编辑
                int i = await _setting.ExitFunSettings(setting);
                return i;
            }
            catch (Exception ex)
            {
                //抛出异常
                throw new Exception(ex.Message);
            }
        }
    }
}