using Dm;
using Model.ModelDto.SysDto;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;
using WMS.Entity.Context;
using WMS.Entity.SysEntity;
using WMS.IDAL.ISysInterface;

namespace WMS.DAL.SysInfrastructure
{
    public class DictionaryRepository : BaseRepository<SysDictionary>, IDictionaryRepository
    {
        private static readonly SqlSugarScope Db = DataContext.Db;
        public DictionaryRepository() : base(Db)
        {
        }

        /// <summary>
        /// 获取字典信息列表
        /// </summary>
        /// <param name="DictName">字典名称</param>
        /// <param name="DictNo">父级字典号</param>
        /// <param name="Level">层级</param>
        /// <param name="IsEdit">允许编辑</param>
        /// <param name="IsAdd">允许新增</param>
        /// <returns></returns>
        public List<DictionaryDto> GetDicList(string DictName, string DictNo, string Level, string IsEdit, string IsAdd)
        {
            string str = "select dic.*,user1.RealName CreateName from SysDictionary dic left join SysUserInfor user1 on dic.CreateUser = user1.Id where dic.IsDel = @isdel";
            //判断层级
            if (Level == "1")
            {
                str += " and dic.Level = @level";
            }
            //判断允许编辑
            if (!string.IsNullOrEmpty(IsEdit))
            {
                str += " and dic.IsEdit = @isedit";
            }
            //判断允许新增
            if (!string.IsNullOrEmpty(IsAdd))
            {
                str += " and dic.IsAdd = @isadd";
            }
            //判断字典名称是否为空
            if (!string.IsNullOrEmpty(DictName))
            {
                if (Level == "1")
                {
                    str += " and dic.ParentNo in (select DictNo from SysDictionary where DictName like @dictname)";
                }
                if (Level == "0")
                {
                    str += " and dic.DictName like @dictname";
                }
                if (string.IsNullOrEmpty(Level))
                {
                    str += " and dic.DictName like @dictname or dic.ParentNo in (select DictNo from SysDictionary where DictName like @dictname)";
                }
            }
            //判断父级字典号是否为空
            if (!string.IsNullOrEmpty(DictNo))
            {
                if (Level == "1")
                {
                    str += " and dic.ParentNo = @dictno";
                }
                if (Level == "0")
                {
                    str += " and dic.DictNo = @dictno";
                }
                if (string.IsNullOrEmpty(Level))
                {
                    str += " and dic.DictNo = @dictno or dic.ParentNo = @dictno";
                }
            }
            //判断层级
            if (Level == "0")
            {
                str += " and dic.Level = @level";
            }
            //排序(根据ord显示顺序)
            str += " and dic.IsPublic ='0'";
            List<DictionaryDto> diclist = Db.Ado.SqlQuery<DictionaryDto>(str, new
            {
                isdel = "0", //是否删除
                dictname = "%" + DictName + "%", //字典名称
                dictno = DictNo, //字典号
                level = Level, //层级
                isedit = IsEdit, //允许编辑
                isadd = IsAdd //允许新增
            });
            diclist = diclist.OrderBy(a => int.Parse(a.Ord)).ToList();
            return diclist;
        }

        /// <summary>
        /// 根据id获取字典信息
        /// </summary>
        /// <param name="id">字典id</param>
        /// <returns></returns>
        public SysDictionary GetDicById(int id)
        {
            string str = "select dic.*,user1.UserName CreateName from SysDictionary dic left join SysUserInfor user1 on dic.CreateUser = user1.Id where dic.IsDel = @isdel and dic.Id = @id";
            SysDictionary dic = Db.Ado.SqlQuery<SysDictionary>(str, new
            {
                isdel = "0", //是否删除
                id //id
            }).First();
            return dic;
        }

        /// <summary>
        /// 获取父级字典号(根据层级根目录)
        /// </summary>
        /// <returns></returns>
        public List<SysDictionary> GetDicParentListByLevel()
        {
            string str = "select Id,DictNo,DictName,ParentNo,Level from SysDictionary where Level = @level and IsDel = @isdel and IsAdd = @isadd";
            List<SysDictionary> diclist = Db.Ado.SqlQuery<SysDictionary>(str, new
            {
                level = "0", //层级
                isdel = "0", //是否删除
                isadd = "0" //允许添加
            });
            return diclist;
        }

        /// <summary>
        /// 根据编号查询字典信息
        /// </summary>
        /// <param name="DictNo">字典编号</param>
        /// <returns></returns>
        public List<SysDictionary> GetDicByNo(string DictNo)
        {
            string str = $"select * from SysDictionary where DictNo = @dictno";
            List<SysDictionary> diclist = Db.Ado.SqlQuery<SysDictionary>(str, new
            {
                dictno = DictNo //字典编号
            });
            return diclist;
        }

        /// <summary>
        /// 新增字典信息
        /// </summary>
        /// <param name="dic">数据字典实体模型</param>
        /// <returns></returns>
        public async Task<int> AddDic(SysDictionary dic)
        {
            //获取是否拥有相同字典名称
            if (!string.IsNullOrEmpty(dic.DictName))
            {
                var dicno = Db.Queryable<SysDictionary>().First(a => a.DictName == dic.DictName);
                if (dicno != null)
                {
                    throw new Exception("获取是否拥有相同字典名称");
                }
            }
            else
            {
                throw new Exception("字典名称为空，请核实！");
            }
            string str = "insert into SysDictionary values(@dictno, @dictname, @parentno, @ord, @level, @ispublic, @isedit, @isadd, @isdel, @createtime, @createuser, null, null)";
            //int i = await CudAsync(str, new
            int i = await Db.Ado.ExecuteCommandAsync(str, new
            {
                dictno = dic.DictNo, //字典编号
                dictname = dic.DictName, //字典名称
                parentno = dic.ParentNo, //父级字典号
                ord = dic.Ord, //显示顺序
                level = dic.Level, //层级
                ispublic = dic.IsPublic, //是否公开
                isedit = dic.IsEdit, //允许编辑
                isadd = dic.IsAdd, //允许添加
                isdel = "0", //是否删除
                createtime = Db.GetDate(), //创建时间
                createuser = dic.CreateUser //创建人
            });
            return i;
        }

        /// <summary>
        /// 删除字典信息
        /// </summary>
        /// <param name="dic">数据字典实体模型</param>
        /// <returns></returns>
        public async Task<int> DelDic(SysDictionary dic)
        {
            string str = $"update SysDictionary set IsDel = @isdel, UpdateTime = @updatetime, UpdateUser = @updateuser where id = @id";
            int i = await Db.Ado.ExecuteCommandAsync(str, new
            {
                isdel = "1", //是否删除
                updatetime = Db.GetDate(), //更改时间
                updateuser = dic.UpdateUser, //更改人
                id = dic.Id //id
            });
            return i;
        }

        /// <summary>
        /// 编辑字典信息
        /// </summary>
        /// <param name="dic">数据字典实体模型</param>
        /// <returns></returns>
        public async Task<int> ExitDic(SysDictionary dic)
        {
            //获取是否拥有相同字典名称
            if (!string.IsNullOrEmpty(dic.DictName))
            {
                var dicno = Db.Queryable<SysDictionary>().First(a => a.DictName == dic.DictName);
                if (dicno != null)
                {
                    throw new Exception("获取是否拥有相同字典名称");
                }
            }
            else
            {
                throw new Exception("字典名称为空，请核实！");
            }
            string str = "update SysDictionary set DictNo = @dictno, DictName = @dictname, ParentNo = @parentno, Ord = @ord, IsPublic = @ispublic, IsEdit = @isedit, IsAdd = @isadd, UpdateTime = @updatetime, UpdateUser = @updateuser where id = @id";
            int i = await Db.Ado.ExecuteCommandAsync(str, new
            {
                dictno = dic.DictNo, //字典编号
                dictname = dic.DictName, //字典名称
                parentno = dic.ParentNo, //父级字典号
                ord = dic.Ord, //显示顺序
                //level = dic.Level, //层级
                ispublic = dic.IsPublic, //是否公开
                isedit = dic.IsEdit, //允许编辑
                isadd = dic.IsAdd, //允许添加
                updatetime = Db.GetDate(), //更改时间
                updateuser = dic.UpdateUser, //更改人
                id = dic.Id //id
            });
            return i;
        }
    }

    internal class NewClass
    {
        public NewClass()
        {
        }

        public override bool Equals(object obj)
        {
            return obj is NewClass other;
        }

        public override int GetHashCode()
        {
            return 0;
        }
    }
}